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 292: || fnd_date.date_to_canonical (g_effective_end_date)

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

Line 309: || fnd_date.date_to_canonical (g_effective_start_date)

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

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

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

Line 394: || fnd_date.date_to_canonical (g_effective_start_date)

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

Line 401: || fnd_date.date_to_canonical (g_next_effective_date)

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

Line 405: || fnd_date.date_to_canonical (g_effective_start_date)

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

Line 407: || fnd_date.date_to_canonical (g_effective_end_date)

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

Line 409: || fnd_date.date_to_canonical (g_next_effective_date)

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

Line 441: || fnd_date.date_to_canonical (g_effective_date)

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

Line 449: || fnd_date.date_to_canonical (g_effective_start_date)

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

Line 453: || fnd_date.date_to_canonical (g_effective_end_date)

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

Line 457: || fnd_date.date_to_canonical (g_effective_start_date)

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

Line 459: || fnd_date.date_to_canonical (g_effective_end_date)

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

Line 461: || fnd_date.date_to_canonical (g_effective_date)

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

Line 3052: fnd_date.canonical_to_date (

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