DBA Data[Home] [Help]

APPS.PAY_US_NACHA_IAT_TAPE dependencies on FND_DATE

Line 220: pay_mag_tape.internal_cxt_values(3) := fnd_date.date_to_canonical(p_effective_date);

216: pay_mag_tape.internal_cxt_values(1) := '3';
217: pay_mag_tape.internal_cxt_names(2) := 'ORG_PAY_METHOD_ID';
218: pay_mag_tape.internal_cxt_values(2) := g_org_payment_method_id;
219: pay_mag_tape.internal_cxt_names(3) := 'DATE_EARNED';
220: pay_mag_tape.internal_cxt_values(3) := fnd_date.date_to_canonical(p_effective_date);
221: --
222: hr_utility.TRACE('.... Writing File Header Parameters');
223: hr_utility.TRACE('g_file_header ' || g_file_header);
224:

Line 276: pay_mag_tape.internal_cxt_values(3) := fnd_date.date_to_canonical(p_effective_date);

272: pay_mag_tape.internal_cxt_values(1) := '4';
273: pay_mag_tape.internal_cxt_names(2) := 'TAX_UNIT_ID';
274: pay_mag_tape.internal_cxt_values(2) := TO_CHAR(g_legal_company_id);
275: pay_mag_tape.internal_cxt_names(3) := 'DATE_EARNED';
276: pay_mag_tape.internal_cxt_values(3) := fnd_date.date_to_canonical(p_effective_date);
277: pay_mag_tape.internal_cxt_names(4) := 'ORG_PAY_METHOD_ID';
278: pay_mag_tape.internal_cxt_values(4) := g_org_payment_method_id;
279:
280: -- Parameters for NACHA_BATCH_HEADER

Line 335: pay_mag_tape.internal_cxt_values(2) := fnd_date.date_to_canonical(p_effective_date);

331: -- Context Setup for NACHA_ENTRY_DETAIL
332: -- First context value is number of contexts
333: pay_mag_tape.internal_cxt_values(1) := '4';
334: pay_mag_tape.internal_cxt_names(2) := 'DATE_EARNED';
335: pay_mag_tape.internal_cxt_values(2) := fnd_date.date_to_canonical(p_effective_date);
336: pay_mag_tape.internal_cxt_names(3) := 'PER_PAY_METHOD_ID';
337: pay_mag_tape.internal_cxt_values(3) := to_char(g_personal_payment_method_id);
338: pay_mag_tape.internal_cxt_names(4) := 'ORG_PAY_METHOD_ID';
339: pay_mag_tape.internal_cxt_values(4) := g_org_payment_method_id;

Line 446: pay_mag_tape.internal_cxt_values(3) := fnd_date.date_to_canonical(p_effective_date);

442: pay_mag_tape.internal_cxt_values(1) := '3';
443: pay_mag_tape.internal_cxt_names(2) := 'ORG_PAY_METHOD_ID';
444: pay_mag_tape.internal_cxt_values(2) := g_csr_org_pay_meth_id;
445: pay_mag_tape.internal_cxt_names(3) := 'DATE_EARNED';
446: pay_mag_tape.internal_cxt_values(3) := fnd_date.date_to_canonical(p_effective_date);
447:
448: -- Parameter Setup for NACHA_ORG_PAY_ENTRY_DETAIL
449: -- first parameter is number of parameters
450: -- second parameter is formula id

Line 515: pay_mag_tape.internal_cxt_values(2) := fnd_date.date_to_canonical(p_effective_date);

511:
512: pay_mag_tape.internal_cxt_values(1) := '3';
513:
514: pay_mag_tape.internal_cxt_names(2) := 'DATE_EARNED';
515: pay_mag_tape.internal_cxt_values(2) := fnd_date.date_to_canonical(p_effective_date);
516:
517: pay_mag_tape.internal_cxt_names(3) := 'PAYROLL_ID';
518: pay_mag_tape.internal_cxt_values(3) := g_payroll_id;
519:

