APPS.PQH_STS_RKD SQL Statements

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

Line: 5

procedure AFTER_DELETE
(P_STATUTORY_SITUATION_ID in NUMBER
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_SITUATION_NAME_O in VARCHAR2
,P_TYPE_OF_PS_O in VARCHAR2
,P_SITUATION_TYPE_O in VARCHAR2
,P_SUB_TYPE_O in VARCHAR2
,P_SOURCE_O in VARCHAR2
,P_LOCATION_O in VARCHAR2
,P_REASON_O in VARCHAR2
,P_IS_DEFAULT_O in VARCHAR2
,P_DATE_FROM_O in DATE
,P_DATE_TO_O in DATE
,P_REQUEST_TYPE_O in VARCHAR2
,P_EMPLOYEE_AGREEMENT_NEEDED_O in VARCHAR2
,P_MANAGER_AGREEMENT_NEEDED_O in VARCHAR2
,P_PRINT_ARRETTE_O in VARCHAR2
,P_RESERVE_POSITION_O in VARCHAR2
,P_ALLOW_PROGRESSIONS_O in VARCHAR2
,P_EXTEND_PROBATION_PERIOD_O in VARCHAR2
,P_REMUNERATION_PAID_O in VARCHAR2
,P_PAY_SHARE_O in NUMBER
,P_PAY_PERIODS_O in NUMBER
,P_FREQUENCY_O in VARCHAR2
,P_FIRST_PERIOD_MAX_DURATION_O in NUMBER
,P_MIN_DURATION_PER_REQUEST_O in NUMBER
,P_MAX_DURATION_PER_REQUEST_O in NUMBER
,P_MAX_DURATION_WHOLE_CAREER_O in NUMBER
,P_RENEWABLE_ALLOWED_O in VARCHAR2
,P_MAX_NO_OF_RENEWALS_O in NUMBER
,P_MAX_DURATION_PER_RENEWAL_O in NUMBER
,P_MAX_TOT_CONTINUOUS_DURATIO_O in NUMBER
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_REMUNERATE_ASSIGN_STAT_ID_O in NUMBER
)is
begin
hr_utility.set_location('Entering: PQH_STS_RKD.AFTER_DELETE', 10);

Line: 42

hr_utility.set_location(' Leaving: PQH_STS_RKD.AFTER_DELETE', 20);

Line: 43

end AFTER_DELETE;