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

Line 22: pay_payroll_xml_extract_pkg.

18: sodhingr 20-Jul-2005 115.0 Initial Version
19: sodhingr 22-Aug-2005 115.1 changed the PL/sql table name
20: from g_payslip_xml to g_xml_table
21: vmehta 05-Oct-2005 115.3 Delete the parameter table
22: pay_payroll_xml_extract_pkg.
23: g_custom_params before setting.
24: mmukherj 21-Oct-2005 115.4 Created another TAG in the
25: employee details level which
26: prints the deposit amount

Line 260: /* IF pay_payroll_xml_extract_pkg.g_leg_code IS NULL THEN

256: IF g_person_flex.count <> 0 THEN
257: g_person_flex.delete;
258: END IF;
259:
260: /* IF pay_payroll_xml_extract_pkg.g_leg_code IS NULL THEN
261: OPEN get_leg_code(ln_assignment_action_id);
262: FETCH get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;
263: CLOSE get_leg_code;
264: END IF;

Line 262: FETCH get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;

258: END IF;
259:
260: /* IF pay_payroll_xml_extract_pkg.g_leg_code IS NULL THEN
261: OPEN get_leg_code(ln_assignment_action_id);
262: FETCH get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;
263: CLOSE get_leg_code;
264: END IF;
265: */
266:

Line 268: IF pay_payroll_xml_extract_pkg.g_leg_code IS NULL THEN

264: END IF;
265: */
266:
267: /* Get Personal Bank Details */
268: IF pay_payroll_xml_extract_pkg.g_leg_code IS NULL THEN
269: OPEN c_get_leg_code(ln_business_group_id);
270: FETCH c_get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;
271: CLOSE c_get_leg_code;
272: END IF;

Line 270: FETCH c_get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;

266:
267: /* Get Personal Bank Details */
268: IF pay_payroll_xml_extract_pkg.g_leg_code IS NULL THEN
269: OPEN c_get_leg_code(ln_business_group_id);
270: FETCH c_get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;
271: CLOSE c_get_leg_code;
272: END IF;
273:
274: OPEN get_person_bank_details(ln_per_pay_method,ld_effective_date);

Line 309: pay_payroll_xml_extract_pkg.load_xml('CS','DEPOSIT_DETAILS','');

305:
306: CLOSE get_payroll_details;
307:
308: /* Build XML */
309: pay_payroll_xml_extract_pkg.load_xml('CS','DEPOSIT_DETAILS','');
310:
311: FOR cntr IN 1..30 LOOP
312: IF g_person_flex(cntr) IS NOT NULL THEN
313: pay_payroll_xml_extract_pkg.load_xml('D','Segment'||cntr,g_person_flex(cntr));

Line 313: pay_payroll_xml_extract_pkg.load_xml('D','Segment'||cntr,g_person_flex(cntr));

309: pay_payroll_xml_extract_pkg.load_xml('CS','DEPOSIT_DETAILS','');
310:
311: FOR cntr IN 1..30 LOOP
312: IF g_person_flex(cntr) IS NOT NULL THEN
313: pay_payroll_xml_extract_pkg.load_xml('D','Segment'||cntr,g_person_flex(cntr));
314: END IF;
315: END LOOP;
316:
317:

Line 318: pay_payroll_xml_extract_pkg.load_xml('D','PAYROLL_START_DATE',

314: END IF;
315: END LOOP;
316:
317:
318: pay_payroll_xml_extract_pkg.load_xml('D','PAYROLL_START_DATE',
319: fnd_date.date_to_canonical(ld_payroll_start_date));
320:
321: pay_payroll_xml_extract_pkg.load_xml('D','PAYROLL_END_DATE',
322: fnd_date.date_to_canonical(ld_payroll_end_date));

Line 321: pay_payroll_xml_extract_pkg.load_xml('D','PAYROLL_END_DATE',

317:
318: pay_payroll_xml_extract_pkg.load_xml('D','PAYROLL_START_DATE',
319: fnd_date.date_to_canonical(ld_payroll_start_date));
320:
321: pay_payroll_xml_extract_pkg.load_xml('D','PAYROLL_END_DATE',
322: fnd_date.date_to_canonical(ld_payroll_end_date));
323:
324: pay_payroll_xml_extract_pkg.load_xml('D','PAYROLL_NAME',lv_payroll_name);
325:

Line 324: pay_payroll_xml_extract_pkg.load_xml('D','PAYROLL_NAME',lv_payroll_name);

320:
321: pay_payroll_xml_extract_pkg.load_xml('D','PAYROLL_END_DATE',
322: fnd_date.date_to_canonical(ld_payroll_end_date));
323:
324: pay_payroll_xml_extract_pkg.load_xml('D','PAYROLL_NAME',lv_payroll_name);
325:
326: pay_payroll_xml_extract_pkg.load_xml('D','EMPLOYEE_NUMBER',
327: lv_employee_number);
328:

Line 326: pay_payroll_xml_extract_pkg.load_xml('D','EMPLOYEE_NUMBER',

322: fnd_date.date_to_canonical(ld_payroll_end_date));
323:
324: pay_payroll_xml_extract_pkg.load_xml('D','PAYROLL_NAME',lv_payroll_name);
325:
326: pay_payroll_xml_extract_pkg.load_xml('D','EMPLOYEE_NUMBER',
327: lv_employee_number);
328:
329: pay_payroll_xml_extract_pkg.load_xml('D','FIRST_NAME',lv_first_name);
330:

Line 329: pay_payroll_xml_extract_pkg.load_xml('D','FIRST_NAME',lv_first_name);

325:
326: pay_payroll_xml_extract_pkg.load_xml('D','EMPLOYEE_NUMBER',
327: lv_employee_number);
328:
329: pay_payroll_xml_extract_pkg.load_xml('D','FIRST_NAME',lv_first_name);
330:
331: pay_payroll_xml_extract_pkg.load_xml('D','LAST_NAME',lv_last_name);
332:
333: pay_payroll_xml_extract_pkg.load_xml('D','MIDDLE_NAMES',lv_middle_names);

Line 331: pay_payroll_xml_extract_pkg.load_xml('D','LAST_NAME',lv_last_name);

327: lv_employee_number);
328:
329: pay_payroll_xml_extract_pkg.load_xml('D','FIRST_NAME',lv_first_name);
330:
331: pay_payroll_xml_extract_pkg.load_xml('D','LAST_NAME',lv_last_name);
332:
333: pay_payroll_xml_extract_pkg.load_xml('D','MIDDLE_NAMES',lv_middle_names);
334:
335: pay_payroll_xml_extract_pkg.load_xml('D','FULL_NAME',lv_full_name);

Line 333: pay_payroll_xml_extract_pkg.load_xml('D','MIDDLE_NAMES',lv_middle_names);

329: pay_payroll_xml_extract_pkg.load_xml('D','FIRST_NAME',lv_first_name);
330:
331: pay_payroll_xml_extract_pkg.load_xml('D','LAST_NAME',lv_last_name);
332:
333: pay_payroll_xml_extract_pkg.load_xml('D','MIDDLE_NAMES',lv_middle_names);
334:
335: pay_payroll_xml_extract_pkg.load_xml('D','FULL_NAME',lv_full_name);
336:
337: pay_payroll_xml_extract_pkg.load_xml('D','CURRENCY',g_currency_code);

Line 335: pay_payroll_xml_extract_pkg.load_xml('D','FULL_NAME',lv_full_name);

331: pay_payroll_xml_extract_pkg.load_xml('D','LAST_NAME',lv_last_name);
332:
333: pay_payroll_xml_extract_pkg.load_xml('D','MIDDLE_NAMES',lv_middle_names);
334:
335: pay_payroll_xml_extract_pkg.load_xml('D','FULL_NAME',lv_full_name);
336:
337: pay_payroll_xml_extract_pkg.load_xml('D','CURRENCY',g_currency_code);
338:
339: pay_payroll_xml_extract_pkg.load_xml('D','DEPOSIT_AMOUNT',

Line 337: pay_payroll_xml_extract_pkg.load_xml('D','CURRENCY',g_currency_code);

333: pay_payroll_xml_extract_pkg.load_xml('D','MIDDLE_NAMES',lv_middle_names);
334:
335: pay_payroll_xml_extract_pkg.load_xml('D','FULL_NAME',lv_full_name);
336:
337: pay_payroll_xml_extract_pkg.load_xml('D','CURRENCY',g_currency_code);
338:
339: pay_payroll_xml_extract_pkg.load_xml('D','DEPOSIT_AMOUNT',
340: lv_deposit_amount);
341:

Line 339: pay_payroll_xml_extract_pkg.load_xml('D','DEPOSIT_AMOUNT',

335: pay_payroll_xml_extract_pkg.load_xml('D','FULL_NAME',lv_full_name);
336:
337: pay_payroll_xml_extract_pkg.load_xml('D','CURRENCY',g_currency_code);
338:
339: pay_payroll_xml_extract_pkg.load_xml('D','DEPOSIT_AMOUNT',
340: lv_deposit_amount);
341:
342:
343: pay_payroll_xml_extract_pkg.g_custom_params.DELETE;

Line 343: pay_payroll_xml_extract_pkg.g_custom_params.DELETE;

339: pay_payroll_xml_extract_pkg.load_xml('D','DEPOSIT_AMOUNT',
340: lv_deposit_amount);
341:
342:
343: pay_payroll_xml_extract_pkg.g_custom_params.DELETE;
344: ln_param_count := pay_payroll_xml_extract_pkg.g_custom_params.COUNT;
345:
346: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_name
347: := 'p_xml_level';

Line 344: ln_param_count := pay_payroll_xml_extract_pkg.g_custom_params.COUNT;

340: lv_deposit_amount);
341:
342:
343: pay_payroll_xml_extract_pkg.g_custom_params.DELETE;
344: ln_param_count := pay_payroll_xml_extract_pkg.g_custom_params.COUNT;
345:
346: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_name
347: := 'p_xml_level';
348:

Line 346: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_name

342:
343: pay_payroll_xml_extract_pkg.g_custom_params.DELETE;
344: ln_param_count := pay_payroll_xml_extract_pkg.g_custom_params.COUNT;
345:
346: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_name
347: := 'p_xml_level';
348:
349: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_value
350: := 'EE';

Line 349: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_value

345:
346: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_name
347: := 'p_xml_level';
348:
349: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_value
350: := 'EE';
351:
352: /*Employee Information -Legislation Specific*/
353: EXECUTE IMMEDIATE 'BEGIN PAY_'||pay_payroll_xml_extract_pkg.g_leg_code||

Line 353: EXECUTE IMMEDIATE 'BEGIN PAY_'||pay_payroll_xml_extract_pkg.g_leg_code||

349: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_value
350: := 'EE';
351:
352: /*Employee Information -Legislation Specific*/
353: EXECUTE IMMEDIATE 'BEGIN PAY_'||pay_payroll_xml_extract_pkg.g_leg_code||
354: '_RULES.add_custom_xml(:1,:2,:3); END;'
355: USING IN ln_assignment_action_id,'','DEPOSIT_XML';
356:
357: pay_payroll_xml_extract_pkg.load_xml('CE','DEPOSIT_DETAILS','');

Line 357: pay_payroll_xml_extract_pkg.load_xml('CE','DEPOSIT_DETAILS','');

353: EXECUTE IMMEDIATE 'BEGIN PAY_'||pay_payroll_xml_extract_pkg.g_leg_code||
354: '_RULES.add_custom_xml(:1,:2,:3); END;'
355: USING IN ln_assignment_action_id,'','DEPOSIT_XML';
356:
357: pay_payroll_xml_extract_pkg.load_xml('CE','DEPOSIT_DETAILS','');
358:
359: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN
360: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
361: FOR cntr IN

Line 359: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN

355: USING IN ln_assignment_action_id,'','DEPOSIT_XML';
356:
357: pay_payroll_xml_extract_pkg.load_xml('CE','DEPOSIT_DETAILS','');
358:
359: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN
360: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
361: FOR cntr IN
362: pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP
363: lr_xml := utl_raw.cast_to_raw(

Line 362: pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP

358:
359: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN
360: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
361: FOR cntr IN
362: pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP
363: lr_xml := utl_raw.cast_to_raw(
364: pay_payroll_xml_extract_pkg.g_xml_table(cntr));
365: ln_amt := utl_raw.length(lr_xml);
366:

Line 364: pay_payroll_xml_extract_pkg.g_xml_table(cntr));

360: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
361: FOR cntr IN
362: pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP
363: lr_xml := utl_raw.cast_to_raw(
364: pay_payroll_xml_extract_pkg.g_xml_table(cntr));
365: ln_amt := utl_raw.length(lr_xml);
366:
367: dbms_lob.writeAppend(l_xml,
368: ln_amt,

Line 371: hr_utility_trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));

367: dbms_lob.writeAppend(l_xml,
368: ln_amt,
369: lr_xml);
370:
371: hr_utility_trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));
372: END LOOP;
373: pay_payroll_xml_extract_pkg.g_xml_table.delete();
374:
375: END IF;

Line 373: pay_payroll_xml_extract_pkg.g_xml_table.delete();

369: lr_xml);
370:
371: hr_utility_trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));
372: END LOOP;
373: pay_payroll_xml_extract_pkg.g_xml_table.delete();
374:
375: END IF;
376:
377: write_to_magtape_lob (l_xml);

Line 493: pay_payroll_xml_extract_pkg.load_xml('CS','DEPOSIT_HEADER','');

489: hr_utility_trace ('ln_payroll_action_id '||ln_payroll_action_id);
490: hr_utility_trace ('ln_business_group_id '||ln_business_group_id);
491:
492:
493: pay_payroll_xml_extract_pkg.load_xml('CS','DEPOSIT_HEADER','');
494: /*Clear the details of previous assignmentId */
495: IF g_org_flex.count <> 0 THEN
496: g_org_flex.delete;
497: END IF;

Line 503: IF pay_payroll_xml_extract_pkg.g_leg_code IS NULL THEN

499: IF g_pmeth_flex.count <> 0 THEN
500: g_pmeth_flex.delete;
501: END IF;
502:
503: IF pay_payroll_xml_extract_pkg.g_leg_code IS NULL THEN
504: OPEN c_get_leg_code(ln_business_group_id);
505: FETCH c_get_leg_code INTO lv_leg_code;
506: hr_utility_trace ('Legislation Code '||lv_leg_code);
507:

