APPS.PAY_FR_DUCS dependencies on FND_NUMBER

Line 93: SELECT fnd_number.canonical_to_number(

89: ,p_french_pay_value out nocopy varchar2
90: ,p_french_contrib_code out nocopy varchar2) IS
91: --
92: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
93: SELECT fnd_number.canonical_to_number(
94: pay_fr_ducs.get_parameter(legislative_parameters, 'COMPANY_ID'))
95: ,pay_fr_ducs.get_parameter(legislative_parameters, 'PERIOD_TYPE')
96: ,effective_date
97: ,business_group_id

Line 215: OPEN c_existing_archive(fnd_number.number_to_canonical(g_company_id));

211: ELSE
212: l_period_code := substr(l_year,3,2)||l_quarter||'0';
213: END IF;
214:
215: OPEN c_existing_archive(fnd_number.number_to_canonical(g_company_id));
216: FETCH c_existing_archive INTO l_payroll_action_id;
217: IF c_existing_archive%found THEN
218: CLOSE c_existing_archive;
219: RAISE duplicate;

Line 707: g_english_base, fnd_number.canonical_to_number(rrv.result_value),

703: , max(decode(iv.name,
704: g_english_contrib_code,rrv.result_value,
705: g_french_contrib_code, rrv.result_value)) contribution_code
706: , nvl(max(decode(iv.name,
707: g_english_base, fnd_number.canonical_to_number(rrv.result_value),
708: g_french_base, fnd_number.canonical_to_number(rrv.result_value))),0) base
709: , nvl(max(decode(iv.name,
710: g_english_rate, fnd_number.canonical_to_number(rrv.result_value),
711: g_french_rate, fnd_number.canonical_to_number(rrv.result_value))),0) rate

Line 708: g_french_base, fnd_number.canonical_to_number(rrv.result_value))),0) base

704: g_english_contrib_code,rrv.result_value,
705: g_french_contrib_code, rrv.result_value)) contribution_code
706: , nvl(max(decode(iv.name,
707: g_english_base, fnd_number.canonical_to_number(rrv.result_value),
708: g_french_base, fnd_number.canonical_to_number(rrv.result_value))),0) base
709: , nvl(max(decode(iv.name,
710: g_english_rate, fnd_number.canonical_to_number(rrv.result_value),
711: g_french_rate, fnd_number.canonical_to_number(rrv.result_value))),0) rate
712: , nvl(max(decode(iv.name,

Line 710: g_english_rate, fnd_number.canonical_to_number(rrv.result_value),

706: , nvl(max(decode(iv.name,
707: g_english_base, fnd_number.canonical_to_number(rrv.result_value),
708: g_french_base, fnd_number.canonical_to_number(rrv.result_value))),0) base
709: , nvl(max(decode(iv.name,
710: g_english_rate, fnd_number.canonical_to_number(rrv.result_value),
711: g_french_rate, fnd_number.canonical_to_number(rrv.result_value))),0) rate
712: , nvl(max(decode(iv.name,
713: g_english_pay_value, decode(ec.classification_name,'Rebates',-1,1) *
714: fnd_number.canonical_to_number(rrv.result_value),

Line 711: g_french_rate, fnd_number.canonical_to_number(rrv.result_value))),0) rate

707: g_english_base, fnd_number.canonical_to_number(rrv.result_value),
708: g_french_base, fnd_number.canonical_to_number(rrv.result_value))),0) base
709: , nvl(max(decode(iv.name,
710: g_english_rate, fnd_number.canonical_to_number(rrv.result_value),
711: g_french_rate, fnd_number.canonical_to_number(rrv.result_value))),0) rate
712: , nvl(max(decode(iv.name,
713: g_english_pay_value, decode(ec.classification_name,'Rebates',-1,1) *
714: fnd_number.canonical_to_number(rrv.result_value),
715: g_french_pay_value, decode(ec.classification_name,'Rebates',-1,1) *

Line 714: fnd_number.canonical_to_number(rrv.result_value),

710: g_english_rate, fnd_number.canonical_to_number(rrv.result_value),
711: g_french_rate, fnd_number.canonical_to_number(rrv.result_value))),0) rate
712: , nvl(max(decode(iv.name,
713: g_english_pay_value, decode(ec.classification_name,'Rebates',-1,1) *
714: fnd_number.canonical_to_number(rrv.result_value),
715: g_french_pay_value, decode(ec.classification_name,'Rebates',-1,1) *
716: fnd_number.canonical_to_number(rrv.result_value))),0) pv
717: FROM pay_action_interlocks ail,
718: pay_run_results rr,

Line 716: fnd_number.canonical_to_number(rrv.result_value))),0) pv

712: , nvl(max(decode(iv.name,
713: g_english_pay_value, decode(ec.classification_name,'Rebates',-1,1) *
714: fnd_number.canonical_to_number(rrv.result_value),
715: g_french_pay_value, decode(ec.classification_name,'Rebates',-1,1) *
716: fnd_number.canonical_to_number(rrv.result_value))),0) pv
717: FROM pay_action_interlocks ail,
718: pay_run_results rr,
719: pay_element_types_f et,
720: pay_element_classifications ec,

Line 862: l_subpage_identifier := fnd_number.number_to_canonical(

858: IF prec.r.contribution_code is not null THEN
859: -- Not first time through loop so archive the previous record
860: IF prec.r.contribution_type in ('URSSAF','ASSEDIC') THEN
861: l_page_type := prec.r.contribution_type;
862: l_subpage_identifier := fnd_number.number_to_canonical(
863: l_establishment_id);
864: ELSIF prec.r.contribution_type IN ('AGIRC','ARRCO') THEN
865: l_page_type := 'PENSION';
866: -- Determine Company Pension Provider ID for Pension contribs

Line 897: , p_action_information5 => fnd_number.number_to_canonical(prec.r.base)

893: , p_action_information1 => l_subpage_identifier
894: , p_action_information2 => l_page_type
895: , p_action_information3 => prec.r.contribution_type
896: , p_action_information4 => prec.r.contribution_code
897: , p_action_information5 => fnd_number.number_to_canonical(prec.r.base)
898: , p_action_information6 => fnd_number.number_to_canonical(prec.r.rate)
899: , p_action_information7 => fnd_number.number_to_canonical(prec.r.pv)
900: , p_action_information8 => prec.group_type);
901:

Line 898: , p_action_information6 => fnd_number.number_to_canonical(prec.r.rate)

894: , p_action_information2 => l_page_type
895: , p_action_information3 => prec.r.contribution_type
896: , p_action_information4 => prec.r.contribution_code
897: , p_action_information5 => fnd_number.number_to_canonical(prec.r.base)
898: , p_action_information6 => fnd_number.number_to_canonical(prec.r.rate)
899: , p_action_information7 => fnd_number.number_to_canonical(prec.r.pv)
900: , p_action_information8 => prec.group_type);
901:
902: END IF;

Line 899: , p_action_information7 => fnd_number.number_to_canonical(prec.r.pv)

895: , p_action_information3 => prec.r.contribution_type
896: , p_action_information4 => prec.r.contribution_code
897: , p_action_information5 => fnd_number.number_to_canonical(prec.r.base)
898: , p_action_information6 => fnd_number.number_to_canonical(prec.r.rate)
899: , p_action_information7 => fnd_number.number_to_canonical(prec.r.pv)
900: , p_action_information8 => prec.group_type);
901:
902: END IF;
903: EXIT WHEN ccontrib%NOTFOUND;

Line 994: fnd_number.number_to_canonical(p_page_identifier);

990: l_total_count number:=0;
991: l_actions_count number:=0;
992: l_sex varchar2(2);
993: l_page_id_chr pay_action_information.action_information1%TYPE:=
994: fnd_number.number_to_canonical(p_page_identifier);
995:
996: CURSOR cur_per IS
997: SELECT distinct paa.person_id
998: FROM pay_action_information pai

Line 1168: , round(sum(fnd_number.canonical_to_number(contrib.action_information5))) base

1164: decode(contrib.action_information8
1165: ,'FULL','1234567890'
1166: ,'PARTIAL','XXXXXXXXXX'))||
1167: substr(contrib.action_information4,4,4) contribution_code
1168: , round(sum(fnd_number.canonical_to_number(contrib.action_information5))) base
1169: , fnd_number.canonical_to_number(contrib.action_information6) rate
1170: , sum(fnd_number.canonical_to_number(contrib.action_information7)) pay_value
1171: , count(distinct assact.assignment_id) number_of_employees
1172: FROM pay_assignment_actions assact

Line 1169: , fnd_number.canonical_to_number(contrib.action_information6) rate

1165: ,'FULL','1234567890'
1166: ,'PARTIAL','XXXXXXXXXX'))||
1167: substr(contrib.action_information4,4,4) contribution_code
1168: , round(sum(fnd_number.canonical_to_number(contrib.action_information5))) base
1169: , fnd_number.canonical_to_number(contrib.action_information6) rate
1170: , sum(fnd_number.canonical_to_number(contrib.action_information7)) pay_value
1171: , count(distinct assact.assignment_id) number_of_employees
1172: FROM pay_assignment_actions assact
1173: , pay_action_information contrib

Line 1170: , sum(fnd_number.canonical_to_number(contrib.action_information7)) pay_value

1166: ,'PARTIAL','XXXXXXXXXX'))||
1167: substr(contrib.action_information4,4,4) contribution_code
1168: , round(sum(fnd_number.canonical_to_number(contrib.action_information5))) base
1169: , fnd_number.canonical_to_number(contrib.action_information6) rate
1170: , sum(fnd_number.canonical_to_number(contrib.action_information7)) pay_value
1171: , count(distinct assact.assignment_id) number_of_employees
1172: FROM pay_assignment_actions assact
1173: , pay_action_information contrib
1174: WHERE

Line 1199: , fnd_number.canonical_to_number(contrib.action_information6)

1195: translate(substr(contrib.action_information4,2,2), '1234567890',
1196: decode(contrib.action_information8 ,'FULL','1234567890'
1197: ,'PARTIAL','XXXXXXXXXX'))||
1198: substr(contrib.action_information4,4,4)
1199: , fnd_number.canonical_to_number(contrib.action_information6)
1200: ORDER BY contrib.action_information1 ,contrib.action_information3;
1201:
1202: CURSOR ccontrib_pension is
1203: SELECT /*+ ORDERED */

Line 1212: , round(sum(fnd_number.canonical_to_number(contrib.action_information5))) base

1208: decode(contrib.action_information8
1209: ,'FULL','1234567890'
1210: ,'PARTIAL','XXXXXXXXXX'))||
1211: substr(contrib.action_information4,4,4) contribution_code
1212: , round(sum(fnd_number.canonical_to_number(contrib.action_information5))) base
1213: , fnd_number.canonical_to_number(contrib.action_information6) rate
1214: , sum(fnd_number.canonical_to_number(contrib.action_information7)) pay_value
1215: , count(distinct assact.assignment_id) number_of_employees
1216: FROM pay_payroll_actions payact

Line 1213: , fnd_number.canonical_to_number(contrib.action_information6) rate

