DBA Data[Home] [Help]

APPS.HXC_ENTITY_GROUPS_UPLOAD_PKG SQL Statements

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

Line: 10

	SELECT entity_group_id FROM hxc_entity_groups
	WHERE entity_type = l_p_entity_type and name = l_p_name;
Line: 40

	SELECT  entity_group_id,
		entity_type,
		object_version_number,
		DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
	INTO
		  l_entity_group_id,
		  l_entity_type ,
		  l_ovn,
		  l_owner
	FROM hxc_entity_groups
	WHERE name = p_name and entity_type = p_entity_type;
Line: 54

	  -- only update if the entity type has actually changed
	 IF (  ( p_entity_type <> l_entity_type ) )
	 THEN
       		hxc_heg_upd.upd
		  (p_entity_group_id         => l_entity_group_id
		  ,p_object_version_number   => l_ovn
		  ,p_name                    => p_name
		  ,p_entity_type             => p_entity_type
		  ) ;
Line: 104

	SELECT
		entity_group_comp_id,
		OBJECT_VERSION_NUMBER,
		DECODE( NVL(last_updated_by,-1),1, 'SEED', 'CUSTOM')
 	INTO
 		l_entity_group_comp_id,
 		l_object_version_number,
 		l_owner
	FROM 	hxc_entity_group_comps
	WHERE	entity_group_id = l_entity_group_id
	AND   	attribute_category = P_ATTRIBUTE_CATEGORY;
Line: 177

 ,p_last_update_date         IN VARCHAR2) IS

l_entity_group_id  HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;
Line: 182

l_last_update_date_db              HXC_ENTITY_GROUPS.last_update_date%TYPE;
Line: 183

l_last_updated_by_db               HXC_ENTITY_GROUPS.last_updated_by%TYPE;
Line: 184

l_last_updated_by_f              HXC_ENTITY_GROUPS.last_updated_by%TYPE;
Line: 185

l_last_update_date_f               HXC_ENTITY_GROUPS.last_update_date%TYPE;
Line: 189

	l_last_updated_by_f := fnd_load_util.owner_id(p_owner);
Line: 190

	l_last_update_date_f := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
Line: 197

	SELECT  entity_group_id,
		entity_type,
		object_version_number
		,last_update_date
			,last_updated_by

	INTO
		  l_entity_group_id,
		  l_entity_type ,
		  l_ovn
		  ,l_last_update_date_db
                        ,l_last_updated_by_db

	FROM hxc_entity_groups
	WHERE name = p_name and entity_type = p_entity_type;
Line: 213

IF (fnd_load_util.upload_test(	l_last_updated_by_f,
					l_last_update_date_f,
	                        	 l_last_updated_by_db,
					l_last_update_date_db ,
					 p_custom_mode))
 THEN
	  -- only update if the entity type has actually changed
	 IF (  ( p_entity_type <> l_entity_type ) )
	 THEN
       		hxc_heg_upd.upd
		  (p_entity_group_id         => l_entity_group_id
		  ,p_object_version_number   => l_ovn
		  ,p_name                    => p_name
		  ,p_entity_type             => p_entity_type
		  ) ;
Line: 252

	 ,p_last_update_date         IN VARCHAR2) IS

l_entity_group_comp_id HXC_ENTITY_GROUP_COMPS.ENTITY_GROUP_comp_ID%TYPE;
Line: 258

l_last_update_date_db              HXC_ENTITY_GROUP_COMPS.last_update_date%TYPE;
Line: 259

l_last_updated_by_db               HXC_ENTITY_GROUP_COMPS.last_updated_by%TYPE;
Line: 260

l_last_updated_by_f               HXC_ENTITY_GROUP_COMPS.last_updated_by%TYPE;
Line: 261

l_last_update_date_f              HXC_ENTITY_GROUP_COMPS.last_update_date%TYPE;
Line: 266

	l_last_updated_by_f := fnd_load_util.owner_id(p_owner);
Line: 267

	l_last_update_date_f := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
Line: 275

	SELECT
		entity_group_comp_id,
		OBJECT_VERSION_NUMBER
		,last_update_date
			,last_updated_by
 	INTO
 		l_entity_group_comp_id,
 		l_object_version_number
 		,l_last_update_date_db
                        ,l_last_updated_by_db
	FROM 	hxc_entity_group_comps
	WHERE	entity_group_id = l_entity_group_id
	AND   	attribute_category = P_ATTRIBUTE_CATEGORY;
Line: 294

	IF (fnd_load_util.upload_test(	l_last_updated_by_f,
					l_last_update_date_f,
	                        	 l_last_updated_by_db,
					l_last_update_date_db ,
					 p_custom_mode))
	THEN
		if g_debug then
			hr_utility.trace('Starting to upd --');