APPS.AHL_MM_MTL_MGT_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 4566: SELECT Mtl_Material_Transactions_S.nextval

4562:
4563: G_DEBUG_LINE_NUM := 150;
4564: l_transaction_header_id := NULL; -- this will identify the records to be picked up by transaction Manager
4565:
4566: SELECT Mtl_Material_Transactions_S.nextval
4567: INTO l_transaction_header_id
4568: FROM DUAL;
4569:
4570: --log

Line 4837: SELECT Mtl_Material_Transactions_S.nextval INTO p_x_txn_hdr_id FROM DUAL;

4833: ',transaction header id '||p_x_txn_hdr_id);
4834: END IF;
4835:
4836: IF(p_x_txn_hdr_id IS NULL) THEN
4837: SELECT Mtl_Material_Transactions_S.nextval INTO p_x_txn_hdr_id FROM DUAL;
4838: END IF;
4839: G_DEBUG_LINE_NUM := 210;
4840: SELECT Mtl_Material_Transactions_S.nextval INTO p_x_txn_intf_id FROM DUAL;
4841: IF (l_log_statement >= l_log_current_level) THEN

Line 4840: SELECT Mtl_Material_Transactions_S.nextval INTO p_x_txn_intf_id FROM DUAL;

4836: IF(p_x_txn_hdr_id IS NULL) THEN
4837: SELECT Mtl_Material_Transactions_S.nextval INTO p_x_txn_hdr_id FROM DUAL;
4838: END IF;
4839: G_DEBUG_LINE_NUM := 210;
4840: SELECT Mtl_Material_Transactions_S.nextval INTO p_x_txn_intf_id FROM DUAL;
4841: IF (l_log_statement >= l_log_current_level) THEN
4842: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Interface Id created - '||p_x_txn_intf_id);
4843:
4844: END IF;