[Home] [Help]
7222: x_returnStatus OUT NOCOPY VARCHAR2) IS
7223:
7224: CURSOR c_mmtt IS
7225: SELECT transaction_temp_id mtl_temp_id
7226: FROM mtl_material_transactions_temp
7227: WHERE transaction_header_id = p_mtl_header_id
7228: AND transaction_action_id = p_txn_action_id
7229: AND transaction_type_id = p_txn_type_id
7230: AND transaction_source_type_id = TPS_INV_JOB_OR_SCHED
7280: -- Fix bug 2369642
7281: --(p_txn_type = WIP_CONSTANTS.MOVE_TXN AND
7282: -- l_mandatory_scrap_flag = WIP_CONSTANTS.YES))) THEN
7283:
7284: UPDATE mtl_material_transactions_temp
7285: SET transaction_temp_id = mtl_material_transactions_s.nextval
7286: WHERE transaction_header_id = p_mtl_header_id
7287: AND transaction_temp_id IS NULL
7288: AND transaction_action_id = p_txn_action_id
7372: 'RCV', -1,
7373: 1) source_code,
7374: MMTT.PRIMARY_QUANTITY primary_quantity
7375: FROM wip_move_txn_interface wmti,
7376: mtl_material_transactions_temp mmtt,
7377: mtl_parameters mp
7378: WHERE wmti.group_id = p_group_id
7379: AND (p_txn_id IS NULL OR wmti.transaction_id = p_txn_id)
7380: AND TRUNC(wmti.transaction_date) = TRUNC(p_txn_date)
7455: IF(l_num_snapshot = 0) THEN
7456: GOTO END_txn;
7457: END IF;
7458:
7459: UPDATE mtl_material_transactions_temp mmtt1
7460: SET mmtt1.transaction_temp_id = mtl_material_transactions_s.nextval
7461: WHERE mmtt1.rowid IN
7462: (SELECT mmtt1.rowid
7463: FROM wip_move_txn_interface wmti,
7462: (SELECT mmtt1.rowid
7463: FROM wip_move_txn_interface wmti,
7464: -- wip_parameters wp,
7465: mtl_parameters mp,
7466: mtl_material_transactions_temp mmtt2
7467: WHERE wmti.group_id = p_group_id
7468: AND TRUNC(wmti.transaction_date) = TRUNC(p_txn_date)
7469: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
7470: AND wmti.process_status = WIP_CONSTANTS.RUNNING
7666: * This procedure is equivalent to witpsst_scrap_txns in wiltps5.ppc
7667: * This procedure is used to update scrap quantity in WIP_DISCRETE_JOBS for
7668: * discrete and OSFM jobs, and WIP_REPETITIVE_SCHEDULES for repetitive
7669: * schedules.
7670: * This procedure also insert into MTL_MATERIAL_TRANSACTIONS_TEMP for costing
7671: * purpose IF the user provide scrap account.
7672: ****************************************************************************/
7673: PROCEDURE scrap_txns(p_gib IN OUT NOCOPY group_rec_t,
7674: x_returnStatus OUT NOCOPY VARCHAR2) IS
7677: SELECT wmti.transaction_id txn_id,
7678: wmti.organization_id org_id,
7679: mmtt.material_allocation_temp_id alloc_id
7680: FROM wip_move_txn_interface wmti,
7681: mtl_material_transactions_temp mmtt
7682: WHERE wmti.transaction_id = mmtt.move_transaction_id
7683: /* Improve performance */
7684: AND mmtt.organization_id = wmti.organization_id
7685: AND mmtt.transaction_source_id = wmti.wip_entity_id
8026: FOR l_step IN WIP_CONSTANTS.QUEUE..WIP_CONSTANTS.RUN LOOP
8027:
8028: -- Discrete and Lotbased jobs
8029: IF(l_move.jobTxn = WIP_CONSTANTS.YES) THEN
8030: INSERT INTO mtl_material_transactions_temp
8031: (last_updated_by,
8032: last_update_date,
8033: last_update_login,
8034: created_by,
8153: -- IF debug message level = 2, write statement below to log file
8154: IF (l_logLevel <= wip_constants.full_logging) THEN
8155: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8156: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8157: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');
8158: l_msg := fnd_message.get;
8159: wip_logger.log(p_msg => l_msg,
8160: x_returnStatus => l_returnStatus);
8161: END IF;
8164:
8165: -- Repetitive schedules
8166: IF(l_move.scheTxn = WIP_CONSTANTS.YES) THEN
8167:
8168: INSERT INTO mtl_material_transactions_temp
8169: (material_allocation_temp_id,
8170: last_updated_by,
8171: last_update_date,
8172: last_update_login,
8288: -- IF debug message level = 2, write statement below to log file
8289: IF (l_logLevel <= wip_constants.full_logging) THEN
8290: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8291: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8292: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');
8293: l_msg := fnd_message.get;
8294: wip_logger.log(p_msg => l_msg,
8295: x_returnStatus => l_returnStatus);
8296: END IF;
8376:
8377: /*****************************************************************************
8378: * This procedure is equivalent to witpscp_completion in wiltps5.ppc
8379: * This procedure is used to do easy completion and easy return
8380: * This procedure insert into MTL_MATERIAL_TRANSACTIONS_TEMP and
8381: * MTL_TRANSACTION_LOTS_TEMP
8382: ****************************************************************************/
8383: PROCEDURE ez_completion(p_gib IN OUT NOCOPY group_rec_t,
8384: p_txn_type IN NUMBER,
8393: transaction_date txn_date,
8394: ABS(primary_quantity) primary_qty,
8395: reason_id reason_id,
8396: transaction_reference reference
8397: FROM mtl_material_transactions_temp
8398: WHERE transaction_header_id = p_header_id
8399: AND wip_entity_type = WIP_CONSTANTS.REPETITIVE
8400: AND transaction_action_id IN (WIP_CONSTANTS.RETASSY_ACTION,
8401: WIP_CONSTANTS.CPLASSY_ACTION);
10027: -- Update lock_flag to 'Y' to prevent inventory worker pick up these
10028: -- records. After we commit, assembly completion record will be in
10029: -- MMTT. There is a slim chance that inventory worker may pick up
10030: -- these records after we commit, and before we call processTemp.
10031: UPDATE mtl_material_transactions_temp
10032: SET lock_flag ='Y'
10033: WHERE transaction_header_id = l_gib.assy_header_id;
10034: END IF;
10035: -- Fixed bug 4361566. Commit to prevent dead lock from calling
10284: | Inventory processing |
10285: +---------------------*/
10286: SELECT count(*)
10287: INTO l_MMTT_record
10288: FROM mtl_material_transactions_temp
10289: WHERE transaction_header_id = l_gib.mtl_header_id;
10290:
10291: IF(l_MMTT_record > 0 AND
10292: l_gib.mtl_mode <> WIP_CONSTANTS.NO_PROCESSING) THEN
10690: sign(mmtt.transaction_quantity), -- transaction_quantity
10691: wmti.transaction_date
10692: FROM wip_move_txn_allocations wmta,
10693: wip_move_txn_interface wmti,
10694: mtl_material_transactions_temp mmtt
10695: WHERE wmti.transaction_id = wmta.transaction_id
10696: AND wmti.organization_id = wmta.organization_id
10697: AND wmti.transaction_id = mmtt.move_transaction_id
10698: AND mmtt.transaction_temp_id = p_tmp_id