APPS.CS_SUPPORT_UTIL SQL Statements

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

Line: 25

		select count(*) from ibu_oss_support_id_parties where support_id = v_support_id and party_id = v_party_id;

Line: 47

	insert into IBU_OSS_SUPPORT_ID_PARTIES (
	 SUPPORT_ID,
 	PARTY_ID,
 	CREATED_BY,
 	CREATION_DATE,
 	LAST_UPDATED_BY,
 	LAST_UPDATE_DATE,
 	LAST_UPDATE_LOGIN,
 	SECURITY_GROUP_ID
	) values (
	p_support_id,
	p_party_id,
	l_created_by,
	l_current_date,
	l_created_by,
	l_current_date,
	l_login,
	l_security_group_id);

Line: 69

procedure Delete_Support_Parties_Link (
	p_support_id	IN 	NUMBER,
	p_party_id	IN	NUMBER,
	X_Return_Status	OUT	VARCHAR2
	)

is

begin
	X_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line: 79

	delete from IBU_OSS_SUPPORT_ID_PARTIES where
		SUPPORT_ID = p_support_id AND
		PARTY_ID = p_party_id;

Line: 88

end Delete_Support_Parties_Link;

Line: 108

		select count(*) from cs_support_id_srs where support_id = v_support_id and incident_id = v_incident_id;

Line: 132

	insert into CS_SUPPORT_ID_SRS (
	SUPPORT_ID,
	INCIDENT_ID,
	CREATED_BY,
	CREATION_DATE,
 	LAST_UPDATED_BY,
 	LAST_UPDATE_DATE,
 	LAST_UPDATE_LOGIN,
 	OBJECT_VERSION_NUMBER,
 	SECURITY_GROUP_ID,
	PRODUCT_VERSION,
	PLATFORM_VERSION,
	DBMS_VERSION  ) values (
	p_support_id,
	p_incident_id,
	l_created_by,
	l_current_date,
	l_created_by,
	l_current_date,
	l_login,
	l_object_version,
	l_security_group_id,
	p_product_version,
	p_platform_version,
	p_rdbms_version);

Line: 163

procedure Delete_Support_SR_Link (
	p_support_id	IN 	NUMBER,
	p_incident_id	IN	NUMBER,
	X_Return_Status		OUT	VARCHAR2
)

is

begin
	X_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line: 173

	delete from CS_SUPPORT_ID_SRS where
		SUPPORT_ID = p_support_id AND
		INCIDENT_ID = p_incident_id;

Line: 183

end Delete_Support_SR_Link;

Line: 221

	select CS_SUPPORT_ID_LVLS_S.NEXTVAL into l_support_id_level_id from dual;

Line: 223

	insert into CS_SUPPORT_ID_LVLS (
	SUP_ID_LVL_ID,
	 SUPPORT_ID,
 	SUPPORT_LVL_ID,
	START_DATE,
	END_DATE,
 	CREATED_BY,
 	CREATION_DATE,
 	LAST_UPDATED_BY,
 	LAST_UPDATE_DATE,
 	LAST_UPDATE_LOGIN,
 	OBJECT_VERSION_NUMBER,
 	SECURITY_GROUP_ID
	) values (
	l_support_id_level_id,
	p_support_id,
	p_level_id,
	l_start_date,
	l_end_date,
	l_created_by,
	l_current_date,
	l_created_by,
	l_current_date,
	l_login,
	l_object_version,
	l_security_group_id);

Line: 254

procedure Delete_Support_ID_Level_Link (
	p_support_level_link_id	IN    NUMBER,
	X_Return_Status		OUT	VARCHAR2)


is

begin
	X_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line: 263

	delete from CS_SUPPORT_ID_LVLS where
		sup_id_lvl_id = p_support_level_link_id;

Line: 272

end Delete_Support_ID_Level_Link;

Line: 289

	select count(*) from CS_SUPPORT_ID_LVL_ITEMS where sup_id_lvl_id = v_support_level_link_id and inv_item_id = v_inv_item_id and inv_organization_id = v_inv_org_id;

Line: 319

	insert into CS_SUPPORT_ID_LVL_ITEMS  (
	SUP_ID_LVL_ID,
	INV_ITEM_ID ,
 	INV_ORGANIZATION_ID,
 	CREATED_BY,
 	CREATION_DATE,
 	LAST_UPDATED_BY,
 	LAST_UPDATE_DATE,
 	LAST_UPDATE_LOGIN,
 	OBJECT_VERSION_NUMBER,
 	SECURITY_GROUP_ID
	) values (
	p_support_level_link_id,
	p_item_id,
	l_inv_org_id ,
	l_created_by,
	l_current_date,
	l_created_by,
	l_current_date,
	l_login,
	l_object_version,
	l_security_group_id);

Line: 347

procedure Delete_Support_Level_Item_Link  (
	p_support_level_link_id	IN	NUMBER,
	p_item_id		IN	NUMBER,
	X_Return_Status		OUT	VARCHAR2)
is


begin
	X_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line: 356

	delete from CS_SUPPORT_ID_LVL_ITEMS where
		 sup_id_lvl_id = p_support_leveL_link_id and
		 inv_item_id  = p_item_id and
		 inv_organization_id =  cs_std.get_item_valdn_orgzn_id ();

Line: 367

end Delete_Support_Level_Item_Link;

Line: 369

procedure Delete_All_Level_Item_Link  (
	p_support_leveL_link_id	IN	NUMBER,
	X_Return_Status		OUT	VARCHAR2)
is


begin
	X_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line: 377

	delete from CS_SUPPORT_ID_LVL_ITEMS where
		 sup_id_lvl_id = p_support_leveL_link_id and
		 inv_organization_id =  cs_std.get_item_valdn_orgzn_id ();

Line: 383

end Delete_All_Level_Item_Link;