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.AMS_ACTPARTNER_PVT SQL Statements

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

Line: 62


   SELECT ams_act_partners_s.NEXTVAL
     FROM DUAL;

Line: 66


   SELECT COUNT(*)
     FROM ams_act_partners
    WHERE activity_partner_id = act_partner_id;

Line: 118


   AMS_Utility_PVT.debug_message(l_full_name ||': insert');

Line: 142


   INSERT INTO ams_act_partners(

        activity_partner_id,
        last_update_date,
        last_updated_by,
        creation_date,
        created_by,
        last_update_login,
        object_version_number,
        act_partner_used_by_id,
        arc_act_partner_used_by,
        primary_flag,
        partner_id,
        partner_type,
        description,
        attribute_category,
        preferred_vad_id,
        partner_address_id,
	primary_contact_id,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15
      ) VALUES (
        l_act_partner_rec.activity_partner_id,
        SYSDATE,
        FND_GLOBAL.user_id,
        SYSDATE,
        FND_GLOBAL.user_id,
        FND_GLOBAL.conc_login_id,
        1,
        l_act_partner_rec.act_partner_used_by_id,
        l_act_partner_rec.arc_act_partner_used_by,
        l_act_partner_rec.primary_flag,
        l_act_partner_rec.partner_id,
        l_act_partner_rec.partner_type,
        l_act_partner_rec.description,
        l_act_partner_rec.attribute_category,
        l_act_partner_rec.preferred_vad_id,
        l_act_partner_rec.partner_address_id,
	l_act_partner_rec.primary_contact_id,
        l_act_partner_rec.attribute1,
        l_act_partner_rec.attribute2,
        l_act_partner_rec.attribute3,
        l_act_partner_rec.attribute4,
        l_act_partner_rec.attribute5,
        l_act_partner_rec.attribute6,
        l_act_partner_rec.attribute7,
        l_act_partner_rec.attribute8,
        l_act_partner_rec.attribute9,
        l_act_partner_rec.attribute10,
        l_act_partner_rec.attribute11,
        l_act_partner_rec.attribute12,
        l_act_partner_rec.attribute13,
        l_act_partner_rec.attribute14,
        l_act_partner_rec.attribute15
   );

Line: 292


PROCEDURE update_act_partner
(
  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_object_version_number IN NUMBER,

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

  p_act_partner_rec     IN  act_partner_rec_type
)
IS

   l_api_version        CONSTANT NUMBER := 1.0;

Line: 309


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

Line: 320


   SAVEPOINT update_act_partner;

Line: 356


         p_validation_mode => JTF_PLSQL_API.g_update,
         x_return_status   => l_return_status
      );

Line: 394


   UPDATE ams_act_partners SET
      last_update_date = SYSDATE,
      last_updated_by = FND_GLOBAL.user_id,
      last_update_login = FND_GLOBAL.conc_login_id,
      primary_flag =  l_act_partner_rec.primary_flag,
      object_version_number = l_act_partner_rec.object_version_number + 1,
      act_partner_used_by_id = l_act_partner_rec.act_partner_used_by_id,
      arc_act_partner_used_by = l_act_partner_rec.arc_act_partner_used_by,
      partner_id = l_act_partner_rec.partner_id,
      partner_type = l_act_partner_rec.partner_type,
      description = l_act_partner_rec.description,
      attribute_category = l_act_partner_rec.attribute_category,
      preferred_vad_id = l_act_partner_rec.preferred_vad_id,
      partner_address_id =  l_act_partner_rec.partner_address_id,
      primary_contact_id =  l_act_partner_rec.primary_contact_id,
      attribute1 = l_act_partner_rec.attribute1,
      attribute2 = l_act_partner_rec.attribute2,
      attribute3 = l_act_partner_rec.attribute3,
      attribute4 = l_act_partner_rec.attribute4,
      attribute5 = l_act_partner_rec.attribute5,
      attribute6 = l_act_partner_rec.attribute6,
      attribute7 = l_act_partner_rec.attribute7,
      attribute8 = l_act_partner_rec.attribute8,
      attribute9 = l_act_partner_rec.attribute9,
      attribute10 = l_act_partner_rec.attribute10,
      attribute11 = l_act_partner_rec.attribute11,
      attribute12 = l_act_partner_rec.attribute12,
      attribute13 = l_act_partner_rec.attribute13,
      attribute14 = l_act_partner_rec.attribute14,
      attribute15 = l_act_partner_rec.attribute15
    WHERE activity_partner_id = l_act_partner_rec.activity_partner_id
    AND object_version_number = l_act_partner_rec.object_version_number;

Line: 463


      ROLLBACK TO update_act_partner;

Line: 474


      ROLLBACK TO update_act_partner;

Line: 485


      ROLLBACK TO update_act_partner;

Line: 500


END update_act_partner;

Line: 514


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

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

  p_act_partner_id  IN  NUMBER,
  p_object_version  IN  NUMBER
)
IS
   l_partner_attr_code  CONSTANT VARCHAR2(30) := 'PTNR';

Line: 530


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

Line: 551


      SELECT arc_act_partner_used_by, act_partner_used_by_id
      FROM   ams_act_partners
      WHERE  activity_partner_id = p_act_partner_id;

Line: 556


      SELECT 1
      FROM  ams_act_partners
      WHERE arc_act_partner_used_by = p_object_type
      AND   act_partner_used_by_id = p_object_id;

Line: 564


   SAVEPOINT delete_act_partner;

Line: 604


   DELETE FROM ams_act_partners
   WHERE activity_partner_id = p_act_partner_id
   AND object_version_number = p_object_version;

Line: 640


      ROLLBACK TO delete_act_partner;

Line: 649


      ROLLBACK TO delete_act_partner;

Line: 658


      ROLLBACK TO delete_deliverable;

Line: 673


END delete_act_partner;

Line: 704


   SELECT activity_partner_id
     FROM ams_act_partners
    WHERE activity_partner_id = p_act_partner_id
      AND object_version_number = p_object_version
   FOR UPDATE OF activity_partner_id NOWAIT;

Line: 1089


   x_act_partner_rec.last_update_date := FND_API.g_miss_date;

Line: 1090


   x_act_partner_rec.last_updated_by := FND_API.g_miss_num;

Line: 1093


   x_act_partner_rec.last_update_login := FND_API.g_miss_num;

Line: 1138


   SELECT *
     FROM ams_act_partners
    WHERE activity_partner_id = p_act_partner_rec.activity_partner_id;

Line: 1286


   SELECT count(*)
    FROM ams_act_partners
    WHERE primary_flag = 'Y'
    AND    act_partner_used_by_id = l_id
    AND    arc_act_partner_used_by = l_used_by;

Line: 1334


      SELECT partner_party_name
      FROM   pv_partners_v
      WHERE  partner_id = p_partner_id; -- instead of partner_party_id; anchaudh changed it to partner_id on 30 Apr-05.