eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_APT_RKI SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5


procedure AFTER_INSERT
(P_EFFECTIVE_DATE in DATE
,P_APPROVER_TYPE_ID in NUMBER
,P_ORIG_SYSTEM in VARCHAR2
,P_QUERY_VARIABLE_1_LABEL in VARCHAR2
,P_QUERY_VARIABLE_2_LABEL in VARCHAR2
,P_QUERY_VARIABLE_3_LABEL in VARCHAR2
,P_QUERY_VARIABLE_4_LABEL in VARCHAR2
,P_QUERY_VARIABLE_5_LABEL in VARCHAR2
,P_VARIABLE_1_LOV_QUERY in VARCHAR2
,P_VARIABLE_2_LOV_QUERY in VARCHAR2
,P_VARIABLE_3_LOV_QUERY in VARCHAR2
,P_VARIABLE_4_LOV_QUERY in VARCHAR2
,P_VARIABLE_5_LOV_QUERY in VARCHAR2
,P_QUERY_PROCEDURE in VARCHAR2
,P_START_DATE in DATE
,P_END_DATE in DATE
,P_OBJECT_VERSION_NUMBER in NUMBER
)is
begin
hr_utility.set_location('Entering: ame_apt_RKI.AFTER_INSERT', 10);

Line: 26


hr_utility.set_location(' Leaving: ame_apt_RKI.AFTER_INSERT', 20);

Line: 27


end AFTER_INSERT;