DBA Data[Home] [Help]

APPS.HR_TRS_UPD dependencies on HR_API

Line 67: -- Update the hr_api_transaction_steps Row

63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: hr_trs_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the hr_api_transaction_steps Row
68: --
69: update hr_api_transaction_steps
70: set
71: api_name = p_rec.api_name,

Line 69: update hr_api_transaction_steps

65: hr_trs_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the hr_api_transaction_steps Row
68: --
69: update hr_api_transaction_steps
70: set
71: api_name = p_rec.api_name,
72: api_display_name = p_rec.api_display_name,
73: processing_order = p_rec.processing_order,

Line 125: When hr_api.check_integrity_violated Then

121: --
122: hr_utility.set_location(' Leaving:'||l_proc, 10);
123: --
124: Exception
125: When hr_api.check_integrity_violated Then
126: -- A check constraint has been violated
127: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
128: hr_trs_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

125: When hr_api.check_integrity_violated Then
126: -- A check constraint has been violated
127: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
128: hr_trs_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.parent_integrity_violated Then
131: -- Parent integrity has been violated
132: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
133: hr_trs_shd.constraint_error

Line 130: When hr_api.parent_integrity_violated Then

126: -- A check constraint has been violated
127: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
128: hr_trs_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.parent_integrity_violated Then
131: -- Parent integrity has been violated
132: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
133: hr_trs_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

130: When hr_api.parent_integrity_violated Then
131: -- Parent integrity has been violated
132: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
133: hr_trs_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
138: hr_trs_shd.constraint_error

Line 135: When hr_api.unique_integrity_violated Then

131: -- Parent integrity has been violated
132: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
133: hr_trs_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
138: hr_trs_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
138: hr_trs_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When Others Then
141: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
142: Raise;
143: End update_dml;

Line 286: If (p_rec.transaction_id = hr_api.g_number) then

282: -- p_rec plsql record structure
283: -- to see if a system default is being used. If a system default
284: -- is being used then we must set to the 'current' argument value.
285: --
286: If (p_rec.transaction_id = hr_api.g_number) then
287: p_rec.transaction_id :=
288: hr_trs_shd.g_old_rec.transaction_id;
289: End If;
290: If (p_rec.api_name = hr_api.g_varchar2) then

Line 290: If (p_rec.api_name = hr_api.g_varchar2) then

286: If (p_rec.transaction_id = hr_api.g_number) then
287: p_rec.transaction_id :=
288: hr_trs_shd.g_old_rec.transaction_id;
289: End If;
290: If (p_rec.api_name = hr_api.g_varchar2) then
291: p_rec.api_name :=
292: hr_trs_shd.g_old_rec.api_name;
293: End If;
294: If (p_rec.api_display_name = hr_api.g_varchar2) then

Line 294: If (p_rec.api_display_name = hr_api.g_varchar2) then

290: If (p_rec.api_name = hr_api.g_varchar2) then
291: p_rec.api_name :=
292: hr_trs_shd.g_old_rec.api_name;
293: End If;
294: If (p_rec.api_display_name = hr_api.g_varchar2) then
295: p_rec.api_display_name :=
296: hr_trs_shd.g_old_rec.api_display_name;
297: End If;
298: If (p_rec.processing_order = hr_api.g_number) then

Line 298: If (p_rec.processing_order = hr_api.g_number) then

294: If (p_rec.api_display_name = hr_api.g_varchar2) then
295: p_rec.api_display_name :=
296: hr_trs_shd.g_old_rec.api_display_name;
297: End If;
298: If (p_rec.processing_order = hr_api.g_number) then
299: p_rec.processing_order :=
300: hr_trs_shd.g_old_rec.processing_order;
301: End If;
302: If (p_rec.item_type = hr_api.g_varchar2) then

Line 302: If (p_rec.item_type = hr_api.g_varchar2) then

298: If (p_rec.processing_order = hr_api.g_number) then
299: p_rec.processing_order :=
300: hr_trs_shd.g_old_rec.processing_order;
301: End If;
302: If (p_rec.item_type = hr_api.g_varchar2) then
303: p_rec.item_type :=
304: hr_trs_shd.g_old_rec.item_type;
305: End If;
306: If (p_rec.item_key = hr_api.g_varchar2) then

Line 306: If (p_rec.item_key = hr_api.g_varchar2) then

302: If (p_rec.item_type = hr_api.g_varchar2) then
303: p_rec.item_type :=
304: hr_trs_shd.g_old_rec.item_type;
305: End If;
306: If (p_rec.item_key = hr_api.g_varchar2) then
307: p_rec.item_key :=
308: hr_trs_shd.g_old_rec.item_key;
309: End If;
310: If (p_rec.activity_id = hr_api.g_number) then

Line 310: If (p_rec.activity_id = hr_api.g_number) then

306: If (p_rec.item_key = hr_api.g_varchar2) then
307: p_rec.item_key :=
308: hr_trs_shd.g_old_rec.item_key;
309: End If;
310: If (p_rec.activity_id = hr_api.g_number) then
311: p_rec.activity_id :=
312: hr_trs_shd.g_old_rec.activity_id;
313: End If;
314: If (p_rec.creator_person_id = hr_api.g_number) then

Line 314: If (p_rec.creator_person_id = hr_api.g_number) then

310: If (p_rec.activity_id = hr_api.g_number) then
311: p_rec.activity_id :=
312: hr_trs_shd.g_old_rec.activity_id;
313: End If;
314: If (p_rec.creator_person_id = hr_api.g_number) then
315: p_rec.creator_person_id :=
316: hr_trs_shd.g_old_rec.creator_person_id;
317: End If;
318: If (p_rec.update_person_id = hr_api.g_number) then

Line 318: If (p_rec.update_person_id = hr_api.g_number) then

314: If (p_rec.creator_person_id = hr_api.g_number) then
315: p_rec.creator_person_id :=
316: hr_trs_shd.g_old_rec.creator_person_id;
317: End If;
318: If (p_rec.update_person_id = hr_api.g_number) then
319: p_rec.update_person_id :=
320: hr_trs_shd.g_old_rec.update_person_id;
321: End If;
322:

Line 323: If (p_rec.pk1 = hr_api.g_varchar2) then

319: p_rec.update_person_id :=
320: hr_trs_shd.g_old_rec.update_person_id;
321: End If;
322:
323: If (p_rec.pk1 = hr_api.g_varchar2) then
324: p_rec.pk1 := hr_trs_shd.g_old_rec.pk1;
325: End If;
326: If (p_rec.pk2 = hr_api.g_varchar2) then
327: p_rec.pk2 := hr_trs_shd.g_old_rec.pk2;

Line 326: If (p_rec.pk2 = hr_api.g_varchar2) then

322:
323: If (p_rec.pk1 = hr_api.g_varchar2) then
324: p_rec.pk1 := hr_trs_shd.g_old_rec.pk1;
325: End If;
326: If (p_rec.pk2 = hr_api.g_varchar2) then
327: p_rec.pk2 := hr_trs_shd.g_old_rec.pk2;
328: End If;
329: If (p_rec.pk3 = hr_api.g_varchar2) then
330: p_rec.pk3 := hr_trs_shd.g_old_rec.pk3;

Line 329: If (p_rec.pk3 = hr_api.g_varchar2) then

325: End If;
326: If (p_rec.pk2 = hr_api.g_varchar2) then
327: p_rec.pk2 := hr_trs_shd.g_old_rec.pk2;
328: End If;
329: If (p_rec.pk3 = hr_api.g_varchar2) then
330: p_rec.pk3 := hr_trs_shd.g_old_rec.pk3;
331: End If;
332: If (p_rec.pk4 = hr_api.g_varchar2) then
333: p_rec.pk4 := hr_trs_shd.g_old_rec.pk4;

