[Home] [Help]
61: begin
62: --dbms_output.put_line(' ');
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: p_assignment_rec.assignment_id:=
65: hr_transaction_api.get_number_value
66: (p_transaction_step_id => p_transaction_step_id
67: ,p_name => 'P_ASSIGNMENT_ID');
68: --
69: p_assignment_rec.object_version_number :=
66: (p_transaction_step_id => p_transaction_step_id
67: ,p_name => 'P_ASSIGNMENT_ID');
68: --
69: p_assignment_rec.object_version_number :=
70: hr_transaction_api.get_number_value
71: (p_transaction_step_id => p_transaction_step_id
72: ,p_name => 'P_OBJECT_VERSION_NUMBER');
73: --
74: p_assignment_rec.business_group_id :=
71: (p_transaction_step_id => p_transaction_step_id
72: ,p_name => 'P_OBJECT_VERSION_NUMBER');
73: --
74: p_assignment_rec.business_group_id :=
75: hr_transaction_api.get_number_value
76: (p_transaction_step_id => p_transaction_step_id
77: ,p_name => 'P_BUSINESS_GROUP_ID');
78: --
79: p_assignment_rec.person_id :=
76: (p_transaction_step_id => p_transaction_step_id
77: ,p_name => 'P_BUSINESS_GROUP_ID');
78: --
79: p_assignment_rec.person_id :=
80: hr_transaction_api.get_number_value
81: (p_transaction_step_id => p_transaction_step_id
82: ,p_name => 'P_PERSON_ID');
83: --
84: p_assignment_rec.organization_id :=
81: (p_transaction_step_id => p_transaction_step_id
82: ,p_name => 'P_PERSON_ID');
83: --
84: p_assignment_rec.organization_id :=
85: hr_transaction_api.get_number_value
86: (p_transaction_step_id => p_transaction_step_id
87: ,p_name => 'P_ORGANIZATION_ID');
88: --
89: p_assignment_rec.grade_id :=
86: (p_transaction_step_id => p_transaction_step_id
87: ,p_name => 'P_ORGANIZATION_ID');
88: --
89: p_assignment_rec.grade_id :=
90: hr_transaction_api.get_number_value
91: (p_transaction_step_id => p_transaction_step_id
92: ,p_name => 'P_GRADE_ID');
93: --
94: p_assignment_rec.position_id :=
91: (p_transaction_step_id => p_transaction_step_id
92: ,p_name => 'P_GRADE_ID');
93: --
94: p_assignment_rec.position_id :=
95: hr_transaction_api.get_number_value
96: (p_transaction_step_id => p_transaction_step_id
97: ,p_name => 'P_POSITION_ID');
98: --
99: p_assignment_rec.job_id :=
96: (p_transaction_step_id => p_transaction_step_id
97: ,p_name => 'P_POSITION_ID');
98: --
99: p_assignment_rec.job_id :=
100: hr_transaction_api.get_number_value
101: (p_transaction_step_id => p_transaction_step_id
102: ,p_name => 'P_JOB_ID');
103: --
104: p_assignment_rec.location_id :=
101: (p_transaction_step_id => p_transaction_step_id
102: ,p_name => 'P_JOB_ID');
103: --
104: p_assignment_rec.location_id :=
105: hr_transaction_api.get_number_value
106: (p_transaction_step_id => p_transaction_step_id
107: ,p_name => 'P_LOCATION_ID');
108: --
109: p_assignment_rec.special_ceiling_step_id :=
106: (p_transaction_step_id => p_transaction_step_id
107: ,p_name => 'P_LOCATION_ID');
108: --
109: p_assignment_rec.special_ceiling_step_id :=
110: hr_transaction_api.get_number_value
111: (p_transaction_step_id => p_transaction_step_id
112: ,p_name => 'P_SPECIAL_CEILING_STEP_ID');
113: --
114: p_assignment_rec.employment_category :=
111: (p_transaction_step_id => p_transaction_step_id
112: ,p_name => 'P_SPECIAL_CEILING_STEP_ID');
113: --
114: p_assignment_rec.employment_category :=
115: hr_transaction_api.get_varchar2_value
116: (p_transaction_step_id => p_transaction_step_id
117: ,p_name => 'P_EMPLOYMENT_CATEGORY');
118: --
119: p_assignment_rec.supervisor_id :=
116: (p_transaction_step_id => p_transaction_step_id
117: ,p_name => 'P_EMPLOYMENT_CATEGORY');
118: --
119: p_assignment_rec.supervisor_id :=
120: hr_transaction_api.get_number_value
121: (p_transaction_step_id => p_transaction_step_id
122: ,p_name => 'P_SUPERVISOR_ID');
123: --
124: p_assignment_rec.manager_flag :=
121: (p_transaction_step_id => p_transaction_step_id
122: ,p_name => 'P_SUPERVISOR_ID');
123: --
124: p_assignment_rec.manager_flag :=
125: hr_transaction_api.get_varchar2_value
126: (p_transaction_step_id => p_transaction_step_id
127: ,p_name => 'P_MANAGER_FLAG');
128: --
129: p_assignment_rec.normal_hours :=
126: (p_transaction_step_id => p_transaction_step_id
127: ,p_name => 'P_MANAGER_FLAG');
128: --
129: p_assignment_rec.normal_hours :=
130: hr_transaction_api.get_number_value
131: (p_transaction_step_id => p_transaction_step_id
132: ,p_name => 'P_NORMAL_HOURS');
133: --
134: p_assignment_rec.frequency :=
131: (p_transaction_step_id => p_transaction_step_id
132: ,p_name => 'P_NORMAL_HOURS');
133: --
134: p_assignment_rec.frequency :=
135: hr_transaction_api.get_varchar2_value
136: (p_transaction_step_id => p_transaction_step_id
137: ,p_name => 'P_FREQUENCY');
138: --
139: p_assignment_rec.time_normal_finish :=
136: (p_transaction_step_id => p_transaction_step_id
137: ,p_name => 'P_FREQUENCY');
138: --
139: p_assignment_rec.time_normal_finish :=
140: substr(hr_transaction_api.get_varchar2_value
141: (p_transaction_step_id => p_transaction_step_id
142: ,p_name => 'P_TIME_NORMAL_FINISH'),0,5);
143: --
144: p_assignment_rec.time_normal_start :=
141: (p_transaction_step_id => p_transaction_step_id
142: ,p_name => 'P_TIME_NORMAL_FINISH'),0,5);
143: --
144: p_assignment_rec.time_normal_start :=
145: substr(hr_transaction_api.get_varchar2_value
146: (p_transaction_step_id => p_transaction_step_id
147: ,p_name => 'P_TIME_NORMAL_START'),0,5);
148: --
149: p_assignment_rec.bargaining_unit_code :=
146: (p_transaction_step_id => p_transaction_step_id
147: ,p_name => 'P_TIME_NORMAL_START'),0,5);
148: --
149: p_assignment_rec.bargaining_unit_code :=
150: hr_transaction_api.get_varchar2_value
151: (p_transaction_step_id => p_transaction_step_id
152: ,p_name => 'P_BARGAINING_UNIT_CODE');
153: --
154: p_assignment_rec.labour_union_member_flag :=
151: (p_transaction_step_id => p_transaction_step_id
152: ,p_name => 'P_BARGAINING_UNIT_CODE');
153: --
154: p_assignment_rec.labour_union_member_flag :=
155: hr_transaction_api.get_varchar2_value
156: (p_transaction_step_id => p_transaction_step_id
157: ,p_name => 'P_LABOUR_UNION_MEMBER_FLAG');
158: --
159: p_assignment_rec.assignment_status_type_id :=
156: (p_transaction_step_id => p_transaction_step_id
157: ,p_name => 'P_LABOUR_UNION_MEMBER_FLAG');
158: --
159: p_assignment_rec.assignment_status_type_id :=
160: hr_transaction_api.get_number_value
161: (p_transaction_step_id => p_transaction_step_id
162: ,p_name => 'P_ASSIGNMENT_STATUS_TYPE_ID');
163: --
164: p_assignment_rec.change_reason :=
161: (p_transaction_step_id => p_transaction_step_id
162: ,p_name => 'P_ASSIGNMENT_STATUS_TYPE_ID');
163: --
164: p_assignment_rec.change_reason :=
165: hr_transaction_api.get_varchar2_value
166: (p_transaction_step_id => p_transaction_step_id
167: ,p_name => 'P_CHANGE_REASON');
168: --
169: p_assignment_rec.ass_attribute_category :=
166: (p_transaction_step_id => p_transaction_step_id
167: ,p_name => 'P_CHANGE_REASON');
168: --
169: p_assignment_rec.ass_attribute_category :=
170: hr_transaction_api.get_varchar2_value
171: (p_transaction_step_id => p_transaction_step_id
172: ,p_name => 'P_ASS_ATTRIBUTE_CATEGORY');
173: --
174: p_assignment_rec.ass_attribute1 :=
171: (p_transaction_step_id => p_transaction_step_id
172: ,p_name => 'P_ASS_ATTRIBUTE_CATEGORY');
173: --
174: p_assignment_rec.ass_attribute1 :=
175: hr_transaction_api.get_varchar2_value
176: (p_transaction_step_id => p_transaction_step_id
177: ,p_name => 'P_ASS_ATTRIBUTE1');
178: --
179: p_assignment_rec.ass_attribute2 :=
176: (p_transaction_step_id => p_transaction_step_id
177: ,p_name => 'P_ASS_ATTRIBUTE1');
178: --
179: p_assignment_rec.ass_attribute2 :=
180: hr_transaction_api.get_varchar2_value
181: (p_transaction_step_id => p_transaction_step_id
182: ,p_name => 'P_ASS_ATTRIBUTE2');
183: --
184: p_assignment_rec.ass_attribute3 :=
181: (p_transaction_step_id => p_transaction_step_id
182: ,p_name => 'P_ASS_ATTRIBUTE2');
183: --
184: p_assignment_rec.ass_attribute3 :=
185: hr_transaction_api.get_varchar2_value
186: (p_transaction_step_id => p_transaction_step_id
187: ,p_name => 'P_ASS_ATTRIBUTE3');
188: --
189: p_assignment_rec.ass_attribute4 :=
186: (p_transaction_step_id => p_transaction_step_id
187: ,p_name => 'P_ASS_ATTRIBUTE3');
188: --
189: p_assignment_rec.ass_attribute4 :=
190: hr_transaction_api.get_varchar2_value
191: (p_transaction_step_id => p_transaction_step_id
192: ,p_name => 'P_ASS_ATTRIBUTE4');
193: --
194: p_assignment_rec.ass_attribute5 :=
191: (p_transaction_step_id => p_transaction_step_id
192: ,p_name => 'P_ASS_ATTRIBUTE4');
193: --
194: p_assignment_rec.ass_attribute5 :=
195: hr_transaction_api.get_varchar2_value
196: (p_transaction_step_id => p_transaction_step_id
197: ,p_name => 'P_ASS_ATTRIBUTE5');
198: --
199: p_assignment_rec.ass_attribute6 :=
196: (p_transaction_step_id => p_transaction_step_id
197: ,p_name => 'P_ASS_ATTRIBUTE5');
198: --
199: p_assignment_rec.ass_attribute6 :=
200: hr_transaction_api.get_varchar2_value
201: (p_transaction_step_id => p_transaction_step_id
202: ,p_name => 'P_ASS_ATTRIBUTE6');
203: --
204: p_assignment_rec.ass_attribute7 :=
201: (p_transaction_step_id => p_transaction_step_id
202: ,p_name => 'P_ASS_ATTRIBUTE6');
203: --
204: p_assignment_rec.ass_attribute7 :=
205: hr_transaction_api.get_varchar2_value
206: (p_transaction_step_id => p_transaction_step_id
207: ,p_name => 'P_ASS_ATTRIBUTE7');
208: --
209: p_assignment_rec.ass_attribute8 :=
206: (p_transaction_step_id => p_transaction_step_id
207: ,p_name => 'P_ASS_ATTRIBUTE7');
208: --
209: p_assignment_rec.ass_attribute8 :=
210: hr_transaction_api.get_varchar2_value
211: (p_transaction_step_id => p_transaction_step_id
212: ,p_name => 'P_ASS_ATTRIBUTE8');
213: --
214: p_assignment_rec.ass_attribute9 :=
211: (p_transaction_step_id => p_transaction_step_id
212: ,p_name => 'P_ASS_ATTRIBUTE8');
213: --
214: p_assignment_rec.ass_attribute9 :=
215: hr_transaction_api.get_varchar2_value
216: (p_transaction_step_id => p_transaction_step_id
217: ,p_name => 'P_ASS_ATTRIBUTE9');
218: --
219: p_assignment_rec.ass_attribute10 :=
216: (p_transaction_step_id => p_transaction_step_id
217: ,p_name => 'P_ASS_ATTRIBUTE9');
218: --
219: p_assignment_rec.ass_attribute10 :=
220: hr_transaction_api.get_varchar2_value
221: (p_transaction_step_id => p_transaction_step_id
222: ,p_name => 'P_ASS_ATTRIBUTE10');
223: --
224: p_assignment_rec.ass_attribute11 :=
221: (p_transaction_step_id => p_transaction_step_id
222: ,p_name => 'P_ASS_ATTRIBUTE10');
223: --
224: p_assignment_rec.ass_attribute11 :=
225: hr_transaction_api.get_varchar2_value
226: (p_transaction_step_id => p_transaction_step_id
227: ,p_name => 'P_ASS_ATTRIBUTE11');
228: --
229: p_assignment_rec.ass_attribute12 :=
226: (p_transaction_step_id => p_transaction_step_id
227: ,p_name => 'P_ASS_ATTRIBUTE11');
228: --
229: p_assignment_rec.ass_attribute12 :=
230: hr_transaction_api.get_varchar2_value
231: (p_transaction_step_id => p_transaction_step_id
232: ,p_name => 'P_ASS_ATTRIBUTE12');
233: --
234: p_assignment_rec.ass_attribute13 :=
231: (p_transaction_step_id => p_transaction_step_id
232: ,p_name => 'P_ASS_ATTRIBUTE12');
233: --
234: p_assignment_rec.ass_attribute13 :=
235: hr_transaction_api.get_varchar2_value
236: (p_transaction_step_id => p_transaction_step_id
237: ,p_name => 'P_ASS_ATTRIBUTE13');
238: --
239: p_assignment_rec.ass_attribute14 :=
236: (p_transaction_step_id => p_transaction_step_id
237: ,p_name => 'P_ASS_ATTRIBUTE13');
238: --
239: p_assignment_rec.ass_attribute14 :=
240: hr_transaction_api.get_varchar2_value
241: (p_transaction_step_id => p_transaction_step_id
242: ,p_name => 'P_ASS_ATTRIBUTE14');
243: --
244: p_assignment_rec.ass_attribute15 :=
241: (p_transaction_step_id => p_transaction_step_id
242: ,p_name => 'P_ASS_ATTRIBUTE14');
243: --
244: p_assignment_rec.ass_attribute15 :=
245: hr_transaction_api.get_varchar2_value
246: (p_transaction_step_id => p_transaction_step_id
247: ,p_name => 'P_ASS_ATTRIBUTE15');
248: --
249: p_assignment_rec.ass_attribute16 :=
246: (p_transaction_step_id => p_transaction_step_id
247: ,p_name => 'P_ASS_ATTRIBUTE15');
248: --
249: p_assignment_rec.ass_attribute16 :=
250: hr_transaction_api.get_varchar2_value
251: (p_transaction_step_id => p_transaction_step_id
252: ,p_name => 'P_ASS_ATTRIBUTE16');
253: --
254: p_assignment_rec.ass_attribute17 :=
251: (p_transaction_step_id => p_transaction_step_id
252: ,p_name => 'P_ASS_ATTRIBUTE16');
253: --
254: p_assignment_rec.ass_attribute17 :=
255: hr_transaction_api.get_varchar2_value
256: (p_transaction_step_id => p_transaction_step_id
257: ,p_name => 'P_ASS_ATTRIBUTE17');
258: --
259: p_assignment_rec.ass_attribute18 :=
256: (p_transaction_step_id => p_transaction_step_id
257: ,p_name => 'P_ASS_ATTRIBUTE17');
258: --
259: p_assignment_rec.ass_attribute18 :=
260: hr_transaction_api.get_varchar2_value
261: (p_transaction_step_id => p_transaction_step_id
262: ,p_name => 'P_ASS_ATTRIBUTE18');
263: --
264: p_assignment_rec.ass_attribute19 :=
261: (p_transaction_step_id => p_transaction_step_id
262: ,p_name => 'P_ASS_ATTRIBUTE18');
263: --
264: p_assignment_rec.ass_attribute19 :=
265: hr_transaction_api.get_varchar2_value
266: (p_transaction_step_id => p_transaction_step_id
267: ,p_name => 'P_ASS_ATTRIBUTE19');
268: --
269: p_assignment_rec.ass_attribute20 :=
266: (p_transaction_step_id => p_transaction_step_id
267: ,p_name => 'P_ASS_ATTRIBUTE19');
268: --
269: p_assignment_rec.ass_attribute20 :=
270: hr_transaction_api.get_varchar2_value
271: (p_transaction_step_id => p_transaction_step_id
272: ,p_name => 'P_ASS_ATTRIBUTE20');
273: --
274: p_assignment_rec.ass_attribute21 :=
271: (p_transaction_step_id => p_transaction_step_id
272: ,p_name => 'P_ASS_ATTRIBUTE20');
273: --
274: p_assignment_rec.ass_attribute21 :=
275: hr_transaction_api.get_varchar2_value
276: (p_transaction_step_id => p_transaction_step_id
277: ,p_name => 'P_ASS_ATTRIBUTE21');
278: --
279: p_assignment_rec.ass_attribute22 :=
276: (p_transaction_step_id => p_transaction_step_id
277: ,p_name => 'P_ASS_ATTRIBUTE21');
278: --
279: p_assignment_rec.ass_attribute22 :=
280: hr_transaction_api.get_varchar2_value
281: (p_transaction_step_id => p_transaction_step_id
282: ,p_name => 'P_ASS_ATTRIBUTE22');
283: --
284: p_assignment_rec.ass_attribute23 :=
281: (p_transaction_step_id => p_transaction_step_id
282: ,p_name => 'P_ASS_ATTRIBUTE22');
283: --
284: p_assignment_rec.ass_attribute23 :=
285: hr_transaction_api.get_varchar2_value
286: (p_transaction_step_id => p_transaction_step_id
287: ,p_name => 'P_ASS_ATTRIBUTE23');
288: --
289: p_assignment_rec.ass_attribute24 :=
286: (p_transaction_step_id => p_transaction_step_id
287: ,p_name => 'P_ASS_ATTRIBUTE23');
288: --
289: p_assignment_rec.ass_attribute24 :=
290: hr_transaction_api.get_varchar2_value
291: (p_transaction_step_id => p_transaction_step_id
292: ,p_name => 'P_ASS_ATTRIBUTE24');
293: --
294: p_assignment_rec.ass_attribute25 :=
291: (p_transaction_step_id => p_transaction_step_id
292: ,p_name => 'P_ASS_ATTRIBUTE24');
293: --
294: p_assignment_rec.ass_attribute25 :=
295: hr_transaction_api.get_varchar2_value
296: (p_transaction_step_id => p_transaction_step_id
297: ,p_name => 'P_ASS_ATTRIBUTE25');
298: --
299: p_assignment_rec.ass_attribute26 :=
296: (p_transaction_step_id => p_transaction_step_id
297: ,p_name => 'P_ASS_ATTRIBUTE25');
298: --
299: p_assignment_rec.ass_attribute26 :=
300: hr_transaction_api.get_varchar2_value
301: (p_transaction_step_id => p_transaction_step_id
302: ,p_name => 'P_ASS_ATTRIBUTE26');
303: --
304: p_assignment_rec.ass_attribute27 :=
301: (p_transaction_step_id => p_transaction_step_id
302: ,p_name => 'P_ASS_ATTRIBUTE26');
303: --
304: p_assignment_rec.ass_attribute27 :=
305: hr_transaction_api.get_varchar2_value
306: (p_transaction_step_id => p_transaction_step_id
307: ,p_name => 'P_ASS_ATTRIBUTE27');
308: --
309: p_assignment_rec.ass_attribute28 :=
306: (p_transaction_step_id => p_transaction_step_id
307: ,p_name => 'P_ASS_ATTRIBUTE27');
308: --
309: p_assignment_rec.ass_attribute28 :=
310: hr_transaction_api.get_varchar2_value
311: (p_transaction_step_id => p_transaction_step_id
312: ,p_name => 'P_ASS_ATTRIBUTE28');
313: --
314: p_assignment_rec.ass_attribute29 :=
311: (p_transaction_step_id => p_transaction_step_id
312: ,p_name => 'P_ASS_ATTRIBUTE28');
313: --
314: p_assignment_rec.ass_attribute29 :=
315: hr_transaction_api.get_varchar2_value
316: (p_transaction_step_id => p_transaction_step_id
317: ,p_name => 'P_ASS_ATTRIBUTE29');
318: --
319: p_assignment_rec.ass_attribute30 :=
316: (p_transaction_step_id => p_transaction_step_id
317: ,p_name => 'P_ASS_ATTRIBUTE29');
318: --
319: p_assignment_rec.ass_attribute30 :=
320: hr_transaction_api.get_varchar2_value
321: (p_transaction_step_id => p_transaction_step_id
322: ,p_name => 'P_ASS_ATTRIBUTE30');
323: --
324: p_assignment_rec.contract_id :=
321: (p_transaction_step_id => p_transaction_step_id
322: ,p_name => 'P_ASS_ATTRIBUTE30');
323: --
324: p_assignment_rec.contract_id :=
325: hr_transaction_api.get_number_value
326: (p_transaction_step_id => p_transaction_step_id
327: ,p_name => 'P_CONTRACT_ID');
328: --
329: p_assignment_rec.establishment_id :=
326: (p_transaction_step_id => p_transaction_step_id
327: ,p_name => 'P_CONTRACT_ID');
328: --
329: p_assignment_rec.establishment_id :=
330: hr_transaction_api.get_number_value
331: (p_transaction_step_id => p_transaction_step_id
332: ,p_name => 'P_ESTABLISHMENT_ID');
333: --
334: p_assignment_rec.cagr_grade_def_id :=
331: (p_transaction_step_id => p_transaction_step_id
332: ,p_name => 'P_ESTABLISHMENT_ID');
333: --
334: p_assignment_rec.cagr_grade_def_id :=
335: hr_transaction_api.get_number_value
336: (p_transaction_step_id => p_transaction_step_id
337: ,p_name => 'P_CAGR_GRADE_DEF_ID');
338: --
339: p_assignment_rec.collective_agreement_id :=
336: (p_transaction_step_id => p_transaction_step_id
337: ,p_name => 'P_CAGR_GRADE_DEF_ID');
338: --
339: p_assignment_rec.collective_agreement_id :=
340: hr_transaction_api.get_number_value
341: (p_transaction_step_id => p_transaction_step_id
342: ,p_name => 'P_COLLECTIVE_AGREEMENT_ID');
343: --
344: p_assignment_rec.cagr_id_flex_num :=
341: (p_transaction_step_id => p_transaction_step_id
342: ,p_name => 'P_COLLECTIVE_AGREEMENT_ID');
343: --
344: p_assignment_rec.cagr_id_flex_num :=
345: hr_transaction_api.get_number_value
346: (p_transaction_step_id => p_transaction_step_id
347: ,p_name => 'P_CAGR_ID_FLEX_NUM');
348: --
349: p_assignment_rec.payroll_id :=
346: (p_transaction_step_id => p_transaction_step_id
347: ,p_name => 'P_CAGR_ID_FLEX_NUM');
348: --
349: p_assignment_rec.payroll_id :=
350: hr_transaction_api.get_number_value
351: (p_transaction_step_id => p_transaction_step_id
352: ,p_name => 'P_PAYROLL_ID');
353: --
354: p_assignment_rec.pay_basis_id :=
351: (p_transaction_step_id => p_transaction_step_id
352: ,p_name => 'P_PAYROLL_ID');
353: --
354: p_assignment_rec.pay_basis_id :=
355: hr_transaction_api.get_number_value
356: (p_transaction_step_id => p_transaction_step_id
357: ,p_name => 'P_PAY_BASIS_ID');
358: --
359: p_assignment_rec.sal_review_period :=
356: (p_transaction_step_id => p_transaction_step_id
357: ,p_name => 'P_PAY_BASIS_ID');
358: --
359: p_assignment_rec.sal_review_period :=
360: hr_transaction_api.get_number_value
361: (p_transaction_step_id => p_transaction_step_id
362: ,p_name => 'P_SAL_REVIEW_PERIOD');
363: --
364: p_assignment_rec.sal_review_period_frequency :=
361: (p_transaction_step_id => p_transaction_step_id
362: ,p_name => 'P_SAL_REVIEW_PERIOD');
363: --
364: p_assignment_rec.sal_review_period_frequency :=
365: hr_transaction_api.get_varchar2_value
366: (p_transaction_step_id => p_transaction_step_id
367: ,p_name => 'P_SAL_REVIEW_PERIOD_FREQUENCY');
368:
369: --
367: ,p_name => 'P_SAL_REVIEW_PERIOD_FREQUENCY');
368:
369: --
370: p_assignment_rec.date_probation_end :=
371: hr_transaction_api.get_date_value
372: (p_transaction_step_id => p_transaction_step_id
373: ,p_name => 'P_DATE_PROBATION_END');
374: --
375: p_assignment_rec.probation_period :=
372: (p_transaction_step_id => p_transaction_step_id
373: ,p_name => 'P_DATE_PROBATION_END');
374: --
375: p_assignment_rec.probation_period :=
376: hr_transaction_api.get_number_value
377: (p_transaction_step_id => p_transaction_step_id
378: ,p_name => 'P_PROBATION_PERIOD');
379: --
380: p_assignment_rec.probation_unit :=
377: (p_transaction_step_id => p_transaction_step_id
378: ,p_name => 'P_PROBATION_PERIOD');
379: --
380: p_assignment_rec.probation_unit :=
381: hr_transaction_api.get_varchar2_value
382: (p_transaction_step_id => p_transaction_step_id
383: ,p_name => 'P_PROBATION_UNIT');
384: --
385: p_assignment_rec.notice_period :=
382: (p_transaction_step_id => p_transaction_step_id
383: ,p_name => 'P_PROBATION_UNIT');
384: --
385: p_assignment_rec.notice_period :=
386: hr_transaction_api.get_number_value
387: (p_transaction_step_id => p_transaction_step_id
388: ,p_name => 'P_NOTICE_PERIOD');
389: --
390: p_assignment_rec.notice_period_uom :=
387: (p_transaction_step_id => p_transaction_step_id
388: ,p_name => 'P_NOTICE_PERIOD');
389: --
390: p_assignment_rec.notice_period_uom :=
391: hr_transaction_api.get_varchar2_value
392: (p_transaction_step_id => p_transaction_step_id
393: ,p_name => 'P_NOTICE_PERIOD_UOM');
394: --
395: p_assignment_rec.employee_category :=
392: (p_transaction_step_id => p_transaction_step_id
393: ,p_name => 'P_NOTICE_PERIOD_UOM');
394: --
395: p_assignment_rec.employee_category :=
396: hr_transaction_api.get_varchar2_value
397: (p_transaction_step_id => p_transaction_step_id
398: ,p_name => 'P_EMPLOYEE_CATEGORY');
399: --
400: p_assignment_rec.work_at_home :=
397: (p_transaction_step_id => p_transaction_step_id
398: ,p_name => 'P_EMPLOYEE_CATEGORY');
399: --
400: p_assignment_rec.work_at_home :=
401: hr_transaction_api.get_varchar2_value
402: (p_transaction_step_id => p_transaction_step_id
403: ,p_name => 'P_WORK_AT_HOME');
404: --
405: p_assignment_rec.job_post_source_name :=
402: (p_transaction_step_id => p_transaction_step_id
403: ,p_name => 'P_WORK_AT_HOME');
404: --
405: p_assignment_rec.job_post_source_name :=
406: hr_transaction_api.get_varchar2_value
407: (p_transaction_step_id => p_transaction_step_id
408: ,p_name => 'P_JOB_POST_SOURCE_NAME');
409: --
410: p_assignment_rec.perf_review_period :=
407: (p_transaction_step_id => p_transaction_step_id
408: ,p_name => 'P_JOB_POST_SOURCE_NAME');
409: --
410: p_assignment_rec.perf_review_period :=
411: hr_transaction_api.get_number_value
412: (p_transaction_step_id => p_transaction_step_id
413: ,p_name => 'P_PERF_REVIEW_PERIOD');
414: --
415: p_assignment_rec.perf_review_period_frequency :=
412: (p_transaction_step_id => p_transaction_step_id
413: ,p_name => 'P_PERF_REVIEW_PERIOD');
414: --
415: p_assignment_rec.perf_review_period_frequency :=
416: hr_transaction_api.get_varchar2_value
417: (p_transaction_step_id => p_transaction_step_id
418: ,p_name => 'P_PERF_REVIEW_PERIOD_FREQUENCY');
419: --
420: p_assignment_rec.internal_address_line :=
417: (p_transaction_step_id => p_transaction_step_id
418: ,p_name => 'P_PERF_REVIEW_PERIOD_FREQUENCY');
419: --
420: p_assignment_rec.internal_address_line :=
421: hr_transaction_api.get_varchar2_value
422: (p_transaction_step_id => p_transaction_step_id
423: ,p_name => 'P_INTERNAL_ADDRESS_LINE');
424: --
425: p_assignment_rec.people_group_id:=
422: (p_transaction_step_id => p_transaction_step_id
423: ,p_name => 'P_INTERNAL_ADDRESS_LINE');
424: --
425: p_assignment_rec.people_group_id:=
426: hr_transaction_api.get_number_value
427: (p_transaction_step_id => p_transaction_step_id
428: ,p_name => 'P_PEOPLE_GROUP_ID');
429: --
430: p_assignment_rec.soft_coding_keyflex_id:=
427: (p_transaction_step_id => p_transaction_step_id
428: ,p_name => 'P_PEOPLE_GROUP_ID');
429: --
430: p_assignment_rec.soft_coding_keyflex_id:=
431: hr_transaction_api.get_number_value
432: (p_transaction_step_id => p_transaction_step_id
433: ,p_name => 'P_SOFT_CODING_KEYFLEX_ID');
434: --
435: p_assignment_rec.title:=
432: (p_transaction_step_id => p_transaction_step_id
433: ,p_name => 'P_SOFT_CODING_KEYFLEX_ID');
434: --
435: p_assignment_rec.title:=
436: hr_transaction_api.get_varchar2_value
437: (p_transaction_step_id => p_transaction_step_id
438: ,p_name => 'P_TITLE');
439: --
440: p_assignment_rec.project_title:=
437: (p_transaction_step_id => p_transaction_step_id
438: ,p_name => 'P_TITLE');
439: --
440: p_assignment_rec.project_title:=
441: hr_transaction_api.get_varchar2_value
442: (p_transaction_step_id => p_transaction_step_id
443: ,p_name => 'P_PROJECT_TITLE');
444: --
445: p_assignment_rec.source_type:=
442: (p_transaction_step_id => p_transaction_step_id
443: ,p_name => 'P_PROJECT_TITLE');
444: --
445: p_assignment_rec.source_type:=
446: hr_transaction_api.get_varchar2_value
447: (p_transaction_step_id => p_transaction_step_id
448: ,p_name => 'P_SOURCE_TYPE');
449: --
450: p_assignment_rec.vendor_assignment_number:=
447: (p_transaction_step_id => p_transaction_step_id
448: ,p_name => 'P_SOURCE_TYPE');
449: --
450: p_assignment_rec.vendor_assignment_number:=
451: hr_transaction_api.get_varchar2_value
452: (p_transaction_step_id => p_transaction_step_id
453: ,p_name => 'P_VENDOR_ASSIGNMENT_NUMBER');
454: --
455: p_assignment_rec.vendor_employee_number:=
452: (p_transaction_step_id => p_transaction_step_id
453: ,p_name => 'P_VENDOR_ASSIGNMENT_NUMBER');
454: --
455: p_assignment_rec.vendor_employee_number:=
456: hr_transaction_api.get_varchar2_value
457: (p_transaction_step_id => p_transaction_step_id
458: ,p_name => 'P_VENDOR_EMPLOYEE_NUMBER');
459: --
460: p_assignment_rec.default_code_comb_id := to_char(
457: (p_transaction_step_id => p_transaction_step_id
458: ,p_name => 'P_VENDOR_EMPLOYEE_NUMBER');
459: --
460: p_assignment_rec.default_code_comb_id := to_char(
461: hr_transaction_api.get_number_value
462: (p_transaction_step_id => p_transaction_step_id
463: ,p_name => 'P_DEFAULT_CODE_COMB_ID'));
464: --
465: p_assignment_rec.set_of_books_id := to_char(
462: (p_transaction_step_id => p_transaction_step_id
463: ,p_name => 'P_DEFAULT_CODE_COMB_ID'));
464: --
465: p_assignment_rec.set_of_books_id := to_char(
466: hr_transaction_api.get_number_value
467: (p_transaction_step_id => p_transaction_step_id
468: ,p_name => 'P_SET_OF_BOOKS_ID'));
469: --
470: p_assignment_rec.vendor_id := to_char(
467: (p_transaction_step_id => p_transaction_step_id
468: ,p_name => 'P_SET_OF_BOOKS_ID'));
469: --
470: p_assignment_rec.vendor_id := to_char(
471: hr_transaction_api.get_number_value
472: (p_transaction_step_id => p_transaction_step_id
473: ,p_name => 'P_VENDOR_ID'));
474: --
475: p_assignment_rec.assignment_type:=
472: (p_transaction_step_id => p_transaction_step_id
473: ,p_name => 'P_VENDOR_ID'));
474: --
475: p_assignment_rec.assignment_type:=
476: hr_transaction_api.get_varchar2_value
477: (p_transaction_step_id => p_transaction_step_id
478: ,p_name => 'P_ASSIGNMENT_TYPE');
479: --
480: -- GSP change
478: ,p_name => 'P_ASSIGNMENT_TYPE');
479: --
480: -- GSP change
481: p_assignment_rec.grade_ladder_pgm_id:=
482: hr_transaction_api.get_number_value
483: (p_transaction_step_id => p_transaction_step_id
484: ,p_name => 'P_GRADE_LADDER_PGM_ID');
485: -- End of GSP change
486:
484: ,p_name => 'P_GRADE_LADDER_PGM_ID');
485: -- End of GSP change
486:
487: --p_assignment_rec.supervisor_assignment_id:=
488: -- hr_transaction_api.get_number_value
489: -- (p_transaction_step_id => p_transaction_step_id
490: -- ,p_name => 'P_SUPERVISOR_ASSIGNMENT_ID');
491: --
492:
490: -- ,p_name => 'P_SUPERVISOR_ASSIGNMENT_ID');
491: --
492:
493: p_assignment_rec.po_header_id :=
494: hr_transaction_api.get_number_value
495: (p_transaction_step_id => p_transaction_step_id
496: ,p_name => 'P_PO_HEADER_ID');
497:
498: p_assignment_rec.po_line_id :=
495: (p_transaction_step_id => p_transaction_step_id
496: ,p_name => 'P_PO_HEADER_ID');
497:
498: p_assignment_rec.po_line_id :=
499: hr_transaction_api.get_number_value
500: (p_transaction_step_id => p_transaction_step_id
501: ,p_name => 'P_PO_LINE_ID');
502:
503: p_assignment_rec.vendor_site_id :=
500: (p_transaction_step_id => p_transaction_step_id
501: ,p_name => 'P_PO_LINE_ID');
502:
503: p_assignment_rec.vendor_site_id :=
504: hr_transaction_api.get_number_value
505: (p_transaction_step_id => p_transaction_step_id
506: ,p_name => 'P_VENDOR_SITE_ID');
507:
508:
506: ,p_name => 'P_VENDOR_SITE_ID');
507:
508:
509: p_assignment_rec.projected_assignment_end :=
510: hr_transaction_api.get_date_value
511: (p_transaction_step_id => p_transaction_step_id
512: ,p_name => 'P_PROJ_ASGN_END');
513:
514: hr_utility.set_location('Exiting:'||l_proc, 15);
728: return;
729: end if;
730: --
731: p_assignment_id:= to_char(
732: hr_transaction_api.get_number_value
733: (p_transaction_step_id => l_transaction_step_id
734: ,p_name => 'P_ASSIGNMENT_ID'));
735: --
736: p_business_group_id:= to_char(
733: (p_transaction_step_id => l_transaction_step_id
734: ,p_name => 'P_ASSIGNMENT_ID'));
735: --
736: p_business_group_id:= to_char(
737: hr_transaction_api.get_number_value
738: (p_transaction_step_id => l_transaction_step_id
739: ,p_name => 'P_BUSINESS_GROUP_ID'));
740: --
741: p_effective_date:= to_char(
738: (p_transaction_step_id => l_transaction_step_id
739: ,p_name => 'P_BUSINESS_GROUP_ID'));
740: --
741: p_effective_date:= to_char(
742: hr_transaction_api.get_date_value
743: (p_transaction_step_id => l_transaction_step_id
744: ,p_name => 'P_EFFECTIVE_DATE')
745: ,g_date_format);
746: --
744: ,p_name => 'P_EFFECTIVE_DATE')
745: ,g_date_format);
746: --
747: p_object_version_number := to_char(
748: hr_transaction_api.get_number_value
749: (p_transaction_step_id => l_transaction_step_id
750: ,p_name => 'P_OBJECT_VERSION_NUMBER'));
751: --
752: p_organization_id := to_char(
749: (p_transaction_step_id => l_transaction_step_id
750: ,p_name => 'P_OBJECT_VERSION_NUMBER'));
751: --
752: p_organization_id := to_char(
753: hr_transaction_api.get_number_value
754: (p_transaction_step_id => l_transaction_step_id
755: ,p_name => 'P_ORGANIZATION_ID'));
756: --
757: open csr_org_name(to_number(p_organization_id));
758: fetch csr_org_name into p_org_name;
759: close csr_org_name;
760: --
761: p_position_id := to_char(
762: hr_transaction_api.get_number_value
763: (p_transaction_step_id => l_transaction_step_id
764: ,p_name => 'P_POSITION_ID'));
765: --
766: open csr_pos_name(to_number(p_position_id));
767: fetch csr_pos_name into p_pos_name;
768: close csr_pos_name;
769: --
770: p_job_id := to_char(
771: hr_transaction_api.get_number_value
772: (p_transaction_step_id => l_transaction_step_id
773: ,p_name => 'P_JOB_ID'));
774: --
775: open csr_job_name(to_number(p_job_id));
776: fetch csr_job_name into p_job_name;
777: close csr_job_name;
778: --
779: p_grade_id := to_char(
780: hr_transaction_api.get_number_value
781: (p_transaction_step_id => l_transaction_step_id
782: ,p_name => 'P_GRADE_ID'));
783: --
784: open csr_grade_name(to_number(p_grade_id));
785: fetch csr_grade_name into p_grade_name;
786: close csr_grade_name;
787: --
788: p_location_id := to_char(
789: hr_transaction_api.get_number_value
790: (p_transaction_step_id => l_transaction_step_id
791: ,p_name => 'P_LOCATION_ID'));
792: --
793: p_employment_category :=
790: (p_transaction_step_id => l_transaction_step_id
791: ,p_name => 'P_LOCATION_ID'));
792: --
793: p_employment_category :=
794: hr_transaction_api.get_varchar2_value
795: (p_transaction_step_id => l_transaction_step_id
796: ,p_name => 'P_EMPLOYMENT_CATEGORY');
797: --
798: p_supervisor_id := to_char(
795: (p_transaction_step_id => l_transaction_step_id
796: ,p_name => 'P_EMPLOYMENT_CATEGORY');
797: --
798: p_supervisor_id := to_char(
799: hr_transaction_api.get_number_value
800: (p_transaction_step_id => l_transaction_step_id
801: ,p_name => 'P_SUPERVISOR_ID'));
802: --
803: p_manager_flag :=
800: (p_transaction_step_id => l_transaction_step_id
801: ,p_name => 'P_SUPERVISOR_ID'));
802: --
803: p_manager_flag :=
804: hr_transaction_api.get_varchar2_value
805: (p_transaction_step_id => l_transaction_step_id
806: ,p_name => 'P_MANAGER_FLAG');
807: --
808:
807: --
808:
809: -- Fix for Bug 2943224 and 3205625 for number format/invalid number error
810: p_normal_hours := to_char(
811: hr_transaction_api.get_number_value
812: (p_transaction_step_id => l_transaction_step_id
813: ,p_name => 'P_NORMAL_HOURS')
814: ,'9999999999999999999D999', 'NLS_NUMERIC_CHARACTERS = ''.,'''
815: );
814: ,'9999999999999999999D999', 'NLS_NUMERIC_CHARACTERS = ''.,'''
815: );
816: --
817: p_frequency :=
818: hr_transaction_api.get_varchar2_value
819: (p_transaction_step_id => l_transaction_step_id
820: ,p_name => 'P_FREQUENCY');
821: --
822: p_time_normal_finish :=
819: (p_transaction_step_id => l_transaction_step_id
820: ,p_name => 'P_FREQUENCY');
821: --
822: p_time_normal_finish :=
823: substr(hr_transaction_api.get_varchar2_value
824: (p_transaction_step_id => l_transaction_step_id
825: ,p_name => 'P_TIME_NORMAL_FINISH'),0,5);
826: --
827: p_time_normal_start :=
824: (p_transaction_step_id => l_transaction_step_id
825: ,p_name => 'P_TIME_NORMAL_FINISH'),0,5);
826: --
827: p_time_normal_start :=
828: substr(hr_transaction_api.get_varchar2_value
829: (p_transaction_step_id => l_transaction_step_id
830: ,p_name => 'P_TIME_NORMAL_START'),0,5);
831: --
832: p_bargaining_unit_code :=
829: (p_transaction_step_id => l_transaction_step_id
830: ,p_name => 'P_TIME_NORMAL_START'),0,5);
831: --
832: p_bargaining_unit_code :=
833: hr_transaction_api.get_varchar2_value
834: (p_transaction_step_id => l_transaction_step_id
835: ,p_name => 'P_BARGAINING_UNIT_CODE');
836: --
837: p_labour_union_member_flag :=
834: (p_transaction_step_id => l_transaction_step_id
835: ,p_name => 'P_BARGAINING_UNIT_CODE');
836: --
837: p_labour_union_member_flag :=
838: hr_transaction_api.get_varchar2_value
839: (p_transaction_step_id => l_transaction_step_id
840: ,p_name => 'P_LABOUR_UNION_MEMBER_FLAG');
841: --
842: p_special_ceiling_step_id := to_char(
839: (p_transaction_step_id => l_transaction_step_id
840: ,p_name => 'P_LABOUR_UNION_MEMBER_FLAG');
841: --
842: p_special_ceiling_step_id := to_char(
843: hr_transaction_api.get_number_value
844: (p_transaction_step_id => l_transaction_step_id
845: ,p_name => 'P_SPECIAL_CEILING_STEP_ID'));
846: --
847: p_assignment_status_type_id := to_char(
844: (p_transaction_step_id => l_transaction_step_id
845: ,p_name => 'P_SPECIAL_CEILING_STEP_ID'));
846: --
847: p_assignment_status_type_id := to_char(
848: hr_transaction_api.get_number_value
849: (p_transaction_step_id => l_transaction_step_id
850: ,p_name => 'P_ASSIGNMENT_STATUS_TYPE_ID'));
851: --
852: p_change_reason :=
849: (p_transaction_step_id => l_transaction_step_id
850: ,p_name => 'P_ASSIGNMENT_STATUS_TYPE_ID'));
851: --
852: p_change_reason :=
853: hr_transaction_api.get_varchar2_value
854: (p_transaction_step_id => l_transaction_step_id
855: ,p_name => 'P_CHANGE_REASON');
856: --
857: p_ass_attribute_category :=
854: (p_transaction_step_id => l_transaction_step_id
855: ,p_name => 'P_CHANGE_REASON');
856: --
857: p_ass_attribute_category :=
858: hr_transaction_api.get_varchar2_value
859: (p_transaction_step_id => l_transaction_step_id
860: ,p_name => 'P_ASS_ATTRIBUTE_CATEGORY');
861: --
862: p_ass_attribute1 :=
859: (p_transaction_step_id => l_transaction_step_id
860: ,p_name => 'P_ASS_ATTRIBUTE_CATEGORY');
861: --
862: p_ass_attribute1 :=
863: hr_transaction_api.get_varchar2_value
864: (p_transaction_step_id => l_transaction_step_id
865: ,p_name => 'P_ASS_ATTRIBUTE1');
866: --
867: p_ass_attribute2 :=
864: (p_transaction_step_id => l_transaction_step_id
865: ,p_name => 'P_ASS_ATTRIBUTE1');
866: --
867: p_ass_attribute2 :=
868: hr_transaction_api.get_varchar2_value
869: (p_transaction_step_id => l_transaction_step_id
870: ,p_name => 'P_ASS_ATTRIBUTE2');
871: --
872: p_ass_attribute3 :=
869: (p_transaction_step_id => l_transaction_step_id
870: ,p_name => 'P_ASS_ATTRIBUTE2');
871: --
872: p_ass_attribute3 :=
873: hr_transaction_api.get_varchar2_value
874: (p_transaction_step_id => l_transaction_step_id
875: ,p_name => 'P_ASS_ATTRIBUTE3');
876: --
877: p_ass_attribute4 :=
874: (p_transaction_step_id => l_transaction_step_id
875: ,p_name => 'P_ASS_ATTRIBUTE3');
876: --
877: p_ass_attribute4 :=
878: hr_transaction_api.get_varchar2_value
879: (p_transaction_step_id => l_transaction_step_id
880: ,p_name => 'P_ASS_ATTRIBUTE4');
881: --
882: p_ass_attribute5 :=
879: (p_transaction_step_id => l_transaction_step_id
880: ,p_name => 'P_ASS_ATTRIBUTE4');
881: --
882: p_ass_attribute5 :=
883: hr_transaction_api.get_varchar2_value
884: (p_transaction_step_id => l_transaction_step_id
885: ,p_name => 'P_ASS_ATTRIBUTE5');
886: --
887: p_ass_attribute6 :=
884: (p_transaction_step_id => l_transaction_step_id
885: ,p_name => 'P_ASS_ATTRIBUTE5');
886: --
887: p_ass_attribute6 :=
888: hr_transaction_api.get_varchar2_value
889: (p_transaction_step_id => l_transaction_step_id
890: ,p_name => 'P_ASS_ATTRIBUTE6');
891: --
892: p_ass_attribute7 :=
889: (p_transaction_step_id => l_transaction_step_id
890: ,p_name => 'P_ASS_ATTRIBUTE6');
891: --
892: p_ass_attribute7 :=
893: hr_transaction_api.get_varchar2_value
894: (p_transaction_step_id => l_transaction_step_id
895: ,p_name => 'P_ASS_ATTRIBUTE7');
896: --
897: p_ass_attribute8 :=
894: (p_transaction_step_id => l_transaction_step_id
895: ,p_name => 'P_ASS_ATTRIBUTE7');
896: --
897: p_ass_attribute8 :=
898: hr_transaction_api.get_varchar2_value
899: (p_transaction_step_id => l_transaction_step_id
900: ,p_name => 'P_ASS_ATTRIBUTE8');
901: --
902: p_ass_attribute9 :=
899: (p_transaction_step_id => l_transaction_step_id
900: ,p_name => 'P_ASS_ATTRIBUTE8');
901: --
902: p_ass_attribute9 :=
903: hr_transaction_api.get_varchar2_value
904: (p_transaction_step_id => l_transaction_step_id
905: ,p_name => 'P_ASS_ATTRIBUTE9');
906: --
907: p_ass_attribute10 :=
904: (p_transaction_step_id => l_transaction_step_id
905: ,p_name => 'P_ASS_ATTRIBUTE9');
906: --
907: p_ass_attribute10 :=
908: hr_transaction_api.get_varchar2_value
909: (p_transaction_step_id => l_transaction_step_id
910: ,p_name => 'P_ASS_ATTRIBUTE10');
911: --
912: p_ass_attribute11 :=
909: (p_transaction_step_id => l_transaction_step_id
910: ,p_name => 'P_ASS_ATTRIBUTE10');
911: --
912: p_ass_attribute11 :=
913: hr_transaction_api.get_varchar2_value
914: (p_transaction_step_id => l_transaction_step_id
915: ,p_name => 'P_ASS_ATTRIBUTE11');
916: --
917: p_ass_attribute12 :=
914: (p_transaction_step_id => l_transaction_step_id
915: ,p_name => 'P_ASS_ATTRIBUTE11');
916: --
917: p_ass_attribute12 :=
918: hr_transaction_api.get_varchar2_value
919: (p_transaction_step_id => l_transaction_step_id
920: ,p_name => 'P_ASS_ATTRIBUTE12');
921: --
922: p_ass_attribute13 :=
919: (p_transaction_step_id => l_transaction_step_id
920: ,p_name => 'P_ASS_ATTRIBUTE12');
921: --
922: p_ass_attribute13 :=
923: hr_transaction_api.get_varchar2_value
924: (p_transaction_step_id => l_transaction_step_id
925: ,p_name => 'P_ASS_ATTRIBUTE13');
926: --
927: p_ass_attribute14 :=
924: (p_transaction_step_id => l_transaction_step_id
925: ,p_name => 'P_ASS_ATTRIBUTE13');
926: --
927: p_ass_attribute14 :=
928: hr_transaction_api.get_varchar2_value
929: (p_transaction_step_id => l_transaction_step_id
930: ,p_name => 'P_ASS_ATTRIBUTE14');
931: --
932: p_ass_attribute15 :=
929: (p_transaction_step_id => l_transaction_step_id
930: ,p_name => 'P_ASS_ATTRIBUTE14');
931: --
932: p_ass_attribute15 :=
933: hr_transaction_api.get_varchar2_value
934: (p_transaction_step_id => l_transaction_step_id
935: ,p_name => 'P_ASS_ATTRIBUTE15');
936: --
937: p_ass_attribute16 :=
934: (p_transaction_step_id => l_transaction_step_id
935: ,p_name => 'P_ASS_ATTRIBUTE15');
936: --
937: p_ass_attribute16 :=
938: hr_transaction_api.get_varchar2_value
939: (p_transaction_step_id => l_transaction_step_id
940: ,p_name => 'P_ASS_ATTRIBUTE16');
941: --
942: p_ass_attribute17 :=
939: (p_transaction_step_id => l_transaction_step_id
940: ,p_name => 'P_ASS_ATTRIBUTE16');
941: --
942: p_ass_attribute17 :=
943: hr_transaction_api.get_varchar2_value
944: (p_transaction_step_id => l_transaction_step_id
945: ,p_name => 'P_ASS_ATTRIBUTE17');
946: --
947: p_ass_attribute18 :=
944: (p_transaction_step_id => l_transaction_step_id
945: ,p_name => 'P_ASS_ATTRIBUTE17');
946: --
947: p_ass_attribute18 :=
948: hr_transaction_api.get_varchar2_value
949: (p_transaction_step_id => l_transaction_step_id
950: ,p_name => 'P_ASS_ATTRIBUTE18');
951: --
952: p_ass_attribute19 :=
949: (p_transaction_step_id => l_transaction_step_id
950: ,p_name => 'P_ASS_ATTRIBUTE18');
951: --
952: p_ass_attribute19 :=
953: hr_transaction_api.get_varchar2_value
954: (p_transaction_step_id => l_transaction_step_id
955: ,p_name => 'P_ASS_ATTRIBUTE19');
956: --
957: p_ass_attribute20 :=
954: (p_transaction_step_id => l_transaction_step_id
955: ,p_name => 'P_ASS_ATTRIBUTE19');
956: --
957: p_ass_attribute20 :=
958: hr_transaction_api.get_varchar2_value
959: (p_transaction_step_id => l_transaction_step_id
960: ,p_name => 'P_ASS_ATTRIBUTE20');
961: --
962: p_ass_attribute21 :=
959: (p_transaction_step_id => l_transaction_step_id
960: ,p_name => 'P_ASS_ATTRIBUTE20');
961: --
962: p_ass_attribute21 :=
963: hr_transaction_api.get_varchar2_value
964: (p_transaction_step_id => l_transaction_step_id
965: ,p_name => 'P_ASS_ATTRIBUTE21');
966: --
967: p_ass_attribute22 :=
964: (p_transaction_step_id => l_transaction_step_id
965: ,p_name => 'P_ASS_ATTRIBUTE21');
966: --
967: p_ass_attribute22 :=
968: hr_transaction_api.get_varchar2_value
969: (p_transaction_step_id => l_transaction_step_id
970: ,p_name => 'P_ASS_ATTRIBUTE22');
971: --
972: p_ass_attribute23 :=
969: (p_transaction_step_id => l_transaction_step_id
970: ,p_name => 'P_ASS_ATTRIBUTE22');
971: --
972: p_ass_attribute23 :=
973: hr_transaction_api.get_varchar2_value
974: (p_transaction_step_id => l_transaction_step_id
975: ,p_name => 'P_ASS_ATTRIBUTE23');
976: --
977: p_ass_attribute24 :=
974: (p_transaction_step_id => l_transaction_step_id
975: ,p_name => 'P_ASS_ATTRIBUTE23');
976: --
977: p_ass_attribute24 :=
978: hr_transaction_api.get_varchar2_value
979: (p_transaction_step_id => l_transaction_step_id
980: ,p_name => 'P_ASS_ATTRIBUTE24');
981: --
982: p_ass_attribute25 :=
979: (p_transaction_step_id => l_transaction_step_id
980: ,p_name => 'P_ASS_ATTRIBUTE24');
981: --
982: p_ass_attribute25 :=
983: hr_transaction_api.get_varchar2_value
984: (p_transaction_step_id => l_transaction_step_id
985: ,p_name => 'P_ASS_ATTRIBUTE25');
986: --
987: p_ass_attribute26 :=
984: (p_transaction_step_id => l_transaction_step_id
985: ,p_name => 'P_ASS_ATTRIBUTE25');
986: --
987: p_ass_attribute26 :=
988: hr_transaction_api.get_varchar2_value
989: (p_transaction_step_id => l_transaction_step_id
990: ,p_name => 'P_ASS_ATTRIBUTE26');
991: --
992: p_ass_attribute27 :=
989: (p_transaction_step_id => l_transaction_step_id
990: ,p_name => 'P_ASS_ATTRIBUTE26');
991: --
992: p_ass_attribute27 :=
993: hr_transaction_api.get_varchar2_value
994: (p_transaction_step_id => l_transaction_step_id
995: ,p_name => 'P_ASS_ATTRIBUTE27');
996: --
997: p_ass_attribute28 :=
994: (p_transaction_step_id => l_transaction_step_id
995: ,p_name => 'P_ASS_ATTRIBUTE27');
996: --
997: p_ass_attribute28 :=
998: hr_transaction_api.get_varchar2_value
999: (p_transaction_step_id => l_transaction_step_id
1000: ,p_name => 'P_ASS_ATTRIBUTE28');
1001: --
1002: p_ass_attribute29 :=
999: (p_transaction_step_id => l_transaction_step_id
1000: ,p_name => 'P_ASS_ATTRIBUTE28');
1001: --
1002: p_ass_attribute29 :=
1003: hr_transaction_api.get_varchar2_value
1004: (p_transaction_step_id => l_transaction_step_id
1005: ,p_name => 'P_ASS_ATTRIBUTE29');
1006: --
1007: p_ass_attribute30 :=
1004: (p_transaction_step_id => l_transaction_step_id
1005: ,p_name => 'P_ASS_ATTRIBUTE29');
1006: --
1007: p_ass_attribute30 :=
1008: hr_transaction_api.get_varchar2_value
1009: (p_transaction_step_id => l_transaction_step_id
1010: ,p_name => 'P_ASS_ATTRIBUTE30');
1011:
1012: p_people_group_id:=to_char(
1009: (p_transaction_step_id => l_transaction_step_id
1010: ,p_name => 'P_ASS_ATTRIBUTE30');
1011:
1012: p_people_group_id:=to_char(
1013: hr_transaction_api.get_number_value
1014: (p_transaction_step_id => l_transaction_step_id
1015: ,p_name => 'P_PEOPLE_GROUP_ID'));
1016: --
1017: p_soft_coding_keyflex_id:= to_char(
1014: (p_transaction_step_id => l_transaction_step_id
1015: ,p_name => 'P_PEOPLE_GROUP_ID'));
1016: --
1017: p_soft_coding_keyflex_id:= to_char(
1018: hr_transaction_api.get_number_value
1019: (p_transaction_step_id => l_transaction_step_id
1020: ,p_name => 'P_SOFT_CODING_KEYFLEX_ID'));
1021: --
1022: p_sal_review_period:=
1019: (p_transaction_step_id => l_transaction_step_id
1020: ,p_name => 'P_SOFT_CODING_KEYFLEX_ID'));
1021: --
1022: p_sal_review_period:=
1023: hr_transaction_api.get_number_value
1024: (p_transaction_step_id => l_transaction_step_id
1025: ,p_name => 'P_SAL_REVIEW_PERIOD');
1026: --
1027: p_sal_review_period_frequency:=
1024: (p_transaction_step_id => l_transaction_step_id
1025: ,p_name => 'P_SAL_REVIEW_PERIOD');
1026: --
1027: p_sal_review_period_frequency:=
1028: hr_transaction_api.get_varchar2_value
1029: (p_transaction_step_id => l_transaction_step_id
1030: ,p_name => 'P_SAL_REVIEW_PERIOD_FREQUENCY');
1031: --
1032: p_date_probation_end:= to_char(
1029: (p_transaction_step_id => l_transaction_step_id
1030: ,p_name => 'P_SAL_REVIEW_PERIOD_FREQUENCY');
1031: --
1032: p_date_probation_end:= to_char(
1033: hr_transaction_api.get_date_value
1034: (p_transaction_step_id => l_transaction_step_id
1035: ,p_name => 'P_DATE_PROBATION_END'), g_date_format);
1036: --
1037: p_probation_period:=
1034: (p_transaction_step_id => l_transaction_step_id
1035: ,p_name => 'P_DATE_PROBATION_END'), g_date_format);
1036: --
1037: p_probation_period:=
1038: hr_transaction_api.get_number_value
1039: (p_transaction_step_id => l_transaction_step_id
1040: ,p_name => 'P_PROBATION_PERIOD');
1041: --
1042: p_probation_unit:=
1039: (p_transaction_step_id => l_transaction_step_id
1040: ,p_name => 'P_PROBATION_PERIOD');
1041: --
1042: p_probation_unit:=
1043: hr_transaction_api.get_varchar2_value
1044: (p_transaction_step_id => l_transaction_step_id
1045: ,p_name => 'P_PROBATION_UNIT');
1046: --
1047: p_notice_period:=
1044: (p_transaction_step_id => l_transaction_step_id
1045: ,p_name => 'P_PROBATION_UNIT');
1046: --
1047: p_notice_period:=
1048: hr_transaction_api.get_number_value
1049: (p_transaction_step_id => l_transaction_step_id
1050: ,p_name => 'P_NOTICE_PERIOD');
1051: --
1052: p_notice_period_uom:=
1049: (p_transaction_step_id => l_transaction_step_id
1050: ,p_name => 'P_NOTICE_PERIOD');
1051: --
1052: p_notice_period_uom:=
1053: hr_transaction_api.get_varchar2_value
1054: (p_transaction_step_id => l_transaction_step_id
1055: ,p_name => 'P_NOTICE_PERIOD_UOM');
1056: --
1057: p_employee_category:=
1054: (p_transaction_step_id => l_transaction_step_id
1055: ,p_name => 'P_NOTICE_PERIOD_UOM');
1056: --
1057: p_employee_category:=
1058: hr_transaction_api.get_varchar2_value
1059: (p_transaction_step_id => l_transaction_step_id
1060: ,p_name => 'P_EMPLOYEE_CATEGORY');
1061: --
1062: p_work_at_home:=
1059: (p_transaction_step_id => l_transaction_step_id
1060: ,p_name => 'P_EMPLOYEE_CATEGORY');
1061: --
1062: p_work_at_home:=
1063: hr_transaction_api.get_varchar2_value
1064: (p_transaction_step_id => l_transaction_step_id
1065: ,p_name => 'P_WORK_AT_HOME');
1066: --
1067: p_job_post_source_name:=
1064: (p_transaction_step_id => l_transaction_step_id
1065: ,p_name => 'P_WORK_AT_HOME');
1066: --
1067: p_job_post_source_name:=
1068: hr_transaction_api.get_varchar2_value
1069: (p_transaction_step_id => l_transaction_step_id
1070: ,p_name => 'P_JOB_POST_SOURCE_NAME');
1071: --
1072: p_perf_review_period:= to_char(
1069: (p_transaction_step_id => l_transaction_step_id
1070: ,p_name => 'P_JOB_POST_SOURCE_NAME');
1071: --
1072: p_perf_review_period:= to_char(
1073: hr_transaction_api.get_number_value
1074: (p_transaction_step_id => l_transaction_step_id
1075: ,p_name => 'P_PERF_REVIEW_PERIOD'));
1076: --
1077: p_perf_review_period_frequency:=
1074: (p_transaction_step_id => l_transaction_step_id
1075: ,p_name => 'P_PERF_REVIEW_PERIOD'));
1076: --
1077: p_perf_review_period_frequency:=
1078: hr_transaction_api.get_varchar2_value
1079: (p_transaction_step_id => l_transaction_step_id
1080: ,p_name => 'P_PERF_REVIEW_PERIOD_FREQUENCY');
1081: --
1082: p_internal_address_line:=
1079: (p_transaction_step_id => l_transaction_step_id
1080: ,p_name => 'P_PERF_REVIEW_PERIOD_FREQUENCY');
1081: --
1082: p_internal_address_line:=
1083: hr_transaction_api.get_varchar2_value
1084: (p_transaction_step_id => l_transaction_step_id
1085: ,p_name => 'P_INTERNAL_ADDRESS_LINE');
1086: --
1087: p_payroll_id:=
1084: (p_transaction_step_id => l_transaction_step_id
1085: ,p_name => 'P_INTERNAL_ADDRESS_LINE');
1086: --
1087: p_payroll_id:=
1088: to_char(hr_transaction_api.get_number_value
1089: (p_transaction_step_id => l_transaction_step_id
1090: ,p_name => 'P_PAYROLL_ID'));
1091: --
1092: p_pay_basis_id:=
1089: (p_transaction_step_id => l_transaction_step_id
1090: ,p_name => 'P_PAYROLL_ID'));
1091: --
1092: p_pay_basis_id:=
1093: to_char(hr_transaction_api.get_number_value
1094: (p_transaction_step_id => l_transaction_step_id
1095: ,p_name => 'P_PAY_BASIS_ID'));
1096: --
1097: p_contract_id:=
1094: (p_transaction_step_id => l_transaction_step_id
1095: ,p_name => 'P_PAY_BASIS_ID'));
1096: --
1097: p_contract_id:=
1098: to_char(hr_transaction_api.get_number_value
1099: (p_transaction_step_id => l_transaction_step_id
1100: ,p_name => 'P_CONTRACT_ID'));
1101: --
1102: p_establishment_id:=
1099: (p_transaction_step_id => l_transaction_step_id
1100: ,p_name => 'P_CONTRACT_ID'));
1101: --
1102: p_establishment_id:=
1103: to_char(hr_transaction_api.get_number_value
1104: (p_transaction_step_id => l_transaction_step_id
1105: ,p_name => 'P_ESTABLISHMENT_ID'));
1106: --
1107: p_cagr_grade_def_id:=
1104: (p_transaction_step_id => l_transaction_step_id
1105: ,p_name => 'P_ESTABLISHMENT_ID'));
1106: --
1107: p_cagr_grade_def_id:=
1108: to_char(hr_transaction_api.get_number_value
1109: (p_transaction_step_id => l_transaction_step_id
1110: ,p_name => 'P_CAGR_GRADE_DEF_ID'));
1111: --
1112: p_collective_agreement_id:=
1109: (p_transaction_step_id => l_transaction_step_id
1110: ,p_name => 'P_CAGR_GRADE_DEF_ID'));
1111: --
1112: p_collective_agreement_id:=
1113: to_char(hr_transaction_api.get_number_value
1114: (p_transaction_step_id => l_transaction_step_id
1115: ,p_name => 'P_COLLECTIVE_AGREEMENT_ID'));
1116: --
1117: p_cagr_id_flex_num:=
1114: (p_transaction_step_id => l_transaction_step_id
1115: ,p_name => 'P_COLLECTIVE_AGREEMENT_ID'));
1116: --
1117: p_cagr_id_flex_num:=
1118: to_char(hr_transaction_api.get_number_value
1119: (p_transaction_step_id => l_transaction_step_id
1120: ,p_name => 'P_CAGR_ID_FLEX_NUM'));
1121: --
1122: p_display_org:=
1119: (p_transaction_step_id => l_transaction_step_id
1120: ,p_name => 'P_CAGR_ID_FLEX_NUM'));
1121: --
1122: p_display_org:=
1123: hr_transaction_api.get_varchar2_value
1124: (p_transaction_step_id => l_transaction_step_id
1125: ,p_name => 'P_DISPLAY_ORG');
1126: --
1127: p_display_job:=
1124: (p_transaction_step_id => l_transaction_step_id
1125: ,p_name => 'P_DISPLAY_ORG');
1126: --
1127: p_display_job:=
1128: hr_transaction_api.get_varchar2_value
1129: (p_transaction_step_id => l_transaction_step_id
1130: ,p_name => 'P_DISPLAY_JOB');
1131: --
1132: p_display_pos:=
1129: (p_transaction_step_id => l_transaction_step_id
1130: ,p_name => 'P_DISPLAY_JOB');
1131: --
1132: p_display_pos:=
1133: hr_transaction_api.get_varchar2_value
1134: (p_transaction_step_id => l_transaction_step_id
1135: ,p_name => 'P_DISPLAY_POS');
1136: --
1137: p_display_grade:=
1134: (p_transaction_step_id => l_transaction_step_id
1135: ,p_name => 'P_DISPLAY_POS');
1136: --
1137: p_display_grade:=
1138: hr_transaction_api.get_varchar2_value
1139: (p_transaction_step_id => l_transaction_step_id
1140: ,p_name => 'P_DISPLAY_GRADE');
1141: --
1142: p_display_ass_status:=
1139: (p_transaction_step_id => l_transaction_step_id
1140: ,p_name => 'P_DISPLAY_GRADE');
1141: --
1142: p_display_ass_status:=
1143: hr_transaction_api.get_varchar2_value
1144: (p_transaction_step_id => l_transaction_step_id
1145: ,p_name => 'P_DISPLAY_ASS_STATUS');
1146: --
1147: p_title:=
1144: (p_transaction_step_id => l_transaction_step_id
1145: ,p_name => 'P_DISPLAY_ASS_STATUS');
1146: --
1147: p_title:=
1148: hr_transaction_api.get_varchar2_value
1149: (p_transaction_step_id => l_transaction_step_id
1150: ,p_name => 'P_TITLE');
1151: --
1152: p_project_title:=
1149: (p_transaction_step_id => l_transaction_step_id
1150: ,p_name => 'P_TITLE');
1151: --
1152: p_project_title:=
1153: hr_transaction_api.get_varchar2_value
1154: (p_transaction_step_id => l_transaction_step_id
1155: ,p_name => 'P_PROJECT_TITLE');
1156: --
1157: p_source_type:=
1154: (p_transaction_step_id => l_transaction_step_id
1155: ,p_name => 'P_PROJECT_TITLE');
1156: --
1157: p_source_type:=
1158: hr_transaction_api.get_varchar2_value
1159: (p_transaction_step_id => l_transaction_step_id
1160: ,p_name => 'P_SOURCE_TYPE');
1161: --
1162: p_vendor_assignment_number:=
1159: (p_transaction_step_id => l_transaction_step_id
1160: ,p_name => 'P_SOURCE_TYPE');
1161: --
1162: p_vendor_assignment_number:=
1163: hr_transaction_api.get_varchar2_value
1164: (p_transaction_step_id => l_transaction_step_id
1165: ,p_name => 'P_VENDOR_ASSIGNMENT_NUMBER');
1166: --
1167: p_vendor_employee_number:=
1164: (p_transaction_step_id => l_transaction_step_id
1165: ,p_name => 'P_VENDOR_ASSIGNMENT_NUMBER');
1166: --
1167: p_vendor_employee_number:=
1168: hr_transaction_api.get_varchar2_value
1169: (p_transaction_step_id => l_transaction_step_id
1170: ,p_name => 'P_VENDOR_EMPLOYEE_NUMBER');
1171: --
1172: p_default_code_comb_id := to_char(
1169: (p_transaction_step_id => l_transaction_step_id
1170: ,p_name => 'P_VENDOR_EMPLOYEE_NUMBER');
1171: --
1172: p_default_code_comb_id := to_char(
1173: hr_transaction_api.get_number_value
1174: (p_transaction_step_id => l_transaction_step_id
1175: ,p_name => 'P_DEFAULT_CODE_COMB_ID'));
1176: --
1177: p_set_of_books_id := to_char(
1174: (p_transaction_step_id => l_transaction_step_id
1175: ,p_name => 'P_DEFAULT_CODE_COMB_ID'));
1176: --
1177: p_set_of_books_id := to_char(
1178: hr_transaction_api.get_number_value
1179: (p_transaction_step_id => l_transaction_step_id
1180: ,p_name => 'P_SET_OF_BOOKS_ID'));
1181: --
1182: p_vendor_id := to_char(
1179: (p_transaction_step_id => l_transaction_step_id
1180: ,p_name => 'P_SET_OF_BOOKS_ID'));
1181: --
1182: p_vendor_id := to_char(
1183: hr_transaction_api.get_number_value
1184: (p_transaction_step_id => l_transaction_step_id
1185: ,p_name => 'P_VENDOR_ID'));
1186: --
1187: open csr_vendor_name(to_number(p_vendor_id));
1188: fetch csr_vendor_name into p_vendor_name;
1189: close csr_vendor_name;
1190: --
1191: p_po_header_id := to_char(
1192: hr_transaction_api.get_number_value
1193: (p_transaction_step_id => l_transaction_step_id
1194: ,p_name => 'P_PO_HEADER_ID'));
1195: --
1196: open csr_po_number(to_number(p_po_header_id));
1197: fetch csr_po_number into p_po_number;
1198: close csr_po_number;
1199:
1200: p_po_line_id := to_char(
1201: hr_transaction_api.get_number_value
1202: (p_transaction_step_id => l_transaction_step_id
1203: ,p_name => 'P_PO_LINE_ID'));
1204: --
1205: open csr_po_line_number(to_number(p_po_line_id));
1206: fetch csr_po_line_number into p_po_line_number;
1207: close csr_po_line_number;
1208:
1209: p_vendor_site_id := to_char(
1210: hr_transaction_api.get_number_value
1211: (p_transaction_step_id => l_transaction_step_id
1212: ,p_name => 'P_VENDOR_SITE_ID'));
1213: --
1214: open csr_vendor_site_name(to_number(p_vendor_site_id));
1215: fetch csr_vendor_site_name into p_vendor_site_name;
1216: close csr_vendor_site_name;
1217:
1218: p_projected_asgn_end :=
1219: hr_transaction_api.get_date_value
1220: (p_transaction_step_id => l_transaction_step_id
1221: ,p_name => 'P_PROJ_ASGN_END');
1222:
1223: --
1222:
1223: --
1224:
1225: p_assignment_type:=
1226: hr_transaction_api.get_varchar2_value
1227: (p_transaction_step_id => l_transaction_step_id
1228: ,p_name => 'P_ASSIGNMENT_TYPE');
1229: --
1230: -- GSP changes
1228: ,p_name => 'P_ASSIGNMENT_TYPE');
1229: --
1230: -- GSP changes
1231: p_grade_ladder_pgm_id := to_char(
1232: hr_transaction_api.get_number_value
1233: (p_transaction_step_id => l_transaction_step_id
1234: ,p_name => 'P_GRADE_LADDER_PGM_ID'));
1235: -- End of GSP changes
1236:
1234: ,p_name => 'P_GRADE_LADDER_PGM_ID'));
1235: -- End of GSP changes
1236:
1237: --p_supervisor_assignment_id := to_char(
1238: -- hr_transaction_api.get_number_value
1239: -- (p_transaction_step_id => l_transaction_step_id
1240: -- ,p_name => 'P_SUPERVISOR_ASSIGNMENT_ID'));
1241: --
1242:
1346: begin
1347: --
1348: hr_utility.set_location('Entering:'||l_proc, 5);
1349: p_assignment_id:=
1350: hr_transaction_api.get_number_value
1351: (p_transaction_step_id => p_transaction_step_id
1352: ,p_name => 'P_ASSIGNMENT_ID');
1353: --
1354: p_business_group_id:=
1351: (p_transaction_step_id => p_transaction_step_id
1352: ,p_name => 'P_ASSIGNMENT_ID');
1353: --
1354: p_business_group_id:=
1355: hr_transaction_api.get_number_value
1356: (p_transaction_step_id => p_transaction_step_id
1357: ,p_name => 'P_BUSINESS_GROUP_ID');
1358: --
1359: p_effective_date:=
1356: (p_transaction_step_id => p_transaction_step_id
1357: ,p_name => 'P_BUSINESS_GROUP_ID');
1358: --
1359: p_effective_date:=
1360: hr_transaction_api.get_date_value
1361: (p_transaction_step_id => p_transaction_step_id
1362: ,p_name => 'P_EFFECTIVE_DATE');
1363: --
1364: p_object_version_number :=
1361: (p_transaction_step_id => p_transaction_step_id
1362: ,p_name => 'P_EFFECTIVE_DATE');
1363: --
1364: p_object_version_number :=
1365: hr_transaction_api.get_number_value
1366: (p_transaction_step_id => p_transaction_step_id
1367: ,p_name => 'P_OBJECT_VERSION_NUMBER');
1368: --
1369: p_position_id :=
1366: (p_transaction_step_id => p_transaction_step_id
1367: ,p_name => 'P_OBJECT_VERSION_NUMBER');
1368: --
1369: p_position_id :=
1370: hr_transaction_api.get_number_value
1371: (p_transaction_step_id => p_transaction_step_id
1372: ,p_name => 'P_POSITION_ID');
1373: --
1374: p_job_id :=
1371: (p_transaction_step_id => p_transaction_step_id
1372: ,p_name => 'P_POSITION_ID');
1373: --
1374: p_job_id :=
1375: hr_transaction_api.get_number_value
1376: (p_transaction_step_id => p_transaction_step_id
1377: ,p_name => 'P_JOB_ID');
1378: --
1379: p_grade_id :=
1376: (p_transaction_step_id => p_transaction_step_id
1377: ,p_name => 'P_JOB_ID');
1378: --
1379: p_grade_id :=
1380: hr_transaction_api.get_number_value
1381: (p_transaction_step_id => p_transaction_step_id
1382: ,p_name => 'P_GRADE_ID');
1383: --
1384: p_location_id :=
1381: (p_transaction_step_id => p_transaction_step_id
1382: ,p_name => 'P_GRADE_ID');
1383: --
1384: p_location_id :=
1385: hr_transaction_api.get_number_value
1386: (p_transaction_step_id => p_transaction_step_id
1387: ,p_name => 'P_LOCATION_ID');
1388: --
1389: p_employment_category :=
1386: (p_transaction_step_id => p_transaction_step_id
1387: ,p_name => 'P_LOCATION_ID');
1388: --
1389: p_employment_category :=
1390: hr_transaction_api.get_varchar2_value
1391: (p_transaction_step_id => p_transaction_step_id
1392: ,p_name => 'P_EMPLOYMENT_CATEGORY');
1393: --
1394: p_supervisor_id :=
1391: (p_transaction_step_id => p_transaction_step_id
1392: ,p_name => 'P_EMPLOYMENT_CATEGORY');
1393: --
1394: p_supervisor_id :=
1395: hr_transaction_api.get_number_value
1396: (p_transaction_step_id => p_transaction_step_id
1397: ,p_name => 'P_SUPERVISOR_ID');
1398: --
1399: p_manager_flag :=
1396: (p_transaction_step_id => p_transaction_step_id
1397: ,p_name => 'P_SUPERVISOR_ID');
1398: --
1399: p_manager_flag :=
1400: hr_transaction_api.get_varchar2_value
1401: (p_transaction_step_id => p_transaction_step_id
1402: ,p_name => 'P_MANAGER_FLAG');
1403: --
1404: p_normal_hours :=
1401: (p_transaction_step_id => p_transaction_step_id
1402: ,p_name => 'P_MANAGER_FLAG');
1403: --
1404: p_normal_hours :=
1405: hr_transaction_api.get_number_value
1406: (p_transaction_step_id => p_transaction_step_id
1407: ,p_name => 'P_NORMAL_HOURS');
1408: --
1409: p_frequency :=
1406: (p_transaction_step_id => p_transaction_step_id
1407: ,p_name => 'P_NORMAL_HOURS');
1408: --
1409: p_frequency :=
1410: hr_transaction_api.get_varchar2_value
1411: (p_transaction_step_id => p_transaction_step_id
1412: ,p_name => 'P_FREQUENCY');
1413: --
1414: p_time_normal_finish :=
1411: (p_transaction_step_id => p_transaction_step_id
1412: ,p_name => 'P_FREQUENCY');
1413: --
1414: p_time_normal_finish :=
1415: substr(hr_transaction_api.get_varchar2_value
1416: (p_transaction_step_id => p_transaction_step_id
1417: ,p_name => 'P_TIME_NORMAL_FINISH'),0,5);
1418: --
1419: p_time_normal_start :=
1416: (p_transaction_step_id => p_transaction_step_id
1417: ,p_name => 'P_TIME_NORMAL_FINISH'),0,5);
1418: --
1419: p_time_normal_start :=
1420: substr(hr_transaction_api.get_varchar2_value
1421: (p_transaction_step_id => p_transaction_step_id
1422: ,p_name => 'P_TIME_NORMAL_START'),0,5);
1423: --
1424: p_bargaining_unit_code :=
1421: (p_transaction_step_id => p_transaction_step_id
1422: ,p_name => 'P_TIME_NORMAL_START'),0,5);
1423: --
1424: p_bargaining_unit_code :=
1425: hr_transaction_api.get_varchar2_value
1426: (p_transaction_step_id => p_transaction_step_id
1427: ,p_name => 'P_BARGAINING_UNIT_CODE');
1428: --
1429: p_labour_union_member_flag :=
1426: (p_transaction_step_id => p_transaction_step_id
1427: ,p_name => 'P_BARGAINING_UNIT_CODE');
1428: --
1429: p_labour_union_member_flag :=
1430: hr_transaction_api.get_varchar2_value
1431: (p_transaction_step_id => p_transaction_step_id
1432: ,p_name => 'P_LABOUR_UNION_MEMBER_FLAG');
1433: --
1434: p_special_ceiling_step_id :=
1431: (p_transaction_step_id => p_transaction_step_id
1432: ,p_name => 'P_LABOUR_UNION_MEMBER_FLAG');
1433: --
1434: p_special_ceiling_step_id :=
1435: hr_transaction_api.get_number_value
1436: (p_transaction_step_id => p_transaction_step_id
1437: ,p_name => 'P_SPECIAL_CEILING_STEP_ID');
1438: --
1439: p_assignment_status_type_id :=
1436: (p_transaction_step_id => p_transaction_step_id
1437: ,p_name => 'P_SPECIAL_CEILING_STEP_ID');
1438: --
1439: p_assignment_status_type_id :=
1440: hr_transaction_api.get_number_value
1441: (p_transaction_step_id => p_transaction_step_id
1442: ,p_name => 'P_ASSIGNMENT_STATUS_TYPE_ID');
1443: --
1444: p_change_reason :=
1441: (p_transaction_step_id => p_transaction_step_id
1442: ,p_name => 'P_ASSIGNMENT_STATUS_TYPE_ID');
1443: --
1444: p_change_reason :=
1445: hr_transaction_api.get_varchar2_value
1446: (p_transaction_step_id => p_transaction_step_id
1447: ,p_name => 'P_CHANGE_REASON');
1448: --
1449: p_ass_attribute_category :=
1446: (p_transaction_step_id => p_transaction_step_id
1447: ,p_name => 'P_CHANGE_REASON');
1448: --
1449: p_ass_attribute_category :=
1450: hr_transaction_api.get_varchar2_value
1451: (p_transaction_step_id => p_transaction_step_id
1452: ,p_name => 'P_ASS_ATTRIBUTE_CATEGORY');
1453: --
1454: p_ass_attribute1 :=
1451: (p_transaction_step_id => p_transaction_step_id
1452: ,p_name => 'P_ASS_ATTRIBUTE_CATEGORY');
1453: --
1454: p_ass_attribute1 :=
1455: hr_transaction_api.get_varchar2_value
1456: (p_transaction_step_id => p_transaction_step_id
1457: ,p_name => 'P_ASS_ATTRIBUTE1');
1458: --
1459: p_ass_attribute2 :=
1456: (p_transaction_step_id => p_transaction_step_id
1457: ,p_name => 'P_ASS_ATTRIBUTE1');
1458: --
1459: p_ass_attribute2 :=
1460: hr_transaction_api.get_varchar2_value
1461: (p_transaction_step_id => p_transaction_step_id
1462: ,p_name => 'P_ASS_ATTRIBUTE2');
1463: --
1464: p_ass_attribute3 :=
1461: (p_transaction_step_id => p_transaction_step_id
1462: ,p_name => 'P_ASS_ATTRIBUTE2');
1463: --
1464: p_ass_attribute3 :=
1465: hr_transaction_api.get_varchar2_value
1466: (p_transaction_step_id => p_transaction_step_id
1467: ,p_name => 'P_ASS_ATTRIBUTE3');
1468: --
1469: p_ass_attribute4 :=
1466: (p_transaction_step_id => p_transaction_step_id
1467: ,p_name => 'P_ASS_ATTRIBUTE3');
1468: --
1469: p_ass_attribute4 :=
1470: hr_transaction_api.get_varchar2_value
1471: (p_transaction_step_id => p_transaction_step_id
1472: ,p_name => 'P_ASS_ATTRIBUTE4');
1473: --
1474: p_ass_attribute5 :=
1471: (p_transaction_step_id => p_transaction_step_id
1472: ,p_name => 'P_ASS_ATTRIBUTE4');
1473: --
1474: p_ass_attribute5 :=
1475: hr_transaction_api.get_varchar2_value
1476: (p_transaction_step_id => p_transaction_step_id
1477: ,p_name => 'P_ASS_ATTRIBUTE5');
1478: --
1479: p_ass_attribute6 :=
1476: (p_transaction_step_id => p_transaction_step_id
1477: ,p_name => 'P_ASS_ATTRIBUTE5');
1478: --
1479: p_ass_attribute6 :=
1480: hr_transaction_api.get_varchar2_value
1481: (p_transaction_step_id => p_transaction_step_id
1482: ,p_name => 'P_ASS_ATTRIBUTE6');
1483: --
1484: p_ass_attribute7 :=
1481: (p_transaction_step_id => p_transaction_step_id
1482: ,p_name => 'P_ASS_ATTRIBUTE6');
1483: --
1484: p_ass_attribute7 :=
1485: hr_transaction_api.get_varchar2_value
1486: (p_transaction_step_id => p_transaction_step_id
1487: ,p_name => 'P_ASS_ATTRIBUTE7');
1488: --
1489: p_ass_attribute8 :=
1486: (p_transaction_step_id => p_transaction_step_id
1487: ,p_name => 'P_ASS_ATTRIBUTE7');
1488: --
1489: p_ass_attribute8 :=
1490: hr_transaction_api.get_varchar2_value
1491: (p_transaction_step_id => p_transaction_step_id
1492: ,p_name => 'P_ASS_ATTRIBUTE8');
1493: --
1494: p_ass_attribute9 :=
1491: (p_transaction_step_id => p_transaction_step_id
1492: ,p_name => 'P_ASS_ATTRIBUTE8');
1493: --
1494: p_ass_attribute9 :=
1495: hr_transaction_api.get_varchar2_value
1496: (p_transaction_step_id => p_transaction_step_id
1497: ,p_name => 'P_ASS_ATTRIBUTE9');
1498: --
1499: p_ass_attribute10 :=
1496: (p_transaction_step_id => p_transaction_step_id
1497: ,p_name => 'P_ASS_ATTRIBUTE9');
1498: --
1499: p_ass_attribute10 :=
1500: hr_transaction_api.get_varchar2_value
1501: (p_transaction_step_id => p_transaction_step_id
1502: ,p_name => 'P_ASS_ATTRIBUTE10');
1503: --
1504: p_ass_attribute11 :=
1501: (p_transaction_step_id => p_transaction_step_id
1502: ,p_name => 'P_ASS_ATTRIBUTE10');
1503: --
1504: p_ass_attribute11 :=
1505: hr_transaction_api.get_varchar2_value
1506: (p_transaction_step_id => p_transaction_step_id
1507: ,p_name => 'P_ASS_ATTRIBUTE11');
1508: --
1509: p_ass_attribute12 :=
1506: (p_transaction_step_id => p_transaction_step_id
1507: ,p_name => 'P_ASS_ATTRIBUTE11');
1508: --
1509: p_ass_attribute12 :=
1510: hr_transaction_api.get_varchar2_value
1511: (p_transaction_step_id => p_transaction_step_id
1512: ,p_name => 'P_ASS_ATTRIBUTE12');
1513: --
1514: p_ass_attribute13 :=
1511: (p_transaction_step_id => p_transaction_step_id
1512: ,p_name => 'P_ASS_ATTRIBUTE12');
1513: --
1514: p_ass_attribute13 :=
1515: hr_transaction_api.get_varchar2_value
1516: (p_transaction_step_id => p_transaction_step_id
1517: ,p_name => 'P_ASS_ATTRIBUTE13');
1518: --
1519: p_ass_attribute14 :=
1516: (p_transaction_step_id => p_transaction_step_id
1517: ,p_name => 'P_ASS_ATTRIBUTE13');
1518: --
1519: p_ass_attribute14 :=
1520: hr_transaction_api.get_varchar2_value
1521: (p_transaction_step_id => p_transaction_step_id
1522: ,p_name => 'P_ASS_ATTRIBUTE14');
1523: --
1524: p_ass_attribute15 :=
1521: (p_transaction_step_id => p_transaction_step_id
1522: ,p_name => 'P_ASS_ATTRIBUTE14');
1523: --
1524: p_ass_attribute15 :=
1525: hr_transaction_api.get_varchar2_value
1526: (p_transaction_step_id => p_transaction_step_id
1527: ,p_name => 'P_ASS_ATTRIBUTE15');
1528: --
1529: p_ass_attribute16 :=
1526: (p_transaction_step_id => p_transaction_step_id
1527: ,p_name => 'P_ASS_ATTRIBUTE15');
1528: --
1529: p_ass_attribute16 :=
1530: hr_transaction_api.get_varchar2_value
1531: (p_transaction_step_id => p_transaction_step_id
1532: ,p_name => 'P_ASS_ATTRIBUTE16');
1533: --
1534: p_ass_attribute17 :=
1531: (p_transaction_step_id => p_transaction_step_id
1532: ,p_name => 'P_ASS_ATTRIBUTE16');
1533: --
1534: p_ass_attribute17 :=
1535: hr_transaction_api.get_varchar2_value
1536: (p_transaction_step_id => p_transaction_step_id
1537: ,p_name => 'P_ASS_ATTRIBUTE17');
1538: --
1539: p_ass_attribute18 :=
1536: (p_transaction_step_id => p_transaction_step_id
1537: ,p_name => 'P_ASS_ATTRIBUTE17');
1538: --
1539: p_ass_attribute18 :=
1540: hr_transaction_api.get_varchar2_value
1541: (p_transaction_step_id => p_transaction_step_id
1542: ,p_name => 'P_ASS_ATTRIBUTE18');
1543: --
1544: p_ass_attribute19 :=
1541: (p_transaction_step_id => p_transaction_step_id
1542: ,p_name => 'P_ASS_ATTRIBUTE18');
1543: --
1544: p_ass_attribute19 :=
1545: hr_transaction_api.get_varchar2_value
1546: (p_transaction_step_id => p_transaction_step_id
1547: ,p_name => 'P_ASS_ATTRIBUTE19');
1548: --
1549: p_ass_attribute20 :=
1546: (p_transaction_step_id => p_transaction_step_id
1547: ,p_name => 'P_ASS_ATTRIBUTE19');
1548: --
1549: p_ass_attribute20 :=
1550: hr_transaction_api.get_varchar2_value
1551: (p_transaction_step_id => p_transaction_step_id
1552: ,p_name => 'P_ASS_ATTRIBUTE20');
1553: --
1554: p_ass_attribute21 :=
1551: (p_transaction_step_id => p_transaction_step_id
1552: ,p_name => 'P_ASS_ATTRIBUTE20');
1553: --
1554: p_ass_attribute21 :=
1555: hr_transaction_api.get_varchar2_value
1556: (p_transaction_step_id => p_transaction_step_id
1557: ,p_name => 'P_ASS_ATTRIBUTE21');
1558: --
1559: p_ass_attribute22 :=
1556: (p_transaction_step_id => p_transaction_step_id
1557: ,p_name => 'P_ASS_ATTRIBUTE21');
1558: --
1559: p_ass_attribute22 :=
1560: hr_transaction_api.get_varchar2_value
1561: (p_transaction_step_id => p_transaction_step_id
1562: ,p_name => 'P_ASS_ATTRIBUTE22');
1563: --
1564: p_ass_attribute23 :=
1561: (p_transaction_step_id => p_transaction_step_id
1562: ,p_name => 'P_ASS_ATTRIBUTE22');
1563: --
1564: p_ass_attribute23 :=
1565: hr_transaction_api.get_varchar2_value
1566: (p_transaction_step_id => p_transaction_step_id
1567: ,p_name => 'P_ASS_ATTRIBUTE23');
1568: --
1569: p_ass_attribute24 :=
1566: (p_transaction_step_id => p_transaction_step_id
1567: ,p_name => 'P_ASS_ATTRIBUTE23');
1568: --
1569: p_ass_attribute24 :=
1570: hr_transaction_api.get_varchar2_value
1571: (p_transaction_step_id => p_transaction_step_id
1572: ,p_name => 'P_ASS_ATTRIBUTE24');
1573: --
1574: p_ass_attribute25 :=
1571: (p_transaction_step_id => p_transaction_step_id
1572: ,p_name => 'P_ASS_ATTRIBUTE24');
1573: --
1574: p_ass_attribute25 :=
1575: hr_transaction_api.get_varchar2_value
1576: (p_transaction_step_id => p_transaction_step_id
1577: ,p_name => 'P_ASS_ATTRIBUTE25');
1578: --
1579: p_ass_attribute26 :=
1576: (p_transaction_step_id => p_transaction_step_id
1577: ,p_name => 'P_ASS_ATTRIBUTE25');
1578: --
1579: p_ass_attribute26 :=
1580: hr_transaction_api.get_varchar2_value
1581: (p_transaction_step_id => p_transaction_step_id
1582: ,p_name => 'P_ASS_ATTRIBUTE26');
1583: --
1584: p_ass_attribute27 :=
1581: (p_transaction_step_id => p_transaction_step_id
1582: ,p_name => 'P_ASS_ATTRIBUTE26');
1583: --
1584: p_ass_attribute27 :=
1585: hr_transaction_api.get_varchar2_value
1586: (p_transaction_step_id => p_transaction_step_id
1587: ,p_name => 'P_ASS_ATTRIBUTE27');
1588: --
1589: p_ass_attribute28 :=
1586: (p_transaction_step_id => p_transaction_step_id
1587: ,p_name => 'P_ASS_ATTRIBUTE27');
1588: --
1589: p_ass_attribute28 :=
1590: hr_transaction_api.get_varchar2_value
1591: (p_transaction_step_id => p_transaction_step_id
1592: ,p_name => 'P_ASS_ATTRIBUTE28');
1593: --
1594: p_ass_attribute29 :=
1591: (p_transaction_step_id => p_transaction_step_id
1592: ,p_name => 'P_ASS_ATTRIBUTE28');
1593: --
1594: p_ass_attribute29 :=
1595: hr_transaction_api.get_varchar2_value
1596: (p_transaction_step_id => p_transaction_step_id
1597: ,p_name => 'P_ASS_ATTRIBUTE29');
1598: --
1599: p_ass_attribute30 :=
1596: (p_transaction_step_id => p_transaction_step_id
1597: ,p_name => 'P_ASS_ATTRIBUTE29');
1598: --
1599: p_ass_attribute30 :=
1600: hr_transaction_api.get_varchar2_value
1601: (p_transaction_step_id => p_transaction_step_id
1602: ,p_name => 'P_ASS_ATTRIBUTE30');
1603:
1604: p_people_group_id:=
1601: (p_transaction_step_id => p_transaction_step_id
1602: ,p_name => 'P_ASS_ATTRIBUTE30');
1603:
1604: p_people_group_id:=
1605: hr_transaction_api.get_number_value
1606: (p_transaction_step_id => p_transaction_step_id
1607: ,p_name => 'P_PEOPLE_GROUP_ID');
1608: --
1609: p_soft_coding_keyflex_id:=
1606: (p_transaction_step_id => p_transaction_step_id
1607: ,p_name => 'P_PEOPLE_GROUP_ID');
1608: --
1609: p_soft_coding_keyflex_id:=
1610: hr_transaction_api.get_number_value
1611: (p_transaction_step_id => p_transaction_step_id
1612: ,p_name => 'P_SOFT_CODING_KEYFLEX_ID');
1613: --
1614: p_sal_review_period:=
1611: (p_transaction_step_id => p_transaction_step_id
1612: ,p_name => 'P_SOFT_CODING_KEYFLEX_ID');
1613: --
1614: p_sal_review_period:=
1615: hr_transaction_api.get_number_value
1616: (p_transaction_step_id => p_transaction_step_id
1617: ,p_name => 'P_SAL_REVIEW_PERIOD');
1618: --
1619: p_sal_review_period_frequency:=
1616: (p_transaction_step_id => p_transaction_step_id
1617: ,p_name => 'P_SAL_REVIEW_PERIOD');
1618: --
1619: p_sal_review_period_frequency:=
1620: hr_transaction_api.get_varchar2_value
1621: (p_transaction_step_id => p_transaction_step_id
1622: ,p_name => 'P_SAL_REVIEW_PERIOD_FREQUENCY');
1623: --
1624: p_date_probation_end :=
1621: (p_transaction_step_id => p_transaction_step_id
1622: ,p_name => 'P_SAL_REVIEW_PERIOD_FREQUENCY');
1623: --
1624: p_date_probation_end :=
1625: hr_transaction_api.get_date_value
1626: (p_transaction_step_id => p_transaction_step_id
1627: ,p_name => 'P_DATE_PROBATION_END');
1628: --
1629: p_probation_period :=
1626: (p_transaction_step_id => p_transaction_step_id
1627: ,p_name => 'P_DATE_PROBATION_END');
1628: --
1629: p_probation_period :=
1630: hr_transaction_api.get_number_value
1631: (p_transaction_step_id => p_transaction_step_id
1632: ,p_name => 'P_PROBATION_PERIOD');
1633: --
1634: p_probation_unit :=
1631: (p_transaction_step_id => p_transaction_step_id
1632: ,p_name => 'P_PROBATION_PERIOD');
1633: --
1634: p_probation_unit :=
1635: hr_transaction_api.get_varchar2_value
1636: (p_transaction_step_id => p_transaction_step_id
1637: ,p_name => 'P_PROBATION_UNIT');
1638: --
1639: p_notice_period :=
1636: (p_transaction_step_id => p_transaction_step_id
1637: ,p_name => 'P_PROBATION_UNIT');
1638: --
1639: p_notice_period :=
1640: hr_transaction_api.get_number_value
1641: (p_transaction_step_id => p_transaction_step_id
1642: ,p_name => 'P_NOTICE_PERIOD');
1643: --
1644: p_notice_period_uom :=
1641: (p_transaction_step_id => p_transaction_step_id
1642: ,p_name => 'P_NOTICE_PERIOD');
1643: --
1644: p_notice_period_uom :=
1645: hr_transaction_api.get_varchar2_value
1646: (p_transaction_step_id => p_transaction_step_id
1647: ,p_name => 'P_NOTICE_PERIOD_UOM');
1648: --
1649: p_employee_category :=
1646: (p_transaction_step_id => p_transaction_step_id
1647: ,p_name => 'P_NOTICE_PERIOD_UOM');
1648: --
1649: p_employee_category :=
1650: hr_transaction_api.get_varchar2_value
1651: (p_transaction_step_id => p_transaction_step_id
1652: ,p_name => 'P_EMPLOYEE_CATEGORY');
1653: --
1654: p_work_at_home :=
1651: (p_transaction_step_id => p_transaction_step_id
1652: ,p_name => 'P_EMPLOYEE_CATEGORY');
1653: --
1654: p_work_at_home :=
1655: hr_transaction_api.get_varchar2_value
1656: (p_transaction_step_id => p_transaction_step_id
1657: ,p_name => 'P_WORK_AT_HOME');
1658: --
1659: p_job_post_source_name :=
1656: (p_transaction_step_id => p_transaction_step_id
1657: ,p_name => 'P_WORK_AT_HOME');
1658: --
1659: p_job_post_source_name :=
1660: hr_transaction_api.get_varchar2_value
1661: (p_transaction_step_id => p_transaction_step_id
1662: ,p_name => 'P_JOB_POST_SOURCE_NAME');
1663: --
1664: p_perf_review_period :=
1661: (p_transaction_step_id => p_transaction_step_id
1662: ,p_name => 'P_JOB_POST_SOURCE_NAME');
1663: --
1664: p_perf_review_period :=
1665: hr_transaction_api.get_number_value
1666: (p_transaction_step_id => p_transaction_step_id
1667: ,p_name => 'P_PERF_REVIEW_PERIOD');
1668: --
1669: p_perf_review_period_frequency :=
1666: (p_transaction_step_id => p_transaction_step_id
1667: ,p_name => 'P_PERF_REVIEW_PERIOD');
1668: --
1669: p_perf_review_period_frequency :=
1670: hr_transaction_api.get_varchar2_value
1671: (p_transaction_step_id => p_transaction_step_id
1672: ,p_name => 'P_PERF_REVIEW_PERIOD_FREQUENCY');
1673: --
1674: p_internal_address_line :=
1671: (p_transaction_step_id => p_transaction_step_id
1672: ,p_name => 'P_PERF_REVIEW_PERIOD_FREQUENCY');
1673: --
1674: p_internal_address_line :=
1675: hr_transaction_api.get_varchar2_value
1676: (p_transaction_step_id => p_transaction_step_id
1677: ,p_name => 'P_INTERNAL_ADDRESS_LINE');
1678: --
1679: p_payroll_id:=
1676: (p_transaction_step_id => p_transaction_step_id
1677: ,p_name => 'P_INTERNAL_ADDRESS_LINE');
1678: --
1679: p_payroll_id:=
1680: hr_transaction_api.get_number_value
1681: (p_transaction_step_id => p_transaction_step_id
1682: ,p_name => 'P_PAYROLL_ID');
1683: --
1684: p_pay_basis_id:=
1681: (p_transaction_step_id => p_transaction_step_id
1682: ,p_name => 'P_PAYROLL_ID');
1683: --
1684: p_pay_basis_id:=
1685: hr_transaction_api.get_number_value
1686: (p_transaction_step_id => p_transaction_step_id
1687: ,p_name => 'P_PAY_BASIS_ID');
1688: --
1689: p_contract_id:=
1686: (p_transaction_step_id => p_transaction_step_id
1687: ,p_name => 'P_PAY_BASIS_ID');
1688: --
1689: p_contract_id:=
1690: hr_transaction_api.get_number_value
1691: (p_transaction_step_id => p_transaction_step_id
1692: ,p_name => 'P_CONTRACT_ID');
1693: --
1694: p_establishment_id:=
1691: (p_transaction_step_id => p_transaction_step_id
1692: ,p_name => 'P_CONTRACT_ID');
1693: --
1694: p_establishment_id:=
1695: hr_transaction_api.get_number_value
1696: (p_transaction_step_id => p_transaction_step_id
1697: ,p_name => 'P_ESTABLISHMENT_ID');
1698: --
1699: p_cagr_grade_def_id:=
1696: (p_transaction_step_id => p_transaction_step_id
1697: ,p_name => 'P_ESTABLISHMENT_ID');
1698: --
1699: p_cagr_grade_def_id:=
1700: hr_transaction_api.get_number_value
1701: (p_transaction_step_id => p_transaction_step_id
1702: ,p_name => 'P_CAGR_GRADE_DEF_ID');
1703: --
1704: p_collective_agreement_id:=
1701: (p_transaction_step_id => p_transaction_step_id
1702: ,p_name => 'P_CAGR_GRADE_DEF_ID');
1703: --
1704: p_collective_agreement_id:=
1705: hr_transaction_api.get_number_value
1706: (p_transaction_step_id => p_transaction_step_id
1707: ,p_name => 'P_COLLECTIVE_AGREEMENT_ID');
1708: --
1709: p_cagr_id_flex_num:=
1706: (p_transaction_step_id => p_transaction_step_id
1707: ,p_name => 'P_COLLECTIVE_AGREEMENT_ID');
1708: --
1709: p_cagr_id_flex_num:=
1710: hr_transaction_api.get_number_value
1711: (p_transaction_step_id => p_transaction_step_id
1712: ,p_name => 'P_CAGR_ID_FLEX_NUM');
1713: --
1714: p_display_org:=
1711: (p_transaction_step_id => p_transaction_step_id
1712: ,p_name => 'P_CAGR_ID_FLEX_NUM');
1713: --
1714: p_display_org:=
1715: hr_transaction_api.get_varchar2_value
1716: (p_transaction_step_id => p_transaction_step_id
1717: ,p_name => 'P_DISPLAY_ORG');
1718: --
1719: p_display_job:=
1716: (p_transaction_step_id => p_transaction_step_id
1717: ,p_name => 'P_DISPLAY_ORG');
1718: --
1719: p_display_job:=
1720: hr_transaction_api.get_varchar2_value
1721: (p_transaction_step_id => p_transaction_step_id
1722: ,p_name => 'P_DISPLAY_JOB');
1723: --
1724: p_display_pos:=
1721: (p_transaction_step_id => p_transaction_step_id
1722: ,p_name => 'P_DISPLAY_JOB');
1723: --
1724: p_display_pos:=
1725: hr_transaction_api.get_varchar2_value
1726: (p_transaction_step_id => p_transaction_step_id
1727: ,p_name => 'P_DISPLAY_POS');
1728: --
1729: p_display_grade:=
1726: (p_transaction_step_id => p_transaction_step_id
1727: ,p_name => 'P_DISPLAY_POS');
1728: --
1729: p_display_grade:=
1730: hr_transaction_api.get_varchar2_value
1731: (p_transaction_step_id => p_transaction_step_id
1732: ,p_name => 'P_DISPLAY_GRADE');
1733: --
1734: p_display_ass_status:=
1731: (p_transaction_step_id => p_transaction_step_id
1732: ,p_name => 'P_DISPLAY_GRADE');
1733: --
1734: p_display_ass_status:=
1735: hr_transaction_api.get_varchar2_value
1736: (p_transaction_step_id => p_transaction_step_id
1737: ,p_name => 'P_DISPLAY_ASS_STATUS');
1738: --
1739: --
1737: ,p_name => 'P_DISPLAY_ASS_STATUS');
1738: --
1739: --
1740: p_title:=
1741: hr_transaction_api.get_varchar2_value
1742: (p_transaction_step_id => p_transaction_step_id
1743: ,p_name => 'P_TITLE');
1744: --
1745: p_project_title:=
1742: (p_transaction_step_id => p_transaction_step_id
1743: ,p_name => 'P_TITLE');
1744: --
1745: p_project_title:=
1746: hr_transaction_api.get_varchar2_value
1747: (p_transaction_step_id => p_transaction_step_id
1748: ,p_name => 'P_PROJECT_TITLE');
1749: --
1750: p_source_type:=
1747: (p_transaction_step_id => p_transaction_step_id
1748: ,p_name => 'P_PROJECT_TITLE');
1749: --
1750: p_source_type:=
1751: hr_transaction_api.get_varchar2_value
1752: (p_transaction_step_id => p_transaction_step_id
1753: ,p_name => 'P_SOURCE_TYPE');
1754: --
1755: p_vendor_assignment_number:=
1752: (p_transaction_step_id => p_transaction_step_id
1753: ,p_name => 'P_SOURCE_TYPE');
1754: --
1755: p_vendor_assignment_number:=
1756: hr_transaction_api.get_varchar2_value
1757: (p_transaction_step_id => p_transaction_step_id
1758: ,p_name => 'P_VENDOR_ASSIGNMENT_NUMBER');
1759: --
1760: p_vendor_employee_number:=
1757: (p_transaction_step_id => p_transaction_step_id
1758: ,p_name => 'P_VENDOR_ASSIGNMENT_NUMBER');
1759: --
1760: p_vendor_employee_number:=
1761: hr_transaction_api.get_varchar2_value
1762: (p_transaction_step_id => p_transaction_step_id
1763: ,p_name => 'P_VENDOR_EMPLOYEE_NUMBER');
1764: --
1765: p_default_code_comb_id :=
1762: (p_transaction_step_id => p_transaction_step_id
1763: ,p_name => 'P_VENDOR_EMPLOYEE_NUMBER');
1764: --
1765: p_default_code_comb_id :=
1766: hr_transaction_api.get_number_value
1767: (p_transaction_step_id => p_transaction_step_id
1768: ,p_name => 'P_DEFAULT_CODE_COMB_ID');
1769: --
1770: p_set_of_books_id :=
1767: (p_transaction_step_id => p_transaction_step_id
1768: ,p_name => 'P_DEFAULT_CODE_COMB_ID');
1769: --
1770: p_set_of_books_id :=
1771: hr_transaction_api.get_number_value
1772: (p_transaction_step_id => p_transaction_step_id
1773: ,p_name => 'P_SET_OF_BOOKS_ID');
1774: --
1775: p_vendor_id :=
1772: (p_transaction_step_id => p_transaction_step_id
1773: ,p_name => 'P_SET_OF_BOOKS_ID');
1774: --
1775: p_vendor_id :=
1776: hr_transaction_api.get_number_value
1777: (p_transaction_step_id => p_transaction_step_id
1778: ,p_name => 'P_VENDOR_ID');
1779: --
1780: p_po_header_id :=
1777: (p_transaction_step_id => p_transaction_step_id
1778: ,p_name => 'P_VENDOR_ID');
1779: --
1780: p_po_header_id :=
1781: hr_transaction_api.get_number_value
1782: (p_transaction_step_id => p_transaction_step_id
1783: ,p_name => 'P_PO_HEADER_ID');
1784: --
1785: p_po_line_id :=
1782: (p_transaction_step_id => p_transaction_step_id
1783: ,p_name => 'P_PO_HEADER_ID');
1784: --
1785: p_po_line_id :=
1786: hr_transaction_api.get_number_value
1787: (p_transaction_step_id => p_transaction_step_id
1788: ,p_name => 'P_PO_LINE_ID');
1789: --
1790: p_vendor_site_id :=
1787: (p_transaction_step_id => p_transaction_step_id
1788: ,p_name => 'P_PO_LINE_ID');
1789: --
1790: p_vendor_site_id :=
1791: hr_transaction_api.get_number_value
1792: (p_transaction_step_id => p_transaction_step_id
1793: ,p_name => 'P_VENDOR_SITE_ID');
1794: --
1795:
1793: ,p_name => 'P_VENDOR_SITE_ID');
1794: --
1795:
1796: p_assignment_type:=
1797: hr_transaction_api.get_varchar2_value
1798: (p_transaction_step_id => p_transaction_step_id
1799: ,p_name => 'P_ASSIGNMENT_TYPE');
1800: --
1801: -- GSP changes
1799: ,p_name => 'P_ASSIGNMENT_TYPE');
1800: --
1801: -- GSP changes
1802: p_grade_ladder_pgm_id :=
1803: hr_transaction_api.get_number_value
1804: (p_transaction_step_id => p_transaction_step_id
1805: ,p_name => 'P_GRADE_LADDER_PGM_ID');
1806:
1807: -- End of GSP changes
1807: -- End of GSP changes
1808:
1809: --
1810: -- p_supervisor_assignment_id :=
1811: -- hr_transaction_api.get_number_value
1812: -- (p_transaction_step_id => p_transaction_step_id
1813: -- ,p_name => 'P_SUPERVISOR_ASSIGNMENT_ID');
1814: --
1815:
1813: -- ,p_name => 'P_SUPERVISOR_ASSIGNMENT_ID');
1814: --
1815:
1816: p_projected_asgn_end :=
1817: hr_transaction_api.get_date_value
1818: (p_transaction_step_id => p_transaction_step_id
1819: ,p_name => 'P_PROJ_ASGN_END');
1820:
1821: hr_utility.set_location('Exiting:'||l_proc, 15);
2568: open csr_per_step_id;
2569: fetch csr_per_step_id into l_per_step_id;
2570: close csr_per_step_id;
2571:
2572: l_asgn_change_mode := hr_transaction_api.get_varchar2_value
2573: (p_transaction_step_id => l_per_step_id
2574: ,p_name => 'P_ASGN_CHANGE_MODE');
2575:
2576: -- ----------------------------------------------------------------------------
2691: -- this is not the first time through.
2692: -- get the existing data from the transaction tables
2693: -- Bug 2365524: set the l_element_changed only if the transaction
2694: -- value is not null
2695: if hr_transaction_api.get_varchar2_value
2696: (p_transaction_step_id => l_transaction_step_id
2697: ,p_name => 'P_ELEMENT_CHANGED') is not null
2698: then
2699: l_element_changed :=
2696: (p_transaction_step_id => l_transaction_step_id
2697: ,p_name => 'P_ELEMENT_CHANGED') is not null
2698: then
2699: l_element_changed :=
2700: hr_transaction_api.get_varchar2_value
2701: (p_transaction_step_id => l_transaction_step_id
2702: ,p_name => 'P_ELEMENT_CHANGED');
2703: end if;
2704: --warning has already been raised.
2709: (p_transaction_step_id => l_transaction_step_id
2710: ,p_assignment_rec => l_old_assignment_rec);
2711: -- we pick up the old review page and activity_id lists to
2712: -- append to
2713: l_review_proc_call:= hr_transaction_api.get_varchar2_value
2714: (p_transaction_step_id => l_transaction_step_id
2715: ,p_name => 'P_REVIEW_PROC_CALL');
2716: l_activity_id_list:= hr_transaction_api.get_varchar2_value
2717: (p_transaction_step_id => l_transaction_step_id
2712: -- append to
2713: l_review_proc_call:= hr_transaction_api.get_varchar2_value
2714: (p_transaction_step_id => l_transaction_step_id
2715: ,p_name => 'P_REVIEW_PROC_CALL');
2716: l_activity_id_list:= hr_transaction_api.get_varchar2_value
2717: (p_transaction_step_id => l_transaction_step_id
2718: ,p_name => 'P_REVIEW_ACTID');
2719: -- check that effective_date and date track update mode
2720: -- have not changed
2729: (p_errorfield => null
2730: ,p_errormsg => fnd_message.get);*/
2731: end if;
2732: /*l_datetrack_update_mode:=
2733: hr_transaction_api.get_varchar2_value(
2734: p_transaction_step_id => l_transaction_step_id,
2735: p_name => 'P_DATETRACK_UPDATE_MODE'
2736: );*/
2737: if nvl(l_re_hire_flow,'N') = 'EX_EMP' then
4388: --
4389: -- To support applicant hire in New Hire process, we need to convert the applicant
4390: -- to employee then update the assignment and rollback the employee to applicant
4391:
4392: l_person_type_id := hr_transaction_api.get_number_value
4393: (p_transaction_step_id => l_per_step_id
4394: ,p_name => 'P_PERSON_TYPE_ID');
4395:
4396: if(l_db_assignment_rec.assignment_type = 'A' AND (l_asgn_change_mode is null OR
4812: -- create a transaction step
4813: --
4814:
4815: if (l_asgn_change_mode ='V' OR l_asgn_change_mode ='W') then
4816: hr_transaction_api.create_trans_step
4817: (p_validate => false
4818: ,p_creator_person_id => p_login_person_id
4819: ,p_transaction_id => l_transaction_id
4820: ,p_api_name => g_api_name
4828: else
4829: open process_order(l_item_type,l_item_key);
4830: fetch process_order into l_proc_order;
4831: if process_order%found then
4832: hr_transaction_api.create_trans_step
4833: (p_validate => false
4834: ,p_creator_person_id => p_login_person_id
4835: ,p_transaction_id => l_transaction_id
4836: ,p_api_name => g_api_name
4841: ,p_processing_order => l_proc_order - 1
4842: ,p_object_version_number => l_trns_object_version_number
4843: );
4844: else
4845: hr_transaction_api.create_transaction_step
4846: (p_validate => false
4847: ,p_creator_person_id => p_login_person_id
4848: ,p_transaction_id => l_transaction_id
4849: ,p_api_name => g_api_name
5748: ln_gsp_activity_id := -1;
5749:
5750: -- increment the process order for displaying pay rate page
5751: -- in review page
5752: hr_transaction_api.Set_Process_Order_String(p_item_type => l_item_type
5753: ,p_item_key => l_item_key
5754: ,p_actid => ln_gsp_activity_id);
5755:
5756: -- display warning only once, thats next time onwards
5831: end if;
5832:
5833: IF (ln_gsp_step_id IS NOT NULL)
5834: THEN
5835: lv_gsp_activity_id := hr_transaction_api.get_varchar2_value
5836: (p_transaction_step_id => ln_gsp_step_id
5837: ,p_name => 'P_REVIEW_ACTID');
5838: -- for Pay Rate GSP Txn, Review Activity Id is -1
5839: if((lv_gsp_activity_id is not null) and (to_number(lv_gsp_activity_id) = -1))
5880: end if;
5881:
5882: IF (ln_gsp_step_id IS NOT NULL)
5883: THEN
5884: lv_gsp_activity_id := hr_transaction_api.get_number_value
5885: (p_transaction_step_id => ln_gsp_step_id
5886: ,p_name => 'P_REVIEW_ACTID');
5887: if((lv_gsp_activity_id is not null) and (to_number(lv_gsp_activity_id) = -1))
5888: THEN
5961: begin
5962:
5963: hr_utility.set_location('Entering:'||l_proc, 5);
5964: l_assignment_id :=
5965: hr_transaction_api.get_number_value
5966: (p_transaction_step_id => p_transaction_step_id
5967: ,p_name => 'P_ASSIGNMENT_ID');
5968:
5969: open csr_new_object_number(l_assignment_id);
5970: fetch csr_new_object_number into l_new_object_number;
5971: close csr_new_object_number;
5972:
5973: l_old_object_number :=
5974: hr_transaction_api.get_number_value
5975: (p_transaction_step_id => p_transaction_step_id
5976: ,p_name => 'P_OBJECT_VERSION_NUMBER');
5977:
5978: if l_old_object_number <> l_new_object_number then
5976: ,p_name => 'P_OBJECT_VERSION_NUMBER');
5977:
5978: if l_old_object_number <> l_new_object_number then
5979: hr_utility.set_location('if l_old_object_number <> l_new_object_number then:'||l_proc,10);
5980: hr_transaction_api.set_number_value
5981: (p_transaction_step_id => p_transaction_step_id
5982: ,p_person_id => p_login_person_id
5983: ,p_name => 'P_OBJECT_VERSION_NUMBER'
5984: ,p_value => l_new_object_number);
6097: (p_transaction_step_id => p_transaction_step_id),g_date_format);
6098: end if;
6099: --
6100: l_datetrack_update_mode:=
6101: hr_transaction_api.get_varchar2_value
6102: (p_transaction_step_id => p_transaction_step_id
6103: ,p_name => 'P_DATETRACK_UPDATE_MODE');
6104:
6105: l_j_changed:=
6102: (p_transaction_step_id => p_transaction_step_id
6103: ,p_name => 'P_DATETRACK_UPDATE_MODE');
6104:
6105: l_j_changed:=
6106: hr_transaction_api.get_varchar2_value
6107: (p_transaction_step_id => p_transaction_step_id
6108: ,p_name => 'P_J_CHANGED');
6109:
6110: OPEN cur_txnStep (p_transaction_step_id);
6122: open csr_per_step_id;
6123: fetch csr_per_step_id into l_per_step_id;
6124: close csr_per_step_id;
6125:
6126: l_asgn_change_mode := hr_transaction_api.get_varchar2_value
6127: (p_transaction_step_id => l_per_step_id
6128: ,p_name => 'P_ASGN_CHANGE_MODE');
6129:
6130: l_person_type_id := hr_transaction_api.get_number_value
6126: l_asgn_change_mode := hr_transaction_api.get_varchar2_value
6127: (p_transaction_step_id => l_per_step_id
6128: ,p_name => 'P_ASGN_CHANGE_MODE');
6129:
6130: l_person_type_id := hr_transaction_api.get_number_value
6131: (p_transaction_step_id => l_per_step_id
6132: ,p_name => 'P_PERSON_TYPE_ID');
6133: --
6134: get_asg_from_tt
6183:
6184: if l_new_hire_appl_hire = 'Y' then
6185: hr_utility.set_location('if l_new_hire_appl_hire = Y then:'||l_proc,25);
6186: l_login_person_id:=
6187: hr_transaction_api.get_number_value
6188: (p_transaction_step_id => p_transaction_step_id
6189: ,p_name => 'P_LOGIN_PERSON_ID');
6190: end if;
6191:
7806: begin
7807: hr_utility.set_location('Entering:'||l_proc, 5);
7808:
7809: -- Fetch Original Manager Flag
7810: l_old_mgr_flag := hr_transaction_api.get_original_varchar2_value(p_transaction_step_id,'P_MANAGER_FLAG');
7811: -- Fetch Original Labour Union Flag
7812: l_old_labour_union_flag := hr_transaction_api.get_original_varchar2_value(p_transaction_step_id,'P_LABOUR_UNION_MEMBER_FLAG');
7813: l_old_organization_id := hr_transaction_api.get_number_value(p_transaction_step_id,'P_ORGANIZATION_ID');
7814: l_old_pay_basis_id := hr_transaction_api.get_original_number_value(p_transaction_step_id,'P_PAY_BASIS_ID');
7808:
7809: -- Fetch Original Manager Flag
7810: l_old_mgr_flag := hr_transaction_api.get_original_varchar2_value(p_transaction_step_id,'P_MANAGER_FLAG');
7811: -- Fetch Original Labour Union Flag
7812: l_old_labour_union_flag := hr_transaction_api.get_original_varchar2_value(p_transaction_step_id,'P_LABOUR_UNION_MEMBER_FLAG');
7813: l_old_organization_id := hr_transaction_api.get_number_value(p_transaction_step_id,'P_ORGANIZATION_ID');
7814: l_old_pay_basis_id := hr_transaction_api.get_original_number_value(p_transaction_step_id,'P_PAY_BASIS_ID');
7815: l_old_grade_id := hr_transaction_api.get_original_number_value(p_transaction_step_id,'P_GRADE_ID');
7816: l_primary_flag := hr_transaction_api.get_varchar2_value(p_transaction_step_id,'P_PRIMARY_FLAG');
7809: -- Fetch Original Manager Flag
7810: l_old_mgr_flag := hr_transaction_api.get_original_varchar2_value(p_transaction_step_id,'P_MANAGER_FLAG');
7811: -- Fetch Original Labour Union Flag
7812: l_old_labour_union_flag := hr_transaction_api.get_original_varchar2_value(p_transaction_step_id,'P_LABOUR_UNION_MEMBER_FLAG');
7813: l_old_organization_id := hr_transaction_api.get_number_value(p_transaction_step_id,'P_ORGANIZATION_ID');
7814: l_old_pay_basis_id := hr_transaction_api.get_original_number_value(p_transaction_step_id,'P_PAY_BASIS_ID');
7815: l_old_grade_id := hr_transaction_api.get_original_number_value(p_transaction_step_id,'P_GRADE_ID');
7816: l_primary_flag := hr_transaction_api.get_varchar2_value(p_transaction_step_id,'P_PRIMARY_FLAG');
7817: l_assignment_id := hr_transaction_api.get_number_value(p_transaction_step_id,'P_ASSIGNMENT_ID');
7810: l_old_mgr_flag := hr_transaction_api.get_original_varchar2_value(p_transaction_step_id,'P_MANAGER_FLAG');
7811: -- Fetch Original Labour Union Flag
7812: l_old_labour_union_flag := hr_transaction_api.get_original_varchar2_value(p_transaction_step_id,'P_LABOUR_UNION_MEMBER_FLAG');
7813: l_old_organization_id := hr_transaction_api.get_number_value(p_transaction_step_id,'P_ORGANIZATION_ID');
7814: l_old_pay_basis_id := hr_transaction_api.get_original_number_value(p_transaction_step_id,'P_PAY_BASIS_ID');
7815: l_old_grade_id := hr_transaction_api.get_original_number_value(p_transaction_step_id,'P_GRADE_ID');
7816: l_primary_flag := hr_transaction_api.get_varchar2_value(p_transaction_step_id,'P_PRIMARY_FLAG');
7817: l_assignment_id := hr_transaction_api.get_number_value(p_transaction_step_id,'P_ASSIGNMENT_ID');
7818: l_effective_date := hr_transaction_api.get_date_value(p_transaction_step_id,'P_EFFECTIVE_DATE');
7811: -- Fetch Original Labour Union Flag
7812: l_old_labour_union_flag := hr_transaction_api.get_original_varchar2_value(p_transaction_step_id,'P_LABOUR_UNION_MEMBER_FLAG');
7813: l_old_organization_id := hr_transaction_api.get_number_value(p_transaction_step_id,'P_ORGANIZATION_ID');
7814: l_old_pay_basis_id := hr_transaction_api.get_original_number_value(p_transaction_step_id,'P_PAY_BASIS_ID');
7815: l_old_grade_id := hr_transaction_api.get_original_number_value(p_transaction_step_id,'P_GRADE_ID');
7816: l_primary_flag := hr_transaction_api.get_varchar2_value(p_transaction_step_id,'P_PRIMARY_FLAG');
7817: l_assignment_id := hr_transaction_api.get_number_value(p_transaction_step_id,'P_ASSIGNMENT_ID');
7818: l_effective_date := hr_transaction_api.get_date_value(p_transaction_step_id,'P_EFFECTIVE_DATE');
7819:
7812: l_old_labour_union_flag := hr_transaction_api.get_original_varchar2_value(p_transaction_step_id,'P_LABOUR_UNION_MEMBER_FLAG');
7813: l_old_organization_id := hr_transaction_api.get_number_value(p_transaction_step_id,'P_ORGANIZATION_ID');
7814: l_old_pay_basis_id := hr_transaction_api.get_original_number_value(p_transaction_step_id,'P_PAY_BASIS_ID');
7815: l_old_grade_id := hr_transaction_api.get_original_number_value(p_transaction_step_id,'P_GRADE_ID');
7816: l_primary_flag := hr_transaction_api.get_varchar2_value(p_transaction_step_id,'P_PRIMARY_FLAG');
7817: l_assignment_id := hr_transaction_api.get_number_value(p_transaction_step_id,'P_ASSIGNMENT_ID');
7818: l_effective_date := hr_transaction_api.get_date_value(p_transaction_step_id,'P_EFFECTIVE_DATE');
7819:
7820: if l_primary_flag is null then
7813: l_old_organization_id := hr_transaction_api.get_number_value(p_transaction_step_id,'P_ORGANIZATION_ID');
7814: l_old_pay_basis_id := hr_transaction_api.get_original_number_value(p_transaction_step_id,'P_PAY_BASIS_ID');
7815: l_old_grade_id := hr_transaction_api.get_original_number_value(p_transaction_step_id,'P_GRADE_ID');
7816: l_primary_flag := hr_transaction_api.get_varchar2_value(p_transaction_step_id,'P_PRIMARY_FLAG');
7817: l_assignment_id := hr_transaction_api.get_number_value(p_transaction_step_id,'P_ASSIGNMENT_ID');
7818: l_effective_date := hr_transaction_api.get_date_value(p_transaction_step_id,'P_EFFECTIVE_DATE');
7819:
7820: if l_primary_flag is null then
7821: open csr_prim_flag;
7814: l_old_pay_basis_id := hr_transaction_api.get_original_number_value(p_transaction_step_id,'P_PAY_BASIS_ID');
7815: l_old_grade_id := hr_transaction_api.get_original_number_value(p_transaction_step_id,'P_GRADE_ID');
7816: l_primary_flag := hr_transaction_api.get_varchar2_value(p_transaction_step_id,'P_PRIMARY_FLAG');
7817: l_assignment_id := hr_transaction_api.get_number_value(p_transaction_step_id,'P_ASSIGNMENT_ID');
7818: l_effective_date := hr_transaction_api.get_date_value(p_transaction_step_id,'P_EFFECTIVE_DATE');
7819:
7820: if l_primary_flag is null then
7821: open csr_prim_flag;
7822: fetch csr_prim_flag into l_primary_flag;