Line 508: pay_payroll_xml_extract_pkg.g_leg_code :=lv_leg_code;

504: OPEN c_get_leg_code(ln_business_group_id);
505: FETCH c_get_leg_code INTO lv_leg_code;
506: hr_utility_trace ('Legislation Code '||lv_leg_code);
507:
508: pay_payroll_xml_extract_pkg.g_leg_code :=lv_leg_code;
509: CLOSE c_get_leg_code;
510: END IF;
511:
512: hr_utility_trace ('Legislation Code '||pay_payroll_xml_extract_pkg.g_leg_code);

Line 512: hr_utility_trace ('Legislation Code '||pay_payroll_xml_extract_pkg.g_leg_code);

508: pay_payroll_xml_extract_pkg.g_leg_code :=lv_leg_code;
509: CLOSE c_get_leg_code;
510: END IF;
511:
512: hr_utility_trace ('Legislation Code '||pay_payroll_xml_extract_pkg.g_leg_code);
513:
514: OPEN get_org_bank_details(ln_org_pay_method,ld_effective_date);
515: FETCH get_org_bank_details INTO
516: g_org_flex(1),g_org_flex(2),g_org_flex(3),

Line 539: pay_payroll_xml_extract_pkg.load_xml('D','Segment'||cntr,g_org_flex(cntr));

535: CLOSE get_org_bank_details;
536:
537: FOR cntr IN 1..30 LOOP
538: IF g_org_flex(cntr) IS NOT NULL THEN
539: pay_payroll_xml_extract_pkg.load_xml('D','Segment'||cntr,g_org_flex(cntr));
540: END IF;
541: END LOOP;
542: IF (lv_pmeth_cat IS NOT NULL)
543: THEN

Line 546: pay_payroll_xml_extract_pkg.load_xml('D', 'Paymeth Developer DF',

542: IF (lv_pmeth_cat IS NOT NULL)
543: THEN
544: FOR cntr IN 1..20 LOOP
545: IF g_pmeth_flex(cntr) IS NOT NULL THEN
546: pay_payroll_xml_extract_pkg.load_xml('D', 'Paymeth Developer DF',
547: lv_pmeth_cat, 'PMETH_INFORMATION'||cntr,g_pmeth_flex(cntr));
548: END IF;
549: END LOOP;
550: END IF;

Line 551: pay_payroll_xml_extract_pkg.load_xml('D','DEPOSIT_DATE',lv_dd_date);

547: lv_pmeth_cat, 'PMETH_INFORMATION'||cntr,g_pmeth_flex(cntr));
548: END IF;
549: END LOOP;
550: END IF;
551: pay_payroll_xml_extract_pkg.load_xml('D','DEPOSIT_DATE',lv_dd_date);
552: pay_payroll_xml_extract_pkg.load_xml('D','CURRENCY',g_currency_code);
553:
554: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN
555: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);

Line 552: pay_payroll_xml_extract_pkg.load_xml('D','CURRENCY',g_currency_code);

548: END IF;
549: END LOOP;
550: END IF;
551: pay_payroll_xml_extract_pkg.load_xml('D','DEPOSIT_DATE',lv_dd_date);
552: pay_payroll_xml_extract_pkg.load_xml('D','CURRENCY',g_currency_code);
553:
554: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN
555: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
556: FOR cntr IN

Line 554: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN

550: END IF;
551: pay_payroll_xml_extract_pkg.load_xml('D','DEPOSIT_DATE',lv_dd_date);
552: pay_payroll_xml_extract_pkg.load_xml('D','CURRENCY',g_currency_code);
553:
554: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN
555: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
556: FOR cntr IN
557: pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP
558: lr_xml := utl_raw.cast_to_raw(

Line 557: pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP

553:
554: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN
555: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
556: FOR cntr IN
557: pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP
558: lr_xml := utl_raw.cast_to_raw(
559: pay_payroll_xml_extract_pkg.g_xml_table(cntr));
560: ln_amt := utl_raw.length(lr_xml);
561:

Line 559: pay_payroll_xml_extract_pkg.g_xml_table(cntr));

555: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
556: FOR cntr IN
557: pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP
558: lr_xml := utl_raw.cast_to_raw(
559: pay_payroll_xml_extract_pkg.g_xml_table(cntr));
560: ln_amt := utl_raw.length(lr_xml);
561:
562: dbms_lob.writeAppend(l_xml,
563: ln_amt,

Line 566: hr_utility_trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));

562: dbms_lob.writeAppend(l_xml,
563: ln_amt,
564: lr_xml);
565:
566: hr_utility_trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));
567: END LOOP;
568: pay_payroll_xml_extract_pkg.g_xml_table.delete();
569:
570: END IF;

Line 568: pay_payroll_xml_extract_pkg.g_xml_table.delete();

564: lr_xml);
565:
566: hr_utility_trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));
567: END LOOP;
568: pay_payroll_xml_extract_pkg.g_xml_table.delete();
569:
570: END IF;
571: write_to_magtape_lob (l_xml);
572: dbms_lob.freeTemporary(l_xml);

Line 574: pay_payroll_xml_extract_pkg.g_custom_params.DELETE;

570: END IF;
571: write_to_magtape_lob (l_xml);
572: dbms_lob.freeTemporary(l_xml);
573:
574: pay_payroll_xml_extract_pkg.g_custom_params.DELETE;
575: ln_param_count := pay_payroll_xml_extract_pkg.g_custom_params.COUNT;
576: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_name := 'p_xml_level';
577: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_value := 'ER';
578:

Line 575: ln_param_count := pay_payroll_xml_extract_pkg.g_custom_params.COUNT;

571: write_to_magtape_lob (l_xml);
572: dbms_lob.freeTemporary(l_xml);
573:
574: pay_payroll_xml_extract_pkg.g_custom_params.DELETE;
575: ln_param_count := pay_payroll_xml_extract_pkg.g_custom_params.COUNT;
576: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_name := 'p_xml_level';
577: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_value := 'ER';
578:
579: /*Employee Information -Legislation Specific*/

Line 576: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_name := 'p_xml_level';

572: dbms_lob.freeTemporary(l_xml);
573:
574: pay_payroll_xml_extract_pkg.g_custom_params.DELETE;
575: ln_param_count := pay_payroll_xml_extract_pkg.g_custom_params.COUNT;
576: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_name := 'p_xml_level';
577: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_value := 'ER';
578:
579: /*Employee Information -Legislation Specific*/
580: EXECUTE IMMEDIATE 'BEGIN PAY_'||pay_payroll_xml_extract_pkg.g_leg_code||

Line 577: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_value := 'ER';

573:
574: pay_payroll_xml_extract_pkg.g_custom_params.DELETE;
575: ln_param_count := pay_payroll_xml_extract_pkg.g_custom_params.COUNT;
576: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_name := 'p_xml_level';
577: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_value := 'ER';
578:
579: /*Employee Information -Legislation Specific*/
580: EXECUTE IMMEDIATE 'BEGIN PAY_'||pay_payroll_xml_extract_pkg.g_leg_code||
581: '_RULES.add_custom_xml(:1,:2,:3); END;'

Line 580: EXECUTE IMMEDIATE 'BEGIN PAY_'||pay_payroll_xml_extract_pkg.g_leg_code||

576: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_name := 'p_xml_level';
577: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_value := 'ER';
578:
579: /*Employee Information -Legislation Specific*/
580: EXECUTE IMMEDIATE 'BEGIN PAY_'||pay_payroll_xml_extract_pkg.g_leg_code||
581: '_RULES.add_custom_xml(:1,:2,:3); END;'
582: USING IN ln_payroll_action_id,'','DEPOSIT_XML';
583:
584: