[Home] [Help]
869: l_transactions_interface_rec.transaction_mode,
870: l_transactions_interface_rec.process_flag,
871: l_transactions_interface_rec.source_header_id, -- 124743, -- ,
872: l_transactions_interface_rec.source_line_id, -- -1, --10,
873: l_transactions_interface_rec.transaction_interface_id, -- null, -- mtl_material_transactions_s.nextval, --l_transaction_interface_id,
874: l_transactions_interface_rec.reason_id, -- swai: bug 6841113
875: l_transactions_interface_rec.final_completion_flag ); -- 'N' ) ;
876:
877:
1825: wdj.primary_item_id = msi.inventory_item_id and
1826: wdj.organization_id = msi.organization_id;
1827:
1828: CURSOR get_mtl_header_id IS
1829: SELECT mtl_material_transactions_s.nextval from dual;
1830:
1831: CURSOR get_last_operation_dtls(c_org_id NUMBER) IS
1832: SELECT
1833: wo.quantity_waiting_to_move,
2532: where rownum=1;
2533: -- end swai: bug 5330060
2534:
2535: /* CURSOR get_material_transaction_id IS
2536: SELECT mtl_material_transactions_s.nextval from dual; */
2537:
2538:
2539: BEGIN
2540:
2895: -- end swai: bug 13820264, FP of bug#13797285, subhat
2896:
2897:
2898: CURSOR get_mtl_header_id IS
2899: SELECT mtl_material_transactions_s.nextval from dual;
2900:
2901: CURSOR get_org_locator_control_code(p_organization_id NUMBER) IS
2902: SELECT stock_locator_control_code from mtl_parameters
2903: where organization_id = p_organization_id;
3938: l_txn_lots_interface_rec mtl_transaction_lots_interface%ROWTYPE;
3939: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
3940:
3941: CURSOR get_mtl_header_id IS
3942: SELECT mtl_material_transactions_s.nextval from dual;
3943:
3944: BEGIN
3945:
3946: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN