APPS.PER_BIL_UPD dependencies on HR_API

Line 98: When hr_api.check_integrity_violated Then

94: --
95: hr_utility.set_location(' Leaving:'||l_proc, 10);
96: --
97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: per_bil_shd.g_api_dml := false; -- Unset the api dml status
101: per_bil_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: per_bil_shd.g_api_dml := false; -- Unset the api dml status
101: per_bil_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_bil_shd.g_api_dml := false; -- Unset the api dml status
106: per_bil_shd.constraint_error

Line 103: When hr_api.parent_integrity_violated Then

99: -- A check constraint has been violated
100: per_bil_shd.g_api_dml := false; -- Unset the api dml status
101: per_bil_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_bil_shd.g_api_dml := false; -- Unset the api dml status
106: per_bil_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_bil_shd.g_api_dml := false; -- Unset the api dml status
106: per_bil_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: per_bil_shd.g_api_dml := false; -- Unset the api dml status
111: per_bil_shd.constraint_error

Line 108: When hr_api.unique_integrity_violated Then

104: -- Parent integrity has been violated
105: per_bil_shd.g_api_dml := false; -- Unset the api dml status
106: per_bil_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: per_bil_shd.g_api_dml := false; -- Unset the api dml status
111: per_bil_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: per_bil_shd.g_api_dml := false; -- Unset the api dml status
111: per_bil_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: per_bil_shd.g_api_dml := false; -- Unset the api dml status
115: Raise;
116: End update_dml;

Line 253: when hr_api.cannot_find_prog_unit then

249: null;
250: --
251: exception
252: --
253: when hr_api.cannot_find_prog_unit then
254: --
255: hr_api.cannot_find_prog_unit_error
256: (p_module_name => 'hr_summary'
257: ,p_hook_type => 'AU');

Line 255: hr_api.cannot_find_prog_unit_error

251: exception
252: --
253: when hr_api.cannot_find_prog_unit then
254: --
255: hr_api.cannot_find_prog_unit_error
256: (p_module_name => 'hr_summary'
257: ,p_hook_type => 'AU');
258: --
259: end;

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

319: -- p_rec plsql record structure
320: -- to see if a system default is being used. If a system default
321: -- is being used then we must set to the 'current' argument value.
322: --
323: If (p_rec.type = hr_api.g_varchar2) then
324: p_rec.type :=
325: per_bil_shd.g_old_rec.type;
326: End If;
327: If (p_rec.business_group_id = hr_api.g_number) then

Line 327: If (p_rec.business_group_id = hr_api.g_number) then

323: If (p_rec.type = hr_api.g_varchar2) then
324: p_rec.type :=
325: per_bil_shd.g_old_rec.type;
326: End If;
327: If (p_rec.business_group_id = hr_api.g_number) then
328: p_rec.business_group_id :=
329: per_bil_shd.g_old_rec.business_group_id;
330: End If;
331: If (p_rec.fk_value1 = hr_api.g_number) then

Line 331: If (p_rec.fk_value1 = hr_api.g_number) then

327: If (p_rec.business_group_id = hr_api.g_number) then
328: p_rec.business_group_id :=
329: per_bil_shd.g_old_rec.business_group_id;
330: End If;
331: If (p_rec.fk_value1 = hr_api.g_number) then
332: p_rec.fk_value1 :=
333: per_bil_shd.g_old_rec.fk_value1;
334: End If;
335: If (p_rec.fk_value2 = hr_api.g_number) then

Line 335: If (p_rec.fk_value2 = hr_api.g_number) then

331: If (p_rec.fk_value1 = hr_api.g_number) then
332: p_rec.fk_value1 :=
333: per_bil_shd.g_old_rec.fk_value1;
334: End If;
335: If (p_rec.fk_value2 = hr_api.g_number) then
336: p_rec.fk_value2 :=
337: per_bil_shd.g_old_rec.fk_value2;
338: End If;
339: If (p_rec.fk_value3 = hr_api.g_number) then

Line 339: If (p_rec.fk_value3 = hr_api.g_number) then

335: If (p_rec.fk_value2 = hr_api.g_number) then
336: p_rec.fk_value2 :=
337: per_bil_shd.g_old_rec.fk_value2;
338: End If;
339: If (p_rec.fk_value3 = hr_api.g_number) then
340: p_rec.fk_value3 :=
341: per_bil_shd.g_old_rec.fk_value3;
342: End If;
343: If (p_rec.text_value1 = hr_api.g_varchar2) then

Line 343: If (p_rec.text_value1 = hr_api.g_varchar2) then

339: If (p_rec.fk_value3 = hr_api.g_number) then
340: p_rec.fk_value3 :=
341: per_bil_shd.g_old_rec.fk_value3;
342: End If;
343: If (p_rec.text_value1 = hr_api.g_varchar2) then
344: p_rec.text_value1 :=
345: per_bil_shd.g_old_rec.text_value1;
346: End If;
347: If (p_rec.text_value2 = hr_api.g_varchar2) then

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

343: If (p_rec.text_value1 = hr_api.g_varchar2) then
344: p_rec.text_value1 :=
345: per_bil_shd.g_old_rec.text_value1;
346: End If;
347: If (p_rec.text_value2 = hr_api.g_varchar2) then
348: p_rec.text_value2 :=
349: per_bil_shd.g_old_rec.text_value2;
350: End If;
351: If (p_rec.text_value3 = hr_api.g_varchar2) then

Line 351: If (p_rec.text_value3 = hr_api.g_varchar2) then

347: If (p_rec.text_value2 = hr_api.g_varchar2) then
348: p_rec.text_value2 :=
349: per_bil_shd.g_old_rec.text_value2;
350: End If;
351: If (p_rec.text_value3 = hr_api.g_varchar2) then
352: p_rec.text_value3 :=
353: per_bil_shd.g_old_rec.text_value3;
354: End If;
355: If (p_rec.text_value4 = hr_api.g_varchar2) then

Line 355: If (p_rec.text_value4 = hr_api.g_varchar2) then

351: If (p_rec.text_value3 = hr_api.g_varchar2) then
352: p_rec.text_value3 :=
353: per_bil_shd.g_old_rec.text_value3;
354: End If;
355: If (p_rec.text_value4 = hr_api.g_varchar2) then
356: p_rec.text_value4 :=
357: per_bil_shd.g_old_rec.text_value4;
358: End If;
359: If (p_rec.text_value5 = hr_api.g_varchar2) then

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

355: If (p_rec.text_value4 = hr_api.g_varchar2) then
356: p_rec.text_value4 :=
357: per_bil_shd.g_old_rec.text_value4;
358: End If;
359: If (p_rec.text_value5 = hr_api.g_varchar2) then
360: p_rec.text_value5 :=
361: per_bil_shd.g_old_rec.text_value5;
362: End If;
363: If (p_rec.text_value6 = hr_api.g_varchar2) then

Line 363: If (p_rec.text_value6 = hr_api.g_varchar2) then

359: If (p_rec.text_value5 = hr_api.g_varchar2) then
360: p_rec.text_value5 :=
361: per_bil_shd.g_old_rec.text_value5;
362: End If;
363: If (p_rec.text_value6 = hr_api.g_varchar2) then
364: p_rec.text_value6 :=
365: per_bil_shd.g_old_rec.text_value6;
366: End If;
367: If (p_rec.text_value7 = hr_api.g_varchar2) then

Line 367: If (p_rec.text_value7 = hr_api.g_varchar2) then

363: If (p_rec.text_value6 = hr_api.g_varchar2) then
364: p_rec.text_value6 :=
365: per_bil_shd.g_old_rec.text_value6;
366: End If;
367: If (p_rec.text_value7 = hr_api.g_varchar2) then
368: p_rec.text_value7 :=
369: per_bil_shd.g_old_rec.text_value7;
370: End If;
371: If (p_rec.num_value1 = hr_api.g_number) then

Line 371: If (p_rec.num_value1 = hr_api.g_number) then

367: If (p_rec.text_value7 = hr_api.g_varchar2) then
368: p_rec.text_value7 :=
369: per_bil_shd.g_old_rec.text_value7;
370: End If;
371: If (p_rec.num_value1 = hr_api.g_number) then
372: p_rec.num_value1 :=
373: per_bil_shd.g_old_rec.num_value1;
374: End If;
375: If (p_rec.num_value2 = hr_api.g_number) then

Line 375: If (p_rec.num_value2 = hr_api.g_number) then

371: If (p_rec.num_value1 = hr_api.g_number) then
372: p_rec.num_value1 :=
373: per_bil_shd.g_old_rec.num_value1;
374: End If;
375: If (p_rec.num_value2 = hr_api.g_number) then
376: p_rec.num_value2 :=
377: per_bil_shd.g_old_rec.num_value2;
378: End If;
379: If (p_rec.num_value3 = hr_api.g_number) then

Line 379: If (p_rec.num_value3 = hr_api.g_number) then

375: If (p_rec.num_value2 = hr_api.g_number) then
376: p_rec.num_value2 :=
377: per_bil_shd.g_old_rec.num_value2;
378: End If;
379: If (p_rec.num_value3 = hr_api.g_number) then
380: p_rec.num_value3 :=
381: per_bil_shd.g_old_rec.num_value3;
382: End If;
383: If (p_rec.date_value1 = hr_api.g_date) then

Line 383: If (p_rec.date_value1 = hr_api.g_date) then

379: If (p_rec.num_value3 = hr_api.g_number) then
380: p_rec.num_value3 :=
381: per_bil_shd.g_old_rec.num_value3;
382: End If;
383: If (p_rec.date_value1 = hr_api.g_date) then
384: p_rec.date_value1 :=
385: per_bil_shd.g_old_rec.date_value1;
386: End If;
387: If (p_rec.date_value2 = hr_api.g_date) then

Line 387: If (p_rec.date_value2 = hr_api.g_date) then

383: If (p_rec.date_value1 = hr_api.g_date) then
384: p_rec.date_value1 :=
385: per_bil_shd.g_old_rec.date_value1;
386: End If;
387: If (p_rec.date_value2 = hr_api.g_date) then
388: p_rec.date_value2 :=
389: per_bil_shd.g_old_rec.date_value2;
390: End If;
391: If (p_rec.date_value3 = hr_api.g_date) then

Line 391: If (p_rec.date_value3 = hr_api.g_date) then

387: If (p_rec.date_value2 = hr_api.g_date) then
388: p_rec.date_value2 :=
389: per_bil_shd.g_old_rec.date_value2;
390: End If;
391: If (p_rec.date_value3 = hr_api.g_date) then
392: p_rec.date_value3 :=
393: per_bil_shd.g_old_rec.date_value3;
394: End If;
395: --

Line 449: p_type in varchar2 default hr_api.g_varchar2,

