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

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

Line: 57


      SELECT AMS_LIST_QUERIES_ALL_s.NEXTVAL
      FROM dual;

Line: 61


      SELECT 1 FROM dual
      WHERE EXISTS (SELECT 1 FROM AMS_LIST_QUERIES_ALL
                    WHERE LIST_QUERY_ID = l_id);

Line: 154


      AMS_LIST_QUERIES_PKG.Insert_Row(
          px_list_query_id  => l_list_query_id,
          p_last_update_date  => SYSDATE,
          p_last_updated_by  => FND_GLOBAL.USER_ID,
          p_creation_date  => SYSDATE,
          p_created_by  => FND_GLOBAL.USER_ID,
          p_last_update_login  => FND_GLOBAL.CONC_LOGIN_ID,
          px_object_version_number  => l_object_version_number,
          p_name  => p_list_query_rec.name,
          p_type  => p_list_query_rec.type,
          p_enabled_flag  => p_list_query_rec.enabled_flag,
          p_primary_key  => p_list_query_rec.primary_key,
          p_source_object_name => p_list_query_rec.source_object_name,
          p_public_flag  => p_list_query_rec.public_flag,
          px_org_id  => l_org_id,
          p_comments  => p_list_query_rec.comments,
          p_act_list_query_used_by_id
                         => p_list_query_rec.act_list_query_used_by_id,
          p_arc_act_list_query_used_by
                         => p_list_query_rec.arc_act_list_query_used_by,
          p_sql_string  => p_list_query_rec.sql_string,
          p_parent_list_query_id => l_parent_list_query_id,
          p_sequence_order       => p_list_query_rec.sequence_order);

Line: 306


         l_list_query_rec.LAST_UPDATE_DATE   := p_list_query_rec_tbl.LAST_UPDATE_DATE;

Line: 307


         l_list_query_rec.LAST_UPDATED_BY   := p_list_query_rec_tbl.LAST_UPDATED_BY;

Line: 310


         l_list_query_rec.LAST_UPDATE_LOGIN   := p_list_query_rec_tbl.LAST_UPDATE_LOGIN;

Line: 495


  update ams_list_queries_all set parameterized_flag = 'Y'
  where parent_list_query_id = l_parent_list_query_id;

Line: 497


  delete from ams_list_queries_param
  where list_query_id = l_parent_list_query_id ;

Line: 501


      INSERT INTO  AMS_LIST_QUERIES_PARAM(
         LIST_QUERY_PARAM_ID    ,
         LIST_QUERY_ID          ,
         LAST_UPDATE_DATE       ,
         LAST_UPDATED_BY        ,
         CREATION_DATE          ,
         CREATED_BY             ,
         LAST_UPDATE_LOGIN      ,
         OBJECT_VERSION_NUMBER  ,
         PARAMETER_ORDER        ,
         PARAMETER_VALUE
      )
      VALUES (
         AMS_LIST_QUERIES_PARAM_S.NEXTVAL
         ,l_parent_list_query_id
         ,SYSDATE
         ,FND_GLOBAL.User_Id
         ,SYSDATE
         ,FND_GLOBAL.User_Id
         ,FND_GLOBAL.Conc_Login_Id
         ,1
         ,i
         , p_query_param(i)
      ) ;

Line: 591


PROCEDURE Update_List_Query(
    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_list_query_rec             IN    list_query_rec_type,
    x_object_version_number      OUT NOCOPY  NUMBER
    )

 IS

CURSOR c_get_list_query(list_query_id NUMBER) IS
    SELECT *
    FROM  AMS_LIST_QUERIES_ALL
    WHERE list_query_id = p_list_query_rec.list_query_id;

Line: 612


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

Line: 624


      SAVEPOINT UPDATE_List_Query_PVT;

Line: 660


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

Line: 724


      AMS_LIST_QUERIES_PKG.Update_Row(
          p_list_query_id  => l_list_query_rec.list_query_id,
          p_last_update_date  => SYSDATE,
          p_last_updated_by  => FND_GLOBAL.USER_ID,
          p_creation_date  => l_list_query_rec.creation_date,
          p_created_by  => l_list_query_rec.created_by,
          p_last_update_login  => FND_GLOBAL.CONC_LOGIN_ID,
          p_object_version_number  => l_list_query_rec.object_version_number,
          p_name  => l_list_query_rec.name,
          p_type  => l_list_query_rec.type,
          p_enabled_flag  => l_list_query_rec.enabled_flag,
          p_primary_key  => l_list_query_rec.primary_key,
          p_source_object_name => l_list_query_rec.source_object_name,
          p_public_flag  => l_list_query_rec.public_flag,
          p_org_id  => l_list_query_rec.org_id,
          p_comments  => l_list_query_rec.comments,
          p_act_list_query_used_by_id  =>
                          l_list_query_rec.act_list_query_used_by_id,
          p_arc_act_list_query_used_by  =>
                          l_list_query_rec.arc_act_list_query_used_by,
          p_sql_string  => l_list_query_rec.sql_string,
          p_parent_list_query_id => p_list_query_rec.parent_list_query_id,
          p_sequence_order       => p_list_query_rec.sequence_order);

