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 828: pji_fm_aggr_fin8 accum,

824: accum.cbs_element_id CBS_ELEMENT_ID
825: -- End OLAP
826: FROM
827: pa_res_list_map_tmp4 tmp4,
828: pji_fm_aggr_fin8 accum,
829: pji_time_cal_period_v time,
830: pji_org_extr_info info
831: WHERE
832: tmp4.TXN_SOURCE_ID = accum.TXN_ACCUM_HEADER_ID AND

Line 910: pji_fm_aggr_fin8 accum ,

906: accum.CBS_ELEMENT_ID CBS_ELEMENT_ID
907: -- End OLAP
908: FROM
909: pa_res_list_map_tmp4 tmp4,
910: pji_fm_aggr_fin8 accum ,
911: pji_time_cal_period_v time --, pji_org_extr_info info
912: WHERE
913: tmp4.TXN_SOURCE_ID = accum.TXN_ACCUM_HEADER_ID AND
914: accum.PROJECT_ID = p_project_ids(i) AND

Line 982: SELECT /+ ordered index (fin PJI_FM_AGGR_FIN8_U1) / /* Added for bug 11843459 */

978: /* Below select statment is added for workplan progress (periodic data) from PJI_FM_AGGR_FIN7
979: To identify those records check for period_flag ='Y'. This is for INCREMENTAL
980: Retrieve Task / Project Level Data for PA/ GL Period
981: */
982: SELECT /*+ ordered index (fin PJI_FM_AGGR_FIN8_U1) */ /* Added for bug 11843459 */
983: /* tmp4.TXN_SOURCE_ID, Commented for workplan progress */
984: min(null) SOURCE_ID,
985: tmp4.RESOURCE_LIST_MEMBER_ID RES_LIST_MEMBER_ID,
986: fin.PROJECT_ID PROJECT_ID,

Line 1028: pji_fm_aggr_fin8 fin,

1024: fin.CBS_ELEMENT_ID CBS_ELEMENT_ID
1025: -- End OLAP
1026: FROM
1027: pa_res_list_map_tmp4 tmp4,
1028: pji_fm_aggr_fin8 fin,
1029: pji_time_cal_period_v time,
1030: pji_org_extr_info info
1031: WHERE
1032: tmp4.TXN_SOURCE_ID = fin.TXN_ACCUM_HEADER_ID AND

Line 1065: SELECT /+ ordered index (fin PJI_FM_AGGR_FIN8_U1) / /* Added for bug 11843459 */

1061: /* Below select statment is added for workplan progress (periodic data) from PJI_FP_TXN_ACCUM
1062: To identify those records check for period_flag ='Y'. This is for FULL and PARTIAL
1063: Retrieve Task / Project Level Data for Non Time Phased Period
1064: */
1065: SELECT /*+ ordered index (fin PJI_FM_AGGR_FIN8_U1) */ /* Added for bug 11843459 */
1066: min(null) SOURCE_ID,
1067: tmp4.RESOURCE_LIST_MEMBER_ID RES_LIST_MEMBER_ID,
1068: fin.PROJECT_ID PROJECT_ID,
1069: p_struct_ver_ids(i) STRUCT_VERSION_ID,

Line 1110: pji_fm_aggr_fin8 fin ,

1106: fin.CBS_ELEMENT_ID
1107: -- End OLAP
1108: FROM
1109: pa_res_list_map_tmp4 tmp4,
1110: pji_fm_aggr_fin8 fin ,
1111: pji_time_cal_period_v time --, pji_org_extr_info info
1112: WHERE
1113: tmp4.TXN_SOURCE_ID = fin.TXN_ACCUM_HEADER_ID AND
1114: fin.PROJECT_ID = p_project_ids(i) AND

Line 1426: delete from pji_fm_aggr_fin8 fin where

1422: IF p_calling_context in ('P', 'W') THEN
1423:
1424: IF l_calendar_type(i) = 'A' THEN
1425:
1426: delete from pji_fm_aggr_fin8 fin where
1427: fin.PROJECT_ID = p_project_ids(i);
1428: ELSE
1429:
1430: delete from pji_fm_aggr_fin8 fin where

Line 1430: delete from pji_fm_aggr_fin8 fin where

1426: delete from pji_fm_aggr_fin8 fin where
1427: fin.PROJECT_ID = p_project_ids(i);
1428: ELSE
1429:
1430: delete from pji_fm_aggr_fin8 fin where
1431: fin.PROJECT_ID = p_project_ids(i)
1432: AND fin.RECVR_PERIOD_ID <= l_end_period_id(i);
1433: END IF;
1434: