[Home] [Help]
5136:
5137: --move enh
5138: --bug 3615826 added the internal_scrap_txn_id column in WLMTI
5139: IF ((l_converted_txn_qty > 0) AND (l_converted_scrap_qty > 0)) THEN
5140: SELECT wip_transactions_s.nextval INTO l_scrap_txn_id from dual;
5141: END IF;
5142:
5143: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
5144: l_msg_tokens.delete;
6303: END IF;
6304: UPDATE wsm_lot_move_txn_interface wlmti
6305: /* LOTATTR: Changed the following so that transaction_id is
6306: updated ONLY if it wasn't populated by the user */
6307: SET transaction_id=nvl(transaction_id,wip_transactions_s.nextval),
6308: wlmti.error = NULL,
6309: wlmti.status = WIP_CONSTANTS.RUNNING,
6310: wlmti.last_update_date = SYSDATE,
6311: wlmti.last_updated_by = decode(nvl(g_user_id, -1),
6447: l_job_exists :=0;
6448: IF (l_first_time=1) THEN
6449: l_stmt_num := 60;
6450:
6451: SELECT wip_transactions_s.nextval
6452: INTO l_wmti_group_id
6453: FROM dual;
6454:
6455: ELSE
8323: (SELECT
8324: decode(l_transaction_quantity,
8325: 0, l_transaction_id,
8326: --bug 3615826
8327: -- wip_transactions_s.nextval),
8328: internal_scrap_txn_id),
8329: LAST_UPDATE_DATE,
8330: LAST_UPDATED_BY,
8331: LAST_UPDATED_BY_NAME,
11805: , sysdate --CREATION_DATE
11806: , g_user_id --CREATED_BY
11807: , fnd_global.user_name--CREATED_BY_NAME
11808: , g_login_id --LAST_UPDATE_LOGIN
11809: , WIP_TRANSACTIONS_S.NEXTVAL --p_group_id --GROUP_ID
11810: , p_source_code --source_code
11811: , WIP_CONSTANTS.PENDING --STATUS
11812: , p_TRANSACTION_TYPE
11813: , p_ORGANIZATION_ID