APPS.AD_UPDATE_PREFS_PKG SQL Statements

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

Line: 11

	l_name  ad_update_preferences.name%TYPE ;

Line: 12

	p_pref_id ad_update_preferences.preference_id%TYPE ;

Line: 20

	SELECT  preference_id
	  INTO  p_pref_id
	  FROM  ad_update_preferences
	 WHERE  name = l_name
   	   AND  owner= l_owner;

Line: 35

	INSERT INTO ad_update_preferences(
		preference_id,
		owner,
		name,
		description,
		default_value,
		creation_date,
		created_by,
		last_update_date,
		last_updated_by)
	VALUES(
		AD_UPDATE_PREFERENCES_S.NEXTVAL ,
		l_owner,
		l_name,
		p_description,
		p_default_value,
		SYSDATE,
		SYSADMIN_VALUE,
		SYSDATE,
		SYSADMIN_VALUE);

Line: 60

PROCEDURE UPDATE_DEF_PREFERENCE(
                 p_owner          IN  VARCHAR2,
                 p_name           IN  VARCHAR2,
                 p_description    IN  VARCHAR2,
                 p_default_value  IN  VARCHAR2,
                 p_pref_id        OUT NOCOPY  NUMBER )
IS
        l_owner AD_UPDATE_PREFERENCES.owner%TYPE ;

Line: 68

        l_name  AD_UPDATE_PREFERENCES.name%TYPE ;

Line: 75

        SELECT  preference_id
          INTO  p_pref_id
          FROM  ad_update_preferences
         WHERE  name = l_name
           AND  owner= l_owner;

Line: 82

	UPDATE  ad_update_preferences
   	   SET  description = p_description,
        	default_value= p_default_value,
        	last_update_date = SYSDATE,
        	last_updated_by  = SYSADMIN_VALUE
 	 WHERE  name = l_name
   	   AND  owner= l_owner;

Line: 96

END UPDATE_DEF_PREFERENCE;

Line: 105

	l_pref_id ad_update_preferences.preference_id%TYPE ;

Line: 108

	SELECT preference_id INTO l_pref_id
	FROM ad_update_preferences
	WHERE owner = upper(p_owner)
	AND   name  = upper(p_name) ;

Line: 131

	l_value ad_update_pref_values.value%TYPE ;

Line: 134

	SELECT  value INTO l_value
	FROM ad_update_pref_values v,ad_update_preferences p
	WHERE v.preference_id=p.preference_id
	AND  owner = upper(p_owner)
	AND  name = upper(p_name)
	--Check for global or session preference
	AND  pref_level =  decode(p_session_id,NULL,'G','S')
	--Match the session id if session preference otherwise always true for global preference
	AND  NVL (pref_level_value,0)  =  NVL (p_session_id, NVL(pref_level_value, 0) );

Line: 152

		SELECT value INTO l_value
		FROM ad_update_pref_values v,ad_update_preferences p
		WHERE v.preference_id=p.preference_id
		AND  owner = upper(p_owner)
		AND  name = upper(p_name)
		AND  pref_level = 'G';

Line: 177

	l_value ad_update_pref_values.value%TYPE ;

Line: 181

	SELECT  value INTO l_value
	FROM ad_update_pref_values v,ad_update_preferences p
	WHERE v.preference_id=p.preference_id
	AND  owner = upper(p_owner)
	AND  name=upper(p_name )
	AND  pref_level = 'S'
	AND  pref_level_value=p_session_id;

Line: 201

PROCEDURE UPDATE_PREFERENCE_VALUE(
                 p_owner      IN VARCHAR2,
                 p_name       IN VARCHAR2,
                 p_value      IN VARCHAR2)
IS
	p_pref_id AD_UPDATE_PREFERENCES.preference_id%TYPE ;

Line: 207

        l_owner AD_UPDATE_PREFERENCES.owner%TYPE ;

Line: 208

        l_name  AD_UPDATE_PREFERENCES.name%TYPE ;

Line: 209

	l_value AD_UPDATE_PREF_VALUES.value%TYPE ;

Line: 219

	   SELECT value
	   INTO l_value
	   FROM AD_UPDATE_PREF_VALUES
	   WHERE preference_id = p_pref_id
	   AND pref_level = 'G';

Line: 226

	UPDATE  ad_update_pref_values
   	   SET  value  = p_value,
        	last_update_date = SYSDATE,
        	last_updated_by  = SYSADMIN_VALUE
 	 WHERE  preference_id=p_pref_id;

Line: 239

END UPDATE_PREFERENCE_VALUE;

Line: 247

p_pref_id ad_update_preferences.preference_id%TYPE ;

Line: 248

l_owner AD_UPDATE_PREFERENCES.owner%TYPE ;

Line: 249

l_name  AD_UPDATE_PREFERENCES.name%TYPE ;

Line: 259

	SELECT  preference_id
	  INTO  p_pref_id
	  FROM  ad_update_pref_values
	 WHERE  preference_id = p_pref_id
	 AND pref_level = 'G';

Line: 275

	INSERT INTO ad_update_pref_values(
		preference_id,
		pref_level,
		pref_level_value,
		value,
		creation_date,
		created_by,
		last_update_date,
		last_updated_by)
	VALUES(
		p_pref_id,
		'G',
		GLOBAL_SESSION_VALUE,
		p_value,
		SYSDATE,
		SYSADMIN_VALUE,
		SYSDATE,
		SYSADMIN_VALUE);

Line: 304

	l_pref_id ad_update_pref_values.preference_id%TYPE ;

Line: 308

	SELECT preference_id INTO l_pref_id
	FROM ad_update_preferences WHERE
	owner = upper(p_owner)
	AND name = upper(p_name);

Line: 313

	--Update the preference value for that particular session
	UPDATE ad_update_pref_values
	SET value = p_value,
	last_update_date = SYSDATE,
	last_updated_by =SYSADMIN_VALUE
	WHERE
	preference_id = l_pref_id
	AND pref_level = 'S'
	AND pref_level_value=p_session_id;

Line: 324

	-- Create new value record if the value record is not updated
		INSERT INTO ad_update_pref_values(
		preference_id,
		pref_level,
		pref_level_value,
		value,
		creation_date,
		created_by,
		last_update_date,
		last_updated_by)
		VALUES (
		l_pref_id,
		'S',
		p_session_id,
		p_value,
		SYSDATE ,
		SYSADMIN_VALUE,
		SYSDATE ,
		SYSADMIN_VALUE);