445: -- |---------------------------------< upd >----------------------------------|
446: -- ----------------------------------------------------------------------------
447: Procedure upd
448: (
449: p_type in varchar2 default hr_api.g_varchar2,
450: p_business_group_id in number default hr_api.g_number,
451: p_object_version_number in out nocopy number,
452: p_id_value in number,
453: p_fk_value1 in number default hr_api.g_number,

Line 450: p_business_group_id in number default hr_api.g_number,

446: -- ----------------------------------------------------------------------------
447: Procedure upd
448: (
449: p_type in varchar2 default hr_api.g_varchar2,
450: p_business_group_id in number default hr_api.g_number,
451: p_object_version_number in out nocopy number,
452: p_id_value in number,
453: p_fk_value1 in number default hr_api.g_number,
454: p_fk_value2 in number default hr_api.g_number,

Line 453: p_fk_value1 in number default hr_api.g_number,

449: p_type in varchar2 default hr_api.g_varchar2,
450: p_business_group_id in number default hr_api.g_number,
451: p_object_version_number in out nocopy number,
452: p_id_value in number,
453: p_fk_value1 in number default hr_api.g_number,
454: p_fk_value2 in number default hr_api.g_number,
455: p_fk_value3 in number default hr_api.g_number,
456: p_text_value1 in varchar2 default hr_api.g_varchar2,
457: p_text_value2 in varchar2 default hr_api.g_varchar2,

Line 454: p_fk_value2 in number default hr_api.g_number,

450: p_business_group_id in number default hr_api.g_number,
451: p_object_version_number in out nocopy number,
452: p_id_value in number,
453: p_fk_value1 in number default hr_api.g_number,
454: p_fk_value2 in number default hr_api.g_number,
455: p_fk_value3 in number default hr_api.g_number,
456: p_text_value1 in varchar2 default hr_api.g_varchar2,
457: p_text_value2 in varchar2 default hr_api.g_varchar2,
458: p_text_value3 in varchar2 default hr_api.g_varchar2,

Line 455: p_fk_value3 in number default hr_api.g_number,

451: p_object_version_number in out nocopy number,
452: p_id_value in number,
453: p_fk_value1 in number default hr_api.g_number,
454: p_fk_value2 in number default hr_api.g_number,
455: p_fk_value3 in number default hr_api.g_number,
456: p_text_value1 in varchar2 default hr_api.g_varchar2,
457: p_text_value2 in varchar2 default hr_api.g_varchar2,
458: p_text_value3 in varchar2 default hr_api.g_varchar2,
459: p_text_value4 in varchar2 default hr_api.g_varchar2,

Line 456: p_text_value1 in varchar2 default hr_api.g_varchar2,

452: p_id_value in number,
453: p_fk_value1 in number default hr_api.g_number,
454: p_fk_value2 in number default hr_api.g_number,
455: p_fk_value3 in number default hr_api.g_number,
456: p_text_value1 in varchar2 default hr_api.g_varchar2,
457: p_text_value2 in varchar2 default hr_api.g_varchar2,
458: p_text_value3 in varchar2 default hr_api.g_varchar2,
459: p_text_value4 in varchar2 default hr_api.g_varchar2,
460: p_text_value5 in varchar2 default hr_api.g_varchar2,

Line 457: p_text_value2 in varchar2 default hr_api.g_varchar2,

453: p_fk_value1 in number default hr_api.g_number,
454: p_fk_value2 in number default hr_api.g_number,
455: p_fk_value3 in number default hr_api.g_number,
456: p_text_value1 in varchar2 default hr_api.g_varchar2,
457: p_text_value2 in varchar2 default hr_api.g_varchar2,
458: p_text_value3 in varchar2 default hr_api.g_varchar2,
459: p_text_value4 in varchar2 default hr_api.g_varchar2,
460: p_text_value5 in varchar2 default hr_api.g_varchar2,
461: p_text_value6 in varchar2 default hr_api.g_varchar2,

Line 458: p_text_value3 in varchar2 default hr_api.g_varchar2,

454: p_fk_value2 in number default hr_api.g_number,
455: p_fk_value3 in number default hr_api.g_number,
456: p_text_value1 in varchar2 default hr_api.g_varchar2,
457: p_text_value2 in varchar2 default hr_api.g_varchar2,
458: p_text_value3 in varchar2 default hr_api.g_varchar2,
459: p_text_value4 in varchar2 default hr_api.g_varchar2,
460: p_text_value5 in varchar2 default hr_api.g_varchar2,
461: p_text_value6 in varchar2 default hr_api.g_varchar2,
462: p_text_value7 in varchar2 default hr_api.g_varchar2,

Line 459: p_text_value4 in varchar2 default hr_api.g_varchar2,

455: p_fk_value3 in number default hr_api.g_number,
456: p_text_value1 in varchar2 default hr_api.g_varchar2,
457: p_text_value2 in varchar2 default hr_api.g_varchar2,
458: p_text_value3 in varchar2 default hr_api.g_varchar2,
459: p_text_value4 in varchar2 default hr_api.g_varchar2,
460: p_text_value5 in varchar2 default hr_api.g_varchar2,
461: p_text_value6 in varchar2 default hr_api.g_varchar2,
462: p_text_value7 in varchar2 default hr_api.g_varchar2,
463: p_num_value1 in number default hr_api.g_number,

Line 460: p_text_value5 in varchar2 default hr_api.g_varchar2,

456: p_text_value1 in varchar2 default hr_api.g_varchar2,
457: p_text_value2 in varchar2 default hr_api.g_varchar2,
458: p_text_value3 in varchar2 default hr_api.g_varchar2,
459: p_text_value4 in varchar2 default hr_api.g_varchar2,
460: p_text_value5 in varchar2 default hr_api.g_varchar2,
461: p_text_value6 in varchar2 default hr_api.g_varchar2,
462: p_text_value7 in varchar2 default hr_api.g_varchar2,
463: p_num_value1 in number default hr_api.g_number,
464: p_num_value2 in number default hr_api.g_number,

Line 461: p_text_value6 in varchar2 default hr_api.g_varchar2,

457: p_text_value2 in varchar2 default hr_api.g_varchar2,
458: p_text_value3 in varchar2 default hr_api.g_varchar2,
459: p_text_value4 in varchar2 default hr_api.g_varchar2,
460: p_text_value5 in varchar2 default hr_api.g_varchar2,
461: p_text_value6 in varchar2 default hr_api.g_varchar2,
462: p_text_value7 in varchar2 default hr_api.g_varchar2,
463: p_num_value1 in number default hr_api.g_number,
464: p_num_value2 in number default hr_api.g_number,
465: p_num_value3 in number default hr_api.g_number,

Line 462: p_text_value7 in varchar2 default hr_api.g_varchar2,

458: p_text_value3 in varchar2 default hr_api.g_varchar2,
459: p_text_value4 in varchar2 default hr_api.g_varchar2,
460: p_text_value5 in varchar2 default hr_api.g_varchar2,
461: p_text_value6 in varchar2 default hr_api.g_varchar2,
462: p_text_value7 in varchar2 default hr_api.g_varchar2,
463: p_num_value1 in number default hr_api.g_number,
464: p_num_value2 in number default hr_api.g_number,
465: p_num_value3 in number default hr_api.g_number,
466: p_date_value1 in date default hr_api.g_date,

Line 463: p_num_value1 in number default hr_api.g_number,

459: p_text_value4 in varchar2 default hr_api.g_varchar2,
460: p_text_value5 in varchar2 default hr_api.g_varchar2,
461: p_text_value6 in varchar2 default hr_api.g_varchar2,
462: p_text_value7 in varchar2 default hr_api.g_varchar2,
463: p_num_value1 in number default hr_api.g_number,
464: p_num_value2 in number default hr_api.g_number,
465: p_num_value3 in number default hr_api.g_number,
466: p_date_value1 in date default hr_api.g_date,
467: p_date_value2 in date default hr_api.g_date,

Line 464: p_num_value2 in number default hr_api.g_number,

460: p_text_value5 in varchar2 default hr_api.g_varchar2,
461: p_text_value6 in varchar2 default hr_api.g_varchar2,
462: p_text_value7 in varchar2 default hr_api.g_varchar2,
463: p_num_value1 in number default hr_api.g_number,
464: p_num_value2 in number default hr_api.g_number,
465: p_num_value3 in number default hr_api.g_number,
466: p_date_value1 in date default hr_api.g_date,
467: p_date_value2 in date default hr_api.g_date,
468: p_date_value3 in date default hr_api.g_date

Line 465: p_num_value3 in number default hr_api.g_number,

461: p_text_value6 in varchar2 default hr_api.g_varchar2,
462: p_text_value7 in varchar2 default hr_api.g_varchar2,
463: p_num_value1 in number default hr_api.g_number,
464: p_num_value2 in number default hr_api.g_number,
465: p_num_value3 in number default hr_api.g_number,
466: p_date_value1 in date default hr_api.g_date,
467: p_date_value2 in date default hr_api.g_date,
468: p_date_value3 in date default hr_api.g_date
469: ) is

Line 466: p_date_value1 in date default hr_api.g_date,

462: p_text_value7 in varchar2 default hr_api.g_varchar2,
463: p_num_value1 in number default hr_api.g_number,
464: p_num_value2 in number default hr_api.g_number,
465: p_num_value3 in number default hr_api.g_number,
466: p_date_value1 in date default hr_api.g_date,
467: p_date_value2 in date default hr_api.g_date,
468: p_date_value3 in date default hr_api.g_date
469: ) is
470: --

Line 467: p_date_value2 in date default hr_api.g_date,

463: p_num_value1 in number default hr_api.g_number,
464: p_num_value2 in number default hr_api.g_number,
465: p_num_value3 in number default hr_api.g_number,
466: p_date_value1 in date default hr_api.g_date,
467: p_date_value2 in date default hr_api.g_date,
468: p_date_value3 in date default hr_api.g_date
469: ) is
470: --
471: l_rec per_bil_shd.g_rec_type;

Line 468: p_date_value3 in date default hr_api.g_date

464: p_num_value2 in number default hr_api.g_number,
465: p_num_value3 in number default hr_api.g_number,
466: p_date_value1 in date default hr_api.g_date,
467: p_date_value2 in date default hr_api.g_date,
468: p_date_value3 in date default hr_api.g_date
469: ) is
470: --
471: l_rec per_bil_shd.g_rec_type;
472: l_proc varchar2(72) := g_package||'upd';