APPS.JTS_CONFIG_VER_STATUS_PVT SQL Statements

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

Line: 113

   l_replayed_date	JTS_CONFIG_VERSION_STATUSES.last_update_date%TYPE;

Line: 174

   l_replayed_date 	JTS_CONFIG_VERSION_STATUSES.last_update_date%TYPE;

Line: 180

SELECT  vs.status_code, l.meaning, vs.creation_date, u.user_name
FROM    jts_config_version_statuses vs,
	fnd_lookup_values l,
	fnd_user u
WHERE	version_id = p_version_id
AND     l.lookup_type = C_STATUS_TYPE
AND     l.lookup_code = vs.status_code
AND	u.user_id (+) = vs.created_by
ORDER BY vs.creation_date DESC;

Line: 257

   INSERT INTO jts_config_version_statuses
   (
     VERSION_ID,
     STATUS_CODE,
     OBJECT_VERSION_NUMBER,
     CREATION_DATE,
     CREATED_BY,
     LAST_UPDATE_DATE,
     LAST_UPDATED_BY,
     LAST_UPDATE_LOGIN
   ) VALUES (
     p_version_id,
     nvl(p_status, C_INIT_VERSION_STATUS),
     1,
     sysdate,
     FND_GLOBAL.user_id,
     sysdate,
     FND_GLOBAL.user_id,
     FND_GLOBAL.user_id
   );

Line: 279

      JTS_CONFIG_VERSION_PVT.update_version_stat(p_api_version,
						 p_version_id,
						 p_status);

Line: 283

      JTS_CONFIG_VERSION_PVT.update_replay_data(p_api_version,
						 p_version_id,
						 p_status);

Line: 298

PROCEDURE DELETE_VERSION_STATUSES(p_api_version	IN  Number,
   				p_version_id	IN  Number) IS
   l_api_version   CONSTANT NUMBER        := 1.0;

Line: 301

   l_api_name      CONSTANT VARCHAR2 (30) := 'DELETE_VERSION_STATUSES';

Line: 313

   DELETE FROM jts_config_version_statuses
   WHERE  version_id = p_version_id;

Line: 319

END DELETE_VERSION_STATUSES;

Line: 323

PROCEDURE DELETE_CONFIG_VER_STATUSES(p_api_version	IN  Number,
   				p_config_id	IN  Number) IS
   l_api_version   CONSTANT NUMBER        := 1.0;

Line: 326

   l_api_name      CONSTANT VARCHAR2 (30) := 'DELETE_CONFIG_VER_STATUSES';

Line: 347

     DELETE FROM jts_config_version_flows
     WHERE  version_id = l_version_id;

Line: 356

END DELETE_CONFIG_VER_STATUSES;