APPS.CSD_WF_PROCESS_PVT dependencies on CSD_RO_CREATION_WIP_TXNS

Line 494: from csd_ro_creation_wip_txns CWT

490: and MMT.inventory_item_id = MSI.inventory_item_id
491: and MMT.organization_id = MSI.organization_id
492: and MMT.transaction_id = MUT.transaction_id(+)
493: and NOT EXISTS (select CWT.from_mtl_transaction_id -- check if RO was previously created for this txn
494: from csd_ro_creation_wip_txns CWT
495: where CWT.from_mtl_transaction_id = MMT.transaction_id);
496:
497: -- Cursor to derive repair type attribute
498: Cursor c_get_repair_type_attr(p_repair_type_id in number) is

Line 743: -- insert new into CSD_RO_CREATION_WIP_TXNS to keep track of transaction ids of created ROs

739: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',
740: 'Created RO: Repair Number = ' || l_repair_number || ' for transaction id = ' || l_transaction_id);
741: END IF;
742:
743: -- insert new into CSD_RO_CREATION_WIP_TXNS to keep track of transaction ids of created ROs
744: INSERT INTO CSD_RO_CREATION_WIP_TXNS(
745: repair_order_creation_id,
746: repair_line_id,
747: from_mtl_transaction_id,

Line 744: INSERT INTO CSD_RO_CREATION_WIP_TXNS(

740: 'Created RO: Repair Number = ' || l_repair_number || ' for transaction id = ' || l_transaction_id);
741: END IF;
742:
743: -- insert new into CSD_RO_CREATION_WIP_TXNS to keep track of transaction ids of created ROs
744: INSERT INTO CSD_RO_CREATION_WIP_TXNS(
745: repair_order_creation_id,
746: repair_line_id,
747: from_mtl_transaction_id,
748: from_wip_entity_id,

Line 771: 'Inserted transaction id = ' || l_transaction_id || ' into CSD_RO_CREATION_WIP_TXNS');

767:
768: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
769: fnd_log.STRING (fnd_log.level_statement,
770: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',
771: 'Inserted transaction id = ' || l_transaction_id || ' into CSD_RO_CREATION_WIP_TXNS');
772: END IF;
773:
774: -- clear/reset values in l_repln_rec
775: l_repln_rec := l_repln_rec_clear;