APPS.AMS_ASSOCIATIONS_PVT SQL Statements

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

Line: 62

   SELECT resource_id
   FROM ams_jtf_rs_emp_v
   WHERE user_id = l_user_id;

Line: 67

   SELECT ams_object_associations_s.NEXTVAL
     FROM DUAL;

Line: 71

   SELECT COUNT(*)
     FROM ams_object_associations
    WHERE object_association_id = association_id;

Line: 76

    SELECT language_code
     FROM  AMS_CAMPAIGN_SCHEDULES_B
    WHERE  schedule_id = l_camp_sch_id;

Line: 81

    SELECT actual_avail_from_date,actual_avail_to_date,language_code
    FROM ams_deliverables_all_b
    WHERE deliverable_id = l_delv_id;

Line: 149

      if AMS_ACCESS_PVT.check_update_access(l_association_rec.MASTER_OBJECT_ID, l_association_rec.MASTER_OBJECT_TYPE, l_res_id, 'USER') = 'N'  then
         IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
            FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS'); --resuing message

Line: 217

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

Line: 234

   INSERT INTO ams_object_associations(
    OBJECT_ASSOCIATION_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER,
    MASTER_OBJECT_TYPE,
    MASTER_OBJECT_ID,
    USING_OBJECT_TYPE,
    USING_OBJECT_ID,
    PRIMARY_FLAG,
    USAGE_TYPE,
    QUANTITY_NEEDED,
    QUANTITY_NEEDED_BY_DATE,
    COST_FROZEN_FLAG,
    PCT_OF_COST_TO_CHARGE_USED_BY,
    MAX_COST_TO_CHARGE_USED_BY,
    MAX_COST_CURRENCY_CODE,
    METRIC_CLASS,
   FULFILL_ON_TYPE_CODE,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    CONTENT_TYPE,
    SEQUENCE_NO
   ) VALUES(
    l_association_rec.OBJECT_ASSOCIATION_ID,
    sysdate,
    FND_GLOBAL.user_id,
    SYSDATE,
    FND_GLOBAL.user_id,
    FND_GLOBAL.conc_login_id,
    1,  -- object_version_number
    l_association_rec.MASTER_OBJECT_TYPE,
    l_association_rec.MASTER_OBJECT_ID,
    l_association_rec.USING_OBJECT_TYPE,
    l_association_rec.USING_OBJECT_ID,
    nvl(l_association_rec.PRIMARY_FLAG,'N'),
    l_association_rec.USAGE_TYPE,
    l_association_rec.QUANTITY_NEEDED,
    l_association_rec.QUANTITY_NEEDED_BY_DATE,
    nvl(l_association_rec.COST_FROZEN_FLAG,'N'),
    l_association_rec.PCT_OF_COST_TO_CHARGE_USED_BY,
    l_association_rec.MAX_COST_TO_CHARGE_USED_BY,
    l_association_rec.MAX_COST_CURRENCY_CODE,
    l_association_rec.METRIC_CLASS,
   l_association_rec.FULFILL_ON_TYPE_CODE,
    l_association_rec.ATTRIBUTE_CATEGORY,
    l_association_rec.ATTRIBUTE1,
    l_association_rec.ATTRIBUTE2,
    l_association_rec.ATTRIBUTE3,
    l_association_rec.ATTRIBUTE4,
    l_association_rec.ATTRIBUTE5,
    l_association_rec.ATTRIBUTE6,
    l_association_rec.ATTRIBUTE7,
    l_association_rec.ATTRIBUTE8,
    l_association_rec.ATTRIBUTE9,
    l_association_rec.ATTRIBUTE10,
    l_association_rec.ATTRIBUTE11,
    l_association_rec.ATTRIBUTE12,
    l_association_rec.ATTRIBUTE13,
    l_association_rec.ATTRIBUTE14,
    l_association_rec.ATTRIBUTE15,
    l_association_rec.content_type,
    l_association_rec.sequence_no
);

Line: 424

PROCEDURE delete_association(
   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,

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

   p_object_association_id         IN  NUMBER,
   p_object_version    IN  NUMBER
)
IS

   l_api_version CONSTANT NUMBER       := 1.0;

Line: 440

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

Line: 454

   select distinct a.using_object_type, a.master_object_type, a.master_object_id
     from ams_object_associations a, ams_object_associations b
   where  a.master_object_type = b.master_object_type
   and a.master_object_id = b.master_object_id
   and a.using_object_type = b.using_object_type
   and b.object_association_id = l_obj_id;

Line: 462

   select 'dummy'
     from ams_object_associations
   where  master_object_type = c_obj_type
   and master_object_id = c_obj_id
   and using_object_type = c_attr;

Line: 469

   SELECT resource_id
   FROM ams_jtf_rs_emp_v
   WHERE user_id = l_user_id;

Line: 474

   SELECT master_object_type, master_object_id
   FROM ams_object_associations
   WHERE object_association_id = l_obj_id;

Line: 481

   SAVEPOINT delete_association;

Line: 519

      if AMS_ACCESS_PVT.check_update_access(l_master_id, l_master, l_res_id, 'USER') = 'N'  then
         IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
            FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS'); --reusing message

Line: 531

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

Line: 538

   DELETE FROM ams_object_associations
   WHERE object_association_id = p_object_association_id
   AND object_version_number = p_object_version;

Line: 624

      ROLLBACK TO delete_association;

Line: 633

      ROLLBACK TO delete_association;

