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.
PACKAGE BODY: APPS.PQP_AAT_RKI

Source


1 package body PQP_AAT_RKI as
2 /* $Header: pqaatrhi.pkb 120.2.12010000.3 2009/07/01 10:58:37 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2012/11/27 04:05:05 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_INSERT
6 (P_EFFECTIVE_DATE in DATE
7 ,P_VALIDATION_START_DATE in DATE
8 ,P_VALIDATION_END_DATE in DATE
9 ,P_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
10 ,P_EFFECTIVE_START_DATE in DATE
11 ,P_EFFECTIVE_END_DATE in DATE
12 ,P_BUSINESS_GROUP_ID in NUMBER
13 ,P_ASSIGNMENT_ID in NUMBER
14 ,P_CONTRACT_TYPE in VARCHAR2
15 ,P_WORK_PATTERN in VARCHAR2
16 ,P_START_DAY in VARCHAR2
17 ,P_OBJECT_VERSION_NUMBER in NUMBER
18 ,P_PRIMARY_COMPANY_CAR in NUMBER
19 ,P_PRIMARY_CAR_FUEL_BENEFIT in VARCHAR2
20 ,P_PRIMARY_CLASS_1A in VARCHAR2
21 ,P_PRIMARY_CAPITAL_CONTRIBUTION in NUMBER
22 ,P_PRIMARY_PRIVATE_CONTRIBUTION in NUMBER
23 ,P_SECONDARY_COMPANY_CAR in NUMBER
24 ,P_SECONDARY_CAR_FUEL_BENEFIT in VARCHAR2
25 ,P_SECONDARY_CLASS_1A in VARCHAR2
26 ,P_SECONDARY_CAPITAL_CONTRIBUTI in NUMBER
27 ,P_SECONDARY_PRIVATE_CONTRIBUTI in NUMBER
28 ,P_COMPANY_CAR_CALC_METHOD in VARCHAR2
29 ,P_COMPANY_CAR_RATES_TABLE_ID in NUMBER
30 ,P_COMPANY_CAR_SECONDARY_TABLE in NUMBER
31 ,P_PRIVATE_CAR in NUMBER
32 ,P_PRIVATE_CAR_CALC_METHOD in VARCHAR2
33 ,P_PRIVATE_CAR_RATES_TABLE_ID in NUMBER
34 ,P_PRIVATE_CAR_ESSENTIAL_TABLE in NUMBER
35 ,P_TP_IS_TEACHER in VARCHAR2
36 ,P_TP_HEADTEACHER_GRP_CODE in NUMBER
37 ,P_TP_SAFEGUARDED_GRADE in VARCHAR2
38 ,P_TP_SAFEGUARDED_GRADE_ID in NUMBER
39 ,P_TP_SAFEGUARDED_RATE_TYPE in VARCHAR2
40 ,P_TP_SAFEGUARDED_RATE_ID in NUMBER
41 ,P_TP_SPINAL_POINT_ID in NUMBER
42 ,P_TP_ELECTED_PENSION in VARCHAR2
43 ,P_TP_FAST_TRACK in VARCHAR2
44 ,P_AAT_ATTRIBUTE_CATEGORY in VARCHAR2
45 ,P_AAT_ATTRIBUTE1 in VARCHAR2
46 ,P_AAT_ATTRIBUTE2 in VARCHAR2
47 ,P_AAT_ATTRIBUTE3 in VARCHAR2
48 ,P_AAT_ATTRIBUTE4 in VARCHAR2
49 ,P_AAT_ATTRIBUTE5 in VARCHAR2
50 ,P_AAT_ATTRIBUTE6 in VARCHAR2
51 ,P_AAT_ATTRIBUTE7 in VARCHAR2
52 ,P_AAT_ATTRIBUTE8 in VARCHAR2
53 ,P_AAT_ATTRIBUTE9 in VARCHAR2
54 ,P_AAT_ATTRIBUTE10 in VARCHAR2
55 ,P_AAT_ATTRIBUTE11 in VARCHAR2
56 ,P_AAT_ATTRIBUTE12 in VARCHAR2
57 ,P_AAT_ATTRIBUTE13 in VARCHAR2
58 ,P_AAT_ATTRIBUTE14 in VARCHAR2
59 ,P_AAT_ATTRIBUTE15 in VARCHAR2
60 ,P_AAT_ATTRIBUTE16 in VARCHAR2
61 ,P_AAT_ATTRIBUTE17 in VARCHAR2
62 ,P_AAT_ATTRIBUTE18 in VARCHAR2
63 ,P_AAT_ATTRIBUTE19 in VARCHAR2
64 ,P_AAT_ATTRIBUTE20 in VARCHAR2
65 ,P_AAT_INFORMATION_CATEGORY in VARCHAR2
66 ,P_AAT_INFORMATION1 in VARCHAR2
67 ,P_AAT_INFORMATION2 in VARCHAR2
68 ,P_AAT_INFORMATION3 in VARCHAR2
69 ,P_AAT_INFORMATION4 in VARCHAR2
70 ,P_AAT_INFORMATION5 in VARCHAR2
71 ,P_AAT_INFORMATION6 in VARCHAR2
72 ,P_AAT_INFORMATION7 in VARCHAR2
73 ,P_AAT_INFORMATION8 in VARCHAR2
74 ,P_AAT_INFORMATION9 in VARCHAR2
75 ,P_AAT_INFORMATION10 in VARCHAR2
76 ,P_AAT_INFORMATION11 in VARCHAR2
77 ,P_AAT_INFORMATION12 in VARCHAR2
78 ,P_AAT_INFORMATION13 in VARCHAR2
79 ,P_AAT_INFORMATION14 in VARCHAR2
80 ,P_AAT_INFORMATION15 in VARCHAR2
81 ,P_AAT_INFORMATION16 in VARCHAR2
82 ,P_AAT_INFORMATION17 in VARCHAR2
83 ,P_AAT_INFORMATION18 in VARCHAR2
84 ,P_AAT_INFORMATION19 in VARCHAR2
85 ,P_AAT_INFORMATION20 in VARCHAR2
86 ,P_LGPS_PROCESS_FLAG in VARCHAR2
87 ,P_LGPS_EXCLUSION_TYPE in VARCHAR2
88 ,P_LGPS_PENSIONABLE_PAY in VARCHAR2
89 ,P_LGPS_TRANS_ARRANG_FLAG in VARCHAR2
90 ,P_LGPS_MEMBERSHIP_NUMBER in VARCHAR2
91 )is
92 l_commit_unit_number number;
93 l_legislation_code   varchar2(30);
94 begin
95 hr_utility.set_location('Entering: PQP_AAT_RKI.AFTER_INSERT', 10);
96 l_commit_unit_number := hr_api.return_commit_unit;
97 if hr_api.call_app_hooks then
98 PAY_DYT_ASSIGNMENT_ATTRIB_PKG.AFTER_INSERT
99 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
100 ,P_VALIDATION_START_DATE => P_VALIDATION_START_DATE
101 ,P_VALIDATION_END_DATE => P_VALIDATION_END_DATE
102 ,P_ASSIGNMENT_ATTRIBUTE_ID => P_ASSIGNMENT_ATTRIBUTE_ID
103 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
104 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
105 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
106 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
107 ,P_CONTRACT_TYPE => P_CONTRACT_TYPE
108 ,P_WORK_PATTERN => P_WORK_PATTERN
109 ,P_START_DAY => P_START_DAY
110 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
111 ,P_PRIMARY_COMPANY_CAR => P_PRIMARY_COMPANY_CAR
112 ,P_PRIMARY_CAR_FUEL_BENEFIT => P_PRIMARY_CAR_FUEL_BENEFIT
113 ,P_PRIMARY_CLASS_1A => P_PRIMARY_CLASS_1A
114 ,P_PRIMARY_CAPITAL_CONTRIBUTION => P_PRIMARY_CAPITAL_CONTRIBUTION
115 ,P_PRIMARY_PRIVATE_CONTRIBUTION => P_PRIMARY_PRIVATE_CONTRIBUTION
116 ,P_SECONDARY_COMPANY_CAR => P_SECONDARY_COMPANY_CAR
117 ,P_SECONDARY_CAR_FUEL_BENEFIT => P_SECONDARY_CAR_FUEL_BENEFIT
118 ,P_SECONDARY_CLASS_1A => P_SECONDARY_CLASS_1A
119 ,P_SECONDARY_CAPITAL_CONTRIBUTI => P_SECONDARY_CAPITAL_CONTRIBUTI
120 ,P_SECONDARY_PRIVATE_CONTRIBUTI => P_SECONDARY_PRIVATE_CONTRIBUTI
121 ,P_COMPANY_CAR_CALC_METHOD => P_COMPANY_CAR_CALC_METHOD
122 ,P_COMPANY_CAR_RATES_TABLE_ID => P_COMPANY_CAR_RATES_TABLE_ID
123 ,P_COMPANY_CAR_SECONDARY_TABLE => P_COMPANY_CAR_SECONDARY_TABLE
124 ,P_PRIVATE_CAR => P_PRIVATE_CAR
125 ,P_PRIVATE_CAR_CALC_METHOD => P_PRIVATE_CAR_CALC_METHOD
126 ,P_PRIVATE_CAR_RATES_TABLE_ID => P_PRIVATE_CAR_RATES_TABLE_ID
127 ,P_PRIVATE_CAR_ESSENTIAL_TABLE => P_PRIVATE_CAR_ESSENTIAL_TABLE
128 ,P_TP_IS_TEACHER => P_TP_IS_TEACHER
129 ,P_TP_HEADTEACHER_GRP_CODE => P_TP_HEADTEACHER_GRP_CODE
130 ,P_TP_SAFEGUARDED_GRADE => P_TP_SAFEGUARDED_GRADE
131 ,P_TP_SAFEGUARDED_GRADE_ID => P_TP_SAFEGUARDED_GRADE_ID
132 ,P_TP_SAFEGUARDED_RATE_TYPE => P_TP_SAFEGUARDED_RATE_TYPE
133 ,P_TP_SAFEGUARDED_RATE_ID => P_TP_SAFEGUARDED_RATE_ID
134 ,P_TP_SPINAL_POINT_ID => P_TP_SPINAL_POINT_ID
135 ,P_TP_ELECTED_PENSION => P_TP_ELECTED_PENSION
136 ,P_TP_FAST_TRACK => P_TP_FAST_TRACK
137 ,P_AAT_ATTRIBUTE_CATEGORY => P_AAT_ATTRIBUTE_CATEGORY
138 ,P_AAT_ATTRIBUTE1 => P_AAT_ATTRIBUTE1
139 ,P_AAT_ATTRIBUTE2 => P_AAT_ATTRIBUTE2
140 ,P_AAT_ATTRIBUTE3 => P_AAT_ATTRIBUTE3
141 ,P_AAT_ATTRIBUTE4 => P_AAT_ATTRIBUTE4
142 ,P_AAT_ATTRIBUTE5 => P_AAT_ATTRIBUTE5
143 ,P_AAT_ATTRIBUTE6 => P_AAT_ATTRIBUTE6
144 ,P_AAT_ATTRIBUTE7 => P_AAT_ATTRIBUTE7
145 ,P_AAT_ATTRIBUTE8 => P_AAT_ATTRIBUTE8
146 ,P_AAT_ATTRIBUTE9 => P_AAT_ATTRIBUTE9
147 ,P_AAT_ATTRIBUTE10 => P_AAT_ATTRIBUTE10
148 ,P_AAT_ATTRIBUTE11 => P_AAT_ATTRIBUTE11
149 ,P_AAT_ATTRIBUTE12 => P_AAT_ATTRIBUTE12
150 ,P_AAT_ATTRIBUTE13 => P_AAT_ATTRIBUTE13
151 ,P_AAT_ATTRIBUTE14 => P_AAT_ATTRIBUTE14
152 ,P_AAT_ATTRIBUTE15 => P_AAT_ATTRIBUTE15
153 ,P_AAT_ATTRIBUTE16 => P_AAT_ATTRIBUTE16
154 ,P_AAT_ATTRIBUTE17 => P_AAT_ATTRIBUTE17
155 ,P_AAT_ATTRIBUTE18 => P_AAT_ATTRIBUTE18
156 ,P_AAT_ATTRIBUTE19 => P_AAT_ATTRIBUTE19
157 ,P_AAT_ATTRIBUTE20 => P_AAT_ATTRIBUTE20
158 ,P_AAT_INFORMATION_CATEGORY => P_AAT_INFORMATION_CATEGORY
159 ,P_AAT_INFORMATION1 => P_AAT_INFORMATION1
160 ,P_AAT_INFORMATION2 => P_AAT_INFORMATION2
161 ,P_AAT_INFORMATION3 => P_AAT_INFORMATION3
162 ,P_AAT_INFORMATION4 => P_AAT_INFORMATION4
163 ,P_AAT_INFORMATION5 => P_AAT_INFORMATION5
164 ,P_AAT_INFORMATION6 => P_AAT_INFORMATION6
165 ,P_AAT_INFORMATION7 => P_AAT_INFORMATION7
166 ,P_AAT_INFORMATION8 => P_AAT_INFORMATION8
167 ,P_AAT_INFORMATION9 => P_AAT_INFORMATION9
168 ,P_AAT_INFORMATION10 => P_AAT_INFORMATION10
169 ,P_AAT_INFORMATION11 => P_AAT_INFORMATION11
170 ,P_AAT_INFORMATION12 => P_AAT_INFORMATION12
171 ,P_AAT_INFORMATION13 => P_AAT_INFORMATION13
172 ,P_AAT_INFORMATION14 => P_AAT_INFORMATION14
173 ,P_AAT_INFORMATION15 => P_AAT_INFORMATION15
174 ,P_AAT_INFORMATION16 => P_AAT_INFORMATION16
175 ,P_AAT_INFORMATION17 => P_AAT_INFORMATION17
176 ,P_AAT_INFORMATION18 => P_AAT_INFORMATION18
177 ,P_AAT_INFORMATION19 => P_AAT_INFORMATION19
178 ,P_AAT_INFORMATION20 => P_AAT_INFORMATION20
179 ,P_LGPS_PROCESS_FLAG => P_LGPS_PROCESS_FLAG
180 ,P_LGPS_EXCLUSION_TYPE => P_LGPS_EXCLUSION_TYPE
181 ,P_LGPS_PENSIONABLE_PAY => P_LGPS_PENSIONABLE_PAY
182 ,P_LGPS_TRANS_ARRANG_FLAG => P_LGPS_TRANS_ARRANG_FLAG
183 ,P_LGPS_MEMBERSHIP_NUMBER => P_LGPS_MEMBERSHIP_NUMBER
184 );
185 end if;
186 hr_api.validate_commit_unit(l_commit_unit_number, 'PQP_ASSIGNMENT_ATTRIBUTES_F', 'AI');
187 hr_utility.set_location(' Leaving: PQP_AAT_RKI.AFTER_INSERT', 20);
188 end AFTER_INSERT;
189 end PQP_AAT_RKI;