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_US_NACHA_TAPE dependencies on FND_NUMBER

Line 368: and fnd_number.number_to_canonical(ppp.value) = prrv_pay.result_value

364: and ppa.date_earned between peev_pay.effective_start_date
365: and peev_pay.effective_end_date
366: and piv_pay.input_value_id = prrv_pay.input_value_id
367: and upper(piv_pay.name) = 'PAY VALUE'
368: and fnd_number.number_to_canonical(ppp.value) = prrv_pay.result_value
369: and peef.element_entry_id = peev.element_entry_id
370: and peef.element_entry_id = peev_pay.element_entry_id
371: and paa.assignment_Action_id = prr_att.assignment_Action_id
372: and prr_att.run_result_id = prrv_att.run_result_id

Line 432: and fnd_number.canonical_to_number(pet.element_information5) = pet_calc.element_type_id

428: and pet.classification_id = pec.classification_id
429: and pec.classification_name = 'Involuntary Deductions'
430: and pec.legislation_code = 'US'
431: and pec.business_group_id IS NULL
432: and fnd_number.canonical_to_number(pet.element_information5) = pet_calc.element_type_id
433: and pet_calc.element_name like pet.element_name || '%Calculator'
434: and pet_calc.element_type_id = piv_pay.element_type_id
435: and NVL(ppa.date_earned, ppa.effective_date) between piv_pay.effective_start_date and piv_pay.effective_end_date
436: and piv_pay.input_value_id = prrv_pay.input_value_id

Line 438: and fnd_number.number_to_canonical(ppp.value) = prrv_pay.result_value

434: and pet_calc.element_type_id = piv_pay.element_type_id
435: and NVL(ppa.date_earned, ppa.effective_date) between piv_pay.effective_start_date and piv_pay.effective_end_date
436: and piv_pay.input_value_id = prrv_pay.input_value_id
437: and upper(piv_pay.name) = 'PAY VALUE'
438: and fnd_number.number_to_canonical(ppp.value) = prrv_pay.result_value
439: and prr_pay.run_result_id = prrv_pay.run_result_id
440: and prr_pay.assignment_action_id = paa.assignment_action_id
441: and prr_pay.element_type_id = pet_calc.element_type_id
442: order by prr_att.run_result_id;

Line 638: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3));

634: BEGIN
635: hr_utility.set_location('pay_us_nacha_tape.get_effective_date',20);
636: IF pay_mag_tape.internal_prm_names(3) = p_param_name
637: THEN
638: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3));
639: ELSIF pay_mag_tape.internal_prm_names(4) = p_param_name
640: THEN
641: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(4));
642: ELSIF pay_mag_tape.internal_prm_names(5) = p_param_name

Line 641: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(4));

637: THEN
638: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3));
639: ELSIF pay_mag_tape.internal_prm_names(4) = p_param_name
640: THEN
641: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(4));
642: ELSIF pay_mag_tape.internal_prm_names(5) = p_param_name
643: THEN
644: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(5));
645: ELSIF pay_mag_tape.internal_prm_names(6) = p_param_name

Line 644: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(5));

640: THEN
641: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(4));
642: ELSIF pay_mag_tape.internal_prm_names(5) = p_param_name
643: THEN
644: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(5));
645: ELSIF pay_mag_tape.internal_prm_names(6) = p_param_name
646: THEN
647: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(6));
648: ELSIF pay_mag_tape.internal_prm_names(7) = p_param_name

Line 647: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(6));

643: THEN
644: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(5));
645: ELSIF pay_mag_tape.internal_prm_names(6) = p_param_name
646: THEN
647: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(6));
648: ELSIF pay_mag_tape.internal_prm_names(7) = p_param_name
649: THEN
650: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(7));
651: ELSIF pay_mag_tape.internal_prm_names(8) = p_param_name

Line 650: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(7));

646: THEN
647: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(6));
648: ELSIF pay_mag_tape.internal_prm_names(7) = p_param_name
649: THEN
650: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(7));
651: ELSIF pay_mag_tape.internal_prm_names(8) = p_param_name
652: THEN
653: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(8));
654: END IF;

Line 653: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(8));

649: THEN
650: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(7));
651: ELSIF pay_mag_tape.internal_prm_names(8) = p_param_name
652: THEN
653: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(8));
654: END IF;
655: RETURN param_value;
656: END get_transfer_param;
657: --

Line 833: pay_mag_tape.internal_prm_values(7) := fnd_number.number_to_canonical(v_amount);

829: -- 4 - TRANSFER_ENTRY_COUNT
830: -- 5 - TRANSFER_ENTRY_HASH
831: -- 6 - TRANSFER_CREDIT_AMOUNT
832: pay_mag_tape.internal_prm_names(7) := 'TRANSFER_PAY_VALUE';
833: pay_mag_tape.internal_prm_values(7) := fnd_number.number_to_canonical(v_amount);
834:
835: pay_mag_tape.internal_prm_names(8) := 'TRANSFER_PREPAYMENT_ID';
836: pay_mag_tape.internal_prm_values(8) := TO_CHAR(v_prepayment_id);
837:

Line 908: fnd_number.canonical_to_number(get_transfer_param('TRANSFER_PAY_VALUE')),

904:
905: g_addenda_write := 'N';
906:
907: get_third_party_details(
908: fnd_number.canonical_to_number(get_transfer_param('TRANSFER_PAY_VALUE')),
909: fnd_number.canonical_to_number(get_transfer_param('TRANSFER_PREPAYMENT_ID')),
910: v_payment_date,
911: v_attach_number,
912: v_fips_code,

Line 909: fnd_number.canonical_to_number(get_transfer_param('TRANSFER_PREPAYMENT_ID')),

905: g_addenda_write := 'N';
906:
907: get_third_party_details(
908: fnd_number.canonical_to_number(get_transfer_param('TRANSFER_PAY_VALUE')),
909: fnd_number.canonical_to_number(get_transfer_param('TRANSFER_PREPAYMENT_ID')),
910: v_payment_date,
911: v_attach_number,
912: v_fips_code,
913: v_med_ind);

Line 1148: pay_mag_tape.internal_prm_values(7) := fnd_number.number_to_canonical(g_amount);

1144: pay_mag_tape.internal_prm_values(5) := TO_CHAR(g_count + g_addenda_count);
1145: pay_mag_tape.internal_prm_names(6) := 'FILE_ENTRY_HASH';
1146: pay_mag_tape.internal_prm_values(6) := TO_CHAR(g_hash);
1147: pay_mag_tape.internal_prm_names(7) := 'FILE_CREDIT_AMOUNT';
1148: pay_mag_tape.internal_prm_values(7) := fnd_number.number_to_canonical(g_amount);
1149: pay_mag_tape.internal_prm_names(8) := 'TRANSFER_PAD_COUNT';
1150: pay_mag_tape.internal_prm_values(8) := TO_CHAR(g_pad_count);
1151: --
1152: hr_utility.set_location('run_formula.File_Control',11);

Line 1226: g_payroll_action_id := fnd_number.canonical_to_number(

1222: IF NOT csr_nacha_batch%ISOPEN and g_business_group_id is NULL THEN
1223: /* main */
1224:
1225: hr_utility.set_location('run_formula.Init',5);
1226: g_payroll_action_id := fnd_number.canonical_to_number(
1227: pay_mag_tape.internal_prm_values(3));
1228:
1229: /* Select all the relevent information using payroll action id */
1230: select ppa.business_group_id,