APPS.OPI_EDW_OPM_JOB_DETAIL_F_C dependencies on OPI_EDW_JOB_DETAIL_FSTG

Line 44: OPI_EDW_JOB_DETAIL_FSTG

40: /* Define Missing Rate Cursor for Job Detail */
41: Cursor Missing_Rate is
42: SELECT JOB_DETAIL_PK,TRX_DATE_FK,SOB_CURRENCY_FK,INSTANCE_FK
43: FROM
44: OPI_EDW_JOB_DETAIL_FSTG
45: WHERE
46: COLLECTION_STATUS in ('RATE NOT AVAILABLE','INVALID CURRENCY')
47: AND JOB_DETAIL_PK like '%OPM'
48: AND SUBSTRB(JOB_DETAIL_PK,instrB(JOB_DETAIL_PK,'-',1,1)+1,

Line 91: SELECT count(*) into l_count from OPI_EDW_JOB_DETAIL_FSTG where

87: DELETE OPI_EDW_OPM_JOB_DETAIL_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_DETAIL_FSTG where
92: COLLECTION_STATUS in ('RATE NOT AVAILABLE','INVALID CURRENCY')
93: AND JOB_DETAIL_PK like '%OPM';
94: IF l_count > 0 THEN
95:

Line 111: FROM OPI_EDW_JOB_DETAIL_FSTG

107: LINE_TYPE=1 AND
108: BATCH_ID
109: in ( SELECT SUBSTRB(JOB_DETAIL_PK,instrB(JOB_DETAIL_PK,'-',1,1)+1,
110: instrB(JOB_DETAIL_PK,'-',1,2)-1-instrB(JOB_DETAIL_PK,'-',1,1))
111: FROM OPI_EDW_JOB_DETAIL_FSTG
112: WHERE COLLECTION_STATUS in ('RATE NOT AVAILABLE','INVALID CURRENCY')
113: AND JOB_DETAIL_PK like '%OPM');
114: edw_log.Put_line(to_char(sql%rowcount) ||' rows missing Currency Rate Conversion');
115: edw_log.put_line(' ');

Line 125: DELETE OPI_EDW_JOB_DETAIL_FSTG

121: edw_log.put_line(' ');
122:
123: /*Delete all missing rows from FSTG table if source and target are on same instance*/
124: IF (LOCAL_SAME_AS_REMOTE) THEN
125: DELETE OPI_EDW_JOB_DETAIL_FSTG
126: WHERE COLLECTION_STATUS in ('RATE NOT AVAILABLE','INVALID CURRENCY')
127: AND JOB_DETAIL_PK like '%OPM';
128: edw_log.Put_line(to_char(sql%rowcount) ||' missing Currency Rate Conversion rows deleted from Staging table');
129: END IF;

Line 156: INSERT INTO OPI_EDW_JOB_DETAIL_FSTG(

152: -- In our case, we consider the records to be in
153: -- progress until the push_to_local procedure for
154: -- all view types has completed successfully.
155: -- ------------------------------------------------
156: INSERT INTO OPI_EDW_JOB_DETAIL_FSTG(
157: ACT_BPR_VAL_B ,
158: ACT_BPR_VAL_G ,
159: ACT_CMPL_DATE ,
160: ACT_CNCL_DATE ,

Line 423: l_staging_table Varchar2(30) :='OPI_EDW_JOB_DETAIL_FSTG';

419: Retcode in out NOCOPY Varchar2,
420: p_from_date IN Varchar2,
421: p_to_date IN Varchar2) IS
422: l_fact_name Varchar2(30) :='OPI_EDW_JOB_DETAIL_F';
423: l_staging_table Varchar2(30) :='OPI_EDW_JOB_DETAIL_FSTG';
424: l_exception_msg Varchar2(2000):=Null;
425: l_from_date Date:=Null;
426: l_to_date Date:=Null;
427: l_seq_id1 NUMBER := -1;