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_API_BK2

Source


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