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_MET_TPL_ASSOCS_PKG SQL Statements

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

Line: 44


PROCEDURE Insert_Row(
          p_metric_tpl_assoc_id    NUMBER,
          p_last_update_date    DATE,
          p_last_updated_by    NUMBER,
          p_creation_date    DATE,
          p_created_by    NUMBER,
          p_last_update_login    NUMBER,
          px_object_version_number   NUMBER,
          p_metric_tpl_header_id    NUMBER,
          p_association_type    VARCHAR2,
          p_used_by_id    NUMBER,
          p_used_by_code    VARCHAR2,
          p_enabled_flag    VARCHAR2)

 IS
   x_rowid    VARCHAR2(30);

Line: 65


   INSERT INTO AMS_MET_TPL_ASSOCS(
      metric_tpl_assoc_id,
      last_update_date,
      last_updated_by,
      creation_date,
      created_by,
      last_update_login,
      object_version_number,
      metric_tpl_header_id,
      association_type,
      used_by_id,
      used_by_code,
      enabled_flag
   ) VALUES (
      DECODE( p_metric_tpl_assoc_id, FND_API.g_miss_num, NULL, p_metric_tpl_assoc_id),
      DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
      DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
      DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
      DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
      DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
      1, -- DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
      DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, NULL, p_metric_tpl_header_id),
      DECODE( p_association_type, FND_API.g_miss_char, NULL, p_association_type),
      DECODE( p_used_by_id, FND_API.g_miss_num, NULL, p_used_by_id),
      DECODE( p_used_by_code, FND_API.g_miss_char, NULL, p_used_by_code),
      DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag));

Line: 91


END Insert_Row;

Line: 110


PROCEDURE Update_Row(
          p_metric_tpl_assoc_id    NUMBER,
          p_last_update_date    DATE,
          p_last_updated_by    NUMBER,
          p_last_update_login    NUMBER,
          p_object_version_number   NUMBER,
          p_metric_tpl_header_id    NUMBER,
          p_association_type    VARCHAR2,
          p_used_by_id    NUMBER,
          p_used_by_code    VARCHAR2,
          p_enabled_flag    VARCHAR2)

 IS
 BEGIN
    UPDATE AMS_MET_TPL_ASSOCS
    SET
       metric_tpl_assoc_id = DECODE( p_metric_tpl_assoc_id, FND_API.g_miss_num, metric_tpl_assoc_id, p_metric_tpl_assoc_id),
       last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
       last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
       last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
       object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
       metric_tpl_header_id = DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, metric_tpl_header_id, p_metric_tpl_header_id),
       association_type = DECODE( p_association_type, FND_API.g_miss_char, association_type, p_association_type),
       used_by_id = DECODE( p_used_by_id, FND_API.g_miss_num, used_by_id, p_used_by_id),
       used_by_code = DECODE( p_used_by_code, FND_API.g_miss_char, used_by_code, p_used_by_code),
       enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
   WHERE METRIC_TPL_ASSOC_ID = p_METRIC_TPL_ASSOC_ID;

Line: 142


END Update_Row;

Line: 161


PROCEDURE Delete_Row(
    p_METRIC_TPL_ASSOC_ID  NUMBER)
 IS
 BEGIN
   DELETE FROM AMS_MET_TPL_ASSOCS
    WHERE METRIC_TPL_ASSOC_ID = p_METRIC_TPL_ASSOC_ID;

Line: 170


 END Delete_Row ;

Line: 192


          p_last_update_date    DATE,
          p_last_updated_by    NUMBER,
          p_creation_date    DATE,
          p_created_by    NUMBER,
          p_last_update_login    NUMBER,
          p_object_version_number    NUMBER,
          p_metric_tpl_header_id    NUMBER,
          p_association_type    VARCHAR2,
          p_used_by_id    NUMBER,
          p_used_by_code    VARCHAR2,
          p_enabled_flag    VARCHAR2)

IS
   CURSOR C IS
        SELECT *
         FROM AMS_MET_TPL_ASSOCS
        WHERE METRIC_TPL_ASSOC_ID =  p_METRIC_TPL_ASSOC_ID
        FOR UPDATE OF METRIC_TPL_ASSOC_ID NOWAIT;

Line: 216


        FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line: 222


       AND (    ( Recinfo.last_update_date = p_last_update_date)
            OR (    ( Recinfo.last_update_date IS NULL )
                AND (  p_last_update_date IS NULL )))
       AND (    ( Recinfo.last_updated_by = p_last_updated_by)
            OR (    ( Recinfo.last_updated_by IS NULL )
                AND (  p_last_updated_by IS NULL )))
       AND (    ( Recinfo.creation_date = p_creation_date)
            OR (    ( Recinfo.creation_date IS NULL )
                AND (  p_creation_date IS NULL )))
       AND (    ( Recinfo.created_by = p_created_by)
            OR (    ( Recinfo.created_by IS NULL )
                AND (  p_created_by IS NULL )))
       AND (    ( Recinfo.last_update_login = p_last_update_login)
            OR (    ( Recinfo.last_update_login IS NULL )
                AND (  p_last_update_login IS NULL )))
       AND (    ( Recinfo.object_version_number = p_object_version_number)
            OR (    ( Recinfo.object_version_number IS NULL )
                AND (  p_object_version_number IS NULL )))
       AND (    ( Recinfo.metric_tpl_header_id = p_metric_tpl_header_id)
            OR (    ( Recinfo.metric_tpl_header_id IS NULL )
                AND (  p_metric_tpl_header_id IS NULL )))
       AND (    ( Recinfo.association_type = p_association_type)
            OR (    ( Recinfo.association_type IS NULL )
                AND (  p_association_type IS NULL )))
       AND (    ( Recinfo.used_by_id = p_used_by_id)
            OR (    ( Recinfo.used_by_id IS NULL )
                AND (  p_used_by_id IS NULL )))
       AND (    ( Recinfo.used_by_code = p_used_by_code)
            OR (    ( Recinfo.used_by_code IS NULL )
                AND (  p_used_by_code IS NULL )))
       AND (    ( Recinfo.enabled_flag = p_enabled_flag)
            OR (    ( Recinfo.enabled_flag IS NULL )
                AND (  p_enabled_flag IS NULL )))
       ) THEN
       RETURN;

Line: 282


  SELECT last_updated_by, object_version_number
  FROM    AMS_MET_TPL_ASSOCS
  WHERE  METRIC_TPL_ASSOC_ID =  X_METRIC_TPL_ASSOC_ID;

Line: 287


   SELECT AMS_MET_TPL_ASSOCS_S.NEXTVAL
   FROM dual;

Line: 315


  Insert_Row(
          p_metric_tpl_assoc_id    => l_metric_tpl_assoc_id,
          p_last_update_date    => sysdate,
          p_last_updated_by    => l_user_id,
          p_creation_date    => sysdate,
          p_created_by    => l_user_id,
          p_last_update_login    => 0,
          px_object_version_number   => l_obj_verno,
          p_metric_tpl_header_id    => x_metric_tpl_header_id,
          p_association_type    => x_association_type,
          p_used_by_id    => x_used_by_id,
          p_used_by_code    => x_used_by_code,
          p_enabled_flag    => x_enabled_flag);

Line: 333


   Update_Row(
          p_metric_tpl_assoc_id    => x_metric_tpl_assoc_id,
          p_last_update_date    => sysdate,
          p_last_updated_by    => l_user_id,
          p_last_update_login    => 0,
          p_object_version_number    => l_obj_verno + 1,
          p_metric_tpl_header_id    => x_metric_tpl_header_id,
          p_association_type    => x_association_type,
          p_used_by_id    => x_used_by_id,
          p_used_by_code    => x_used_by_code,
          p_enabled_flag    => x_enabled_flag);