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_BTL_BUS dependencies on PAY_BATCH_LINES

Line 366: -- pay_batch_lines and PER_BUSINESS_GROUPS

362: --
363: -- Declare cursor
364: --
365: -- In the following cursor statement add join(s) between
366: -- pay_batch_lines and PER_BUSINESS_GROUPS
367: -- so that the security_group_id for
368: -- the current business group context can be derived.
369: -- Remove this comment when the edit has been completed.
370: cursor csr_sec_grp is

Line 373: , pay_batch_lines btl

369: -- Remove this comment when the edit has been completed.
370: cursor csr_sec_grp is
371: select pbg.security_group_id
372: from per_business_groups pbg
373: , pay_batch_lines btl
374: , pay_batch_headers bth
375: where btl.batch_line_id = p_batch_line_id
376: and bth.batch_id = btl.batch_id
377: and pbg.business_group_id = bth.business_group_id;

Line 433: -- pay_batch_lines and PER_BUSINESS_GROUPS

429: --
430: -- Declare cursor
431: --
432: -- In the following cursor statement add join(s) between
433: -- pay_batch_lines and PER_BUSINESS_GROUPS
434: -- so that the legislation_code for
435: -- the current business group context can be derived.
436: -- Remove this comment when the edit has been completed.
437: cursor csr_leg_code is

Line 440: , pay_batch_lines btl

436: -- Remove this comment when the edit has been completed.
437: cursor csr_leg_code is
438: select pbg.legislation_code
439: from per_business_groups pbg
440: , pay_batch_lines btl
441: , pay_batch_headers bth
442: where btl.batch_line_id = p_batch_line_id
443: and bth.batch_id = btl.batch_id
444: and pbg.business_group_id = bth.business_group_id;

Line 603: from pay_batch_lines pbl

599: Procedure chk_transferred_status (p_batch_line_id number) Is
600: --
601: cursor csr_status is
602: select 'Y'
603: from pay_batch_lines pbl
604: where pbl.batch_line_id = p_batch_line_id
605: and pbl.batch_line_status = 'T';
606: --
607: l_transferred varchar2(1);

Line 654: (p_batch_line_id in pay_batch_lines.batch_line_id%TYPE,

650: -- {End of Comments}
651: --
652: -- ---------------------------------------------------------------------------
653: procedure chk_batch_id
654: (p_batch_line_id in pay_batch_lines.batch_line_id%TYPE,
655: p_batch_id in pay_batch_lines.batch_id%TYPE
656: ) is
657: --
658: l_proc varchar2(72) := g_package||'chk_batch_id';

Line 655: p_batch_id in pay_batch_lines.batch_id%TYPE

651: --
652: -- ---------------------------------------------------------------------------
653: procedure chk_batch_id
654: (p_batch_line_id in pay_batch_lines.batch_line_id%TYPE,
655: p_batch_id in pay_batch_lines.batch_id%TYPE
656: ) is
657: --
658: l_proc varchar2(72) := g_package||'chk_batch_id';
659: l_dummy number;

Line 694: pay_btl_shd.constraint_error('PAY_BATCH_LINES_FK3');

690: open csr_batch_id_exists;
691: fetch csr_batch_id_exists into l_dummy;
692: if csr_batch_id_exists%notfound then
693: close csr_batch_id_exists;
694: pay_btl_shd.constraint_error('PAY_BATCH_LINES_FK3');
695: end if;
696: close csr_batch_id_exists;
697: end if;
698: --

Line 737: (p_batch_line_status in pay_batch_lines.batch_line_status%TYPE,

733: -- {End of Comments}
734: --
735: -- ---------------------------------------------------------------------------
736: procedure chk_batch_line_status
737: (p_batch_line_status in pay_batch_lines.batch_line_status%TYPE,
738: p_session_date in date,
739: p_batch_id in pay_batch_lines.batch_id%TYPE,
740: p_batch_line_id in pay_batch_lines.batch_line_id%TYPE,
741: p_assignment_id in pay_batch_lines.assignment_id%TYPE,

Line 739: p_batch_id in pay_batch_lines.batch_id%TYPE,

735: -- ---------------------------------------------------------------------------
736: procedure chk_batch_line_status
737: (p_batch_line_status in pay_batch_lines.batch_line_status%TYPE,
738: p_session_date in date,
739: p_batch_id in pay_batch_lines.batch_id%TYPE,
740: p_batch_line_id in pay_batch_lines.batch_line_id%TYPE,
741: p_assignment_id in pay_batch_lines.assignment_id%TYPE,
742: p_assignment_number in pay_batch_lines.assignment_number%TYPE,
743: p_object_version_number in pay_batch_lines.object_version_number%TYPE

Line 740: p_batch_line_id in pay_batch_lines.batch_line_id%TYPE,

736: procedure chk_batch_line_status
737: (p_batch_line_status in pay_batch_lines.batch_line_status%TYPE,
738: p_session_date in date,
739: p_batch_id in pay_batch_lines.batch_id%TYPE,
740: p_batch_line_id in pay_batch_lines.batch_line_id%TYPE,
741: p_assignment_id in pay_batch_lines.assignment_id%TYPE,
742: p_assignment_number in pay_batch_lines.assignment_number%TYPE,
743: p_object_version_number in pay_batch_lines.object_version_number%TYPE
744: ) is

Line 741: p_assignment_id in pay_batch_lines.assignment_id%TYPE,

737: (p_batch_line_status in pay_batch_lines.batch_line_status%TYPE,
738: p_session_date in date,
739: p_batch_id in pay_batch_lines.batch_id%TYPE,
740: p_batch_line_id in pay_batch_lines.batch_line_id%TYPE,
741: p_assignment_id in pay_batch_lines.assignment_id%TYPE,
742: p_assignment_number in pay_batch_lines.assignment_number%TYPE,
743: p_object_version_number in pay_batch_lines.object_version_number%TYPE
744: ) is
745: --

Line 742: p_assignment_number in pay_batch_lines.assignment_number%TYPE,

738: p_session_date in date,
739: p_batch_id in pay_batch_lines.batch_id%TYPE,
740: p_batch_line_id in pay_batch_lines.batch_line_id%TYPE,
741: p_assignment_id in pay_batch_lines.assignment_id%TYPE,
742: p_assignment_number in pay_batch_lines.assignment_number%TYPE,
743: p_object_version_number in pay_batch_lines.object_version_number%TYPE
744: ) is
745: --
746: l_proc varchar2(72) := g_package||'chk_batch_line_status';

Line 743: p_object_version_number in pay_batch_lines.object_version_number%TYPE

739: p_batch_id in pay_batch_lines.batch_id%TYPE,
740: p_batch_line_id in pay_batch_lines.batch_line_id%TYPE,
741: p_assignment_id in pay_batch_lines.assignment_id%TYPE,
742: p_assignment_number in pay_batch_lines.assignment_number%TYPE,
743: p_object_version_number in pay_batch_lines.object_version_number%TYPE
744: ) is
745: --
746: l_proc varchar2(72) := g_package||'chk_batch_line_status';
747: l_api_updating boolean;

Line 756: from pay_batch_lines btl

752: where bth.batch_id = p_batch_id;
753: --
754: cursor csr_batch_line_asg is
755: select null
756: from pay_batch_lines btl
757: where btl.batch_line_id = p_batch_line_id
758: and ((btl.assignment_id is null and p_assignment_id is null)
759: or btl.assignment_id = p_assignment_id)
760: and ((btl.assignment_number is null and p_assignment_number is null)

Line 907: (p_entry_type in pay_batch_lines.entry_type%TYPE,

903: -- {End of Comments}
904: --
905: -- ---------------------------------------------------------------------------
906: procedure chk_entry_type
907: (p_entry_type in pay_batch_lines.entry_type%TYPE,
908: p_session_date in date,
909: p_batch_line_id in pay_batch_lines.batch_line_id%TYPE,
910: p_object_version_number in pay_batch_lines.object_version_number%TYPE
911: ) is

Line 909: p_batch_line_id in pay_batch_lines.batch_line_id%TYPE,

905: -- ---------------------------------------------------------------------------
906: procedure chk_entry_type
907: (p_entry_type in pay_batch_lines.entry_type%TYPE,
908: p_session_date in date,
909: p_batch_line_id in pay_batch_lines.batch_line_id%TYPE,
910: p_object_version_number in pay_batch_lines.object_version_number%TYPE
911: ) is
912: --
913: l_proc varchar2(72) := g_package||'chk_entry_type';

Line 910: p_object_version_number in pay_batch_lines.object_version_number%TYPE

906: procedure chk_entry_type
907: (p_entry_type in pay_batch_lines.entry_type%TYPE,
908: p_session_date in date,
909: p_batch_line_id in pay_batch_lines.batch_line_id%TYPE,
910: p_object_version_number in pay_batch_lines.object_version_number%TYPE
911: ) is
912: --
913: l_proc varchar2(72) := g_package||'chk_entry_type';
914: l_api_updating boolean;

Line 997: (p_batch_line_id in pay_batch_lines.batch_line_id%TYPE

993: -- {End of Comments}
994: --
995: -- ---------------------------------------------------------------------------
996: procedure chk_delete
997: (p_batch_line_id in pay_batch_lines.batch_line_id%TYPE
998: ) is
999: --
1000: l_proc varchar2(72) := g_package||'chk_delete';
1001: l_exists varchar2(1);