Line: 778


     ROLLBACK TO UPDATE_List_Query_PVT;

Line: 788


     ROLLBACK TO UPDATE_List_Query_PVT;

Line: 798


     ROLLBACK TO UPDATE_List_Query_PVT;

Line: 810


End Update_List_Query;

Line: 811


PROCEDURE Update_List_Query(
    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_list_query_rec_tbl               IN    list_query_rec_type_tbl,
    p_sql_string_tbl       in sql_string_tbl ,
    x_object_version_number      OUT NOCOPY  NUMBER
    ) is


CURSOR c_get_list_query IS
    SELECT *
    FROM  AMS_LIST_QUERIES_ALL
    WHERE list_query_id = p_list_query_rec_tbl.parent_list_query_id;

Line: 830


    SELECT count(1)
    FROM  AMS_LIST_QUERIES_ALL
    WHERE parent_list_query_id = p_list_query_rec_tbl.parent_list_query_id;

Line: 836


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

Line: 850


select list_query_id ,object_version_number
from   ams_list_queries_all
where parent_list_query_id = cur_parent_query_id
and   sequence_order = cur_sequence_order ;

Line: 856


select query --sql_string column is obsolete bug 4604653
from   ams_list_queries_all
where parent_list_query_id = cur_parent_query_id;

Line: 864


      SAVEPOINT UPDATE_List_Query_PVT_TBL;

Line: 944


         l_list_query_rec.LAST_UPDATE_DATE   := l_list_query_rec_tbl.LAST_UPDATE_DATE;

Line: 945


         l_list_query_rec.LAST_UPDATED_BY   := l_list_query_rec_tbl.LAST_UPDATED_BY;

Line: 948


         l_list_query_rec.LAST_UPDATE_LOGIN   := l_list_query_rec_tbl.LAST_UPDATE_LOGIN;

Line: 1001


               Update_List_Query(
                  p_api_version_number     => p_api_version_number,
                  p_init_msg_list          => p_init_msg_list,
                  p_commit                 => p_commit ,
                  p_validation_level       => p_validation_level        ,
                  x_return_status          => x_return_status           ,
                  x_msg_count              => x_msg_count               ,
                  x_msg_data               => x_msg_data   ,
                  p_list_query_rec         => l_list_query_rec ,
                  x_object_version_number  => l_object_version_number
    );

Line: 1036


      delete from ams_list_queries_all
      where parent_list_query_id = l_parent_list_query_id
       and  sequence_order  > l_no_of_records_upd  ;

Line: 1068


     ROLLBACK TO UPDATE_List_Query_PVT_tbl;

Line: 1078


     ROLLBACK TO UPDATE_List_Query_PVT_tbl;

Line: 1088


     ROLLBACK TO UPDATE_List_Query_PVT_tbl;

Line: 1100


END Update_List_Query;

Line: 1104


