APPS.ASO_EDUCATION_INT SQL Statements

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

Line: 11

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;

Line: 30

  aso_debug_pub.add('Enter Delete_OTA_Line ', 1, 'Y');

Line: 31

  aso_debug_pub.add('Delete_OTA_Line- P_Qte_Line_Id: '||P_Qte_Line_Id, 1, 'N');

Line: 47

  aso_debug_pub.add('Delete_OTA_Line- l_UOM_Code: '||l_UOM_Code, 1, 'N');

Line: 53

  aso_debug_pub.add('Delete_OTA_Line- l_UOM_Code=ENR ', 1, 'N');

Line: 64

aso_debug_pub.add('Delete_OTA_Line- after OTA_ASO_INTERFACE.ota_aso_del: '||X_Return_Status, 1, 'N');

Line: 67

	    			FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_DELETE_OTA_LINE');

Line: 74

END Delete_OTA_Line;

Line: 77

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;

Line: 99

  aso_debug_pub.add('Enter Update_OTA_Line ', 1, 'Y');

Line: 100

  aso_debug_pub.add('Update_OTA_Line- P_Order_Line_Tbl.count: '||P_Order_Line_Tbl.count, 1, 'N');

Line: 114

  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');

Line: 122

  aso_debug_pub.add('Update_OTA_Line- l_UOM_Code: '||l_UOM_Code, 1, 'N');

Line: 123

  aso_debug_pub.add('Update_OTA_Line- l_Qte_Line_Id: '||l_Qte_Line_Id, 1, 'N');

Line: 129

  aso_debug_pub.add('Update_OTA_Line- l_UOM_Code=ENR ', 1, 'N');

Line: 141

aso_debug_pub.add('Update_OTA_Line- after OTA_ASO_INTERFACE.ota_aso_upd: '||X_Return_Status, 1, 'N');

Line: 144

                    FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_UPDATE_OTA_LINE');

Line: 153

END Update_OTA_With_OrderLine;