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.22.12020000.11 2013/03/07 11:26:45 pkoduri 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 380: OPEN csr_get_tag_name (pay_payroll_xml_extract_pkg.g_leg_code||

376: l_proc_name := g_proc_name || 'LOAD_XML-2';
377: hr_utility_trace ('Entering '||l_proc_name);
378:
379: IF p_node_type = 'D' THEN
380: OPEN csr_get_tag_name (pay_payroll_xml_extract_pkg.g_leg_code||
381: '_BANK_DETAILS');
382: FETCH csr_get_tag_name INTO l_tag_name;
383: CLOSE csr_get_tag_name;
384: END IF;

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

667:
668: IF p_generate_header_flag THEN
669: build_sql(sqlstr,
670: l_cntr_sql,
671: 'pay_payroll_xml_extract_pkg.load_xml(''CS'', NULL, ''?xml version="1.0" encoding="'||
672: hr_mx_utility.get_IANA_charset||'"?'', NULL);');
673: END IF;
674: IF p_root_tag IS NOT NULL THEN
675: build_sql(sqlstr,

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

673: END IF;
674: IF p_root_tag IS NOT NULL THEN
675: build_sql(sqlstr,
676: l_cntr_sql,
677: 'pay_payroll_xml_extract_pkg.load_xml(''CS'', NULL, '''||
678: p_root_tag||''', NULL);');
679: END IF;
680:
681: /* Fetch legislation_code. */

Line 683: FETCH get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;

679: END IF;
680:
681: /* Fetch legislation_code. */
682: OPEN get_leg_code;
683: FETCH get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;
684: CLOSE get_leg_code;
685:
686:
687: /* Checking for International Payroll Legislation,

Line 690: g_install_leg_check := pay_ip_utility.get_ip_installation(pay_payroll_xml_extract_pkg.g_leg_code);

686:
687: /* Checking for International Payroll Legislation,
688: The flag g_install_leg_check returns 'N' for International Payroll localization and 'Y' for supported legislations.
689: */
690: g_install_leg_check := pay_ip_utility.get_ip_installation(pay_payroll_xml_extract_pkg.g_leg_code);
691:
692: FOR csr_get_archived_regions_rec IN csr_get_archived_regions LOOP
693: IF csr_get_archived_regions_rec.action_information_category IN
694: ('ADDRESS DETAILS', pay_payroll_xml_extract_pkg.g_leg_code ||

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

690: g_install_leg_check := pay_ip_utility.get_ip_installation(pay_payroll_xml_extract_pkg.g_leg_code);
691:
692: FOR csr_get_archived_regions_rec IN csr_get_archived_regions LOOP
693: IF csr_get_archived_regions_rec.action_information_category IN
694: ('ADDRESS DETAILS', pay_payroll_xml_extract_pkg.g_leg_code ||
695: ' EMPLOYER DETAILS') THEN
696: build_sql(sqlstr,
697: l_cntr_sql,
698: 'FOR csr_get_archived_info_rec IN pay_payroll_xml_extract_pkg.csr_get_archived_info (:l_action_context_id,'''||

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

694: ('ADDRESS DETAILS', pay_payroll_xml_extract_pkg.g_leg_code ||
695: ' EMPLOYER DETAILS') THEN
696: build_sql(sqlstr,
697: l_cntr_sql,
698: 'FOR csr_get_archived_info_rec IN pay_payroll_xml_extract_pkg.csr_get_archived_info (:l_action_context_id,'''||
699: csr_get_archived_regions_rec.action_information_category
700: ||''', l_org_id, :l_action_information_id) LOOP ');
701: ELSE
702: build_sql(sqlstr,

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

700: ||''', l_org_id, :l_action_information_id) LOOP ');
701: ELSE
702: build_sql(sqlstr,
703: l_cntr_sql,
704: 'FOR csr_get_archived_info_rec IN pay_payroll_xml_extract_pkg.csr_get_archived_info (:l_action_context_id,'''||
705: csr_get_archived_regions_rec.action_information_category
706: ||''', NULL, :l_action_information_id) LOOP ');
707: END IF;
708: build_sql(sqlstr,

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

706: ||''', NULL, :l_action_information_id) LOOP ');
707: END IF;
708: build_sql(sqlstr,
709: l_cntr_sql,
710: 'pay_payroll_xml_extract_pkg.load_xml(''CS'', NULL, ''' ||
711: csr_get_archived_regions_rec.action_information_category ||
712: ''', NULL);');
713: /*12636751 --Start */
714: IF csr_get_archived_regions_rec.action_information_category = 'EMPLOYEE DETAILS'

Line 715: AND pay_payroll_xml_extract_pkg.g_leg_code = 'US' THEN

711: csr_get_archived_regions_rec.action_information_category ||
712: ''', NULL);');
713: /*12636751 --Start */
714: IF csr_get_archived_regions_rec.action_information_category = 'EMPLOYEE DETAILS'
715: AND pay_payroll_xml_extract_pkg.g_leg_code = 'US' THEN
716: build_sql(sqlstr, l_cntr_sql, 'lt_pay_date := csr_get_archived_info_rec.effective_date;');
717:
718: build_sql(sqlstr,l_cntr_sql,
719: ' SELECT NVL((select lei_information13 from hr_location_extra_info hle ,HR_LOCATIONS_ALL HLA '||

Line 747: 'pay_payroll_xml_extract_pkg.load_xml(''D'', ''RATE_DISP_FLG'', lt_rate_flg);');

743: 'END IF;'||
744: 'END IF;'||
745: 'END IF;');
746: build_sql(sqlstr,l_cntr_sql,
747: 'pay_payroll_xml_extract_pkg.load_xml(''D'', ''RATE_DISP_FLG'', lt_rate_flg);');
748:
749: END IF;
750:
751: IF csr_get_archived_regions_rec.action_information_category = 'AC EARNINGS'

Line 752: AND pay_payroll_xml_extract_pkg.g_leg_code = 'US' THEN

748:
749: END IF;
750:
751: IF csr_get_archived_regions_rec.action_information_category = 'AC EARNINGS'
752: AND pay_payroll_xml_extract_pkg.g_leg_code = 'US' THEN
753: build_sql(sqlstr, l_cntr_sql, 'lt_state_cd := substr(csr_get_archived_info_rec.action_information21,1,2);');
754: build_sql(sqlstr, l_cntr_sql, 'lt_element_type := csr_get_archived_info_rec.action_information20;');
755: build_sql(sqlstr,
756: l_cntr_sql,

Line 761: ' pay_payroll_xml_extract_pkg.load_xml(''D'', ''DATE_DISP_FLG'', lt_ret_val);');

757: 'SELECT NVL(hruserdt.get_table_value('||lt_per_bgId_value||',''ONLINE_PAYSLIP_DATE_CONTROL_TBL'',lt_state_cd'||
758: ',lt_element_type,lt_pay_date),''N'') INTO lt_ret_val FROM DUAL ;');
759: build_sql(sqlstr,
760: l_cntr_sql,
761: ' pay_payroll_xml_extract_pkg.load_xml(''D'', ''DATE_DISP_FLG'', lt_ret_val);');
762: END IF;
763: /*12636751 --End */
764: /*13743223: */
765: IF csr_get_archived_regions_rec.action_information_category =

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

787: AND cntr_flex_col BETWEEN l_kff_seg_start
788: AND l_kff_seg_end THEN
789: build_sql(sqlstr,
790: l_cntr_sql,
791: 'pay_payroll_xml_extract_pkg.load_xml(''D'', ''Segment'
792: || (cntr_flex_col - l_kff_seg_start + 1) ||
793: ''', LTRIM(RTRIM(csr_get_archived_info_rec.action_information'
794: || cntr_flex_col ||')));');
795: ELSE

Line 802: AND pay_payroll_xml_extract_pkg.g_leg_code = 'US' THEN

798: and account_number field action_information7 masked for Employee Third party payments*/
799:
800: IF csr_get_archived_regions_rec.action_information_category =
801: 'EMPLOYEE THIRD PARTY PAYMENTS'
802: AND pay_payroll_xml_extract_pkg.g_leg_code = 'US' THEN
803: build_sql(sqlstr,
804: l_cntr_sql,
805: 'csr_get_archived_info_rec.action_information4 :=
806: pay_us_employee_payslip_web.get_check_number(csr_get_archived_info_rec.action_information17

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

813: END IF;
814:
815: build_sql(sqlstr,
816: l_cntr_sql,
817: 'pay_payroll_xml_extract_pkg.load_xml(''D'', '''
818: || csr_get_archived_regions_rec.action_information_category ||
819: ''', ''ACTION_INFORMATION'|| cntr_flex_col ||
820: ''', LTRIM(RTRIM(csr_get_archived_info_rec.action_information'
821: || cntr_flex_col ||')));');

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

827: IF csr_get_archived_regions_rec.action_information_category =
828: 'EMPLOYEE DETAILS' THEN
829: build_sql(sqlstr,
830: l_cntr_sql,
831: 'FOR csr_payroll_details_rec IN pay_payroll_xml_extract_pkg.csr_payroll_details(csr_get_archived_info_rec.action_information16) LOOP ');
832: build_sql(sqlstr,
833: l_cntr_sql,
834: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYROLL_NAME'', csr_payroll_details_rec.payroll_name);');
835: build_sql(sqlstr,

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

830: l_cntr_sql,
831: 'FOR csr_payroll_details_rec IN pay_payroll_xml_extract_pkg.csr_payroll_details(csr_get_archived_info_rec.action_information16) LOOP ');
832: build_sql(sqlstr,
833: l_cntr_sql,
834: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYROLL_NAME'', csr_payroll_details_rec.payroll_name);');
835: build_sql(sqlstr,
836: l_cntr_sql,
837: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PERIOD_TYPE'', csr_payroll_details_rec.period_type);');
838: build_sql(sqlstr,

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

833: l_cntr_sql,
834: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYROLL_NAME'', csr_payroll_details_rec.payroll_name);');
835: build_sql(sqlstr,
836: l_cntr_sql,
837: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PERIOD_TYPE'', csr_payroll_details_rec.period_type);');
838: build_sql(sqlstr,
839: l_cntr_sql,
840: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''START_DATE'', csr_payroll_details_rec.start_date);');
841: build_sql(sqlstr,

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

836: l_cntr_sql,
837: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PERIOD_TYPE'', csr_payroll_details_rec.period_type);');
838: build_sql(sqlstr,
839: l_cntr_sql,
840: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''START_DATE'', csr_payroll_details_rec.start_date);');
841: build_sql(sqlstr,
842: l_cntr_sql,
843: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''END_DATE'', csr_payroll_details_rec.end_date);');
844: build_sql(sqlstr,

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

839: l_cntr_sql,
840: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''START_DATE'', csr_payroll_details_rec.start_date);');
841: build_sql(sqlstr,
842: l_cntr_sql,
843: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''END_DATE'', csr_payroll_details_rec.end_date);');
844: build_sql(sqlstr,
845: l_cntr_sql,
846: '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));');
847: build_sql(sqlstr,

Line 846: '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));');

842: l_cntr_sql,
843: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''END_DATE'', csr_payroll_details_rec.end_date);');
844: build_sql(sqlstr,
845: l_cntr_sql,
846: '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));');
847: build_sql(sqlstr,
848: l_cntr_sql,
849: 'END LOOP;');
850: build_sql(sqlstr,

Line 878: pay_payroll_xml_extract_pkg.g_leg_code||

874:
875: build_sql(sqlstr,
876: l_cntr_sql,
877: 'EXECUTE IMMEDIATE (''BEGIN pay_'||
878: pay_payroll_xml_extract_pkg.g_leg_code||
879: '_rules.add_custom_xml('||l_action_context_id||
880: ', '''''|| csr_get_archived_regions_rec.action_information_category ||
881: ''''', '''''|| p_document_type ||
882: '''''); END;'');');

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

883: END IF;
884:
885: build_sql(sqlstr,
886: l_cntr_sql,
887: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
888: build_sql(sqlstr,
889: l_cntr_sql,
890: 'pay_payroll_xml_extract_pkg.load_xml('''');');
893: build_sql(sqlstr,
894: l_cntr_sql,

Line 891: pay_payroll_xml_extract_pkg.g_leg_code||

887: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
888: build_sql(sqlstr,
889: l_cntr_sql,
890: 'pay_payroll_xml_extract_pkg.load_xml('''');');
893: build_sql(sqlstr,
894: l_cntr_sql,
895: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

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

891: pay_payroll_xml_extract_pkg.g_leg_code||
892: '_RULES.ADD_CUSTOM_XML -->'');');
893: build_sql(sqlstr,
894: l_cntr_sql,
895: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
896: build_sql(sqlstr,
897: l_cntr_sql,
898: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
899: build_sql(sqlstr,

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

894: l_cntr_sql,
895: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
896: build_sql(sqlstr,
897: l_cntr_sql,
898: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
899: build_sql(sqlstr,
900: l_cntr_sql,
901: 'END LOOP;');
902: build_sql(sqlstr,

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

900: l_cntr_sql,
901: 'END LOOP;');
902: build_sql(sqlstr,
903: l_cntr_sql,
904: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
905: build_sql(sqlstr,
906: l_cntr_sql,
907: 'END IF;');
908: build_sql(sqlstr,

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

928: ''''', '''''|| p_document_type ||
929: '''''); END;'');');
930: build_sql(sqlstr,
931: l_cntr_sql,
932: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
933: build_sql(sqlstr,
934: l_cntr_sql,
935: 'pay_payroll_xml_extract_pkg.load_xml('''');');

Line 935: 'pay_payroll_xml_extract_pkg.load_xml('''');');
937: build_sql(sqlstr,
938: l_cntr_sql,
939: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

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

935: 'pay_payroll_xml_extract_pkg.load_xml('''');');
937: build_sql(sqlstr,
938: l_cntr_sql,
939: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
940: build_sql(sqlstr,
941: l_cntr_sql,
942: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
943: build_sql(sqlstr,

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

938: l_cntr_sql,
939: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
940: build_sql(sqlstr,
941: l_cntr_sql,
942: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
943: build_sql(sqlstr,
944: l_cntr_sql,
945: 'END LOOP;');
946: build_sql(sqlstr,

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

944: l_cntr_sql,
945: 'END LOOP;');
946: build_sql(sqlstr,
947: l_cntr_sql,
948: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
949: build_sql(sqlstr,
950: l_cntr_sql,
951: 'END IF;');
952: build_sql(sqlstr,

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

960: 'END;');
961:
962: build_sql(sqlstr,
963: l_cntr_sql,
964: 'pay_payroll_xml_extract_pkg.load_xml(''CE'', NULL, ''' ||
965: csr_get_archived_regions_rec.action_information_category ||
966: ''', NULL);');
967: build_sql(sqlstr,
968: l_cntr_sql,

Line 992: pay_payroll_xml_extract_pkg.g_leg_code||

988:
989: build_sql(sqlstr,
990: l_cntr_sql,
991: 'EXECUTE IMMEDIATE (''BEGIN pay_'||
992: pay_payroll_xml_extract_pkg.g_leg_code||
993: '_rules.add_custom_xml('||l_action_context_id||', NULL'||
994: ', '''''|| p_document_type ||
995: '''''); END;'');');
996: END IF;

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

995: '''''); END;'');');
996: END IF;
997: build_sql(sqlstr,
998: l_cntr_sql,
999: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
1000: build_sql(sqlstr,
1001: l_cntr_sql,
1002: 'pay_payroll_xml_extract_pkg.load_xml('''');');
1005: build_sql(sqlstr,
1006: l_cntr_sql,

Line 1003: pay_payroll_xml_extract_pkg.g_leg_code||

999: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
1000: build_sql(sqlstr,
1001: l_cntr_sql,
1002: 'pay_payroll_xml_extract_pkg.load_xml('''');');
1005: build_sql(sqlstr,
1006: l_cntr_sql,
1007: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

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

1003: pay_payroll_xml_extract_pkg.g_leg_code||
1004: '_RULES.ADD_CUSTOM_XML -->'');');
1005: build_sql(sqlstr,
1006: l_cntr_sql,
1007: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
1008: build_sql(sqlstr,
1009: l_cntr_sql,
1010: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
1011: build_sql(sqlstr,

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

1006: l_cntr_sql,
1007: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
1008: build_sql(sqlstr,
1009: l_cntr_sql,
1010: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
1011: build_sql(sqlstr,
1012: l_cntr_sql,
1013: 'END LOOP;');
1014: build_sql(sqlstr,

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

1012: l_cntr_sql,
1013: 'END LOOP;');
1014: build_sql(sqlstr,
1015: l_cntr_sql,
1016: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
1017: build_sql(sqlstr,
1018: l_cntr_sql,
1019: 'END IF;');
1020: build_sql(sqlstr,

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

1038: ', '''''|| p_document_type ||
1039: '''''); END;'');');
1040: build_sql(sqlstr,
1041: l_cntr_sql,
1042: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
1043: build_sql(sqlstr,
1044: l_cntr_sql,
1045: 'pay_payroll_xml_extract_pkg.load_xml('''');');

Line 1045: 'pay_payroll_xml_extract_pkg.load_xml('''');');
1047: build_sql(sqlstr,
1048: l_cntr_sql,
1049: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

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

1045: 'pay_payroll_xml_extract_pkg.load_xml('''');');
1047: build_sql(sqlstr,
1048: l_cntr_sql,
1049: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
1050: build_sql(sqlstr,
1051: l_cntr_sql,
1052: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
1053: build_sql(sqlstr,

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

1048: l_cntr_sql,
1049: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
1050: build_sql(sqlstr,
1051: l_cntr_sql,
1052: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
1053: build_sql(sqlstr,
1054: l_cntr_sql,
1055: 'END LOOP;');
1056: build_sql(sqlstr,

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

1054: l_cntr_sql,
1055: 'END LOOP;');
1056: build_sql(sqlstr,
1057: l_cntr_sql,
1058: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
1059: build_sql(sqlstr,
1060: l_cntr_sql,
1061: 'END IF;');
1062: build_sql(sqlstr,

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

1071:
1072: IF p_root_tag IS NOT NULL THEN
1073: build_sql(sqlstr,
1074: l_cntr_sql,
1075: 'pay_payroll_xml_extract_pkg.load_xml(''CE'', NULL, '''||
1076: p_root_tag||''', NULL);');
1077: END IF;
1078:
1079: build_sql(sqlstr,

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

1222: dbms_lob.SESSION);
1223: FOR cntr_arch_rec IN
1224: p_action_inf_id_tab.first()..p_action_inf_id_tab.last()
1225: LOOP
1226: l_last_param := pay_payroll_xml_extract_pkg.g_custom_params.last();
1227: IF l_last_param IS NULL THEN
1228: l_last_param := 0;
1229: END IF;
1230:

Line 1231: pay_payroll_xml_extract_pkg.g_custom_params(

1227: IF l_last_param IS NULL THEN
1228: l_last_param := 0;
1229: END IF;
1230:
1231: pay_payroll_xml_extract_pkg.g_custom_params(
1232: l_last_param + 1).parameter_name := 'action_information_id';
1233:
1234: pay_payroll_xml_extract_pkg.g_custom_params(
1235: l_last_param + 1).parameter_value :=

Line 1234: pay_payroll_xml_extract_pkg.g_custom_params(

1230:
1231: pay_payroll_xml_extract_pkg.g_custom_params(
1232: l_last_param + 1).parameter_name := 'action_information_id';
1233:
1234: pay_payroll_xml_extract_pkg.g_custom_params(
1235: l_last_param + 1).parameter_value :=
1236: p_action_inf_id_tab(cntr_arch_rec);
1237:
1238: generate_internal(

Line 1255: pay_payroll_xml_extract_pkg.g_custom_params.delete(

1251: /* Remove the parameter 'action_information_id' before the next
1252: iteration (or returning to the calling program). Calling
1253: application is expected to clear this cache to avoid a
1254: possibility of stale parameter values in subsequent calls.*/
1255: pay_payroll_xml_extract_pkg.g_custom_params.delete(
1256: pay_payroll_xml_extract_pkg.g_custom_params.last());
1257: END LOOP;
1258: p_xml := l_xml;
1259: dbms_lob.freeTemporary(l_xml);

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

1252: iteration (or returning to the calling program). Calling
1253: application is expected to clear this cache to avoid a
1254: possibility of stale parameter values in subsequent calls.*/
1255: pay_payroll_xml_extract_pkg.g_custom_params.delete(
1256: pay_payroll_xml_extract_pkg.g_custom_params.last());
1257: END LOOP;
1258: p_xml := l_xml;
1259: dbms_lob.freeTemporary(l_xml);
1260: END IF;

Line 1268: pay_payroll_xml_extract_pkg.g_custom_params.delete(

1264: -- Bug 6068599
1265: EXCEPTION
1266: WHEN OTHERS THEN
1267: /* Remove the parameter 'action_information_id' in case of error. */
1268: pay_payroll_xml_extract_pkg.g_custom_params.delete(
1269: pay_payroll_xml_extract_pkg.g_custom_params.last());
1270: hr_utility_trace (sqlerrm);
1271: RAISE;
1272: END;

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

1265: EXCEPTION
1266: WHEN OTHERS THEN
1267: /* Remove the parameter 'action_information_id' in case of error. */
1268: pay_payroll_xml_extract_pkg.g_custom_params.delete(
1269: pay_payroll_xml_extract_pkg.g_custom_params.last());
1270: hr_utility_trace (sqlerrm);
1271: RAISE;
1272: END;
1273:

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

1393:
1394: IF p_generate_header_flag THEN
1395: build_sql(sqlstr,
1396: l_cntr_sql,
1397: 'pay_payroll_xml_extract_pkg.load_xml(''CS'', NULL, ''?xml version="1.0" encoding="'||
1398: hr_mx_utility.get_IANA_charset||'"?'', NULL);');
1399: END IF;
1400: IF p_root_tag IS NOT NULL THEN
1401: build_sql(sqlstr,

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

1399: END IF;
1400: IF p_root_tag IS NOT NULL THEN
1401: build_sql(sqlstr,
1402: l_cntr_sql,
1403: 'pay_payroll_xml_extract_pkg.load_xml(''CS'', NULL, '''||
1404: p_root_tag||''', NULL);');
1405: END IF;
1406:
1407: /* Fetch legislation_code. */

Line 1409: FETCH get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;

1405: END IF;
1406:
1407: /* Fetch legislation_code. */
1408: OPEN get_leg_code;
1409: FETCH get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;
1410: CLOSE get_leg_code;
1411: FOR csr_get_archived_regions_rec IN csr_get_archived_regions LOOP
1412: hr_utility_trace('csr_get_archived_regions_rec = '||csr_get_archived_regions_rec.action_information_category);
1413: hr_utility_trace('pay_payroll_xml_extract_pkg.g_leg_code = '||pay_payroll_xml_extract_pkg.g_leg_code);

Line 1413: hr_utility_trace('pay_payroll_xml_extract_pkg.g_leg_code = '||pay_payroll_xml_extract_pkg.g_leg_code);

1409: FETCH get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;
1410: CLOSE get_leg_code;
1411: FOR csr_get_archived_regions_rec IN csr_get_archived_regions LOOP
1412: hr_utility_trace('csr_get_archived_regions_rec = '||csr_get_archived_regions_rec.action_information_category);
1413: hr_utility_trace('pay_payroll_xml_extract_pkg.g_leg_code = '||pay_payroll_xml_extract_pkg.g_leg_code);
1414:
1415: IF (csr_get_archived_regions_rec.action_information_category LIKE pay_payroll_xml_extract_pkg.g_leg_code||'%THIRD PARTY CHECKS' OR
1416: csr_get_archived_regions_rec.action_information_category LIKE pay_payroll_xml_extract_pkg.g_leg_code||'%THIRD PARTY CHEQUES') THEN
1417: build_sql(sqlstr,

Line 1415: IF (csr_get_archived_regions_rec.action_information_category LIKE pay_payroll_xml_extract_pkg.g_leg_code||'%THIRD PARTY CHECKS' OR

1411: FOR csr_get_archived_regions_rec IN csr_get_archived_regions LOOP
1412: hr_utility_trace('csr_get_archived_regions_rec = '||csr_get_archived_regions_rec.action_information_category);
1413: hr_utility_trace('pay_payroll_xml_extract_pkg.g_leg_code = '||pay_payroll_xml_extract_pkg.g_leg_code);
1414:
1415: IF (csr_get_archived_regions_rec.action_information_category LIKE pay_payroll_xml_extract_pkg.g_leg_code||'%THIRD PARTY CHECKS' OR
1416: csr_get_archived_regions_rec.action_information_category LIKE pay_payroll_xml_extract_pkg.g_leg_code||'%THIRD PARTY CHEQUES') THEN
1417: build_sql(sqlstr,
1418: l_cntr_sql,
1419: 'FOR csr_get_archived_info_rec IN pay_payroll_xml_extract_pkg.csr_get_thd_pty_arch_info (:l_action_context_id,'''||

Line 1416: csr_get_archived_regions_rec.action_information_category LIKE pay_payroll_xml_extract_pkg.g_leg_code||'%THIRD PARTY CHEQUES') THEN

1412: hr_utility_trace('csr_get_archived_regions_rec = '||csr_get_archived_regions_rec.action_information_category);
1413: hr_utility_trace('pay_payroll_xml_extract_pkg.g_leg_code = '||pay_payroll_xml_extract_pkg.g_leg_code);
1414:
1415: IF (csr_get_archived_regions_rec.action_information_category LIKE pay_payroll_xml_extract_pkg.g_leg_code||'%THIRD PARTY CHECKS' OR
1416: csr_get_archived_regions_rec.action_information_category LIKE pay_payroll_xml_extract_pkg.g_leg_code||'%THIRD PARTY CHEQUES') THEN
1417: build_sql(sqlstr,
1418: l_cntr_sql,
1419: 'FOR csr_get_archived_info_rec IN pay_payroll_xml_extract_pkg.csr_get_thd_pty_arch_info (:l_action_context_id,'''||
1420: csr_get_archived_regions_rec.action_information_category

Line 1419: 'FOR csr_get_archived_info_rec IN pay_payroll_xml_extract_pkg.csr_get_thd_pty_arch_info (:l_action_context_id,'''||

1415: IF (csr_get_archived_regions_rec.action_information_category LIKE pay_payroll_xml_extract_pkg.g_leg_code||'%THIRD PARTY CHECKS' OR
1416: csr_get_archived_regions_rec.action_information_category LIKE pay_payroll_xml_extract_pkg.g_leg_code||'%THIRD PARTY CHEQUES') THEN
1417: build_sql(sqlstr,
1418: l_cntr_sql,
1419: 'FOR csr_get_archived_info_rec IN pay_payroll_xml_extract_pkg.csr_get_thd_pty_arch_info (:l_action_context_id,'''||
1420: csr_get_archived_regions_rec.action_information_category
1421: ||''', :l_pre_payment_id) LOOP ');
1422: cntr_flex_col := 1;
1423: LOOP

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

1427: csr_get_archived_regions_rec.action_information_category,
1428: 'ACTION_INFORMATION'||cntr_flex_col) THEN
1429: build_sql(sqlstr,
1430: l_cntr_sql,
1431: 'pay_payroll_xml_extract_pkg.load_xml(''D'', '''
1432: || csr_get_archived_regions_rec.action_information_category ||
1433: ''', ''ACTION_INFORMATION'|| cntr_flex_col ||
1434: ''', LTRIM(RTRIM(csr_get_archived_info_rec.action_information'
1435: || cntr_flex_col ||')));');

Line 1448: pay_payroll_xml_extract_pkg.g_leg_code||

1444: 'BEGIN ');
1445: build_sql(sqlstr,
1446: l_cntr_sql,
1447: 'EXECUTE IMMEDIATE (''BEGIN pay_'||
1448: pay_payroll_xml_extract_pkg.g_leg_code||
1449: '_rules.add_custom_xml('||l_action_context_id||
1450: ', '''''|| csr_get_archived_regions_rec.action_information_category ||
1451: ''''', '''''|| p_document_type ||
1452: '''''); END;'');');

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

1451: ''''', '''''|| p_document_type ||
1452: '''''); END;'');');
1453: build_sql(sqlstr,
1454: l_cntr_sql,
1455: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
1456: build_sql(sqlstr,
1457: l_cntr_sql,
1458: 'pay_payroll_xml_extract_pkg.load_xml('''');');
1461: build_sql(sqlstr,
1462: l_cntr_sql,

Line 1459: pay_payroll_xml_extract_pkg.g_leg_code||

1455: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
1456: build_sql(sqlstr,
1457: l_cntr_sql,
1458: 'pay_payroll_xml_extract_pkg.load_xml('''');');
1461: build_sql(sqlstr,
1462: l_cntr_sql,
1463: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

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

1459: pay_payroll_xml_extract_pkg.g_leg_code||
1460: '_RULES.ADD_CUSTOM_XML -->'');');
1461: build_sql(sqlstr,
1462: l_cntr_sql,
1463: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
1464: build_sql(sqlstr,
1465: l_cntr_sql,
1466: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
1467: build_sql(sqlstr,

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

1462: l_cntr_sql,
1463: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
1464: build_sql(sqlstr,
1465: l_cntr_sql,
1466: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
1467: build_sql(sqlstr,
1468: l_cntr_sql,
1469: 'END LOOP;');
1470: build_sql(sqlstr,

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

1468: l_cntr_sql,
1469: 'END LOOP;');
1470: build_sql(sqlstr,
1471: l_cntr_sql,
1472: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
1473: build_sql(sqlstr,
1474: l_cntr_sql,
1475: 'END IF;');
1476: build_sql(sqlstr,

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

1496: ''''', '''''|| p_document_type ||
1497: '''''); END;'');');
1498: build_sql(sqlstr,
1499: l_cntr_sql,
1500: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
1501: build_sql(sqlstr,
1502: l_cntr_sql,
1503: 'pay_payroll_xml_extract_pkg.load_xml('''');');

Line 1503: 'pay_payroll_xml_extract_pkg.load_xml('''');');
1505: build_sql(sqlstr,
1506: l_cntr_sql,
1507: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

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

1503: 'pay_payroll_xml_extract_pkg.load_xml('''');');
1505: build_sql(sqlstr,
1506: l_cntr_sql,
1507: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
1508: build_sql(sqlstr,
1509: l_cntr_sql,
1510: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
1511: build_sql(sqlstr,

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

1506: l_cntr_sql,
1507: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
1508: build_sql(sqlstr,
1509: l_cntr_sql,
1510: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
1511: build_sql(sqlstr,
1512: l_cntr_sql,
1513: 'END LOOP;');
1514: build_sql(sqlstr,

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

1512: l_cntr_sql,
1513: 'END LOOP;');
1514: build_sql(sqlstr,
1515: l_cntr_sql,
1516: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
1517: build_sql(sqlstr,
1518: l_cntr_sql,
1519: 'END IF;');
1520: build_sql(sqlstr,

Line 1543: pay_payroll_xml_extract_pkg.g_leg_code||

1539: 'BEGIN ');
1540: build_sql(sqlstr,
1541: l_cntr_sql,
1542: 'EXECUTE IMMEDIATE (''BEGIN pay_'||
1543: pay_payroll_xml_extract_pkg.g_leg_code||
1544: '_rules.add_custom_xml('||l_action_context_id||', NULL'||
1545: ', '''''|| p_document_type ||
1546: '''''); END;'');');
1547: build_sql(sqlstr,

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

1545: ', '''''|| p_document_type ||
1546: '''''); END;'');');
1547: build_sql(sqlstr,
1548: l_cntr_sql,
1549: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
1550: build_sql(sqlstr,
1551: l_cntr_sql,
1552: 'pay_payroll_xml_extract_pkg.load_xml('''');');
1555: build_sql(sqlstr,
1556: l_cntr_sql,

Line 1553: pay_payroll_xml_extract_pkg.g_leg_code||

1549: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
1550: build_sql(sqlstr,
1551: l_cntr_sql,
1552: 'pay_payroll_xml_extract_pkg.load_xml('''');');
1555: build_sql(sqlstr,
1556: l_cntr_sql,
1557: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

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

1553: pay_payroll_xml_extract_pkg.g_leg_code||
1554: '_RULES.ADD_CUSTOM_XML -->'');');
1555: build_sql(sqlstr,
1556: l_cntr_sql,
1557: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
1558: build_sql(sqlstr,
1559: l_cntr_sql,
1560: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
1561: build_sql(sqlstr,

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

1556: l_cntr_sql,
1557: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
1558: build_sql(sqlstr,
1559: l_cntr_sql,
1560: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
1561: build_sql(sqlstr,
1562: l_cntr_sql,
1563: 'END LOOP;');
1564: build_sql(sqlstr,

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

1562: l_cntr_sql,
1563: 'END LOOP;');
1564: build_sql(sqlstr,
1565: l_cntr_sql,
1566: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
1567: build_sql(sqlstr,
1568: l_cntr_sql,
1569: 'END IF;');
1570: build_sql(sqlstr,

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

1588: ', '''''|| p_document_type ||
1589: '''''); END;'');');
1590: build_sql(sqlstr,
1591: l_cntr_sql,
1592: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
1593: build_sql(sqlstr,
1594: l_cntr_sql,
1595: 'pay_payroll_xml_extract_pkg.load_xml('''');');

Line 1595: 'pay_payroll_xml_extract_pkg.load_xml('''');');
1597: build_sql(sqlstr,
1598: l_cntr_sql,
1599: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

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

1595: 'pay_payroll_xml_extract_pkg.load_xml('''');');
1597: build_sql(sqlstr,
1598: l_cntr_sql,
1599: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
1600: build_sql(sqlstr,
1601: l_cntr_sql,
1602: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
1603: build_sql(sqlstr,

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

1598: l_cntr_sql,
1599: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
1600: build_sql(sqlstr,
1601: l_cntr_sql,
1602: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
1603: build_sql(sqlstr,
1604: l_cntr_sql,
1605: 'END LOOP;');
1606: build_sql(sqlstr,

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

1604: l_cntr_sql,
1605: 'END LOOP;');
1606: build_sql(sqlstr,
1607: l_cntr_sql,
1608: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
1609: build_sql(sqlstr,
1610: l_cntr_sql,
1611: 'END IF;');
1612: build_sql(sqlstr,

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

1621:
1622: IF p_root_tag IS NOT NULL THEN
1623: build_sql(sqlstr,
1624: l_cntr_sql,
1625: 'pay_payroll_xml_extract_pkg.load_xml(''CE'', NULL, '''||
1626: p_root_tag||''', NULL);');
1627: END IF;
1628:
1629: build_sql(sqlstr,

Line 1692: g_proc_name := 'PAY_PAYROLL_XML_EXTRACT_PKG.';

1688:
1689:
1690: BEGIN
1691: --hr_utility.trace_on (null, 'MX_IDC');
1692: g_proc_name := 'PAY_PAYROLL_XML_EXTRACT_PKG.';
1693: g_debug := hr_utility.debug_enabled;
1694: END PAY_PAYROLL_XML_EXTRACT_PKG;

Line 1694: END PAY_PAYROLL_XML_EXTRACT_PKG;

1690: BEGIN
1691: --hr_utility.trace_on (null, 'MX_IDC');
1692: g_proc_name := 'PAY_PAYROLL_XML_EXTRACT_PKG.';
1693: g_debug := hr_utility.debug_enabled;
1694: END PAY_PAYROLL_XML_EXTRACT_PKG;