1 package body PQP_DET_RKU as
2 /* $Header: pqdetrhi.pkb 115.8 2003/02/17 22:14:03 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:47:25 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_UPDATE
6 (P_ANALYZED_DATA_DETAILS_ID in NUMBER
7 ,P_ANALYZED_DATA_ID in NUMBER
8 ,P_INCOME_CODE in VARCHAR2
9 ,P_WITHHOLDING_RATE in NUMBER
10 ,P_INCOME_CODE_SUB_TYPE in VARCHAR2
11 ,P_EXEMPTION_CODE in VARCHAR2
12 ,P_MAXIMUM_BENEFIT_AMOUNT in NUMBER
13 ,P_RETRO_LOSE_BEN_AMT_FLAG in VARCHAR2
14 ,P_DATE_BENEFIT_ENDS in DATE
15 ,P_RETRO_LOSE_BEN_DATE_FLAG in VARCHAR2
16 ,P_NRA_EXEMPT_FROM_SS in VARCHAR2
17 ,P_NRA_EXEMPT_FROM_MEDICARE in VARCHAR2
18 ,P_STUDENT_EXEMPT_FROM_SS in VARCHAR2
19 ,P_STUDENT_EXEMPT_FROM_MEDI in VARCHAR2
20 ,P_ADDL_WITHHOLDING_FLAG in VARCHAR2
21 ,P_CONSTANT_ADDL_TAX in NUMBER
22 ,P_ADDL_WITHHOLDING_AMT in NUMBER
23 ,P_ADDL_WTHLDNG_AMT_PERIOD_TYPE in VARCHAR2
24 ,P_PERSONAL_EXEMPTION in NUMBER
25 ,P_ADDL_EXEMPTION_ALLOWED in NUMBER
26 ,P_TREATY_BEN_ALLOWED_FLAG in VARCHAR2
27 ,P_TREATY_BENEFITS_START_DATE in DATE
28 ,P_OBJECT_VERSION_NUMBER in NUMBER
29 ,P_EFFECTIVE_DATE in DATE
30 ,P_RETRO_LOSS_NOTIFICATION_SENT in VARCHAR2
31 ,P_CURRENT_ANALYSIS in VARCHAR2
32 ,P_FORECAST_INCOME_CODE in VARCHAR2
33 ,P_ANALYZED_DATA_ID_O in NUMBER
34 ,P_INCOME_CODE_O in VARCHAR2
35 ,P_WITHHOLDING_RATE_O in NUMBER
36 ,P_INCOME_CODE_SUB_TYPE_O in VARCHAR2
37 ,P_EXEMPTION_CODE_O in VARCHAR2
38 ,P_MAXIMUM_BENEFIT_AMOUNT_O in NUMBER
39 ,P_RETRO_LOSE_BEN_AMT_FLAG_O in VARCHAR2
40 ,P_DATE_BENEFIT_ENDS_O in DATE
41 ,P_RETRO_LOSE_BEN_DATE_FLAG_O in VARCHAR2
42 ,P_NRA_EXEMPT_FROM_SS_O in VARCHAR2
43 ,P_NRA_EXEMPT_FROM_MEDICARE_O in VARCHAR2
44 ,P_STUDENT_EXEMPT_FROM_SS_O in VARCHAR2
45 ,P_STUDENT_EXEMPT_FROM_MEDI_O in VARCHAR2
46 ,P_ADDL_WITHHOLDING_FLAG_O in VARCHAR2
47 ,P_CONSTANT_ADDL_TAX_O in NUMBER
48 ,P_ADDL_WITHHOLDING_AMT_O in NUMBER
49 ,P_ADDL_WTHLDNG_AMT_PERIOD_TY_O in VARCHAR2
50 ,P_PERSONAL_EXEMPTION_O in NUMBER
51 ,P_ADDL_EXEMPTION_ALLOWED_O in NUMBER
52 ,P_TREATY_BEN_ALLOWED_FLAG_O in VARCHAR2
53 ,P_TREATY_BENEFITS_START_DATE_O in DATE
54 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
55 ,P_RETRO_LOSS_NOTIF_SENT_O in VARCHAR2
56 ,P_CURRENT_ANALYSIS_O in VARCHAR2
57 ,P_FORECAST_INCOME_CODE_O in VARCHAR2
58 )is
59 begin
60 hr_utility.set_location('Entering: PQP_DET_RKU.AFTER_UPDATE', 10);
61 hr_utility.set_location(' Leaving: PQP_DET_RKU.AFTER_UPDATE', 20);
62 end AFTER_UPDATE;
63 end PQP_DET_RKU;
[Home] [Help]