APPS.CS_INSTALLEDBASE_PUB SQL Statements

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

Line: 121

PROCEDURE Update_Product
(
 	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_cp_id						IN	NUMBER,
 	p_as_of_date					IN	DATE	DEFAULT sysdate,
 	p_cp_rec						IN	CP_Prod_Rec_Type,
 	p_ship_rec					IN	CP_Ship_Rec_Type,
	p_comments					IN	VARCHAR2 DEFAULT NULL,
	p_update_by_customer_flag		IN	VARCHAR2 DEFAULT FND_API.G_FALSE,
 	p_abort_on_warn_flag			IN	Abort_Upd_On_Warn_Rec_Type,
 	p_cascade_updates_flag			IN	Cascade_Upd_Flag_Rec_Type,
	p_cascade_inst_date_change_war	IN	VARCHAR2	DEFAULT FND_API.G_TRUE,
    p_org_id                IN NUMBER DEFAULT FND_API.G_MISS_NUM
) IS

BEGIN
  null;

Line: 143

END Update_Product;

Line: 172

PROCEDURE Update_Revision
(
	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_cp_rev_id			IN	NUMBER,
	p_object_version_number	IN	NUMBER,
	p_start_date_active		IN	DATE		DEFAULT FND_API.G_MISS_DATE,
	p_end_date_active		IN	DATE		DEFAULT FND_API.G_MISS_DATE,
	p_desc_flex			IN	CS_InstalledBase_PUB.DFF_Rec_Type,
	x_object_version_number	OUT NOCOPY	NUMBER
) IS

BEGIN
   null;

Line: 190

END Update_Revision;

Line: 210

PROCEDURE Update_Contact
(
	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_cs_contact_id		IN	NUMBER,
	p_object_version_number	IN	NUMBER,
	p_contact_rec			IN	CP_Contact_Rec_Type,
	x_object_version_number	OUT NOCOPY	NUMBER
) IS

BEGIN
  null;

Line: 226

END Update_Contact;

Line: 229

PROCEDURE Delete_Contact
(
	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_cs_contact_id		IN	NUMBER
) IS

BEGIN
   null;

Line: 242

END Delete_Contact;

Line: 414

PROCEDURE Update_Product_Parameters
(
	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_cp_parameter_id		IN      NUMBER,
	p_object_version_number	IN	   NUMBER,
	p_cp_param_rec			IN      CP_Param_Rec_Type,
	x_object_version_number	OUT NOCOPY	   NUMBER
) IS

BEGIN
   null;

Line: 430

END Update_Product_Parameters;

Line: 433

PROCEDURE Delete_Product_Parameters
(
	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_cp_parameter_id   IN      NUMBER
) IS

BEGIN
   null;

Line: 446

END Delete_Product_Parameters;