1209: ,'FULL','1234567890'
1210: ,'PARTIAL','XXXXXXXXXX'))||
1211: substr(contrib.action_information4,4,4) contribution_code
1212: , round(sum(fnd_number.canonical_to_number(contrib.action_information5))) base
1213: , fnd_number.canonical_to_number(contrib.action_information6) rate
1214: , sum(fnd_number.canonical_to_number(contrib.action_information7)) pay_value
1215: , count(distinct assact.assignment_id) number_of_employees
1216: FROM pay_payroll_actions payact
1217: , pay_assignment_actions assact

Line 1214: , sum(fnd_number.canonical_to_number(contrib.action_information7)) pay_value

1210: ,'PARTIAL','XXXXXXXXXX'))||
1211: substr(contrib.action_information4,4,4) contribution_code
1212: , round(sum(fnd_number.canonical_to_number(contrib.action_information5))) base
1213: , fnd_number.canonical_to_number(contrib.action_information6) rate
1214: , sum(fnd_number.canonical_to_number(contrib.action_information7)) pay_value
1215: , count(distinct assact.assignment_id) number_of_employees
1216: FROM pay_payroll_actions payact
1217: , pay_assignment_actions assact
1218: , pay_action_information contrib

Line 1234: (SELECT fnd_number.number_to_canonical(ind_pens_prv.organization_id)

1230: WHERE pens_prv.org_information_id = p_page_identifier
1231: AND pens_prv.org_information_context = 'FR_COMP_PE_PRVS'))
1232: or
1233: (contrib.action_information1 in
1234: (SELECT fnd_number.number_to_canonical(ind_pens_prv.organization_id)
1235: FROM hr_organization_information ind_pens_prv
1236: , hr_organization_information pens_grp
1237: WHERE pens_grp.org_information_id = p_page_identifier
1238: AND pens_grp.org_information_context = 'FR_COMP_PE_PRVS'

Line 1250: , fnd_number.canonical_to_number(contrib.action_information6)

1246: translate(substr(contrib.action_information4,2,2), '1234567890',
1247: decode(contrib.action_information8 ,'FULL','1234567890'
1248: ,'PARTIAL','XXXXXXXXXX'))||
1249: substr(contrib.action_information4,4,4)
1250: , fnd_number.canonical_to_number(contrib.action_information6)
1251: ORDER BY contrib.action_information1, contrib.action_information3;
1252:
1253: /**/
1254:

Line 1326: , p_action_information11 => fnd_number.number_to_canonical(

1322: , p_action_information7 => l_sort1_text2
1323: , p_action_information8 => l_sort2_code
1324: , p_action_information9 => l_sort2_text1
1325: , p_action_information10 => l_sort2_text2
1326: , p_action_information11 => fnd_number.number_to_canonical(
1327: rec_contr.number_of_employees)
1328: , p_action_information12 => fnd_number.number_to_canonical(
1329: rec_contr.base)
1330: , p_action_information13 => fnd_number.number_to_canonical(

Line 1328: , p_action_information12 => fnd_number.number_to_canonical(

1324: , p_action_information9 => l_sort2_text1
1325: , p_action_information10 => l_sort2_text2
1326: , p_action_information11 => fnd_number.number_to_canonical(
1327: rec_contr.number_of_employees)
1328: , p_action_information12 => fnd_number.number_to_canonical(
1329: rec_contr.base)
1330: , p_action_information13 => fnd_number.number_to_canonical(
1331: rec_contr.rate)
1332: , p_action_information14 => fnd_number.number_to_canonical(

Line 1330: , p_action_information13 => fnd_number.number_to_canonical(

1326: , p_action_information11 => fnd_number.number_to_canonical(
1327: rec_contr.number_of_employees)
1328: , p_action_information12 => fnd_number.number_to_canonical(
1329: rec_contr.base)
1330: , p_action_information13 => fnd_number.number_to_canonical(
1331: rec_contr.rate)
1332: , p_action_information14 => fnd_number.number_to_canonical(
1333: l_pay_value));
1334:

Line 1332: , p_action_information14 => fnd_number.number_to_canonical(

1328: , p_action_information12 => fnd_number.number_to_canonical(
1329: rec_contr.base)
1330: , p_action_information13 => fnd_number.number_to_canonical(
1331: rec_contr.rate)
1332: , p_action_information14 => fnd_number.number_to_canonical(
1333: l_pay_value));
1334:
1335: -- Keep running total
1336:

Line 1428: , p_action_information11 => fnd_number.number_to_canonical(

1424: , p_action_information7 => l_sort1_text2
1425: , p_action_information8 => l_sort2_code
1426: , p_action_information9 => l_sort2_text1
1427: , p_action_information10 => l_sort2_text2
1428: , p_action_information11 => fnd_number.number_to_canonical(
1429: rec_contr.number_of_employees)
1430: , p_action_information12 => fnd_number.number_to_canonical(
1431: rec_contr.base)
1432: , p_action_information13 => fnd_number.number_to_canonical(

Line 1430: , p_action_information12 => fnd_number.number_to_canonical(

1426: , p_action_information9 => l_sort2_text1
1427: , p_action_information10 => l_sort2_text2
1428: , p_action_information11 => fnd_number.number_to_canonical(
1429: rec_contr.number_of_employees)
1430: , p_action_information12 => fnd_number.number_to_canonical(
1431: rec_contr.base)
1432: , p_action_information13 => fnd_number.number_to_canonical(
1433: rec_contr.rate)
1434: , p_action_information14 => fnd_number.number_to_canonical(

Line 1432: , p_action_information13 => fnd_number.number_to_canonical(

1428: , p_action_information11 => fnd_number.number_to_canonical(
1429: rec_contr.number_of_employees)
1430: , p_action_information12 => fnd_number.number_to_canonical(
1431: rec_contr.base)
1432: , p_action_information13 => fnd_number.number_to_canonical(
1433: rec_contr.rate)
1434: , p_action_information14 => fnd_number.number_to_canonical(
1435: l_pay_value));
1436:

Line 1434: , p_action_information14 => fnd_number.number_to_canonical(

1430: , p_action_information12 => fnd_number.number_to_canonical(
1431: rec_contr.base)
1432: , p_action_information13 => fnd_number.number_to_canonical(
1433: rec_contr.rate)
1434: , p_action_information14 => fnd_number.number_to_canonical(
1435: l_pay_value));
1436:
1437: l_total_contrib := l_total_contrib + l_pay_value;
1438: END LOOP;

Line 1721: , fnd_number.canonical_to_number(org_information16) advances

1717: , org_information12 payment_2_limit
1718: , org_information13 payment_3_account
1719: , org_information14 payment_3_type
1720: , org_information15 payment_3_limit
1721: , fnd_number.canonical_to_number(org_information16) advances
1722: , fnd_number.canonical_to_number(org_information17) regularisation
1723: FROM hr_organization_information
1724: WHERE organization_id = g_company_id
1725: and org_information_context = 'FR_COMP_PAYMENT_OVERRIDE'

Line 1722: , fnd_number.canonical_to_number(org_information17) regularisation

1718: , org_information13 payment_3_account
1719: , org_information14 payment_3_type
1720: , org_information15 payment_3_limit
1721: , fnd_number.canonical_to_number(org_information16) advances
1722: , fnd_number.canonical_to_number(org_information17) regularisation
1723: FROM hr_organization_information
1724: WHERE organization_id = g_company_id
1725: and org_information_context = 'FR_COMP_PAYMENT_OVERRIDE'
1726: and org_information2 = p_page_identifier

Line 1781: OPEN c_existing_archive(fnd_number.number_to_canonical(g_company_id));

1777: l_currency := 'euro';
1778: l_currency_code := 'EUR';
1779: l_currency_number := '9';
1780:
1781: OPEN c_existing_archive(fnd_number.number_to_canonical(g_company_id));
1782: FETCH c_existing_archive INTO l_payroll_action_id;
1783: IF c_existing_archive%found THEN
1784:
1785: RAISE duplicate;

Line 1819: , p_action_information1 => fnd_number.number_to_canonical(

1815: , p_action_context_id => p_payroll_action_id
1816: , p_action_context_type => 'PA'
1817: , p_object_version_number => l_ovn
1818: , p_action_information_category => 'FR_DUCS_COMP_INFO'
1819: , p_action_information1 => fnd_number.number_to_canonical(
1820: g_company_id)
1821: , p_action_information2 => rec_company.company_name
1822: , p_action_information3 => rec_company.company_address_line_1
1823: , p_action_information4 => rec_company.company_address_line_2

Line 1846: , p_action_information1 => fnd_number.number_to_canonical(g_company_id)

1842: , p_action_context_id => p_payroll_action_id
1843: , p_action_context_type => 'PA'
1844: , p_object_version_number => l_ovn
1845: , p_action_information_category => 'FR_DUCS_REFERENCE_INFO'
1846: , p_action_information1 => fnd_number.number_to_canonical(g_company_id)
1847: , p_action_information2 => l_period_code
1848: , p_action_information3 => l_date_from
1849: , p_action_information4 => l_date_to
1850: , p_action_information5 => l_period_description

Line 1864: FOR rec_estab IN csr_estab(fnd_number.number_to_canonical(g_company_id))

1860:
1861: ------
1862:
1863:
1864: FOR rec_estab IN csr_estab(fnd_number.number_to_canonical(g_company_id))
1865: LOOP
1866:
1867: pay_action_information_api.create_action_information (
1868: p_action_information_id => l_action_info_id

Line 1963: ,p_payment1_limit => fnd_number.canonical_to_number(l_payment_1_limit)

1959: pay_fr_ducs.process_payment
1960: (p_name => rec_estab.assedic_name
1961: ,p_total_payment => l_total_payment
1962: ,p_payment1_type => l_payment_1_type
1963: ,p_payment1_limit => fnd_number.canonical_to_number(l_payment_1_limit)
1964: ,p_payment1_value => l_payment_1_val
1965: ,p_payment2_type => l_payment_2_type
1966: ,p_payment2_limit => fnd_number.canonical_to_number(l_payment_2_limit)
1967: ,p_payment2_value => l_payment_2_val

Line 1966: ,p_payment2_limit => fnd_number.canonical_to_number(l_payment_2_limit)

1962: ,p_payment1_type => l_payment_1_type
1963: ,p_payment1_limit => fnd_number.canonical_to_number(l_payment_1_limit)
1964: ,p_payment1_value => l_payment_1_val
1965: ,p_payment2_type => l_payment_2_type
1966: ,p_payment2_limit => fnd_number.canonical_to_number(l_payment_2_limit)
1967: ,p_payment2_value => l_payment_2_val
1968: ,p_payment3_type => l_payment_3_type
1969: ,p_payment3_limit => fnd_number.canonical_to_number(l_payment_3_limit)
1970: ,p_payment3_value => l_payment_3_val);

Line 1969: ,p_payment3_limit => fnd_number.canonical_to_number(l_payment_3_limit)

1965: ,p_payment2_type => l_payment_2_type
1966: ,p_payment2_limit => fnd_number.canonical_to_number(l_payment_2_limit)
1967: ,p_payment2_value => l_payment_2_val
1968: ,p_payment3_type => l_payment_3_type
1969: ,p_payment3_limit => fnd_number.canonical_to_number(l_payment_3_limit)
1970: ,p_payment3_value => l_payment_3_val);
1971:
1972:
1973:

Line 2033: ,p_action_information12 => fnd_number.number_to_canonical(l_payment_1_val)

2029: ,p_action_information8 => rec_estab.urssaf_address_line_2
2030: ,p_action_information9 => rec_estab.urssaf_address_line_3
2031: ,p_action_information10 => rec_estab.urssaf_address_line_4
2032: ,p_action_information11 => l_payment_1_acc_no
2033: ,p_action_information12 => fnd_number.number_to_canonical(l_payment_1_val)
2034: ,p_action_information13 => l_payment_2_acc_no
2035: ,p_action_information14 => fnd_number.number_to_canonical(l_payment_2_val)
2036: ,p_action_information15 => l_payment_3_acc_no
2037: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)

Line 2035: ,p_action_information14 => fnd_number.number_to_canonical(l_payment_2_val)

2031: ,p_action_information10 => rec_estab.urssaf_address_line_4
2032: ,p_action_information11 => l_payment_1_acc_no
2033: ,p_action_information12 => fnd_number.number_to_canonical(l_payment_1_val)
2034: ,p_action_information13 => l_payment_2_acc_no
2035: ,p_action_information14 => fnd_number.number_to_canonical(l_payment_2_val)
2036: ,p_action_information15 => l_payment_3_acc_no
2037: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)
2038: ,p_action_information17 => to_char(l_Declaration_Due,'dd/mm/yyyy')
2039: ,p_action_information18 => to_char(l_Latest_Declaration,'dd/mm/yyyy')

Line 2037: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)

2033: ,p_action_information12 => fnd_number.number_to_canonical(l_payment_1_val)
2034: ,p_action_information13 => l_payment_2_acc_no
2035: ,p_action_information14 => fnd_number.number_to_canonical(l_payment_2_val)
2036: ,p_action_information15 => l_payment_3_acc_no
2037: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)
2038: ,p_action_information17 => to_char(l_Declaration_Due,'dd/mm/yyyy')
2039: ,p_action_information18 => to_char(l_Latest_Declaration,'dd/mm/yyyy')
2040: ,p_action_information19 => to_char(l_Last_Contribution,'dd/mm/yyyy')
2041: ,p_action_information20 => to_char(l_Payment_Date,'dd/mm/yyyy')

Line 2046: ,p_action_information25 => fnd_number.number_to_canonical(

2042: ,p_action_information21 => l_contribution_emps
2043: ,p_action_information22 => l_month_end_male
2044: ,p_action_information23 => l_month_end_female
2045: ,p_action_information24 => l_month_end_total
2046: ,p_action_information25 => fnd_number.number_to_canonical(
2047: l_total_contributions)
2048: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)
2049: ,p_action_information27 => fnd_number.number_to_canonical(l_regularization)
2050: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment)

Line 2048: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)

2044: ,p_action_information23 => l_month_end_female
2045: ,p_action_information24 => l_month_end_total
2046: ,p_action_information25 => fnd_number.number_to_canonical(
2047: l_total_contributions)
2048: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)
2049: ,p_action_information27 => fnd_number.number_to_canonical(l_regularization)
2050: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment)
2051: ,p_action_information29 => l_total_actions);
2052:

Line 2049: ,p_action_information27 => fnd_number.number_to_canonical(l_regularization)

2045: ,p_action_information24 => l_month_end_total
2046: ,p_action_information25 => fnd_number.number_to_canonical(
2047: l_total_contributions)
2048: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)
2049: ,p_action_information27 => fnd_number.number_to_canonical(l_regularization)
2050: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment)
2051: ,p_action_information29 => l_total_actions);
2052:
2053: -- AASEDIC

Line 2050: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment)

2046: ,p_action_information25 => fnd_number.number_to_canonical(
2047: l_total_contributions)
2048: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)
2049: ,p_action_information27 => fnd_number.number_to_canonical(l_regularization)
2050: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment)
2051: ,p_action_information29 => l_total_actions);
2052:
2053: -- AASEDIC
2054:

Line 2131: ,p_payment1_limit => fnd_number.canonical_to_number(l_payment_1_limit)

2127: pay_fr_ducs.process_payment
2128: (p_name => rec_estab.assedic_name
2129: ,p_total_payment => l_total_payment
2130: ,p_payment1_type => l_payment_1_type
2131: ,p_payment1_limit => fnd_number.canonical_to_number(l_payment_1_limit)
2132: ,p_payment1_value => l_payment_1_val
2133: ,p_payment2_type => l_payment_2_type
2134: ,p_payment2_limit => fnd_number.canonical_to_number(l_payment_2_limit)
2135: ,p_payment2_value => l_payment_2_val

Line 2134: ,p_payment2_limit => fnd_number.canonical_to_number(l_payment_2_limit)

2130: ,p_payment1_type => l_payment_1_type
2131: ,p_payment1_limit => fnd_number.canonical_to_number(l_payment_1_limit)
2132: ,p_payment1_value => l_payment_1_val
2133: ,p_payment2_type => l_payment_2_type
2134: ,p_payment2_limit => fnd_number.canonical_to_number(l_payment_2_limit)
2135: ,p_payment2_value => l_payment_2_val
2136: ,p_payment3_type => l_payment_3_type
2137: ,p_payment3_limit => fnd_number.canonical_to_number(l_payment_3_limit)
2138: ,p_payment3_value => l_payment_3_val);

Line 2137: ,p_payment3_limit => fnd_number.canonical_to_number(l_payment_3_limit)

2133: ,p_payment2_type => l_payment_2_type
2134: ,p_payment2_limit => fnd_number.canonical_to_number(l_payment_2_limit)
2135: ,p_payment2_value => l_payment_2_val
2136: ,p_payment3_type => l_payment_3_type
2137: ,p_payment3_limit => fnd_number.canonical_to_number(l_payment_3_limit)
2138: ,p_payment3_value => l_payment_3_val);
2139:
2140:
2141:

Line 2199: ,p_action_information12 => fnd_number.number_to_canonical(l_payment_1_val)

2195: ,p_action_information8 => rec_estab.assedic_address_line_2
2196: ,p_action_information9 => rec_estab.assedic_address_line_3
2197: ,p_action_information10 => rec_estab.assedic_address_line_4
2198: ,p_action_information11 => l_payment_1_acc_no
2199: ,p_action_information12 => fnd_number.number_to_canonical(l_payment_1_val)
2200: ,p_action_information13 => l_payment_2_acc_no
2201: ,p_action_information14 => fnd_number.number_to_canonical(l_payment_2_val)
2202: ,p_action_information15 => l_payment_3_acc_no
2203: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)

Line 2201: ,p_action_information14 => fnd_number.number_to_canonical(l_payment_2_val)

