APPS.AMS_SETUP_ATTR_PVT SQL Statements

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

Line: 40

    SELECT AMS_CUSTOM_SETUP_ATTR_S.NEXTVAL
    FROM DUAL;

Line: 44

    SELECT COUNT(*)
    FROM AMS_CUSTOM_SETUP_ATTR
    WHERE setup_attribute_id = setup_attr_id;

Line: 106

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

Line: 123

  INSERT INTO AMS_CUSTOM_SETUP_ATTR
  (
    setup_attribute_id,
    custom_setup_id,
    last_update_date,
    last_updated_by,
    creation_date,
    created_by,
    object_version_number,
    last_update_login,
    display_sequence_no,
    object_attribute,
    attr_mandatory_flag,
    attr_available_flag,
    function_name,
    parent_function_name,
    parent_setup_attribute,
    parent_display_sequence,
    show_in_report,
    show_in_cue_card,
    copy_allowed_flag,
    related_ak_attribute,
    essential_seq_num
  )
  VALUES
  (
    l_setup_attr_rec.setup_attribute_id,
    l_setup_attr_rec.custom_setup_id,
    SYSDATE,
    FND_GLOBAL.user_id,
    SYSDATE,
    FND_GLOBAL.user_id,
    1,
    FND_GLOBAL.conc_login_id,
    l_setup_attr_rec.display_sequence_no,
    l_setup_attr_rec.object_attribute,
    l_setup_attr_rec.attr_mandatory_flag,
    NVL(l_setup_attr_rec.attr_available_flag,'Y'),
    l_setup_attr_rec.function_name,
    l_setup_attr_rec.parent_function_name,
    l_setup_attr_rec.parent_setup_attribute,
    l_setup_attr_rec.parent_display_sequence,
    nvl(l_setup_attr_rec.show_in_report,'Y'),
    nvl(l_setup_attr_rec.show_in_cue_card,'Y'),
    nvl(l_setup_attr_rec.copy_allowed_flag,'N'),
    l_setup_attr_rec.related_ak_attribute,
    l_setup_attr_rec.essential_seq_num
  );

Line: 238

PROCEDURE update_setup_attr
(
  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_setup_attr_rec      IN      setup_attr_rec_type
)
IS

  l_api_version       CONSTANT NUMBER := 1.0;

Line: 254

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

Line: 262

  SAVEPOINT update_setup_attr;

Line: 301

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

Line: 316

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

Line: 319

  UPDATE AMS_CUSTOM_SETUP_ATTR SET
    custom_setup_id  = l_setup_attr_rec.custom_setup_id,
    last_update_date = SYSDATE,
    last_updated_by  = FND_GLOBAL.user_id,
    object_version_number   = l_setup_attr_rec.object_version_number + 1,
    last_update_login       = FND_GLOBAL.conc_login_id,
    display_sequence_no     = l_setup_attr_rec.display_sequence_no,
    object_attribute        = l_setup_attr_rec.object_attribute,
    attr_mandatory_flag     = l_setup_attr_rec.attr_mandatory_flag,
    attr_available_flag     = l_setup_attr_rec.attr_available_flag,
    function_name           = l_setup_attr_rec.function_name,
    parent_function_name    = l_setup_attr_rec.parent_function_name,
    parent_setup_attribute  = l_setup_attr_rec.parent_setup_attribute,
    parent_display_sequence = l_setup_attr_rec.parent_display_sequence,
    show_in_report          = nvl(l_setup_attr_rec.show_in_report,'Y'),
    related_ak_attribute    = l_setup_attr_rec.related_ak_attribute,
    essential_seq_num       = l_setup_attr_rec.essential_seq_num
  WHERE setup_attribute_id = l_setup_attr_rec.setup_attribute_id
  AND object_version_number = l_setup_attr_rec.object_version_number;

Line: 370

      ROLLBACK TO update_setup_attr;

Line: 380

      ROLLBACK TO update_setup_attr;

Line: 390

      ROLLBACK TO update_setup_attr;

Line: 402

END update_setup_attr;

Line: 620

  AND p_validation_mode = JTF_PLSQL_API.g_update THEN
    IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
      FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_SETUP_ATT_ID');

Line: 632

    AND p_validation_mode = JTF_PLSQL_API.g_update
  THEN
    IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
      FND_MESSAGE.set_name('AMS', 'AMS_API_NO_OBJ_VER_NUM');

Line: 732

      SELECT 1 FROM dual
      WHERE EXISTS (SELECT 1 FROM   ams_custom_setup_attr
            WHERE  custom_setup_id = id_in
            AND essential_seq_num = seq_num_in
	    AND setup_attribute_id <> setup_id_in
            );

Line: 868

    SELECT mandatory_flag FROM AMS_SETUP_TYPES
    WHERE setup_attribute = obj_attr
    -- Following lines are added by ptendulk on 29th Dec
    AND object_type = l_obj_type
    AND activity_type_code = l_act_type ;

Line: 875

    SELECT mandatory_flag FROM AMS_SETUP_TYPES
    WHERE setup_attribute = obj_attr
    -- Following lines are added by ptendulk on 29th Dec
    AND object_type = l_obj_type
    AND activity_type_code IS NULL ;

Line: 883

    SELECT object_type,activity_type_code
    FROM   ams_custom_setups_vl
    WHERE  custom_setup_id = p_setup_attr_rec.custom_setup_id ;

Line: 889

    SELECT MEANING FROM AMS_LOOKUPS WHERE LOOKUP_TYPE = 'AMS_SYS_ARC_QUALIFIER' AND LOOKUP_CODE = obj_attr;

Line: 1061

    SELECT * FROM AMS_CUSTOM_SETUP_ATTR
    WHERE setup_attribute_id = p_setup_attr_rec.setup_attribute_id;

Line: 1149

  x_setup_attr_rec.last_update_date        := FND_API.g_miss_date;

Line: 1150

  x_setup_attr_rec.last_updated_by         := FND_API.g_miss_num;

Line: 1153

  x_setup_attr_rec.last_update_login       := FND_API.g_miss_num;