The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Delete_OTA_Line(
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
P_Qte_Line_Id IN NUMBER,
X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
IS
CURSOR C_Get_UOM(l_qte_ln_id NUMBER) IS
SELECT UOM_Code FROM ASO_QUOTE_LINES_ALL
WHERE Quote_Line_Id = l_qte_ln_id;
aso_debug_pub.add('Enter Delete_OTA_Line ', 1, 'Y');
aso_debug_pub.add('Delete_OTA_Line- P_Qte_Line_Id: '||P_Qte_Line_Id, 1, 'N');
aso_debug_pub.add('Delete_OTA_Line- l_UOM_Code: '||l_UOM_Code, 1, 'N');
aso_debug_pub.add('Delete_OTA_Line- l_UOM_Code=ENR ', 1, 'N');
aso_debug_pub.add('Delete_OTA_Line- after OTA_ASO_INTERFACE.ota_aso_del: '||X_Return_Status, 1, 'N');
FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_DELETE_OTA_LINE');
END Delete_OTA_Line;
PROCEDURE Update_OTA_With_OrderLine(
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
P_Order_Line_Tbl IN ASO_ORDER_INT.Order_Line_Tbl_Type,
X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
IS
CURSOR C_Get_UOM_Line(l_ship_ln_id NUMBER) IS
SELECT qtl.UOM_Code, qtl.Quote_Line_Id
FROM ASO_QUOTE_LINES_ALL qtl, ASO_SHIPMENTS shp
WHERE shp.Shipment_Id = l_ship_ln_id
AND shp.Quote_Line_Id = qtl.Quote_Line_Id;
aso_debug_pub.add('Enter Update_OTA_Line ', 1, 'Y');
aso_debug_pub.add('Update_OTA_Line- P_Order_Line_Tbl.count: '||P_Order_Line_Tbl.count, 1, 'N');
aso_debug_pub.add('Update_OTA_Line- P_Order_Line_Tbl(i).Quote_Shipment_Line_Id: '||P_Order_Line_Tbl(i).Quote_Shipment_Line_Id, 1, 'N');
aso_debug_pub.add('Update_OTA_Line- l_UOM_Code: '||l_UOM_Code, 1, 'N');
aso_debug_pub.add('Update_OTA_Line- l_Qte_Line_Id: '||l_Qte_Line_Id, 1, 'N');
aso_debug_pub.add('Update_OTA_Line- l_UOM_Code=ENR ', 1, 'N');
aso_debug_pub.add('Update_OTA_Line- after OTA_ASO_INTERFACE.ota_aso_upd: '||X_Return_Status, 1, 'N');
FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_UPDATE_OTA_LINE');
END Update_OTA_With_OrderLine;