APPS.AD_UPDATE_WORK_PARAMS_PKG SQL Statements

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

Line: 10

	l_name  AD_UPDATE_WORK_PARAMS.name%TYPE ;

Line: 14

	--Update the value if the parameter already exists
	UPDATE AD_UPDATE_WORK_PARAMS
	SET  value   =   p_value,
	last_update_date = SYSDATE,
	last_updated_by  = SYSADMIN_VALUE
	WHERE owner  =   l_owner
	AND   name   =   l_name
	AND   session_id = GLOBAL_SESSION_VALUE;

Line: 24

	--Create a new parameter if the parameter has not been updated
		INSERT INTO AD_UPDATE_WORK_PARAMS(
		session_id,
		owner,
		name,
		value,
		creation_date,
		created_by,
		last_update_date,
		last_updated_by)
		VALUES(
		GLOBAL_SESSION_VALUE,
		l_owner,
		l_name,
		p_value,
		SYSDATE ,
		SYSADMIN_VALUE,
		SYSDATE ,
		SYSADMIN_VALUE);

Line: 55

	l_value AD_UPDATE_WORK_PARAMS.value%TYPE ;

Line: 58

	SELECT value INTO l_value
	FROM AD_UPDATE_WORK_PARAMS
	WHERE session_id =  GLOBAL_SESSION_VALUE
	AND   owner      =  upper(p_owner)
	AND   name       =  upper(p_name);

Line: 78

	l_owner AD_UPDATE_WORK_PARAMS.owner%TYPE ;

Line: 79

	l_name  AD_UPDATE_WORK_PARAMS.name%TYPE ;

Line: 84

	--Update the value if the parameter already exists for the session
	UPDATE AD_UPDATE_WORK_PARAMS
	SET  value   =   p_value,
	last_update_date = SYSDATE,
	last_updated_by  = SYSADMIN_VALUE
	WHERE owner  =   l_owner
	AND   name   =   l_name
	AND   session_id = p_session_id;

Line: 94

	--Create a new parameter if the parameter has not been updated for the session
		INSERT INTO AD_UPDATE_WORK_PARAMS(
		session_id,
		owner,
		name,
		value,
		creation_date,
		created_by,
		last_update_date,
		last_updated_by)
		VALUES(
		p_session_id,
		l_owner,
		l_name,
		p_value,
		SYSDATE ,
		SYSADMIN_VALUE,
		SYSDATE,
		SYSADMIN_VALUE);

Line: 127

	l_value AD_UPDATE_WORK_PARAMS.value%TYPE ;

Line: 130

	SELECT value INTO l_value
	FROM AD_UPDATE_WORK_PARAMS
	WHERE session_id =  p_session_id
	AND   owner      =  upper(p_owner)
	AND   name       =  upper(p_name);