Line 332: If (p_rec.pk4 = hr_api.g_varchar2) then

328: End If;
329: If (p_rec.pk3 = hr_api.g_varchar2) then
330: p_rec.pk3 := hr_trs_shd.g_old_rec.pk3;
331: End If;
332: If (p_rec.pk4 = hr_api.g_varchar2) then
333: p_rec.pk4 := hr_trs_shd.g_old_rec.pk4;
334: End If;
335: If (p_rec.pk5 = hr_api.g_varchar2) then
336: p_rec.pk5 := hr_trs_shd.g_old_rec.pk5;

Line 335: If (p_rec.pk5 = hr_api.g_varchar2) then

331: End If;
332: If (p_rec.pk4 = hr_api.g_varchar2) then
333: p_rec.pk4 := hr_trs_shd.g_old_rec.pk4;
334: End If;
335: If (p_rec.pk5 = hr_api.g_varchar2) then
336: p_rec.pk5 := hr_trs_shd.g_old_rec.pk5;
337: End If;
338: If (p_rec.information_category = hr_api.g_varchar2) then
339: p_rec.information_category := hr_trs_shd.g_old_rec.information_category;

Line 338: If (p_rec.information_category = hr_api.g_varchar2) then

334: End If;
335: If (p_rec.pk5 = hr_api.g_varchar2) then
336: p_rec.pk5 := hr_trs_shd.g_old_rec.pk5;
337: End If;
338: If (p_rec.information_category = hr_api.g_varchar2) then
339: p_rec.information_category := hr_trs_shd.g_old_rec.information_category;
340: End If;
341: If (p_rec.information1 = hr_api.g_varchar2) then
342: p_rec.information1 := hr_trs_shd.g_old_rec.information1;

Line 341: If (p_rec.information1 = hr_api.g_varchar2) then

337: End If;
338: If (p_rec.information_category = hr_api.g_varchar2) then
339: p_rec.information_category := hr_trs_shd.g_old_rec.information_category;
340: End If;
341: If (p_rec.information1 = hr_api.g_varchar2) then
342: p_rec.information1 := hr_trs_shd.g_old_rec.information1;
343: End If;
344: If (p_rec.information2 = hr_api.g_varchar2) then
345: p_rec.information2 := hr_trs_shd.g_old_rec.information2;

Line 344: If (p_rec.information2 = hr_api.g_varchar2) then

340: End If;
341: If (p_rec.information1 = hr_api.g_varchar2) then
342: p_rec.information1 := hr_trs_shd.g_old_rec.information1;
343: End If;
344: If (p_rec.information2 = hr_api.g_varchar2) then
345: p_rec.information2 := hr_trs_shd.g_old_rec.information2;
346: End If;
347: If (p_rec.information3 = hr_api.g_varchar2) then
348: p_rec.information3 := hr_trs_shd.g_old_rec.information3;

Line 347: If (p_rec.information3 = hr_api.g_varchar2) then

343: End If;
344: If (p_rec.information2 = hr_api.g_varchar2) then
345: p_rec.information2 := hr_trs_shd.g_old_rec.information2;
346: End If;
347: If (p_rec.information3 = hr_api.g_varchar2) then
348: p_rec.information3 := hr_trs_shd.g_old_rec.information3;
349: End If;
350: If (p_rec.information4 = hr_api.g_varchar2) then
351: p_rec.information4 := hr_trs_shd.g_old_rec.information4;

Line 350: If (p_rec.information4 = hr_api.g_varchar2) then

346: End If;
347: If (p_rec.information3 = hr_api.g_varchar2) then
348: p_rec.information3 := hr_trs_shd.g_old_rec.information3;
349: End If;
350: If (p_rec.information4 = hr_api.g_varchar2) then
351: p_rec.information4 := hr_trs_shd.g_old_rec.information4;
352: End If;
353: If (p_rec.information5 = hr_api.g_varchar2) then
354: p_rec.information5 := hr_trs_shd.g_old_rec.information5;

Line 353: If (p_rec.information5 = hr_api.g_varchar2) then

349: End If;
350: If (p_rec.information4 = hr_api.g_varchar2) then
351: p_rec.information4 := hr_trs_shd.g_old_rec.information4;
352: End If;
353: If (p_rec.information5 = hr_api.g_varchar2) then
354: p_rec.information5 := hr_trs_shd.g_old_rec.information5;
355: End If;
356: If (p_rec.information6 = hr_api.g_varchar2) then
357: p_rec.information6 := hr_trs_shd.g_old_rec.information6;

Line 356: If (p_rec.information6 = hr_api.g_varchar2) then

352: End If;
353: If (p_rec.information5 = hr_api.g_varchar2) then
354: p_rec.information5 := hr_trs_shd.g_old_rec.information5;
355: End If;
356: If (p_rec.information6 = hr_api.g_varchar2) then
357: p_rec.information6 := hr_trs_shd.g_old_rec.information6;
358: End If;
359: If (p_rec.information7 = hr_api.g_varchar2) then
360: p_rec.information7 := hr_trs_shd.g_old_rec.information7;

Line 359: If (p_rec.information7 = hr_api.g_varchar2) then

355: End If;
356: If (p_rec.information6 = hr_api.g_varchar2) then
357: p_rec.information6 := hr_trs_shd.g_old_rec.information6;
358: End If;
359: If (p_rec.information7 = hr_api.g_varchar2) then
360: p_rec.information7 := hr_trs_shd.g_old_rec.information7;
361: End If;
362: If (p_rec.information8 = hr_api.g_varchar2) then
363: p_rec.information8 := hr_trs_shd.g_old_rec.information8;

Line 362: If (p_rec.information8 = hr_api.g_varchar2) then

358: End If;
359: If (p_rec.information7 = hr_api.g_varchar2) then
360: p_rec.information7 := hr_trs_shd.g_old_rec.information7;
361: End If;
362: If (p_rec.information8 = hr_api.g_varchar2) then
363: p_rec.information8 := hr_trs_shd.g_old_rec.information8;
364: End If;
365: If (p_rec.information9 = hr_api.g_varchar2) then
366: p_rec.information9 := hr_trs_shd.g_old_rec.information9;

Line 365: If (p_rec.information9 = hr_api.g_varchar2) then

361: End If;
362: If (p_rec.information8 = hr_api.g_varchar2) then
363: p_rec.information8 := hr_trs_shd.g_old_rec.information8;
364: End If;
365: If (p_rec.information9 = hr_api.g_varchar2) then
366: p_rec.information9 := hr_trs_shd.g_old_rec.information9;
367: End If;
368: If (p_rec.information10 = hr_api.g_varchar2) then
369: p_rec.information10 := hr_trs_shd.g_old_rec.information10;

Line 368: If (p_rec.information10 = hr_api.g_varchar2) then

364: End If;
365: If (p_rec.information9 = hr_api.g_varchar2) then
366: p_rec.information9 := hr_trs_shd.g_old_rec.information9;
367: End If;
368: If (p_rec.information10 = hr_api.g_varchar2) then
369: p_rec.information10 := hr_trs_shd.g_old_rec.information10;
370: End If;
371: If (p_rec.information11 = hr_api.g_varchar2) then
372: p_rec.information11 := hr_trs_shd.g_old_rec.information11;

Line 371: If (p_rec.information11 = hr_api.g_varchar2) then

367: End If;
368: If (p_rec.information10 = hr_api.g_varchar2) then
369: p_rec.information10 := hr_trs_shd.g_old_rec.information10;
370: End If;
371: If (p_rec.information11 = hr_api.g_varchar2) then
372: p_rec.information11 := hr_trs_shd.g_old_rec.information11;
373: End If;
374: If (p_rec.information12 = hr_api.g_varchar2) then
375: p_rec.information12:= hr_trs_shd.g_old_rec.information12;

