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 2737: fnd_date.canonical_to_date('2003/04/06 00:00:00') then

2733: check_parameters;
2734: --
2735: for maternity in maternity_details loop
2736: if maternity.due_date >=
2737: fnd_date.canonical_to_date('2003/04/06 00:00:00') then
2738: sickness_trigger_weeks := 28;
2739: else
2740: sickness_trigger_weeks := 42;
2741: end if;

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

2770: --
2771: -- force the MPP to start on the Sunday of the
2772: -- sixth week prior to the EWC
2773: if maternity.due_date <
2774: fnd_date.canonical_to_date('2003/04/06 00:00:00') then
2775: --
2776: hr_utility.trace(l_proc||'Condition 3 true');
2777: --
2778: if rtrim (to_char (maternity.EWC, 'DAY')) = l_sunday then

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

2812: p_object_version_number => maternity.object_version_number);
2813: hr_utility.trace(l_proc||'Back from updating MPP Start Date');
2814: end if;
2815: else
2816: if maternity.due_date < fnd_date.canonical_to_date('2003/04/06 00:00:00') then
2817: --
2818: -- Start the MPP on the first Sunday of the sickness
2819: -- as due date before 06-APR-2003
2820: --

Line 2893: fnd_date.date_to_canonical(start_disqualifying_period));

2889: --
2890: end_disqualifying_period := start_disqualifying_period
2891: + (l_SMP_element.Maximum_MPP * 7) -1;
2892: hr_utility.trace('start_disqualifying_period : '||
2893: fnd_date.date_to_canonical(start_disqualifying_period));
2894: hr_utility.trace('end_disqualifying_period : '||
2895: fnd_date.date_to_canonical(end_disqualifying_period));
2896: --
2897: exception

Line 2895: fnd_date.date_to_canonical(end_disqualifying_period));

2891: + (l_SMP_element.Maximum_MPP * 7) -1;
2892: hr_utility.trace('start_disqualifying_period : '||
2893: fnd_date.date_to_canonical(start_disqualifying_period));
2894: hr_utility.trace('end_disqualifying_period : '||
2895: fnd_date.date_to_canonical(end_disqualifying_period));
2896: --
2897: exception
2898: when attempt_to_add_to_end_of_time then
2899: --

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

3635: l_proc varchar2(80) := g_package||'check_linking_letter';
3636: --
3637: -- Get current linking letter end date off the person record
3638: cursor csr_link_letter is
3639: select fnd_date.canonical_to_date(ppf.per_information11)
3640: from per_all_people_f ppf
3641: where ppf.person_id = p_absence.person_id
3642: and ppf.per_information_category = 'GB'
3643: and sysdate between ppf.effective_start_date and ppf.effective_end_date;

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

3815: -- Changes for bug 1020757: --
3816: -- --
3817: -- The changeformat function will return the screen_entry_value in the --
3818: -- external display format. This is not always 'DD-MON-YYYY' so that --
3819: -- should not be hardcoded. Better to use fnd_date.chardate_to_date --
3820: -- which will convert the display format to a date. --
3821: -- This will fix bug 1020757. --
3822: -------------------------------------------------------------------------
3823: /* max(decode(inp.name,c_from_name, */

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

3826: /* max(decode(inp.name,c_to_name, */
3827: /* to_date(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom, */
3828: /* g_SSP_correction.input_currency_code),'DD-MON-YYYY'),null)) DATE_TO, */
3829: max(decode(inp.name,c_from_name,
3830: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,
3831: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_FROM,
3832: max(decode(inp.name,c_to_name,
3833: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,
3834: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_TO,

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

3829: max(decode(inp.name,c_from_name,
3830: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,
3831: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_FROM,
3832: max(decode(inp.name,c_to_name,
3833: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,
3834: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_TO,
3835: -- End of Changes for bug 1020757
3836: ------------------------------------------------------------------------
3837: max(decode(inp.name,c_amount_name,

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

4103: p_input_value_id8 => g_SSP_legislation.qualifying_days_id,
4104: p_entry_value1 => new_entry.rate (Y),
4105: -- Fix for bug 1020757:
4106: -- This explicit conversion is not possible anymore since we don't know
4107: -- what the format is going to be. We need to use fnd_date,date_to_chardate
4108: -- p_entry_value2 => to_char(new_entry.date_from(Y),'DD-MON-YYYY'),
4109: -- p_entry_value3 => to_char(new_entry.date_to(Y),'DD-MON-YYYY'),
4110: p_entry_value2 => fnd_date.date_to_chardate(new_entry.date_from(Y)),
4111: p_entry_value3 => fnd_date.date_to_chardate(new_entry.date_to(Y)),

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

4106: -- This explicit conversion is not possible anymore since we don't know
4107: -- what the format is going to be. We need to use fnd_date,date_to_chardate
4108: -- p_entry_value2 => to_char(new_entry.date_from(Y),'DD-MON-YYYY'),
4109: -- p_entry_value3 => to_char(new_entry.date_to(Y),'DD-MON-YYYY'),
4110: p_entry_value2 => fnd_date.date_to_chardate(new_entry.date_from(Y)),
4111: p_entry_value3 => fnd_date.date_to_chardate(new_entry.date_to(Y)),
4112: p_entry_value4 => new_entry.amount (Y),
4113: p_entry_value5 => new_entry.withheld_days (Y),
4114: p_entry_value6 => new_entry.SSP_weeks (Y),

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

4107: -- what the format is going to be. We need to use fnd_date,date_to_chardate
4108: -- p_entry_value2 => to_char(new_entry.date_from(Y),'DD-MON-YYYY'),
4109: -- p_entry_value3 => to_char(new_entry.date_to(Y),'DD-MON-YYYY'),
4110: p_entry_value2 => fnd_date.date_to_chardate(new_entry.date_from(Y)),
4111: p_entry_value3 => fnd_date.date_to_chardate(new_entry.date_to(Y)),
4112: p_entry_value4 => new_entry.amount (Y),
4113: p_entry_value5 => new_entry.withheld_days (Y),
4114: p_entry_value6 => new_entry.SSP_weeks (Y),
4115: p_entry_value7 => new_entry.SSP_days_due (Y),