FND_STANDARD: Standard APIs

This section describes utilities you can use to achieve standard functionality in your forms.

FND_STANDARD.FORM_INFO

Summary 
procedure  FND_STANDARD.FORM_INFO(
		version                  IN varchar2,
		title                    IN  varchar2,
		application_short_name   IN varchar2,
		date_last_modified       IN varchar2,
		last_modified_by         IN varchar2);
Description FND_STANDARD.FORM_INFO provides information about the form. Call it as the first step in your WHEN-NEW-FORM-INSTANCE trigger. The TEMPLATE form provides you with a skeleton call that you must modify.

See: Special Triggers in the TEMPLATE form

FND_STANDARD.SET_WHO

Summary 
procedure  FND_STANDARD.SET_WHO;
Description SET_WHO loads WHO fields with proper user information. Call in PRE-UPDATE, PRE-INSERT for each block with WHO fields. You do not need to call FND_GLOBAL if you use SET_WHO to populate your WHO fields.

See: Tracking Data Changes With Record History (WHO) and FND_GLOBAL:WHO Column Maintenance.

FND_STANDARD.SYSTEM_DATE

Summary 
function  FND_STANDARD.SYSTEM_DATE return date;
Description This function behaves exactly like the built-in SYSDATE, only cached for efficiency. You should use it in your Oracle Forms PL/SQL code in place of the built-in SYSDATE.

FND_STANDARD.USER

Summary 
function  FND_STANDARD.USER return varchar2;
Description This function behaves exactly like the built-in USER, only cached for efficiency. You should use it in your Oracle Forms PL/SQL code in place of the built-in USER.