APPS.ASO_INSTBASE_INT SQL Statements

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

Line: 50

PROCEDURE Delete_Installation_Detail
(
	p_api_version_number    IN      NUMBER,
	p_init_msg_list         IN      VARCHAR2    := FND_API.G_FALSE,
	p_commit                IN      VARCHAR2    := FND_API.G_FALSE,
	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,
	p_line_inst_dtl_id      IN      NUMBER
)
IS

  l_api_version_number NUMBER := 1.0;

Line: 63

  l_api_name VARCHAR2(50)     := 'Delete_Installation_Detail';

Line: 68

  SAVEPOINT Delete_Installation_detail_PUB;

Line: 98

    CSI_T_Txn_Details_GRP.Delete_Transaction_Dtls(
      p_api_version         => 1.0,
      p_init_msg_list       => p_init_msg_list,
      p_commit              => p_commit,
      x_return_status       => x_return_status,
      x_msg_count           => x_msg_count,
      x_msg_data            => x_msg_data,
      p_transaction_line_id    => p_line_inst_dtl_id
    );

Line: 172

END Delete_Installation_Detail;

Line: 182

PROCEDURE Update_Inst_Details_ORDER
(
  p_api_version_number			IN	NUMBER,
	p_init_msg_list		IN	VARCHAR2  := FND_API.G_FALSE,
	p_commit	  IN	VARCHAR2  := FND_API.G_FALSE,
	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,
	p_quote_line_shipment_id		IN	NUMBER,
	p_order_line_id		IN	NUMBER
)
IS

  -- hyang, bug 2860045, performance fix.

  CURSOR C_quote_line(quote_line_shipment_id number)
  IS
    SELECT quote_line_id
    FROM aso_shipments
    WHERE shipment_id = quote_line_shipment_id;

Line: 205

   select transaction_line_id
   from csi_t_transaction_lines
   where source_transaction_id = quote_line_id
   and source_transaction_table = 'ASO_QUOTE_LINES_ALL';

Line: 212

  l_api_name           VARCHAR2(240) := 'UPDATE_INST_DETAILS_ORDER';

Line: 221

  SAVEPOINT Update_Inst_details_ORder_PUB;

Line: 258

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

Line: 350

END Update_Inst_Details_ORDER;

Line: 369

     select  quote_line_id
     from aso_line_relationships  aso_rel
     where aso_rel.related_quote_line_id = l_quote_line_id;

Line: 374

     select inventory_item_id
     from aso_quote_lines_all
     where quote_line_id = x_top_model_line_id;