APPS.FII_PA_REVENUE_F_C dependencies on FII_PA_REVENUE_FSTG

Line 63: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PA_REVENUE_FSTG';

59: l_industry VARCHAR2(30);
60:
61: BEGIN
62: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
63: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PA_REVENUE_FSTG';
64: EXECUTE IMMEDIATE l_stmt;
65: END IF;
66: END;
67:

Line 76: DELETE FII_PA_REVENUE_FSTG

72: PROCEDURE DELETE_STG
73: IS
74:
75: BEGIN
76: DELETE FII_PA_REVENUE_FSTG
77: WHERE COLLECTION_STATUS = 'LOCAL READY' OR ( COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR COLLECTION_STATUS = 'INVALID CURRENCY')
78: AND INSTANCE = (SELECT INSTANCE_CODE
79: FROM EDW_LOCAL_INSTANCE);
80: END;

Line 98: FROM FII_PA_REVENUE_FSTG FPF

94: SELECT
95: TO_NUMBER(SUBSTR (revenue_PK, 1, INSTR(REVENUE_PK, '-' )-1)),
96: TO_NUMBER(SUBSTR (REVENUE_PK, INSTR(REVENUE_PK,'-')+1,INSTR(REVENUE_PK,'-',1,2)-(INSTR(REVENUE_PK,'-')+1)))
97:
98: FROM FII_PA_REVENUE_FSTG FPF
99:
100: WHERE
101: FPF.REVENUE_PK LIKE '%-EXP-%'
102: AND (FPF.COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR FPF.COLLECTION_STATUS = 'INVALID CURRENCY');

Line 121: FROM FII_PA_REVENUE_FSTG FPF

117: TO_NUMBER(SUBSTR (REVENUE_PK, 1, INSTR(REVENUE_PK, '-' )-1)),
118: TO_NUMBER(SUBSTR (REVENUE_PK, INSTR(REVENUE_PK,'-')+1,INSTR(REVENUE_PK,'-',1,2)-(INSTR(REVENUE_PK,'-')+1))),
119: TO_NUMBER(DECODE((SUBSTR (REVENUE_PK, INSTR(REVENUE_PK,'-',1,2)+1,INSTR(REVENUE_PK,'-',1,3)-(INSTR(REVENUE_PK,'-',1,2)+1)))
120: , 'NA', null, (SUBSTR (REVENUE_PK, INSTR(REVENUE_PK,'-',1,2)+1,INSTR(REVENUE_PK,'-',1,3)-(INSTR(REVENUE_PK,'-',1,2)+1)))))
121: FROM FII_PA_REVENUE_FSTG FPF
122:
123: WHERE
124: FPF.REVENUE_PK LIKE '%-EVN-%'
125: AND (FPF.COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR FPF.COLLECTION_STATUS = 'INVALID CURRENCY');

Line 192: UPDATE FII_PA_REVENUE_FSTG

188: IS
189:
190: BEGIN
191:
192: UPDATE FII_PA_REVENUE_FSTG
193: SET COLLECTION_STATUS = 'READY'
194: WHERE COLLECTION_STATUS = 'LOCAL READY'
195: AND INSTANCE = (SELECT INSTANCE_CODE
196: FROM EDW_LOCAL_INSTANCE);

Line 222: Insert Into FII_PA_REVENUE_FSTG

218: l_mau := nvl(edw_currency.get_mau, 0.01 );
219:
220: fii_flex_mapping.init_cache('FII_PA_REVENUE_F');
221:
222: Insert Into FII_PA_REVENUE_FSTG
223: (
224: CURRENCY_GL_FK,
225: CUSTOMER_FK,
226: GL_ACCT10_FK,

Line 352: Insert Into FII_PA_REVENUE_FSTG@EDW_APPS_TO_WH

348: -----------------------------------------------------------
349: FUNCTION PUSH_REMOTE RETURN NUMBER
350: IS
351: BEGIN
352: Insert Into FII_PA_REVENUE_FSTG@EDW_APPS_TO_WH
353: (
354: CURRENCY_GL_FK,
355: CUSTOMER_FK,
356: GL_ACCT10_FK,

Line 451: from FII_PA_REVENUE_FSTG

447: INSTANCE_FK,
448: NULL,
449: 'READY',
450: EDW_RECORD_TYPE
451: from FII_PA_REVENUE_FSTG
452: WHERE collection_status = 'LOCAL READY';
453: --ensures that only the records with collection status of local ready will be pushed to remote fstg
454: RETURN(sql%rowcount);
455:

Line 579: FROM FII_PA_REVENUE_FSTG

575: rows Number:=0;
576: rows1 Number:=0;
577: CURSOR c1 IS SELECT DISTINCT CURRENCY_GL_FK frm_currency,
578: SUBSTR(PA_DATE_FK,1,(INSTR(PA_DATE_FK, '-',1,3)-1)) inv_dt, COLLECTION_STATUS
579: FROM FII_PA_REVENUE_FSTG
580: WHERE COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR COLLECTION_STATUS = 'INVALID CURRENCY';
581:
582: --Cursor declaration required to generate output file containing rows with above collection status
583: Begin