[Home] [Help]
829: l_transactions_interface_rec.transaction_mode,
830: l_transactions_interface_rec.process_flag,
831: l_transactions_interface_rec.source_header_id, -- 124743, -- ,
832: l_transactions_interface_rec.source_line_id, -- -1, --10,
833: l_transactions_interface_rec.transaction_interface_id, -- null, -- mtl_material_transactions_s.nextval, --l_transaction_interface_id,
834: l_transactions_interface_rec.reason_id, -- swai: bug 6841113
835: l_transactions_interface_rec.final_completion_flag ); -- 'N' ) ;
836:
837:
1620: wdj.primary_item_id = msi.inventory_item_id and
1621: wdj.organization_id = msi.organization_id;
1622:
1623: CURSOR get_mtl_header_id IS
1624: SELECT mtl_material_transactions_s.nextval from dual;
1625:
1626: CURSOR get_last_operation_dtls(c_org_id NUMBER) IS
1627: SELECT
1628: wo.quantity_waiting_to_move,
2195: where rownum=1;
2196: -- end swai: bug 5330060
2197:
2198: /* CURSOR get_material_transaction_id IS
2199: SELECT mtl_material_transactions_s.nextval from dual; */
2200:
2201:
2202: BEGIN
2203:
2550:
2551:
2552:
2553: CURSOR get_mtl_header_id IS
2554: SELECT mtl_material_transactions_s.nextval from dual;
2555:
2556: CURSOR get_org_locator_control_code(p_organization_id NUMBER) IS
2557: SELECT stock_locator_control_code from mtl_parameters
2558: where organization_id = p_organization_id;
3501: l_txn_lots_interface_rec mtl_transaction_lots_interface%ROWTYPE;
3502: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
3503:
3504: CURSOR get_mtl_header_id IS
3505: SELECT mtl_material_transactions_s.nextval from dual;
3506:
3507: BEGIN
3508:
3509: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN