40: BEGIN
41: DELETE FII_AP_HOLD_DATA_FSTG
42: WHERE COLLECTION_STATUS = 'LOCAL READY' OR (COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR COLLECTION_STATUS = 'INVALID CURRENCY')
43: AND INSTANCE = (SELECT INSTANCE_CODE
44: FROM EDW_LOCAL_INSTANCE);
45: END;
46:
47: ------------------------------------------------------------
48: --PROCEDURE INSERT_MISSING_RATES_IN_TMP
101:
102:
103: SELECT instance_code
104: INTO l_instance1
105: FROM edw_local_instance;
106:
107: SELECT instance_code
108: INTO l_instance2
109: FROM edw_local_instance@edw_apps_to_wh;
105: FROM edw_local_instance;
106:
107: SELECT instance_code
108: INTO l_instance2
109: FROM edw_local_instance@edw_apps_to_wh;
110:
111: IF (l_instance1 = l_instance2) THEN
112: RETURN TRUE;
113: END IF;
134: UPDATE FII_AP_HOLD_DATA_FSTG
135: SET COLLECTION_STATUS = 'READY'
136: WHERE COLLECTION_STATUS = 'LOCAL READY'
137: AND INSTANCE = (SELECT INSTANCE_CODE
138: FROM EDW_LOCAL_INSTANCE);
139:
140: RETURN(sql%rowcount);
141:
142: EXCEPTION