APPS.PQP_GDA_RKU SQL Statements

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

Line: 5

procedure AFTER_UPDATE
(P_EFFECTIVE_DATE in DATE
,P_GAP_DAILY_ABSENCE_ID in NUMBER
,P_GAP_ABSENCE_PLAN_ID in NUMBER
,P_ABSENCE_DATE in DATE
,P_WORK_PATTERN_DAY_TYPE in VARCHAR2
,P_LEVEL_OF_ENTITLEMENT in VARCHAR2
,P_LEVEL_OF_PAY in VARCHAR2
,P_DURATION in NUMBER
,P_DURATION_IN_HOURS in NUMBER
,P_WORKING_DAYS_PER_WEEK in NUMBER
,P_FTE in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_GAP_ABSENCE_PLAN_ID_O in NUMBER
,P_ABSENCE_DATE_O in DATE
,P_WORK_PATTERN_DAY_TYPE_O in VARCHAR2
,P_LEVEL_OF_ENTITLEMENT_O in VARCHAR2
,P_LEVEL_OF_PAY_O in VARCHAR2
,P_DURATION_O in NUMBER
,P_DURATION_IN_HOURS_O in NUMBER
,P_WORKING_DAYS_PER_WEEK_O in NUMBER
,P_FTE_O in NUMBER
,P_OBJECT_VERSION_NUMBER_O in NUMBER
)is
begin
hr_utility.set_location('Entering: PQP_GDA_RKU.AFTER_UPDATE', 10);

Line: 31

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

Line: 32

end AFTER_UPDATE;