APPS.WSM_LBJ_INTERFACE_PVT dependencies on WSM_SERIAL_TXN_INTERFACE

Line 12030: -- bulk update WSM_SERIAL_TXN_INTERFACE

12026: program_application_id = v_wlji_program_appl_id(i)
12027: where header_id = v_wlji_header_id(i);
12028:
12029: -- ST : Serial Support Project ...........................----------------------------------------------
12030: -- bulk update WSM_SERIAL_TXN_INTERFACE
12031: forall i in v_wlji_process_status.first..v_wlji_process_status.last
12032: update WSM_SERIAL_TXN_INTERFACE
12033: set process_status = v_wlji_process_status(i),
12034: error_message = v_wlji_err_msg(i),

Line 12032: update WSM_SERIAL_TXN_INTERFACE

12028:
12029: -- ST : Serial Support Project ...........................----------------------------------------------
12030: -- bulk update WSM_SERIAL_TXN_INTERFACE
12031: forall i in v_wlji_process_status.first..v_wlji_process_status.last
12032: update WSM_SERIAL_TXN_INTERFACE
12033: set process_status = v_wlji_process_status(i),
12034: error_message = v_wlji_err_msg(i),
12035: request_id = v_wlji_request_id(i),
12036: program_id = v_wlji_program_id(i),

Line 12216: -- Delete successful rows from WSM_SERIAL_TXN_INTERFACE

12212: );
12213: l_stmt_num := 1100.2;
12214:
12215: -- ST : Serial Support Project ...........................----------------------------------------------
12216: -- Delete successful rows from WSM_SERIAL_TXN_INTERFACE
12217: delete from WSM_SERIAL_TXN_INTERFACE
12218: where header_id IN
12219: (select wlji.header_id
12220: from wsm_lot_job_interface wlji

Line 12217: delete from WSM_SERIAL_TXN_INTERFACE

12213: l_stmt_num := 1100.2;
12214:
12215: -- ST : Serial Support Project ...........................----------------------------------------------
12216: -- Delete successful rows from WSM_SERIAL_TXN_INTERFACE
12217: delete from WSM_SERIAL_TXN_INTERFACE
12218: where header_id IN
12219: (select wlji.header_id
12220: from wsm_lot_job_interface wlji
12221: where wlji.process_status = 5