2197: ,p_action_information10 => rec_estab.assedic_address_line_4
2198: ,p_action_information11 => l_payment_1_acc_no
2199: ,p_action_information12 => fnd_number.number_to_canonical(l_payment_1_val)
2200: ,p_action_information13 => l_payment_2_acc_no
2201: ,p_action_information14 => fnd_number.number_to_canonical(l_payment_2_val)
2202: ,p_action_information15 => l_payment_3_acc_no
2203: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)
2204: ,p_action_information17 => to_char(l_Declaration_Due,'dd/mm/yyyy')
2205: ,p_action_information18 => to_char(l_Latest_Declaration,'dd/mm/yyyy')

Line 2203: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)

2199: ,p_action_information12 => fnd_number.number_to_canonical(l_payment_1_val)
2200: ,p_action_information13 => l_payment_2_acc_no
2201: ,p_action_information14 => fnd_number.number_to_canonical(l_payment_2_val)
2202: ,p_action_information15 => l_payment_3_acc_no
2203: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)
2204: ,p_action_information17 => to_char(l_Declaration_Due,'dd/mm/yyyy')
2205: ,p_action_information18 => to_char(l_Latest_Declaration,'dd/mm/yyyy')
2206: ,p_action_information19 => to_char(l_Last_Contribution,'dd/mm/yyyy')
2207: ,p_action_information20 => to_char(l_Payment_Date,'dd/mm/yyyy')

Line 2212: ,p_action_information25 => fnd_number.number_to_canonical(

2208: ,p_action_information21 => l_contribution_emps
2209: ,p_action_information22 => l_month_end_male
2210: ,p_action_information23 => l_month_end_female
2211: ,p_action_information24 => l_month_end_total
2212: ,p_action_information25 => fnd_number.number_to_canonical(
2213: l_total_contributions)
2214: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)
2215: ,p_action_information27 => fnd_number.number_to_canonical(l_regularization)
2216: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment)

Line 2214: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)

2210: ,p_action_information23 => l_month_end_female
2211: ,p_action_information24 => l_month_end_total
2212: ,p_action_information25 => fnd_number.number_to_canonical(
2213: l_total_contributions)
2214: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)
2215: ,p_action_information27 => fnd_number.number_to_canonical(l_regularization)
2216: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment)
2217: ,p_action_information29 => l_total_actions);
2218:

Line 2215: ,p_action_information27 => fnd_number.number_to_canonical(l_regularization)

2211: ,p_action_information24 => l_month_end_total
2212: ,p_action_information25 => fnd_number.number_to_canonical(
2213: l_total_contributions)
2214: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)
2215: ,p_action_information27 => fnd_number.number_to_canonical(l_regularization)
2216: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment)
2217: ,p_action_information29 => l_total_actions);
2218:
2219: END LOOP;

Line 2216: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment)

2212: ,p_action_information25 => fnd_number.number_to_canonical(
2213: l_total_contributions)
2214: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)
2215: ,p_action_information27 => fnd_number.number_to_canonical(l_regularization)
2216: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment)
2217: ,p_action_information29 => l_total_actions);
2218:
2219: END LOOP;
2220:

Line 2300: ,p_payment1_limit => fnd_number.canonical_to_number(l_payment_1_limit)

2296: pay_fr_ducs.process_payment
2297: (p_name => rec_pens.name
2298: ,p_total_payment => l_total_payment
2299: ,p_payment1_type => l_payment_1_type
2300: ,p_payment1_limit => fnd_number.canonical_to_number(l_payment_1_limit)
2301: ,p_payment1_value => l_payment_1_val
2302: ,p_payment2_type => l_payment_2_type
2303: ,p_payment2_limit => fnd_number.canonical_to_number(l_payment_2_limit)
2304: ,p_payment2_value => l_payment_2_val

Line 2303: ,p_payment2_limit => fnd_number.canonical_to_number(l_payment_2_limit)

2299: ,p_payment1_type => l_payment_1_type
2300: ,p_payment1_limit => fnd_number.canonical_to_number(l_payment_1_limit)
2301: ,p_payment1_value => l_payment_1_val
2302: ,p_payment2_type => l_payment_2_type
2303: ,p_payment2_limit => fnd_number.canonical_to_number(l_payment_2_limit)
2304: ,p_payment2_value => l_payment_2_val
2305: ,p_payment3_type => l_payment_3_type
2306: ,p_payment3_limit => fnd_number.canonical_to_number(l_payment_3_limit)
2307: ,p_payment3_value => l_payment_3_val);

