eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_BTH_UPD dependencies on HR_API

Line 95: When hr_api.check_integrity_violated Then

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

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

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

Line 100: When hr_api.parent_integrity_violated Then

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

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

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

Line 105: When hr_api.unique_integrity_violated Then

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

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

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

Line 273: when hr_api.cannot_find_prog_unit then

269: );
270: --
271: exception
272: --
273: when hr_api.cannot_find_prog_unit then
274: --
275: hr_api.cannot_find_prog_unit_error
276: (p_module_name => 'PAY_BATCH_HEADERS'
277: ,p_hook_type => 'AU');

Line 275: hr_api.cannot_find_prog_unit_error

271: exception
272: --
273: when hr_api.cannot_find_prog_unit then
274: --
275: hr_api.cannot_find_prog_unit_error
276: (p_module_name => 'PAY_BATCH_HEADERS'
277: ,p_hook_type => 'AU');
278: --
279: end;

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

334: -- p_rec plsql record structure
335: -- to see if a system default is being used. If a system default
336: -- is being used then we must set to the 'current' argument value.
337: --
338: If (p_rec.business_group_id = hr_api.g_number) then
339: p_rec.business_group_id :=
340: pay_bth_shd.g_old_rec.business_group_id;
341: End If;
342: If (p_rec.batch_name = hr_api.g_varchar2) then

Line 342: If (p_rec.batch_name = hr_api.g_varchar2) then

338: If (p_rec.business_group_id = hr_api.g_number) then
339: p_rec.business_group_id :=
340: pay_bth_shd.g_old_rec.business_group_id;
341: End If;
342: If (p_rec.batch_name = hr_api.g_varchar2) then
343: p_rec.batch_name :=
344: pay_bth_shd.g_old_rec.batch_name;
345: End If;
346: If (p_rec.batch_status = hr_api.g_varchar2) then

Line 346: If (p_rec.batch_status = hr_api.g_varchar2) then

342: If (p_rec.batch_name = hr_api.g_varchar2) then
343: p_rec.batch_name :=
344: pay_bth_shd.g_old_rec.batch_name;
345: End If;
346: If (p_rec.batch_status = hr_api.g_varchar2) then
347: p_rec.batch_status :=
348: pay_bth_shd.g_old_rec.batch_status;
349: End If;
350: If (p_rec.action_if_exists = hr_api.g_varchar2) then

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

346: If (p_rec.batch_status = hr_api.g_varchar2) then
347: p_rec.batch_status :=
348: pay_bth_shd.g_old_rec.batch_status;
349: End If;
350: If (p_rec.action_if_exists = hr_api.g_varchar2) then
351: p_rec.action_if_exists :=
352: pay_bth_shd.g_old_rec.action_if_exists;
353: End If;
354: If (p_rec.batch_reference = hr_api.g_varchar2) then

Line 354: If (p_rec.batch_reference = hr_api.g_varchar2) then

350: If (p_rec.action_if_exists = hr_api.g_varchar2) then
351: p_rec.action_if_exists :=
352: pay_bth_shd.g_old_rec.action_if_exists;
353: End If;
354: If (p_rec.batch_reference = hr_api.g_varchar2) then
355: p_rec.batch_reference :=
356: pay_bth_shd.g_old_rec.batch_reference;
357: End If;
358: If (p_rec.batch_source = hr_api.g_varchar2) then

Line 358: If (p_rec.batch_source = hr_api.g_varchar2) then

354: If (p_rec.batch_reference = hr_api.g_varchar2) then
355: p_rec.batch_reference :=
356: pay_bth_shd.g_old_rec.batch_reference;
357: End If;
358: If (p_rec.batch_source = hr_api.g_varchar2) then
359: p_rec.batch_source :=
360: pay_bth_shd.g_old_rec.batch_source;
361: End If;
362: If (p_rec.batch_type = hr_api.g_varchar2) then

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

