Wednesday, August 7, 2019

How to call WHO columns into the forms

By using FND_STANDARD API’S

1. FND_STANDARD.FORM_INFO

Provides information about the form.
Should be called form when_newform _ instance   trigger.

2. FND_STANDARD.SET_WHO

loads WHO columns with proper user information.
Should be called from PRE_UPDTE and PRE_INSERT
Triggers for each block with WHO fields
If this is used FND-GLOBAL need not be called.
(FND_GLOBAL.WHO)

3. FND_STANDARD.SYSTEM_DATE

This is a function which returns date.
Behave exactly like SYSDATE built-in.

4. FNID_STANDARD.USER

This is a function which returns varchar2
Behaves exactly like built in USER.

No comments:

Post a Comment

AME (Approval Management Engine)

AME (Approval Management Engine) : AME Stands for Oracle Approval Management Engine. AME is a self service web application that enables...