eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TASK_CONTACTS_PUB SQL Statements

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

Line: 7


    PROCEDURE do_unmark_primary_flag_update(
        p_task_contact_id     IN      NUMBER
    ) ;

Line: 11


    PROCEDURE do_delete_cascade(
                p_task_contact_id IN NUMBER
    ) ;

Line: 21


        SELECT '1'
          FROM jtf_task_contacts
         WHERE task_id = b_task_id;

Line: 91


         SELECT 1
           FROM jtf_task_contacts
          WHERE ROWID = l_rowid;

Line: 223


      SELECT jtf_task_contacts_s.nextval
        INTO l_task_contact_id
        FROM dual;

Line: 240


      jtf_task_contacts_pkg.insert_row (
         x_rowid => l_rowid,
         x_task_contact_id => l_task_contact_id,
         x_attribute4 => p_attribute4,
         x_attribute5 => p_attribute5,
         x_attribute6 => p_attribute6,
         x_attribute7 => p_attribute7,
         x_attribute8 => p_attribute8,
         x_attribute9 => p_attribute9,
         x_attribute10 => p_attribute10,
         x_attribute11 => p_attribute11,
         x_attribute12 => p_attribute12,
         x_attribute13 => p_attribute13,
         x_attribute14 => p_attribute14,
         x_attribute15 => p_attribute15,
         x_attribute_category => p_attribute_category,
         x_contact_id => p_contact_id,
         x_attribute1 => p_attribute1,
         x_attribute2 => p_attribute2,
         x_attribute3 => p_attribute3,
         x_task_id => p_task_id,
         x_creation_date => SYSDATE,
         x_created_by => jtf_task_utl.created_by,
         x_last_update_date => SYSDATE,
         x_last_updated_by => jtf_task_utl.updated_by,
         x_last_update_login => jtf_task_utl.login_id,
         x_contact_type_code => p_contact_type_code,
         x_escalation_notify_flag => p_escalation_notify_flag,
         x_escalation_requester_flag => p_escalation_requester_flag,
         x_primary_flag => l_primary_flag -- For fixing a bug 2644132
      );

Line: 407


   PROCEDURE update_task_contacts (
      p_api_version                 IN       NUMBER,
      p_init_msg_list               IN       VARCHAR2,
      p_commit                      IN       VARCHAR2,
      p_object_version_number       IN OUT NOCOPY   NUMBER,
      p_task_contact_id             IN       NUMBER,
      p_contact_id                  IN       NUMBER,
      p_contact_type_code           IN       VARCHAR2,
      p_escalation_notify_flag      IN       VARCHAR2,
      p_escalation_requester_flag   IN       VARCHAR2,
      x_return_status               OUT NOCOPY     VARCHAR2,
      x_msg_data                    OUT NOCOPY     VARCHAR2,
      x_msg_count                   OUT NOCOPY     NUMBER,
      p_attribute1                  IN       VARCHAR2,
      p_attribute2                  IN       VARCHAR2,
      p_attribute3                  IN       VARCHAR2,
      p_attribute4                  IN       VARCHAR2,
      p_attribute5                  IN       VARCHAR2,
      p_attribute6                  IN       VARCHAR2,
      p_attribute7                  IN       VARCHAR2,
      p_attribute8                  IN       VARCHAR2,
      p_attribute9                  IN       VARCHAR2,
      p_attribute10                 IN       VARCHAR2,
      p_attribute11                 IN       VARCHAR2,
      p_attribute12                 IN       VARCHAR2,
      p_attribute13                 IN       VARCHAR2,
      p_attribute14                 IN       VARCHAR2,
      p_attribute15                 IN       VARCHAR2,
      p_attribute_category          IN       VARCHAR2,
      p_primary_flag                IN       VARCHAR2
   )
   IS
      l_api_version   CONSTANT NUMBER                                 := 1.0;

Line: 441


               := 'UPDATE_TASK_CONTACTS';

Line: 447


         SELECT task_contact_id,
                task_id,
                DECODE (
                   p_contact_id,
                   fnd_api.g_miss_num, contact_id,
                   p_contact_id
                ) contact_id,
                DECODE (
                   p_contact_type_code,
                   fnd_api.g_miss_char, contact_type_code,
                   p_contact_type_code
                ) contact_type_code,
                DECODE (
                   p_escalation_notify_flag,
                   fnd_api.g_miss_char, escalation_notify_flag,
                   p_escalation_notify_flag
                ) escalation_notify_flag,
                DECODE (
                   p_escalation_requester_flag,
                   fnd_api.g_miss_char, escalation_requester_flag,
                   p_escalation_requester_flag
                ) escalation_requester_flag,
                DECODE (
                   p_attribute1,
                   fnd_api.g_miss_char, attribute1,
                   p_attribute1
                ) attribute1,
                DECODE (
                   p_attribute2,
                   fnd_api.g_miss_char, attribute2,
                   p_attribute2
                ) attribute2,
                DECODE (
                   p_attribute3,
                   fnd_api.g_miss_char, attribute3,
                   p_attribute3
                ) attribute3,
                DECODE (
                   p_attribute4,
                   fnd_api.g_miss_char, attribute4,
                   p_attribute4
                ) attribute4,
                DECODE (
                   p_attribute5,
                   fnd_api.g_miss_char, attribute5,
                   p_attribute5
                ) attribute5,
                DECODE (
                   p_attribute6,
                   fnd_api.g_miss_char, attribute6,
                   p_attribute6
                ) attribute6,
                DECODE (
                   p_attribute7,
                   fnd_api.g_miss_char, attribute7,
                   p_attribute7
                ) attribute7,
                DECODE (
                   p_attribute8,
                   fnd_api.g_miss_char, attribute8,
                   p_attribute8
                ) attribute8,
                DECODE (
                   p_attribute9,
                   fnd_api.g_miss_char, attribute9,
                   p_attribute9
                ) attribute9,
                DECODE (
                   p_attribute10,
                   fnd_api.g_miss_char, attribute10,
                   p_attribute10
                ) attribute10,
                DECODE (
                   p_attribute11,
                   fnd_api.g_miss_char, attribute11,
                   p_attribute11
                ) attribute11,
                DECODE (
                   p_attribute12,
                   fnd_api.g_miss_char, attribute12,
                   p_attribute12
                ) attribute12,
                DECODE (
                   p_attribute13,
                   fnd_api.g_miss_char, attribute13,
                   p_attribute13
                ) attribute13,
                DECODE (
                   p_attribute14,
                   fnd_api.g_miss_char, attribute14,
                   p_attribute14
                ) attribute14,
                DECODE (
                   p_attribute15,
                   fnd_api.g_miss_char, attribute15,
                   p_attribute15
                ) attribute15,
                DECODE (
                   p_attribute_category,
                   fnd_api.g_miss_char, attribute_category,
                   p_attribute_category
                ) attribute_category,
                DECODE (
                   p_primary_flag,
                   fnd_api.g_miss_char, primary_flag,
                   p_primary_flag
                ) primary_flag
           FROM jtf_task_contacts
          WHERE task_contact_id = p_task_contact_id;

Line: 562


         SELECT contact_id,
                contact_type_code
           FROM jtf_task_contacts
          WHERE task_contact_id = b_task_contact_id;

Line: 570


      SAVEPOINT update_task_contacts_pub;

Line: 636


         SELECT task_id
           INTO l_task_id
           FROM jtf_task_contacts
          WHERE task_contact_id = p_task_contact_id;

Line: 732


           do_unmark_primary_flag_update( P_task_contact_id );

Line: 751


      jtf_task_contacts_pkg.update_row (
         x_task_contact_id => p_task_contact_id,
         x_object_version_number => p_object_version_number + 1,
         x_attribute1 => task_contacts.attribute1,
         x_attribute2 => task_contacts.attribute2,
         x_attribute3 => task_contacts.attribute3,
         x_attribute4 => task_contacts.attribute4,
         x_attribute5 => task_contacts.attribute5,
         x_attribute6 => task_contacts.attribute6,
         x_attribute7 => task_contacts.attribute7,
         x_attribute8 => task_contacts.attribute8,
         x_attribute9 => task_contacts.attribute9,
         x_attribute10 => task_contacts.attribute10,
         x_attribute11 => task_contacts.attribute11,
         x_attribute12 => task_contacts.attribute12,
         x_attribute13 => task_contacts.attribute13,
         x_attribute14 => task_contacts.attribute14,
         x_attribute15 => task_contacts.attribute15,
         x_attribute_category => task_contacts.attribute_category,
         x_task_id => task_contacts.task_id,
         x_contact_id => task_contacts.contact_id,
         x_last_update_date => SYSDATE,
         x_last_updated_by => jtf_task_utl.updated_by,
         x_last_update_login => jtf_task_utl.login_id,
         x_contact_type_code => task_contacts.contact_type_code,
         x_escalation_notify_flag => task_contacts.escalation_notify_flag,
         x_escalation_requester_flag => task_contacts.escalation_requester_flag,
         x_primary_flag => task_contacts.primary_flag
      );

Line: 788


         jtf_task_utl.delete_party_reference(
            p_reference_from    => 'CONTACT',
            p_task_id       => l_task_id,
            p_party_type_code   => l_orig_type_code,
            p_party_id      => l_orig_con_id,
            x_msg_count     => x_msg_count,
            x_msg_data      => x_msg_data,
            x_return_status     => x_return_status);

Line: 834


         ROLLBACK TO update_task_contacts_pub;

Line: 842


         ROLLBACK TO update_task_contacts_pub;

Line: 852


   PROCEDURE delete_task_contacts (
      p_api_version             IN       NUMBER,
      p_init_msg_list           IN       VARCHAR2,
      p_commit                  IN       VARCHAR2,
      p_object_version_number   IN       NUMBER,
      p_task_contact_id         IN       NUMBER,
      x_return_status           OUT NOCOPY     VARCHAR2,
      x_msg_data                OUT NOCOPY     VARCHAR2,
      x_msg_count               OUT NOCOPY     NUMBER,
      p_delete_cascade          IN       VARCHAR2
   )
   IS
      l_api_version   CONSTANT NUMBER                   := 1.0;

Line: 866


               := 'DELETE_TASK_CONTACTS';

Line: 872


         SELECT contact_id,
                contact_type_code
           FROM jtf_task_contacts
          WHERE task_contact_id = b_task_contact_id;

Line: 878


      SAVEPOINT delete_task_contacts_pvt;

Line: 910


         SELECT task_id
           INTO l_task_id
           FROM jtf_task_contacts
          WHERE task_contact_id = p_task_contact_id;

Line: 942


      IF p_delete_cascade = jtf_task_utl.g_yes THEN
         do_delete_cascade (
            p_task_contact_id => p_task_contact_id
         ) ;

Line: 961


      jtf_task_contacts_pkg.delete_row (
         x_task_contact_id => p_task_contact_id
      );

Line: 968


            jtf_task_utl.delete_party_reference(
               p_reference_from     => 'CONTACT',
               p_task_id        => l_task_id,
               p_party_type_code    => l_contact_type_code,
               p_party_id       => l_contact_id,
               x_msg_count      => x_msg_count,
               x_msg_data       => x_msg_data,
               x_return_status      => x_return_status);

Line: 997


         ROLLBACK TO delete_task_contacts_pvt;

Line: 1005


         ROLLBACK TO delete_task_contacts_pvt;

Line: 1023


      UPDATE jtf_task_contacts
         SET primary_flag = 'N'
       WHERE task_id = p_task_id
         AND primary_flag = 'Y';

Line: 1030


   PROCEDURE do_unmark_primary_flag_update(
                p_task_contact_id  IN      NUMBER

   ) IS

   BEGIN
   -- unmark previous primary flag
      UPDATE jtf_task_contacts
         SET primary_flag = 'N'
       WHERE task_id = (SELECT task_id FROM jtf_task_contacts
                              WHERE  task_contact_id = p_task_contact_id)
         AND primary_flag = 'Y';

Line: 1045


   PROCEDURE do_delete_cascade(
                p_task_contact_id IN NUMBER
   ) IS

      l_task_phone_id jtf_task_phones.task_phone_id%TYPE;

Line: 1053


         SELECT task_phone_id
         FROM jtf_task_phones
         WHERE task_contact_id = p_task_contact_id
         AND owner_table_name = 'JTF_TASK_CONTACTS';

Line: 1064


         DELETE FROM jtf_task_phones
         WHERE task_phone_id = l_task_phone_id;