358: If (p_rec.batch_source = hr_api.g_varchar2) then
359: p_rec.batch_source :=
360: pay_bth_shd.g_old_rec.batch_source;
361: End If;
362: If (p_rec.batch_type = hr_api.g_varchar2) then
363: p_rec.batch_type :=
364: pay_bth_shd.g_old_rec.batch_type;
365: End If;
366: If (p_rec.comments = hr_api.g_varchar2) then

Line 366: If (p_rec.comments = hr_api.g_varchar2) then

362: If (p_rec.batch_type = hr_api.g_varchar2) then
363: p_rec.batch_type :=
364: pay_bth_shd.g_old_rec.batch_type;
365: End If;
366: If (p_rec.comments = hr_api.g_varchar2) then
367: p_rec.comments :=
368: pay_bth_shd.g_old_rec.comments;
369: End If;
370: If (p_rec.date_effective_changes = hr_api.g_varchar2) then

Line 370: If (p_rec.date_effective_changes = hr_api.g_varchar2) then

366: If (p_rec.comments = hr_api.g_varchar2) then
367: p_rec.comments :=
368: pay_bth_shd.g_old_rec.comments;
369: End If;
370: If (p_rec.date_effective_changes = hr_api.g_varchar2) then
371: p_rec.date_effective_changes :=
372: pay_bth_shd.g_old_rec.date_effective_changes;
373: End If;
374: If (p_rec.purge_after_transfer = hr_api.g_varchar2) then

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

370: If (p_rec.date_effective_changes = hr_api.g_varchar2) then
371: p_rec.date_effective_changes :=
372: pay_bth_shd.g_old_rec.date_effective_changes;
373: End If;
374: If (p_rec.purge_after_transfer = hr_api.g_varchar2) then
375: p_rec.purge_after_transfer :=
376: pay_bth_shd.g_old_rec.purge_after_transfer;
377: End If;
378: If (p_rec.reject_if_future_changes = hr_api.g_varchar2) then

Line 378: If (p_rec.reject_if_future_changes = hr_api.g_varchar2) then

374: If (p_rec.purge_after_transfer = hr_api.g_varchar2) then
375: p_rec.purge_after_transfer :=
376: pay_bth_shd.g_old_rec.purge_after_transfer;
377: End If;
378: If (p_rec.reject_if_future_changes = hr_api.g_varchar2) then
379: p_rec.reject_if_future_changes :=
380: pay_bth_shd.g_old_rec.reject_if_future_changes;
381: End If;
382: If (p_rec.reject_if_results_exists = hr_api.g_varchar2) then

Line 382: If (p_rec.reject_if_results_exists = hr_api.g_varchar2) then

378: If (p_rec.reject_if_future_changes = hr_api.g_varchar2) then
379: p_rec.reject_if_future_changes :=
380: pay_bth_shd.g_old_rec.reject_if_future_changes;
381: End If;
382: If (p_rec.reject_if_results_exists = hr_api.g_varchar2) then
383: p_rec.reject_if_results_exists :=
384: pay_bth_shd.g_old_rec.reject_if_results_exists;
385: End If;
386: If (p_rec.purge_after_rollback = hr_api.g_varchar2) then

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

382: If (p_rec.reject_if_results_exists = hr_api.g_varchar2) then
383: p_rec.reject_if_results_exists :=
384: pay_bth_shd.g_old_rec.reject_if_results_exists;
385: End If;
386: If (p_rec.purge_after_rollback = hr_api.g_varchar2) then
387: p_rec.purge_after_rollback :=
388: pay_bth_shd.g_old_rec.purge_after_rollback;
389: End If;
390: If (p_rec.REJECT_ENTRY_NOT_REMOVED = hr_api.g_varchar2) then

Line 390: If (p_rec.REJECT_ENTRY_NOT_REMOVED = hr_api.g_varchar2) then

386: If (p_rec.purge_after_rollback = hr_api.g_varchar2) then
387: p_rec.purge_after_rollback :=
388: pay_bth_shd.g_old_rec.purge_after_rollback;
389: End If;
390: If (p_rec.REJECT_ENTRY_NOT_REMOVED = hr_api.g_varchar2) then
391: p_rec.REJECT_ENTRY_NOT_REMOVED :=
392: pay_bth_shd.g_old_rec.REJECT_ENTRY_NOT_REMOVED;
393: End If;
394: If (p_rec.ROLLBACK_ENTRY_UPDATES = hr_api.g_varchar2) then

Line 394: If (p_rec.ROLLBACK_ENTRY_UPDATES = hr_api.g_varchar2) then

390: If (p_rec.REJECT_ENTRY_NOT_REMOVED = hr_api.g_varchar2) then
391: p_rec.REJECT_ENTRY_NOT_REMOVED :=
392: pay_bth_shd.g_old_rec.REJECT_ENTRY_NOT_REMOVED;
393: End If;
394: If (p_rec.ROLLBACK_ENTRY_UPDATES = hr_api.g_varchar2) then
395: p_rec.ROLLBACK_ENTRY_UPDATES :=
396: pay_bth_shd.g_old_rec.ROLLBACK_ENTRY_UPDATES;
397: End If;
398: --

Line 456: ,p_batch_name in varchar2 default hr_api.g_varchar2

