APPS.OPI_EDW_OPM_JOB_RSRC_F_C dependencies on OPI_EDW_OPM_JOB_RSRC_INC

Line 50: OPI_EDW_OPM_JOB_RSRC_INC

46: AND JOB_RSRC_PK like '%OPM'
47: AND SUBSTRB(JOB_RSRC_PK,instrB(JOB_RSRC_PK,'-',-1,3)+1,
48: instrB(JOB_RSRC_PK,'-',-1,2)-1-instrB(JOB_RSRC_PK,'-',-1,3))
49: in (select PRIMARY_KEY from
50: OPI_EDW_OPM_JOB_RSRC_INC
51: WHERE SEQ_ID is NULL);
52:
53: BEGIN
54: /* Print Header */

Line 87: DELETE OPI_EDW_OPM_JOB_RSRC_INC;

83: IS
84: l_count number;
85: BEGIN
86: /* Delete the incremental table before inserting new data */
87: DELETE OPI_EDW_OPM_JOB_RSRC_INC;
88: edw_log.put_line(' ');
89: edw_log.Put_line('Identifying Missing Rate Rows ');
90: edw_log.put_line(' ');
91: SELECT count(*) into l_count from OPI_EDW_JOB_RSRC_FSTG where

Line 97: INSERT /*+ parallel(OPI_EDW_OPM_JOB_RSRC_INC) */

93: AND JOB_RSRC_PK like '%OPM';
94: IF l_count > 0 THEN
95:
96: /* insert into Incremental table all line_id where Currency is missing */
97: INSERT /*+ parallel(OPI_EDW_OPM_JOB_RSRC_INC) */
98: into OPI_EDW_OPM_JOB_RSRC_INC(PRIMARY_KEY,view_id,seq_id)
99: SELECT
100: BATCHSTEPLINE_ID,
101: 1,

Line 98: into OPI_EDW_OPM_JOB_RSRC_INC(PRIMARY_KEY,view_id,seq_id)

94: IF l_count > 0 THEN
95:
96: /* insert into Incremental table all line_id where Currency is missing */
97: INSERT /*+ parallel(OPI_EDW_OPM_JOB_RSRC_INC) */
98: into OPI_EDW_OPM_JOB_RSRC_INC(PRIMARY_KEY,view_id,seq_id)
99: SELECT
100: BATCHSTEPLINE_ID,
101: 1,
102: NULL

Line 315: INSERT /*+ parallel(OPI_EDW_OPM_JOB_RSRC_INC) */

311: l_industry VARCHAR2(30);
312: BEGIN
313: p_count := 0;
314: select OPI_EDW_JOB_RSRC_INC_S.nextval into l_seq_id from dual;
315: INSERT /*+ parallel(OPI_EDW_OPM_JOB_RSRC_INC) */
316: into OPI_EDW_OPM_JOB_RSRC_INC(PRIMARY_KEY,view_id,seq_id)
317: SELECT
318: BATCHSTEPLINE_ID,
319: 1,

Line 316: into OPI_EDW_OPM_JOB_RSRC_INC(PRIMARY_KEY,view_id,seq_id)

312: BEGIN
313: p_count := 0;
314: select OPI_EDW_JOB_RSRC_INC_S.nextval into l_seq_id from dual;
315: INSERT /*+ parallel(OPI_EDW_OPM_JOB_RSRC_INC) */
316: into OPI_EDW_OPM_JOB_RSRC_INC(PRIMARY_KEY,view_id,seq_id)
317: SELECT
318: BATCHSTEPLINE_ID,
319: 1,
320: l_seq_id

Line 329: from OPI_EDW_OPM_JOB_RSRC_INC

325: AND GREATEST(POD.LAST_UPDATE_DATE, PBH.LAST_UPDATE_DATE)
326: BETWEEN g_push_from_date and g_push_to_date
327: AND BATCHSTEPLINE_ID not in (
328: SELECT PRIMARY_KEY
329: from OPI_EDW_OPM_JOB_RSRC_INC
330: WHERE SEQ_ID is NULL);
331: p_count := sql%rowcount;
332:
333: /* Update the Missing Currency convenrsion rows with new Sequence */

Line 334: Update OPI_EDW_OPM_JOB_RSRC_INC set view_id=1,seq_id=l_seq_id

330: WHERE SEQ_ID is NULL);
331: p_count := sql%rowcount;
332:
333: /* Update the Missing Currency convenrsion rows with new Sequence */
334: Update OPI_EDW_OPM_JOB_RSRC_INC set view_id=1,seq_id=l_seq_id
335: WHERE seq_id is NULL;
336:
337: p_count:=p_count+sql%rowcount;
338:

Line 343: TABNAME => 'OPI_EDW_OPM_JOB_RSRC_INC');

339: Commit;
340:
341: IF (FND_INSTALLATION.GET_APP_INFO('OPI', l_status, l_industry, l_OPI_schema)) THEN
342: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_OPI_schema,
343: TABNAME => 'OPI_EDW_OPM_JOB_RSRC_INC');
344: END IF;
345:
346: RETURN(l_seq_id);
347: EXCEPTION