APPS.PAY_MX_RULES dependencies on PAY_PAYROLL_XML_EXTRACT_PKG

Line 36: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()):=

32:
33: BEGIN
34: l_proc_name := g_proc_name || 'LOAD_XML';
35: hr_utility_trace ('Entering '||l_proc_name);
36: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()):=
37: p_xml;
38: hr_utility_trace ('Leaving '||l_proc_name);
39: END LOAD_XML;
40:

Line 663: FOR cntr in pay_payroll_xml_extract_pkg.g_custom_params.first()..

659: WHERE action_information_id = cp_action_info_id;
660:
661: FUNCTION get_param_val (p_param_name varchar2) return varchar2 is
662: BEGIN
663: FOR cntr in pay_payroll_xml_extract_pkg.g_custom_params.first()..
664: pay_payroll_xml_extract_pkg.g_custom_params.last()
665: LOOP
666: IF pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name
667: = p_param_name

Line 664: pay_payroll_xml_extract_pkg.g_custom_params.last()

660:
661: FUNCTION get_param_val (p_param_name varchar2) return varchar2 is
662: BEGIN
663: FOR cntr in pay_payroll_xml_extract_pkg.g_custom_params.first()..
664: pay_payroll_xml_extract_pkg.g_custom_params.last()
665: LOOP
666: IF pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name
667: = p_param_name
668: THEN

Line 666: IF pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name

662: BEGIN
663: FOR cntr in pay_payroll_xml_extract_pkg.g_custom_params.first()..
664: pay_payroll_xml_extract_pkg.g_custom_params.last()
665: LOOP
666: IF pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name
667: = p_param_name
668: THEN
669: hr_utility_trace('Custom Params : '||
670: pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name);

Line 670: pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name);

666: IF pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name
667: = p_param_name
668: THEN
669: hr_utility_trace('Custom Params : '||
670: pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name);
671:
672: hr_utility_trace('Custom Params Value : '||
673: pay_payroll_xml_extract_pkg.g_custom_params(cntr).
674: parameter_value);

Line 673: pay_payroll_xml_extract_pkg.g_custom_params(cntr).

669: hr_utility_trace('Custom Params : '||
670: pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name);
671:
672: hr_utility_trace('Custom Params Value : '||
673: pay_payroll_xml_extract_pkg.g_custom_params(cntr).
674: parameter_value);
675:
676: RETURN pay_payroll_xml_extract_pkg.g_custom_params(cntr).
677: parameter_value;

Line 676: RETURN pay_payroll_xml_extract_pkg.g_custom_params(cntr).

672: hr_utility_trace('Custom Params Value : '||
673: pay_payroll_xml_extract_pkg.g_custom_params(cntr).
674: parameter_value);
675:
676: RETURN pay_payroll_xml_extract_pkg.g_custom_params(cntr).
677: parameter_value;
678: END IF;
679:
680: END LOOP;

Line 777: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME',

773: hr_utility_trace('lv_country '|| lv_country);
774: hr_utility_trace('lv_state '|| lv_state);
775: hr_utility_trace('lv_maternal_last_name '|| lv_maternal_last_name);
776:
777: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME',
778: lv_org_name);
779: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME_REPORTING',
780: replace(strip_spl_chars (lv_org_name),'/','N'));
781: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE1',

Line 779: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME_REPORTING',

775: hr_utility_trace('lv_maternal_last_name '|| lv_maternal_last_name);
776:
777: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME',
778: lv_org_name);
779: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME_REPORTING',
780: replace(strip_spl_chars (lv_org_name),'/','N'));
781: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE1',
782: lv_address_line1);
783: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE2',

Line 781: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE1',

777: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME',
778: lv_org_name);
779: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME_REPORTING',
780: replace(strip_spl_chars (lv_org_name),'/','N'));
781: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE1',
782: lv_address_line1);
783: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE2',
784: lv_address_line2);
785: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',

Line 783: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE2',

779: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME_REPORTING',
780: replace(strip_spl_chars (lv_org_name),'/','N'));
781: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE1',
782: lv_address_line1);
783: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE2',
784: lv_address_line2);
785: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',
786: lv_address_line3);
787: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);

Line 785: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',

781: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE1',
782: lv_address_line1);
783: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE2',
784: lv_address_line2);
785: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',
786: lv_address_line3);
787: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);
788: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);
789: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);

Line 787: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);

783: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE2',
784: lv_address_line2);
785: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',
786: lv_address_line3);
787: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);
788: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);
789: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);
790: pay_payroll_xml_extract_pkg.load_xml_data('D','POSTAL_CODE',
791: lv_postal_code);

Line 788: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);

784: lv_address_line2);
785: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',
786: lv_address_line3);
787: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);
788: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);
789: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);
790: pay_payroll_xml_extract_pkg.load_xml_data('D','POSTAL_CODE',
791: lv_postal_code);
792: pay_payroll_xml_extract_pkg.load_xml_data('D','MATERNAL_LAST_NAME',

Line 789: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);

785: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',
786: lv_address_line3);
787: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);
788: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);
789: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);
790: pay_payroll_xml_extract_pkg.load_xml_data('D','POSTAL_CODE',
791: lv_postal_code);
792: pay_payroll_xml_extract_pkg.load_xml_data('D','MATERNAL_LAST_NAME',
793: lv_maternal_last_name);

Line 790: pay_payroll_xml_extract_pkg.load_xml_data('D','POSTAL_CODE',

786: lv_address_line3);
787: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);
788: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);
789: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);
790: pay_payroll_xml_extract_pkg.load_xml_data('D','POSTAL_CODE',
791: lv_postal_code);
792: pay_payroll_xml_extract_pkg.load_xml_data('D','MATERNAL_LAST_NAME',
793: lv_maternal_last_name);
794: pay_payroll_xml_extract_pkg.load_xml_data('D',

Line 792: pay_payroll_xml_extract_pkg.load_xml_data('D','MATERNAL_LAST_NAME',

788: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);
789: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);
790: pay_payroll_xml_extract_pkg.load_xml_data('D','POSTAL_CODE',
791: lv_postal_code);
792: pay_payroll_xml_extract_pkg.load_xml_data('D','MATERNAL_LAST_NAME',
793: lv_maternal_last_name);
794: pay_payroll_xml_extract_pkg.load_xml_data('D',
795: 'MATERNAL_LAST_NAME_REPORTING',
796: replace(strip_spl_chars (lv_maternal_last_name),'/','N'));

Line 794: pay_payroll_xml_extract_pkg.load_xml_data('D',

790: pay_payroll_xml_extract_pkg.load_xml_data('D','POSTAL_CODE',
791: lv_postal_code);
792: pay_payroll_xml_extract_pkg.load_xml_data('D','MATERNAL_LAST_NAME',
793: lv_maternal_last_name);
794: pay_payroll_xml_extract_pkg.load_xml_data('D',
795: 'MATERNAL_LAST_NAME_REPORTING',
796: replace(strip_spl_chars (lv_maternal_last_name),'/','N'));
797:
798: pay_payroll_xml_extract_pkg.load_xml_data('D','FIRST_NAME_REPORTING',

Line 798: pay_payroll_xml_extract_pkg.load_xml_data('D','FIRST_NAME_REPORTING',

794: pay_payroll_xml_extract_pkg.load_xml_data('D',
795: 'MATERNAL_LAST_NAME_REPORTING',
796: replace(strip_spl_chars (lv_maternal_last_name),'/','N'));
797:
798: pay_payroll_xml_extract_pkg.load_xml_data('D','FIRST_NAME_REPORTING',
799: replace(strip_spl_chars (lv_first_name),'/','N'));
800: pay_payroll_xml_extract_pkg.load_xml_data('D','LAST_NAME_REPORTING',
801: replace(strip_spl_chars (lv_last_name),'/','N'));
802: pay_payroll_xml_extract_pkg.load_xml_data('D','MIDDLE_NAMES_REPORTING',

Line 800: pay_payroll_xml_extract_pkg.load_xml_data('D','LAST_NAME_REPORTING',

796: replace(strip_spl_chars (lv_maternal_last_name),'/','N'));
797:
798: pay_payroll_xml_extract_pkg.load_xml_data('D','FIRST_NAME_REPORTING',
799: replace(strip_spl_chars (lv_first_name),'/','N'));
800: pay_payroll_xml_extract_pkg.load_xml_data('D','LAST_NAME_REPORTING',
801: replace(strip_spl_chars (lv_last_name),'/','N'));
802: pay_payroll_xml_extract_pkg.load_xml_data('D','MIDDLE_NAMES_REPORTING',
803: replace(strip_spl_chars (lv_middle_names),'/','N'));
804: pay_payroll_xml_extract_pkg.load_xml_data('D','ORDER_NAME_REPORTING',

Line 802: pay_payroll_xml_extract_pkg.load_xml_data('D','MIDDLE_NAMES_REPORTING',

798: pay_payroll_xml_extract_pkg.load_xml_data('D','FIRST_NAME_REPORTING',
799: replace(strip_spl_chars (lv_first_name),'/','N'));
800: pay_payroll_xml_extract_pkg.load_xml_data('D','LAST_NAME_REPORTING',
801: replace(strip_spl_chars (lv_last_name),'/','N'));
802: pay_payroll_xml_extract_pkg.load_xml_data('D','MIDDLE_NAMES_REPORTING',
803: replace(strip_spl_chars (lv_middle_names),'/','N'));
804: pay_payroll_xml_extract_pkg.load_xml_data('D','ORDER_NAME_REPORTING',
805: replace(strip_spl_chars (lv_order_name),'/','N'));
806: pay_payroll_xml_extract_pkg.load_xml_data('D','FULL_NAME_REPORTING',

Line 804: pay_payroll_xml_extract_pkg.load_xml_data('D','ORDER_NAME_REPORTING',

800: pay_payroll_xml_extract_pkg.load_xml_data('D','LAST_NAME_REPORTING',
801: replace(strip_spl_chars (lv_last_name),'/','N'));
802: pay_payroll_xml_extract_pkg.load_xml_data('D','MIDDLE_NAMES_REPORTING',
803: replace(strip_spl_chars (lv_middle_names),'/','N'));
804: pay_payroll_xml_extract_pkg.load_xml_data('D','ORDER_NAME_REPORTING',
805: replace(strip_spl_chars (lv_order_name),'/','N'));
806: pay_payroll_xml_extract_pkg.load_xml_data('D','FULL_NAME_REPORTING',
807: replace(strip_spl_chars (lv_full_name),'/','N'));
808: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYROLL_NAME_REPORTING',

Line 806: pay_payroll_xml_extract_pkg.load_xml_data('D','FULL_NAME_REPORTING',

802: pay_payroll_xml_extract_pkg.load_xml_data('D','MIDDLE_NAMES_REPORTING',
803: replace(strip_spl_chars (lv_middle_names),'/','N'));
804: pay_payroll_xml_extract_pkg.load_xml_data('D','ORDER_NAME_REPORTING',
805: replace(strip_spl_chars (lv_order_name),'/','N'));
806: pay_payroll_xml_extract_pkg.load_xml_data('D','FULL_NAME_REPORTING',
807: replace(strip_spl_chars (lv_full_name),'/','N'));
808: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYROLL_NAME_REPORTING',
809: replace(strip_spl_chars (lv_payroll_name),'/','N'));
810: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE_REPORTING',

Line 808: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYROLL_NAME_REPORTING',

804: pay_payroll_xml_extract_pkg.load_xml_data('D','ORDER_NAME_REPORTING',
805: replace(strip_spl_chars (lv_order_name),'/','N'));
806: pay_payroll_xml_extract_pkg.load_xml_data('D','FULL_NAME_REPORTING',
807: replace(strip_spl_chars (lv_full_name),'/','N'));
808: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYROLL_NAME_REPORTING',
809: replace(strip_spl_chars (lv_payroll_name),'/','N'));
810: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE_REPORTING',
811: lv_account_type);
812: END IF;

Line 810: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE_REPORTING',

806: pay_payroll_xml_extract_pkg.load_xml_data('D','FULL_NAME_REPORTING',
807: replace(strip_spl_chars (lv_full_name),'/','N'));
808: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYROLL_NAME_REPORTING',
809: replace(strip_spl_chars (lv_payroll_name),'/','N'));
810: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE_REPORTING',
811: lv_account_type);
812: END IF;
813:
814: /* Custom XML for SUA Interface Extract and Social Security Affiliation