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

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

Line: 5


procedure AFTER_INSERT
(P_ACCRUAL_PLAN_ID in NUMBER
,P_BUSINESS_GROUP_ID in NUMBER
,P_ACCRUAL_PLAN_ELEMENT_TYPE_ID in NUMBER
,P_PTO_INPUT_VALUE_ID in NUMBER
,P_CO_INPUT_VALUE_ID in NUMBER
,P_RESIDUAL_INPUT_VALUE_ID in NUMBER
,P_ACCRUAL_CATEGORY in VARCHAR2
,P_ACCRUAL_PLAN_NAME in VARCHAR2
,P_ACCRUAL_START in VARCHAR2
,P_ACCRUAL_UNITS_OF_MEASURE in VARCHAR2
,P_INELIGIBLE_PERIOD_LENGTH in NUMBER
,P_INELIGIBLE_PERIOD_TYPE in VARCHAR2
,P_ACCRUAL_FORMULA_ID in NUMBER
,P_CO_FORMULA_ID in NUMBER
,P_CO_DATE_INPUT_VALUE_ID in NUMBER
,P_CO_EXP_DATE_INPUT_VALUE_ID in NUMBER
,P_RESIDUAL_DATE_INPUT_VALUE_ID in NUMBER
,P_DESCRIPTION in VARCHAR2
,P_INELIGIBILITY_FORMULA_ID in NUMBER
,P_PAYROLL_FORMULA_ID in NUMBER
,P_DEFINED_BALANCE_ID in NUMBER
,P_TAGGING_ELEMENT_TYPE_ID in NUMBER
,P_BALANCE_ELEMENT_TYPE_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_INFORMATION_CATEGORY in VARCHAR2
,P_INFORMATION1 in VARCHAR2
,P_INFORMATION2 in VARCHAR2
,P_INFORMATION3 in VARCHAR2
,P_INFORMATION4 in VARCHAR2
,P_INFORMATION5 in VARCHAR2
,P_INFORMATION6 in VARCHAR2
,P_INFORMATION7 in VARCHAR2
,P_INFORMATION8 in VARCHAR2
,P_INFORMATION9 in VARCHAR2
,P_INFORMATION10 in VARCHAR2
,P_INFORMATION11 in VARCHAR2
,P_INFORMATION12 in VARCHAR2
,P_INFORMATION13 in VARCHAR2
,P_INFORMATION14 in VARCHAR2
,P_INFORMATION15 in VARCHAR2
,P_INFORMATION16 in VARCHAR2
,P_INFORMATION17 in VARCHAR2
,P_INFORMATION18 in VARCHAR2
,P_INFORMATION19 in VARCHAR2
,P_INFORMATION20 in VARCHAR2
,P_INFORMATION21 in VARCHAR2
,P_INFORMATION22 in VARCHAR2
,P_INFORMATION23 in VARCHAR2
,P_INFORMATION24 in VARCHAR2
,P_INFORMATION25 in VARCHAR2
,P_INFORMATION26 in VARCHAR2
,P_INFORMATION27 in VARCHAR2
,P_INFORMATION28 in VARCHAR2
,P_INFORMATION29 in VARCHAR2
,P_INFORMATION30 in VARCHAR2
)is
begin
hr_utility.set_location('Entering: PAY_PAP_RKI.AFTER_INSERT', 10);

Line: 64


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

Line: 65


end AFTER_INSERT;