APPS.PJI_RM_SUM_EXTR dependencies on PJI_RM_AGGR_RES1

Line 26: insert /*+ append parallel(res1_i) */ into PJI_RM_AGGR_RES1 res1_i

22:
23: --The calendar_type is hard coded as 'C'. The dangling 'P' and 'G'
24: --records are inserted into TMP1 as 'C'
25:
26: insert /*+ append parallel(res1_i) */ into PJI_RM_AGGR_RES1 res1_i
27: (
28: WORKER_ID,
29: DANGLING_FLAG,
30: ROW_ID,

Line 119: from PJI_RM_AGGR_RES1

115: delete /*+ parallel(res) */
116: from PJI_RM_DNGL_RES res
117: where WORKER_ID = 0 and
118: ROWID in (select ROW_ID
119: from PJI_RM_AGGR_RES1
120: where WORKER_ID = p_worker_id);
121:
122: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION (l_process, 'PJI_RM_SUM_EXTR.PURGE_DANGLING_ROWS(p_worker_id);');
123:

Line 212: insert /*+ append parallel(res1_i) */ into PJI_RM_AGGR_RES1 res1_i

208: l_min_date := to_number(to_char(to_date(
209: PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),
210: PJI_RM_SUM_MAIN.g_date_mask), 'J'));
211:
212: insert /*+ append parallel(res1_i) */ into PJI_RM_AGGR_RES1 res1_i
213: (
214: WORKER_ID,
215: DANGLING_FLAG,
216: RECORD_TYPE,

Line 585: -- - Aggregate and insert data into PJI_RM_AGGR_RES1

581: -- The following steps are done in this procedure
582: -- - Extract data from FID
583: -- - Identify dangling records
584: -- - Identify data for partial refresh
585: -- - Aggregate and insert data into PJI_RM_AGGR_RES1
586: -- -----------------------------------------------------
587: PROCEDURE EXTRACT_BATCH_FID (p_worker_id IN NUMBER) IS
588:
589: l_process VARCHAR2(30);

Line 627: insert /*+ append parallel(res1_i) */ into PJI_RM_AGGR_RES1 res1_i

623: degree => BIS_COMMON_PARAMETERS.
624: GET_DEGREE_OF_PARALLELISM);
625:
626: -- Initial/Incremental collection from forecast log table
627: insert /*+ append parallel(res1_i) */ into PJI_RM_AGGR_RES1 res1_i
628: (
629: WORKER_ID,
630: DANGLING_FLAG,
631: RECORD_TYPE,

Line 915: PJI_RM_AGGR_RES1 tmp

911: JOB_ID,
912: WORK_TYPE_ID,
913: PROJECT_ID
914: from
915: PJI_RM_AGGR_RES1 tmp
916: where
917: WORKER_ID = p_worker_id and
918: DANGLING_FLAG is not null;
919:

Line 921: from PJI_RM_AGGR_RES1

917: WORKER_ID = p_worker_id and
918: DANGLING_FLAG is not null;
919:
920: delete
921: from PJI_RM_AGGR_RES1
922: where WORKER_ID = p_worker_id and
923: DANGLING_FLAG is not null;
924:
925: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION (l_process, 'PJI_RM_SUM_EXTR.MOVE_DANGLING_ROWS(p_worker_id);');

Line 1004: PJI_RM_AGGR_RES1 tmp1

1000: GL_CALENDAR_ID,
1001: PA_CALENDAR_ID,
1002: JOB_ID
1003: from
1004: PJI_RM_AGGR_RES1 tmp1
1005: where
1006: WORKER_ID = p_worker_id and
1007: RECORD_TYPE = 'U' and
1008: CAPACITY_HRS >= 0 and

Line 1048: insert /*+ append parallel(res1_i) */ into PJI_RM_AGGR_RES1 res1_i

1044:
1045: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1046: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
1047:
1048: insert /*+ append parallel(res1_i) */ into PJI_RM_AGGR_RES1 res1_i
1049: (
1050: WORKER_ID,
1051: DANGLING_FLAG,
1052: RECORD_TYPE,

Line 1362: PJI_RM_AGGR_RES1 tmp1,

1358: tmp1.UNASSIGNED_HRS_S,
1359: tmp1.CONF_OVERCOM_HRS_S,
1360: tmp1.PROV_OVERCOM_HRS_S
1361: from
1362: PJI_RM_AGGR_RES1 tmp1,
1363: PJI_RM_AGGR_RES3 tmp3,
1364: PJI_RM_RES_WT_F rmr
1365: where
1366: tmp1.WORKER_ID = p_worker_id and