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

Line 264: sivanara 17-Jun-2008 115.70 7185703 Removed fnd_date function from the cursor

260: to archive_data cursor, so that
261: archive data is only for "Employee"
262: sivanara 25-Apr-2008 115.68 6960481 Added new parameter to event_qualified
263: to filter out applicant event.
264: sivanara 17-Jun-2008 115.70 7185703 Removed fnd_date function from the cursor
265: csr_get_asg_end_date and csr_per_gre.
266: sivanara 20-Aug-2008 115.71 7341327 For the cursor csr_per_gre added condition
267: for applicant.
268: swamukhi 01-Oct-2008 115.72 6451017 For the cursor csr_per_gre added a condition

Line 374: AND fnd_date.canonical_to_date(p_effective_date)

370:
371: SELECT per.current_applicant_flag
372: FROM per_all_people_f per
373: WHERE per.person_id = p_person_id
374: AND fnd_date.canonical_to_date(p_effective_date)
375: BETWEEN per.effective_start_date AND per.effective_end_date;
376:
377:
378: l_return BOOLEAN;

Line 388: fnd_date.date_to_canonical(p_effective_date));

384: l_proc_name := gv_package || 'event_qualified';
385: hr_utility_trace ('Entering '||l_proc_name);
386: hr_utility_trace ('p_assignment_id = '||p_assignment_id);
387: hr_utility_trace ('p_effective_date = '||
388: fnd_date.date_to_canonical(p_effective_date));
389: hr_utility_trace ('p_gre_id = '||p_gre_id);
390:
391: l_return := FALSE;
392: -- Check if assignment is cached.

Line 441: OPEN c_check_per_status(p_person_id, fnd_date.date_to_canonical(p_effective_date));

437: END IF;
438: END LOOP;
439: END IF;
440: hr_utility_trace('Checking for applicant record');
441: OPEN c_check_per_status(p_person_id, fnd_date.date_to_canonical(p_effective_date));
442: FETCH c_check_per_status INTO lv_chk_emp_status;
443: CLOSE c_check_per_status;
444:
445: IF lv_chk_emp_status = 'Y' THEN

Line 511: SELECT fnd_date.canonical_to_date(org_information6)

507: ORDER BY ppa.payroll_action_id desc ;
508:
509:
510: CURSOR c_get_imp_date(cp_organization_id IN NUMBER) IS
511: SELECT fnd_date.canonical_to_date(org_information6)
512: FROM hr_organization_information
513: WHERE org_information_context = 'MX_TAX_REGISTRATION'
514: AND organization_id = cp_organization_id ;
515:

Line 558: lv_start_date := fnd_date.date_to_canonical( ld_start_date );

554: fetched above is equal to hr_api.g_sot */
555:
556: IF NVL( ld_start_date, hr_api.g_sot ) <> hr_api.g_sot THEN
557:
558: lv_start_date := fnd_date.date_to_canonical( ld_start_date );
559:
560: ELSE
561:
562: IF p_gre_id IS NOT NULL THEN

Line 593: ld_report_imp_date := fnd_date.canonical_to_date(

589: IF c_get_imp_date%NOTFOUND OR ld_report_imp_date is NULL THEN
590:
591: -- defaulting to Report Implementation Date from
592: -- mx pay legislation info table
593: ld_report_imp_date := fnd_date.canonical_to_date(
594: pay_mx_utility.get_default_imp_date) ;
595:
596: END IF;
597:

Line 610: lv_start_date := fnd_date.date_to_canonical(ld_report_imp_date);

606:
607: IF c_get_start_date%NOTFOUND THEN
608:
609: -- assign the ld_start_date from rep imp date
610: lv_start_date := fnd_date.date_to_canonical(ld_report_imp_date);
611:
612: END IF;
613:
614: CLOSE c_get_start_date;

Line 618: ld_start_date := fnd_date.canonical_to_date(lv_start_date) ;

614: CLOSE c_get_start_date;
615:
616: hr_utility_trace('lv_start_date '||lv_start_date);
617:
618: ld_start_date := fnd_date.canonical_to_date(lv_start_date) ;
619:
620: hr_utility_trace('ld_start_date '||ld_start_date);
621:
622: ELSE

Line 624: SELECT fnd_date.date_to_canonical(sysdate)

620: hr_utility_trace('ld_start_date '||ld_start_date);
621:
622: ELSE
623:
624: SELECT fnd_date.date_to_canonical(sysdate)
625: INTO lv_start_date
626: FROM DUAL;
627:
628: END IF; -- p_gre_id IS NOT NULL

Line 647: SELECT fnd_date.date_to_displaydate( ADD_MONTHS (

643: BEGIN
644:
645: lv_dates := NULL;
646:
647: SELECT fnd_date.date_to_displaydate( ADD_MONTHS (
648: fnd_date.canonical_to_date( p_date ), -1 ) ) || ' - ' ||
649: fnd_date.date_to_displaydate( ADD_MONTHS (
650: fnd_date.canonical_to_date( p_date ), 1 ) -1 )
651: INTO lv_dates

Line 648: fnd_date.canonical_to_date( p_date ), -1 ) ) || ' - ' ||

644:
645: lv_dates := NULL;
646:
647: SELECT fnd_date.date_to_displaydate( ADD_MONTHS (
648: fnd_date.canonical_to_date( p_date ), -1 ) ) || ' - ' ||
649: fnd_date.date_to_displaydate( ADD_MONTHS (
650: fnd_date.canonical_to_date( p_date ), 1 ) -1 )
651: INTO lv_dates
652: FROM dual;

Line 649: fnd_date.date_to_displaydate( ADD_MONTHS (

645: lv_dates := NULL;
646:
647: SELECT fnd_date.date_to_displaydate( ADD_MONTHS (
648: fnd_date.canonical_to_date( p_date ), -1 ) ) || ' - ' ||
649: fnd_date.date_to_displaydate( ADD_MONTHS (
650: fnd_date.canonical_to_date( p_date ), 1 ) -1 )
651: INTO lv_dates
652: FROM dual;
653:

Line 650: fnd_date.canonical_to_date( p_date ), 1 ) -1 )

646:
647: SELECT fnd_date.date_to_displaydate( ADD_MONTHS (
648: fnd_date.canonical_to_date( p_date ), -1 ) ) || ' - ' ||
649: fnd_date.date_to_displaydate( ADD_MONTHS (
650: fnd_date.canonical_to_date( p_date ), 1 ) -1 )
651: INTO lv_dates
652: FROM dual;
653:
654: RETURN lv_dates;

Line 720: IF TRUNC(fnd_date.canonical_to_date(lv_end_date)) -

716: hr_utility.set_location(gv_package || lv_procedure_name, 30);
717:
718: IF lv_periodic_end_date IS NOT NULL THEN
719:
720: IF TRUNC(fnd_date.canonical_to_date(lv_end_date)) -
721: TRUNC(fnd_date.canonical_to_date(lv_periodic_end_date)) >= 1 THEN
722:
723: gv_periodic_end_date :=
724: to_char(fnd_date.canonical_to_date(lv_periodic_end_date)

Line 721: TRUNC(fnd_date.canonical_to_date(lv_periodic_end_date)) >= 1 THEN

717:
718: IF lv_periodic_end_date IS NOT NULL THEN
719:
720: IF TRUNC(fnd_date.canonical_to_date(lv_end_date)) -
721: TRUNC(fnd_date.canonical_to_date(lv_periodic_end_date)) >= 1 THEN
722:
723: gv_periodic_end_date :=
724: to_char(fnd_date.canonical_to_date(lv_periodic_end_date)
725: , 'YYYY/MM/DD') ||' 23:59:59';

Line 724: to_char(fnd_date.canonical_to_date(lv_periodic_end_date)

720: IF TRUNC(fnd_date.canonical_to_date(lv_end_date)) -
721: TRUNC(fnd_date.canonical_to_date(lv_periodic_end_date)) >= 1 THEN
722:
723: gv_periodic_end_date :=
724: to_char(fnd_date.canonical_to_date(lv_periodic_end_date)
725: , 'YYYY/MM/DD') ||' 23:59:59';
726:
727: ELSE
728:

Line 730: to_char(fnd_date.canonical_to_date(lv_periodic_end_date)

726:
727: ELSE
728:
729: gv_periodic_end_date :=
730: to_char(fnd_date.canonical_to_date(lv_periodic_end_date)
731: , 'YYYY/MM/DD') ||' '||
732: to_char(fnd_date.canonical_to_date(lv_end_date)
733: , 'HH24:MI:SS');
734:

Line 732: to_char(fnd_date.canonical_to_date(lv_end_date)

728:
729: gv_periodic_end_date :=
730: to_char(fnd_date.canonical_to_date(lv_periodic_end_date)
731: , 'YYYY/MM/DD') ||' '||
732: to_char(fnd_date.canonical_to_date(lv_end_date)
733: , 'HH24:MI:SS');
734:
735: END IF;
736:

Line 755: fnd_date.date_to_canonical(

751:
752: IF gv_mode = 'P' THEN
753:
754: gv_periodic_start_date :=
755: fnd_date.date_to_canonical(
756: TRUNC(add_months(fnd_date.canonical_to_date(
757: lv_periodic_end_date),-2)+1));
758:
759: ELSE

Line 756: TRUNC(add_months(fnd_date.canonical_to_date(

752: IF gv_mode = 'P' THEN
753:
754: gv_periodic_start_date :=
755: fnd_date.date_to_canonical(
756: TRUNC(add_months(fnd_date.canonical_to_date(
757: lv_periodic_end_date),-2)+1));
758:
759: ELSE
760:

Line 1568: fnd_date.canonical_to_date(

1564: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4);
1565:
1566: IF pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category
1567: = 'MX SS TRANSACTIONS' AND
1568: fnd_date.canonical_to_date(
1569: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2) =
1570: p_effective_date AND
1571: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4 = '08'
1572: THEN

Line 1606: 'on '||fnd_date.date_to_canonical(p_effective_date)

1602: fix_var_idw(ln_count).idw_date := p_effective_date;
1603: END IF;
1604: ELSE
1605: hr_utility_trace('Current person is a new hire. 07 effective '||
1606: 'on '||fnd_date.date_to_canonical(p_effective_date)
1607: ||' will not be archived.');
1608: END IF;
1609: END IF;
1610: END cache_IDW_date;

Line 1647: fnd_date.date_to_canonical(p_effective_date));

1643: hr_utility_trace('element entry id '||
1644: ln_element_entry_id||' has following IDW info: -');
1645: hr_utility_trace('IDW type = '||lv_idw_type);
1646: hr_utility_trace('IDW effective date = '||
1647: fnd_date.date_to_canonical(p_effective_date));
1648: ELSE
1649: hr_utility_trace('element entry id '||
1650: ln_element_entry_id||' has no IDW information.');
1651: END IF;

Line 1779: trn(ln_trn_cnt).date := fnd_date.date_to_canonical(

1775: IF p_iv_name = c_infonavit_info_rec.name AND
1776: p_screen_entry_value <> c_infonavit_info_rec.screen_entry_value
1777: THEN
1778: trn(ln_trn_cnt).type := p_tran_type;
1779: trn(ln_trn_cnt).date := fnd_date.date_to_canonical(
1780: p_effective_end_date + 1);
1781: hr_utility_trace('Transaction '|| p_tran_type ||' found.');
1782: lb_tran_found := TRUE;
1783: EXIT;

Line 1823: prev_eff_date := fnd_date.canonical_to_date('0001/01/01');

1819: ln_step := 1;
1820:
1821: fix_var_idw.DELETE;
1822: fix_var_idw_uniq.DELETE;
1823: prev_eff_date := fnd_date.canonical_to_date('0001/01/01');
1824:
1825: hr_utility.set_location(gv_package || lv_procedure_name, 910);
1826: ln_step := 91;
1827:

Line 1845: fnd_date.date_to_canonical(ld_effective_date));

1841: LOOP
1842: FETCH c_IDW_events INTO ld_effective_date;
1843: EXIT WHEN c_IDW_events%NOTFOUND;
1844: hr_utility_trace('Timestamp of IDW table update event = '||
1845: fnd_date.date_to_canonical(ld_effective_date));
1846: parse_all_ele_entries (ld_effective_date);
1847: END LOOP;
1848: CLOSE c_IDW_events;
1849:

Line 1862: ' = '||fnd_date.date_to_canonical(ld_hire_anniversary));

1858: ld_hire_anniversary := hr_mx_utility.get_hire_anniversary(
1859: p_person_id,
1860: p_end_date);
1861: hr_utility_trace ('Hire anniversary date of person '||p_person_id||
1862: ' = '||fnd_date.date_to_canonical(ld_hire_anniversary));
1863:
1864: -- Calculate anniversary date in current year
1865: SELECT ADD_MONTHS (TRUNC (p_end_date, 'Y'),
1866: MONTHS_BETWEEN (ld_hire_anniversary,

Line 1875: fnd_date.date_to_canonical(ld_anniversary_date));

1871: FROM dual;
1872:
1873: hr_utility_trace ('Anniversary date of person '||p_person_id||
1874: ' in the year of archiver run = '||
1875: fnd_date.date_to_canonical(ld_anniversary_date));
1876:
1877: parse_all_ele_entries (ld_anniversary_date);
1878: END IF; -- seniority_changed?
1879: END IF; -- gv_IDW_calc_method = 'B'

Line 1995: trn(ln_trn_cnt).abs_start_date := fnd_date.date_to_canonical(

1991:
1992: trn(ln_trn_cnt).type := '12';
1993: --trn(ln_trn_cnt).dis_insurance_type := lv_disability_type;
1994: trn(ln_trn_cnt).dis_num := lv_disability_id;
1995: trn(ln_trn_cnt).abs_start_date := fnd_date.date_to_canonical(
1996: ld_date_start);
1997: trn(ln_trn_cnt).abs_end_date := fnd_date.date_to_canonical(
1998: ld_date_end);
1999:

Line 1997: trn(ln_trn_cnt).abs_end_date := fnd_date.date_to_canonical(

1993: --trn(ln_trn_cnt).dis_insurance_type := lv_disability_type;
1994: trn(ln_trn_cnt).dis_num := lv_disability_id;
1995: trn(ln_trn_cnt).abs_start_date := fnd_date.date_to_canonical(
1996: ld_date_start);
1997: trn(ln_trn_cnt).abs_end_date := fnd_date.date_to_canonical(
1998: ld_date_end);
1999:
2000: OPEN c_disabilities_info (lv_disability_id);
2001: FETCH c_disabilities_info

Line 2021: trn(ln_trn_cnt).date := fnd_date.date_to_canonical(ld_date_start);

2017: trn(ln_trn_cnt).dis_num := NULL;
2018:
2019: END IF;
2020:
2021: trn(ln_trn_cnt).date := fnd_date.date_to_canonical(ld_date_start);
2022:
2023: trn(ln_trn_cnt).abs_days := ln_absence_days;
2024: trn(ln_trn_cnt).idw_vol_contr := NULL;
2025: trn(ln_trn_cnt).salary_type := NULL;

Line 2132: trn (ln_trn_cnt).date := fnd_date.date_to_canonical (

2128: IF ln_next_element_entry_id = -1 THEN
2129:
2130: ln_trn_cnt := trn.count();
2131: trn (ln_trn_cnt).type := '16';
2132: trn (ln_trn_cnt).date := fnd_date.date_to_canonical (
2133: infonavit.effective_end_date);
2134:
2135: load_infonavit_info (p_assignment_id
2136: ,ln_element_entry_id

Line 2167: fnd_date.date_to_canonical(

2163:
2164: -- gv_credit_start_date is already in canonical date format.
2165:
2166: trn(ln_trn_cnt).date := nvl(gv_credit_start_date,
2167: fnd_date.date_to_canonical(
2168: infonavit.effective_start_date));
2169:
2170: load_infonavit_info (p_assignment_id
2171: ,ln_element_entry_id

Line 2278: fnd_date.date_to_canonical(fix_var_idw(i).idw_date);

2274: ln_trn_cnt := trn.COUNT;
2275:
2276: trn(ln_trn_cnt).type := '07';
2277: trn(ln_trn_cnt).date :=
2278: fnd_date.date_to_canonical(fix_var_idw(i).idw_date);
2279: trn(ln_trn_cnt).dis_num := NULL;
2280: trn(ln_trn_cnt).abs_days := NULL;
2281:
2282: IF fix_var_idw(i).idw_type = 'FIXED' THEN

Line 2303: fnd_date.canonical_to_date(gv_periodic_end_date) + 1

2299:
2300: ln_idw := get_idw( p_assignment_id => p_assignment_id
2301: ,p_tax_unit_id => p_gre_id
2302: ,p_effective_date =>
2303: fnd_date.canonical_to_date(gv_periodic_end_date) + 1
2304: ,p_fixed_idw => ln_fixed_idw
2305: ,p_variable_idw => ln_variable_idw );
2306:
2307: hr_utility.trace('SS_ARCH other TRN VARIABLE ln_idw: '||ln_idw);

Line 2320: fnd_date.date_to_canonical(

2316: ln_trn_cnt := trn.COUNT;
2317:
2318: trn(ln_trn_cnt).type := '07';
2319: trn(ln_trn_cnt).date :=
2320: fnd_date.date_to_canonical(
2321: trunc(fnd_date.canonical_to_date(gv_periodic_end_date)) + 1);
2322: trn(ln_trn_cnt).dis_num := NULL;
2323: trn(ln_trn_cnt).abs_days := NULL;
2324: trn(ln_trn_cnt).idw_vol_contr := ln_idw;

Line 2321: trunc(fnd_date.canonical_to_date(gv_periodic_end_date)) + 1);

2317:
2318: trn(ln_trn_cnt).type := '07';
2319: trn(ln_trn_cnt).date :=
2320: fnd_date.date_to_canonical(
2321: trunc(fnd_date.canonical_to_date(gv_periodic_end_date)) + 1);
2322: trn(ln_trn_cnt).dis_num := NULL;
2323: trn(ln_trn_cnt).abs_days := NULL;
2324: trn(ln_trn_cnt).idw_vol_contr := ln_idw;
2325: trn(ln_trn_cnt).salary_type := 'VARIABLE';

Line 2356: ,fnd_date.canonical_to_date(trn(i).date));

2352: lv_exclude_end_date := p_exc_end_date;
2353: /*8438074 End*/
2354:
2355: OPEN c_person_detail (p_person_id
2356: ,fnd_date.canonical_to_date(trn(i).date));
2357: FETCH c_person_detail INTO lv_employee_ssn;
2358: CLOSE c_person_detail;
2359:
2360: /*8438074 Begin*/

Line 2362: (fnd_date.canonical_to_date(lv_exclude_start_date)<=fnd_date.canonical_to_date(lv_exclude_end_date)) AND

2358: CLOSE c_person_detail;
2359:
2360: /*8438074 Begin*/
2361: IF (lv_exclude_start_date IS NOT NULL AND lv_exclude_end_date IS NOT NULL) AND
2362: (fnd_date.canonical_to_date(lv_exclude_start_date)<=fnd_date.canonical_to_date(lv_exclude_end_date)) AND
2363: (fnd_date.canonical_to_date(trn(i).date) BETWEEN fnd_date.canonical_to_date(lv_exclude_start_date) AND fnd_date.canonical_to_date(lv_exclude_end_date)) THEN
2364:
2365: lv_do_not_report := 'Y';
2366:

Line 2363: (fnd_date.canonical_to_date(trn(i).date) BETWEEN fnd_date.canonical_to_date(lv_exclude_start_date) AND fnd_date.canonical_to_date(lv_exclude_end_date)) THEN

2359:
2360: /*8438074 Begin*/
2361: IF (lv_exclude_start_date IS NOT NULL AND lv_exclude_end_date IS NOT NULL) AND
2362: (fnd_date.canonical_to_date(lv_exclude_start_date)<=fnd_date.canonical_to_date(lv_exclude_end_date)) AND
2363: (fnd_date.canonical_to_date(trn(i).date) BETWEEN fnd_date.canonical_to_date(lv_exclude_start_date) AND fnd_date.canonical_to_date(lv_exclude_end_date)) THEN
2364:
2365: lv_do_not_report := 'Y';
2366:
2367: ELSE lv_exclude_start_date := NULL;

Line 2525: AND fnd_date.canonical_to_date(aei_information1) = cp_effective_date

2521: SELECT aei_information3
2522: FROM per_assignment_extra_info pae
2523: WHERE pae.assignment_id = cp_assignment_id
2524: AND information_type = 'MX_SS_EMP_TRANS_REASON'
2525: AND fnd_date.canonical_to_date(aei_information1) = cp_effective_date
2526: AND aei_information2 = cp_gre_id ;
2527:
2528: CURSOR c_get_pos_leaving_reason ( cp_assignment_id IN NUMBER
2529: ,cp_effective_date IN DATE ) IS

Line 2593: AND fnd_date.canonical_to_date(p_effective_date)

2589:
2590: SELECT per.current_applicant_flag
2591: FROM per_all_people_f per
2592: WHERE per.person_id = p_person_id
2593: AND fnd_date.canonical_to_date(p_effective_date)
2594: BETWEEN per.effective_start_date AND per.effective_end_date;
2595:
2596: /*bug 6933682*/
2597: CURSOR c_salary_type ( cp_assignment_id IN NUMBER

Line 2807: OPEN c_check_per_status(p_person_id, fnd_date.date_to_canonical(p_asg_events(i).effective_date - 1));

2803: ,p_level => 'I');
2804: END IF;
2805:
2806: hr_utility_trace('Checking wherther the person is applicant');
2807: OPEN c_check_per_status(p_person_id, fnd_date.date_to_canonical(p_asg_events(i).effective_date - 1));
2808: FETCH c_check_per_status INTO lv_check_applicant;
2809:
2810: CLOSE c_check_per_status;
2811:

Line 2813: hr_utility_trace('The person is applicant on effective_date ' || fnd_date.date_to_canonical(p_asg_events(i).effective_date - 1));

2809:
2810: CLOSE c_check_per_status;
2811:
2812: IF lv_check_applicant = 'Y' THEN
2813: hr_utility_trace('The person is applicant on effective_date ' || fnd_date.date_to_canonical(p_asg_events(i).effective_date - 1));
2814: hr_utility_trace('making -9 for the gre that got by location');
2815: ln_old_gre_id := -9;
2816: END IF;
2817:

Line 2876: hr_utility_trace('p_asg_events(i).effective_date - 1 :' || fnd_date.date_to_canonical(p_asg_events(i).effective_date - 1));

2872: hr_utility.set_location(gv_package||lv_procedure_name,120);
2873: ln_step := 12;
2874: hr_utility_trace('Inside get_transaction and sof_coding :');
2875: hr_utility_trace('p_assignment_id :' || p_assignment_id);
2876: hr_utility_trace('p_asg_events(i).effective_date - 1 :' || fnd_date.date_to_canonical(p_asg_events(i).effective_date - 1));
2877: OPEN c_get_asg_loc(p_assignment_id
2878: ,p_asg_events(i).effective_date - 1);
2879:
2880: FETCH c_get_asg_loc

Line 2898: OPEN c_check_per_status(p_person_id, fnd_date.date_to_canonical(p_asg_events(i).effective_date - 1));

2894: ,p_business_group_id
2895: ,lv_old_value
2896: ,p_asg_events(i).effective_date - 1), -9);
2897: hr_utility_trace('Checking wherther the person is applicant');
2898: OPEN c_check_per_status(p_person_id, fnd_date.date_to_canonical(p_asg_events(i).effective_date - 1));
2899: FETCH c_check_per_status INTO lv_check_applicant;
2900:
2901: CLOSE c_check_per_status;
2902:

Line 2904: hr_utility_trace('The person is applicant on effective_date ' || fnd_date.date_to_canonical(p_asg_events(i).effective_date - 1));

2900:
2901: CLOSE c_check_per_status;
2902:
2903: IF lv_check_applicant = 'Y' THEN
2904: hr_utility_trace('The person is applicant on effective_date ' || fnd_date.date_to_canonical(p_asg_events(i).effective_date - 1));
2905: hr_utility_trace('making -9 for the gre that got by location');
2906: ln_old_gre_id := -9;
2907: END IF;
2908:

Line 2927: hr_utility_trace('p_asg_events(i).effective_date :' || fnd_date.date_to_canonical(p_asg_events(i).effective_date ));

2923:
2924: hr_utility.set_location(gv_package||lv_procedure_name,140);
2925: ln_step := 14;
2926: hr_utility_trace('p_assignment_id :' || p_assignment_id);
2927: hr_utility_trace('p_asg_events(i).effective_date :' || fnd_date.date_to_canonical(p_asg_events(i).effective_date ));
2928: OPEN c_get_asg_loc(p_assignment_id
2929: ,p_asg_events(i).effective_date);
2930:
2931: FETCH c_get_asg_loc

Line 3238: fnd_date.date_to_canonical(hire_sep(i).trn_date);

3234: ln_step := 24;
3235:
3236: lv_transaction_type := '08';
3237: lv_transaction_date :=
3238: fnd_date.date_to_canonical(hire_sep(i).trn_date);
3239: lv_leaving_reason := NULL;
3240: hr_utility.trace('lv_transaction_date is: '||lv_transaction_date);
3241: /* Do not archive this transaction if person-GRE relation
3242: already exists prior to transaction date. */

Line 3280: fnd_date.date_to_canonical(hire_sep(i).trn_date);

3276: ln_step := 25;
3277:
3278: lv_transaction_type := '02';
3279: lv_transaction_date :=
3280: fnd_date.date_to_canonical(hire_sep(i).trn_date);
3281:
3282: ld_eff_date := hire_sep(i).trn_date;
3283: lv_idw := NULL;
3284:

Line 3327: ,fnd_date.canonical_to_date

3323: hr_utility.set_location(gv_package || lv_procedure_name, 280);
3324: ln_step := 28;
3325: hr_utility_trace('lv_transaction_date :'|| lv_transaction_date);
3326: OPEN c_person_detail (p_person_id
3327: ,fnd_date.canonical_to_date
3328: (lv_transaction_date));
3329: FETCH c_person_detail INTO lv_employee_ssn;
3330: CLOSE c_person_detail;
3331:

Line 3358: (fnd_date.canonical_to_date(lv_exclude_start_date)<=fnd_date.canonical_to_date(lv_exclude_end_date)) AND

3354: END IF;
3355:
3356: /*8438074 Begin*/
3357: IF (lv_exclude_start_date IS NOT NULL AND lv_exclude_end_date IS NOT NULL) AND
3358: (fnd_date.canonical_to_date(lv_exclude_start_date)<=fnd_date.canonical_to_date(lv_exclude_end_date)) AND
3359: (fnd_date.canonical_to_date(lv_transaction_date) BETWEEN fnd_date.canonical_to_date(lv_exclude_start_date) AND fnd_date.canonical_to_date(lv_exclude_end_date)) THEN
3360:
3361: lv_do_not_report := 'Y';
3362:

Line 3359: (fnd_date.canonical_to_date(lv_transaction_date) BETWEEN fnd_date.canonical_to_date(lv_exclude_start_date) AND fnd_date.canonical_to_date(lv_exclude_end_date)) THEN

3355:
3356: /*8438074 Begin*/
3357: IF (lv_exclude_start_date IS NOT NULL AND lv_exclude_end_date IS NOT NULL) AND
3358: (fnd_date.canonical_to_date(lv_exclude_start_date)<=fnd_date.canonical_to_date(lv_exclude_end_date)) AND
3359: (fnd_date.canonical_to_date(lv_transaction_date) BETWEEN fnd_date.canonical_to_date(lv_exclude_start_date) AND fnd_date.canonical_to_date(lv_exclude_end_date)) THEN
3360:
3361: lv_do_not_report := 'Y';
3362:
3363: ELSE lv_exclude_start_date := NULL;

Line 3767: ,fnd_date.date_to_canonical(ppf.effective_start_date) hire_date

3763: ,ppf.per_information4 medical_center
3764: ,ppf.employee_number worker_id
3765: ,ppf.national_identifier curp
3766: ,ppf.per_information2 tax_rfc_id
3767: ,fnd_date.date_to_canonical(ppf.effective_start_date) hire_date
3768: FROM per_all_people_f ppf
3769: WHERE ppf.person_id = cp_person_id
3770: AND ppf.effective_start_date =
3771: ( SELECT max(ppf_in.effective_start_date)

Line 3926: fnd_date.date_to_canonical(p_end_date));*/

3922: ld_effective_date := ld_asg_start_date;
3923: END IF;
3924: /*ld_effective_date := max (ld_effective_date, p_end_date);
3925: hr_utility_trace('p_end_date = '||
3926: fnd_date.date_to_canonical(p_end_date));*/
3927: hr_utility_trace('ld_asg_start_date = '||
3928: fnd_date.date_to_canonical(ld_asg_start_date));
3929: hr_utility_trace('ld_asg_end_date = '||
3930: fnd_date.date_to_canonical(ld_asg_end_date));

Line 3928: fnd_date.date_to_canonical(ld_asg_start_date));

3924: /*ld_effective_date := max (ld_effective_date, p_end_date);
3925: hr_utility_trace('p_end_date = '||
3926: fnd_date.date_to_canonical(p_end_date));*/
3927: hr_utility_trace('ld_asg_start_date = '||
3928: fnd_date.date_to_canonical(ld_asg_start_date));
3929: hr_utility_trace('ld_asg_end_date = '||
3930: fnd_date.date_to_canonical(ld_asg_end_date));
3931: hr_utility_trace('p_end_date = '||
3932: fnd_date.date_to_canonical(p_end_date));

Line 3930: fnd_date.date_to_canonical(ld_asg_end_date));

3926: fnd_date.date_to_canonical(p_end_date));*/
3927: hr_utility_trace('ld_asg_start_date = '||
3928: fnd_date.date_to_canonical(ld_asg_start_date));
3929: hr_utility_trace('ld_asg_end_date = '||
3930: fnd_date.date_to_canonical(ld_asg_end_date));
3931: hr_utility_trace('p_end_date = '||
3932: fnd_date.date_to_canonical(p_end_date));
3933: hr_utility_trace('ld_effective_date = '||
3934: fnd_date.date_to_canonical(ld_effective_date));

Line 3932: fnd_date.date_to_canonical(p_end_date));

3928: fnd_date.date_to_canonical(ld_asg_start_date));
3929: hr_utility_trace('ld_asg_end_date = '||
3930: fnd_date.date_to_canonical(ld_asg_end_date));
3931: hr_utility_trace('p_end_date = '||
3932: fnd_date.date_to_canonical(p_end_date));
3933: hr_utility_trace('ld_effective_date = '||
3934: fnd_date.date_to_canonical(ld_effective_date));
3935:
3936: OPEN c_person_detail (p_person_id

Line 3934: fnd_date.date_to_canonical(ld_effective_date));

3930: fnd_date.date_to_canonical(ld_asg_end_date));
3931: hr_utility_trace('p_end_date = '||
3932: fnd_date.date_to_canonical(p_end_date));
3933: hr_utility_trace('ld_effective_date = '||
3934: fnd_date.date_to_canonical(ld_effective_date));
3935:
3936: OPEN c_person_detail (p_person_id
3937: ,ld_effective_date);
3938: --,p_effective_date);

Line 4011: lv_end_date := fnd_date.date_to_canonical(

4007: /*OPEN csr_asg_end_date;
4008: FETCH csr_asg_end_date INTO ld_asg_end_date;
4009: CLOSE csr_asg_end_date;
4010:
4011: lv_end_date := fnd_date.date_to_canonical(
4012: LEAST(ld_asg_end_date,
4013: fnd_date.canonical_to_date(lv_end_date)));*/
4014:
4015: SELECT count(*) into ln_check_person_info_exist

Line 4013: fnd_date.canonical_to_date(lv_end_date)));*/

4009: CLOSE csr_asg_end_date;
4010:
4011: lv_end_date := fnd_date.date_to_canonical(
4012: LEAST(ld_asg_end_date,
4013: fnd_date.canonical_to_date(lv_end_date)));*/
4014:
4015: SELECT count(*) into ln_check_person_info_exist
4016: FROM pay_action_information
4017: WHERE action_context_type='AAP'

Line 4021: AND ld_asg_start_date >=fnd_date.canonical_to_date(action_information10);

4017: WHERE action_context_type='AAP'
4018: AND assignment_id = p_assignment_id
4019: AND tax_unit_id = p_gre_id
4020: AND action_information_category = 'MX SS PERSON INFORMATION'
4021: AND ld_asg_start_date >=fnd_date.canonical_to_date(action_information10);
4022:
4023: hr_utility.trace('ln_check_person_info_exist '|| ln_check_person_info_exist);
4024: IF ln_check_person_info_exist > 0 THEN
4025:

Line 4271: AND TRUNC( fnd_date.canonical_to_date (

4267: AND ppa_prev.report_qualifier = 'SS_ARCHIVE'
4268: AND ppa_prev.report_category = 'RT'
4269: AND pay_mx_utility.get_legi_param_val('GRE',
4270: ppa_prev.legislative_parameters) = p_gre_id
4271: AND TRUNC( fnd_date.canonical_to_date (
4272: pay_mx_utility.get_legi_param_val(
4273: 'PERIOD_ENDING_DATE',
4274: ppa_prev.legislative_parameters) ) ) =
4275: TRUNC(p_periodic_end_date)

Line 4400: fnd_date.canonical_to_date (lv_end_date));

4396: END IF;
4397:
4398: gv_IDW_calc_method := get_IDW_calc_method (
4399: ln_gre_id,
4400: fnd_date.canonical_to_date (lv_end_date));
4401:
4402: hr_utility_trace('--> gv_IDW_calc_method : ' || gv_IDW_calc_method );
4403: /*
4404: IF gv_mode = 'P' THEN

Line 4407: fnd_date.date_to_canonical(

4403: /*
4404: IF gv_mode = 'P' THEN
4405:
4406: gv_periodic_start_date :=
4407: fnd_date.date_to_canonical(
4408: TRUNC(add_months(fnd_date.canonical_to_date(lv_end_date),-2)+1));
4409: -- ||' 00:00:00';
4410:
4411: ELSE

Line 4408: TRUNC(add_months(fnd_date.canonical_to_date(lv_end_date),-2)+1));

4404: IF gv_mode = 'P' THEN
4405:
4406: gv_periodic_start_date :=
4407: fnd_date.date_to_canonical(
4408: TRUNC(add_months(fnd_date.canonical_to_date(lv_end_date),-2)+1));
4409: -- ||' 00:00:00';
4410:
4411: ELSE
4412:

Line 4484: set effective_date = fnd_date.canonical_to_date('4712/12/31')

4480:
4481: hr_utility_trace('--> Query formed p_sqlstr : ' || p_sqlstr );
4482:
4483: update pay_payroll_actions
4484: set effective_date = fnd_date.canonical_to_date('4712/12/31')
4485: where payroll_action_id = p_payroll_action_id;
4486:
4487: /*Begin - Bug 13357684*/
4488: select name

Line 4584: AND TRUNC( fnd_date.canonical_to_date (

4580: AND ppa_prev.report_qualifier = 'SS_ARCHIVE'
4581: AND ppa_prev.report_category = 'RT'
4582: AND pay_mx_utility.get_legi_param_val('GRE',
4583: ppa_prev.legislative_parameters) = cp_gre_id
4584: AND TRUNC( fnd_date.canonical_to_date (
4585: pay_mx_utility.get_legi_param_val( 'PERIOD_ENDING_DATE',
4586: ppa_prev.legislative_parameters) ) ) =
4587: TRUNC(fnd_date.canonical_to_date(cp_periodic_end_date))
4588: AND paa_prev.payroll_action_id = ppa_prev.payroll_action_id

Line 4587: TRUNC(fnd_date.canonical_to_date(cp_periodic_end_date))

4583: ppa_prev.legislative_parameters) = cp_gre_id
4584: AND TRUNC( fnd_date.canonical_to_date (
4585: pay_mx_utility.get_legi_param_val( 'PERIOD_ENDING_DATE',
4586: ppa_prev.legislative_parameters) ) ) =
4587: TRUNC(fnd_date.canonical_to_date(cp_periodic_end_date))
4588: AND paa_prev.payroll_action_id = ppa_prev.payroll_action_id
4589: AND paa_prev.assignment_id = paf.assignment_id
4590: AND pay_mx_utility.get_legi_param_val('MX_IDWV',
4591: paa_prev.serial_number) = 'Y' )

Line 4669: AND TRUNC( fnd_date.canonical_to_date (

4665: AND ppa_prev.report_qualifier = 'SS_ARCHIVE'
4666: AND ppa_prev.report_category = 'RT'
4667: AND pay_mx_utility.get_legi_param_val('GRE',
4668: ppa_prev.legislative_parameters) = cp_gre_id
4669: AND TRUNC( fnd_date.canonical_to_date (
4670: pay_mx_utility.get_legi_param_val( 'PERIOD_ENDING_DATE',
4671: ppa_prev.legislative_parameters) ) ) =
4672: TRUNC(fnd_date.canonical_to_date(cp_periodic_end_date))
4673: AND paa_prev.payroll_action_id = ppa_prev.payroll_action_id

Line 4672: TRUNC(fnd_date.canonical_to_date(cp_periodic_end_date))

4668: ppa_prev.legislative_parameters) = cp_gre_id
4669: AND TRUNC( fnd_date.canonical_to_date (
4670: pay_mx_utility.get_legi_param_val( 'PERIOD_ENDING_DATE',
4671: ppa_prev.legislative_parameters) ) ) =
4672: TRUNC(fnd_date.canonical_to_date(cp_periodic_end_date))
4673: AND paa_prev.payroll_action_id = ppa_prev.payroll_action_id
4674: AND paa_prev.assignment_id = paf.assignment_id
4675: AND pay_mx_utility.get_legi_param_val('MX_IDWV',
4676: paa_prev.serial_number) = 'Y' )

Line 4859: fnd_date.canonical_to_date (lv_end_date));

4855:
4856: IF gv_IDW_calc_method IS NULL THEN
4857: gv_IDW_calc_method := get_IDW_calc_method (
4858: ln_gre_id,
4859: fnd_date.canonical_to_date (lv_end_date));
4860: END IF;
4861:
4862: hr_utility_trace('--> gv_IDW_calc_method ' || gv_IDW_calc_method);
4863:

Line 4879: ,fnd_date.canonical_to_date(lv_start_date)

4875: OPEN c_get_range_emp(p_payroll_action_id
4876: ,p_chunk
4877: ,ln_business_group_id
4878: ,ln_gre_id
4879: ,fnd_date.canonical_to_date(lv_start_date)
4880: ,fnd_date.canonical_to_date(lv_end_date)
4881: ,fnd_date.canonical_to_date(gv_periodic_start_date)
4882: ,fnd_date.canonical_to_date(gv_periodic_end_date)
4883: );

Line 4880: ,fnd_date.canonical_to_date(lv_end_date)

4876: ,p_chunk
4877: ,ln_business_group_id
4878: ,ln_gre_id
4879: ,fnd_date.canonical_to_date(lv_start_date)
4880: ,fnd_date.canonical_to_date(lv_end_date)
4881: ,fnd_date.canonical_to_date(gv_periodic_start_date)
4882: ,fnd_date.canonical_to_date(gv_periodic_end_date)
4883: );
4884:

Line 4881: ,fnd_date.canonical_to_date(gv_periodic_start_date)

4877: ,ln_business_group_id
4878: ,ln_gre_id
4879: ,fnd_date.canonical_to_date(lv_start_date)
4880: ,fnd_date.canonical_to_date(lv_end_date)
4881: ,fnd_date.canonical_to_date(gv_periodic_start_date)
4882: ,fnd_date.canonical_to_date(gv_periodic_end_date)
4883: );
4884:
4885: hr_utility_trace('c_get_range_emp');

Line 4882: ,fnd_date.canonical_to_date(gv_periodic_end_date)

4878: ,ln_gre_id
4879: ,fnd_date.canonical_to_date(lv_start_date)
4880: ,fnd_date.canonical_to_date(lv_end_date)
4881: ,fnd_date.canonical_to_date(gv_periodic_start_date)
4882: ,fnd_date.canonical_to_date(gv_periodic_end_date)
4883: );
4884:
4885: hr_utility_trace('c_get_range_emp');
4886:

