APPS.ICX_RELATED_TEMPLATES_PUB SQL Statements

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

Line: 5

PROCEDURE Insert_Relation
( p_api_version_number 	IN	NUMBER			    		,
  p_init_msg_list	IN  	VARCHAR2 := FND_API.G_FALSE		,
  p_simulate		IN	VARCHAR2 := FND_API.G_FALSE 		,
  p_commit		IN	VARCHAR2 := FND_API.G_FALSE 		,
  p_validation_level	IN	NUMBER   := FND_API.G_VALID_LEVEL_FULL	,
  p_return_status	OUT 	VARCHAR2				,
  p_msg_count		OUT	NUMBER					,
  p_msg_data		OUT 	VARCHAR2	    			,
  p_template		IN	VARCHAR2 DEFAULT NULL			,
  p_related_template	IN	VARCHAR2 DEFAULT NULL			,
  p_relationship_type	IN 	VARCHAR2				,
  p_created_by		IN      NUMBER
) IS


l_api_version_number    CONSTANT    NUMBER  :=  1.0;

Line: 31

    SAVEPOINT Insert_Relation_PUB;

Line: 38

	'Insert_Relation',
	G_PKG_NAME)
    THEN
	RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line: 81

	    select count(*) into l_count
   	    from   po_reqexpress_headers
	    where  express_name = p_template;

Line: 97

	    select count(*) into l_count
   	    from   po_reqexpress_headers
	    where  express_name = p_related_template;

Line: 127

	    select count(*) into l_count
	    from   po_related_templates
	    where  express_name = p_template
 	    and    related_express_name = p_related_template;

Line: 146

	    select count(*) into l_count
	    from   po_related_templates
	    where  express_name = p_template
	    and    related_express_name = p_related_template;

Line: 163

	select count(*) into l_count
	from   fnd_lookups
	where  lookup_type = 'ICX_RELATIONS'
	and    enabled_flag = 'Y'
	and    lookup_code = p_relationship_type;

Line: 191

    insert into po_related_templates
       (express_name,
	related_express_name,
	relationship_type,
	created_by,
	creation_date,
	last_updated_by,
	last_update_date)
    values
       (p_template,
	p_related_template,
	p_relationship_type,
	p_created_by,
	sysdate,
	p_created_by,
	sysdate);

Line: 216

	ROLLBACK TO Insert_Relation_PUB;

Line: 264

    	        'Insert_Relation'
	    );

Line: 276

END; -- Insert_Relation

Line: 281

PROCEDURE Delete_Relation
( p_api_version_number 	IN	NUMBER			    		,
  p_init_msg_list	IN  	VARCHAR2 := FND_API.G_FALSE		,
  p_simulate		IN	VARCHAR2 := FND_API.G_FALSE 		,
  p_commit		IN	VARCHAR2 := FND_API.G_FALSE 		,
  p_validation_level	IN	NUMBER   := FND_API.G_VALID_LEVEL_FULL	,
  p_return_status	OUT 	VARCHAR2				,
  p_msg_count		OUT	NUMBER					,
  p_msg_data		OUT 	VARCHAR2	    			,
  p_template		IN	VARCHAR2 DEFAULT NULL			,
  p_related_template	IN	VARCHAR2 DEFAULT NULL
) IS


l_api_version_number    CONSTANT    NUMBER  :=  1.0;

Line: 306

    SAVEPOINT Delete_Relation_PUB;

Line: 313

	'Delete Relation',
	G_PKG_NAME)
    THEN
	RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line: 356

    delete from po_related_templates
    where  express_name = p_template
    and    related_express_name = p_related_template;

Line: 368

	ROLLBACK TO Insert_Relation_PUB;

Line: 392

	    -- add message: Relation to delete does not exist
	    FND_MESSAGE.SET_NAME('ICX','ICX_CAT_DELETE');

Line: 433

    	        'Delete_Relation'
	    );

Line: 445

END; -- Delete_Relation