APPS.PAY_GB_RTI_EAS dependencies on FND_NUMBER

Line 2147: fnd_number.number_to_canonical(pact.request_id) request_id,

2143: l_proc CONSTANT VARCHAR2(35):= g_package||'range_cursor';
2144: /* EAS 2013 changes */
2145: cursor csr_payroll_details(pactid NUMBER) is
2146: select
2147: fnd_number.number_to_canonical(pact.request_id) request_id,
2148: to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'START=') + 6,10),'YYYY-MM-DD') effective_date,
2149: substr(pay_gb_eoy_archive.get_parameter(pact.legislative_parameters,'NO_OF_PARTS'),1,2) no_of_parts,
2150: substr(pay_gb_eoy_archive.get_parameter(pact.legislative_parameters,'PERMIT'),1,12) unique_part_id,
2151: report_type,

Line 2865: fnd_number.number_to_canonical(pact.request_id) request_id,

2861: cursor csr_payroll_details(pactid NUMBER) is
2862: select
2863: nvl(UPPER(hoi.org_information11),' ') sender_id,
2864: decode(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'TEST=') + 5,1) ,'N',' ','Y','1') test_indicator,
2865: fnd_number.number_to_canonical(pact.request_id) request_id,
2866: to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'START=') + 6,10),'YYYY-MM-DD') effective_date,
2867: nvl(upper(substr(ltrim(hoi.org_information3),1,35)),' ') employer_name,
2868: nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
2869: lpad(nvl(substr(hoi.org_information1,1,3),' '),3,0) tax_office_no,

Line 3343: fnd_number.number_to_canonical(pact.request_id) request_id,

3339: cursor csr_payroll_details(pactid NUMBER) is
3340: select
3341: nvl(UPPER(hoi.org_information11),' ') sender_id,
3342: decode(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'TEST=') + 5,1) ,'N',' ','Y','1') test_indicator,
3343: fnd_number.number_to_canonical(pact.request_id) request_id,
3344: nvl(upper(substr(ltrim(hoi.org_information3),1,35)),' ') employer_name,
3345: nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
3346: substr(pay_gb_eoy_archive.get_parameter(pact.legislative_parameters,'NO_OF_PARTS'),1,2) no_of_parts,
3347: substr(pay_gb_eoy_archive.get_parameter(pact.legislative_parameters,'PERMIT'),1,12) unique_part_id,

Line 3394: fnd_number.number_to_canonical(request_id) control_id,

3390: l_unique_part_id VARCHAR2(12);
3391:
3392: cursor csr_leg_param is
3393: select legislative_parameters para,
3394: fnd_number.number_to_canonical(request_id) control_id,
3395: report_type,
3396: business_group_id
3397: from pay_payroll_actions pact
3398: where payroll_action_id = pactid;