452: Procedure upd
453: (p_session_date in date
454: ,p_batch_id in number
455: ,p_object_version_number in out nocopy number
456: ,p_batch_name in varchar2 default hr_api.g_varchar2
457: ,p_batch_status in varchar2 default hr_api.g_varchar2
458: ,p_action_if_exists in varchar2 default hr_api.g_varchar2
459: ,p_batch_reference in varchar2 default hr_api.g_varchar2
460: ,p_batch_source in varchar2 default hr_api.g_varchar2

Line 457: ,p_batch_status in varchar2 default hr_api.g_varchar2

453: (p_session_date in date
454: ,p_batch_id in number
455: ,p_object_version_number in out nocopy number
456: ,p_batch_name in varchar2 default hr_api.g_varchar2
457: ,p_batch_status in varchar2 default hr_api.g_varchar2
458: ,p_action_if_exists in varchar2 default hr_api.g_varchar2
459: ,p_batch_reference in varchar2 default hr_api.g_varchar2
460: ,p_batch_source in varchar2 default hr_api.g_varchar2
461: ,p_batch_type in varchar2 default hr_api.g_varchar2

Line 458: ,p_action_if_exists in varchar2 default hr_api.g_varchar2

454: ,p_batch_id in number
455: ,p_object_version_number in out nocopy number
456: ,p_batch_name in varchar2 default hr_api.g_varchar2
457: ,p_batch_status in varchar2 default hr_api.g_varchar2
458: ,p_action_if_exists in varchar2 default hr_api.g_varchar2
459: ,p_batch_reference in varchar2 default hr_api.g_varchar2
460: ,p_batch_source in varchar2 default hr_api.g_varchar2
461: ,p_batch_type in varchar2 default hr_api.g_varchar2
462: ,p_comments in varchar2 default hr_api.g_varchar2

Line 459: ,p_batch_reference in varchar2 default hr_api.g_varchar2

455: ,p_object_version_number in out nocopy number
456: ,p_batch_name in varchar2 default hr_api.g_varchar2
457: ,p_batch_status in varchar2 default hr_api.g_varchar2
458: ,p_action_if_exists in varchar2 default hr_api.g_varchar2
459: ,p_batch_reference in varchar2 default hr_api.g_varchar2
460: ,p_batch_source in varchar2 default hr_api.g_varchar2
461: ,p_batch_type in varchar2 default hr_api.g_varchar2
462: ,p_comments in varchar2 default hr_api.g_varchar2
463: ,p_date_effective_changes in varchar2 default hr_api.g_varchar2

Line 460: ,p_batch_source in varchar2 default hr_api.g_varchar2

456: ,p_batch_name in varchar2 default hr_api.g_varchar2
457: ,p_batch_status in varchar2 default hr_api.g_varchar2
458: ,p_action_if_exists in varchar2 default hr_api.g_varchar2
459: ,p_batch_reference in varchar2 default hr_api.g_varchar2
460: ,p_batch_source in varchar2 default hr_api.g_varchar2
461: ,p_batch_type in varchar2 default hr_api.g_varchar2
462: ,p_comments in varchar2 default hr_api.g_varchar2
463: ,p_date_effective_changes in varchar2 default hr_api.g_varchar2
464: ,p_purge_after_transfer in varchar2 default hr_api.g_varchar2

Line 461: ,p_batch_type in varchar2 default hr_api.g_varchar2

457: ,p_batch_status in varchar2 default hr_api.g_varchar2
458: ,p_action_if_exists in varchar2 default hr_api.g_varchar2
459: ,p_batch_reference in varchar2 default hr_api.g_varchar2
460: ,p_batch_source in varchar2 default hr_api.g_varchar2
461: ,p_batch_type in varchar2 default hr_api.g_varchar2
462: ,p_comments in varchar2 default hr_api.g_varchar2
463: ,p_date_effective_changes in varchar2 default hr_api.g_varchar2
464: ,p_purge_after_transfer in varchar2 default hr_api.g_varchar2
465: ,p_reject_if_future_changes in varchar2 default hr_api.g_varchar2

Line 462: ,p_comments in varchar2 default hr_api.g_varchar2

458: ,p_action_if_exists in varchar2 default hr_api.g_varchar2
459: ,p_batch_reference in varchar2 default hr_api.g_varchar2
460: ,p_batch_source in varchar2 default hr_api.g_varchar2
461: ,p_batch_type in varchar2 default hr_api.g_varchar2
462: ,p_comments in varchar2 default hr_api.g_varchar2
463: ,p_date_effective_changes in varchar2 default hr_api.g_varchar2
464: ,p_purge_after_transfer in varchar2 default hr_api.g_varchar2
465: ,p_reject_if_future_changes in varchar2 default hr_api.g_varchar2
466: ,p_reject_if_results_exists in varchar2 default hr_api.g_varchar2

Line 463: ,p_date_effective_changes in varchar2 default hr_api.g_varchar2

459: ,p_batch_reference in varchar2 default hr_api.g_varchar2
460: ,p_batch_source in varchar2 default hr_api.g_varchar2
461: ,p_batch_type in varchar2 default hr_api.g_varchar2
462: ,p_comments in varchar2 default hr_api.g_varchar2
463: ,p_date_effective_changes in varchar2 default hr_api.g_varchar2
464: ,p_purge_after_transfer in varchar2 default hr_api.g_varchar2
465: ,p_reject_if_future_changes in varchar2 default hr_api.g_varchar2
466: ,p_reject_if_results_exists in varchar2 default hr_api.g_varchar2
467: ,p_purge_after_rollback in varchar2 default hr_api.g_varchar2

Line 464: ,p_purge_after_transfer in varchar2 default hr_api.g_varchar2

460: ,p_batch_source in varchar2 default hr_api.g_varchar2
461: ,p_batch_type in varchar2 default hr_api.g_varchar2
462: ,p_comments in varchar2 default hr_api.g_varchar2
463: ,p_date_effective_changes in varchar2 default hr_api.g_varchar2
464: ,p_purge_after_transfer in varchar2 default hr_api.g_varchar2
465: ,p_reject_if_future_changes in varchar2 default hr_api.g_varchar2
466: ,p_reject_if_results_exists in varchar2 default hr_api.g_varchar2
467: ,p_purge_after_rollback in varchar2 default hr_api.g_varchar2
468: ,p_REJECT_ENTRY_NOT_REMOVED in varchar2 default hr_api.g_varchar2

Line 465: ,p_reject_if_future_changes in varchar2 default hr_api.g_varchar2

461: ,p_batch_type in varchar2 default hr_api.g_varchar2
462: ,p_comments in varchar2 default hr_api.g_varchar2
463: ,p_date_effective_changes in varchar2 default hr_api.g_varchar2
464: ,p_purge_after_transfer in varchar2 default hr_api.g_varchar2
465: ,p_reject_if_future_changes in varchar2 default hr_api.g_varchar2
466: ,p_reject_if_results_exists in varchar2 default hr_api.g_varchar2
467: ,p_purge_after_rollback in varchar2 default hr_api.g_varchar2
468: ,p_REJECT_ENTRY_NOT_REMOVED in varchar2 default hr_api.g_varchar2
469: ,p_ROLLBACK_ENTRY_UPDATES in varchar2 default hr_api.g_varchar2

Line 466: ,p_reject_if_results_exists in varchar2 default hr_api.g_varchar2

462: ,p_comments in varchar2 default hr_api.g_varchar2
463: ,p_date_effective_changes in varchar2 default hr_api.g_varchar2
464: ,p_purge_after_transfer in varchar2 default hr_api.g_varchar2
465: ,p_reject_if_future_changes in varchar2 default hr_api.g_varchar2
466: ,p_reject_if_results_exists in varchar2 default hr_api.g_varchar2
467: ,p_purge_after_rollback in varchar2 default hr_api.g_varchar2
468: ,p_REJECT_ENTRY_NOT_REMOVED in varchar2 default hr_api.g_varchar2
469: ,p_ROLLBACK_ENTRY_UPDATES in varchar2 default hr_api.g_varchar2
470: ) is

Line 467: ,p_purge_after_rollback in varchar2 default hr_api.g_varchar2

463: ,p_date_effective_changes in varchar2 default hr_api.g_varchar2
464: ,p_purge_after_transfer in varchar2 default hr_api.g_varchar2
465: ,p_reject_if_future_changes in varchar2 default hr_api.g_varchar2
466: ,p_reject_if_results_exists in varchar2 default hr_api.g_varchar2
467: ,p_purge_after_rollback in varchar2 default hr_api.g_varchar2
468: ,p_REJECT_ENTRY_NOT_REMOVED in varchar2 default hr_api.g_varchar2
469: ,p_ROLLBACK_ENTRY_UPDATES in varchar2 default hr_api.g_varchar2
470: ) is
471: --

