APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on FND_DATE

Line 1803: ld_return_date := fnd_date.canonical_to_date(p_char_date);

1799: ld_return_date DATE;
1800:
1801: BEGIN
1802: if length(p_char_date) = 19 then
1803: ld_return_date := fnd_date.canonical_to_date(p_char_date);
1804: else
1805: begin
1806: ld_return_date := fnd_date.chardate_to_date(p_char_date);
1807:

Line 1806: ld_return_date := fnd_date.chardate_to_date(p_char_date);

1802: if length(p_char_date) = 19 then
1803: ld_return_date := fnd_date.canonical_to_date(p_char_date);
1804: else
1805: begin
1806: ld_return_date := fnd_date.chardate_to_date(p_char_date);
1807:
1808: exception
1809: when others then
1810: ld_return_date := null;

Line 2342: /* and fnd_date.canonical_to_date(pai.action_information11) = pps.date_start;*/

2338: pay_action_information pai
2339: where pps.person_id = p_person_id
2340: and pai.action_context_id = p_action_context_id
2341: and pai.action_information_category = 'EMPLOYEE DETAILS'
2342: /* and fnd_date.canonical_to_date(pai.action_information11) = pps.date_start;*/
2343: and format_to_date(pai.action_information11) = pps.date_start;
2344:
2345: /* Bug 3722370 - Introduced decode statement in WHERE clause */
2346: cursor c_get_term_details(p_actual_termination_date varchar2,

Line 3159: FND function fnd_date.date_to_displaydate is available

3155: Any reorganization of the bind variables would require
3156: modifications in all CO files referencing this VO.
3157: 2. Hijrah support has been provided at present only for
3158: releases post 12.1.1. Over loaded version of
3159: FND function fnd_date.date_to_displaydate is available
3160: at present only in 12.1.1 and later
3161: More details in note 807393.1
3162: 3. Date formatting does not depend on the profile
3163: "FND: Date API Calendar Awareness Default"

Line 3167: fnd_date.date_to_displaydate, the calendar_aware

3163: "FND: Date API Calendar Awareness Default"
3164: At the time this code was written, it has been
3165: observed that the date fields in OA framework is not
3166: dependent on this profile. Hence while calling
3167: fnd_date.date_to_displaydate, the calendar_aware
3168: parameter has been harcoded as 1
3169: *********************************************************************/
3170:
3171: FUNCTION get_display_list (p_date DATE,

Line 3195: v_list := fnd_date.date_to_displaydate(p_date,1)

3191:
3192: hr_utility.TRACE('Release greater than or equal to 12.1.1 ' );
3193: --Calendar_aware parameter intentionally hard coded as 1, as date fields in OA framework does not depend
3194: --on the fnd profile "FND: Date API Calendar Awareness Default"
3195: v_list := fnd_date.date_to_displaydate(p_date,1)
3196: ||' - '
3197: || g_job_label
3198: ||' '
3199: || p_action_information14

Line 3224: v_list := pay_date_wrapper_pkg.fnd_date_date_to_displaydate(p_date)

3220: if p_legislation_code = 'US' then
3221: g_job_label := null;
3222: end if;
3223:
3224: v_list := pay_date_wrapper_pkg.fnd_date_date_to_displaydate(p_date)
3225: ||' - '
3226: || g_job_label
3227: ||' '
3228: || p_action_information14