Line 4893: , fnd_date.canonical_to_date(lv_start_date)

4889: , p_start_person_id
4890: , p_end_person_id
4891: , ln_business_group_id
4892: , ln_gre_id
4893: , fnd_date.canonical_to_date(lv_start_date)
4894: , fnd_date.canonical_to_date(lv_end_date)
4895: , fnd_date.canonical_to_date(gv_periodic_start_date)
4896: , fnd_date.canonical_to_date(gv_periodic_end_date) );
4897:

Line 4894: , fnd_date.canonical_to_date(lv_end_date)

4890: , p_end_person_id
4891: , ln_business_group_id
4892: , ln_gre_id
4893: , fnd_date.canonical_to_date(lv_start_date)
4894: , fnd_date.canonical_to_date(lv_end_date)
4895: , fnd_date.canonical_to_date(gv_periodic_start_date)
4896: , fnd_date.canonical_to_date(gv_periodic_end_date) );
4897:
4898: hr_utility_trace('c_get_emp');

Line 4895: , fnd_date.canonical_to_date(gv_periodic_start_date)

4891: , ln_business_group_id
4892: , ln_gre_id
4893: , fnd_date.canonical_to_date(lv_start_date)
4894: , fnd_date.canonical_to_date(lv_end_date)
4895: , fnd_date.canonical_to_date(gv_periodic_start_date)
4896: , fnd_date.canonical_to_date(gv_periodic_end_date) );
4897:
4898: hr_utility_trace('c_get_emp');
4899:

