APPS.WSM_LBJ_INTERFACE_PVT dependencies on WSM_SERIAL_TXN_INTERFACE

Line 11926: -- bulk update WSM_SERIAL_TXN_INTERFACE

11922: program_application_id = v_wlji_program_appl_id(i)
11923: where header_id = v_wlji_header_id(i);
11924:
11925: -- ST : Serial Support Project ...........................----------------------------------------------
11926: -- bulk update WSM_SERIAL_TXN_INTERFACE
11927: forall i in v_wlji_process_status.first..v_wlji_process_status.last
11928: update WSM_SERIAL_TXN_INTERFACE
11929: set process_status = v_wlji_process_status(i),
11930: error_message = v_wlji_err_msg(i),

Line 11928: update WSM_SERIAL_TXN_INTERFACE

11924:
11925: -- ST : Serial Support Project ...........................----------------------------------------------
11926: -- bulk update WSM_SERIAL_TXN_INTERFACE
11927: forall i in v_wlji_process_status.first..v_wlji_process_status.last
11928: update WSM_SERIAL_TXN_INTERFACE
11929: set process_status = v_wlji_process_status(i),
11930: error_message = v_wlji_err_msg(i),
11931: request_id = v_wlji_request_id(i),
11932: program_id = v_wlji_program_id(i),

Line 12112: -- Delete successful rows from WSM_SERIAL_TXN_INTERFACE

12108: );
12109: l_stmt_num := 1100.2;
12110:
12111: -- ST : Serial Support Project ...........................----------------------------------------------
12112: -- Delete successful rows from WSM_SERIAL_TXN_INTERFACE
12113: delete from WSM_SERIAL_TXN_INTERFACE
12114: where header_id IN
12115: (select wlji.header_id
12116: from wsm_lot_job_interface wlji

Line 12113: delete from WSM_SERIAL_TXN_INTERFACE

12109: l_stmt_num := 1100.2;
12110:
12111: -- ST : Serial Support Project ...........................----------------------------------------------
12112: -- Delete successful rows from WSM_SERIAL_TXN_INTERFACE
12113: delete from WSM_SERIAL_TXN_INTERFACE
12114: where header_id IN
12115: (select wlji.header_id
12116: from wsm_lot_job_interface wlji
12117: where wlji.process_status = 5