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_PAYROLL_XML_EXTRACT_PKG dependencies on PAY_PAYROLL_XML_EXTRACT_PKG

Line 1: PACKAGE BODY PAY_PAYROLL_XML_EXTRACT_PKG as

1: PACKAGE BODY PAY_PAYROLL_XML_EXTRACT_PKG as
2: /* $Header: pyxmlxtr.pkb 120.13.12010000.2 2008/08/22 10:34:18 ckesanap ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_payroll_xml_extract_pkg

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_payroll_xml_extract_pkg
21:
22: Description : This package handles generation of XML from data archived
23: in pay_action_information. Calling applications can invoke
24: one of the overloaded versions of GENERATE procedure with

Line 319: OPEN csr_get_tag_name (pay_payroll_xml_extract_pkg.g_leg_code||

315: l_proc_name := g_proc_name || 'LOAD_XML-2';
316: hr_utility_trace ('Entering '||l_proc_name);
317:
318: IF p_node_type = 'D' THEN
319: OPEN csr_get_tag_name (pay_payroll_xml_extract_pkg.g_leg_code||
320: '_BANK_DETAILS');
321: FETCH csr_get_tag_name INTO l_tag_name;
322: CLOSE csr_get_tag_name;
323: END IF;

Line 576: 'pay_payroll_xml_extract_pkg.load_xml(''CS'', NULL, ''?xml version="1.0" encoding="'||

572: build_sql(sqlstr, l_cntr_sql, 'declare l_org_id varchar2(100);begin ');
573: IF p_generate_header_flag THEN
574: build_sql(sqlstr,
575: l_cntr_sql,
576: 'pay_payroll_xml_extract_pkg.load_xml(''CS'', NULL, ''?xml version="1.0" encoding="'||
577: hr_mx_utility.get_IANA_charset||'"?'', NULL);');
578: END IF;
579: IF p_root_tag IS NOT NULL THEN
580: build_sql(sqlstr,

Line 582: 'pay_payroll_xml_extract_pkg.load_xml(''CS'', NULL, '''||

578: END IF;
579: IF p_root_tag IS NOT NULL THEN
580: build_sql(sqlstr,
581: l_cntr_sql,
582: 'pay_payroll_xml_extract_pkg.load_xml(''CS'', NULL, '''||
583: p_root_tag||''', NULL);');
584: END IF;
585:
586: /* Fetch legislation_code. */

Line 588: FETCH get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;

584: END IF;
585:
586: /* Fetch legislation_code. */
587: OPEN get_leg_code;
588: FETCH get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;
589: CLOSE get_leg_code;
590:
591: FOR csr_get_archived_regions_rec IN csr_get_archived_regions LOOP
592: IF csr_get_archived_regions_rec.action_information_category IN

Line 593: ('ADDRESS DETAILS', pay_payroll_xml_extract_pkg.g_leg_code ||

589: CLOSE get_leg_code;
590:
591: FOR csr_get_archived_regions_rec IN csr_get_archived_regions LOOP
592: IF csr_get_archived_regions_rec.action_information_category IN
593: ('ADDRESS DETAILS', pay_payroll_xml_extract_pkg.g_leg_code ||
594: ' EMPLOYER DETAILS') THEN
595: build_sql(sqlstr,
596: l_cntr_sql,
597: 'FOR csr_get_archived_info_rec IN pay_payroll_xml_extract_pkg.csr_get_archived_info (:l_action_context_id,'''||

Line 597: 'FOR csr_get_archived_info_rec IN pay_payroll_xml_extract_pkg.csr_get_archived_info (:l_action_context_id,'''||

593: ('ADDRESS DETAILS', pay_payroll_xml_extract_pkg.g_leg_code ||
594: ' EMPLOYER DETAILS') THEN
595: build_sql(sqlstr,
596: l_cntr_sql,
597: 'FOR csr_get_archived_info_rec IN pay_payroll_xml_extract_pkg.csr_get_archived_info (:l_action_context_id,'''||
598: csr_get_archived_regions_rec.action_information_category
599: ||''', l_org_id, :l_action_information_id) LOOP ');
600: ELSE
601: build_sql(sqlstr,

Line 603: 'FOR csr_get_archived_info_rec IN pay_payroll_xml_extract_pkg.csr_get_archived_info (:l_action_context_id,'''||

599: ||''', l_org_id, :l_action_information_id) LOOP ');
600: ELSE
601: build_sql(sqlstr,
602: l_cntr_sql,
603: 'FOR csr_get_archived_info_rec IN pay_payroll_xml_extract_pkg.csr_get_archived_info (:l_action_context_id,'''||
604: csr_get_archived_regions_rec.action_information_category
605: ||''', NULL, :l_action_information_id) LOOP ');
606: END IF;
607: build_sql(sqlstr,

Line 609: 'pay_payroll_xml_extract_pkg.load_xml(''CS'', NULL, ''' ||

605: ||''', NULL, :l_action_information_id) LOOP ');
606: END IF;
607: build_sql(sqlstr,
608: l_cntr_sql,
609: 'pay_payroll_xml_extract_pkg.load_xml(''CS'', NULL, ''' ||
610: csr_get_archived_regions_rec.action_information_category ||
611: ''', NULL);');
612: cntr_flex_col := 1;
613: LOOP

Line 624: 'pay_payroll_xml_extract_pkg.load_xml(''D'', ''Segment'

620: AND cntr_flex_col BETWEEN l_kff_seg_start
621: AND l_kff_seg_end THEN
622: build_sql(sqlstr,
623: l_cntr_sql,
624: 'pay_payroll_xml_extract_pkg.load_xml(''D'', ''Segment'
625: || (cntr_flex_col - l_kff_seg_start + 1) ||
626: ''', LTRIM(RTRIM(csr_get_archived_info_rec.action_information'
627: || cntr_flex_col ||')));');
628: ELSE

Line 631: 'pay_payroll_xml_extract_pkg.load_xml(''D'', '''

627: || cntr_flex_col ||')));');
628: ELSE
629: build_sql(sqlstr,
630: l_cntr_sql,
631: 'pay_payroll_xml_extract_pkg.load_xml(''D'', '''
632: || csr_get_archived_regions_rec.action_information_category ||
633: ''', ''ACTION_INFORMATION'|| cntr_flex_col ||
634: ''', LTRIM(RTRIM(csr_get_archived_info_rec.action_information'
635: || cntr_flex_col ||')));');

Line 645: 'FOR csr_payroll_details_rec IN pay_payroll_xml_extract_pkg.csr_payroll_details(csr_get_archived_info_rec.action_information16) LOOP ');

641: IF csr_get_archived_regions_rec.action_information_category =
642: 'EMPLOYEE DETAILS' THEN
643: build_sql(sqlstr,
644: l_cntr_sql,
645: 'FOR csr_payroll_details_rec IN pay_payroll_xml_extract_pkg.csr_payroll_details(csr_get_archived_info_rec.action_information16) LOOP ');
646: build_sql(sqlstr,
647: l_cntr_sql,
648: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYROLL_NAME'', csr_payroll_details_rec.payroll_name);');
649: build_sql(sqlstr,

Line 648: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYROLL_NAME'', csr_payroll_details_rec.payroll_name);');

644: l_cntr_sql,
645: 'FOR csr_payroll_details_rec IN pay_payroll_xml_extract_pkg.csr_payroll_details(csr_get_archived_info_rec.action_information16) LOOP ');
646: build_sql(sqlstr,
647: l_cntr_sql,
648: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYROLL_NAME'', csr_payroll_details_rec.payroll_name);');
649: build_sql(sqlstr,
650: l_cntr_sql,
651: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PERIOD_TYPE'', csr_payroll_details_rec.period_type);');
652: build_sql(sqlstr,

Line 651: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PERIOD_TYPE'', csr_payroll_details_rec.period_type);');

647: l_cntr_sql,
648: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYROLL_NAME'', csr_payroll_details_rec.payroll_name);');
649: build_sql(sqlstr,
650: l_cntr_sql,
651: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PERIOD_TYPE'', csr_payroll_details_rec.period_type);');
652: build_sql(sqlstr,
653: l_cntr_sql,
654: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''START_DATE'', csr_payroll_details_rec.start_date);');
655: build_sql(sqlstr,

Line 654: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''START_DATE'', csr_payroll_details_rec.start_date);');

650: l_cntr_sql,
651: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PERIOD_TYPE'', csr_payroll_details_rec.period_type);');
652: build_sql(sqlstr,
653: l_cntr_sql,
654: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''START_DATE'', csr_payroll_details_rec.start_date);');
655: build_sql(sqlstr,
656: l_cntr_sql,
657: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''END_DATE'', csr_payroll_details_rec.end_date);');
658: build_sql(sqlstr,

Line 657: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''END_DATE'', csr_payroll_details_rec.end_date);');

653: l_cntr_sql,
654: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''START_DATE'', csr_payroll_details_rec.start_date);');
655: build_sql(sqlstr,
656: l_cntr_sql,
657: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''END_DATE'', csr_payroll_details_rec.end_date);');
658: build_sql(sqlstr,
659: l_cntr_sql,
660: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYMENT_DATE'', substr(fnd_date.date_to_canonical(csr_get_archived_info_rec.effective_date),1,10));');
661: build_sql(sqlstr,

Line 660: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYMENT_DATE'', substr(fnd_date.date_to_canonical(csr_get_archived_info_rec.effective_date),1,10));');

656: l_cntr_sql,
657: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''END_DATE'', csr_payroll_details_rec.end_date);');
658: build_sql(sqlstr,
659: l_cntr_sql,
660: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYMENT_DATE'', substr(fnd_date.date_to_canonical(csr_get_archived_info_rec.effective_date),1,10));');
661: build_sql(sqlstr,
662: l_cntr_sql,
663: 'END LOOP;');
664: build_sql(sqlstr,

Line 676: pay_payroll_xml_extract_pkg.g_leg_code||

672: 'BEGIN ');
673: build_sql(sqlstr,
674: l_cntr_sql,
675: 'EXECUTE IMMEDIATE (''BEGIN pay_'||
676: pay_payroll_xml_extract_pkg.g_leg_code||
677: '_rules.add_custom_xml('||l_action_context_id||
678: ', '''''|| csr_get_archived_regions_rec.action_information_category ||
679: ''''', '''''|| p_document_type ||
680: '''''); END;'');');

Line 684: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');

680: '''''); END;'');');
681:
682: build_sql(sqlstr,
683: l_cntr_sql,
684: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
685: build_sql(sqlstr,
686: l_cntr_sql,
687: 'pay_payroll_xml_extract_pkg.load_xml('''');');
690: build_sql(sqlstr,
691: l_cntr_sql,

Line 688: pay_payroll_xml_extract_pkg.g_leg_code||

684: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
685: build_sql(sqlstr,
686: l_cntr_sql,
687: 'pay_payroll_xml_extract_pkg.load_xml('''');');
690: build_sql(sqlstr,
691: l_cntr_sql,
692: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

Line 692: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

688: pay_payroll_xml_extract_pkg.g_leg_code||
689: '_RULES.ADD_CUSTOM_XML -->'');');
690: build_sql(sqlstr,
691: l_cntr_sql,
692: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
693: build_sql(sqlstr,
694: l_cntr_sql,
695: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
696: build_sql(sqlstr,

Line 695: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');

691: l_cntr_sql,
692: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
693: build_sql(sqlstr,
694: l_cntr_sql,
695: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
696: build_sql(sqlstr,
697: l_cntr_sql,
698: 'END LOOP;');
699: build_sql(sqlstr,

Line 701: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');

697: l_cntr_sql,
698: 'END LOOP;');
699: build_sql(sqlstr,
700: l_cntr_sql,
701: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
702: build_sql(sqlstr,
703: l_cntr_sql,
704: 'END IF;');
705: build_sql(sqlstr,

Line 729: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');

725: ''''', '''''|| p_document_type ||
726: '''''); END;'');');
727: build_sql(sqlstr,
728: l_cntr_sql,
729: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
730: build_sql(sqlstr,
731: l_cntr_sql,
732: 'pay_payroll_xml_extract_pkg.load_xml('''');');

Line 732: 'pay_payroll_xml_extract_pkg.load_xml('''');');
734: build_sql(sqlstr,
735: l_cntr_sql,
736: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

Line 736: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

732: 'pay_payroll_xml_extract_pkg.load_xml('''');');
734: build_sql(sqlstr,
735: l_cntr_sql,
736: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
737: build_sql(sqlstr,
738: l_cntr_sql,
739: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
740: build_sql(sqlstr,

Line 739: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');

735: l_cntr_sql,
736: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
737: build_sql(sqlstr,
738: l_cntr_sql,
739: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
740: build_sql(sqlstr,
741: l_cntr_sql,
742: 'END LOOP;');
743: build_sql(sqlstr,

Line 745: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');

741: l_cntr_sql,
742: 'END LOOP;');
743: build_sql(sqlstr,
744: l_cntr_sql,
745: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
746: build_sql(sqlstr,
747: l_cntr_sql,
748: 'END IF;');
749: build_sql(sqlstr,

Line 761: 'pay_payroll_xml_extract_pkg.load_xml(''CE'', NULL, ''' ||

757: 'END;');
758:
759: build_sql(sqlstr,
760: l_cntr_sql,
761: 'pay_payroll_xml_extract_pkg.load_xml(''CE'', NULL, ''' ||
762: csr_get_archived_regions_rec.action_information_category ||
763: ''', NULL);');
764: build_sql(sqlstr,
765: l_cntr_sql,

Line 776: pay_payroll_xml_extract_pkg.g_leg_code||

772: 'BEGIN ');
773: build_sql(sqlstr,
774: l_cntr_sql,
775: 'EXECUTE IMMEDIATE (''BEGIN pay_'||
776: pay_payroll_xml_extract_pkg.g_leg_code||
777: '_rules.add_custom_xml('||l_action_context_id||', NULL'||
778: ', '''''|| p_document_type ||
779: '''''); END;'');');
780: build_sql(sqlstr,

Line 782: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');

778: ', '''''|| p_document_type ||
779: '''''); END;'');');
780: build_sql(sqlstr,
781: l_cntr_sql,
782: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
783: build_sql(sqlstr,
784: l_cntr_sql,
785: 'pay_payroll_xml_extract_pkg.load_xml('''');');
788: build_sql(sqlstr,
789: l_cntr_sql,

Line 786: pay_payroll_xml_extract_pkg.g_leg_code||

782: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
783: build_sql(sqlstr,
784: l_cntr_sql,
785: 'pay_payroll_xml_extract_pkg.load_xml('''');');
788: build_sql(sqlstr,
789: l_cntr_sql,
790: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

Line 790: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

786: pay_payroll_xml_extract_pkg.g_leg_code||
787: '_RULES.ADD_CUSTOM_XML -->'');');
788: build_sql(sqlstr,
789: l_cntr_sql,
790: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
791: build_sql(sqlstr,
792: l_cntr_sql,
793: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
794: build_sql(sqlstr,

Line 793: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');

789: l_cntr_sql,
790: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
791: build_sql(sqlstr,
792: l_cntr_sql,
793: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
794: build_sql(sqlstr,
795: l_cntr_sql,
796: 'END LOOP;');
797: build_sql(sqlstr,

Line 799: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');

795: l_cntr_sql,
796: 'END LOOP;');
797: build_sql(sqlstr,
798: l_cntr_sql,
799: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
800: build_sql(sqlstr,
801: l_cntr_sql,
802: 'END IF;');
803: build_sql(sqlstr,

Line 825: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');

821: ', '''''|| p_document_type ||
822: '''''); END;'');');
823: build_sql(sqlstr,
824: l_cntr_sql,
825: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
826: build_sql(sqlstr,
827: l_cntr_sql,
828: 'pay_payroll_xml_extract_pkg.load_xml('''');');

Line 828: 'pay_payroll_xml_extract_pkg.load_xml('''');');
830: build_sql(sqlstr,
831: l_cntr_sql,
832: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

Line 832: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

828: 'pay_payroll_xml_extract_pkg.load_xml('''');');
830: build_sql(sqlstr,
831: l_cntr_sql,
832: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
833: build_sql(sqlstr,
834: l_cntr_sql,
835: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
836: build_sql(sqlstr,

Line 835: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');

831: l_cntr_sql,
832: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
833: build_sql(sqlstr,
834: l_cntr_sql,
835: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
836: build_sql(sqlstr,
837: l_cntr_sql,
838: 'END LOOP;');
839: build_sql(sqlstr,

Line 841: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');

837: l_cntr_sql,
838: 'END LOOP;');
839: build_sql(sqlstr,
840: l_cntr_sql,
841: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
842: build_sql(sqlstr,
843: l_cntr_sql,
844: 'END IF;');
845: build_sql(sqlstr,

Line 858: 'pay_payroll_xml_extract_pkg.load_xml(''CE'', NULL, '''||

854:
855: IF p_root_tag IS NOT NULL THEN
856: build_sql(sqlstr,
857: l_cntr_sql,
858: 'pay_payroll_xml_extract_pkg.load_xml(''CE'', NULL, '''||
859: p_root_tag||''', NULL);');
860: END IF;
861:
862: build_sql(sqlstr,

Line 1009: l_last_param := pay_payroll_xml_extract_pkg.g_custom_params.last();

1005: dbms_lob.SESSION);
1006: FOR cntr_arch_rec IN
1007: p_action_inf_id_tab.first()..p_action_inf_id_tab.last()
1008: LOOP
1009: l_last_param := pay_payroll_xml_extract_pkg.g_custom_params.last();
1010: IF l_last_param IS NULL THEN
1011: l_last_param := 0;
1012: END IF;
1013:

Line 1014: pay_payroll_xml_extract_pkg.g_custom_params(

1010: IF l_last_param IS NULL THEN
1011: l_last_param := 0;
1012: END IF;
1013:
1014: pay_payroll_xml_extract_pkg.g_custom_params(
1015: l_last_param + 1).parameter_name := 'action_information_id';
1016:
1017: pay_payroll_xml_extract_pkg.g_custom_params(
1018: l_last_param + 1).parameter_value :=

Line 1017: pay_payroll_xml_extract_pkg.g_custom_params(

1013:
1014: pay_payroll_xml_extract_pkg.g_custom_params(
1015: l_last_param + 1).parameter_name := 'action_information_id';
1016:
1017: pay_payroll_xml_extract_pkg.g_custom_params(
1018: l_last_param + 1).parameter_value :=
1019: p_action_inf_id_tab(cntr_arch_rec);
1020:
1021: generate_internal(

Line 1038: pay_payroll_xml_extract_pkg.g_custom_params.delete(

1034: /* Remove the parameter 'action_information_id' before the next
1035: iteration (or returning to the calling program). Calling
1036: application is expected to clear this cache to avoid a
1037: possibility of stale parameter values in subsequent calls.*/
1038: pay_payroll_xml_extract_pkg.g_custom_params.delete(
1039: pay_payroll_xml_extract_pkg.g_custom_params.last());
1040: END LOOP;
1041: p_xml := l_xml;
1042: dbms_lob.freeTemporary(l_xml);

Line 1039: pay_payroll_xml_extract_pkg.g_custom_params.last());

1035: iteration (or returning to the calling program). Calling
1036: application is expected to clear this cache to avoid a
1037: possibility of stale parameter values in subsequent calls.*/
1038: pay_payroll_xml_extract_pkg.g_custom_params.delete(
1039: pay_payroll_xml_extract_pkg.g_custom_params.last());
1040: END LOOP;
1041: p_xml := l_xml;
1042: dbms_lob.freeTemporary(l_xml);
1043: END IF;

Line 1051: pay_payroll_xml_extract_pkg.g_custom_params.delete(

1047: -- Bug 6068599
1048: EXCEPTION
1049: WHEN OTHERS THEN
1050: /* Remove the parameter 'action_information_id' in case of error. */
1051: pay_payroll_xml_extract_pkg.g_custom_params.delete(
1052: pay_payroll_xml_extract_pkg.g_custom_params.last());
1053: hr_utility_trace (sqlerrm);
1054: RAISE;
1055: END;

Line 1052: pay_payroll_xml_extract_pkg.g_custom_params.last());

1048: EXCEPTION
1049: WHEN OTHERS THEN
1050: /* Remove the parameter 'action_information_id' in case of error. */
1051: pay_payroll_xml_extract_pkg.g_custom_params.delete(
1052: pay_payroll_xml_extract_pkg.g_custom_params.last());
1053: hr_utility_trace (sqlerrm);
1054: RAISE;
1055: END;
1056:

Line 1059: g_proc_name := 'PAY_PAYROLL_XML_EXTRACT_PKG.';

1055: END;
1056:
1057: BEGIN
1058: --hr_utility.trace_on (null, 'MX_IDC');
1059: g_proc_name := 'PAY_PAYROLL_XML_EXTRACT_PKG.';
1060: g_debug := hr_utility.debug_enabled;
1061: END PAY_PAYROLL_XML_EXTRACT_PKG;

Line 1061: END PAY_PAYROLL_XML_EXTRACT_PKG;

1057: BEGIN
1058: --hr_utility.trace_on (null, 'MX_IDC');
1059: g_proc_name := 'PAY_PAYROLL_XML_EXTRACT_PKG.';
1060: g_debug := hr_utility.debug_enabled;
1061: END PAY_PAYROLL_XML_EXTRACT_PKG;