Line 4896: , fnd_date.canonical_to_date(gv_periodic_end_date) );

4892: , ln_gre_id
4893: , fnd_date.canonical_to_date(lv_start_date)
4894: , fnd_date.canonical_to_date(lv_end_date)
4895: , fnd_date.canonical_to_date(gv_periodic_start_date)
4896: , fnd_date.canonical_to_date(gv_periodic_end_date) );
4897:
4898: hr_utility_trace('c_get_emp');
4899:
4900: END IF;

Line 5013: BETWEEN fnd_date.canonical_to_date(lv_start_date)

5009: INTO ln_events_found
5010: FROM pay_process_events
5011: WHERE assignment_id = ln_assignment_id
5012: AND last_update_date
5013: BETWEEN fnd_date.canonical_to_date(lv_start_date)
5014: AND fnd_date.canonical_to_date(lv_end_date);
5015: END IF;
5016:
5017: ln_step := 8;

Line 5014: AND fnd_date.canonical_to_date(lv_end_date);

5010: FROM pay_process_events
5011: WHERE assignment_id = ln_assignment_id
5012: AND last_update_date
5013: BETWEEN fnd_date.canonical_to_date(lv_start_date)
5014: AND fnd_date.canonical_to_date(lv_end_date);
5015: END IF;
5016:
5017: ln_step := 8;
5018: hr_utility_trace('--> In Step 8 ');

Line 5025: fnd_date.canonical_to_date(lv_end_date),

5021: IF ln_events_found > 0
5022: OR (gv_IDW_calc_method = 'B' AND
5023: seniority_changed (
5024: ln_person_id,
5025: fnd_date.canonical_to_date(lv_end_date),
5026: fnd_date.canonical_to_date(lv_start_date)) = 'Y') THEN
5027: hr_utility_trace('--> Inside If ' );
5028: SELECT pay_assignment_actions_s.nextval
5029: INTO ln_asg_act_id

Line 5026: fnd_date.canonical_to_date(lv_start_date)) = 'Y') THEN

5022: OR (gv_IDW_calc_method = 'B' AND
5023: seniority_changed (
5024: ln_person_id,
5025: fnd_date.canonical_to_date(lv_end_date),
5026: fnd_date.canonical_to_date(lv_start_date)) = 'Y') THEN
5027: hr_utility_trace('--> Inside If ' );
5028: SELECT pay_assignment_actions_s.nextval
5029: INTO ln_asg_act_id
5030: FROM dual;

Line 5129: AND fnd_date.canonical_to_date(p_effective_date)

5125:
5126: SELECT 'Y'
5127: FROM per_all_people_f per
5128: WHERE per.person_id = p_person_id
5129: AND fnd_date.canonical_to_date(p_effective_date)
5130: BETWEEN per.effective_start_date AND per.effective_end_date
5131: AND per.current_employee_flag = 'Y';
5132:
5133:

Line 5218: ld_start_date := fnd_date.canonical_to_date(lv_start_date);

5214:
5215: hr_utility.set_location(gv_package || lv_procedure_name, 30);
5216: ln_step := 3;
5217:
5218: ld_start_date := fnd_date.canonical_to_date(lv_start_date);
5219: ld_end_date := fnd_date.canonical_to_date(lv_end_date);
5220:
5221: hr_utility_trace('--> lv_start_date' || lv_start_date );
5222: hr_utility_trace('--> lv_end_date' || lv_end_date );

Line 5219: ld_end_date := fnd_date.canonical_to_date(lv_end_date);

5215: hr_utility.set_location(gv_package || lv_procedure_name, 30);
5216: ln_step := 3;
5217:
5218: ld_start_date := fnd_date.canonical_to_date(lv_start_date);
5219: ld_end_date := fnd_date.canonical_to_date(lv_end_date);
5220:
5221: hr_utility_trace('--> lv_start_date' || lv_start_date );
5222: hr_utility_trace('--> lv_end_date' || lv_end_date );
5223: hr_utility_trace('--> ln_business_group_id' || ln_business_group_id );

Line 5230: fnd_date.canonical_to_date (lv_end_date));

5226:
5227: IF gv_IDW_calc_method IS NULL THEN
5228: gv_IDW_calc_method := get_IDW_calc_method (
5229: ln_gre_id,
5230: fnd_date.canonical_to_date (lv_end_date));
5231: END IF;
5232: hr_utility_trace('--> gv_IDW_calc_method' || gv_IDW_calc_method );
5233: /****************************************************************
5234: ** Archive all the payroll action level data once only when

Line 5330: IF (TRUNC(fnd_date.canonical_to_date(

5326: hr_utility_trace('Person ID for MX SS Transcations .. ' || pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO1);
5327: hr_utility_trace('Transaction Date for MX SS Transcations .. ' || pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO2);
5328: hr_utility_trace('IS Employee active .. ' || lv_is_employee);
5329:
5330: IF (TRUNC(fnd_date.canonical_to_date(
5331: pay_mx_soc_sec_archive.lrr_act_tab(i).act_info2)) =
5332: TRUNC(fnd_date.canonical_to_date('4712/12/31'))) OR lv_is_employee = 'N' THEN
5333:
5334: NULL;

Line 5332: TRUNC(fnd_date.canonical_to_date('4712/12/31'))) OR lv_is_employee = 'N' THEN

5328: hr_utility_trace('IS Employee active .. ' || lv_is_employee);
5329:
5330: IF (TRUNC(fnd_date.canonical_to_date(
5331: pay_mx_soc_sec_archive.lrr_act_tab(i).act_info2)) =
5332: TRUNC(fnd_date.canonical_to_date('4712/12/31'))) OR lv_is_employee = 'N' THEN
5333:
5334: NULL;
5335: hr_utility_trace('--> NULL' );
5336: ELSE

Line 5433: fnd_date.canonical_to_date(

5429:
5430: CURSOR c_payroll_Action_info (cp_payroll_action_id IN NUMBER) IS
5431: SELECT pay_mx_utility.get_legi_param_val('GRE',
5432: LEGISLATIVE_PARAMETERS) GRE,
5433: fnd_date.canonical_to_date(
5434: pay_mx_utility.get_legi_param_val(
5435: 'END_DATE',
5436: LEGISLATIVE_PARAMETERS)) END_DATE
5437: FROM pay_payroll_actions

Line 5494: fnd_date.date_to_canonical(ld_end_date));

5490: p_attribute19 => NULL,
5491: p_attribute20 => NULL);
5492:
5493: hr_utility_trace ('end_date in legislative_parameters = '||
5494: fnd_date.date_to_canonical(ld_end_date));
5495: hr_utility_trace ('Date stamped in pay_recorded_requests = '||
5496: fnd_date.date_to_canonical(ld_start_date));
5497:
5498: /* We need to stamp the end date in pay_recorded_requests only if

Line 5496: fnd_date.date_to_canonical(ld_start_date));

5492:
5493: hr_utility_trace ('end_date in legislative_parameters = '||
5494: fnd_date.date_to_canonical(ld_end_date));
5495: hr_utility_trace ('Date stamped in pay_recorded_requests = '||
5496: fnd_date.date_to_canonical(ld_start_date));
5497:
5498: /* We need to stamp the end date in pay_recorded_requests only if
5499: existing date is less than end date stamped on payroll action. This
5500: is done to prevent invalid stamping of date in pay_recorded_requests

Line 5507: fnd_date.date_to_canonical(ld_end_date));

5503: In other words, date stamped in pay_recorded_requests can only be
5504: advanced further; it cannot be updated by a potential retry attempt. */
5505: IF ld_end_date > ld_start_date THEN
5506: hr_utility_trace ('Advancing date in pay_recorded_requests to '||
5507: fnd_date.date_to_canonical(ld_end_date));
5508: pay_recorded_requests_pkg.set_recorded_date(
5509: p_process => 'MX_SOC_SEC_ARCH',
5510: p_recorded_date => ld_end_date,
5511: p_recorded_date_o => ld_old_recorded_date,