APPS.JTF_EC_REFERENCES_PVT SQL Statements

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

Line: 207

   PROCEDURE update_references (
      p_api_version               IN       NUMBER,
      p_init_msg_list             IN       VARCHAR2 DEFAULT fnd_api.g_false,
      p_commit                    IN       VARCHAR2 DEFAULT fnd_api.g_false,
      p_object_version_number     IN OUT NOCOPY  NUMBER,
      p_escalation_reference_id   IN       NUMBER,
      p_object_type_code          IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
      p_object_name               IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
      p_object_id                 IN       NUMBER DEFAULT fnd_api.g_miss_num,
      p_object_details            IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
      p_reference_code            IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
      p_usage                     IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
      x_return_status             OUT NOCOPY     VARCHAR2,
      x_msg_data                  OUT NOCOPY     VARCHAR2,
      x_msg_count                 OUT NOCOPY     NUMBER,
      p_attribute1                IN       VARCHAR2 DEFAULT null ,
      p_attribute2                IN       VARCHAR2 DEFAULT null ,
      p_attribute3                IN       VARCHAR2 DEFAULT null ,
      p_attribute4                IN       VARCHAR2 DEFAULT null ,
      p_attribute5                IN       VARCHAR2 DEFAULT null ,
      p_attribute6                IN       VARCHAR2 DEFAULT null ,
      p_attribute7                IN       VARCHAR2 DEFAULT null ,
      p_attribute8                IN       VARCHAR2 DEFAULT null ,
      p_attribute9                IN       VARCHAR2 DEFAULT null ,
      p_attribute10               IN       VARCHAR2 DEFAULT null ,
      p_attribute11               IN       VARCHAR2 DEFAULT null ,
      p_attribute12               IN       VARCHAR2 DEFAULT null ,
      p_attribute13               IN       VARCHAR2 DEFAULT null ,
      p_attribute14               IN       VARCHAR2 DEFAULT null ,
      p_attribute15               IN       VARCHAR2 DEFAULT null ,
      p_attribute_category        IN       VARCHAR2 DEFAULT null,
      p_task_id			  IN       NUMBER DEFAULT fnd_api.g_miss_num
   )
   IS
      l_api_version   CONSTANT NUMBER                                        := 1.0;

Line: 243

               := 'UPDATE_REFERENCES';

Line: 249

         SELECT 1 x
           FROM jtf_task_references_vl
          WHERE task_reference_id = p_escalation_reference_id;

Line: 261

         SELECT REFERENCE_CODE , OBJECT_TYPE_CODE , OBJECT_ID, TASK_ID
           FROM JTF_TASK_REFERENCES_B
          WHERE task_reference_id = reference_id;

Line: 270

      SAVEPOINT update_references_pub;

Line: 315

         SELECT 1
           INTO x
           FROM jtf_tasks_vl tasks,
                jtf_task_references_vl reference,
                jtf_task_statuses_vl status
          WHERE reference.task_reference_id <> p_escalation_reference_id
            AND tasks.task_id = reference.task_id
            AND tasks.task_type_id = jtf_ec_pub.g_escalation_type_id
            AND reference.object_type_code = p_object_type_code
            AND reference.object_id = p_object_id
            AND tasks.task_status_id = status.task_status_id
            AND status.closed_flag = 'Y';

Line: 367

      jtf_task_references_pub.update_references (
         p_api_version => 1.0,
         p_init_msg_list => fnd_api.g_false,
         p_commit => fnd_api.g_false,
         p_object_version_number => p_object_version_number,
         p_task_reference_id => p_escalation_reference_id,
         p_object_type_code => p_object_type_code,
         p_object_name => p_object_name,
         p_object_id => p_object_id,
         p_object_details => p_object_details,
         p_reference_code => p_reference_code,
         p_usage => NULL,
         x_return_status => x_return_status,
         x_msg_data => x_msg_data,
         x_msg_count => x_msg_count,
	 p_attribute1    =>     p_attribute1,
	 p_attribute2    =>     p_attribute2,
	 p_attribute3    =>     p_attribute3,
	 p_attribute4    =>     p_attribute4,
	 p_attribute5    =>     p_attribute5,
	 p_attribute6    =>     p_attribute6,
	 p_attribute7    =>     p_attribute7,
	 p_attribute8    =>     p_attribute8,
	 p_attribute9    =>     p_attribute9,
	 p_attribute10    =>    p_attribute10,
	 p_attribute11    =>    p_attribute11,
	 p_attribute12    =>    p_attribute12,
	 p_attribute13    =>    p_attribute13,
	 p_attribute14    =>     p_attribute14,
	 p_attribute15    =>     p_attribute15,
         p_attribute_category  => p_attribute_category
      );

Line: 414

      jtf_esc_wf_events_pvt.publish_update_escRef
                      (P_ESC_REF_REC_OLD	  => 	l_esc_ref_rec_old,
                       P_ESC_REF_REC_NEW	  => 	l_esc_ref_rec_new);

Line: 426

         ROLLBACK TO update_references_pub;

Line: 431

         ROLLBACK TO update_references_pub;

Line: 439

         ROLLBACK TO update_references_pub;

Line: 452

   PROCEDURE delete_references (
      p_api_version               IN       NUMBER,
      p_init_msg_list             IN       VARCHAR2 DEFAULT fnd_api.g_false,
      p_commit                    IN       VARCHAR2 DEFAULT fnd_api.g_false,
      p_object_version_number     IN       NUMBER,
      p_escalation_reference_id   IN       NUMBER,
      x_return_status             OUT NOCOPY     VARCHAR2,
      x_msg_data                  OUT NOCOPY     VARCHAR2,
      x_msg_count                 OUT NOCOPY     NUMBER
   )
   IS
      l_api_version   CONSTANT NUMBER       := 1.0;

Line: 464

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

Line: 471

         SELECT REFERENCE_CODE, OBJECT_TYPE_CODE, OBJECT_ID, TASK_ID
           FROM JTF_TASK_REFERENCES_B
          WHERE task_reference_id = reference_id;

Line: 478

      SAVEPOINT delete_task_reference_pub;

Line: 502

      jtf_task_references_pvt.delete_references (
         p_api_version => 1.0,
         p_init_msg_list => fnd_api.g_false,
         p_commit => fnd_api.g_false,
         p_object_version_number => p_object_version_number,
         p_task_reference_id => p_escalation_reference_id,
         x_return_status => x_return_status,
         x_msg_data => x_msg_data,
         x_msg_count => x_msg_count
      );

Line: 535

       jtf_esc_wf_events_pvt.publish_delete_escRef
              (p_esc_ref_rec              => l_esc_ref_rec);

Line: 545

         ROLLBACK TO delete_task_reference_pub;

Line: 550

         ROLLBACK TO delete_task_reference_pub;