APPS.OPI_EDW_OPI_JOB_DETAIL_F_C dependencies on OPI_EDW_OPI_JOB_DETAIL_INC

Line 29: INTO OPI_EDW_OPI_JOB_DETAIL_INC(primary_key1, primary_key2, primary_key3, seq_id)

25:
26: SELECT OPI_EDW_JOB_DETAIL_INC_S.NEXTVAL INTO l_seq_id FROM dual;
27:
28: INSERT
29: INTO OPI_EDW_OPI_JOB_DETAIL_INC(primary_key1, primary_key2, primary_key3, seq_id)
30: SELECT
31: primary_key1,
32: primary_key2,
33: primary_key3,

Line 127: OPI_EDW_OPI_JOB_DETAIL_INC

123: primary_key1,
124: primary_key2,
125: primary_key3
126: FROM
127: OPI_EDW_OPI_JOB_DETAIL_INC
128: );
129:
130: p_count := SQL%rowcount;
131:

Line 132: DELETE FROM OPI_EDW_OPI_JOB_DETAIL_INC WHERE seq_id IS NULL;

128: );
129:
130: p_count := SQL%rowcount;
131:
132: DELETE FROM OPI_EDW_OPI_JOB_DETAIL_INC WHERE seq_id IS NULL;
133: COMMIT;
134:
135: RETURN(l_seq_id);
136:

Line 467: tabname=> 'OPI_EDW_OPI_JOB_DETAIL_INC' );

463: -- --------------------------------------------------------
464: IF fnd_installation.get_app_info( 'OPI', l_status,
465: l_industry, l_opi_schema) THEN
466: fnd_stats.gather_table_stats(ownname=> l_opi_schema,
467: tabname=> 'OPI_EDW_OPI_JOB_DETAIL_INC' );
468: END IF;
469:
470: -- --------------------------------------------------------
471: -- Pushing data to local staging table

Line 498: execute immediate 'truncate table '||l_opi_schema||'.OPI_EDW_OPI_JOB_DETAIL_INC ';

494: -- ---------------------------------------
495: -- Delete all incremental table's records
496: -- ---------------------------------------
497:
498: execute immediate 'truncate table '||l_opi_schema||'.OPI_EDW_OPI_JOB_DETAIL_INC ';
499:
500: -- --------------------------------------------------------------------------
501: -- Insert missing currency rate/invalid currency rows into incremental table
502: -- --------------------------------------------------------------------------

Line 505: INTO OPI_EDW_OPI_JOB_DETAIL_INC(primary_key1, primary_key2, primary_key3)

501: -- Insert missing currency rate/invalid currency rows into incremental table
502: -- --------------------------------------------------------------------------
503:
504: INSERT
505: INTO OPI_EDW_OPI_JOB_DETAIL_INC(primary_key1, primary_key2, primary_key3)
506: SELECT distinct
507: SUBSTRB(JOB_DETAIL_PK,INSTR(JOB_DETAIL_PK,'-',1,1)+1,INSTR(JOB_DETAIL_PK,'-',1,2)-INSTR(JOB_DETAIL_PK,'-',1,1)-1) primary_key1,
508: SUBSTRB(JOB_DETAIL_PK,INSTR(JOB_DETAIL_PK,'-',1,2)+1,INSTR(JOB_DETAIL_PK,'-',1,3)-INSTR(JOB_DETAIL_PK,'-',1,2)-1) primary_key2,
509: SUBSTRB(JOB_DETAIL_PK,INSTR(JOB_DETAIL_PK,'-',1,1)+1,INSTR(JOB_DETAIL_PK,'-',1,3)-INSTR(JOB_DETAIL_PK,'-',1,1)-1) primary_key3

Line 594: || '.opi_edw_opi_job_detail_inc ';

590:
591: IF fnd_installation.get_app_info( 'OPI', l_status,
592: l_industry, l_opi_schema) THEN
593: execute immediate 'truncate table ' || l_opi_schema
594: || '.opi_edw_opi_job_detail_inc ';
595: END IF;
596: edw_log.put_line('Identifying changed records have Failed');
597: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);
598: raise;