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.SSP_SSP_PKG dependencies on FND_DATE

Line 2623: fnd_date.canonical_to_date('2003/04/06 00:00:00') then

2619: check_parameters;
2620: --
2621: for maternity in maternity_details loop
2622: if maternity.due_date >=
2623: fnd_date.canonical_to_date('2003/04/06 00:00:00') then
2624: sickness_trigger_weeks := 28;
2625: else
2626: sickness_trigger_weeks := 42;
2627: end if;

Line 2660: fnd_date.canonical_to_date('2003/04/06 00:00:00') then

2656: --
2657: -- force the MPP to start on the Sunday of the
2658: -- sixth week prior to the EWC
2659: if maternity.due_date <
2660: fnd_date.canonical_to_date('2003/04/06 00:00:00') then
2661: --
2662: hr_utility.trace(l_proc||'Condition 3 true');
2663: --
2664: if rtrim (to_char (maternity.EWC, 'DAY')) = l_sunday then

Line 2702: if maternity.due_date < fnd_date.canonical_to_date('2003/04/06 00:00:00') then

2698: p_object_version_number => maternity.object_version_number);
2699: hr_utility.trace(l_proc||'Back from updating MPP Start Date');
2700: end if;
2701: else
2702: if maternity.due_date < fnd_date.canonical_to_date('2003/04/06 00:00:00') then
2703: --
2704: -- Start the MPP on the first Sunday of the sickness
2705: -- as due date before 06-APR-2003
2706: --

Line 2779: fnd_date.date_to_canonical(start_disqualifying_period));

2775: --
2776: end_disqualifying_period := start_disqualifying_period
2777: + (l_SMP_element.Maximum_MPP * 7) -1;
2778: hr_utility.trace('start_disqualifying_period : '||
2779: fnd_date.date_to_canonical(start_disqualifying_period));
2780: hr_utility.trace('end_disqualifying_period : '||
2781: fnd_date.date_to_canonical(end_disqualifying_period));
2782: --
2783: exception

Line 2781: fnd_date.date_to_canonical(end_disqualifying_period));

2777: + (l_SMP_element.Maximum_MPP * 7) -1;
2778: hr_utility.trace('start_disqualifying_period : '||
2779: fnd_date.date_to_canonical(start_disqualifying_period));
2780: hr_utility.trace('end_disqualifying_period : '||
2781: fnd_date.date_to_canonical(end_disqualifying_period));
2782: --
2783: exception
2784: when attempt_to_add_to_end_of_time then
2785: --

Line 3525: select fnd_date.canonical_to_date(ppf.per_information11)

3521: l_proc varchar2(80) := g_package||'check_linking_letter';
3522: --
3523: -- Get current linking letter end date off the person record
3524: cursor csr_link_letter is
3525: select fnd_date.canonical_to_date(ppf.per_information11)
3526: from per_all_people_f ppf
3527: where ppf.person_id = p_absence.person_id
3528: and ppf.per_information_category = 'GB'
3529: and sysdate between ppf.effective_start_date and ppf.effective_end_date;

Line 3705: -- should not be hardcoded. Better to use fnd_date.chardate_to_date --

3701: -- Changes for bug 1020757: --
3702: -- --
3703: -- The changeformat function will return the screen_entry_value in the --
3704: -- external display format. This is not always 'DD-MON-YYYY' so that --
3705: -- should not be hardcoded. Better to use fnd_date.chardate_to_date --
3706: -- which will convert the display format to a date. --
3707: -- This will fix bug 1020757. --
3708: -------------------------------------------------------------------------
3709: /* max(decode(inp.name,c_from_name, */

Line 3716: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,

3712: /* max(decode(inp.name,c_to_name, */
3713: /* to_date(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom, */
3714: /* g_SSP_correction.input_currency_code),'DD-MON-YYYY'),null)) DATE_TO, */
3715: max(decode(inp.name,c_from_name,
3716: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,
3717: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_FROM,
3718: max(decode(inp.name,c_to_name,
3719: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,
3720: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_TO,

Line 3719: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,

3715: max(decode(inp.name,c_from_name,
3716: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,
3717: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_FROM,
3718: max(decode(inp.name,c_to_name,
3719: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,
3720: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_TO,
3721: -- End of Changes for bug 1020757
3722: ------------------------------------------------------------------------
3723: max(decode(inp.name,c_amount_name,

Line 3975: -- what the format is going to be. We need to use fnd_date,date_to_chardate

3971: p_input_value_id8 => g_SSP_legislation.qualifying_days_id,
3972: p_entry_value1 => new_entry.rate (Y),
3973: -- Fix for bug 1020757:
3974: -- This explicit conversion is not possible anymore since we don't know
3975: -- what the format is going to be. We need to use fnd_date,date_to_chardate
3976: -- p_entry_value2 => to_char(new_entry.date_from(Y),'DD-MON-YYYY'),
3977: -- p_entry_value3 => to_char(new_entry.date_to(Y),'DD-MON-YYYY'),
3978: p_entry_value2 => fnd_date.date_to_chardate(new_entry.date_from(Y)),
3979: p_entry_value3 => fnd_date.date_to_chardate(new_entry.date_to(Y)),

Line 3978: p_entry_value2 => fnd_date.date_to_chardate(new_entry.date_from(Y)),

3974: -- This explicit conversion is not possible anymore since we don't know
3975: -- what the format is going to be. We need to use fnd_date,date_to_chardate
3976: -- p_entry_value2 => to_char(new_entry.date_from(Y),'DD-MON-YYYY'),
3977: -- p_entry_value3 => to_char(new_entry.date_to(Y),'DD-MON-YYYY'),
3978: p_entry_value2 => fnd_date.date_to_chardate(new_entry.date_from(Y)),
3979: p_entry_value3 => fnd_date.date_to_chardate(new_entry.date_to(Y)),
3980: p_entry_value4 => new_entry.amount (Y),
3981: p_entry_value5 => new_entry.withheld_days (Y),
3982: p_entry_value6 => new_entry.SSP_weeks (Y),

Line 3979: p_entry_value3 => fnd_date.date_to_chardate(new_entry.date_to(Y)),

3975: -- what the format is going to be. We need to use fnd_date,date_to_chardate
3976: -- p_entry_value2 => to_char(new_entry.date_from(Y),'DD-MON-YYYY'),
3977: -- p_entry_value3 => to_char(new_entry.date_to(Y),'DD-MON-YYYY'),
3978: p_entry_value2 => fnd_date.date_to_chardate(new_entry.date_from(Y)),
3979: p_entry_value3 => fnd_date.date_to_chardate(new_entry.date_to(Y)),
3980: p_entry_value4 => new_entry.amount (Y),
3981: p_entry_value5 => new_entry.withheld_days (Y),
3982: p_entry_value6 => new_entry.SSP_weeks (Y),
3983: p_entry_value7 => new_entry.SSP_days_due (Y),