APPS.JTF_FM_HISTORY_UTIL_PVT dependencies on JTF_FM_PARTITION_X_REQUEST

Line 50: UPDATE JTF_FM_PARTITION_X_REQUEST SET REQUEST_ID=NULL WHERE REQUEST_ID = p_request_id;

46: DELETE FROM JTF_FM_REQUEST_CONTENTS WHERE REQUEST_ID = p_request_id;
47: DELETE FROM JTF_FM_REQUEST_HISTORY WHERE HIST_REQ_ID = p_request_id;
48:
49: --Clear partition record
50: UPDATE JTF_FM_PARTITION_X_REQUEST SET REQUEST_ID=NULL WHERE REQUEST_ID = p_request_id;
51:
52: COMMIT WORK;
53:
54: END DELETE_REQUEST_HISTORY;

Line 147: UPDATE JTF_FM_PARTITION_X_REQUEST

143: RAISE e_error_found;
144: END IF;
145:
146: --CLEAN THE DATA FROM PARTITION TABLE AS WELL
147: UPDATE JTF_FM_PARTITION_X_REQUEST
148: SET REQUEST_ID=NULL
149: WHERE REQUEST_ID=c_header_record.request_id ;
150:
151: