APPS.JTF_EC_CONTACTS_PVT SQL Statements

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

Line: 134

   PROCEDURE update_escalation_contacts (
      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  VARCHAR2,
      p_escalation_contact_id       IN       NUMBER DEFAULT NULL,
      p_contact_id                  IN       NUMBER,
      p_contact_type_code           IN       VARCHAR2 DEFAULT NULL,
      p_escalation_notify_flag      IN       VARCHAR2 DEFAULT NULL,
      p_escalation_requester_flag   IN       VARCHAR2 DEFAULT NULL,
      x_return_status               OUT NOCOPY     VARCHAR2,
      x_msg_data                    OUT NOCOPY     VARCHAR2,
      x_msg_count                   OUT NOCOPY     NUMBER,
      p_attribute1              	IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute2              	IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute3              	IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute4              	IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute5              	IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute6              	IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute7              	IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute8              	IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute9              	IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute10             	IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute11             	IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute12             	IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute13             	IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute14             	IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute15             	IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute_category      	IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
   )
   IS
      l_api_version    CONSTANT NUMBER       := 1.0;

Line: 166

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

Line: 169

      SAVEPOINT update_escalation_contacts_pub;

Line: 189

      jtf_task_contacts_pub.update_task_contacts (
         p_api_version => p_api_version,
         p_init_msg_list => p_init_msg_list,
         p_commit => p_commit,
         p_task_contact_id => p_escalation_contact_id,
         p_object_version_number => l_object_version_number,
         p_contact_id => p_contact_id,
         p_contact_type_code => p_contact_type_code,
         p_escalation_notify_flag => p_escalation_notify_flag,
         p_escalation_requester_flag => p_escalation_requester_flag,
         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: 231

         ROLLBACK TO update_escalation_contacts_pub;

Line: 236

         ROLLBACK TO update_escalation_contacts_pub;

Line: 243

   PROCEDURE delete_escalation_contacts (
      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_contact_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: 255

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

Line: 257

      SAVEPOINT delete_escalation_contacts_pub;

Line: 277

      jtf_task_contacts_pub.delete_task_contacts (
         p_api_version => p_api_version,
         p_init_msg_list => p_init_msg_list,
         p_commit => p_commit,
         p_object_version_number => p_object_version_number,
         p_task_contact_id => p_escalation_contact_id,
         x_return_status => x_return_status,
         x_msg_data => x_msg_data,
         x_msg_count => x_msg_count
      );

Line: 303

         ROLLBACK TO delete_task_contacts_pvt;

Line: 308

         ROLLBACK TO delete_task_contacts_pvt;