Line 374: If (p_rec.information12 = hr_api.g_varchar2) then

370: End If;
371: If (p_rec.information11 = hr_api.g_varchar2) then
372: p_rec.information11 := hr_trs_shd.g_old_rec.information11;
373: End If;
374: If (p_rec.information12 = hr_api.g_varchar2) then
375: p_rec.information12:= hr_trs_shd.g_old_rec.information12;
376: End If;
377: If (p_rec.information13 = hr_api.g_varchar2) then
378: p_rec.information13 := hr_trs_shd.g_old_rec.information1;

Line 377: If (p_rec.information13 = hr_api.g_varchar2) then

373: End If;
374: If (p_rec.information12 = hr_api.g_varchar2) then
375: p_rec.information12:= hr_trs_shd.g_old_rec.information12;
376: End If;
377: If (p_rec.information13 = hr_api.g_varchar2) then
378: p_rec.information13 := hr_trs_shd.g_old_rec.information1;
379: End If;
380: If (p_rec.information14 = hr_api.g_varchar2) then
381: p_rec.information14 := hr_trs_shd.g_old_rec.information14;

Line 380: If (p_rec.information14 = hr_api.g_varchar2) then

376: End If;
377: If (p_rec.information13 = hr_api.g_varchar2) then
378: p_rec.information13 := hr_trs_shd.g_old_rec.information1;
379: End If;
380: If (p_rec.information14 = hr_api.g_varchar2) then
381: p_rec.information14 := hr_trs_shd.g_old_rec.information14;
382: End If;
383: If (p_rec.information15= hr_api.g_varchar2) then
384: p_rec.information15 := hr_trs_shd.g_old_rec.information15;

Line 383: If (p_rec.information15= hr_api.g_varchar2) then

379: End If;
380: If (p_rec.information14 = hr_api.g_varchar2) then
381: p_rec.information14 := hr_trs_shd.g_old_rec.information14;
382: End If;
383: If (p_rec.information15= hr_api.g_varchar2) then
384: p_rec.information15 := hr_trs_shd.g_old_rec.information15;
385: End If;
386: If (p_rec.information16 = hr_api.g_varchar2) then
387: p_rec.information16 := hr_trs_shd.g_old_rec.information16;

Line 386: If (p_rec.information16 = hr_api.g_varchar2) then

382: End If;
383: If (p_rec.information15= hr_api.g_varchar2) then
384: p_rec.information15 := hr_trs_shd.g_old_rec.information15;
385: End If;
386: If (p_rec.information16 = hr_api.g_varchar2) then
387: p_rec.information16 := hr_trs_shd.g_old_rec.information16;
388: End If;
389: If (p_rec.information17 = hr_api.g_varchar2) then
390: p_rec.information17 := hr_trs_shd.g_old_rec.information17;

Line 389: If (p_rec.information17 = hr_api.g_varchar2) then

385: End If;
386: If (p_rec.information16 = hr_api.g_varchar2) then
387: p_rec.information16 := hr_trs_shd.g_old_rec.information16;
388: End If;
389: If (p_rec.information17 = hr_api.g_varchar2) then
390: p_rec.information17 := hr_trs_shd.g_old_rec.information17;
391: End If;
392: If (p_rec.information18 = hr_api.g_varchar2) then
393: p_rec.information18 := hr_trs_shd.g_old_rec.information18;

Line 392: If (p_rec.information18 = hr_api.g_varchar2) then

388: End If;
389: If (p_rec.information17 = hr_api.g_varchar2) then
390: p_rec.information17 := hr_trs_shd.g_old_rec.information17;
391: End If;
392: If (p_rec.information18 = hr_api.g_varchar2) then
393: p_rec.information18 := hr_trs_shd.g_old_rec.information18;
394: End If;
395: If (p_rec.information19 = hr_api.g_varchar2) then
396: p_rec.information19 := hr_trs_shd.g_old_rec.information19;

Line 395: If (p_rec.information19 = hr_api.g_varchar2) then

391: End If;
392: If (p_rec.information18 = hr_api.g_varchar2) then
393: p_rec.information18 := hr_trs_shd.g_old_rec.information18;
394: End If;
395: If (p_rec.information19 = hr_api.g_varchar2) then
396: p_rec.information19 := hr_trs_shd.g_old_rec.information19;
397: End If;
398: If (p_rec.information20= hr_api.g_varchar2) then
399: p_rec.information20 := hr_trs_shd.g_old_rec.information20;

Line 398: If (p_rec.information20= hr_api.g_varchar2) then

394: End If;
395: If (p_rec.information19 = hr_api.g_varchar2) then
396: p_rec.information19 := hr_trs_shd.g_old_rec.information19;
397: End If;
398: If (p_rec.information20= hr_api.g_varchar2) then
399: p_rec.information20 := hr_trs_shd.g_old_rec.information20;
400: End If;
401: If (p_rec.information21 = hr_api.g_varchar2) then
402: p_rec.information21 := hr_trs_shd.g_old_rec.information21;

Line 401: If (p_rec.information21 = hr_api.g_varchar2) then

397: End If;
398: If (p_rec.information20= hr_api.g_varchar2) then
399: p_rec.information20 := hr_trs_shd.g_old_rec.information20;
400: End If;
401: If (p_rec.information21 = hr_api.g_varchar2) then
402: p_rec.information21 := hr_trs_shd.g_old_rec.information21;
403: End If;
404: If (p_rec.information22 = hr_api.g_varchar2) then
405: p_rec.information22 := hr_trs_shd.g_old_rec.information22;

Line 404: If (p_rec.information22 = hr_api.g_varchar2) then

400: End If;
401: If (p_rec.information21 = hr_api.g_varchar2) then
402: p_rec.information21 := hr_trs_shd.g_old_rec.information21;
403: End If;
404: If (p_rec.information22 = hr_api.g_varchar2) then
405: p_rec.information22 := hr_trs_shd.g_old_rec.information22;
406: End If;
407: If (p_rec.information23 = hr_api.g_varchar2) then
408: p_rec.information23 := hr_trs_shd.g_old_rec.information23;

Line 407: If (p_rec.information23 = hr_api.g_varchar2) then

403: End If;
404: If (p_rec.information22 = hr_api.g_varchar2) then
405: p_rec.information22 := hr_trs_shd.g_old_rec.information22;
406: End If;
407: If (p_rec.information23 = hr_api.g_varchar2) then
408: p_rec.information23 := hr_trs_shd.g_old_rec.information23;
409: End If;
410: If (p_rec.information24 = hr_api.g_varchar2) then
411: p_rec.information24 := hr_trs_shd.g_old_rec.information24;

Line 410: If (p_rec.information24 = hr_api.g_varchar2) then

406: End If;
407: If (p_rec.information23 = hr_api.g_varchar2) then
408: p_rec.information23 := hr_trs_shd.g_old_rec.information23;
409: End If;
410: If (p_rec.information24 = hr_api.g_varchar2) then
411: p_rec.information24 := hr_trs_shd.g_old_rec.information24;
412: End If;
413: If (p_rec.information25 = hr_api.g_varchar2) then
414: p_rec.information25 := hr_trs_shd.g_old_rec.information25;

Line 413: If (p_rec.information25 = hr_api.g_varchar2) then

409: End If;
410: If (p_rec.information24 = hr_api.g_varchar2) then
411: p_rec.information24 := hr_trs_shd.g_old_rec.information24;
412: End If;
413: If (p_rec.information25 = hr_api.g_varchar2) then
414: p_rec.information25 := hr_trs_shd.g_old_rec.information25;
415: End If;
416: If (p_rec.information26 = hr_api.g_varchar2) then
417: p_rec.information26 := hr_trs_shd.g_old_rec.information26;

