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.HXT_INTERFACE_UTILITIES dependencies on PAY_BATCH_HEADERS

Line 491: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,

487: RETURN l_conc_request_id_suffix;
488: END conc_request_id_suffix;
489:
490: FUNCTION batch_name (
491: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
492: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
493: p_invalid_batch_status IN pay_batch_headers.batch_status%TYPE
494: DEFAULT NULL
495: )

Line 492: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

488: END conc_request_id_suffix;
489:
490: FUNCTION batch_name (
491: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
492: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
493: p_invalid_batch_status IN pay_batch_headers.batch_status%TYPE
494: DEFAULT NULL
495: )
496: RETURN pay_batch_headers.batch_name%TYPE

Line 493: p_invalid_batch_status IN pay_batch_headers.batch_status%TYPE

489:
490: FUNCTION batch_name (
491: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
492: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
493: p_invalid_batch_status IN pay_batch_headers.batch_status%TYPE
494: DEFAULT NULL
495: )
496: RETURN pay_batch_headers.batch_name%TYPE
497: AS

Line 496: RETURN pay_batch_headers.batch_name%TYPE

492: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
493: p_invalid_batch_status IN pay_batch_headers.batch_status%TYPE
494: DEFAULT NULL
495: )
496: RETURN pay_batch_headers.batch_name%TYPE
497: AS
498: l_proc proc_name ;
499:
500: CURSOR csr_max_batch_id (

Line 501: p_batch_ref pay_batch_headers.batch_reference%TYPE,

497: AS
498: l_proc proc_name ;
499:
500: CURSOR csr_max_batch_id (
501: p_batch_ref pay_batch_headers.batch_reference%TYPE,
502: p_bg_id pay_batch_headers.business_group_id%TYPE,
503: p_invalid_batch_status pay_batch_headers.batch_status%TYPE
504: )
505: IS

Line 502: p_bg_id pay_batch_headers.business_group_id%TYPE,

498: l_proc proc_name ;
499:
500: CURSOR csr_max_batch_id (
501: p_batch_ref pay_batch_headers.batch_reference%TYPE,
502: p_bg_id pay_batch_headers.business_group_id%TYPE,
503: p_invalid_batch_status pay_batch_headers.batch_status%TYPE
504: )
505: IS
506: SELECT MAX (pbh.batch_id) batch_id

Line 503: p_invalid_batch_status pay_batch_headers.batch_status%TYPE

499:
500: CURSOR csr_max_batch_id (
501: p_batch_ref pay_batch_headers.batch_reference%TYPE,
502: p_bg_id pay_batch_headers.business_group_id%TYPE,
503: p_invalid_batch_status pay_batch_headers.batch_status%TYPE
504: )
505: IS
506: SELECT MAX (pbh.batch_id) batch_id
507: FROM pay_batch_headers pbh

Line 507: FROM pay_batch_headers pbh

503: p_invalid_batch_status pay_batch_headers.batch_status%TYPE
504: )
505: IS
506: SELECT MAX (pbh.batch_id) batch_id
507: FROM pay_batch_headers pbh
508: WHERE pbh.batch_reference = p_batch_ref
509: AND pbh.business_group_id = p_bg_id
510: AND ( (pbh.batch_status <> p_invalid_batch_status)
511: OR (p_invalid_batch_status IS NULL)

Line 514: CURSOR csr_batch_name (p_batch_id pay_batch_headers.batch_id%TYPE)

510: AND ( (pbh.batch_status <> p_invalid_batch_status)
511: OR (p_invalid_batch_status IS NULL)
512: );
513:
514: CURSOR csr_batch_name (p_batch_id pay_batch_headers.batch_id%TYPE)
515: IS
516: SELECT batch_name
517: FROM pay_batch_headers pbh
518: WHERE pbh.batch_id = p_batch_id;

Line 517: FROM pay_batch_headers pbh

513:
514: CURSOR csr_batch_name (p_batch_id pay_batch_headers.batch_id%TYPE)
515: IS
516: SELECT batch_name
517: FROM pay_batch_headers pbh
518: WHERE pbh.batch_id = p_batch_id;
519:
520: l_batch_id pay_batch_headers.batch_id%TYPE;
521: l_batch_name pay_batch_headers.batch_name%TYPE;

Line 520: l_batch_id pay_batch_headers.batch_id%TYPE;

516: SELECT batch_name
517: FROM pay_batch_headers pbh
518: WHERE pbh.batch_id = p_batch_id;
519:
520: l_batch_id pay_batch_headers.batch_id%TYPE;
521: l_batch_name pay_batch_headers.batch_name%TYPE;
522: BEGIN
523: g_debug :=hr_utility.debug_enabled;
524: if g_debug then

Line 521: l_batch_name pay_batch_headers.batch_name%TYPE;

517: FROM pay_batch_headers pbh
518: WHERE pbh.batch_id = p_batch_id;
519:
520: l_batch_id pay_batch_headers.batch_id%TYPE;
521: l_batch_name pay_batch_headers.batch_name%TYPE;
522: BEGIN
523: g_debug :=hr_utility.debug_enabled;
524: if g_debug then
525: l_proc := g_package

Line 557: p_batch_name IN pay_batch_headers.batch_name%TYPE,

553: RETURN l_batch_name;
554: END batch_name;
555:
556: FUNCTION max_batch_id (
557: p_batch_name IN pay_batch_headers.batch_name%TYPE,
558: p_bg_id IN pay_batch_headers.business_group_id%TYPE
559: )
560: RETURN pay_batch_headers.batch_id%TYPE
561: AS

Line 558: p_bg_id IN pay_batch_headers.business_group_id%TYPE

554: END batch_name;
555:
556: FUNCTION max_batch_id (
557: p_batch_name IN pay_batch_headers.batch_name%TYPE,
558: p_bg_id IN pay_batch_headers.business_group_id%TYPE
559: )
560: RETURN pay_batch_headers.batch_id%TYPE
561: AS
562: l_proc proc_name ;

Line 560: RETURN pay_batch_headers.batch_id%TYPE

556: FUNCTION max_batch_id (
557: p_batch_name IN pay_batch_headers.batch_name%TYPE,
558: p_bg_id IN pay_batch_headers.business_group_id%TYPE
559: )
560: RETURN pay_batch_headers.batch_id%TYPE
561: AS
562: l_proc proc_name ;
563:
564: CURSOR csr_max_batch_id (

Line 565: p_batch_name IN pay_batch_headers.batch_name%TYPE,

561: AS
562: l_proc proc_name ;
563:
564: CURSOR csr_max_batch_id (
565: p_batch_name IN pay_batch_headers.batch_name%TYPE,
566: p_bg_id IN pay_batch_headers.business_group_id%TYPE
567: )
568: IS
569: SELECT MAX (pbh.batch_id) -- we need to do max because name is not unique

Line 566: p_bg_id IN pay_batch_headers.business_group_id%TYPE

562: l_proc proc_name ;
563:
564: CURSOR csr_max_batch_id (
565: p_batch_name IN pay_batch_headers.batch_name%TYPE,
566: p_bg_id IN pay_batch_headers.business_group_id%TYPE
567: )
568: IS
569: SELECT MAX (pbh.batch_id) -- we need to do max because name is not unique
570: FROM pay_batch_headers pbh

Line 570: FROM pay_batch_headers pbh

566: p_bg_id IN pay_batch_headers.business_group_id%TYPE
567: )
568: IS
569: SELECT MAX (pbh.batch_id) -- we need to do max because name is not unique
570: FROM pay_batch_headers pbh
571: WHERE pbh.batch_name = p_batch_name
572: AND pbh.business_group_id = p_bg_id;
573:
574: l_batch_id pay_batch_headers.batch_id%TYPE;

Line 574: l_batch_id pay_batch_headers.batch_id%TYPE;

570: FROM pay_batch_headers pbh
571: WHERE pbh.batch_name = p_batch_name
572: AND pbh.business_group_id = p_bg_id;
573:
574: l_batch_id pay_batch_headers.batch_id%TYPE;
575: BEGIN
576: g_debug :=hr_utility.debug_enabled;
577: if g_debug then
578: l_proc := g_package

Line 601: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

597: RETURN l_batch_id;
598: END max_batch_id;
599:
600: FUNCTION max_batch_id (
601: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
602: p_bg_id IN pay_batch_headers.business_group_id%TYPE
603: )
604: RETURN pay_batch_headers.batch_id%TYPE
605: AS

Line 602: p_bg_id IN pay_batch_headers.business_group_id%TYPE

598: END max_batch_id;
599:
600: FUNCTION max_batch_id (
601: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
602: p_bg_id IN pay_batch_headers.business_group_id%TYPE
603: )
604: RETURN pay_batch_headers.batch_id%TYPE
605: AS
606: l_proc proc_name ;

Line 604: RETURN pay_batch_headers.batch_id%TYPE

600: FUNCTION max_batch_id (
601: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
602: p_bg_id IN pay_batch_headers.business_group_id%TYPE
603: )
604: RETURN pay_batch_headers.batch_id%TYPE
605: AS
606: l_proc proc_name ;
607:
608: CURSOR csr_max_batch_id (

Line 609: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

605: AS
606: l_proc proc_name ;
607:
608: CURSOR csr_max_batch_id (
609: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
610: p_bg_id IN pay_batch_headers.business_group_id%TYPE
611: )
612: IS
613: SELECT MAX (pbh.batch_id) -- we need to do max because name is not unique

Line 610: p_bg_id IN pay_batch_headers.business_group_id%TYPE

606: l_proc proc_name ;
607:
608: CURSOR csr_max_batch_id (
609: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
610: p_bg_id IN pay_batch_headers.business_group_id%TYPE
611: )
612: IS
613: SELECT MAX (pbh.batch_id) -- we need to do max because name is not unique
614: FROM pay_batch_headers pbh

Line 614: FROM pay_batch_headers pbh

610: p_bg_id IN pay_batch_headers.business_group_id%TYPE
611: )
612: IS
613: SELECT MAX (pbh.batch_id) -- we need to do max because name is not unique
614: FROM pay_batch_headers pbh
615: WHERE pbh.batch_name = p_batch_reference
616: AND pbh.business_group_id = p_bg_id;
617:
618: l_batch_id pay_batch_headers.batch_id%TYPE;

Line 618: l_batch_id pay_batch_headers.batch_id%TYPE;

614: FROM pay_batch_headers pbh
615: WHERE pbh.batch_name = p_batch_reference
616: AND pbh.business_group_id = p_bg_id;
617:
618: l_batch_id pay_batch_headers.batch_id%TYPE;
619: BEGIN
620: g_debug :=hr_utility.debug_enabled;
621: if g_debug then
622: l_proc := g_package

Line 644: FUNCTION count_batch_lines (p_batch_id IN pay_batch_headers.batch_id%TYPE)

640: end if;
641: RETURN l_batch_id;
642: END max_batch_id;
643:
644: FUNCTION count_batch_lines (p_batch_id IN pay_batch_headers.batch_id%TYPE)
645: RETURN NUMBER
646: AS
647: l_proc proc_name ;
648:

Line 649: CURSOR csr_batch_lines (p_batch_id IN pay_batch_headers.batch_name%TYPE)

645: RETURN NUMBER
646: AS
647: l_proc proc_name ;
648:
649: CURSOR csr_batch_lines (p_batch_id IN pay_batch_headers.batch_name%TYPE)
650: IS
651: SELECT COUNT (pbl.batch_line_id)
652: FROM pay_batch_lines pbl
653: WHERE pbl.batch_id = p_batch_id;

Line 679: p_batch_name IN pay_batch_headers.batch_name%TYPE,

675: RETURN l_batch_lines;
676: END count_batch_lines;
677:
678: FUNCTION count_batch_lines (
679: p_batch_name IN pay_batch_headers.batch_name%TYPE,
680: p_bg_id IN pay_batch_headers.business_group_id%TYPE
681: )
682: RETURN NUMBER
683: AS

Line 680: p_bg_id IN pay_batch_headers.business_group_id%TYPE

676: END count_batch_lines;
677:
678: FUNCTION count_batch_lines (
679: p_batch_name IN pay_batch_headers.batch_name%TYPE,
680: p_bg_id IN pay_batch_headers.business_group_id%TYPE
681: )
682: RETURN NUMBER
683: AS
684: l_proc proc_name ;

Line 685: l_batch_id pay_batch_headers.batch_name%TYPE;

681: )
682: RETURN NUMBER
683: AS
684: l_proc proc_name ;
685: l_batch_id pay_batch_headers.batch_name%TYPE;
686: l_batch_lines NUMBER;
687: BEGIN
688: g_debug :=hr_utility.debug_enabled;
689: if g_debug then

Line 711: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

707: RETURN l_batch_lines;
708: END count_batch_lines;
709:
710: FUNCTION total_batch_lines (
711: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
712: p_bg_id IN pay_batch_headers.business_group_id%TYPE
713: )
714: RETURN NUMBER
715: AS

Line 712: p_bg_id IN pay_batch_headers.business_group_id%TYPE

708: END count_batch_lines;
709:
710: FUNCTION total_batch_lines (
711: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
712: p_bg_id IN pay_batch_headers.business_group_id%TYPE
713: )
714: RETURN NUMBER
715: AS
716: l_proc proc_name ;

Line 719: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

715: AS
716: l_proc proc_name ;
717:
718: CURSOR csr_batch_lines (
719: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
720: p_bg_id IN pay_batch_headers.business_group_id%TYPE
721: )
722: IS
723: SELECT COUNT (pbl.batch_line_id)

Line 720: p_bg_id IN pay_batch_headers.business_group_id%TYPE

716: l_proc proc_name ;
717:
718: CURSOR csr_batch_lines (
719: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
720: p_bg_id IN pay_batch_headers.business_group_id%TYPE
721: )
722: IS
723: SELECT COUNT (pbl.batch_line_id)
724: FROM pay_batch_lines pbl, pay_batch_headers pbh

Line 724: FROM pay_batch_lines pbl, pay_batch_headers pbh

720: p_bg_id IN pay_batch_headers.business_group_id%TYPE
721: )
722: IS
723: SELECT COUNT (pbl.batch_line_id)
724: FROM pay_batch_lines pbl, pay_batch_headers pbh
725: WHERE pbl.batch_id = pbh.batch_id
726: AND pbh.business_group_id = p_bg_id
727: AND batch_reference = p_batch_reference;
728:

Line 753: p_batch_id IN pay_batch_headers.batch_reference%TYPE

749: RETURN l_batch_lines;
750: END total_batch_lines;
751:
752: FUNCTION max_lines_exceeded (
753: p_batch_id IN pay_batch_headers.batch_reference%TYPE
754: )
755: RETURN BOOLEAN
756: IS
757: l_proc proc_name ;

Line 785: p_batch_id IN pay_batch_headers.batch_reference%TYPE,

781: RETURN l_max_lines_exceeded;
782: END max_lines_exceeded;
783:
784: PROCEDURE max_lines_exceeded (
785: p_batch_id IN pay_batch_headers.batch_reference%TYPE,
786: p_number_lines IN OUT NOCOPY PLS_INTEGER,
787: p_max_lines_exceeded OUT NOCOPY BOOLEAN
788: )
789: IS

Line 822: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,

818: end if;
819: END max_lines_exceeded;
820:
821: FUNCTION max_lines_exceeded (
822: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
823: p_bg_id IN pay_batch_headers.business_group_id%TYPE
824: )
825: RETURN BOOLEAN
826: IS

Line 823: p_bg_id IN pay_batch_headers.business_group_id%TYPE

819: END max_lines_exceeded;
820:
821: FUNCTION max_lines_exceeded (
822: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
823: p_bg_id IN pay_batch_headers.business_group_id%TYPE
824: )
825: RETURN BOOLEAN
826: IS
827: l_proc proc_name ;

Line 828: l_batch_name pay_batch_headers.batch_name%TYPE;

824: )
825: RETURN BOOLEAN
826: IS
827: l_proc proc_name ;
828: l_batch_name pay_batch_headers.batch_name%TYPE;
829: l_max_lines_exceeded BOOLEAN;
830: BEGIN
831: g_debug :=hr_utility.debug_enabled;
832: if g_debug then

Line 2853: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

2849: RETURN l_element_type_id;
2850: END find_element_id_in_attr_tbl;
2851:
2852: PROCEDURE find_other_in_attr_tbl (
2853: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
2854: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
2855: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2856: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
2857: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,

Line 2869: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

2865: l_att_idx PLS_INTEGER
2866: := NVL (p_start_position, p_att_table.FIRST);
2867:
2868: FUNCTION asg_id (
2869: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
2870: p_effective_date IN DATE,
2871: p_bee_rec IN bee_rec
2872: )
2873: RETURN per_all_assignments_f.assignment_id%TYPE

Line 2877: p_bg_id pay_batch_headers.business_group_id%TYPE,

2873: RETURN per_all_assignments_f.assignment_id%TYPE
2874: AS
2875: l_proc proc_name ;
2876: CURSOR csr_asg_id (
2877: p_bg_id pay_batch_headers.business_group_id%TYPE,
2878: p_effective_date DATE,
2879: p_assignment_number per_all_assignments_f.assignment_number%TYPE
2880: )
2881: IS

Line 3800: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

3796: RETURN l_purged;
3797: END purge_pipe;
3798: */
3799: FUNCTION free_batch_suffix (
3800: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
3801: p_bg_id IN pay_batch_headers.business_group_id%TYPE
3802: )
3803: RETURN NUMBER
3804: IS

Line 3801: p_bg_id IN pay_batch_headers.business_group_id%TYPE

3797: END purge_pipe;
3798: */
3799: FUNCTION free_batch_suffix (
3800: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
3801: p_bg_id IN pay_batch_headers.business_group_id%TYPE
3802: )
3803: RETURN NUMBER
3804: IS
3805: l_proc proc_name ;