42: BEGIN
43: DELETE FII_AP_INV_ON_HOLD_FSTG
44: WHERE COLLECTION_STATUS = 'LOCAL READY'OR ( COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR COLLECTION_STATUS = 'INVALID CURRENCY')
45: AND INSTANCE = (SELECT INSTANCE_CODE
46: FROM EDW_LOCAL_INSTANCE);
47: END;
48:
49: ------------------------------------------------------------
50: --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_INV_ON_HOLD_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