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_RKU SQL Statements

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

Line: 5


procedure AFTER_UPDATE
(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
,P_BENEFIT_ACTION_ID_O in NUMBER
,P_PERSON_ID_O in NUMBER
,P_LER_ID_O in NUMBER
,P_LF_EVT_OCRD_DT_O in DATE
,P_REPLCD_FLAG_O in VARCHAR2
,P_CRTD_FLAG_O in VARCHAR2
,P_TMPRL_FLAG_O in VARCHAR2
,P_DLTD_FLAG_O in VARCHAR2
,P_OPEN_AND_CLSD_FLAG_O in VARCHAR2
,P_CLSD_FLAG_O in VARCHAR2
,P_NOT_CRTD_FLAG_O in VARCHAR2
,P_STL_ACTV_FLAG_O in VARCHAR2
,P_CLPSD_FLAG_O in VARCHAR2
,P_CLSN_FLAG_O in VARCHAR2
,P_NO_EFFECT_FLAG_O in VARCHAR2
,P_CVRGE_RT_PREM_FLAG_O in VARCHAR2
,P_PER_IN_LER_ID_O in NUMBER
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_OBJECT_VERSION_NUMBER_O in NUMBER
)is
begin
hr_utility.set_location('Entering: ben_bli_RKU.AFTER_UPDATE', 10);

Line: 49


hr_utility.set_location(' Leaving: ben_bli_RKU.AFTER_UPDATE', 20);

Line: 50


end AFTER_UPDATE;