APPS.EGO_BULKLOAD_ENTITIES dependencies on EGO_BULKLOAD_INTF

Line 85: UPDATE EGO_BULKLOAD_INTF

81: l_intf_status_tobe_process := 1;
82: l_intf_status_upload_done := 99;
83: -- the bulkload line status must be changed
84: -- to uploaded to appropriate interface tables
85: UPDATE EGO_BULKLOAD_INTF
86: SET process_status = l_intf_status_upload_done
87: WHERE resultfmt_usage_id = p_result_format_usage_id
88: AND process_status = l_intf_status_tobe_process;
89: EXCEPTION

Line 165: UPDATE EGO_BULKLOAD_INTF

161: Write_Debug('Login id : '||to_char(FND_GLOBAL.login_id));
162: Write_Debug('Program Application Id : '||to_char(FND_GLOBAL.prog_appl_id));
163: Write_Debug('Concurrent Program Id : '||to_char(FND_GLOBAL.conc_program_id));
164:
165: UPDATE EGO_BULKLOAD_INTF
166: SET
167: PROCESS_STATUS = G_DATA_ROWS_READY_FOR_API,
168: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
169: REQUEST_ID = FND_GLOBAL.conc_request_id,

Line 249: UPDATE EGO_BULKLOAD_INTF

245:
246: ---------------------------------------------------------------------
247: -- Setting PROCESS_STATUS to 1 Prior to Calling BOM APIs
248: ---------------------------------------------------------------------
249: UPDATE EGO_BULKLOAD_INTF
250: SET PROCESS_STATUS = 1
251: WHERE RESULTFMT_USAGE_ID = result_format_usage_id;
252:
253: COMMIT;

Line 259: UPDATE EGO_BULKLOAD_INTF SET PROCESS_STATUS = 1

255: /*
256: SNELLOLI: CALL THE BOM API
257: after setting the process status to 1 again
258: has to check for errors later
259: UPDATE EGO_BULKLOAD_INTF SET PROCESS_STATUS = 1
260: WHERE RESULTFMT_USAGE_ID = result_format_usage_id;
261: commit;
262: */
263: FND_FILE.PUT_LINE( FND_FILE.LOG,'Calling BOM BULKLOAD AFTER UPDATION');