APPS.WMS_WIP_XDOCK_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 976: SELECT mtl_material_transactions_s.NEXTVAL

972: l_ret := 0;
973:
974: -- Need to create a new MMTT line and call TM here!
975: /*
976: SELECT mtl_material_transactions_s.NEXTVAL
977: INTO l_new_temp_id
978: FROM dual;
979:
980: SELECT mtl_material_transactions_s.NEXTVAL

Line 980: SELECT mtl_material_transactions_s.NEXTVAL

976: SELECT mtl_material_transactions_s.NEXTVAL
977: INTO l_new_temp_id
978: FROM dual;
979:
980: SELECT mtl_material_transactions_s.NEXTVAL
981: INTO l_new_txn_hdr_id
982: FROM dual;
983: */
984:

Line 1422: SELECT mtl_material_transactions_s.NEXTVAL

1418: WHERE transaction_temp_id = txn_tmp_id;
1419:
1420: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1421: BEGIN
1422: SELECT mtl_material_transactions_s.NEXTVAL
1423: INTO new_txn_temp_id
1424: FROM DUAL;
1425:
1426: x_new_temp_id := new_txn_temp_id;

Line 1428: SELECT mtl_material_transactions_s.NEXTVAL

1424: FROM DUAL;
1425:
1426: x_new_temp_id := new_txn_temp_id;
1427:
1428: SELECT mtl_material_transactions_s.NEXTVAL
1429: INTO l_new_txn_hdr_id
1430: FROM DUAL;
1431:
1432: x_new_hdr_id := l_new_txn_hdr_id;

Line 1569: SELECT mtl_material_transactions_s.NEXTVAL

1565: IF (l_debug = 1) THEN
1566: mydebug('child lot row with temp id ' || lot_row.transaction_temp_id);
1567: END IF;
1568:
1569: SELECT mtl_material_transactions_s.NEXTVAL
1570: INTO ser_transaction_temp_id
1571: FROM DUAL;
1572:
1573: OPEN msnt(lot_row.serial_transaction_temp_id);

Line 1585: SELECT mtl_material_transactions_s.NEXTVAL

1581: IF (l_debug = 1) THEN
1582: mydebug('child lot ser row with temp id ' || ser_row.transaction_temp_id);
1583: END IF;
1584:
1585: SELECT mtl_material_transactions_s.NEXTVAL
1586: INTO ser_row.transaction_temp_id
1587: FROM DUAL;
1588:
1589: ser_row.transaction_temp_id := ser_transaction_temp_id;