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_BUS dependencies on PAY_BATCH_HEADERS

Line 29: , pay_batch_headers bth

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pay_batch_headers bth
30: where bth.batch_id = p_batch_id
31: and pbg.business_group_id = bth.business_group_id;
32: --
33: -- Declare local variables

Line 89: , pay_batch_headers bth

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , pay_batch_headers bth
90: where bth.batch_id = p_batch_id
91: and pbg.business_group_id = bth.business_group_id;
92: --
93: -- Declare local variables

Line 253: from pay_batch_headers pbh

249: Procedure chk_transferred_status (p_batch_id number) Is
250: --
251: cursor csr_status is
252: select pbh.batch_status
253: from pay_batch_headers pbh
254: where pbh.batch_id = p_batch_id;
255: --
256: l_status pay_batch_headers.batch_status%TYPE;
257: --

Line 256: l_status pay_batch_headers.batch_status%TYPE;

252: select pbh.batch_status
253: from pay_batch_headers pbh
254: where pbh.batch_id = p_batch_id;
255: --
256: l_status pay_batch_headers.batch_status%TYPE;
257: --
258: Begin
259: --
260: open csr_status;

Line 303: (p_batch_name in pay_batch_headers.batch_name%TYPE

299: -- {End of Comments}
300: --
301: -- ---------------------------------------------------------------------------
302: procedure chk_batch_name
303: (p_batch_name in pay_batch_headers.batch_name%TYPE
304: ) is
305: --
306: l_proc varchar2(72) := g_package||'chk_batch_name';
307: --

Line 357: (p_batch_status in pay_batch_headers.batch_status%TYPE,

353: -- {End of Comments}
354: --
355: -- ---------------------------------------------------------------------------
356: procedure chk_batch_status
357: (p_batch_status in pay_batch_headers.batch_status%TYPE,
358: p_session_date in date,
359: p_batch_id in pay_batch_headers.batch_id%TYPE,
360: p_object_version_number in pay_batch_headers.object_version_number%TYPE
361: ) is

Line 359: p_batch_id in pay_batch_headers.batch_id%TYPE,

355: -- ---------------------------------------------------------------------------
356: procedure chk_batch_status
357: (p_batch_status in pay_batch_headers.batch_status%TYPE,
358: p_session_date in date,
359: p_batch_id in pay_batch_headers.batch_id%TYPE,
360: p_object_version_number in pay_batch_headers.object_version_number%TYPE
361: ) is
362: --
363: l_proc varchar2(72) := g_package||'chk_batch_status';

Line 360: p_object_version_number in pay_batch_headers.object_version_number%TYPE

356: procedure chk_batch_status
357: (p_batch_status in pay_batch_headers.batch_status%TYPE,
358: p_session_date in date,
359: p_batch_id in pay_batch_headers.batch_id%TYPE,
360: p_object_version_number in pay_batch_headers.object_version_number%TYPE
361: ) is
362: --
363: l_proc varchar2(72) := g_package||'chk_batch_status';
364: l_api_updating boolean;

Line 451: (p_action_if_exists in pay_batch_headers.action_if_exists%TYPE,

447: -- {End of Comments}
448: --
449: -- ---------------------------------------------------------------------------
450: procedure chk_action_if_exists
451: (p_action_if_exists in pay_batch_headers.action_if_exists%TYPE,
452: p_session_date in date,
453: p_batch_id in pay_batch_headers.batch_id%TYPE,
454: p_object_version_number in pay_batch_headers.object_version_number%TYPE
455: ) is

Line 453: p_batch_id in pay_batch_headers.batch_id%TYPE,

449: -- ---------------------------------------------------------------------------
450: procedure chk_action_if_exists
451: (p_action_if_exists in pay_batch_headers.action_if_exists%TYPE,
452: p_session_date in date,
453: p_batch_id in pay_batch_headers.batch_id%TYPE,
454: p_object_version_number in pay_batch_headers.object_version_number%TYPE
455: ) is
456: --
457: l_proc varchar2(72) := g_package||'chk_action_if_exists';

Line 454: p_object_version_number in pay_batch_headers.object_version_number%TYPE

450: procedure chk_action_if_exists
451: (p_action_if_exists in pay_batch_headers.action_if_exists%TYPE,
452: p_session_date in date,
453: p_batch_id in pay_batch_headers.batch_id%TYPE,
454: p_object_version_number in pay_batch_headers.object_version_number%TYPE
455: ) is
456: --
457: l_proc varchar2(72) := g_package||'chk_action_if_exists';
458: l_api_updating boolean;

Line 543: (p_purge_after_transfer in pay_batch_headers.purge_after_transfer%TYPE,

539: -- {End of Comments}
540: --
541: -- ---------------------------------------------------------------------------
542: procedure chk_purge_after_transfer
543: (p_purge_after_transfer in pay_batch_headers.purge_after_transfer%TYPE,
544: p_session_date in date,
545: p_batch_id in pay_batch_headers.batch_id%TYPE,
546: p_object_version_number in pay_batch_headers.object_version_number%TYPE
547: ) is

Line 545: p_batch_id in pay_batch_headers.batch_id%TYPE,

541: -- ---------------------------------------------------------------------------
542: procedure chk_purge_after_transfer
543: (p_purge_after_transfer in pay_batch_headers.purge_after_transfer%TYPE,
544: p_session_date in date,
545: p_batch_id in pay_batch_headers.batch_id%TYPE,
546: p_object_version_number in pay_batch_headers.object_version_number%TYPE
547: ) is
548: --
549: l_proc varchar2(72) := g_package||'chk_purge_after_transfer';

Line 546: p_object_version_number in pay_batch_headers.object_version_number%TYPE

542: procedure chk_purge_after_transfer
543: (p_purge_after_transfer in pay_batch_headers.purge_after_transfer%TYPE,
544: p_session_date in date,
545: p_batch_id in pay_batch_headers.batch_id%TYPE,
546: p_object_version_number in pay_batch_headers.object_version_number%TYPE
547: ) is
548: --
549: l_proc varchar2(72) := g_package||'chk_purge_after_transfer';
550: l_api_updating boolean;

Line 635: (p_reject_if_future_changes in pay_batch_headers.reject_if_future_changes%TYPE,

631: -- {End of Comments}
632: --
633: -- ---------------------------------------------------------------------------
634: procedure chk_reject_if_future_changes
635: (p_reject_if_future_changes in pay_batch_headers.reject_if_future_changes%TYPE,
636: p_session_date in date,
637: p_batch_id in pay_batch_headers.batch_id%TYPE,
638: p_object_version_number in pay_batch_headers.object_version_number%TYPE
639: ) is

Line 637: p_batch_id in pay_batch_headers.batch_id%TYPE,

633: -- ---------------------------------------------------------------------------
634: procedure chk_reject_if_future_changes
635: (p_reject_if_future_changes in pay_batch_headers.reject_if_future_changes%TYPE,
636: p_session_date in date,
637: p_batch_id in pay_batch_headers.batch_id%TYPE,
638: p_object_version_number in pay_batch_headers.object_version_number%TYPE
639: ) is
640: --
641: l_proc varchar2(72) := g_package||'chk_reject_if_future_changes';

Line 638: p_object_version_number in pay_batch_headers.object_version_number%TYPE

634: procedure chk_reject_if_future_changes
635: (p_reject_if_future_changes in pay_batch_headers.reject_if_future_changes%TYPE,
636: p_session_date in date,
637: p_batch_id in pay_batch_headers.batch_id%TYPE,
638: p_object_version_number in pay_batch_headers.object_version_number%TYPE
639: ) is
640: --
641: l_proc varchar2(72) := g_package||'chk_reject_if_future_changes';
642: l_api_updating boolean;

Line 727: (p_reject_if_results_exists in pay_batch_headers.reject_if_results_exists%TYPE,

723: -- {End of Comments}
724: --
725: -- ---------------------------------------------------------------------------
726: procedure chk_reject_if_results_exists
727: (p_reject_if_results_exists in pay_batch_headers.reject_if_results_exists%TYPE,
728: p_session_date in date,
729: p_batch_id in pay_batch_headers.batch_id%TYPE,
730: p_object_version_number in pay_batch_headers.object_version_number%TYPE
731: ) is

Line 729: p_batch_id in pay_batch_headers.batch_id%TYPE,

725: -- ---------------------------------------------------------------------------
726: procedure chk_reject_if_results_exists
727: (p_reject_if_results_exists in pay_batch_headers.reject_if_results_exists%TYPE,
728: p_session_date in date,
729: p_batch_id in pay_batch_headers.batch_id%TYPE,
730: p_object_version_number in pay_batch_headers.object_version_number%TYPE
731: ) is
732: --
733: l_proc varchar2(72) := g_package||'chk_reject_if_results_exists';

Line 730: p_object_version_number in pay_batch_headers.object_version_number%TYPE

726: procedure chk_reject_if_results_exists
727: (p_reject_if_results_exists in pay_batch_headers.reject_if_results_exists%TYPE,
728: p_session_date in date,
729: p_batch_id in pay_batch_headers.batch_id%TYPE,
730: p_object_version_number in pay_batch_headers.object_version_number%TYPE
731: ) is
732: --
733: l_proc varchar2(72) := g_package||'chk_reject_if_results_exists';
734: l_api_updating boolean;

Line 819: (p_purge_after_rollback in pay_batch_headers.purge_after_rollback%TYPE,

815: -- {End of Comments}
816: --
817: -- ---------------------------------------------------------------------------
818: procedure chk_purge_after_rollback
819: (p_purge_after_rollback in pay_batch_headers.purge_after_rollback%TYPE,
820: p_session_date in date,
821: p_batch_id in pay_batch_headers.batch_id%TYPE,
822: p_object_version_number in pay_batch_headers.object_version_number%TYPE
823: ) is

Line 821: p_batch_id in pay_batch_headers.batch_id%TYPE,

817: -- ---------------------------------------------------------------------------
818: procedure chk_purge_after_rollback
819: (p_purge_after_rollback in pay_batch_headers.purge_after_rollback%TYPE,
820: p_session_date in date,
821: p_batch_id in pay_batch_headers.batch_id%TYPE,
822: p_object_version_number in pay_batch_headers.object_version_number%TYPE
823: ) is
824: --
825: l_proc varchar2(72) := g_package||'chk_purge_after_rollback';

Line 822: p_object_version_number in pay_batch_headers.object_version_number%TYPE

818: procedure chk_purge_after_rollback
819: (p_purge_after_rollback in pay_batch_headers.purge_after_rollback%TYPE,
820: p_session_date in date,
821: p_batch_id in pay_batch_headers.batch_id%TYPE,
822: p_object_version_number in pay_batch_headers.object_version_number%TYPE
823: ) is
824: --
825: l_proc varchar2(72) := g_package||'chk_purge_after_rollback';
826: l_api_updating boolean;

Line 910: (p_date_effective_changes in pay_batch_headers.date_effective_changes%TYPE,

906: -- {End of Comments}
907: --
908: -- ---------------------------------------------------------------------------
909: procedure chk_date_effective_changes
910: (p_date_effective_changes in pay_batch_headers.date_effective_changes%TYPE,
911: p_session_date in date,
912: p_batch_id in pay_batch_headers.batch_id%TYPE,
913: p_object_version_number in pay_batch_headers.object_version_number%TYPE,
914: p_reject_if_future_changes in pay_batch_headers.reject_if_future_changes%TYPE,

Line 912: p_batch_id in pay_batch_headers.batch_id%TYPE,

908: -- ---------------------------------------------------------------------------
909: procedure chk_date_effective_changes
910: (p_date_effective_changes in pay_batch_headers.date_effective_changes%TYPE,
911: p_session_date in date,
912: p_batch_id in pay_batch_headers.batch_id%TYPE,
913: p_object_version_number in pay_batch_headers.object_version_number%TYPE,
914: p_reject_if_future_changes in pay_batch_headers.reject_if_future_changes%TYPE,
915: p_action_if_exists in pay_batch_headers.action_if_exists%TYPE
916: ) is

Line 913: p_object_version_number in pay_batch_headers.object_version_number%TYPE,

909: procedure chk_date_effective_changes
910: (p_date_effective_changes in pay_batch_headers.date_effective_changes%TYPE,
911: p_session_date in date,
912: p_batch_id in pay_batch_headers.batch_id%TYPE,
913: p_object_version_number in pay_batch_headers.object_version_number%TYPE,
914: p_reject_if_future_changes in pay_batch_headers.reject_if_future_changes%TYPE,
915: p_action_if_exists in pay_batch_headers.action_if_exists%TYPE
916: ) is
917: --

Line 914: p_reject_if_future_changes in pay_batch_headers.reject_if_future_changes%TYPE,

910: (p_date_effective_changes in pay_batch_headers.date_effective_changes%TYPE,
911: p_session_date in date,
912: p_batch_id in pay_batch_headers.batch_id%TYPE,
913: p_object_version_number in pay_batch_headers.object_version_number%TYPE,
914: p_reject_if_future_changes in pay_batch_headers.reject_if_future_changes%TYPE,
915: p_action_if_exists in pay_batch_headers.action_if_exists%TYPE
916: ) is
917: --
918: l_proc varchar2(72) := g_package||'chk_date_effective_changes';

Line 915: p_action_if_exists in pay_batch_headers.action_if_exists%TYPE

911: p_session_date in date,
912: p_batch_id in pay_batch_headers.batch_id%TYPE,
913: p_object_version_number in pay_batch_headers.object_version_number%TYPE,
914: p_reject_if_future_changes in pay_batch_headers.reject_if_future_changes%TYPE,
915: p_action_if_exists in pay_batch_headers.action_if_exists%TYPE
916: ) is
917: --
918: l_proc varchar2(72) := g_package||'chk_date_effective_changes';
919: l_api_updating boolean;

Line 1011: (p_batch_id in pay_batch_headers.batch_id%TYPE

1007: -- {End of Comments}
1008: --
1009: -- ---------------------------------------------------------------------------
1010: procedure chk_delete
1011: (p_batch_id in pay_batch_headers.batch_id%TYPE
1012: ) is
1013: --
1014: l_proc varchar2(72) := g_package||'chk_delete';
1015: l_exists varchar2(1);