Line: 642

      ROLLBACK TO delete_association;

Line: 656

END delete_association;

Line: 686

   SELECT object_association_id
     FROM ams_object_associations
    WHERE object_association_id = p_object_association_id
      AND object_version_number = p_object_version
   FOR UPDATE OF object_association_id NOWAIT;

Line: 802

PROCEDURE update_association(
   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,

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

   p_association_rec   IN  association_rec_type
)
IS

   l_api_version CONSTANT NUMBER := 1.0;

Line: 817

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

Line: 827

   SELECT resource_id
   FROM ams_jtf_rs_emp_v
   WHERE user_id = l_user_id;

Line: 833

   SAVEPOINT update_association;

Line: 870

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

Line: 903

      if AMS_ACCESS_PVT.check_update_access(l_association_rec.MASTER_OBJECT_ID, l_association_rec.MASTER_OBJECT_TYPE, l_res_id, 'USER') = 'N'  then
         IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
            FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS');

Line: 914

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

Line: 917

   UPDATE ams_object_associations SET
    last_update_date = SYSDATE,
    last_updated_by = FND_GLOBAL.user_id,
    last_update_login = FND_GLOBAL.conc_login_id,
    object_version_number = l_association_rec.object_version_number + 1,
    MASTER_OBJECT_TYPE = l_association_rec.MASTER_OBJECT_TYPE,
    MASTER_OBJECT_ID = l_association_rec.MASTER_OBJECT_ID,
    USING_OBJECT_TYPE = l_association_rec.USING_OBJECT_TYPE,
    USING_OBJECT_ID = l_association_rec.USING_OBJECT_ID,
    PRIMARY_FLAG = l_association_rec.PRIMARY_FLAG,
    USAGE_TYPE = l_association_rec.USAGE_TYPE,
    QUANTITY_NEEDED = l_association_rec.QUANTITY_NEEDED,
    QUANTITY_NEEDED_BY_DATE = l_association_rec.QUANTITY_NEEDED_BY_DATE,
    COST_FROZEN_FLAG = l_association_rec.COST_FROZEN_FLAG,
    PCT_OF_COST_TO_CHARGE_USED_BY = l_association_rec.PCT_OF_COST_TO_CHARGE_USED_BY,
    MAX_COST_TO_CHARGE_USED_BY = l_association_rec.MAX_COST_TO_CHARGE_USED_BY,
    MAX_COST_CURRENCY_CODE = l_association_rec.MAX_COST_CURRENCY_CODE,
    METRIC_CLASS = l_association_rec.METRIC_CLASS,
   FULFILL_ON_TYPE_CODE = l_association_rec.FULFILL_ON_TYPE_CODE,
    ATTRIBUTE_CATEGORY = l_association_rec.ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = l_association_rec.ATTRIBUTE1,
    ATTRIBUTE2 = l_association_rec.ATTRIBUTE2,
    ATTRIBUTE3 = l_association_rec.ATTRIBUTE3,
    ATTRIBUTE4 = l_association_rec.ATTRIBUTE4,
    ATTRIBUTE5 = l_association_rec.ATTRIBUTE5,
    ATTRIBUTE6 = l_association_rec.ATTRIBUTE6,
    ATTRIBUTE7 = l_association_rec.ATTRIBUTE7,
    ATTRIBUTE8 = l_association_rec.ATTRIBUTE8,
    ATTRIBUTE9 = l_association_rec.ATTRIBUTE9,
    ATTRIBUTE10 = l_association_rec.ATTRIBUTE10,
    ATTRIBUTE11 = l_association_rec.ATTRIBUTE11,
    ATTRIBUTE12 = l_association_rec.ATTRIBUTE12,
    ATTRIBUTE13 = l_association_rec.ATTRIBUTE13,
    ATTRIBUTE14 = l_association_rec.ATTRIBUTE14,
    ATTRIBUTE15 = l_association_rec.ATTRIBUTE15,
    content_type = l_association_rec.content_type,
    sequence_no = l_association_rec.sequence_no
   WHERE object_association_id = l_association_rec.object_association_id
   AND object_version_number = l_association_rec.object_version_number;

Line: 987

      ROLLBACK TO update_association;

Line: 996

      ROLLBACK TO update_association;

Line: 1005

      ROLLBACK TO update_association;

Line: 1019

END update_association;

Line: 1350

   SELECT  DISTINCT 'Y'
   FROM ams_object_associations
   WHERE master_object_type = p_masterobjType
   AND  master_object_id = p_masterobjId
   AND using_object_type = p_using_objType
   AND using_object_id = p_using_id;

Line: 1625

SELECT active_to_date
FROM ams_event_headers_all_b
WHERE event_header_id = l_event_id;

Line: 1631

SELECT event_end_date
FROM ams_event_offers_all_b
WHERE event_offer_id = l_event_offer_id;

Line: 1637

SELECT actual_exec_end_date
FROM ams_campaigns_all_b
WHERE campaign_id = l_camp_id;

Line: 1643

SELECT end_date_time
FROM ams_campaign_schedules_b
WHERE  schedule_id = l_camp_sche_id;

Line: 1798

   SELECT *
     FROM ams_object_associations
    WHERE object_association_id = p_association_rec.object_association_id;

Line: 1894

   x_association_rec.last_update_date := FND_API.g_miss_date;

Line: 1895

   x_association_rec.last_updated_by := FND_API.g_miss_num;

Line: 1898

   x_association_rec.last_update_login := FND_API.g_miss_num;