DBA Data[Home] [Help]

APPS.CS_INST_DETAIL_PUB SQL Statements

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

Line: 135

PROCEDURE Update_Installation_Details
(
	p_api_version           		IN	NUMBER,
	p_init_msg_list         		IN	VARCHAR2    DEFAULT FND_API.G_FALSE,
	p_commit                		IN	VARCHAR2    DEFAULT FND_API.G_FALSE,
	x_return_status        		OUT NOCOPY	VARCHAR2,
	x_msg_count             		OUT NOCOPY	NUMBER,
	x_msg_data              		OUT NOCOPY	VARCHAR2,
	p_line_inst_dtl_rec     		IN	Line_Inst_Dtl_Rec_Type,
	p_line_inst_dtl_desc_flex	IN	CS_InstalledBase_PUB.DFF_Rec_Type,
	p_object_version_number		IN	NUMBER,
	x_object_version_number		OUT NOCOPY	NUMBER -- was commented
) IS


BEGIN
   null;
Line: 152

END Update_Installation_Details;
Line: 154

PROCEDURE Delete_Installation_Details
(
	p_api_version           IN      NUMBER,
	p_init_msg_list         IN      VARCHAR2    DEFAULT FND_API.G_FALSE,
	p_commit                IN      VARCHAR2    DEFAULT FND_API.G_FALSE,
	x_return_status         OUT NOCOPY     VARCHAR2,
	x_msg_count             OUT NOCOPY     NUMBER,
	x_msg_data              OUT NOCOPY     VARCHAR2,
	p_line_inst_detail_id   IN      NUMBER--,
--	p_object_version_number IN	  NUMBER
) IS
BEGIN
   null;
Line: 167

END Delete_Installation_Details;
Line: 172

PROCEDURE Update_Inst_Details_RMA_Rcpt
(
	p_api_version           		IN	NUMBER,
	p_init_msg_list         		IN	VARCHAR2    DEFAULT FND_API.G_FALSE,
	p_commit                		IN	VARCHAR2    DEFAULT FND_API.G_FALSE,
	x_return_status        		    OUT NOCOPY	VARCHAR2,
	x_msg_count             		OUT NOCOPY	NUMBER,
	x_msg_data              		OUT NOCOPY	VARCHAR2,
	p_rcpt_tbl                		IN	RMA_RCPT_TBL_TYPE,
	p_rcpt_tbl_count             	IN	NUMBER,
	p_order_line_id           		IN	NUMBER,
	p_cp_id                   		IN	NUMBER,
	p_serial_flag              		IN	VARCHAR2,
	p_object_version_number		    IN	NUMBER,
	x_object_version_number		    OUT NOCOPY	NUMBER
) IS

BEGIN
   null;
Line: 191

END Update_Inst_Details_RMA_Rcpt;