Line 468: ,p_REJECT_ENTRY_NOT_REMOVED in varchar2 default hr_api.g_varchar2

464: ,p_purge_after_transfer in varchar2 default hr_api.g_varchar2
465: ,p_reject_if_future_changes in varchar2 default hr_api.g_varchar2
466: ,p_reject_if_results_exists in varchar2 default hr_api.g_varchar2
467: ,p_purge_after_rollback in varchar2 default hr_api.g_varchar2
468: ,p_REJECT_ENTRY_NOT_REMOVED in varchar2 default hr_api.g_varchar2
469: ,p_ROLLBACK_ENTRY_UPDATES in varchar2 default hr_api.g_varchar2
470: ) is
471: --
472: l_rec pay_bth_shd.g_rec_type;

Line 469: ,p_ROLLBACK_ENTRY_UPDATES in varchar2 default hr_api.g_varchar2

465: ,p_reject_if_future_changes in varchar2 default hr_api.g_varchar2
466: ,p_reject_if_results_exists in varchar2 default hr_api.g_varchar2
467: ,p_purge_after_rollback in varchar2 default hr_api.g_varchar2
468: ,p_REJECT_ENTRY_NOT_REMOVED in varchar2 default hr_api.g_varchar2
469: ,p_ROLLBACK_ENTRY_UPDATES in varchar2 default hr_api.g_varchar2
470: ) is
471: --
472: l_rec pay_bth_shd.g_rec_type;
473: l_proc varchar2(72) := g_package||'upd';

Line 484: ,hr_api.g_number

480: --
481: l_rec :=
482: pay_bth_shd.convert_args
483: (p_batch_id
484: ,hr_api.g_number
485: ,p_batch_name
486: ,p_batch_status
487: ,p_action_if_exists
488: ,p_batch_reference