Line 2306: ,p_payment3_limit => fnd_number.canonical_to_number(l_payment_3_limit)

2302: ,p_payment2_type => l_payment_2_type
2303: ,p_payment2_limit => fnd_number.canonical_to_number(l_payment_2_limit)
2304: ,p_payment2_value => l_payment_2_val
2305: ,p_payment3_type => l_payment_3_type
2306: ,p_payment3_limit => fnd_number.canonical_to_number(l_payment_3_limit)
2307: ,p_payment3_value => l_payment_3_val);
2308:
2309: pay_fr_ducs.get_count_emps(p_payroll_action_id
2310: ,rec_pens.comp_pens_prov_id

Line 2365: ,p_action_information12 => fnd_number.number_to_canonical(l_payment_1_val)

2361: ,p_action_information8 => rec_pens.address_line_2
2362: ,p_action_information9 => rec_pens.address_line_3
2363: ,p_action_information10 => rec_pens.address_line_4
2364: ,p_action_information11 => l_payment_1_acc_no
2365: ,p_action_information12 => fnd_number.number_to_canonical(l_payment_1_val)
2366: ,p_action_information13 => l_payment_2_acc_no
2367: ,p_action_information14 => fnd_number.number_to_canonical(l_payment_2_val)
2368: ,p_action_information15 => l_payment_3_acc_no
2369: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)

Line 2367: ,p_action_information14 => fnd_number.number_to_canonical(l_payment_2_val)

2363: ,p_action_information10 => rec_pens.address_line_4
2364: ,p_action_information11 => l_payment_1_acc_no
2365: ,p_action_information12 => fnd_number.number_to_canonical(l_payment_1_val)
2366: ,p_action_information13 => l_payment_2_acc_no
2367: ,p_action_information14 => fnd_number.number_to_canonical(l_payment_2_val)
2368: ,p_action_information15 => l_payment_3_acc_no
2369: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)
2370: ,p_action_information17 => to_char(l_Declaration_Due,'dd/mm/yyyy')
2371: ,p_action_information18 => to_char(l_Latest_Declaration,'dd/mm/yyyy')

Line 2369: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)

2365: ,p_action_information12 => fnd_number.number_to_canonical(l_payment_1_val)
2366: ,p_action_information13 => l_payment_2_acc_no
2367: ,p_action_information14 => fnd_number.number_to_canonical(l_payment_2_val)
2368: ,p_action_information15 => l_payment_3_acc_no
2369: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)
2370: ,p_action_information17 => to_char(l_Declaration_Due,'dd/mm/yyyy')
2371: ,p_action_information18 => to_char(l_Latest_Declaration,'dd/mm/yyyy')
2372: ,p_action_information19 => to_char(l_Last_Contribution,'dd/mm/yyyy')
2373: ,p_action_information20 => to_char(l_Payment_Date,'dd/mm/yyyy')

Line 2378: ,p_action_information25 => fnd_number.number_to_canonical(

2374: ,p_action_information21 => l_contribution_emps
2375: ,p_action_information22 => l_month_end_male
2376: ,p_action_information23 => l_month_end_female
2377: ,p_action_information24 => l_month_end_total
2378: ,p_action_information25 => fnd_number.number_to_canonical(
2379: l_total_contributions)
2380: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)
2381: ,p_action_information27 => fnd_number.number_to_canonical(l_regularization)
2382: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment)

Line 2380: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)

2376: ,p_action_information23 => l_month_end_female
2377: ,p_action_information24 => l_month_end_total
2378: ,p_action_information25 => fnd_number.number_to_canonical(
2379: l_total_contributions)
2380: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)
2381: ,p_action_information27 => fnd_number.number_to_canonical(l_regularization)
2382: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment)
2383: ,p_action_information29 => l_total_actions);
2384:

Line 2381: ,p_action_information27 => fnd_number.number_to_canonical(l_regularization)

2377: ,p_action_information24 => l_month_end_total
2378: ,p_action_information25 => fnd_number.number_to_canonical(
2379: l_total_contributions)
2380: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)
2381: ,p_action_information27 => fnd_number.number_to_canonical(l_regularization)
2382: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment)
2383: ,p_action_information29 => l_total_actions);
2384:
2385:

Line 2382: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment)

2378: ,p_action_information25 => fnd_number.number_to_canonical(
2379: l_total_contributions)
2380: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)
2381: ,p_action_information27 => fnd_number.number_to_canonical(l_regularization)
2382: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment)
2383: ,p_action_information29 => l_total_actions);
2384:
2385:
2386: END LOOP; -- End of Pension Loop

Line 2525: l_advances:=round(nvl(fnd_number.canonical_to_number(payment.advances),0),2);

2521: ELSE
2522:
2523: -- Set total payment using the update advances and regularisation values
2524:
2525: l_advances:=round(nvl(fnd_number.canonical_to_number(payment.advances),0),2);
2526: l_regularisation:=round(nvl(fnd_number.canonical_to_number(
2527: payment.regularisation),0),2);
2528: l_total_payment :=
2529: round(fnd_number.canonical_to_number(payment.total_contributions),2) +

Line 2526: l_regularisation:=round(nvl(fnd_number.canonical_to_number(

2522:
2523: -- Set total payment using the update advances and regularisation values
2524:
2525: l_advances:=round(nvl(fnd_number.canonical_to_number(payment.advances),0),2);
2526: l_regularisation:=round(nvl(fnd_number.canonical_to_number(
2527: payment.regularisation),0),2);
2528: l_total_payment :=
2529: round(fnd_number.canonical_to_number(payment.total_contributions),2) +
2530: l_advances + l_regularisation;

Line 2529: round(fnd_number.canonical_to_number(payment.total_contributions),2) +

2525: l_advances:=round(nvl(fnd_number.canonical_to_number(payment.advances),0),2);
2526: l_regularisation:=round(nvl(fnd_number.canonical_to_number(
2527: payment.regularisation),0),2);
2528: l_total_payment :=
2529: round(fnd_number.canonical_to_number(payment.total_contributions),2) +
2530: l_advances + l_regularisation;
2531:
2532: pay_fr_ducs.process_payment
2533: (p_name => payment.organization_name

Line 2536: ,p_payment1_limit => fnd_number.canonical_to_number(payment.payment_1_limit)

2532: pay_fr_ducs.process_payment
2533: (p_name => payment.organization_name
2534: ,p_total_payment => l_total_payment
2535: ,p_payment1_type => payment.payment_1_type
2536: ,p_payment1_limit => fnd_number.canonical_to_number(payment.payment_1_limit)
2537: ,p_payment1_value => l_payment_1_val
2538: ,p_payment2_type => payment.payment_2_type
2539: ,p_payment2_limit => fnd_number.canonical_to_number(payment.payment_2_limit)
2540: ,p_payment2_value => l_payment_2_val

Line 2539: ,p_payment2_limit => fnd_number.canonical_to_number(payment.payment_2_limit)

2535: ,p_payment1_type => payment.payment_1_type
2536: ,p_payment1_limit => fnd_number.canonical_to_number(payment.payment_1_limit)
2537: ,p_payment1_value => l_payment_1_val
2538: ,p_payment2_type => payment.payment_2_type
2539: ,p_payment2_limit => fnd_number.canonical_to_number(payment.payment_2_limit)
2540: ,p_payment2_value => l_payment_2_val
2541: ,p_payment3_type => payment.payment_3_type
2542: ,p_payment3_limit => fnd_number.canonical_to_number(payment.payment_3_limit)
2543: ,p_payment3_value => l_payment_3_val);

Line 2542: ,p_payment3_limit => fnd_number.canonical_to_number(payment.payment_3_limit)

2538: ,p_payment2_type => payment.payment_2_type
2539: ,p_payment2_limit => fnd_number.canonical_to_number(payment.payment_2_limit)
2540: ,p_payment2_value => l_payment_2_val
2541: ,p_payment3_type => payment.payment_3_type
2542: ,p_payment3_limit => fnd_number.canonical_to_number(payment.payment_3_limit)
2543: ,p_payment3_value => l_payment_3_val);
2544:
2545:
2546: l_payment_1_acc_no := null;

Line 2575: ,p_action_information12 => fnd_number.number_to_canonical(l_payment_1_val)

2571: pay_action_information_api.update_action_information(
2572: p_action_information_id => payment.action_information_id
2573: ,p_object_version_number => payment.object_version_number
2574: ,p_action_information11 => l_payment_1_acc_no
2575: ,p_action_information12 => fnd_number.number_to_canonical(l_payment_1_val)
2576: ,p_action_information13 => l_payment_2_acc_no
2577: ,p_action_information14 => fnd_number.number_to_canonical(l_payment_2_val)
2578: ,p_action_information15 => l_payment_3_acc_no
2579: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)

Line 2577: ,p_action_information14 => fnd_number.number_to_canonical(l_payment_2_val)

2573: ,p_object_version_number => payment.object_version_number
2574: ,p_action_information11 => l_payment_1_acc_no
2575: ,p_action_information12 => fnd_number.number_to_canonical(l_payment_1_val)
2576: ,p_action_information13 => l_payment_2_acc_no
2577: ,p_action_information14 => fnd_number.number_to_canonical(l_payment_2_val)
2578: ,p_action_information15 => l_payment_3_acc_no
2579: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)
2580: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)
2581: ,p_action_information27 => fnd_number.number_to_canonical(l_regularisation)

Line 2579: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)

2575: ,p_action_information12 => fnd_number.number_to_canonical(l_payment_1_val)
2576: ,p_action_information13 => l_payment_2_acc_no
2577: ,p_action_information14 => fnd_number.number_to_canonical(l_payment_2_val)
2578: ,p_action_information15 => l_payment_3_acc_no
2579: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)
2580: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)
2581: ,p_action_information27 => fnd_number.number_to_canonical(l_regularisation)
2582: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment));
2583:

Line 2580: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)

2576: ,p_action_information13 => l_payment_2_acc_no
2577: ,p_action_information14 => fnd_number.number_to_canonical(l_payment_2_val)
2578: ,p_action_information15 => l_payment_3_acc_no
2579: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)
2580: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)
2581: ,p_action_information27 => fnd_number.number_to_canonical(l_regularisation)
2582: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment));
2583:
2584: END IF;

Line 2581: ,p_action_information27 => fnd_number.number_to_canonical(l_regularisation)

2577: ,p_action_information14 => fnd_number.number_to_canonical(l_payment_2_val)
2578: ,p_action_information15 => l_payment_3_acc_no
2579: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)
2580: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)
2581: ,p_action_information27 => fnd_number.number_to_canonical(l_regularisation)
2582: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment));
2583:
2584: END IF;
2585:

Line 2582: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment));

2578: ,p_action_information15 => l_payment_3_acc_no
2579: ,p_action_information16 => fnd_number.number_to_canonical(l_payment_3_val)
2580: ,p_action_information26 => fnd_number.number_to_canonical(l_advances)
2581: ,p_action_information27 => fnd_number.number_to_canonical(l_regularisation)
2582: ,p_action_information28 => fnd_number.number_to_canonical(l_total_payment));
2583:
2584: END IF;
2585:
2586: END LOOP;