1 package body PQP_ANALYZED_ALIEN_DET_BK1 as
2 /* $Header: pqdetapi.pkb 115.7 2003/01/22 00:54:43 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/01/03 22:54:23 (YYYY/MM/DD HH24:MI:SS)
5 procedure CREATE_ANALYZED_ALIEN_DET_A
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 )is
34 begin
35 hr_utility.set_location('Entering: PQP_ANALYZED_ALIEN_DET_BK1.CREATE_ANALYZED_ALIEN_DET_A', 10);
36 hr_utility.set_location(' Leaving: PQP_ANALYZED_ALIEN_DET_BK1.CREATE_ANALYZED_ALIEN_DET_A', 20);
37 end CREATE_ANALYZED_ALIEN_DET_A;
38 procedure CREATE_ANALYZED_ALIEN_DET_B
39 (P_ANALYZED_DATA_ID in NUMBER
40 ,P_INCOME_CODE in VARCHAR2
41 ,P_WITHHOLDING_RATE in NUMBER
42 ,P_INCOME_CODE_SUB_TYPE in VARCHAR2
43 ,P_EXEMPTION_CODE in VARCHAR2
44 ,P_MAXIMUM_BENEFIT_AMOUNT in NUMBER
45 ,P_RETRO_LOSE_BEN_AMT_FLAG in VARCHAR2
46 ,P_DATE_BENEFIT_ENDS in DATE
47 ,P_RETRO_LOSE_BEN_DATE_FLAG in VARCHAR2
48 ,P_NRA_EXEMPT_FROM_SS in VARCHAR2
49 ,P_NRA_EXEMPT_FROM_MEDICARE in VARCHAR2
50 ,P_STUDENT_EXEMPT_FROM_SS in VARCHAR2
51 ,P_STUDENT_EXEMPT_FROM_MEDI in VARCHAR2
52 ,P_ADDL_WITHHOLDING_FLAG in VARCHAR2
53 ,P_CONSTANT_ADDL_TAX in NUMBER
54 ,P_ADDL_WITHHOLDING_AMT in NUMBER
55 ,P_ADDL_WTHLDNG_AMT_PERIOD_TYPE in VARCHAR2
56 ,P_PERSONAL_EXEMPTION in NUMBER
57 ,P_ADDL_EXEMPTION_ALLOWED in NUMBER
58 ,P_TREATY_BEN_ALLOWED_FLAG in VARCHAR2
59 ,P_TREATY_BENEFITS_START_DATE in DATE
60 ,P_EFFECTIVE_DATE in DATE
61 ,P_RETRO_LOSS_NOTIFICATION_SENT in VARCHAR2
62 ,P_CURRENT_ANALYSIS in VARCHAR2
63 ,P_FORECAST_INCOME_CODE in VARCHAR2
64 )is
65 begin
66 hr_utility.set_location('Entering: PQP_ANALYZED_ALIEN_DET_BK1.CREATE_ANALYZED_ALIEN_DET_B', 10);
67 hr_utility.set_location(' Leaving: PQP_ANALYZED_ALIEN_DET_BK1.CREATE_ANALYZED_ALIEN_DET_B', 20);
68 end CREATE_ANALYZED_ALIEN_DET_B;
69 end PQP_ANALYZED_ALIEN_DET_BK1;
[Home] [Help]