APPS.FII_PA_COST_F_C dependencies on FII_PA_COST_FSTG

Line 58: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PA_COST_FSTG';

54: l_industry VARCHAR2(30);
55:
56: BEGIN
57: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
58: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PA_COST_FSTG';
59: EXECUTE IMMEDIATE l_stmt;
60: END IF;
61: END;
62:

Line 71: DELETE FII_PA_COST_FSTG

67: PROCEDURE DELETE_STG
68: IS
69:
70: BEGIN
71: DELETE FII_PA_COST_FSTG
72: WHERE COLLECTION_STATUS = 'LOCAL READY'OR ( COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR COLLECTION_STATUS = 'INVALID CURRENCY')
73: AND INSTANCE = (SELECT INSTANCE_CODE
74: FROM EDW_LOCAL_INSTANCE);
75: END;

Line 94: FROM FII_PA_COST_FSTG fcf

90: SELECT
91: TO_NUMBER(SUBSTR (COST_PK, 1, INSTR(COST_PK, '-' )-1)),
92: TO_NUMBER(SUBSTR (COST_PK, INSTR(COST_PK, '-')+1,INSTR(COST_PK,'-',1,2)-(INSTR(COST_PK,'-')+1)))
93:
94: FROM FII_PA_COST_FSTG fcf
95:
96: WHERE
97:
98: fcf.COLLECTION_STATUS = 'RATE NOT AVAILABLE'

Line 107: select count(*) into rows2 from FII_PA_COST_FSTG;

103: g_retcode := 1;
104: g_missing_rates := 1;
105: END IF;
106: --Generates "Warning" message in the Status column of Concurrent Manager "Requests" table
107: select count(*) into rows2 from FII_PA_COST_FSTG;
108:
109: if g_debug_flag = 'Y' then
110: edw_log.put_line('Number of rows in stg'||rows2 );
111: edw_log.put_line(' ');

Line 164: UPDATE FII_PA_COST_FSTG

160: IS
161:
162: BEGIN
163:
164: UPDATE FII_PA_COST_FSTG
165: SET COLLECTION_STATUS = 'READY'
166: WHERE COLLECTION_STATUS = 'LOCAL READY'
167: AND INSTANCE = (SELECT INSTANCE_CODE
168: FROM EDW_LOCAL_INSTANCE);

Line 203: Insert into FII_PA_COST_FSTG (

199:
200:
201: -- insert records from the source view into the local staging table
202:
203: Insert into FII_PA_COST_FSTG (
204: COST_PK,
205: INSTANCE_FK,
206: SET_OF_BOOKS_FK,
207: PROJECT_FK,

Line 359: Insert Into FII_PA_COST_FSTG@EDW_APPS_TO_WH

355: FUNCTION PUSH_REMOTE RETURN NUMBER
356: IS
357:
358: BEGIN
359: Insert Into FII_PA_COST_FSTG@EDW_APPS_TO_WH
360: (
361: COST_PK,
362: INSTANCE_FK,
363: SET_OF_BOOKS_FK,

Line 478: from FII_PA_COST_FSTG

474: INSTANCE,
475: null,
476: 'READY',
477: EDW_RECORD_TYPE
478: from FII_PA_COST_FSTG
479: WHERE collection_status = 'LOCAL READY';
480: --ensures that only the records with collection status of local ready will be pushed to remote fstg
481: RETURN(sql%rowcount);
482: EXCEPTION

Line 578: FROM FII_PA_COST_FSTG

574: my_collection_status Varchar2(2000):=NULL;
575: rows Number:=0;
576: rows1 Number:=0;
577: CURSOR c1 IS SELECT DISTINCT FROM_CURRENCY, substr(TRANSACTION_DATE,1,10 ) inv_dt, COLLECTION_STATUS
578: FROM FII_PA_COST_FSTG
579: WHERE COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR COLLECTION_STATUS = 'INVALID CURRENCY';
580:
581: Begin
582: Errbuf :=NULL;

Line 625: select count(*) into rows1 from FII_PA_COST_FSTG;

621: TRUNCATE_STG;
622: ELSE
623: DELETE_STG;
624: END IF;
625: select count(*) into rows1 from FII_PA_COST_FSTG;
626:
627: if g_debug_flag = 'Y' then
628: edw_log.put_line('Number of rows in stg after truncating or deleting'||rows1 );
629: fii_util.stop_timer;