APPS.AMS_LIST_WF SQL Statements

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

Line: 36

    SELECT employee_id source_id
      FROM ams_jtf_rs_emp_v
     WHERE resource_id = p_user_id ;

Line: 108

  cursor c1(l_last_updated_by number) is
  select jtf.resource_id
    from jtf_rs_resource_extns jtf
   where jtf.user_id = l_last_updated_by;

Line: 140

     update ams_list_headers_all
     set object_version_number = object_version_number + 1
     where list_header_id = p_list_header_id;

Line: 199

  open c1(l_clistHeader_rec.last_updated_by);

Line: 355

             update ams_list_headers_all
             set status_code                  = 'SCHEDULED',
                 user_status_id               = 301,
                 status_date                  = sysdate,
                 last_update_date             = sysdate
             WHERE  list_header_id            = l_list_header_id;

Line: 365

             update ams_list_headers_all
             set status_code                  = 'GENERATING',
                 user_status_id               = 302,
                 status_date                  = sysdate,
                 last_update_date             = sysdate
             WHERE  list_header_id            = l_list_header_id;

Line: 426

             update ams_list_headers_all
             set status_code                  = 'GENERATING',
                 user_status_id               = 302,
                 status_date                  = sysdate,
                 last_update_date             = sysdate
             WHERE  list_header_id            = l_list_header_id;

Line: 479

select list_used_by , list_used_by_id
from  ams_act_lists
where list_header_id = l_list_header_id
and   list_act_type = 'TARGET' ;

Line: 562

  select USER_ENTERED_START_TIME, timezone_id
  from ams_list_headers_vl
  where list_header_id = p_list_header_id;

Line: 645

        update ams_list_headers_all set WORKFLOW_ITEM_KEY  = l_new_item_key
        where list_header_id = p_list_header_id;

Line: 648

             update ams_list_headers_all
             set status_code                  = 'SCHEDULED',
                 user_status_id               = 301,
                 status_date                  = sysdate,
                 last_update_date             = sysdate,
                 WORKFLOW_ITEM_KEY  	      = l_new_item_key
             WHERE  list_header_id            = p_list_header_id;

Line: 698

  cursor c1(l_last_updated_by number) is
  select jtf.resource_id
    from jtf_rs_resource_extns jtf
   where jtf.user_id = l_last_updated_by;

Line: 734

     update ams_list_headers_all
     set object_version_number = object_version_number + 1
     where list_header_id = l_list_header_id;

Line: 785

  open c1(l_clistHeader_rec.last_updated_by);

Line: 846

  is select item_key
  from wf_item_activity_statuses
  where item_type = l_item_type
  and   item_key like p_list_header_id|| '%'
  and activity_status in ('ERROR','ACTIVE');

Line: 853

        select status_code into l_status_code from ams_list_headers_all
        where list_header_id = p_list_header_id;

Line: 856

        update ams_list_headers_all
	   set WORKFLOW_ITEM_KEY  = null,
               status_code        = 'FAILED',
               user_status_id     = 311,
               last_update_date   = sysdate,
               status_date        = sysdate
        where list_header_id = p_list_header_id;

Line: 895

    select WORKFLOW_ITEM_KEY
    from ams_list_headers_all where list_header_id = l_list_header_id;