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.BEN_BLI_RKI SQL Statements

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

Line: 5


procedure AFTER_INSERT
(P_BATCH_LER_ID in NUMBER
,P_BENEFIT_ACTION_ID in NUMBER
,P_PERSON_ID in NUMBER
,P_LER_ID in NUMBER
,P_LF_EVT_OCRD_DT in DATE
,P_REPLCD_FLAG in VARCHAR2
,P_CRTD_FLAG in VARCHAR2
,P_TMPRL_FLAG in VARCHAR2
,P_DLTD_FLAG in VARCHAR2
,P_OPEN_AND_CLSD_FLAG in VARCHAR2
,P_CLSD_FLAG in VARCHAR2
,P_NOT_CRTD_FLAG in VARCHAR2
,P_STL_ACTV_FLAG in VARCHAR2
,P_CLPSD_FLAG in VARCHAR2
,P_CLSN_FLAG in VARCHAR2
,P_NO_EFFECT_FLAG in VARCHAR2
,P_CVRGE_RT_PREM_FLAG in VARCHAR2
,P_PER_IN_LER_ID in NUMBER
,P_BUSINESS_GROUP_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_EFFECTIVE_DATE in DATE
)is
begin
hr_utility.set_location('Entering: ben_bli_RKI.AFTER_INSERT', 10);

Line: 30


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

Line: 31


end AFTER_INSERT;