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_FM_XBS_ACCUM_UTILS dependencies on PJI_FM_AGGR_FIN8

Line 298: print_time ( ' Deleting pji_fm_aggr_fin8 0001 p_calendar_type ' || p_calendar_type ) ;

294: update pji_pjp_proj_batch_map set act_err_msg=p_err_msg
295: where project_id=p_project_id;
296:
297: else
298: print_time ( ' Deleting pji_fm_aggr_fin8 0001 p_calendar_type ' || p_calendar_type ) ;
299: IF (p_calendar_type = 'N') THEN
300: print_time ( ' Deleting pji_fm_aggr_fin8 0001.1 ' ) ;
301: l_calendar_type := 'A';
302: l_period_type_id := 2048;

Line 300: print_time ( ' Deleting pji_fm_aggr_fin8 0001.1 ' ) ;

296:
297: else
298: print_time ( ' Deleting pji_fm_aggr_fin8 0001 p_calendar_type ' || p_calendar_type ) ;
299: IF (p_calendar_type = 'N') THEN
300: print_time ( ' Deleting pji_fm_aggr_fin8 0001.1 ' ) ;
301: l_calendar_type := 'A';
302: l_period_type_id := 2048;
303: ELSIF (p_calendar_type = 'P') THEN
304: print_time ( ' Deleting pji_fm_aggr_fin8 0001.2 ' ) ;

Line 304: print_time ( ' Deleting pji_fm_aggr_fin8 0001.2 ' ) ;

300: print_time ( ' Deleting pji_fm_aggr_fin8 0001.1 ' ) ;
301: l_calendar_type := 'A';
302: l_period_type_id := 2048;
303: ELSIF (p_calendar_type = 'P') THEN
304: print_time ( ' Deleting pji_fm_aggr_fin8 0001.2 ' ) ;
305: l_calendar_type := 'P';
306: l_period_type_id := 32;
307: ELSE
308: print_time ( ' Deleting pji_fm_aggr_fin8 0001.3 ' ) ;

Line 308: print_time ( ' Deleting pji_fm_aggr_fin8 0001.3 ' ) ;

304: print_time ( ' Deleting pji_fm_aggr_fin8 0001.2 ' ) ;
305: l_calendar_type := 'P';
306: l_period_type_id := 32;
307: ELSE
308: print_time ( ' Deleting pji_fm_aggr_fin8 0001.3 ' ) ;
309: l_calendar_type := 'G';
310: l_period_type_id := 32;
311: END IF;
312: print_time ( ' get_summarized_data 0002 ' ) ;

Line 343: delete from pji_fm_aggr_fin8 fin where

339: END;
340: END IF;
341:
342: IF l_calendar_type = 'A' THEN
343: delete from pji_fm_aggr_fin8 fin where
344: fin.PROJECT_ID = p_project_id;
345: ELSE
346: delete from pji_fm_aggr_fin8 fin where
347: fin.PROJECT_ID = p_project_id

Line 346: delete from pji_fm_aggr_fin8 fin where

342: IF l_calendar_type = 'A' THEN
343: delete from pji_fm_aggr_fin8 fin where
344: fin.PROJECT_ID = p_project_id;
345: ELSE
346: delete from pji_fm_aggr_fin8 fin where
347: fin.PROJECT_ID = p_project_id
348: AND fin.RECVR_PERIOD_ID <= l_end_period_id;
349: END IF;
350: END IF;

Line 819: pji_fm_aggr_fin8 accum,

815: MIN(time.START_DATE) MIN_START_DATE,
816: MAX(time.END_DATE) MAX_END_DATE
817: FROM
818: pa_res_list_map_tmp4 tmp4,
819: pji_fm_aggr_fin8 accum,
820: pji_time_cal_period_v time,
821: pji_org_extr_info info
822: WHERE
823: tmp4.TXN_SOURCE_ID = accum.TXN_ACCUM_HEADER_ID AND

Line 894: pji_fm_aggr_fin8 accum ,

890: MIN(time.START_DATE) MIN_START_DATE,
891: MAX(time.END_DATE) MAX_END_DATE
892: FROM
893: pa_res_list_map_tmp4 tmp4,
894: pji_fm_aggr_fin8 accum ,
895: pji_time_cal_period_v time --, pji_org_extr_info info
896: WHERE
897: tmp4.TXN_SOURCE_ID = accum.TXN_ACCUM_HEADER_ID AND
898: accum.PROJECT_ID = p_project_ids(i) AND

Line 999: pji_fm_aggr_fin8 fin,

995: MIN(time.START_DATE) MIN_START_DATE,
996: MAX(time.END_DATE) MAX_END_DATE
997: FROM
998: pa_res_list_map_tmp4 tmp4,
999: pji_fm_aggr_fin8 fin,
1000: pji_time_cal_period_v time,
1001: pji_org_extr_info info
1002: WHERE
1003: tmp4.TXN_SOURCE_ID = fin.TXN_ACCUM_HEADER_ID AND

Line 1074: pji_fm_aggr_fin8 fin ,

1070: MIN(time.START_DATE) MIN_START_DATE,
1071: MAX(time.END_DATE) MAX_END_DATE
1072: FROM
1073: pa_res_list_map_tmp4 tmp4,
1074: pji_fm_aggr_fin8 fin ,
1075: pji_time_cal_period_v time --, pji_org_extr_info info
1076: WHERE
1077: tmp4.TXN_SOURCE_ID = fin.TXN_ACCUM_HEADER_ID AND
1078: fin.PROJECT_ID = p_project_ids(i) AND

Line 1363: delete from pji_fm_aggr_fin8 fin where

1359: IF p_calling_context in ('P', 'W') THEN
1360:
1361: IF l_calendar_type(i) = 'A' THEN
1362:
1363: delete from pji_fm_aggr_fin8 fin where
1364: fin.PROJECT_ID = p_project_ids(i);
1365: ELSE
1366:
1367: delete from pji_fm_aggr_fin8 fin where

Line 1367: delete from pji_fm_aggr_fin8 fin where

1363: delete from pji_fm_aggr_fin8 fin where
1364: fin.PROJECT_ID = p_project_ids(i);
1365: ELSE
1366:
1367: delete from pji_fm_aggr_fin8 fin where
1368: fin.PROJECT_ID = p_project_ids(i)
1369: AND fin.RECVR_PERIOD_ID <= l_end_period_id(i);
1370: END IF;
1371: