72: --
73: Begin
74:
75: --
76: debug(fnd_date.date_to_canonical(p_trace_date));
77: --
78:
79: End debug;
80: --
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:
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;
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:
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 );