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

Line 79: DEBUG (fnd_date.date_to_canonical (p_trace_date));

75:
76: --
77: BEGIN
78: --
79: DEBUG (fnd_date.date_to_canonical (p_trace_date));
80: --
81:
82: END DEBUG;
83:

Line 282: || fnd_date.date_to_canonical (g_effective_date)

278: debug_enter (l_proc_name);
279: DEBUG (TO_CHAR (g_effective_date, 'DD-MON-YYYY'));
280: DEBUG (
281: 'g_effective_date: '
282: || fnd_date.date_to_canonical (g_effective_date)
283: );
284: /*g_effective_end_date := -- "end of day" of a day before effective date
285: fnd_date.canonical_to_date (
286: TO_CHAR ( g_effective_date

Line 285: fnd_date.canonical_to_date (

281: 'g_effective_date: '
282: || fnd_date.date_to_canonical (g_effective_date)
283: );
284: /*g_effective_end_date := -- "end of day" of a day before effective date
285: fnd_date.canonical_to_date (
286: TO_CHAR ( g_effective_date
287: - 1, 'YYYY/MM/DD')
288: || '23:59:59'
289: );*/

Line 293: || fnd_date.date_to_canonical (g_effective_end_date)

289: );*/
290: g_effective_end_date:= g_effective_date;
291: DEBUG (
292: 'g_effective_end_date: '
293: || fnd_date.date_to_canonical (g_effective_end_date)
294: );
295: -- 11.5.10_CU2: Performance fix :
296: -- get the ben_ext_rcd.ext_rcd_id
297: -- and use this one for next cursor

Line 310: || fnd_date.date_to_canonical (g_effective_start_date)

306: OPEN csr_last_run_details(l_ext_rcd_id);
307: FETCH csr_last_run_details INTO g_effective_start_date;
308: DEBUG (
309: 'g_effective_start_date just after fetch: '
310: || fnd_date.date_to_canonical (g_effective_start_date)
311: );
312:
313: IF csr_last_run_details%NOTFOUND -- not likely ever bcos of use of MAX
314: OR g_effective_start_date IS NULL

Line 340: l_initial_ext_date := fnd_date.displaydate_to_date(l_value);

336: p_error_text := l_error_text;
337: debug_exit (l_proc_name);
338: RETURN -1;
339: END IF; -- End if of function in error check ...
340: l_initial_ext_date := fnd_date.displaydate_to_date(l_value);
341:
342: DEBUG ( 'Initial Extract Date: '
343: || TO_CHAR(l_initial_ext_date, 'DD-MM-YYYY'));
344: DEBUG ('End of call to function pqp_gb_get_table_value');

Line 395: || fnd_date.date_to_canonical (g_effective_start_date)

391:
392: CLOSE csr_last_run_details;
393: DEBUG (
394: 'g_effective_start_date: '
395: || fnd_date.date_to_canonical (g_effective_start_date)
396: );
397: OPEN csr_next_run_details(l_ext_rcd_id);
398: FETCH csr_next_run_details INTO g_next_effective_date;
399: CLOSE csr_next_run_details;

Line 402: || fnd_date.date_to_canonical (g_next_effective_date)

398: FETCH csr_next_run_details INTO g_next_effective_date;
399: CLOSE csr_next_run_details;
400: DEBUG (
401: 'g_next_effective_date: '
402: || fnd_date.date_to_canonical (g_next_effective_date)
403: );
404: g_header_system_element :=
405: g_header_system_element
406: || fnd_date.date_to_canonical (g_effective_start_date)

Line 406: || fnd_date.date_to_canonical (g_effective_start_date)

402: || fnd_date.date_to_canonical (g_next_effective_date)
403: );
404: g_header_system_element :=
405: g_header_system_element
406: || fnd_date.date_to_canonical (g_effective_start_date)
407: || ':'
408: || fnd_date.date_to_canonical (g_effective_end_date)
409: || ':'
410: || fnd_date.date_to_canonical (g_next_effective_date)

Line 408: || fnd_date.date_to_canonical (g_effective_end_date)

404: g_header_system_element :=
405: g_header_system_element
406: || fnd_date.date_to_canonical (g_effective_start_date)
407: || ':'
408: || fnd_date.date_to_canonical (g_effective_end_date)
409: || ':'
410: || fnd_date.date_to_canonical (g_next_effective_date)
411: || ':';
412: DEBUG ( 'g_header_system_element: '

Line 410: || fnd_date.date_to_canonical (g_next_effective_date)

406: || fnd_date.date_to_canonical (g_effective_start_date)
407: || ':'
408: || fnd_date.date_to_canonical (g_effective_end_date)
409: || ':'
410: || fnd_date.date_to_canonical (g_next_effective_date)
411: || ':';
412: DEBUG ( 'g_header_system_element: '
413: || g_header_system_element);
414: debug_exit (l_proc_name);

Line 442: || fnd_date.date_to_canonical (g_effective_date)

438: debug_enter (l_proc_name);
439: DEBUG (TO_CHAR (g_effective_date, 'DD-MON-YYYY'));
440: DEBUG (
441: 'g_effective_date: '
442: || fnd_date.date_to_canonical (g_effective_date)
443: );
444: g_effective_end_date := g_effective_date;
445: g_effective_start_date := ADD_MONTHS (( g_effective_date
446: + 1

Line 450: || fnd_date.date_to_canonical (g_effective_start_date)

446: + 1
447: ), -12);
448: DEBUG (
449: 'g_effective_start_date: '
450: || fnd_date.date_to_canonical (g_effective_start_date)
451: );
452: DEBUG (
453: 'g_effective_end_date: '
454: || fnd_date.date_to_canonical (g_effective_end_date)

Line 454: || fnd_date.date_to_canonical (g_effective_end_date)

450: || fnd_date.date_to_canonical (g_effective_start_date)
451: );
452: DEBUG (
453: 'g_effective_end_date: '
454: || fnd_date.date_to_canonical (g_effective_end_date)
455: );
456: g_header_system_element :=
457: g_header_system_element
458: || fnd_date.date_to_canonical (g_effective_start_date)

Line 458: || fnd_date.date_to_canonical (g_effective_start_date)

454: || fnd_date.date_to_canonical (g_effective_end_date)
455: );
456: g_header_system_element :=
457: g_header_system_element
458: || fnd_date.date_to_canonical (g_effective_start_date)
459: || ':'
460: || fnd_date.date_to_canonical (g_effective_end_date)
461: || ':'
462: || fnd_date.date_to_canonical (g_effective_date)

Line 460: || fnd_date.date_to_canonical (g_effective_end_date)

456: g_header_system_element :=
457: g_header_system_element
458: || fnd_date.date_to_canonical (g_effective_start_date)
459: || ':'
460: || fnd_date.date_to_canonical (g_effective_end_date)
461: || ':'
462: || fnd_date.date_to_canonical (g_effective_date)
463: || ':';
464: DEBUG ( 'g_header_system_element: '

Line 462: || fnd_date.date_to_canonical (g_effective_date)

458: || fnd_date.date_to_canonical (g_effective_start_date)
459: || ':'
460: || fnd_date.date_to_canonical (g_effective_end_date)
461: || ':'
462: || fnd_date.date_to_canonical (g_effective_date)
463: || ':';
464: DEBUG ( 'g_header_system_element: '
465: || g_header_system_element);
466: debug_exit (l_proc_name);

Line 3053: fnd_date.canonical_to_date (

3049: IF l_input_value_id IS NOT NULL
3050: THEN
3051: DEBUG ('Before calling get_ele_entry_value function');
3052: l_dt_joined_pens :=
3053: fnd_date.canonical_to_date (
3054: get_ele_entry_value (
3055: p_element_entry_id=> g_ele_entry_details (
3056: p_assignment_id
3057: ).element_entry_id,