APPS.PJI_TIME_C dependencies on PJI_TIME_ENT_PERIOD

Line 292: INSERT INTO pji_time_ent_period(

288: AND adjustment_period_flag='N'
289: AND (start_date < g_earliest_start_date
290: OR end_date > g_latest_end_date);
291:
292: INSERT INTO pji_time_ent_period(
293: ent_period_id
294: , ent_qtr_id
295: , ent_year_id
296: , sequence

Line 322: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_ENT_PERIOD table.');

318:
319: l_no_rows_inserted := SQL%rowcount;
320:
321: IF g_debug_flag = 'Y' THEN
322: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_ENT_PERIOD table.');
323: END IF;
324:
325: IF l_no_rows_inserted > 0 THEN
326: SELECT MIN(start_date), MAX(end_date)

Line 328: FROM pji_time_ent_period

324:
325: IF l_no_rows_inserted > 0 THEN
326: SELECT MIN(start_date), MAX(end_date)
327: INTO l_min_date, l_max_date
328: FROM pji_time_ent_period
329: WHERE (start_date < g_earliest_start_date
330: OR end_date > g_latest_end_date);
331:
332: g_min_date:=l_min_date;

Line 383: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_ENT_PERIOD table.');

379: END IF;
380: EXCEPTION
381: WHEN DUP_VAL_ON_INDEX THEN
382: IF g_debug_flag = 'Y' THEN
383: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_ENT_PERIOD table.');
384: END IF;
385: RETURN FALSE;
386: END LOAD_ENT_PERIOD;
387:

Line 919: FROM pji_time_ent_period period

915: , l_year_start_date
916: , l_qtr_end_date
917: , l_period_end_date
918: , l_year_end_date
919: FROM pji_time_ent_period period
920: , pji_time_ent_qtr qtr
921: , pji_time_ent_year yr
922: WHERE 1=1
923: AND period.ent_qtr_id = qtr.ent_qtr_id

Line 956: , PJI_TIME_ENT_PERIOD period

952: , g_user_id
953: , g_user_id
954: , g_login_id
955: FROM PJI_TIME_ENT_YEAR year
956: , PJI_TIME_ENT_PERIOD period
957: WHERE year.end_date < l_year_start_date
958: AND period.start_date >= g_earliest_start_date;
959:
960: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;

Line 991: , PJI_TIME_ENT_PERIOD period

987: , g_user_id
988: , g_user_id
989: , g_login_id
990: FROM PJI_TIME_ENT_QTR qtr
991: , PJI_TIME_ENT_PERIOD period
992: WHERE 1=1
993: AND qtr.end_date < l_qtr_start_date
994: AND qtr.start_date >= l_year_start_date
995: AND period.start_date >= g_earliest_start_date

Line 1028: FROM PJI_TIME_ENT_PERIOD newprd

1024: , SYSDATE
1025: , g_user_id
1026: , g_user_id
1027: , g_login_id
1028: FROM PJI_TIME_ENT_PERIOD newprd
1029: , PJI_TIME_ENT_PERIOD oldprd
1030: WHERE 1=1
1031: AND newprd.end_date < l_period_start_date
1032: AND newprd.start_date >= l_qtr_start_date

Line 1029: , PJI_TIME_ENT_PERIOD oldprd

1025: , g_user_id
1026: , g_user_id
1027: , g_login_id
1028: FROM PJI_TIME_ENT_PERIOD newprd
1029: , PJI_TIME_ENT_PERIOD oldprd
1030: WHERE 1=1
1031: AND newprd.end_date < l_period_start_date
1032: AND newprd.start_date >= l_qtr_start_date
1033: AND oldprd.start_date >= g_earliest_start_date

Line 1057: , pji_time_ent_period period

1053: , period.end_date period_end_date
1054: , qtr.end_date qtr_end_date
1055: , YEAR.end_date year_end_date
1056: FROM pji_time_extr_tmp extr
1057: , pji_time_ent_period period
1058: , pji_time_ent_qtr qtr
1059: , pji_time_ent_year YEAR
1060: WHERE 1=1
1061: AND TO_NUMBER(extr.period_year||extr.quarter_num||DECODE(LENGTH(extr.period_num),1,'0'||extr.period_num, extr.period_num)) = period.ent_period_id

Line 1089: FROM PJI_TIME_ENT_PERIOD

1085: , SYSDATE
1086: , g_user_id
1087: , g_user_id
1088: , g_login_id
1089: FROM PJI_TIME_ENT_PERIOD
1090: WHERE start_date >= extr_rec.qtr_start_date
1091: AND start_date <= extr_rec.period_start_date
1092: AND end_date < extr_rec.report_date
1093: UNION ALL

Line 1106: FROM PJI_TIME_ENT_PERIOD

1102: , SYSDATE
1103: , g_user_id
1104: , g_user_id
1105: , g_login_id
1106: FROM PJI_TIME_ENT_PERIOD
1107: WHERE start_date >= extr_rec.qtr_start_date
1108: AND start_date <= extr_rec.period_start_date
1109: AND end_date >= extr_rec.report_date;
1110: