DBA Data[Home] [Help]

APPS.PJI_TIME_C dependencies on FND_DATE

Line 184: pji_utils.write2log('Earliest Start Date: '||Fnd_Date.date_to_displaydate(g_earliest_start_date));

180: IF g_debug_flag = 'Y' THEN
181: pji_utils.write2log('Enterprise Calendar = '||g_period_set_name||' ('||g_period_type||')');
182: pji_utils.write2log('Week Start Day = '||g_week_start_day);
183: pji_utils.write2log('Week offset = '||g_week_offset);
184: pji_utils.write2log('Earliest Start Date: '||Fnd_Date.date_to_displaydate(g_earliest_start_date));
185: pji_utils.write2log('Latest End Date: '||Fnd_Date.date_to_displaydate(g_latest_end_date));
186: END IF;
187:
188: IF (g_period_set_name IS NULL OR g_period_type IS NULL) THEN

Line 185: pji_utils.write2log('Latest End Date: '||Fnd_Date.date_to_displaydate(g_latest_end_date));

181: pji_utils.write2log('Enterprise Calendar = '||g_period_set_name||' ('||g_period_type||')');
182: pji_utils.write2log('Week Start Day = '||g_week_start_day);
183: pji_utils.write2log('Week offset = '||g_week_offset);
184: pji_utils.write2log('Earliest Start Date: '||Fnd_Date.date_to_displaydate(g_earliest_start_date));
185: pji_utils.write2log('Latest End Date: '||Fnd_Date.date_to_displaydate(g_latest_end_date));
186: END IF;
187:
188: IF (g_period_set_name IS NULL OR g_period_type IS NULL) THEN
189: RAISE G_BIS_PARAMETER_NOT_SETUP;

Line 369: pji_utils.write2log('New Earliest Start Date: '||Fnd_Date.date_to_displaydate(l_min_date));

365: --g_latest_end_date:=GREATEST(l_max_date, g_latest_end_date);
366:
367: IF g_debug_flag = 'Y' THEN
368: pji_utils.write2log('Calendar ID: -1');
369: pji_utils.write2log('New Earliest Start Date: '||Fnd_Date.date_to_displaydate(l_min_date));
370: pji_utils.write2log('New Latest End Date: '||Fnd_Date.date_to_displaydate(l_max_date));
371: END IF;
372:
373: END IF;

Line 370: pji_utils.write2log('New Latest End Date: '||Fnd_Date.date_to_displaydate(l_max_date));

366:
367: IF g_debug_flag = 'Y' THEN
368: pji_utils.write2log('Calendar ID: -1');
369: pji_utils.write2log('New Earliest Start Date: '||Fnd_Date.date_to_displaydate(l_min_date));
370: pji_utils.write2log('New Latest End Date: '||Fnd_Date.date_to_displaydate(l_max_date));
371: END IF;
372:
373: END IF;
374:

Line 678: pji_utils.write2log('Earliest Start Date: '||Fnd_Date.date_to_displaydate(l_min_date));

674: END IF;
675:
676: IF g_debug_flag = 'Y' THEN
677: pji_utils.write2log('Calendar ID: '||p_calendar_id);
678: pji_utils.write2log('Earliest Start Date: '||Fnd_Date.date_to_displaydate(l_min_date));
679: pji_utils.write2log('Latest End Date: '||Fnd_Date.date_to_displaydate(l_max_date));
680: END IF;
681:
682: END IF;

Line 679: pji_utils.write2log('Latest End Date: '||Fnd_Date.date_to_displaydate(l_max_date));

675:
676: IF g_debug_flag = 'Y' THEN
677: pji_utils.write2log('Calendar ID: '||p_calendar_id);
678: pji_utils.write2log('Earliest Start Date: '||Fnd_Date.date_to_displaydate(l_min_date));
679: pji_utils.write2log('Latest End Date: '||Fnd_Date.date_to_displaydate(l_max_date));
680: END IF;
681:
682: END IF;
683: IF l_no_rows_inserted >0 THEN

Line 1206: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_RPT_STRUCT table for date : '||Fnd_Date.date_to_displaydate(extr_rec.report_date));

1202:
1203: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
1204:
1205: IF g_debug_flag = 'Y' THEN
1206: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_RPT_STRUCT table for date : '||Fnd_Date.date_to_displaydate(extr_rec.report_date));
1207: END IF;
1208:
1209: END LOOP;
1210: END LOAD_TIME_RPT_STRUCT;

Line 1549: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_RPT_STRUCT table for date : '||Fnd_Date.date_to_displaydate(extr_rec.report_date));

1545:
1546: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
1547:
1548: IF g_debug_flag = 'Y' THEN
1549: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_RPT_STRUCT table for date : '||Fnd_Date.date_to_displaydate(extr_rec.report_date));
1550: END IF;
1551:
1552: END LOOP;
1553: END LOAD_TIME_CAL_RPT_STRUCT;