43: BEGIN
44: DELETE FII_AP_INV_LINES_FSTG
45: WHERE COLLECTION_STATUS = 'LOCAL READY'OR ( COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR COLLECTION_STATUS = 'INVALID CURRENCY')
46: AND INSTANCE = (SELECT INSTANCE_CODE
47: FROM EDW_LOCAL_INSTANCE);
48: END;
49:
50: ------------------------------------------------------------
51: --PROCEDURE INSERT_MISSING_RATES_IN_TMP
113:
114:
115: SELECT instance_code
116: INTO l_instance1
117: FROM edw_local_instance;
118:
119: SELECT instance_code
120: INTO l_instance2
121: FROM edw_local_instance@edw_apps_to_wh;
117: FROM edw_local_instance;
118:
119: SELECT instance_code
120: INTO l_instance2
121: FROM edw_local_instance@edw_apps_to_wh;
122:
123: IF (l_instance1 = l_instance2) THEN
124: RETURN TRUE;
125: END IF;
146: UPDATE FII_AP_INV_LINES_FSTG
147: SET COLLECTION_STATUS = 'READY'
148: WHERE COLLECTION_STATUS = 'LOCAL READY'
149: AND INSTANCE = (SELECT INSTANCE_CODE
150: FROM EDW_LOCAL_INSTANCE);
151:
152: RETURN(sql%rowcount);
153:
154: EXCEPTION