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_PTO_PKG dependencies on FND_DATE

Line 629: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)

625: and prr.status in ('P','PA')
626: and prrv_plan.result_value = l_accrual_plan_id
627: and paa.action_sequence < l_action_sequence
628: /* restrict to just this accrual year, otherwise all taken across all plan years will be added in */
629: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
630: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
631:
632:
633: CURSOR csr_previous_paid_absences_r is

Line 630: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);

626: and prrv_plan.result_value = l_accrual_plan_id
627: and paa.action_sequence < l_action_sequence
628: /* restrict to just this accrual year, otherwise all taken across all plan years will be added in */
629: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
630: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
631:
632:
633: CURSOR csr_previous_paid_absences_r is
634: select sum(prrv_days.result_value)

Line 653: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)

649: and prr.status in ('P','PA')
650: and prrv_plan.result_value = l_accrual_plan_id
651: and paa.action_sequence < l_action_sequence
652: /* restrict to just this accrual year, otherwise all taken across all plan years will be added in */
653: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
654: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
655: --
656: -- Get the absences on or after the action sequence
657: CURSOR csr_current_paid_absences is

Line 654: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);

650: and prrv_plan.result_value = l_accrual_plan_id
651: and paa.action_sequence < l_action_sequence
652: /* restrict to just this accrual year, otherwise all taken across all plan years will be added in */
653: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
654: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
655: --
656: -- Get the absences on or after the action sequence
657: CURSOR csr_current_paid_absences is
658: select sum(prrv_days.result_value)

Line 738: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)

734: and prrv_plan.result_value = l_accrual_plan_id
735: and prr.element_type_id = l_fr_pay_info.pay_element_id
736: and prr.status in ('P','PA')
737: and paa.action_sequence <= l_action_sequence
738: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
739: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
740:
741: CURSOR csr_prev_and_cur_paid_abs_r is
742: select sum(prrv_days.result_value)

Line 739: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);

735: and prr.element_type_id = l_fr_pay_info.pay_element_id
736: and prr.status in ('P','PA')
737: and paa.action_sequence <= l_action_sequence
738: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
739: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
740:
741: CURSOR csr_prev_and_cur_paid_abs_r is
742: select sum(prrv_days.result_value)
743: from pay_run_result_values prrv_days

Line 760: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)

756: and prrv_plan.result_value = l_accrual_plan_id
757: and prr.element_type_id = l_fr_pay_r_info.pay_element_id
758: and prr.status in ('P','PA')
759: and paa.action_sequence <= l_action_sequence
760: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
761: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
762:
763: --
764: -- Termination processing - get sum of paid absences

Line 761: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);

757: and prr.element_type_id = l_fr_pay_r_info.pay_element_id
758: and prr.status in ('P','PA')
759: and paa.action_sequence <= l_action_sequence
760: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
761: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
762:
763: --
764: -- Termination processing - get sum of paid absences
765: --

Line 788: fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)

784: -- restrict to just this accrual year,
785: -- otherwise all taken across all plan years will be added in
786: -- this cursor is used by the accruals calculation
787: and prrv_accrual.result_value between
788: fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
789: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
790:
791:
792: --

Line 789: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);

785: -- otherwise all taken across all plan years will be added in
786: -- this cursor is used by the accruals calculation
787: and prrv_accrual.result_value between
788: fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
789: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
790:
791:
792: --
793: -- get the total of ENTITLEMENT, OBSOLETION, ADJUSTMENT entries for this asg for this accrual plan year

Line 826: and pevdate.screen_entry_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)

822: and pee.element_entry_id = pevs.element_entry_id
823: and pee.element_entry_id = pevc.element_entry_id
824: and pee.element_entry_id = pevy.element_entry_id
825: and pee.element_entry_id = pevdate.element_entry_id
826: and pevdate.screen_entry_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
827: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end)
828: and pee.assignment_id = p_assignment_id ;
829: --
830: -- Cursor for calculating existing entitlements for additional holidays

Line 827: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end)

823: and pee.element_entry_id = pevc.element_entry_id
824: and pee.element_entry_id = pevy.element_entry_id
825: and pee.element_entry_id = pevdate.element_entry_id
826: and pevdate.screen_entry_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
827: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end)
828: and pee.assignment_id = p_assignment_id ;
829: --
830: -- Cursor for calculating existing entitlements for additional holidays
831: cursor csr_get_ent_add(

Line 842: and pevdate.screen_entry_value = fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end)