PROCEDURE Delete_List_Query(
    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_list_query_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

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

Line: 1123


      SAVEPOINT DELETE_List_Query_PVT;

Line: 1156


      AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

Line: 1160


      AMS_LIST_QUERIES_PKG.Delete_Row(
          p_LIST_QUERY_ID  => p_LIST_QUERY_ID);

Line: 1191


     ROLLBACK TO DELETE_List_Query_PVT;

Line: 1201


     ROLLBACK TO DELETE_List_Query_PVT;

Line: 1211


     ROLLBACK TO DELETE_List_Query_PVT;

Line: 1223


End Delete_List_Query;

Line: 1225


PROCEDURE Delete_parent_List_Query(
    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_parent_list_query_id       IN  NUMBER,
    p_object_version_number      IN   NUMBER
    ) is
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_List_Query';

Line: 1241


is select list_query_id
from ams_list_queries_all
where parent_list_query_id = p_parent_list_query_id ;

Line: 1248


      SAVEPOINT DELETE_List_Query_PVT_tbl;

Line: 1281


      AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

Line: 1289


         AMS_LIST_QUERIES_PKG.Delete_Row(
             p_LIST_QUERY_ID  => l_LIST_QUERY_ID);

Line: 1321


     ROLLBACK TO DELETE_List_Query_PVT_tbl;

Line: 1331


     ROLLBACK TO DELETE_List_Query_PVT_tbl;

Line: 1341


     ROLLBACK TO DELETE_List_Query_PVT_tbl;

Line: 1353


END Delete_parent_List_Query;

Line: 1378


   SELECT LIST_QUERY_ID
   FROM AMS_LIST_QUERIES_ALL
   WHERE LIST_QUERY_ID = p_LIST_QUERY_ID
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 1496


is select FND_API.g_FALSE
from ams_list_queries_vl
where  ( parent_list_query_id <> p_list_query_rec.parent_list_query_id
      or (parent_list_query_id is null
          and list_query_id <> p_list_query_rec.list_query_id ))
and    name   = p_list_query_rec.name ;

Line: 1779


   SELECT *
   FROM ams_list_queries_all
   WHERE list_query_id = p_list_query_rec.list_query_id;

Line: 1805


   IF p_list_query_rec.last_update_date = FND_API.g_miss_date THEN
     x_complete_rec.last_update_date        := l_query_rec.last_update_date;

Line: 1809


   IF p_list_query_rec.last_updated_by = FND_API.g_miss_num THEN
     x_complete_rec.last_updated_by         := l_query_rec.last_updated_by;

Line: 1821


   IF p_list_query_rec.last_update_login  = FND_API.g_miss_num THEN
    x_complete_rec.last_update_login       := l_query_rec.last_update_login;

Line: 1921


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

Line: 2057


   x_listquery_rec.LAST_UPDATE_DATE   := FND_API.g_miss_date ;

Line: 2058


   x_listquery_rec.LAST_UPDATED_BY   := FND_API.g_miss_num ;

Line: 2061


   x_listquery_rec.LAST_UPDATE_LOGIN   := FND_API.g_miss_num ;

Line: 2085


   x_listquery_rec.LAST_UPDATE_DATE   := FND_API.g_miss_date ;

Line: 2086


   x_listquery_rec.LAST_UPDATED_BY   := FND_API.g_miss_num ;

Line: 2089


   x_listquery_rec.LAST_UPDATE_LOGIN   := FND_API.g_miss_num ;

Line: 2114


   SELECT *
   FROM   ams_list_queries_all
   WHERE list_query_id = p_listquery_rec.parent_list_query_id
     and sequence_order = 1;

Line: 2140


   IF p_listquery_rec.LAST_UPDATE_DATE   = FND_API.g_miss_date THEN
         x_complete_rec.LAST_UPDATE_DATE   := l_listquery_rec.LAST_UPDATE_DATE;

Line: 2144


   IF p_listquery_rec.LAST_UPDATED_BY   = FND_API.g_miss_num THEN
         x_complete_rec.LAST_UPDATED_BY   := l_listquery_rec.LAST_UPDATED_BY;

Line: 2157


   IF p_listquery_rec.LAST_UPDATE_LOGIN   = FND_API.g_miss_num THEN
         x_complete_rec.LAST_UPDATE_LOGIN   := l_listquery_rec.LAST_UPDATE_LOGIN;

Line: 2229


   SELECT *
   FROM   ams_list_queries_all
   WHERE list_query_id = p_listquery_rec.list_query_id;

Line: 2254


   IF p_listquery_rec.LAST_UPDATE_DATE   = FND_API.g_miss_date THEN
         x_complete_rec.LAST_UPDATE_DATE   := l_listquery_rec.LAST_UPDATE_DATE;

Line: 2258


   IF p_listquery_rec.LAST_UPDATED_BY   = FND_API.g_miss_num THEN
         x_complete_rec.LAST_UPDATED_BY   := l_listquery_rec.LAST_UPDATED_BY;

Line: 2271


   IF p_listquery_rec.LAST_UPDATE_LOGIN   = FND_API.g_miss_num THEN
         x_complete_rec.LAST_UPDATE_LOGIN   := l_listquery_rec.LAST_UPDATE_LOGIN;

Line: 2370


  SELECT *
  FROM ams_list_queries_all
  WHERE parent_list_query_id =listqueryId
  ORDER BY sequence_order;

Line: 2375


 CURSOR fetch_list_select_actions(list_id NUMBER) IS
      SELECT incl_object_id,rank,order_number,description,list_action_type
             ,no_of_rows_requested,no_of_rows_available,no_of_rows_used
	     ,distribution_pct,no_of_rows_targeted
      FROM ams_list_select_actions
      WHERE action_used_by_id =list_id
      AND arc_action_used_by='LIST'
      AND arc_incl_object_from='SQL';

Line: 2422


 FOR l_list_actions_rec IN fetch_list_select_actions(p_source_listheader_id)
 LOOP

	   j:=0;

Line: 2426


	   l_sql_string_tbl.DELETE;

Line: 2470


		  l_action_rec.list_select_action_id          := NULL;