Line 416: If (p_rec.information26 = hr_api.g_varchar2) then

412: End If;
413: If (p_rec.information25 = hr_api.g_varchar2) then
414: p_rec.information25 := hr_trs_shd.g_old_rec.information25;
415: End If;
416: If (p_rec.information26 = hr_api.g_varchar2) then
417: p_rec.information26 := hr_trs_shd.g_old_rec.information26;
418: End If;
419: If (p_rec.information27 = hr_api.g_varchar2) then
420: p_rec.information27 := hr_trs_shd.g_old_rec.information27;

Line 419: If (p_rec.information27 = hr_api.g_varchar2) then

415: End If;
416: If (p_rec.information26 = hr_api.g_varchar2) then
417: p_rec.information26 := hr_trs_shd.g_old_rec.information26;
418: End If;
419: If (p_rec.information27 = hr_api.g_varchar2) then
420: p_rec.information27 := hr_trs_shd.g_old_rec.information27;
421: End If;
422: If (p_rec.information28 = hr_api.g_varchar2) then
423: p_rec.information28 := hr_trs_shd.g_old_rec.information28;

Line 422: If (p_rec.information28 = hr_api.g_varchar2) then

418: End If;
419: If (p_rec.information27 = hr_api.g_varchar2) then
420: p_rec.information27 := hr_trs_shd.g_old_rec.information27;
421: End If;
422: If (p_rec.information28 = hr_api.g_varchar2) then
423: p_rec.information28 := hr_trs_shd.g_old_rec.information28;
424: End If;
425: If (p_rec.information29 = hr_api.g_varchar2) then
426: p_rec.information29 := hr_trs_shd.g_old_rec.information29;

Line 425: If (p_rec.information29 = hr_api.g_varchar2) then

421: End If;
422: If (p_rec.information28 = hr_api.g_varchar2) then
423: p_rec.information28 := hr_trs_shd.g_old_rec.information28;
424: End If;
425: If (p_rec.information29 = hr_api.g_varchar2) then
426: p_rec.information29 := hr_trs_shd.g_old_rec.information29;
427: End If;
428: If (p_rec.information30 = hr_api.g_varchar2) then
429: p_rec.information30 := hr_trs_shd.g_old_rec.information30;

Line 428: If (p_rec.information30 = hr_api.g_varchar2) then

424: End If;
425: If (p_rec.information29 = hr_api.g_varchar2) then
426: p_rec.information29 := hr_trs_shd.g_old_rec.information29;
427: End If;
428: If (p_rec.information30 = hr_api.g_varchar2) then
429: p_rec.information30 := hr_trs_shd.g_old_rec.information30;
430: End If;
431:
432:

Line 493: Raise HR_Api.Validate_Enabled;

489: --
490: -- If we are validating then raise the Validate_Enabled exception
491: --
492: If p_validate then
493: Raise HR_Api.Validate_Enabled;
494: End If;
495: --
496: hr_utility.set_location(' Leaving:'||l_proc, 10);
497: Exception

Line 498: When HR_Api.Validate_Enabled Then

494: End If;
495: --
496: hr_utility.set_location(' Leaving:'||l_proc, 10);
497: Exception
498: When HR_Api.Validate_Enabled Then
499: --
500: -- As the Validate_Enabled exception has been raised
501: -- we must rollback to the savepoint
502: --

Line 512: p_transaction_id in number default hr_api.g_number,

