9797: l_gib.process_phase := p_proc_phase;
9798: l_gib.process_status := WIP_CONSTANTS.RUNNING;
9799: l_gib.time_out := p_time_out;
9800: l_gib.intf_tbl_name := 'WIP_MOVE_TXN_INTERFACE';
9801: l_gib.user_id := fnd_global.user_id;
9802: l_gib.login_id := fnd_global.conc_login_id;
9803: l_gib.request_id := fnd_global.conc_request_id;
9804: l_gib.application_id := fnd_global.prog_appl_id;
9805: l_gib.program_id := fnd_global.conc_program_id;
9798: l_gib.process_status := WIP_CONSTANTS.RUNNING;
9799: l_gib.time_out := p_time_out;
9800: l_gib.intf_tbl_name := 'WIP_MOVE_TXN_INTERFACE';
9801: l_gib.user_id := fnd_global.user_id;
9802: l_gib.login_id := fnd_global.conc_login_id;
9803: l_gib.request_id := fnd_global.conc_request_id;
9804: l_gib.application_id := fnd_global.prog_appl_id;
9805: l_gib.program_id := fnd_global.conc_program_id;
9806: l_gib.seq_move := NVL(p_seq_move, WIP_CONSTANTS.NO);
9799: l_gib.time_out := p_time_out;
9800: l_gib.intf_tbl_name := 'WIP_MOVE_TXN_INTERFACE';
9801: l_gib.user_id := fnd_global.user_id;
9802: l_gib.login_id := fnd_global.conc_login_id;
9803: l_gib.request_id := fnd_global.conc_request_id;
9804: l_gib.application_id := fnd_global.prog_appl_id;
9805: l_gib.program_id := fnd_global.conc_program_id;
9806: l_gib.seq_move := NVL(p_seq_move, WIP_CONSTANTS.NO);
9807: END IF; -- move is online
9800: l_gib.intf_tbl_name := 'WIP_MOVE_TXN_INTERFACE';
9801: l_gib.user_id := fnd_global.user_id;
9802: l_gib.login_id := fnd_global.conc_login_id;
9803: l_gib.request_id := fnd_global.conc_request_id;
9804: l_gib.application_id := fnd_global.prog_appl_id;
9805: l_gib.program_id := fnd_global.conc_program_id;
9806: l_gib.seq_move := NVL(p_seq_move, WIP_CONSTANTS.NO);
9807: END IF; -- move is online
9808:
9801: l_gib.user_id := fnd_global.user_id;
9802: l_gib.login_id := fnd_global.conc_login_id;
9803: l_gib.request_id := fnd_global.conc_request_id;
9804: l_gib.application_id := fnd_global.prog_appl_id;
9805: l_gib.program_id := fnd_global.conc_program_id;
9806: l_gib.seq_move := NVL(p_seq_move, WIP_CONSTANTS.NO);
9807: END IF; -- move is online
9808:
9809: IF(p_proc_phase = WIP_CONSTANTS.MOVE_VAL) THEN
10590: /* Set process phase to 'Running' */
10591: UPDATE wip_move_txn_interface
10592: SET process_status = WIP_CONSTANTS.RUNNING,
10593: last_update_date = SYSDATE,
10594: last_update_login = fnd_global.conc_login_id,
10595: request_id = fnd_global.conc_request_id,
10596: program_application_id = fnd_global.prog_appl_id,
10597: program_id = fnd_global.conc_program_id,
10598: program_update_date = SYSDATE
10591: UPDATE wip_move_txn_interface
10592: SET process_status = WIP_CONSTANTS.RUNNING,
10593: last_update_date = SYSDATE,
10594: last_update_login = fnd_global.conc_login_id,
10595: request_id = fnd_global.conc_request_id,
10596: program_application_id = fnd_global.prog_appl_id,
10597: program_id = fnd_global.conc_program_id,
10598: program_update_date = SYSDATE
10599: WHERE group_id = p_group_id;
10592: SET process_status = WIP_CONSTANTS.RUNNING,
10593: last_update_date = SYSDATE,
10594: last_update_login = fnd_global.conc_login_id,
10595: request_id = fnd_global.conc_request_id,
10596: program_application_id = fnd_global.prog_appl_id,
10597: program_id = fnd_global.conc_program_id,
10598: program_update_date = SYSDATE
10599: WHERE group_id = p_group_id;
10600:
10593: last_update_date = SYSDATE,
10594: last_update_login = fnd_global.conc_login_id,
10595: request_id = fnd_global.conc_request_id,
10596: program_application_id = fnd_global.prog_appl_id,
10597: program_id = fnd_global.conc_program_id,
10598: program_update_date = SYSDATE
10599: WHERE group_id = p_group_id;
10600:
10601: -- Fixed bug 4361566. Set global variable to let inventory know that they