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 682: FOR cntr in pay_payroll_xml_extract_pkg.g_custom_params.first()..

678: WHERE action_information_id = cp_action_info_id;
679:
680: FUNCTION get_param_val (p_param_name varchar2) return varchar2 is
681: BEGIN
682: FOR cntr in pay_payroll_xml_extract_pkg.g_custom_params.first()..
683: pay_payroll_xml_extract_pkg.g_custom_params.last()
684: LOOP
685: IF pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name
686: = p_param_name

Line 683: pay_payroll_xml_extract_pkg.g_custom_params.last()

679:
680: FUNCTION get_param_val (p_param_name varchar2) return varchar2 is
681: BEGIN
682: FOR cntr in pay_payroll_xml_extract_pkg.g_custom_params.first()..
683: pay_payroll_xml_extract_pkg.g_custom_params.last()
684: LOOP
685: IF pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name
686: = p_param_name
687: THEN

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

681: BEGIN
682: FOR cntr in pay_payroll_xml_extract_pkg.g_custom_params.first()..
683: pay_payroll_xml_extract_pkg.g_custom_params.last()
684: LOOP
685: IF pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name
686: = p_param_name
687: THEN
688: hr_utility_trace('Custom Params : '||
689: pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name);

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

685: IF pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name
686: = p_param_name
687: THEN
688: hr_utility_trace('Custom Params : '||
689: pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name);
690:
691: hr_utility_trace('Custom Params Value : '||
692: pay_payroll_xml_extract_pkg.g_custom_params(cntr).
693: parameter_value);

Line 692: pay_payroll_xml_extract_pkg.g_custom_params(cntr).

688: hr_utility_trace('Custom Params : '||
689: pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name);
690:
691: hr_utility_trace('Custom Params Value : '||
692: pay_payroll_xml_extract_pkg.g_custom_params(cntr).
693: parameter_value);
694:
695: RETURN pay_payroll_xml_extract_pkg.g_custom_params(cntr).
696: parameter_value;

Line 695: RETURN pay_payroll_xml_extract_pkg.g_custom_params(cntr).

691: hr_utility_trace('Custom Params Value : '||
692: pay_payroll_xml_extract_pkg.g_custom_params(cntr).
693: parameter_value);
694:
695: RETURN pay_payroll_xml_extract_pkg.g_custom_params(cntr).
696: parameter_value;
697: END IF;
698:
699: END LOOP;

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

792: hr_utility_trace('lv_country '|| lv_country);
793: hr_utility_trace('lv_state '|| lv_state);
794: hr_utility_trace('lv_maternal_last_name '|| lv_maternal_last_name);
795:
796: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME',
797: lv_org_name);
798: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME_REPORTING',
799: replace(strip_spl_chars (lv_org_name),'/','N'));
800: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE1',

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

794: hr_utility_trace('lv_maternal_last_name '|| lv_maternal_last_name);
795:
796: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME',
797: lv_org_name);
798: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME_REPORTING',
799: replace(strip_spl_chars (lv_org_name),'/','N'));
800: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE1',
801: lv_address_line1);
802: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE2',

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

796: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME',
797: lv_org_name);
798: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME_REPORTING',
799: replace(strip_spl_chars (lv_org_name),'/','N'));
800: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE1',
801: lv_address_line1);
802: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE2',
803: lv_address_line2);
804: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',

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

798: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME_REPORTING',
799: replace(strip_spl_chars (lv_org_name),'/','N'));
800: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE1',
801: lv_address_line1);
802: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE2',
803: lv_address_line2);
804: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',
805: lv_address_line3);
806: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);

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

800: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE1',
801: lv_address_line1);
802: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE2',
803: lv_address_line2);
804: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',
805: lv_address_line3);
806: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);
807: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);
808: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);

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

802: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE2',
803: lv_address_line2);
804: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',
805: lv_address_line3);
806: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);
807: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);
808: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);
809: pay_payroll_xml_extract_pkg.load_xml_data('D','POSTAL_CODE',
810: lv_postal_code);

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

803: lv_address_line2);
804: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',
805: lv_address_line3);
806: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);
807: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);
808: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);
809: pay_payroll_xml_extract_pkg.load_xml_data('D','POSTAL_CODE',
810: lv_postal_code);
811: pay_payroll_xml_extract_pkg.load_xml_data('D','MATERNAL_LAST_NAME',

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

804: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',
805: lv_address_line3);
806: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);
807: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);
808: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);
809: pay_payroll_xml_extract_pkg.load_xml_data('D','POSTAL_CODE',
810: lv_postal_code);
811: pay_payroll_xml_extract_pkg.load_xml_data('D','MATERNAL_LAST_NAME',
812: lv_maternal_last_name);

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

805: lv_address_line3);
806: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);
807: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);
808: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);
809: pay_payroll_xml_extract_pkg.load_xml_data('D','POSTAL_CODE',
810: lv_postal_code);
811: pay_payroll_xml_extract_pkg.load_xml_data('D','MATERNAL_LAST_NAME',
812: lv_maternal_last_name);
813: pay_payroll_xml_extract_pkg.load_xml_data('D',

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

807: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);
808: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);
809: pay_payroll_xml_extract_pkg.load_xml_data('D','POSTAL_CODE',
810: lv_postal_code);
811: pay_payroll_xml_extract_pkg.load_xml_data('D','MATERNAL_LAST_NAME',
812: lv_maternal_last_name);
813: pay_payroll_xml_extract_pkg.load_xml_data('D',
814: 'MATERNAL_LAST_NAME_REPORTING',
815: replace(strip_spl_chars (lv_maternal_last_name),'/','N'));

Line 813: pay_payroll_xml_extract_pkg.load_xml_data('D',

809: pay_payroll_xml_extract_pkg.load_xml_data('D','POSTAL_CODE',
810: lv_postal_code);
811: pay_payroll_xml_extract_pkg.load_xml_data('D','MATERNAL_LAST_NAME',
812: lv_maternal_last_name);
813: pay_payroll_xml_extract_pkg.load_xml_data('D',
814: 'MATERNAL_LAST_NAME_REPORTING',
815: replace(strip_spl_chars (lv_maternal_last_name),'/','N'));
816:
817: pay_payroll_xml_extract_pkg.load_xml_data('D','FIRST_NAME_REPORTING',

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

813: pay_payroll_xml_extract_pkg.load_xml_data('D',
814: 'MATERNAL_LAST_NAME_REPORTING',
815: replace(strip_spl_chars (lv_maternal_last_name),'/','N'));
816:
817: pay_payroll_xml_extract_pkg.load_xml_data('D','FIRST_NAME_REPORTING',
818: replace(strip_spl_chars (lv_first_name),'/','N'));
819: pay_payroll_xml_extract_pkg.load_xml_data('D','LAST_NAME_REPORTING',
820: replace(strip_spl_chars (lv_last_name),'/','N'));
821: pay_payroll_xml_extract_pkg.load_xml_data('D','MIDDLE_NAMES_REPORTING',

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

815: replace(strip_spl_chars (lv_maternal_last_name),'/','N'));
816:
817: pay_payroll_xml_extract_pkg.load_xml_data('D','FIRST_NAME_REPORTING',
818: replace(strip_spl_chars (lv_first_name),'/','N'));
819: pay_payroll_xml_extract_pkg.load_xml_data('D','LAST_NAME_REPORTING',
820: replace(strip_spl_chars (lv_last_name),'/','N'));
821: pay_payroll_xml_extract_pkg.load_xml_data('D','MIDDLE_NAMES_REPORTING',
822: replace(strip_spl_chars (lv_middle_names),'/','N'));
823: pay_payroll_xml_extract_pkg.load_xml_data('D','ORDER_NAME_REPORTING',

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

817: pay_payroll_xml_extract_pkg.load_xml_data('D','FIRST_NAME_REPORTING',
818: replace(strip_spl_chars (lv_first_name),'/','N'));
819: pay_payroll_xml_extract_pkg.load_xml_data('D','LAST_NAME_REPORTING',
820: replace(strip_spl_chars (lv_last_name),'/','N'));
821: pay_payroll_xml_extract_pkg.load_xml_data('D','MIDDLE_NAMES_REPORTING',
822: replace(strip_spl_chars (lv_middle_names),'/','N'));
823: pay_payroll_xml_extract_pkg.load_xml_data('D','ORDER_NAME_REPORTING',
824: replace(strip_spl_chars (lv_order_name),'/','N'));
825: pay_payroll_xml_extract_pkg.load_xml_data('D','FULL_NAME_REPORTING',

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

819: pay_payroll_xml_extract_pkg.load_xml_data('D','LAST_NAME_REPORTING',
820: replace(strip_spl_chars (lv_last_name),'/','N'));
821: pay_payroll_xml_extract_pkg.load_xml_data('D','MIDDLE_NAMES_REPORTING',
822: replace(strip_spl_chars (lv_middle_names),'/','N'));
823: pay_payroll_xml_extract_pkg.load_xml_data('D','ORDER_NAME_REPORTING',
824: replace(strip_spl_chars (lv_order_name),'/','N'));
825: pay_payroll_xml_extract_pkg.load_xml_data('D','FULL_NAME_REPORTING',
826: replace(strip_spl_chars (lv_full_name),'/','N'));
827: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYROLL_NAME_REPORTING',

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

821: pay_payroll_xml_extract_pkg.load_xml_data('D','MIDDLE_NAMES_REPORTING',
822: replace(strip_spl_chars (lv_middle_names),'/','N'));
823: pay_payroll_xml_extract_pkg.load_xml_data('D','ORDER_NAME_REPORTING',
824: replace(strip_spl_chars (lv_order_name),'/','N'));
825: pay_payroll_xml_extract_pkg.load_xml_data('D','FULL_NAME_REPORTING',
826: replace(strip_spl_chars (lv_full_name),'/','N'));
827: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYROLL_NAME_REPORTING',
828: replace(strip_spl_chars (lv_payroll_name),'/','N'));
829: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE_REPORTING',

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

823: pay_payroll_xml_extract_pkg.load_xml_data('D','ORDER_NAME_REPORTING',
824: replace(strip_spl_chars (lv_order_name),'/','N'));
825: pay_payroll_xml_extract_pkg.load_xml_data('D','FULL_NAME_REPORTING',
826: replace(strip_spl_chars (lv_full_name),'/','N'));
827: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYROLL_NAME_REPORTING',
828: replace(strip_spl_chars (lv_payroll_name),'/','N'));
829: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE_REPORTING',
830: lv_account_type);
831: END IF;

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

825: pay_payroll_xml_extract_pkg.load_xml_data('D','FULL_NAME_REPORTING',
826: replace(strip_spl_chars (lv_full_name),'/','N'));
827: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYROLL_NAME_REPORTING',
828: replace(strip_spl_chars (lv_payroll_name),'/','N'));
829: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE_REPORTING',
830: lv_account_type);
831: END IF;
832:
833: /* Custom XML for SUA Interface Extract and Social Security Affiliation