APPS.OZF_DENORM_QUERIES_PVT SQL Statements

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

Line: 41

   SELECT ozf_denorm_queries_s.NEXTVAL
   FROM DUAL;

Line: 46

   SELECT count(*)
     FROM ozf_denorm_queries
    WHERE denorm_query_id = denorm_id;

Line: 112

	 --dbms_output.put_line('before insert'||SUBSTR(l_stringArray(1),1,150));

Line: 114

         INSERT INTO ozf_denorm_queries(
		                    DENORM_QUERY_ID
                                   ,QUERY_FOR
	                           ,CONTEXT
 				   ,ATTRIBUTE
				   ,CONDITION_ID_COLUMN
			           ,CONDITION_NAME_COLUMN
			           ,ACTIVE_FLAG
				   ,CREATION_DATE
		 	           ,CREATED_BY
 	        		   ,LAST_UPDATE_DATE
				   ,LAST_UPDATED_BY
		 	           ,LAST_UPDATE_LOGIN
				   ,SEEDED_FLAG
  				   ,SQL_VALIDATION_1
				   ,SQL_VALIDATION_2
				   ,SQL_VALIDATION_3
				   ,SQL_VALIDATION_4
		 	           ,SQL_VALIDATION_5
		 	           ,SQL_VALIDATION_6
		 	           ,SQL_VALIDATION_7
			           ,SQL_VALIDATION_8,
			   	   OBJECT_VERSION_NUMBER
                                    )
         VALUES(
		 l_denorm_queries_rec.denorm_query_id,
	         l_denorm_queries_rec.QUERY_FOR,
                 l_denorm_queries_rec.CONTEXT,
                 l_denorm_queries_rec.ATTRIBUTE ,
                 l_denorm_queries_rec.CONDITION_ID_COLUMN,
                 l_denorm_queries_rec.CONDITION_NAME_COLUMN,
	 	 nvl(l_denorm_queries_rec.active_flag,'N'),
	         SYSDATE,
		 FND_GLOBAL.user_id,
		 SYSDATE,
		 FND_GLOBAL.user_id,
		 FND_GLOBAL.conc_login_id,
		 'N',
		 l_stringArray(1),
                 l_stringArray(2),
		 l_stringArray(3),
                 l_stringArray(4),
                 l_stringArray(5),
		 l_stringArray(6),
                 l_stringArray(7),
                 l_stringArray(8),
		 1

	        );

Line: 228

PROCEDURE update_denorm_queries(
   p_api_version       IN  NUMBER,
   p_init_msg_list     IN  VARCHAR2  := FND_API.g_false,
   p_commit            IN  VARCHAR2  := FND_API.g_false,
   p_validation_level  IN  NUMBER    := FND_API.g_valid_level_full,

   p_denorm_queries_rec          IN  denorm_queries_rec_type,

   x_return_status     OUT NOCOPY VARCHAR2,
   x_msg_count         OUT NOCOPY NUMBER,
   x_msg_data          OUT NOCOPY VARCHAR2
)
IS

   l_api_version CONSTANT NUMBER := 1.0;

Line: 243

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

Line: 256

   OZF_Utility_PVT.debug_message(l_full_name||': entered update');

Line: 259

   SAVEPOINT update_denorm_queries;

Line: 307

		UPDATE ozf_denorm_queries SET
		        last_update_date = SYSDATE,
			last_updated_by = FND_GLOBAL.user_id,
			last_update_login = FND_GLOBAL.conc_login_id,
			active_flag = nvl(temp_denorm_queries_rec.active_flag,'N'),
			query_for = temp_denorm_queries_rec.query_for,
			context = temp_denorm_queries_rec.context,
			attribute = temp_denorm_queries_rec.attribute,
			condition_name_column = temp_denorm_queries_rec.condition_name_column,
			condition_id_column = temp_denorm_queries_rec.condition_id_column,
			sql_validation_1 = l_stringArray(1),
			sql_validation_2 = l_stringArray(2),
			sql_validation_3 = l_stringArray(3),
			sql_validation_4 = l_stringArray(4),
			sql_validation_5 = l_stringArray(5),
			sql_validation_6 = l_stringArray(6),
			sql_validation_7 = l_stringArray(7),
			sql_validation_8 = l_stringArray(8),
			object_version_number=temp_denorm_queries_rec.object_version_number+1
			WHERE denorm_query_id = temp_denorm_queries_rec.denorm_query_id
		         AND object_version_number =temp_denorm_queries_rec.object_version_number;

Line: 357

      ROLLBACK TO update_denorm_queries;

Line: 366

      ROLLBACK TO update_denorm_queries;

Line: 377

      ROLLBACK TO update_denorm_queries;

Line: 391

END update_denorm_queries;

Line: 400

PROCEDURE delete_denorm_queries(
   p_api_version       IN  NUMBER,
   p_init_msg_list     IN  VARCHAR2 := FND_API.g_false,
   p_commit            IN  VARCHAR2 := FND_API.g_false,

   p_denorm_query_id            IN  NUMBER,
   p_object_version    IN  NUMBER,

   x_return_status     OUT NOCOPY VARCHAR2,
   x_msg_count         OUT NOCOPY NUMBER,
   x_msg_data          OUT NOCOPY VARCHAR2
)
IS

   l_api_version CONSTANT NUMBER       := 1.0;

Line: 415

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

Line: 423

   SAVEPOINT delete_denorm_queries;

Line: 444

   OZF_Utility_PVT.debug_message(l_full_name ||': delete');

Line: 446

   delete ozf_denorm_queries
   WHERE denorm_query_id = p_denorm_query_id
   AND OBJECT_VERSION_NUMBER=p_object_version;

Line: 466

      ROLLBACK TO delete_denorm_queries;

Line: 475

      ROLLBACK TO delete_denorm_queries;

Line: 484

      ROLLBACK TO delete_denorm_queries;

Line: 498

END delete_denorm_queries;

Line: 633

 select denorm_query_id from ozf_denorm_queries
 where query_for=p_query_for and context=p_context_name
 and attribute=p_context_attribute;

Line: 851

 select query_for,context,attribute from ozf_denorm_queries
 where query_for=p_query_for and context=p_context_name
 and attribute=p_context_attribute;

Line: 903

   SELECT *
     FROM ozf_denorm_queries
     WHERE denorm_query_id = p_denorm_queries_rec.denorm_query_id;

Line: 947

  IF p_denorm_queries_rec.last_update_date = FND_API.g_miss_date THEN
      x_complete_rec.last_update_date := NULL;

Line: 950

  IF p_denorm_queries_rec.last_update_date IS NULL THEN
      x_complete_rec.last_update_date := l_denorm_queries_rec.last_update_date;

Line: 953

  IF p_denorm_queries_rec.last_updated_by = FND_API.g_miss_num THEN
      x_complete_rec.last_updated_by := NULL;

Line: 956

  IF p_denorm_queries_rec.last_updated_by IS NULL THEN
      x_complete_rec.last_updated_by := l_denorm_queries_rec.last_updated_by;

Line: 960

  IF p_denorm_queries_rec.last_update_login = FND_API.g_miss_num THEN
      x_complete_rec.last_update_login := NULL;

Line: 963

  IF p_denorm_queries_rec.last_update_login IS NULL THEN
      x_complete_rec.last_update_login := l_denorm_queries_rec.last_update_login;