508: -- ----------------------------------------------------------------------------
509: Procedure upd
510: (
511: p_transaction_step_id in number,
512: p_transaction_id in number default hr_api.g_number,
513: p_api_name in varchar2 default hr_api.g_varchar2,
514: p_api_display_name in varchar2 default hr_api.g_varchar2,
515: p_processing_order in number default hr_api.g_number,
516: p_item_type in varchar2 default hr_api.g_varchar2,

Line 513: p_api_name in varchar2 default hr_api.g_varchar2,

509: Procedure upd
510: (
511: p_transaction_step_id in number,
512: p_transaction_id in number default hr_api.g_number,
513: p_api_name in varchar2 default hr_api.g_varchar2,
514: p_api_display_name in varchar2 default hr_api.g_varchar2,
515: p_processing_order in number default hr_api.g_number,
516: p_item_type in varchar2 default hr_api.g_varchar2,
517: p_item_key in varchar2 default hr_api.g_varchar2,

Line 514: p_api_display_name in varchar2 default hr_api.g_varchar2,

510: (
511: p_transaction_step_id in number,
512: p_transaction_id in number default hr_api.g_number,
513: p_api_name in varchar2 default hr_api.g_varchar2,
514: p_api_display_name in varchar2 default hr_api.g_varchar2,
515: p_processing_order in number default hr_api.g_number,
516: p_item_type in varchar2 default hr_api.g_varchar2,
517: p_item_key in varchar2 default hr_api.g_varchar2,
518: p_activity_id in number default hr_api.g_number,

Line 515: p_processing_order in number default hr_api.g_number,

511: p_transaction_step_id in number,
512: p_transaction_id in number default hr_api.g_number,
513: p_api_name in varchar2 default hr_api.g_varchar2,
514: p_api_display_name in varchar2 default hr_api.g_varchar2,
515: p_processing_order in number default hr_api.g_number,
516: p_item_type in varchar2 default hr_api.g_varchar2,
517: p_item_key in varchar2 default hr_api.g_varchar2,
518: p_activity_id in number default hr_api.g_number,
519: p_creator_person_id in number default hr_api.g_number,

Line 516: p_item_type in varchar2 default hr_api.g_varchar2,

512: p_transaction_id in number default hr_api.g_number,
513: p_api_name in varchar2 default hr_api.g_varchar2,
514: p_api_display_name in varchar2 default hr_api.g_varchar2,
515: p_processing_order in number default hr_api.g_number,
516: p_item_type in varchar2 default hr_api.g_varchar2,
517: p_item_key in varchar2 default hr_api.g_varchar2,
518: p_activity_id in number default hr_api.g_number,
519: p_creator_person_id in number default hr_api.g_number,
520: p_update_person_id in number default hr_api.g_number,

Line 517: p_item_key in varchar2 default hr_api.g_varchar2,

513: p_api_name in varchar2 default hr_api.g_varchar2,
514: p_api_display_name in varchar2 default hr_api.g_varchar2,
515: p_processing_order in number default hr_api.g_number,
516: p_item_type in varchar2 default hr_api.g_varchar2,
517: p_item_key in varchar2 default hr_api.g_varchar2,
518: p_activity_id in number default hr_api.g_number,
519: p_creator_person_id in number default hr_api.g_number,
520: p_update_person_id in number default hr_api.g_number,
521: p_object_version_number in out nocopy number,

Line 518: p_activity_id in number default hr_api.g_number,

514: p_api_display_name in varchar2 default hr_api.g_varchar2,
515: p_processing_order in number default hr_api.g_number,
516: p_item_type in varchar2 default hr_api.g_varchar2,
517: p_item_key in varchar2 default hr_api.g_varchar2,
518: p_activity_id in number default hr_api.g_number,
519: p_creator_person_id in number default hr_api.g_number,
520: p_update_person_id in number default hr_api.g_number,
521: p_object_version_number in out nocopy number,
522: p_validate in boolean default false,

Line 519: p_creator_person_id in number default hr_api.g_number,

515: p_processing_order in number default hr_api.g_number,
516: p_item_type in varchar2 default hr_api.g_varchar2,
517: p_item_key in varchar2 default hr_api.g_varchar2,
518: p_activity_id in number default hr_api.g_number,
519: p_creator_person_id in number default hr_api.g_number,
520: p_update_person_id in number default hr_api.g_number,
521: p_object_version_number in out nocopy number,
522: p_validate in boolean default false,
523: p_OBJECT_TYPE in VARCHAR2 default hr_api.g_varchar2,

Line 520: p_update_person_id in number default hr_api.g_number,

516: p_item_type in varchar2 default hr_api.g_varchar2,
517: p_item_key in varchar2 default hr_api.g_varchar2,
518: p_activity_id in number default hr_api.g_number,
519: p_creator_person_id in number default hr_api.g_number,
520: p_update_person_id in number default hr_api.g_number,
521: p_object_version_number in out nocopy number,
522: p_validate in boolean default false,
523: p_OBJECT_TYPE in VARCHAR2 default hr_api.g_varchar2,
524: p_OBJECT_NAME in VARCHAR2 default hr_api.g_varchar2,

Line 523: p_OBJECT_TYPE in VARCHAR2 default hr_api.g_varchar2,

519: p_creator_person_id in number default hr_api.g_number,
520: p_update_person_id in number default hr_api.g_number,
521: p_object_version_number in out nocopy number,
522: p_validate in boolean default false,
523: p_OBJECT_TYPE in VARCHAR2 default hr_api.g_varchar2,
524: p_OBJECT_NAME in VARCHAR2 default hr_api.g_varchar2,
525: p_OBJECT_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,
526: p_OBJECT_STATE in VARCHAR2 default hr_api.g_varchar2,
527: p_OBJECT_NAME_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,

Line 524: p_OBJECT_NAME in VARCHAR2 default hr_api.g_varchar2,

520: p_update_person_id in number default hr_api.g_number,
521: p_object_version_number in out nocopy number,
522: p_validate in boolean default false,
523: p_OBJECT_TYPE in VARCHAR2 default hr_api.g_varchar2,
524: p_OBJECT_NAME in VARCHAR2 default hr_api.g_varchar2,
525: p_OBJECT_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,
526: p_OBJECT_STATE in VARCHAR2 default hr_api.g_varchar2,
527: p_OBJECT_NAME_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,
528: p_PK1 in VARCHAR2 default hr_api.g_varchar2,

Line 525: p_OBJECT_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,

521: p_object_version_number in out nocopy number,
522: p_validate in boolean default false,
523: p_OBJECT_TYPE in VARCHAR2 default hr_api.g_varchar2,
524: p_OBJECT_NAME in VARCHAR2 default hr_api.g_varchar2,
525: p_OBJECT_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,
526: p_OBJECT_STATE in VARCHAR2 default hr_api.g_varchar2,
527: p_OBJECT_NAME_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,
528: p_PK1 in VARCHAR2 default hr_api.g_varchar2,
529: p_PK2 in VARCHAR2 default hr_api.g_varchar2,

Line 526: p_OBJECT_STATE in VARCHAR2 default hr_api.g_varchar2,

522: p_validate in boolean default false,
523: p_OBJECT_TYPE in VARCHAR2 default hr_api.g_varchar2,
524: p_OBJECT_NAME in VARCHAR2 default hr_api.g_varchar2,
525: p_OBJECT_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,
526: p_OBJECT_STATE in VARCHAR2 default hr_api.g_varchar2,
527: p_OBJECT_NAME_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,
528: p_PK1 in VARCHAR2 default hr_api.g_varchar2,
529: p_PK2 in VARCHAR2 default hr_api.g_varchar2,
530: p_PK3 in VARCHAR2 default hr_api.g_varchar2,

Line 527: p_OBJECT_NAME_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,

523: p_OBJECT_TYPE in VARCHAR2 default hr_api.g_varchar2,
524: p_OBJECT_NAME in VARCHAR2 default hr_api.g_varchar2,
525: p_OBJECT_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,
526: p_OBJECT_STATE in VARCHAR2 default hr_api.g_varchar2,
527: p_OBJECT_NAME_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,
528: p_PK1 in VARCHAR2 default hr_api.g_varchar2,
529: p_PK2 in VARCHAR2 default hr_api.g_varchar2,
530: p_PK3 in VARCHAR2 default hr_api.g_varchar2,
531: p_PK4 in VARCHAR2 default hr_api.g_varchar2,

Line 528: p_PK1 in VARCHAR2 default hr_api.g_varchar2,

524: p_OBJECT_NAME in VARCHAR2 default hr_api.g_varchar2,
525: p_OBJECT_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,
526: p_OBJECT_STATE in VARCHAR2 default hr_api.g_varchar2,
527: p_OBJECT_NAME_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,
528: p_PK1 in VARCHAR2 default hr_api.g_varchar2,
529: p_PK2 in VARCHAR2 default hr_api.g_varchar2,
530: p_PK3 in VARCHAR2 default hr_api.g_varchar2,
531: p_PK4 in VARCHAR2 default hr_api.g_varchar2,
532: p_PK5 in VARCHAR2 default hr_api.g_varchar2,

Line 529: p_PK2 in VARCHAR2 default hr_api.g_varchar2,

525: p_OBJECT_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,
526: p_OBJECT_STATE in VARCHAR2 default hr_api.g_varchar2,
527: p_OBJECT_NAME_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,
528: p_PK1 in VARCHAR2 default hr_api.g_varchar2,
529: p_PK2 in VARCHAR2 default hr_api.g_varchar2,
530: p_PK3 in VARCHAR2 default hr_api.g_varchar2,
531: p_PK4 in VARCHAR2 default hr_api.g_varchar2,
532: p_PK5 in VARCHAR2 default hr_api.g_varchar2,
533: p_information_category in VARCHAR2 default hr_api.g_varchar2,

Line 530: p_PK3 in VARCHAR2 default hr_api.g_varchar2,

526: p_OBJECT_STATE in VARCHAR2 default hr_api.g_varchar2,
527: p_OBJECT_NAME_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,
528: p_PK1 in VARCHAR2 default hr_api.g_varchar2,
529: p_PK2 in VARCHAR2 default hr_api.g_varchar2,
530: p_PK3 in VARCHAR2 default hr_api.g_varchar2,
531: p_PK4 in VARCHAR2 default hr_api.g_varchar2,
532: p_PK5 in VARCHAR2 default hr_api.g_varchar2,
533: p_information_category in VARCHAR2 default hr_api.g_varchar2,
534: p_information1 in VARCHAR2 default hr_api.g_varchar2,

Line 531: p_PK4 in VARCHAR2 default hr_api.g_varchar2,

527: p_OBJECT_NAME_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,
528: p_PK1 in VARCHAR2 default hr_api.g_varchar2,
529: p_PK2 in VARCHAR2 default hr_api.g_varchar2,
530: p_PK3 in VARCHAR2 default hr_api.g_varchar2,
531: p_PK4 in VARCHAR2 default hr_api.g_varchar2,
532: p_PK5 in VARCHAR2 default hr_api.g_varchar2,
533: p_information_category in VARCHAR2 default hr_api.g_varchar2,
534: p_information1 in VARCHAR2 default hr_api.g_varchar2,
535: p_information2 in VARCHAR2 default hr_api.g_varchar2,

Line 532: p_PK5 in VARCHAR2 default hr_api.g_varchar2,

528: p_PK1 in VARCHAR2 default hr_api.g_varchar2,
529: p_PK2 in VARCHAR2 default hr_api.g_varchar2,
530: p_PK3 in VARCHAR2 default hr_api.g_varchar2,
531: p_PK4 in VARCHAR2 default hr_api.g_varchar2,
532: p_PK5 in VARCHAR2 default hr_api.g_varchar2,
533: p_information_category in VARCHAR2 default hr_api.g_varchar2,
534: p_information1 in VARCHAR2 default hr_api.g_varchar2,
535: p_information2 in VARCHAR2 default hr_api.g_varchar2,
536: p_information3 in VARCHAR2 default hr_api.g_varchar2,

Line 533: p_information_category in VARCHAR2 default hr_api.g_varchar2,

529: p_PK2 in VARCHAR2 default hr_api.g_varchar2,
530: p_PK3 in VARCHAR2 default hr_api.g_varchar2,
531: p_PK4 in VARCHAR2 default hr_api.g_varchar2,
532: p_PK5 in VARCHAR2 default hr_api.g_varchar2,
533: p_information_category in VARCHAR2 default hr_api.g_varchar2,
534: p_information1 in VARCHAR2 default hr_api.g_varchar2,
535: p_information2 in VARCHAR2 default hr_api.g_varchar2,
536: p_information3 in VARCHAR2 default hr_api.g_varchar2,
537: p_information4 in VARCHAR2 default hr_api.g_varchar2,

Line 534: p_information1 in VARCHAR2 default hr_api.g_varchar2,

530: p_PK3 in VARCHAR2 default hr_api.g_varchar2,
531: p_PK4 in VARCHAR2 default hr_api.g_varchar2,
532: p_PK5 in VARCHAR2 default hr_api.g_varchar2,
533: p_information_category in VARCHAR2 default hr_api.g_varchar2,
534: p_information1 in VARCHAR2 default hr_api.g_varchar2,
535: p_information2 in VARCHAR2 default hr_api.g_varchar2,
536: p_information3 in VARCHAR2 default hr_api.g_varchar2,
537: p_information4 in VARCHAR2 default hr_api.g_varchar2,
538: p_information5 in VARCHAR2 default hr_api.g_varchar2,

Line 535: p_information2 in VARCHAR2 default hr_api.g_varchar2,

531: p_PK4 in VARCHAR2 default hr_api.g_varchar2,
532: p_PK5 in VARCHAR2 default hr_api.g_varchar2,
533: p_information_category in VARCHAR2 default hr_api.g_varchar2,
534: p_information1 in VARCHAR2 default hr_api.g_varchar2,
535: p_information2 in VARCHAR2 default hr_api.g_varchar2,
536: p_information3 in VARCHAR2 default hr_api.g_varchar2,
537: p_information4 in VARCHAR2 default hr_api.g_varchar2,
538: p_information5 in VARCHAR2 default hr_api.g_varchar2,
539: p_information6 in VARCHAR2 default hr_api.g_varchar2,

Line 536: p_information3 in VARCHAR2 default hr_api.g_varchar2,

532: p_PK5 in VARCHAR2 default hr_api.g_varchar2,
533: p_information_category in VARCHAR2 default hr_api.g_varchar2,
534: p_information1 in VARCHAR2 default hr_api.g_varchar2,
535: p_information2 in VARCHAR2 default hr_api.g_varchar2,
536: p_information3 in VARCHAR2 default hr_api.g_varchar2,
537: p_information4 in VARCHAR2 default hr_api.g_varchar2,
538: p_information5 in VARCHAR2 default hr_api.g_varchar2,
539: p_information6 in VARCHAR2 default hr_api.g_varchar2,
540: p_information7 in VARCHAR2 default hr_api.g_varchar2,

Line 537: p_information4 in VARCHAR2 default hr_api.g_varchar2,

533: p_information_category in VARCHAR2 default hr_api.g_varchar2,
534: p_information1 in VARCHAR2 default hr_api.g_varchar2,
535: p_information2 in VARCHAR2 default hr_api.g_varchar2,
536: p_information3 in VARCHAR2 default hr_api.g_varchar2,
537: p_information4 in VARCHAR2 default hr_api.g_varchar2,
538: p_information5 in VARCHAR2 default hr_api.g_varchar2,
539: p_information6 in VARCHAR2 default hr_api.g_varchar2,
540: p_information7 in VARCHAR2 default hr_api.g_varchar2,
541: p_information8 in VARCHAR2 default hr_api.g_varchar2,

Line 538: p_information5 in VARCHAR2 default hr_api.g_varchar2,

534: p_information1 in VARCHAR2 default hr_api.g_varchar2,
535: p_information2 in VARCHAR2 default hr_api.g_varchar2,
536: p_information3 in VARCHAR2 default hr_api.g_varchar2,
537: p_information4 in VARCHAR2 default hr_api.g_varchar2,
538: p_information5 in VARCHAR2 default hr_api.g_varchar2,
539: p_information6 in VARCHAR2 default hr_api.g_varchar2,
540: p_information7 in VARCHAR2 default hr_api.g_varchar2,
541: p_information8 in VARCHAR2 default hr_api.g_varchar2,
542: p_information9 in VARCHAR2 default hr_api.g_varchar2,

Line 539: p_information6 in VARCHAR2 default hr_api.g_varchar2,

535: p_information2 in VARCHAR2 default hr_api.g_varchar2,
536: p_information3 in VARCHAR2 default hr_api.g_varchar2,
537: p_information4 in VARCHAR2 default hr_api.g_varchar2,
538: p_information5 in VARCHAR2 default hr_api.g_varchar2,
539: p_information6 in VARCHAR2 default hr_api.g_varchar2,
540: p_information7 in VARCHAR2 default hr_api.g_varchar2,
541: p_information8 in VARCHAR2 default hr_api.g_varchar2,
542: p_information9 in VARCHAR2 default hr_api.g_varchar2,
543: p_information10 in VARCHAR2 default hr_api.g_varchar2,

Line 540: p_information7 in VARCHAR2 default hr_api.g_varchar2,

536: p_information3 in VARCHAR2 default hr_api.g_varchar2,
537: p_information4 in VARCHAR2 default hr_api.g_varchar2,
538: p_information5 in VARCHAR2 default hr_api.g_varchar2,
539: p_information6 in VARCHAR2 default hr_api.g_varchar2,
540: p_information7 in VARCHAR2 default hr_api.g_varchar2,
541: p_information8 in VARCHAR2 default hr_api.g_varchar2,
542: p_information9 in VARCHAR2 default hr_api.g_varchar2,
543: p_information10 in VARCHAR2 default hr_api.g_varchar2,
544: p_information11 in VARCHAR2 default hr_api.g_varchar2,

Line 541: p_information8 in VARCHAR2 default hr_api.g_varchar2,

537: p_information4 in VARCHAR2 default hr_api.g_varchar2,
538: p_information5 in VARCHAR2 default hr_api.g_varchar2,
539: p_information6 in VARCHAR2 default hr_api.g_varchar2,
540: p_information7 in VARCHAR2 default hr_api.g_varchar2,
541: p_information8 in VARCHAR2 default hr_api.g_varchar2,
542: p_information9 in VARCHAR2 default hr_api.g_varchar2,
543: p_information10 in VARCHAR2 default hr_api.g_varchar2,
544: p_information11 in VARCHAR2 default hr_api.g_varchar2,
545: p_information12 in VARCHAR2 default hr_api.g_varchar2,

Line 542: p_information9 in VARCHAR2 default hr_api.g_varchar2,

538: p_information5 in VARCHAR2 default hr_api.g_varchar2,
539: p_information6 in VARCHAR2 default hr_api.g_varchar2,
540: p_information7 in VARCHAR2 default hr_api.g_varchar2,
541: p_information8 in VARCHAR2 default hr_api.g_varchar2,
542: p_information9 in VARCHAR2 default hr_api.g_varchar2,
543: p_information10 in VARCHAR2 default hr_api.g_varchar2,
544: p_information11 in VARCHAR2 default hr_api.g_varchar2,
545: p_information12 in VARCHAR2 default hr_api.g_varchar2,
546: p_information13 in VARCHAR2 default hr_api.g_varchar2,

Line 543: p_information10 in VARCHAR2 default hr_api.g_varchar2,

539: p_information6 in VARCHAR2 default hr_api.g_varchar2,
540: p_information7 in VARCHAR2 default hr_api.g_varchar2,
541: p_information8 in VARCHAR2 default hr_api.g_varchar2,
542: p_information9 in VARCHAR2 default hr_api.g_varchar2,
543: p_information10 in VARCHAR2 default hr_api.g_varchar2,
544: p_information11 in VARCHAR2 default hr_api.g_varchar2,
545: p_information12 in VARCHAR2 default hr_api.g_varchar2,
546: p_information13 in VARCHAR2 default hr_api.g_varchar2,
547: p_information14 in VARCHAR2 default hr_api.g_varchar2,

Line 544: p_information11 in VARCHAR2 default hr_api.g_varchar2,

540: p_information7 in VARCHAR2 default hr_api.g_varchar2,
541: p_information8 in VARCHAR2 default hr_api.g_varchar2,
542: p_information9 in VARCHAR2 default hr_api.g_varchar2,
543: p_information10 in VARCHAR2 default hr_api.g_varchar2,
544: p_information11 in VARCHAR2 default hr_api.g_varchar2,
545: p_information12 in VARCHAR2 default hr_api.g_varchar2,
546: p_information13 in VARCHAR2 default hr_api.g_varchar2,
547: p_information14 in VARCHAR2 default hr_api.g_varchar2,
548: p_information15 in VARCHAR2 default hr_api.g_varchar2,

Line 545: p_information12 in VARCHAR2 default hr_api.g_varchar2,

541: p_information8 in VARCHAR2 default hr_api.g_varchar2,
542: p_information9 in VARCHAR2 default hr_api.g_varchar2,
543: p_information10 in VARCHAR2 default hr_api.g_varchar2,
544: p_information11 in VARCHAR2 default hr_api.g_varchar2,
545: p_information12 in VARCHAR2 default hr_api.g_varchar2,
546: p_information13 in VARCHAR2 default hr_api.g_varchar2,
547: p_information14 in VARCHAR2 default hr_api.g_varchar2,
548: p_information15 in VARCHAR2 default hr_api.g_varchar2,
549: p_information16 in VARCHAR2 default hr_api.g_varchar2,

Line 546: p_information13 in VARCHAR2 default hr_api.g_varchar2,

542: p_information9 in VARCHAR2 default hr_api.g_varchar2,
543: p_information10 in VARCHAR2 default hr_api.g_varchar2,
544: p_information11 in VARCHAR2 default hr_api.g_varchar2,
545: p_information12 in VARCHAR2 default hr_api.g_varchar2,
546: p_information13 in VARCHAR2 default hr_api.g_varchar2,
547: p_information14 in VARCHAR2 default hr_api.g_varchar2,
548: p_information15 in VARCHAR2 default hr_api.g_varchar2,
549: p_information16 in VARCHAR2 default hr_api.g_varchar2,
550: p_information17 in VARCHAR2 default hr_api.g_varchar2,

Line 547: p_information14 in VARCHAR2 default hr_api.g_varchar2,

543: p_information10 in VARCHAR2 default hr_api.g_varchar2,
544: p_information11 in VARCHAR2 default hr_api.g_varchar2,
545: p_information12 in VARCHAR2 default hr_api.g_varchar2,
546: p_information13 in VARCHAR2 default hr_api.g_varchar2,
547: p_information14 in VARCHAR2 default hr_api.g_varchar2,
548: p_information15 in VARCHAR2 default hr_api.g_varchar2,
549: p_information16 in VARCHAR2 default hr_api.g_varchar2,
550: p_information17 in VARCHAR2 default hr_api.g_varchar2,
551: p_information18 in VARCHAR2 default hr_api.g_varchar2,

Line 548: p_information15 in VARCHAR2 default hr_api.g_varchar2,

544: p_information11 in VARCHAR2 default hr_api.g_varchar2,
545: p_information12 in VARCHAR2 default hr_api.g_varchar2,
546: p_information13 in VARCHAR2 default hr_api.g_varchar2,
547: p_information14 in VARCHAR2 default hr_api.g_varchar2,
548: p_information15 in VARCHAR2 default hr_api.g_varchar2,
549: p_information16 in VARCHAR2 default hr_api.g_varchar2,
550: p_information17 in VARCHAR2 default hr_api.g_varchar2,
551: p_information18 in VARCHAR2 default hr_api.g_varchar2,
552: p_information19 in VARCHAR2 default hr_api.g_varchar2,

Line 549: p_information16 in VARCHAR2 default hr_api.g_varchar2,

545: p_information12 in VARCHAR2 default hr_api.g_varchar2,
546: p_information13 in VARCHAR2 default hr_api.g_varchar2,
547: p_information14 in VARCHAR2 default hr_api.g_varchar2,
548: p_information15 in VARCHAR2 default hr_api.g_varchar2,
549: p_information16 in VARCHAR2 default hr_api.g_varchar2,
550: p_information17 in VARCHAR2 default hr_api.g_varchar2,
551: p_information18 in VARCHAR2 default hr_api.g_varchar2,
552: p_information19 in VARCHAR2 default hr_api.g_varchar2,
553: p_information20 in VARCHAR2 default hr_api.g_varchar2,

Line 550: p_information17 in VARCHAR2 default hr_api.g_varchar2,

546: p_information13 in VARCHAR2 default hr_api.g_varchar2,
547: p_information14 in VARCHAR2 default hr_api.g_varchar2,
548: p_information15 in VARCHAR2 default hr_api.g_varchar2,
549: p_information16 in VARCHAR2 default hr_api.g_varchar2,
550: p_information17 in VARCHAR2 default hr_api.g_varchar2,
551: p_information18 in VARCHAR2 default hr_api.g_varchar2,
552: p_information19 in VARCHAR2 default hr_api.g_varchar2,
553: p_information20 in VARCHAR2 default hr_api.g_varchar2,
554: p_information21 in VARCHAR2 default hr_api.g_varchar2,

Line 551: p_information18 in VARCHAR2 default hr_api.g_varchar2,

547: p_information14 in VARCHAR2 default hr_api.g_varchar2,
548: p_information15 in VARCHAR2 default hr_api.g_varchar2,
549: p_information16 in VARCHAR2 default hr_api.g_varchar2,
550: p_information17 in VARCHAR2 default hr_api.g_varchar2,
551: p_information18 in VARCHAR2 default hr_api.g_varchar2,
552: p_information19 in VARCHAR2 default hr_api.g_varchar2,
553: p_information20 in VARCHAR2 default hr_api.g_varchar2,
554: p_information21 in VARCHAR2 default hr_api.g_varchar2,
555: p_information22 in VARCHAR2 default hr_api.g_varchar2,

Line 552: p_information19 in VARCHAR2 default hr_api.g_varchar2,

548: p_information15 in VARCHAR2 default hr_api.g_varchar2,
549: p_information16 in VARCHAR2 default hr_api.g_varchar2,
550: p_information17 in VARCHAR2 default hr_api.g_varchar2,
551: p_information18 in VARCHAR2 default hr_api.g_varchar2,
552: p_information19 in VARCHAR2 default hr_api.g_varchar2,
553: p_information20 in VARCHAR2 default hr_api.g_varchar2,
554: p_information21 in VARCHAR2 default hr_api.g_varchar2,
555: p_information22 in VARCHAR2 default hr_api.g_varchar2,
556: p_information23 in VARCHAR2 default hr_api.g_varchar2,

Line 553: p_information20 in VARCHAR2 default hr_api.g_varchar2,

549: p_information16 in VARCHAR2 default hr_api.g_varchar2,
550: p_information17 in VARCHAR2 default hr_api.g_varchar2,
551: p_information18 in VARCHAR2 default hr_api.g_varchar2,
552: p_information19 in VARCHAR2 default hr_api.g_varchar2,
553: p_information20 in VARCHAR2 default hr_api.g_varchar2,
554: p_information21 in VARCHAR2 default hr_api.g_varchar2,
555: p_information22 in VARCHAR2 default hr_api.g_varchar2,
556: p_information23 in VARCHAR2 default hr_api.g_varchar2,
557: p_information24 in VARCHAR2 default hr_api.g_varchar2,

Line 554: p_information21 in VARCHAR2 default hr_api.g_varchar2,

550: p_information17 in VARCHAR2 default hr_api.g_varchar2,
551: p_information18 in VARCHAR2 default hr_api.g_varchar2,
552: p_information19 in VARCHAR2 default hr_api.g_varchar2,
553: p_information20 in VARCHAR2 default hr_api.g_varchar2,
554: p_information21 in VARCHAR2 default hr_api.g_varchar2,
555: p_information22 in VARCHAR2 default hr_api.g_varchar2,
556: p_information23 in VARCHAR2 default hr_api.g_varchar2,
557: p_information24 in VARCHAR2 default hr_api.g_varchar2,
558: p_information25 in VARCHAR2 default hr_api.g_varchar2,

Line 555: p_information22 in VARCHAR2 default hr_api.g_varchar2,

551: p_information18 in VARCHAR2 default hr_api.g_varchar2,
552: p_information19 in VARCHAR2 default hr_api.g_varchar2,
553: p_information20 in VARCHAR2 default hr_api.g_varchar2,
554: p_information21 in VARCHAR2 default hr_api.g_varchar2,
555: p_information22 in VARCHAR2 default hr_api.g_varchar2,
556: p_information23 in VARCHAR2 default hr_api.g_varchar2,
557: p_information24 in VARCHAR2 default hr_api.g_varchar2,
558: p_information25 in VARCHAR2 default hr_api.g_varchar2,
559: p_information26 in VARCHAR2 default hr_api.g_varchar2,

Line 556: p_information23 in VARCHAR2 default hr_api.g_varchar2,

552: p_information19 in VARCHAR2 default hr_api.g_varchar2,
553: p_information20 in VARCHAR2 default hr_api.g_varchar2,
554: p_information21 in VARCHAR2 default hr_api.g_varchar2,
555: p_information22 in VARCHAR2 default hr_api.g_varchar2,
556: p_information23 in VARCHAR2 default hr_api.g_varchar2,
557: p_information24 in VARCHAR2 default hr_api.g_varchar2,
558: p_information25 in VARCHAR2 default hr_api.g_varchar2,
559: p_information26 in VARCHAR2 default hr_api.g_varchar2,
560: p_information27 in VARCHAR2 default hr_api.g_varchar2,

Line 557: p_information24 in VARCHAR2 default hr_api.g_varchar2,

553: p_information20 in VARCHAR2 default hr_api.g_varchar2,
554: p_information21 in VARCHAR2 default hr_api.g_varchar2,
555: p_information22 in VARCHAR2 default hr_api.g_varchar2,
556: p_information23 in VARCHAR2 default hr_api.g_varchar2,
557: p_information24 in VARCHAR2 default hr_api.g_varchar2,
558: p_information25 in VARCHAR2 default hr_api.g_varchar2,
559: p_information26 in VARCHAR2 default hr_api.g_varchar2,
560: p_information27 in VARCHAR2 default hr_api.g_varchar2,
561: p_information28 in VARCHAR2 default hr_api.g_varchar2,

Line 558: p_information25 in VARCHAR2 default hr_api.g_varchar2,

554: p_information21 in VARCHAR2 default hr_api.g_varchar2,
555: p_information22 in VARCHAR2 default hr_api.g_varchar2,
556: p_information23 in VARCHAR2 default hr_api.g_varchar2,
557: p_information24 in VARCHAR2 default hr_api.g_varchar2,
558: p_information25 in VARCHAR2 default hr_api.g_varchar2,
559: p_information26 in VARCHAR2 default hr_api.g_varchar2,
560: p_information27 in VARCHAR2 default hr_api.g_varchar2,
561: p_information28 in VARCHAR2 default hr_api.g_varchar2,
562: p_information29 in VARCHAR2 default hr_api.g_varchar2,

Line 559: p_information26 in VARCHAR2 default hr_api.g_varchar2,

555: p_information22 in VARCHAR2 default hr_api.g_varchar2,
556: p_information23 in VARCHAR2 default hr_api.g_varchar2,
557: p_information24 in VARCHAR2 default hr_api.g_varchar2,
558: p_information25 in VARCHAR2 default hr_api.g_varchar2,
559: p_information26 in VARCHAR2 default hr_api.g_varchar2,
560: p_information27 in VARCHAR2 default hr_api.g_varchar2,
561: p_information28 in VARCHAR2 default hr_api.g_varchar2,
562: p_information29 in VARCHAR2 default hr_api.g_varchar2,
563: p_information30 in VARCHAR2 default hr_api.g_varchar2

Line 560: p_information27 in VARCHAR2 default hr_api.g_varchar2,

556: p_information23 in VARCHAR2 default hr_api.g_varchar2,
557: p_information24 in VARCHAR2 default hr_api.g_varchar2,
558: p_information25 in VARCHAR2 default hr_api.g_varchar2,
559: p_information26 in VARCHAR2 default hr_api.g_varchar2,
560: p_information27 in VARCHAR2 default hr_api.g_varchar2,
561: p_information28 in VARCHAR2 default hr_api.g_varchar2,
562: p_information29 in VARCHAR2 default hr_api.g_varchar2,
563: p_information30 in VARCHAR2 default hr_api.g_varchar2
564:

Line 561: p_information28 in VARCHAR2 default hr_api.g_varchar2,

557: p_information24 in VARCHAR2 default hr_api.g_varchar2,
558: p_information25 in VARCHAR2 default hr_api.g_varchar2,
559: p_information26 in VARCHAR2 default hr_api.g_varchar2,
560: p_information27 in VARCHAR2 default hr_api.g_varchar2,
561: p_information28 in VARCHAR2 default hr_api.g_varchar2,
562: p_information29 in VARCHAR2 default hr_api.g_varchar2,
563: p_information30 in VARCHAR2 default hr_api.g_varchar2
564:
565:

Line 562: p_information29 in VARCHAR2 default hr_api.g_varchar2,

558: p_information25 in VARCHAR2 default hr_api.g_varchar2,
559: p_information26 in VARCHAR2 default hr_api.g_varchar2,
560: p_information27 in VARCHAR2 default hr_api.g_varchar2,
561: p_information28 in VARCHAR2 default hr_api.g_varchar2,
562: p_information29 in VARCHAR2 default hr_api.g_varchar2,
563: p_information30 in VARCHAR2 default hr_api.g_varchar2
564:
565:
566: ) is

Line 563: p_information30 in VARCHAR2 default hr_api.g_varchar2

559: p_information26 in VARCHAR2 default hr_api.g_varchar2,
560: p_information27 in VARCHAR2 default hr_api.g_varchar2,
561: p_information28 in VARCHAR2 default hr_api.g_varchar2,
562: p_information29 in VARCHAR2 default hr_api.g_varchar2,
563: p_information30 in VARCHAR2 default hr_api.g_varchar2
564:
565:
566: ) is
567: --