Line 605: pay_mag_tape.internal_cxt_values(2) := fnd_date.date_to_canonical(p_effective_date);

601:
602: pay_mag_tape.internal_cxt_values(1) := '3';
603:
604: pay_mag_tape.internal_cxt_names(2) := 'DATE_EARNED';
605: pay_mag_tape.internal_cxt_values(2) := fnd_date.date_to_canonical(p_effective_date);
606:
607: pay_mag_tape.internal_cxt_names(3) := 'ORG_PAY_METHOD_ID';
608: pay_mag_tape.internal_cxt_values(3) := g_org_payment_method_id;
609:

Line 636: pay_mag_tape.internal_cxt_values(2) := fnd_date.date_to_canonical(p_effective_date);

632:
633: pay_mag_tape.internal_cxt_values(1) := '4';
634:
635: pay_mag_tape.internal_cxt_names(2) := 'DATE_EARNED';
636: pay_mag_tape.internal_cxt_values(2) := fnd_date.date_to_canonical(p_effective_date);
637:
638: pay_mag_tape.internal_cxt_names(3) := 'PER_PAY_METHOD_ID';
639: pay_mag_tape.internal_cxt_values(3) := to_char(g_personal_payment_method_id);
640:

Line 670: pay_mag_tape.internal_cxt_values(2) := fnd_date.date_to_canonical(p_effective_date);

666:
667: pay_mag_tape.internal_cxt_values(1) := '3';
668:
669: pay_mag_tape.internal_cxt_names(2) := 'DATE_EARNED';
670: pay_mag_tape.internal_cxt_values(2) := fnd_date.date_to_canonical(p_effective_date);
671:
672: pay_mag_tape.internal_cxt_names(3) := 'ORG_PAY_METHOD_ID';
673: pay_mag_tape.internal_cxt_values(3) := g_org_payment_method_id;
674:

Line 706: pay_mag_tape.internal_cxt_values(2) := fnd_date.date_to_canonical(p_effective_date);

702:
703: pay_mag_tape.internal_cxt_values(1) := '3';
704:
705: pay_mag_tape.internal_cxt_names(2) := 'DATE_EARNED';
706: pay_mag_tape.internal_cxt_values(2) := fnd_date.date_to_canonical(p_effective_date);
707:
708: pay_mag_tape.internal_cxt_names(3) := 'ORG_PAY_METHOD_ID';
709: pay_mag_tape.internal_cxt_values(3) := g_org_payment_method_id;
710:

Line 786: pay_mag_tape.internal_cxt_values(3) := fnd_date.date_to_canonical(p_effective_date);

782: pay_mag_tape.internal_cxt_values(1) := '4';
783: pay_mag_tape.internal_cxt_names(2) := 'TAX_UNIT_ID';
784: pay_mag_tape.internal_cxt_values(2) := TO_CHAR(g_legal_company_id);
785: pay_mag_tape.internal_cxt_names(3) := 'DATE_EARNED';
786: pay_mag_tape.internal_cxt_values(3) := fnd_date.date_to_canonical(p_effective_date);
787: pay_mag_tape.internal_cxt_names(4) := 'ORG_PAY_METHOD_ID';
788: pay_mag_tape.internal_cxt_values(4) := g_org_payment_method_id;
789:
790: -- Parameter Setup for NACHA_BATCH_CONTROL

Line 849: pay_mag_tape.internal_cxt_values(3) := fnd_date.date_to_canonical(p_effective_date);

845: pay_mag_tape.internal_cxt_values(1) := '3';
846: pay_mag_tape.internal_cxt_names(2) := 'ORG_PAY_METHOD_ID';
847: pay_mag_tape.internal_cxt_values(2) := g_org_payment_method_id;
848: pay_mag_tape.internal_cxt_names(3) := 'DATE_EARNED';
849: pay_mag_tape.internal_cxt_values(3) := fnd_date.date_to_canonical(p_effective_date);
850:
851: hr_utility.TRACE('.... Writing File Control Parameters');
852:
853: pay_mag_tape.internal_prm_values(1) := '8';