APPS.EDW_SOURCE_INST_PKG SQL Statements

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

Line: 48

  UPDATE edw_source_instances_tl
	SET		DESCRIPTION = 	p_src_inst_rec.description
			,NAME		= p_src_inst_rec.name
		  , LAST_UPDATE_DATE  = SYSDATE
		  , LAST_UPDATED_BY   = l_user_id
		  , LAST_UPDATE_LOGIN = l_login_id
		  , SOURCE_LANG       = userenv('LANG')
	where instance_code = p_src_inst_rec.instance_code
	and userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 94

	  UPDATE edw_source_instances
	SET	warehouse_to_instance_link = p_src_inst_rec.LINK
		  , LAST_UPDATE_DATE  = SYSDATE
		  , LAST_UPDATED_BY   = l_user_id
		  , LAST_UPDATE_LOGIN = l_login_id
	where instance_code = p_src_inst_rec.instance_code;

Line: 101

  UPDATE edw_source_instances_tl
	SET		DESCRIPTION = 	p_src_inst_rec.description
			,NAME		= p_src_inst_rec.name
		  , LAST_UPDATE_DATE  = SYSDATE
		  , LAST_UPDATED_BY   = l_user_id
		  , LAST_UPDATE_LOGIN = l_login_id
		  , SOURCE_LANG       = userenv('LANG')
	where instance_code = p_src_inst_rec.instance_code
	and userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 114

	INSERT INTO EDW_SOURCE_INSTANCES(
 		INSTANCE_CODE,		 ENABLED_FLAG,
		 WAREHOUSE_TO_INSTANCE_LINK,		 CREATION_DATE,
		 CREATED_BY,		 LAST_UPDATE_DATE,
		 LAST_UPDATE_LOGIN,		 LAST_UPDATED_BY)
		values
		(	p_src_inst_rec.Instance_code, p_src_inst_rec.enabled_flag,
			p_src_inst_rec.link, sysdate,
			l_user_id, sysdate,
			l_user_id, l_login_id);

Line: 125

	INSERT INTO EDW_SOURCE_INSTANCES_TL(
	 	INSTANCE_CODE,  LANGUAGE,
		TRANSLATED, SOURCE_LANG,
		NAME,  DESCRIPTION,
		CREATION_DATE, CREATED_BY,
		LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LAST_UPDATED_BY)
		select	e.instance_code, l.language_code,
			'Y', userenv('LANG'),
			p_src_inst_rec.name, p_src_inst_rec.description,
			sysdate, l_user_id,
			sysdate, l_login_id, l_user_id
		from fnd_languages L,
		edw_source_instances e
		where l.installed_flag in ('I', 'B')
		and e.instance_code = p_src_inst_rec.instance_code
		and NOT EXISTS
		(SELECT 'EXISTS'	FROM edw_source_instances e, edw_source_instances_tl tl
		WHERE tl.instance_code = e.instance_code
			and tl.language = l.language_code);