APPS.PAY_ETP_RKD SQL Statements

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

Line: 5

procedure AFTER_DELETE
(P_EFFECTIVE_DATE in DATE
,P_DATETRACK_MODE in VARCHAR2
,P_VALIDATION_START_DATE in DATE
,P_VALIDATION_END_DATE in DATE
,P_ELEMENT_TYPE_ID in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_EFFECTIVE_START_DATE_O in DATE
,P_EFFECTIVE_END_DATE_O in DATE
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_LEGISLATION_CODE_O in VARCHAR2
,P_FORMULA_ID_O in NUMBER
,P_INPUT_CURRENCY_CODE_O in VARCHAR2
,P_OUTPUT_CURRENCY_CODE_O in VARCHAR2
,P_CLASSIFICATION_ID_O in NUMBER
,P_BENEFIT_CLASSIFICATION_ID_O in NUMBER
,P_ADDITIONAL_ENTRY_ALLOWED_F_O in VARCHAR2
,P_ADJUSTMENT_ONLY_FLAG_O in VARCHAR2
,P_CLOSED_FOR_ENTRY_FLAG_O in VARCHAR2
,P_ELEMENT_NAME_O in VARCHAR2
,P_INDIRECT_ONLY_FLAG_O in VARCHAR2
,P_MULTIPLE_ENTRIES_ALLOWED_F_O in VARCHAR2
,P_MULTIPLY_VALUE_FLAG_O in VARCHAR2
,P_POST_TERMINATION_RULE_O in VARCHAR2
,P_PROCESS_IN_RUN_FLAG_O in VARCHAR2
,P_PROCESSING_PRIORITY_O in NUMBER
,P_PROCESSING_TYPE_O in VARCHAR2
,P_STANDARD_LINK_FLAG_O in VARCHAR2
,P_COMMENT_ID_O in NUMBER
,P_COMMENTS_O in VARCHAR2
,P_DESCRIPTION_O in VARCHAR2
,P_LEGISLATION_SUBGROUP_O in VARCHAR2
,P_QUALIFYING_AGE_O in NUMBER
,P_QUALIFYING_LENGTH_OF_SERVI_O in NUMBER
,P_QUALIFYING_UNITS_O in VARCHAR2
,P_REPORTING_NAME_O in VARCHAR2
,P_ATTRIBUTE_CATEGORY_O in VARCHAR2
,P_ATTRIBUTE1_O in VARCHAR2
,P_ATTRIBUTE2_O in VARCHAR2
,P_ATTRIBUTE3_O in VARCHAR2
,P_ATTRIBUTE4_O in VARCHAR2
,P_ATTRIBUTE5_O in VARCHAR2
,P_ATTRIBUTE6_O in VARCHAR2
,P_ATTRIBUTE7_O in VARCHAR2
,P_ATTRIBUTE8_O in VARCHAR2
,P_ATTRIBUTE9_O in VARCHAR2
,P_ATTRIBUTE10_O in VARCHAR2
,P_ATTRIBUTE11_O in VARCHAR2
,P_ATTRIBUTE12_O in VARCHAR2
,P_ATTRIBUTE13_O in VARCHAR2
,P_ATTRIBUTE14_O in VARCHAR2
,P_ATTRIBUTE15_O in VARCHAR2
,P_ATTRIBUTE16_O in VARCHAR2
,P_ATTRIBUTE17_O in VARCHAR2
,P_ATTRIBUTE18_O in VARCHAR2
,P_ATTRIBUTE19_O in VARCHAR2
,P_ATTRIBUTE20_O in VARCHAR2
,P_ELEMENT_INFORMATION_CATEGO_O in VARCHAR2
,P_ELEMENT_INFORMATION1_O in VARCHAR2
,P_ELEMENT_INFORMATION2_O in VARCHAR2
,P_ELEMENT_INFORMATION3_O in VARCHAR2
,P_ELEMENT_INFORMATION4_O in VARCHAR2
,P_ELEMENT_INFORMATION5_O in VARCHAR2
,P_ELEMENT_INFORMATION6_O in VARCHAR2
,P_ELEMENT_INFORMATION7_O in VARCHAR2
,P_ELEMENT_INFORMATION8_O in VARCHAR2
,P_ELEMENT_INFORMATION9_O in VARCHAR2
,P_ELEMENT_INFORMATION10_O in VARCHAR2
,P_ELEMENT_INFORMATION11_O in VARCHAR2
,P_ELEMENT_INFORMATION12_O in VARCHAR2
,P_ELEMENT_INFORMATION13_O in VARCHAR2
,P_ELEMENT_INFORMATION14_O in VARCHAR2
,P_ELEMENT_INFORMATION15_O in VARCHAR2
,P_ELEMENT_INFORMATION16_O in VARCHAR2
,P_ELEMENT_INFORMATION17_O in VARCHAR2
,P_ELEMENT_INFORMATION18_O in VARCHAR2
,P_ELEMENT_INFORMATION19_O in VARCHAR2
,P_ELEMENT_INFORMATION20_O in VARCHAR2
,P_THIRD_PARTY_PAY_ONLY_FLAG_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_ITERATIVE_FLAG_O in VARCHAR2
,P_ITERATIVE_FORMULA_ID_O in NUMBER
,P_ITERATIVE_PRIORITY_O in NUMBER
,P_CREATOR_TYPE_O in VARCHAR2
,P_RETRO_SUMM_ELE_ID_O in NUMBER
,P_GROSSUP_FLAG_O in VARCHAR2
,P_PROCESS_MODE_O in VARCHAR2
,P_ADVANCE_INDICATOR_O in VARCHAR2
,P_ADVANCE_PAYABLE_O in VARCHAR2
,P_ADVANCE_DEDUCTION_O in VARCHAR2
,P_PROCESS_ADVANCE_ENTRY_O in VARCHAR2
,P_PRORATION_GROUP_ID_O in NUMBER
,P_PRORATION_FORMULA_ID_O in NUMBER
,P_RECALC_EVENT_GROUP_ID_O in NUMBER
,P_ONCE_EACH_PERIOD_FLAG_O in VARCHAR2
,P_TIME_DEFINITION_TYPE_O in VARCHAR2
,P_TIME_DEFINITION_ID_O in NUMBER
,P_ADVANCE_ELEMENT_TYPE_ID_O in NUMBER
,P_DEDUCTION_ELEMENT_TYPE_ID_O in NUMBER
)is
begin
hr_utility.set_location('Entering: PAY_ETP_RKD.AFTER_DELETE', 10);

Line: 108

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

Line: 109

end AFTER_DELETE;