APPS.WSH_DD_TXNS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 16

PROCEDURE Insert_DD_Txn(
	p_dd_txn_info	IN DD_Txn_Rec_Type,
	x_rowid		OUT NOCOPY  VARCHAR2,
	x_dd_txn_id     OUT NOCOPY  NUMBER,
	x_return_status	OUT NOCOPY  VARCHAR2
	) IS

--
l_debug_on BOOLEAN;

Line: 26

l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INSERT_DD_TXN';

Line: 45

     INSERT INTO wsh_dd_txns
        (DD_TXN_ID,
         DD_TXN_DATE,
         DELIVERY_DETAIL_ID,
         RELEASED_STATUS,
         REQUESTED_QUANTITY,
         REQUESTED_QUANTITY_UOM,
         REQUESTED_QUANTITY2,
         REQUESTED_QUANTITY_UOM2,
         PICKED_QUANTITY,
         PICKED_QUANTITY2,
         ATTRIBUTE_CATEGORY,
         ATTRIBUTE1,
         ATTRIBUTE2,
         ATTRIBUTE3,
         ATTRIBUTE4,
         ATTRIBUTE5,
         ATTRIBUTE6,
         ATTRIBUTE7,
         ATTRIBUTE8,
         ATTRIBUTE9,
         ATTRIBUTE10,
         ATTRIBUTE11,
         ATTRIBUTE12,
         ATTRIBUTE13,
         ATTRIBUTE14,
         ATTRIBUTE15,
         CREATION_DATE,
         CREATED_BY,
         LAST_UPDATE_DATE,
         LAST_UPDATED_BY,
         LAST_UPDATE_LOGIN)
     VALUES
        (wsh_dd_txns_s.nextval,  -- bug 5257141
         SYSDATE,
         p_dd_txn_info.DELIVERY_DETAIL_ID,
         p_dd_txn_info.RELEASED_STATUS,
         p_dd_txn_info.REQUESTED_QUANTITY,
         p_dd_txn_info.REQUESTED_QUANTITY_UOM,
         p_dd_txn_info.REQUESTED_QUANTITY2,
         p_dd_txn_info.REQUESTED_QUANTITY_UOM2,
         p_dd_txn_info.PICKED_QUANTITY,
         p_dd_txn_info.PICKED_QUANTITY2,
         p_dd_txn_info.ATTRIBUTE_CATEGORY,
         p_dd_txn_info.ATTRIBUTE1,
         p_dd_txn_info.ATTRIBUTE2,
         p_dd_txn_info.ATTRIBUTE3,
         p_dd_txn_info.ATTRIBUTE4,
         p_dd_txn_info.ATTRIBUTE5,
         p_dd_txn_info.ATTRIBUTE6,
         p_dd_txn_info.ATTRIBUTE7,
         p_dd_txn_info.ATTRIBUTE8,
         p_dd_txn_info.ATTRIBUTE9,
         p_dd_txn_info.ATTRIBUTE10,
         p_dd_txn_info.ATTRIBUTE11,
         p_dd_txn_info.ATTRIBUTE12,
         p_dd_txn_info.ATTRIBUTE13,
         p_dd_txn_info.ATTRIBUTE14,
         p_dd_txn_info.ATTRIBUTE15,
         SYSDATE,
         FND_GLOBAL.USER_ID,
         SYSDATE,
         FND_GLOBAL.USER_ID,
         FND_GLOBAL.LOGIN_ID);

Line: 120

        wsh_util_core.default_handler('WSH_DD_TXNS_PVT.INSERT_DD_TXN',l_module_name);

Line: 128

END Insert_DD_Txn;

Line: 142

  SELECT DELIVERY_DETAIL_ID,
         RELEASED_STATUS,
         REQUESTED_QUANTITY,
         REQUESTED_QUANTITY_UOM,
         REQUESTED_QUANTITY2,
         REQUESTED_QUANTITY_UOM2,
         PICKED_QUANTITY,
         PICKED_QUANTITY2
  FROM
  wsh_delivery_details
  WHERE delivery_detail_id = p_delivery_detail_id;

Line: 283

         WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Insert_DD_Txn');

Line: 287

  Insert_DD_Txn(p_dd_txn_info => l_dd_txn_info,
	x_rowid => l_rowid,
	x_dd_txn_id =>l_dd_txn_id,
	x_return_status => l_return_status);

Line: 295

        WSH_DEBUG_SV.logmsg(l_module_name,' Error in Insert_DD_Txn');