DBA Data[Home] [Help]

APPS.PQP_GB_TP_TYPE2_FUNCTIONS dependencies on FND_DATE

Line 76: debug(fnd_date.date_to_canonical(p_trace_date));

72: --
73: Begin
74:
75: --
76: debug(fnd_date.date_to_canonical(p_trace_date));
77: --
78:
79: End debug;
80: --

Line 259: fnd_date.date_to_canonical(g_effective_start_date)||':'||

255: debug(':g_header_system_element:'||g_header_system_element,525);
256:
257: g_header_system_element:=
258: g_header_system_element||
259: fnd_date.date_to_canonical(g_effective_start_date)||':'||
260: fnd_date.date_to_canonical(g_effective_end_date)||':'||
261: fnd_date.date_to_canonical(g_effective_date)||':' ;
262:
263:

Line 260: fnd_date.date_to_canonical(g_effective_end_date)||':'||

256:
257: g_header_system_element:=
258: g_header_system_element||
259: fnd_date.date_to_canonical(g_effective_start_date)||':'||
260: fnd_date.date_to_canonical(g_effective_end_date)||':'||
261: fnd_date.date_to_canonical(g_effective_date)||':' ;
262:
263:
264: pqp_gb_tp_pension_extracts.g_header_system_element := g_header_system_element;

Line 261: fnd_date.date_to_canonical(g_effective_date)||':' ;

257: g_header_system_element:=
258: g_header_system_element||
259: fnd_date.date_to_canonical(g_effective_start_date)||':'||
260: fnd_date.date_to_canonical(g_effective_end_date)||':'||
261: fnd_date.date_to_canonical(g_effective_date)||':' ;
262:
263:
264: pqp_gb_tp_pension_extracts.g_header_system_element := g_header_system_element;
265:

Line 407: fnd_date.canonical_to_date(TO_CHAR(g_effective_date - 1,'YYYY/MM/DD')||'23:59:59');

403: g_crossbg_enabled := pqp_gb_tp_pension_extracts.g_crossbg_enabled;
404: g_estb_number := pqp_gb_tp_pension_extracts.g_estb_number;
405: -- "end of day" of a day before effective date
406: g_effective_run_date :=
407: fnd_date.canonical_to_date(TO_CHAR(g_effective_date - 1,'YYYY/MM/DD')||'23:59:59');
408: -- ********* Ennd of Variables ***************
409:
410:
411: debug(':g_estb_number:'||g_estb_number,210 );