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_FR_DUCS dependencies on PAY_FR_DUCS

Line 1: package body PAY_FR_DUCS as

1: package body PAY_FR_DUCS as
2: /* $Header: pyfraduc.pkb 120.1 2006/01/27 04:37:54 aparkes noship $ */
3: --
4: -- Globals
5: --

Line 16: g_package constant varchar2(30):= 'pay_fr_ducs';

12: pens_provs g_org_info_tabtype);
13:
14: g_estab_pens_provs g_estab_pens_prov_rectype;
15:
16: g_package constant varchar2(30):= 'pay_fr_ducs';
17:
18: g_business_group_id per_business_Groups.business_group_id%TYPE;
19: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
20:

Line 94: pay_fr_ducs.get_parameter(legislative_parameters, 'COMPANY_ID'))

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
98: FROM pay_payroll_actions

Line 95: ,pay_fr_ducs.get_parameter(legislative_parameters, 'PERIOD_TYPE')

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
98: FROM pay_payroll_actions
99: WHERE payroll_action_id = p_payroll_action_id;

Line 183: pay_fr_ducs.get_all_parameters

179: --
180: -- Load the parameters to the process
181: --
182:
183: pay_fr_ducs.get_all_parameters
184: (p_payroll_action_id => p_payroll_action_id
185: ,p_business_group_id => g_business_group_id
186: ,p_company_id => g_company_id
187: ,p_period_type => g_period_type

Line 384: pay_fr_ducs.get_all_parameters

380:
381: if g_payroll_action_id is null
382: or g_payroll_action_id <> p_payroll_action_id
383: then
384: pay_fr_ducs.get_all_parameters
385: (p_payroll_action_id => p_payroll_action_id
386: ,p_business_group_id => g_business_group_id
387: ,p_company_id => g_company_id
388: ,p_period_type => g_period_type

Line 469: pay_fr_ducs.get_all_parameters

465: if g_payroll_action_id is null
466: or g_payroll_action_id <> p_payroll_action_id
467: then
468: hr_utility.set_location(l_proc,20);
469: pay_fr_ducs.get_all_parameters
470: (p_payroll_action_id => p_payroll_action_id
471: ,p_business_group_id => g_business_group_id
472: ,p_company_id => g_company_id
473: ,p_period_type => g_period_type

Line 606: pay_fr_ducs.retrieve_contributions(grand_child.new_ass_act_id,

602: open csr_locking_reversal (grand_child.assignment_action_id);
603: fetch csr_locking_reversal into l_num;
604: if csr_locking_reversal%NOTFOUND then
605: -- Run the contribution retrieval procedure
606: pay_fr_ducs.retrieve_contributions(grand_child.new_ass_act_id,
607: p_effective_date,
608: grand_child.tax_unit_id);
609: end if; -- csr_locking_reversal%NOTFOUND
610: close csr_locking_reversal;

Line 621: pay_fr_ducs.retrieve_contributions(child.new_ass_act_id,

617: open csr_locking_reversal (child.assignment_action_id);
618: fetch csr_locking_reversal into l_num;
619: if csr_locking_reversal%NOTFOUND then
620: -- Run the contribution retrieval procedure
621: pay_fr_ducs.retrieve_contributions(child.new_ass_act_id,
622: p_effective_date,
623: child.tax_unit_id);
624: end if; -- csr_locking_reversal%NOTFOUND
625: close csr_locking_reversal;

Line 641: pay_fr_ducs.retrieve_contributions(p_assignment_action_id

637: IF not l_child THEN
638: open csr_locking_reversal (l_locked_action.id);
639: fetch csr_locking_reversal into l_num;
640: if csr_locking_reversal%NOTFOUND then
641: pay_fr_ducs.retrieve_contributions(p_assignment_action_id
642: ,p_effective_date
643: ,l_locked_action.tax_unit_id);
644: end if; -- csr_locking_reversal%NOTFOUND
645: close csr_locking_reversal;

Line 1285: pay_fr_ducs.get_lookup('FR_ASSEDIC_CONTRI_CODE'

1281: ,substr(rec_contr.contribution_code,4,4));
1282:
1283: ELSIF rec_contr.contribution_type = 'ASSEDIC' THEN -- ASSEDIC
1284: -- Last 3 chars of contribution code define the text
1285: pay_fr_ducs.get_lookup('FR_ASSEDIC_CONTRI_CODE'
1286: ,substr(rec_contr.contribution_code,5,3)
1287: ,l_meaning
1288: ,l_tag);
1289: l_contribution_text := l_meaning;

Line 1352: pay_fr_ducs.get_lookup('FR_PENSION_CATEGORY'

1348: FOR rec_contr IN ccontrib_pension LOOP
1349:
1350:
1351:
1352: pay_fr_ducs.get_lookup('FR_PENSION_CATEGORY'
1353: ,substr(rec_contr.contribution_code,3,3)
1354: ,l_meaning
1355: ,l_tag);
1356: l_tag:=replace(l_tag,'N/C','NON CADRES');

Line 1737: pay_fr_ducs.get_all_parameters

1733: hr_utility.set_location('Entering ' || l_proc, 20);
1734: if g_payroll_action_id is null
1735: or g_payroll_action_id <> p_payroll_action_id
1736: then
1737: pay_fr_ducs.get_all_parameters
1738: (p_payroll_action_id => p_payroll_action_id
1739: ,p_business_group_id => g_business_group_id
1740: ,p_company_id => g_company_id
1741: ,p_period_type => g_period_type

Line 1886: pay_fr_ducs.process_contributions

1882: -- Insert the Establishment Archive record
1883: --
1884:
1885: -- Process URSSAF contributions
1886: pay_fr_ducs.process_contributions
1887: (p_payroll_action_id => p_payroll_action_id
1888: ,p_page_identifier => rec_estab.establishment_id
1889: ,p_page_type => 'URSSAF'
1890: ,p_total_contributions => l_total_contributions

Line 1959: pay_fr_ducs.process_payment

1955: l_total_payment := l_total_contributions + l_advances + l_regularization;
1956:
1957:
1958:
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)

Line 1974: pay_fr_ducs.get_count_emps(p_payroll_action_id

1970: ,p_payment3_value => l_payment_3_val);
1971:
1972:
1973:
1974: pay_fr_ducs.get_count_emps(p_payroll_action_id
1975: ,rec_estab.establishment_id
1976: ,'URSSAF'
1977: ,l_contribution_emps
1978: ,l_month_end_male

Line 2055: pay_fr_ducs.process_contributions

2051: ,p_action_information29 => l_total_actions);
2052:
2053: -- AASEDIC
2054:
2055: pay_fr_ducs.process_contributions
2056: (p_payroll_action_id => p_payroll_action_id
2057: ,p_page_identifier => rec_estab.establishment_id
2058: ,p_page_type => 'ASSEDIC'
2059: ,p_total_contributions => l_total_contributions

Line 2127: pay_fr_ducs.process_payment

2123: l_advances := round(nvl(l_advances,0),2);
2124: l_regularization := round(nvl(l_regularization,0),2);
2125: l_total_payment := l_total_contributions + l_advances + l_regularization;
2126:
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)

Line 2142: pay_fr_ducs.get_count_emps(p_payroll_action_id

2138: ,p_payment3_value => l_payment_3_val);
2139:
2140:
2141:
2142: pay_fr_ducs.get_count_emps(p_payroll_action_id
2143: ,rec_estab.establishment_id
2144: ,'ASSEDIC'
2145: ,l_contribution_emps
2146: ,l_month_end_male

Line 2227: pay_fr_ducs.process_contributions

2223: FOR rec_pens IN csr_comp_pension_prvs LOOP
2224:
2225:
2226: -- Process PENSION contributions
2227: pay_fr_ducs.process_contributions
2228: (p_payroll_action_id => p_payroll_action_id
2229: ,p_page_identifier => rec_pens.comp_pens_prov_id
2230: ,p_page_type => 'PENSION'
2231: ,p_total_contributions => l_total_contributions

Line 2296: pay_fr_ducs.process_payment

2292: l_regularization := round(nvl(l_regularization,0),2);
2293:
2294: l_total_payment := l_total_contributions + l_advances + l_regularization;
2295:
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)

Line 2309: pay_fr_ducs.get_count_emps(p_payroll_action_id

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
2311: ,'PENSION'
2312: ,l_contribution_emps
2313: ,l_month_end_male

Line 2532: pay_fr_ducs.process_payment

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
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)

Line 2598: END PAY_FR_DUCS; -- End of package

2594:
2595: END recalculate_payment;
2596: --
2597:
2598: END PAY_FR_DUCS; -- End of package