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

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

Line: 50


      SELECT AMS_PROD_TEMPLATE_ATTR_s.NEXTVAL
      FROM dual;

Line: 54


      SELECT 1
      FROM AMS_PROD_TEMPLATE_ATTR
      WHERE TEMPLATE_ATTRIBUTE_ID = l_id;

Line: 137


      INSERT INTO AMS_PROD_TEMPLATE_ATTR(
           template_attribute_id,
           template_id,
           last_update_date,
           last_updated_by,
           creation_date,
           created_by,
           object_version_number,
           last_update_login,
           parent_attribute_code,
           parent_select_all,
           attribute_code,
           default_flag,
           editable_flag,
           hide_flag
      ) VALUES (
           DECODE( l_template_attribute_id, FND_API.g_miss_num, NULL, l_template_attribute_id),
           DECODE( p_template_attr_rec.template_id, FND_API.g_miss_num, NULL, p_template_attr_rec.template_id),
           sysdate,
           fnd_global.user_id,
           SYSDATE,
           fnd_global.user_id,
           l_object_version_number,
           FND_GLOBAL.CONC_LOGIN_ID,
           DECODE( p_template_attr_rec.parent_attribute_code, FND_API.g_miss_char, NULL, p_template_attr_rec.parent_attribute_code),
           DECODE( p_template_attr_rec.parent_select_all, FND_API.g_miss_char, NULL, p_template_attr_rec.parent_select_all),
           DECODE( p_template_attr_rec.attribute_code, FND_API.g_miss_char, NULL, p_template_attr_rec.attribute_code),
           DECODE( p_template_attr_rec.default_flag, FND_API.g_miss_char, NULL, p_template_attr_rec.default_flag),
           DECODE( p_template_attr_rec.editable_flag, FND_API.g_miss_char, NULL, p_template_attr_rec.editable_flag),
           DECODE( p_template_attr_rec.hide_flag, FND_API.g_miss_char, NULL, p_template_attr_rec.hide_flag));

Line: 236


PROCEDURE Update_Template_Attr(
    p_api_version_number         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_template_attr_rec          IN    template_attr_rec_type
    )

 IS

CURSOR c_get_template_attr(p_template_attribute_id NUMBER) IS
    SELECT *
    FROM  AMS_PROD_TEMPLATE_ATTR
    WHERE template_attribute_id = p_template_attribute_id;

Line: 257


L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_Template_Attr';

Line: 270


      SAVEPOINT UPDATE_Template_Attr_PVT;

Line: 300


      AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

Line: 309


  AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
   p_token_name   => 'INFO',
 p_token_value  => 'Template_Attr') ;

Line: 327


 p_token_value  => 'Last_Update_Date') ;

Line: 350


            p_validation_mode => JTF_PLSQL_API.g_update,
            p_template_attr_rec  =>  l_template_attr_rec,
            x_return_status    => x_return_status,
            x_msg_count        => x_msg_count,
            x_msg_data         => x_msg_data);

Line: 362


      AMS_UTILITY_PVT.debug_message(' IN UPDATE API VALUE FOR DeFAULT FLAG IS :'||l_template_attr_rec.default_flag);

Line: 365


      /*  If select all flag is "Y" then defaulting the default,editable flag to "Y" */
      --IF l_template_attr_rec.parent_select_all ='Y'
      --THEN
      -- l_template_attr_rec.editable_flag := 'Y';

Line: 373


   Update AMS_PROD_TEMPLATE_ATTR
   SET template_attribute_id = DECODE( l_template_attr_rec.template_attribute_id, FND_API.g_miss_num, template_attribute_id, l_template_attr_rec.template_attribute_id),
          template_id = DECODE( l_template_attr_rec.template_id, FND_API.g_miss_num, template_id, l_template_attr_rec.template_id),
          last_update_date = sysdate,
          last_updated_by = fnd_global.user_id,
          object_version_number = l_template_attr_rec.object_version_number + 1,
          last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
          parent_attribute_code = DECODE( l_template_attr_rec.parent_attribute_code, FND_API.g_miss_char, parent_attribute_code, l_template_attr_rec.parent_attribute_code),
          --parent_select_all = DECODE( l_template_attr_rec.parent_select_all, FND_API.g_miss_char, 'N', l_template_attr_rec.parent_select_all),
          attribute_code = DECODE( l_template_attr_rec.attribute_code, FND_API.g_miss_char, attribute_code, l_template_attr_rec.attribute_code),
          default_flag = DECODE( l_template_attr_rec.default_flag, FND_API.g_miss_char,'N', l_template_attr_rec.default_flag),
          editable_flag = DECODE( l_template_attr_rec.editable_flag, FND_API.g_miss_char, 'N', l_template_attr_rec.editable_flag),
          hide_flag = DECODE( l_template_attr_rec.hide_flag, FND_API.g_miss_char, 'N', l_template_attr_rec.hide_flag)
   WHERE TEMPLATE_ATTRIBUTE_ID = l_template_attr_rec.TEMPLATE_ATTRIBUTE_ID
   AND   object_version_number = l_template_attr_rec.object_version_number;

Line: 397


      AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.parent_select_all:' ||l_template_attr_rec.parent_select_all);

Line: 414


      IF l_template_attr_rec.parent_select_all = FND_API.G_MISS_CHAR
      THEN
         l_template_attr_rec.parent_select_all := 'N';

Line: 423


      UPDATE ams_prod_template_attr
      SET parent_select_all = l_template_attr_rec.parent_select_all
         , last_update_date = sysdate
         , last_updated_by = fnd_global.user_id
         , last_update_login = FND_GLOBAL.CONC_LOGIN_ID
         --, object_version_number = object_version_number + 1
      WHERE template_id = l_template_attr_rec.template_id
      AND parent_attribute_code = l_template_attr_rec.parent_attribute_code;

Line: 436


      AMS_UTILITY_PVT.debug_message('AFTER UPDATe for l_template_attr_rec.parent_select_all :'||l_template_attr_rec.parent_select_all );

Line: 472


     ROLLBACK TO UPDATE_Template_Attr_PVT;

Line: 482


     ROLLBACK TO UPDATE_Template_Attr_PVT;

Line: 492


     ROLLBACK TO UPDATE_Template_Attr_PVT;

Line: 504


End Update_Template_Attr;

Line: 507


PROCEDURE Delete_Template_Attr(
    p_api_version_number         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_template_attribute_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

 IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Template_Attr';

Line: 526


      SAVEPOINT DELETE_Template_Attr_PVT;

Line: 554


      DELETE FROM AMS_PROD_TEMPLATE_ATTR
      WHERE TEMPLATE_ATTRIBUTE_ID = p_TEMPLATE_ATTRIBUTE_ID;

Line: 586


     ROLLBACK TO DELETE_Template_Attr_PVT;

Line: 596


     ROLLBACK TO DELETE_Template_Attr_PVT;

Line: 606


     ROLLBACK TO DELETE_Template_Attr_PVT;

Line: 618


End Delete_Template_Attr;

Line: 642


   SELECT TEMPLATE_ATTRIBUTE_ID
   FROM AMS_PROD_TEMPLATE_ATTR
   WHERE TEMPLATE_ATTRIBUTE_ID = p_TEMPLATE_ATTRIBUTE_ID
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 814


      IF (p_template_attr_rec.parent_select_all = 'Y'
      AND(( p_template_attr_rec.editable_flag = 'N')
       OR (p_template_attr_rec.default_flag = 'N')))
      THEN
         IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
         THEN
             FND_MESSAGE.Set_Name('AMS', 'AMS_EDIT_SELECT_DEF_ERROR');

Line: 913


      SELECT *
      FROM ams_prod_template_attr
      WHERE template_attribute_id = p_template_attr_rec.template_attribute_id;

Line: 936


   IF p_template_attr_rec.last_update_date = FND_API.g_miss_date THEN
      x_complete_rec.last_update_date := l_template_attr_rec.last_update_date;

Line: 941


   IF p_template_attr_rec.last_updated_by = FND_API.g_miss_num THEN
      x_complete_rec.last_updated_by := l_template_attr_rec.last_updated_by;

Line: 961


   IF p_template_attr_rec.last_update_login = FND_API.g_miss_num THEN
      x_complete_rec.last_update_login := l_template_attr_rec.last_update_login;

Line: 976


   IF p_template_attr_rec.parent_select_all = FND_API.g_miss_char THEN
      x_complete_rec.parent_select_all := l_template_attr_rec.parent_select_all;