APPS.FII_PA_BUDGET_F_C dependencies on FII_PA_BUDGET_FSTG

Line 56: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PA_BUDGET_FSTG';

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

Line 69: DELETE FII_PA_BUDGET_FSTG

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

Line 94: FROM FII_PA_BUDGET_FSTG fsi

90: TO_DATE((SUBSTR (BUDGET_LINE_PK, INSTR(BUDGET_LINE_PK,
91: '-')+1,INSTR(BUDGET_LINE_PK,'-',1,2)-(INSTR(BUDGET_LINE_PK,'-')+1))), 'YYYY/MM/DD'),
92: p_conversion_date
93:
94: FROM FII_PA_BUDGET_FSTG fsi
95:
96: WHERE
97:
98: fsi.COLLECTION_STATUS = 'RATE NOT AVAILABLE'

Line 161: UPDATE FII_PA_BUDGET_FSTG

157: IS
158:
159: BEGIN
160:
161: UPDATE FII_PA_BUDGET_FSTG
162: SET COLLECTION_STATUS = 'READY'
163: WHERE COLLECTION_STATUS = 'LOCAL READY'
164: AND INSTANCE = (SELECT INSTANCE_CODE
165: FROM EDW_LOCAL_INSTANCE);

Line 190: Insert Into FII_PA_BUDGET_FSTG

186: l_mau := nvl(edw_currency.get_mau, 0.01 );
187:
188: fii_flex_mapping.init_cache('FII_PA_BUDGET_F');
189:
190: Insert Into FII_PA_BUDGET_FSTG
191: (
192: BUDGET_LINE_PK
193: ,INSTANCE_FK
194: ,SET_OF_BOOKS_FK

Line 320: Insert Into FII_PA_BUDGET_FSTG@EDW_APPS_TO_WH

316: FUNCTION PUSH_REMOTE RETURN NUMBER
317: IS
318: BEGIN
319:
320: Insert Into FII_PA_BUDGET_FSTG@EDW_APPS_TO_WH
321: (
322: BUDGET_LINE_PK
323: ,INSTANCE_FK
324: ,SET_OF_BOOKS_FK

Line 418: from FII_PA_BUDGET_FSTG

414: ,INSTANCE
415: ,OPERATION_CODE
416: ,'READY'
417: ,EDW_RECORD_TYPE
418: from FII_PA_BUDGET_FSTG
419: WHERE collection_status = 'LOCAL READY';
420: --ensures that only the records with collection status of local ready will be pushed to remote fstg
421: RETURN(sql%rowcount);
422:

Line 529: FROM FII_PA_BUDGET_FSTG

525: rows Number:=0;
526: rows1 Number:=0;
527: CURSOR c1 IS SELECT DISTINCT CURRENCY_GL_FK frm_currency,
528: substr(TRANSACTION_DATE,1,10) inv_dt, COLLECTION_STATUS
529: FROM FII_PA_BUDGET_FSTG
530: WHERE COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR COLLECTION_STATUS = 'INVALID CURRENCY';
531:
532: --Cursor declaration required to generate output file containing rows with above collection status
533: