DBA Data[Home] [Help]

APPS.PAY_IP_RULES dependencies on PAY_PAYROLL_XML_EXTRACT_PKG

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

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

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

304: lv_userdefined_proc_ee varchar2(150);
305:
306: FUNCTION get_param_val (p_param_name varchar2) return varchar2 is
307: BEGIN
308: FOR cntr in pay_payroll_xml_extract_pkg.g_custom_params.first()..
309: pay_payroll_xml_extract_pkg.g_custom_params.last()
310: LOOP
311: IF pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name
312: = p_param_name

Line 309: pay_payroll_xml_extract_pkg.g_custom_params.last()

305:
306: FUNCTION get_param_val (p_param_name varchar2) return varchar2 is
307: BEGIN
308: FOR cntr in pay_payroll_xml_extract_pkg.g_custom_params.first()..
309: pay_payroll_xml_extract_pkg.g_custom_params.last()
310: LOOP
311: IF pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name
312: = p_param_name
313: THEN

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

307: BEGIN
308: FOR cntr in pay_payroll_xml_extract_pkg.g_custom_params.first()..
309: pay_payroll_xml_extract_pkg.g_custom_params.last()
310: LOOP
311: IF pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name
312: = p_param_name
313: THEN
314: hr_utility_trace('Custom Params : '||
315: pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name);

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

311: IF pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name
312: = p_param_name
313: THEN
314: hr_utility_trace('Custom Params : '||
315: pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name);
316:
317: hr_utility_trace('Custom Params Value : '||
318: pay_payroll_xml_extract_pkg.g_custom_params(cntr).
319: parameter_value);

Line 318: pay_payroll_xml_extract_pkg.g_custom_params(cntr).

314: hr_utility_trace('Custom Params : '||
315: pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name);
316:
317: hr_utility_trace('Custom Params Value : '||
318: pay_payroll_xml_extract_pkg.g_custom_params(cntr).
319: parameter_value);
320:
321: RETURN pay_payroll_xml_extract_pkg.g_custom_params(cntr).
322: parameter_value;

Line 321: RETURN pay_payroll_xml_extract_pkg.g_custom_params(cntr).

317: hr_utility_trace('Custom Params Value : '||
318: pay_payroll_xml_extract_pkg.g_custom_params(cntr).
319: parameter_value);
320:
321: RETURN pay_payroll_xml_extract_pkg.g_custom_params(cntr).
322: parameter_value;
323: END IF;
324:
325: END LOOP;

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

462: hr_utility_trace('lv_full_name '|| lv_full_name);
463: hr_utility_trace('lv_payroll_id '|| lv_payroll_id);
464: hr_utility_trace('lv_payroll_name '|| lv_payroll_name);
465:
466: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME',
467: lv_org_name);
468: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME_REPORTING',
469: replace(strip_spl_chars (lv_org_name),'/','N'));
470: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE1',

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

464: hr_utility_trace('lv_payroll_name '|| lv_payroll_name);
465:
466: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME',
467: lv_org_name);
468: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME_REPORTING',
469: replace(strip_spl_chars (lv_org_name),'/','N'));
470: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE1',
471: lv_address_line1);
472: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE2',

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

466: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME',
467: lv_org_name);
468: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME_REPORTING',
469: replace(strip_spl_chars (lv_org_name),'/','N'));
470: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE1',
471: lv_address_line1);
472: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE2',
473: lv_address_line2);
474: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',

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

468: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME_REPORTING',
469: replace(strip_spl_chars (lv_org_name),'/','N'));
470: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE1',
471: lv_address_line1);
472: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE2',
473: lv_address_line2);
474: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',
475: lv_address_line3);
476: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);

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

470: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE1',
471: lv_address_line1);
472: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE2',
473: lv_address_line2);
474: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',
475: lv_address_line3);
476: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);
477: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);
478: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);

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

472: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE2',
473: lv_address_line2);
474: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',
475: lv_address_line3);
476: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);
477: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);
478: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);
479: pay_payroll_xml_extract_pkg.load_xml_data('D','POSTAL_CODE',
480: lv_postal_code);

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

473: lv_address_line2);
474: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',
475: lv_address_line3);
476: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);
477: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);
478: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);
479: pay_payroll_xml_extract_pkg.load_xml_data('D','POSTAL_CODE',
480: lv_postal_code);
481: pay_payroll_xml_extract_pkg.load_xml_data('D','ORDER_NAME_REPORTING',

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

474: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_LINE3',
475: lv_address_line3);
476: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);
477: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);
478: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);
479: pay_payroll_xml_extract_pkg.load_xml_data('D','POSTAL_CODE',
480: lv_postal_code);
481: pay_payroll_xml_extract_pkg.load_xml_data('D','ORDER_NAME_REPORTING',
482: replace(strip_spl_chars (lv_order_name),'/','N'));

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

475: lv_address_line3);
476: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_town_or_city);
477: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);
478: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);
479: pay_payroll_xml_extract_pkg.load_xml_data('D','POSTAL_CODE',
480: lv_postal_code);
481: pay_payroll_xml_extract_pkg.load_xml_data('D','ORDER_NAME_REPORTING',
482: replace(strip_spl_chars (lv_order_name),'/','N'));
483:

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

477: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_state);
478: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_country);
479: pay_payroll_xml_extract_pkg.load_xml_data('D','POSTAL_CODE',
480: lv_postal_code);
481: pay_payroll_xml_extract_pkg.load_xml_data('D','ORDER_NAME_REPORTING',
482: replace(strip_spl_chars (lv_order_name),'/','N'));
483:
484:
485: IF lv_userdefined_proc_ee IS NOT NULL THEN