838: where pevm.input_value_id = p_type_m_iv_id
839: and pevdate.input_value_id = p_type_accrual_date_iv_id
840: and pee.element_entry_id = pevm.element_entry_id
841: and pee.element_entry_id = pevdate.element_entry_id
842: and pevdate.screen_entry_value = fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end)
843: and pee.assignment_id = p_assignment_id
844: and pee.effective_start_date between p_legal_period_end and
845: add_months(l_fr_plan_info.accrual_year_end,12);
846: --

Line 1354: between fnd_date.date_to_canonical(l_accrued_start_date)

1350: and paa.assignment_id = p_assignment_id
1351: and prr.element_type_id = l_fr_pay_info.pay_element_id
1352: and prr.status in ('P','PA')
1353: and prrv_accrual.result_value
1354: between fnd_date.date_to_canonical(l_accrued_start_date)
1355: and fnd_date.date_to_canonical(l_accrued_end_date);
1356: --
1357: -- Cursor for finding number of days to be regularized
1358: -- and holiday payments made

Line 1355: and fnd_date.date_to_canonical(l_accrued_end_date);

1351: and prr.element_type_id = l_fr_pay_info.pay_element_id
1352: and prr.status in ('P','PA')
1353: and prrv_accrual.result_value
1354: between fnd_date.date_to_canonical(l_accrued_start_date)
1355: and fnd_date.date_to_canonical(l_accrued_end_date);
1356: --
1357: -- Cursor for finding number of days to be regularized
1358: -- and holiday payments made
1359: -- in case of unregularized payments retro

Line 1384: between fnd_date.date_to_canonical(l_accrued_start_date)

1380: and paa.assignment_id = p_assignment_id
1381: and prr.element_type_id = l_fr_pay_r_info.pay_element_id
1382: and prr.status in ('P','PA')
1383: and prrv_accrual.result_value
1384: between fnd_date.date_to_canonical(l_accrued_start_date)
1385: and fnd_date.date_to_canonical(l_accrued_end_date);
1386: --
1387: -- Cursor to fetch all previous regularized payments
1388: Cursor csr_prev_reg_pymt IS

Line 1385: and fnd_date.date_to_canonical(l_accrued_end_date);

1381: and prr.element_type_id = l_fr_pay_r_info.pay_element_id
1382: and prr.status in ('P','PA')
1383: and prrv_accrual.result_value
1384: between fnd_date.date_to_canonical(l_accrued_start_date)
1385: and fnd_date.date_to_canonical(l_accrued_end_date);
1386: --
1387: -- Cursor to fetch all previous regularized payments
1388: Cursor csr_prev_reg_pymt IS
1389: select sum(prrv_pay.result_value)

Line 1406: between fnd_date.date_to_canonical(l_accrued_start_date)

1402: and paa.assignment_id = p_assignment_id
1403: and prr.element_type_id = l_fr_pay_info.pay_reg_element_id
1404: and prr.status in ('P','PA')
1405: and prrv_accrual.result_value
1406: between fnd_date.date_to_canonical(l_accrued_start_date)
1407: and fnd_date.date_to_canonical(l_accrued_end_date);
1408:
1409: -- Cursor to fetch all previous regularized payments retro
1410: Cursor csr_prev_reg_pymt_r IS

Line 1407: and fnd_date.date_to_canonical(l_accrued_end_date);

1403: and prr.element_type_id = l_fr_pay_info.pay_reg_element_id
1404: and prr.status in ('P','PA')
1405: and prrv_accrual.result_value
1406: between fnd_date.date_to_canonical(l_accrued_start_date)
1407: and fnd_date.date_to_canonical(l_accrued_end_date);
1408:
1409: -- Cursor to fetch all previous regularized payments retro
1410: Cursor csr_prev_reg_pymt_r IS
1411: select sum(prrv_pay.result_value)

Line 1428: between fnd_date.date_to_canonical(l_accrued_start_date)

1424: and paa.assignment_id = p_assignment_id
1425: and prr.element_type_id = l_fr_pay_r_info.pay_reg_element_id
1426: and prr.status in ('P','PA')
1427: and prrv_accrual.result_value
1428: between fnd_date.date_to_canonical(l_accrued_start_date)
1429: and fnd_date.date_to_canonical(l_accrued_end_date);
1430: --
1431: --
1432: -- Cursor to fetch regularised payments on termination

Line 1429: and fnd_date.date_to_canonical(l_accrued_end_date);

1425: and prr.element_type_id = l_fr_pay_r_info.pay_reg_element_id
1426: and prr.status in ('P','PA')
1427: and prrv_accrual.result_value
1428: between fnd_date.date_to_canonical(l_accrued_start_date)
1429: and fnd_date.date_to_canonical(l_accrued_end_date);
1430: --
1431: --
1432: -- Cursor to fetch regularised payments on termination
1433: Cursor csr_fetch_term_reg_pymts IS

Line 1467: between fnd_date.date_to_canonical(l_accrued_start_date)

1463: and paa.action_sequence <= nvl(l_action_sequence, paa.action_sequence)
1464: and paa.assignment_id = p_assignment_id
1465: and prr.element_type_id = petf.element_type_id
1466: and prrv_accrual.result_value
1467: between fnd_date.date_to_canonical(l_accrued_start_date)
1468: and fnd_date.date_to_canonical(l_accrued_end_date);
1469:
1470: -- Cursor to check whether user has opted for regularization
1471: Cursor csr_reg_option_flg IS

Line 1468: and fnd_date.date_to_canonical(l_accrued_end_date);

1464: and paa.assignment_id = p_assignment_id
1465: and prr.element_type_id = petf.element_type_id
1466: and prrv_accrual.result_value
1467: between fnd_date.date_to_canonical(l_accrued_start_date)
1468: and fnd_date.date_to_canonical(l_accrued_end_date);
1469:
1470: -- Cursor to check whether user has opted for regularization
1471: Cursor csr_reg_option_flg IS
1472: Select nvl(INFORMATION30, 'N') reg_flg

Line 1674: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)

1670: and paa.action_sequence <= nvl(l_action_sequence, paa.action_sequence)
1671: and paa.assignment_id = p_assignment_id
1672: and prr.element_type_id = petf.element_type_id
1673: and prr.status in ('P','PA')
1674: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
1675: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
1676:
1677: --
1678: -- Get the payments made for all absences in this accrual year. (NOT regularization payments)

Line 1675: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);

1671: and paa.assignment_id = p_assignment_id
1672: and prr.element_type_id = petf.element_type_id
1673: and prr.status in ('P','PA')
1674: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
1675: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
1676:
1677: --
1678: -- Get the payments made for all absences in this accrual year. (NOT regularization payments)
1679: --

Line 1700: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)

1696: and paa.action_sequence <= nvl(l_action_sequence, paa.action_sequence)
1697: and paa.assignment_id = p_assignment_id
1698: and prr.element_type_id = l_fr_pay_info.pay_reg_element_id
1699: and prr.status in ('P','PA')
1700: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
1701: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
1702:
1703: --
1704: -- Get the payments made for all absences in this accrual year. (NOT regularization payments)

Line 1701: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);

1697: and paa.assignment_id = p_assignment_id
1698: and prr.element_type_id = l_fr_pay_info.pay_reg_element_id
1699: and prr.status in ('P','PA')
1700: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
1701: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
1702:
1703: --
1704: -- Get the payments made for all absences in this accrual year. (NOT regularization payments)
1705: --

Line 1729: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)

1725: and prr.element_type_id = l_fr_pay_info.pay_element_id
1726: and prr.status in ('P','PA')
1727: and prrv_plan.result_value = p_accrual_plan_id
1728: and paa.action_sequence <= l_action_sequence
1729: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
1730: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
1731: CURSOR csr_fetch_all_paid_absences_r is
1732: select sum(prrv_days.result_value), sum(prrv_pay.result_value)
1733: from pay_run_result_values prrv_days

Line 1730: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);

1726: and prr.status in ('P','PA')
1727: and prrv_plan.result_value = p_accrual_plan_id
1728: and paa.action_sequence <= l_action_sequence
1729: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
1730: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
1731: CURSOR csr_fetch_all_paid_absences_r is
1732: select sum(prrv_days.result_value), sum(prrv_pay.result_value)
1733: from pay_run_result_values prrv_days
1734: ,pay_run_result_values prrv_pay

Line 1753: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)

1749: and prr.element_type_id = l_fr_pay_r_info.pay_element_id
1750: and prr.status in ('P','PA')
1751: and prrv_plan.result_value = p_accrual_plan_id
1752: and paa.action_sequence <= l_action_sequence
1753: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
1754: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
1755: CURSOR csr_action_sequence_all_paid is
1756: select max(paa.action_sequence)
1757: from pay_assignment_actions paa

Line 1754: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);

1750: and prr.status in ('P','PA')
1751: and prrv_plan.result_value = p_accrual_plan_id
1752: and paa.action_sequence <= l_action_sequence
1753: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
1754: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
1755: CURSOR csr_action_sequence_all_paid is
1756: select max(paa.action_sequence)
1757: from pay_assignment_actions paa
1758: ,pay_payroll_Actions ppa

Line 2685: scr_valuetbl(l_index) := fnd_date.date_to_displaydate(l_accrual_date);

2681: --
2682: l_index := l_index + 1;
2683: inp_value_id_tbl(l_index) := l_type_accrual_date_iv_id;
2684: l_accrual_date := l_fr_plan_info.accrual_year_end;
2685: scr_valuetbl(l_index) := fnd_date.date_to_displaydate(l_accrual_date);
2686: --
2687: -- The Accrual Plan ID will always be present
2688: --
2689: l_index := l_index + 1;

Line 3344: and pevdate.screen_entry_value between fnd_date.date_to_canonical(c_start_date) and fnd_date.date_to_canonical(c_end_date)

3340: and pevdate.input_value_id = c_type_accrual_date_iv_id
3341: and pee.element_entry_id = pevm.element_entry_id
3342: and pee.element_entry_id = pevp.element_entry_id
3343: and pee.element_entry_id = pevdate.element_entry_id
3344: and pevdate.screen_entry_value between fnd_date.date_to_canonical(c_start_date) and fnd_date.date_to_canonical(c_end_date)
3345: and pee.assignment_id = p_assignment_id ;
3346: --
3347: begin
3348: hr_utility.set_location('Entering ' || l_proc,10);

Line 3364: l_inputs(2).value := fnd_date.date_to_canonical(p_calculation_date);

3360: --
3361: l_inputs(1).name := 'ASSIGNMENT_ID';
3362: l_inputs(1).value := p_assignment_id;
3363: l_inputs(2).name := 'DATE_EARNED';
3364: l_inputs(2).value := fnd_date.date_to_canonical(p_calculation_date);
3365: l_inputs(3).name := 'ACCRUAL_PLAN_ID';
3366: l_inputs(3).value := p_plan_id;
3367: l_inputs(4).name := 'BUSINESS_GROUP_ID';
3368: l_inputs(4).value := p_business_group_id;

Line 3372: l_inputs(6).value := fnd_date.date_to_canonical(p_calculation_date);

3368: l_inputs(4).value := p_business_group_id;
3369: l_inputs(5).name := 'PAYROLL_ID';
3370: l_inputs(5).value := p_payroll_id;
3371: l_inputs(6).name := 'CALCULATION_DATE';
3372: l_inputs(6).value := fnd_date.date_to_canonical(p_calculation_date);
3373: l_inputs(7).name := 'ACCRUAL_START_DATE';
3374: l_inputs(7).value := fnd_date.date_to_canonical(p_accrual_start_date);
3375: l_inputs(8).name := 'ASSIGNMENT_ACTION_ID';
3376: l_inputs(8).value := p_assignment_action_id;

Line 3374: l_inputs(7).value := fnd_date.date_to_canonical(p_accrual_start_date);

3370: l_inputs(5).value := p_payroll_id;
3371: l_inputs(6).name := 'CALCULATION_DATE';
3372: l_inputs(6).value := fnd_date.date_to_canonical(p_calculation_date);
3373: l_inputs(7).name := 'ACCRUAL_START_DATE';
3374: l_inputs(7).value := fnd_date.date_to_canonical(p_accrual_start_date);
3375: l_inputs(8).name := 'ASSIGNMENT_ACTION_ID';
3376: l_inputs(8).value := p_assignment_action_id;
3377: l_inputs(9).name := 'ACCRUAL_LATEST_BALANCE';
3378: l_inputs(9).value := p_accrual_latest_balance;

Line 3392: p_effective_start_date := fnd_date.canonical_to_date(l_outputs(2).value);

3388: p_outputs => l_outputs);
3389:
3390:
3391: p_total_accrued_pto := fnd_number.canonical_to_number(l_outputs(1).value);
3392: p_effective_start_date := fnd_date.canonical_to_date(l_outputs(2).value);
3393: p_effective_end_date := fnd_date.canonical_to_date(l_outputs(3).value);
3394: p_accrual_end_date := fnd_date.canonical_to_date(l_outputs(4).value);
3395: P_total_Accrued_protected := per_formula_functions.get_number('TOTAL_ACCRUED_PTO_PROTECTED');
3396: P_total_Accrued_seniority := per_formula_functions.get_number('TOTAL_ACCRUED_PTO_SENIORITY');

Line 3393: p_effective_end_date := fnd_date.canonical_to_date(l_outputs(3).value);

3389:
3390:
3391: p_total_accrued_pto := fnd_number.canonical_to_number(l_outputs(1).value);
3392: p_effective_start_date := fnd_date.canonical_to_date(l_outputs(2).value);
3393: p_effective_end_date := fnd_date.canonical_to_date(l_outputs(3).value);
3394: p_accrual_end_date := fnd_date.canonical_to_date(l_outputs(4).value);
3395: P_total_Accrued_protected := per_formula_functions.get_number('TOTAL_ACCRUED_PTO_PROTECTED');
3396: P_total_Accrued_seniority := per_formula_functions.get_number('TOTAL_ACCRUED_PTO_SENIORITY');
3397: P_total_Accrued_mothers := per_formula_functions.get_number('TOTAL_ACCRUED_PTO_MOTHERS');

Line 3394: p_accrual_end_date := fnd_date.canonical_to_date(l_outputs(4).value);

3390:
3391: p_total_accrued_pto := fnd_number.canonical_to_number(l_outputs(1).value);
3392: p_effective_start_date := fnd_date.canonical_to_date(l_outputs(2).value);
3393: p_effective_end_date := fnd_date.canonical_to_date(l_outputs(3).value);
3394: p_accrual_end_date := fnd_date.canonical_to_date(l_outputs(4).value);
3395: P_total_Accrued_protected := per_formula_functions.get_number('TOTAL_ACCRUED_PTO_PROTECTED');
3396: P_total_Accrued_seniority := per_formula_functions.get_number('TOTAL_ACCRUED_PTO_SENIORITY');
3397: P_total_Accrued_mothers := per_formula_functions.get_number('TOTAL_ACCRUED_PTO_MOTHERS');
3398: P_total_Accrued_conventional := per_formula_functions.get_number('TOTAL_ACCRUED_PTO_CONVENTIONAL');

Line 3462: l_inputs(2).value := fnd_date.date_to_canonical(p_calculation_date);

3458: --
3459: l_inputs(1).name := 'ASSIGNMENT_ID';
3460: l_inputs(1).value := p_assignment_id;
3461: l_inputs(2).name := 'CALCULATION_DATE';
3462: l_inputs(2).value := fnd_date.date_to_canonical(p_calculation_date);
3463: l_inputs(3).name := 'LEGAL_PERIOD';
3464: -- hard coding the legal period
3465: l_inputs(3).value := 6;
3466: --

Line 3479: l_inputs(9).value := fnd_date.date_to_canonical(p_legal_period_start_date);

3475: l_inputs(8).name := 'MAIN_PROTECTED_DAYS';
3476: l_inputs(8).value := l_protected_days;
3477: l_inputs(9).name := 'LEGAL_PERIOD_START_DATE';
3478: -- modified input values and value name
3479: l_inputs(9).value := fnd_date.date_to_canonical(p_legal_period_start_date);
3480: l_inputs(10).name := 'HOLIDAY_PERIOD_START_DATE';
3481: l_inputs(10).value := fnd_date.date_to_canonical(add_months(l_main_accrual_year_start,l_main_entitlement_offset));
3482: l_inputs(11).name := 'HOLIDAY_PERIOD';
3483: l_inputs(11).value := l_main_entitlement_duration;

Line 3481: l_inputs(10).value := fnd_date.date_to_canonical(add_months(l_main_accrual_year_start,l_main_entitlement_offset));

3477: l_inputs(9).name := 'LEGAL_PERIOD_START_DATE';
3478: -- modified input values and value name
3479: l_inputs(9).value := fnd_date.date_to_canonical(p_legal_period_start_date);
3480: l_inputs(10).name := 'HOLIDAY_PERIOD_START_DATE';
3481: l_inputs(10).value := fnd_date.date_to_canonical(add_months(l_main_accrual_year_start,l_main_entitlement_offset));
3482: l_inputs(11).name := 'HOLIDAY_PERIOD';
3483: l_inputs(11).value := l_main_entitlement_duration;
3484:
3485:

Line 3780: and paa.abs_information1 between fnd_date.date_to_canonical(p_accrual_year_start)

3776: where element_type_id = p_holiday_element_id
3777: )
3778: and pee.creator_type = 'A'
3779: and paa.absence_Attendance_id = pee.creator_id
3780: and paa.abs_information1 between fnd_date.date_to_canonical(p_accrual_year_start)
3781: and fnd_date.date_to_canonical(p_accrual_year_end)
3782: and pee.assignment_id = p_assignment_id;
3783:
3784: l_proc VARCHAR2(72) := g_package||' Get_fr_holidays_booked_list ';

Line 3781: and fnd_date.date_to_canonical(p_accrual_year_end)

3777: )
3778: and pee.creator_type = 'A'
3779: and paa.absence_Attendance_id = pee.creator_id
3780: and paa.abs_information1 between fnd_date.date_to_canonical(p_accrual_year_start)
3781: and fnd_date.date_to_canonical(p_accrual_year_end)
3782: and pee.assignment_id = p_assignment_id;
3783:
3784: l_proc VARCHAR2(72) := g_package||' Get_fr_holidays_booked_list ';
3785:

Line 4118: and pevd.screen_entry_value between fnd_date.date_to_canonical(p_accrual_start_date)

4114: from pay_element_entry_values_f pevd
4115: ,pay_element_entries_f pee
4116: where pevd.input_value_id = p_ent_accrual_date_iv_id
4117: and pee.element_entry_id = pevd.element_entry_id
4118: and pevd.screen_entry_value between fnd_date.date_to_canonical(p_accrual_start_date)
4119: and fnd_date.date_to_canonical(p_accrual_end_Date)
4120: and pee.assignment_id = p_assignment_id;
4121: --
4122: BEGIN

Line 4119: and fnd_date.date_to_canonical(p_accrual_end_Date)

4115: ,pay_element_entries_f pee
4116: where pevd.input_value_id = p_ent_accrual_date_iv_id
4117: and pee.element_entry_id = pevd.element_entry_id
4118: and pevd.screen_entry_value between fnd_date.date_to_canonical(p_accrual_start_date)
4119: and fnd_date.date_to_canonical(p_accrual_end_Date)
4120: and pee.assignment_id = p_assignment_id;
4121: --
4122: BEGIN
4123: hr_utility.set_location('Entering ' || l_proc,10);

Line 4195: and pevd.screen_entry_value between fnd_date.date_to_canonical(p_accrual_start_date)

4191: and pevs.input_value_id = p_sal_input_id
4192: and pee.element_entry_id = pevn.element_entry_id
4193: and pee.element_entry_id = pevs.element_entry_id
4194: and pee.element_entry_id = pevd.element_entry_id
4195: and pevd.screen_entry_value between fnd_date.date_to_canonical(p_accrual_start_date)
4196: and fnd_date.date_to_canonical(p_accrual_end_Date)
4197: and pee.assignment_id = p_assignment_id;
4198:
4199: l_fr_plan_info g_fr_plan_info;

Line 4196: and fnd_date.date_to_canonical(p_accrual_end_Date)

4192: and pee.element_entry_id = pevn.element_entry_id
4193: and pee.element_entry_id = pevs.element_entry_id
4194: and pee.element_entry_id = pevd.element_entry_id
4195: and pevd.screen_entry_value between fnd_date.date_to_canonical(p_accrual_start_date)
4196: and fnd_date.date_to_canonical(p_accrual_end_Date)
4197: and pee.assignment_id = p_assignment_id;
4198:
4199: l_fr_plan_info g_fr_plan_info;
4200:

Line 4828: ,fnd_date.canonical_to_date(abs.abs_information1) /* date accrued */

4824: CURSOR csr_get_abs_detail(c_element_entry_id in number) is
4825: select pee.effective_start_date
4826: ,pee.effective_end_date
4827: ,abs.absence_attendance_id
4828: ,fnd_date.canonical_to_date(abs.abs_information1) /* date accrued */
4829: ,abs.abs_information2 /* main days */
4830: ,abs.abs_information3 /* seniority */
4831: ,abs.abs_information4 /* young mothers */
4832: ,abs.abs_information5 /* conventional days */

Line 5018: AND fnd_date.date_to_canonical(p_date_earned)

5014: WHERE p_date_earned BETWEEN assign.effective_start_date AND assign.effective_end_date
5015: AND assign.assignment_id = p_assignment_id
5016: AND assign.establishment_id = target.organization_id
5017: AND target.org_information_context = 'FR_ESTAB_ACCRUAL_RATE'
5018: AND fnd_date.date_to_canonical(p_date_earned)
5019: BETWEEN target.org_information1
5020: AND nvl(target.org_information2, '4712/12/31 00:00:00');
5021:
5022: --

Line 5041: AND fnd_date.date_to_canonical(p_date_earned)

5037: AND assign.establishment_id = estab.organization_id
5038: AND target.organization_id = comp.organization_id
5039: AND estab.org_information1 = to_char(comp.organization_id)
5040: AND target.org_information_context = 'FR_COMP_ACCRUAL_RATE'
5041: AND fnd_date.date_to_canonical(p_date_earned)
5042: BETWEEN target.org_information1
5043: AND nvl(target.org_information2, '4712/12/31 00:00:00');
5044:
5045: begin

Line 5821: and fnd_date.date_to_canonical (paa.date_start) between fnd_date.date_to_canonical(p_start_date) and fnd_date.date_to_canonical(p_end_date)

5817: ,pay_element_entries_f pee
5818: ,per_absence_attendance_types pat
5819: where pee.creator_type = 'A'
5820: and paa.absence_attendance_id = pee.creator_id
5821: and fnd_date.date_to_canonical (paa.date_start) between fnd_date.date_to_canonical(p_start_date) and fnd_date.date_to_canonical(p_end_date)
5822: and pee.assignment_id = p_assignment_id
5823: and paa.absence_attendance_type_id = pat.absence_attendance_type_id
5824: and pat.absence_category = 'S';
5825: --

Line 5838: and fnd_date.date_to_canonical(paa.date_start) between fnd_date.date_to_canonical(p_start_date)

5834: where element_type_id = p_holiday_Element_id
5835: )
5836: and pee.creator_type = 'A'
5837: and paa.absence_Attendance_id = pee.creator_id
5838: and fnd_date.date_to_canonical(paa.date_start) between fnd_date.date_to_canonical(p_start_date)
5839: and fnd_date.date_to_canonical(p_end_date)
5840: and pee.assignment_id = p_assignment_id;
5841:
5842: l_proc VARCHAR2(72) := g_package||' Check_fr_holidays_booked ';

Line 5839: and fnd_date.date_to_canonical(p_end_date)

5835: )
5836: and pee.creator_type = 'A'
5837: and paa.absence_Attendance_id = pee.creator_id
5838: and fnd_date.date_to_canonical(paa.date_start) between fnd_date.date_to_canonical(p_start_date)
5839: and fnd_date.date_to_canonical(p_end_date)
5840: and pee.assignment_id = p_assignment_id;
5841:
5842: l_proc VARCHAR2(72) := g_package||' Check_fr_holidays_booked ';
5843: --

Line 5921: and fnd_date.date_to_canonical(paa.date_start) >= fnd_date.date_to_canonical(p_start_date)

5917: where element_type_id = p_holiday_element_id
5918: )
5919: and pee.creator_type = 'A'
5920: and paa.absence_Attendance_id = pee.creator_id
5921: and fnd_date.date_to_canonical(paa.date_start) >= fnd_date.date_to_canonical(p_start_date)
5922: and fnd_date.date_to_canonical(paa.date_end) <= fnd_date.date_to_canonical(p_end_date)
5923: and paa.absence_days >= p_no_absences
5924: and pee.assignment_id = p_assignment_id;
5925:

Line 5922: and fnd_date.date_to_canonical(paa.date_end) <= fnd_date.date_to_canonical(p_end_date)

5918: )
5919: and pee.creator_type = 'A'
5920: and paa.absence_Attendance_id = pee.creator_id
5921: and fnd_date.date_to_canonical(paa.date_start) >= fnd_date.date_to_canonical(p_start_date)
5922: and fnd_date.date_to_canonical(paa.date_end) <= fnd_date.date_to_canonical(p_end_date)
5923: and paa.absence_days >= p_no_absences
5924: and pee.assignment_id = p_assignment_id;
5925:
5926: