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.PJI_TIME_C dependencies on PJI_TIME_EXTR_TMP

Line 270: DELETE pji_time_extr_tmp;

266: l_min_date DATE;
267: l_max_date DATE;
268: BEGIN
269:
270: DELETE pji_time_extr_tmp;
271:
272: INSERT INTO pji_time_extr_tmp(period_year
273: , quarter_num
274: , period_num

Line 272: INSERT INTO pji_time_extr_tmp(period_year

268: BEGIN
269:
270: DELETE pji_time_extr_tmp;
271:
272: INSERT INTO pji_time_extr_tmp(period_year
273: , quarter_num
274: , period_num
275: , period_name
276: , start_date

Line 317: FROM pji_time_extr_tmp;

313: , SYSDATE
314: , g_user_id
315: , g_user_id
316: , g_login_id
317: FROM pji_time_extr_tmp;
318:
319: l_no_rows_inserted := SQL%rowcount;
320:
321: IF g_debug_flag = 'Y' THEN

Line 425: WHERE ent_qtr_id in (SELECT DISTINCT period_year||quarter_num FROM pji_time_extr_tmp);

421: END IF;
422: END IF;
423:
424: DELETE FROM pji_time_ent_qtr
425: WHERE ent_qtr_id in (SELECT DISTINCT period_year||quarter_num FROM pji_time_extr_tmp);
426:
427: l_no_rows_deleted := SQL%rowcount;
428:
429: IF g_debug_flag = 'Y' THEN

Line 459: FROM pji_time_extr_tmp

455: , SYSDATE
456: , g_user_id
457: , g_user_id
458: , g_login_id
459: FROM pji_time_extr_tmp
460: GROUP BY
461: period_year||quarter_num
462: , period_year
463: , quarter_num

Line 518: WHERE ent_year_id in (SELECT DISTINCT period_year from pji_time_extr_tmp);

514: END IF;
515: END IF;
516:
517: DELETE FROM pji_time_ent_year
518: WHERE ent_year_id in (SELECT DISTINCT period_year from pji_time_extr_tmp);
519:
520: l_no_rows_deleted := SQL%rowcount;
521:
522: IF g_debug_flag = 'Y' THEN

Line 552: FROM pji_time_extr_tmp

548: , SYSDATE
549: , g_user_id
550: , g_user_id
551: , g_login_id
552: FROM pji_time_extr_tmp
553: GROUP BY period_year
554: HAVING MAX(end_date) 555: OR MIN(start_date)>g_latest_end_date
556: OR g_cal_info_exists = 'N';

Line 582: DELETE pji_time_extr_tmp;

578: l_no_rows_inserted NUMBER := 0;
579: l_min_date DATE;
580: l_max_date DATE;
581: BEGIN
582: DELETE pji_time_extr_tmp;
583:
584: INSERT INTO pji_time_extr_tmp(period_year
585: , quarter_num
586: , period_num

Line 584: INSERT INTO pji_time_extr_tmp(period_year

580: l_max_date DATE;
581: BEGIN
582: DELETE pji_time_extr_tmp;
583:
584: INSERT INTO pji_time_extr_tmp(period_year
585: , quarter_num
586: , period_num
587: , period_name
588: , start_date

Line 629: FROM pji_time_extr_tmp;

625: , SYSDATE
626: , g_user_id
627: , g_user_id
628: , g_login_id
629: FROM pji_time_extr_tmp;
630:
631: l_no_rows_inserted := SQL%rowcount;
632:
633: IF g_debug_flag = 'Y' THEN

Line 738: WHERE cal_qtr_id in (SELECT DISTINCT LPAD(p_calendar_id,3,'0')||period_year||quarter_num FROM pji_time_extr_tmp);

734: END IF;
735: END IF;
736:
737: DELETE FROM pji_time_cal_qtr
738: WHERE cal_qtr_id in (SELECT DISTINCT LPAD(p_calendar_id,3,'0')||period_year||quarter_num FROM pji_time_extr_tmp);
739:
740: l_no_rows_deleted := SQL%rowcount;
741:
742: IF g_debug_flag = 'Y' THEN

Line 772: FROM pji_time_extr_tmp

768: , SYSDATE
769: , g_user_id
770: , g_user_id
771: , g_login_id
772: FROM pji_time_extr_tmp
773: GROUP BY period_year||quarter_num
774: , period_year
775: , quarter_num
776: HAVING MAX(end_date)

Line 836: WHERE cal_year_id in (SELECT DISTINCT LPAD(p_calendar_id,3,'0')||period_year from pji_time_extr_tmp);

832: END IF;
833: END IF;
834:
835: DELETE FROM pji_time_cal_year
836: WHERE cal_year_id in (SELECT DISTINCT LPAD(p_calendar_id,3,'0')||period_year from pji_time_extr_tmp);
837:
838: l_no_rows_deleted := SQL%rowcount;
839:
840: IF g_debug_flag = 'Y' THEN

Line 868: FROM pji_time_extr_tmp

864: , SYSDATE
865: , g_user_id
866: , g_user_id
867: , g_login_id
868: FROM pji_time_extr_tmp
869: GROUP BY period_year
870: HAVING MAX(end_date) 871: OR MIN(start_date)>p_latest_end_date
872: OR p_cal_info_exists = 'N';

Line 1056: FROM pji_time_extr_tmp extr

1052: , YEAR.start_date year_start_date
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

Line 1392: FROM pji_time_extr_tmp extr

1388: , YEAR.start_date year_start_date
1389: , period.end_date period_end_date
1390: , qtr.end_date qtr_end_date
1391: , YEAR.end_date year_end_date
1392: FROM pji_time_extr_tmp extr
1393: , pji_time_cal_period period
1394: , pji_time_cal_qtr qtr
1395: , pji_time_cal_year YEAR
1396: WHERE 1=1