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.IEU_WR_PUB SQL Statements

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

Line: 95


   select work_item_id, workitem_pk_id, workitem_obj_code
   from   ieu_uwqm_items
   where  source_object_id = p_source_object_id
   and    source_object_type_code = p_source_object_type_code
   and ( distribution_status_id = 0 or distribution_status_id = 1);

Line: 106


      SAVEPOINT insert_wr_items_sp;

Line: 212


          SELECT object_code, object_function
          INTO   l_workitem_obj_code, l_object_function
          FROM   jtf_objects_b
          WHERE  object_code = p_workitem_obj_code;

Line: 255


             SELECT priority_id, priority_level
             INTO   l_priority_id, l_priority_level
             FROM   ieu_uwqm_priorities_b
             WHERE  priority_code = p_priority_code;

Line: 291


         (p_work_item_status = 'DELETE') OR
            (p_work_item_status = 'SLEEP')
      THEN
            l_work_item_status_valid_flag := 'T';

Line: 434


         ELSIF (p_work_item_status = 'DELETE')
         THEN
             l_work_item_status_id := 4;

Line: 450


       Select ws_id
       into   l_ws_id1
       from   ieu_uwqm_work_sources_b
       where  object_code = p_workitem_obj_code
--       and    nvl(not_valid_flag,'N') = 'N';

Line: 481


         Select ws_id
         into   l_ws_id2
         from   ieu_uwqm_work_sources_b
         where  object_code = p_source_object_type_code
--         and    nvl(not_valid_flag,'N') = 'N';

Line: 502


                   SELECT a.ws_id
                   INTO   l_association_ws_id
                   FROM   ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
                   WHERE  child_ws_id = l_ws_id1
                   AND    parent_ws_id = l_ws_id2
                   AND    a.ws_id = b.ws_id
--                   AND    nvl(b.not_valid_flag,'N') = 'N';

Line: 530


           SELECT  ws_a_props.dist_st_based_on_parent_flag
           INTO   l_dist_st_based_on_parent
           FROM   ieu_uwqm_work_sources_b ws_b, IEU_UWQM_WS_ASSCT_PROPS ws_a_props
           WHERE  ws_b.ws_id = l_association_ws_id
           AND    ws_b.ws_id = ws_a_props.ws_id
--           AND    nvl(ws_b.not_valid_flag,'N') = 'N';

Line: 565


           SELECT distribute_from, distribute_to
           INTO   l_dist_from, l_dist_to
           FROM   ieu_uwqm_work_sources_b
           WHERE  ws_id = l_ws_id1;

Line: 596


              SELECT distribution_status_id, status_id
              INTO   l_parent_dist_status, l_parent_status_id
              FROM   ieu_uwqm_items
              WHERE  workitem_pk_id = p_source_object_id
              AND    workitem_obj_code = p_source_object_type_code;

Line: 719


      IEU_WR_ITEMS_PKG.INSERT_ROW
       ( p_workitem_obj_code,
         p_workitem_pk_id,
         p_work_item_number,
         p_title,
         p_party_id,
         l_priority_id,
         l_priority_level,
         p_due_date,
         l_work_item_status_id,
         p_owner_id,
         l_owner_type,
         p_assignee_id,
         l_assignee_type,
         l_owner_type_actual,
         l_assignee_type_actual,
         p_source_object_id,
         p_source_object_type_code,
         p_application_id,
         p_ieu_enum_type_uuid,
         p_user_id,
         p_login_id,
         l_curr_ws_id,
         l_distribution_status_id,
         x_work_item_id,
         l_msg_data,
         x_return_status
       );

Line: 758


                        select a.ws_id
                        into   l_ws_id
                        from   ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
                        where (parent_ws_id =  l_curr_ws_id)
                        and   a.ws_id = b.ws_id
--                        and   nvl(b.not_valid_flag, 'N') = 'N';

Line: 848


  ROLLBACK TO insert_wr_items_sp;

Line: 859


  ROLLBACK TO insert_wr_items_sp;

Line: 871


  ROLLBACK TO insert_wr_items_sp;

Line: 887


PROCEDURE UPDATE_WR_ITEM
( p_api_version               IN NUMBER,
  p_init_msg_list             IN VARCHAR2 DEFAULT NULL,
  p_commit                    IN VARCHAR2 DEFAULT NULL,
  p_workitem_obj_code         IN VARCHAR2 DEFAULT NULL,
  p_workitem_pk_id            IN NUMBER   DEFAULT NULL,
  p_title                           IN VARCHAR2 DEFAULT NULL,
  p_party_id                        IN NUMBER,
  p_priority_code             IN VARCHAR2 DEFAULT NULL,
  p_due_date                  IN DATE,
  p_owner_id                  IN NUMBER   DEFAULT NULL,
  p_owner_type                IN VARCHAR2 DEFAULT NULL,
  p_assignee_id               IN NUMBER,
  p_assignee_type             IN VARCHAR2,
  p_source_object_id          IN NUMBER,
  p_source_object_type_code   IN VARCHAR2,
  p_application_id            IN NUMBER   DEFAULT NULL,
  p_work_item_status          IN VARCHAR2 DEFAULT NULL,
  p_user_id                   IN NUMBER   DEFAULT NULL,
  p_login_id                  IN NUMBER   DEFAULT NULL,
  x_msg_count                 OUT NOCOPY  NUMBER,
  x_msg_data                  OUT NOCOPY VARCHAR2,
  x_return_status             OUT NOCOPY VARCHAR2) AS

  l_api_version  NUMBER        := 1.0;

Line: 958


   select work_item_id, workitem_pk_id, workitem_obj_code
   from   ieu_uwqm_items
   where  source_object_id = p_source_object_id
   and    source_object_type_code = p_source_object_type_code
   and ( distribution_status_id = 0 or distribution_status_id = 1);

Line: 982


      l_api_name := 'UPDATE_WR_ITEM';

Line: 984


      SAVEPOINT update_wr_items_sp;

Line: 1046


         FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 1063


      select decode(p_title, FND_API.G_MISS_CHAR, title, p_title) title,
             decode(p_party_id, FND_API.G_MISS_NUM, party_id, p_party_id) party_id,
             decode(p_due_date, FND_API.G_MISS_DATE, due_date, p_due_date) due_date,
             decode(p_owner_id, FND_API.G_MISS_NUM, owner_id, p_owner_id) owner_id,
             decode(p_owner_type, FND_API.G_MISS_CHAR, owner_type_actual, p_owner_type) owner_type_actual,
             decode(p_assignee_id, FND_API.G_MISS_NUM, assignee_id, p_assignee_id) assignee_id,
             decode(p_assignee_type, FND_API.G_MISS_CHAR, assignee_type_actual, p_assignee_type) assignee_type_actual,
             decode(p_source_object_id, FND_API.G_MISS_NUM, source_object_id, p_source_object_id) source_object_id,
             decode(p_source_object_type_code, FND_API.G_MISS_CHAR, source_object_type_code, p_source_object_type_code) source_object_type_code,
             decode(p_application_id, FND_API.G_MISS_NUM, application_id, p_application_id) application_id
       into  m_title,
             m_party_id,
             m_due_date,
             m_owner_id,
             m_owner_type,
             m_assignee_id,
             m_assignee_type,
             m_source_object_id,
             m_source_object_type_code,
             m_application_id
       from ieu_uwqm_items
       where workitem_obj_code = p_workitem_obj_code
         and workitem_pk_id = p_workitem_pk_id;

Line: 1090


	      select title,
		     party_id,
		     due_date,
		     owner_id,
		     owner_type_actual,
		     assignee_id,
		     assignee_type_actual,
		     source_object_id,
		     source_object_type_code,
		     application_id
	       into  m_title,
		     m_party_id,
		     m_due_date,
		     m_owner_id,
		     m_owner_type,
		     m_assignee_id,
		     m_assignee_type,
		     m_source_object_id,
		     m_source_object_type_code,
		     m_application_id
	       from ieu_uwqm_items
	       where workitem_obj_code = p_workitem_obj_code
		 and workitem_pk_id = p_workitem_pk_id;

Line: 1119


            FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 1173


	select decode(p_priority_code, FND_API.G_MISS_CHAR, b.priority_code, p_priority_code) priority_code
	into m_priority_code
	from ieu_uwqm_items a, ieu_uwqm_priorities_b b
	where a.priority_id = b.priority_id
	  and a.priority_level = b.priority_level
	  and a.workitem_obj_code = p_workitem_obj_code
	  and a.workitem_pk_id = p_workitem_pk_id;

Line: 1186


            FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 1200


	       select decode(p_work_item_status, FND_API.G_MISS_CHAR, decode(status_id, 0, 'OPEN', 3, 'CLOSE', 4, 'DELETE', 5, 'SLEEP'), p_work_item_status) status_id
	       into m_work_item_status
	       from ieu_uwqm_items
	       where workitem_obj_code = p_workitem_obj_code
		 and workitem_pk_id = p_workitem_pk_id;

Line: 1210


            FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 1235


          SELECT 1
          INTO   l_workitem_obj_code
          FROM   jtf_objects_b
          WHERE  object_code = p_workitem_obj_code;

Line: 1256


            FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 1278


             SELECT priority_id, priority_level
             INTO   l_priority_id, l_priority_level
             FROM   ieu_uwqm_priorities_b
             WHERE  priority_code = m_priority_code;

Line: 1295


            FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 1312


         (m_work_item_status = 'DELETE') OR
            (m_work_item_status = 'SLEEP')
      THEN
            l_work_item_status_valid_flag := 'T';

Line: 1343


            FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 1392


	  FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 1452


         ELSIF (m_work_item_status = 'DELETE')
         THEN
             l_work_item_status_id := 4;

Line: 1468


       Select ws_id
       into   l_ws_id1
       from   ieu_uwqm_work_sources_b
       where  object_code = p_workitem_obj_code
--       and    nvl(not_valid_flag,'N') = 'N';

Line: 1499


         Select ws_id
         into   l_ws_id2
         from   ieu_uwqm_work_sources_b
         where  object_code = m_source_object_type_code
--         and    nvl(not_valid_flag,'N') = 'N';

Line: 1520


                   SELECT a.ws_id
                   INTO   l_association_ws_id
                   FROM   ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
                   WHERE  child_ws_id = l_ws_id1
                   AND    parent_ws_id = l_ws_id2
                   AND    a.ws_id = b.ws_id
--                   AND    nvl(b.not_valid_flag,'N') = 'N';

Line: 1548


           SELECT ws_a_props.dist_st_based_on_parent_flag
           INTO   l_dist_st_based_on_parent
           FROM   ieu_uwqm_work_sources_b ws_b, IEU_UWQM_WS_ASSCT_PROPS ws_a_props
           WHERE  ws_b.ws_id = l_association_ws_id
           AND    ws_b.ws_id = ws_a_props.ws_id
--           AND    nvl(ws_b.not_valid_flag, 'N') = 'N';

Line: 1582


           SELECT distribute_from, distribute_to
           INTO   l_dist_from, l_dist_to
           FROM   ieu_uwqm_work_sources_b
           WHERE  ws_id = l_ws_id1;

Line: 1613


              SELECT distribution_status_id, status_id
              INTO   l_parent_dist_status, l_parent_status_id
              FROM   ieu_uwqm_items
              WHERE  workitem_pk_id = m_source_object_id
              AND    workitem_obj_code = m_source_object_type_code;

Line: 1734


      IEU_WR_ITEMS_PKG.UPDATE_ROW
       ( p_workitem_obj_code,
         p_workitem_pk_id,
         m_title,
         m_party_id,
         l_priority_id,
         l_priority_level,
         m_due_date,
         m_owner_id,
         l_owner_type,
         m_assignee_id,
         l_assignee_type,
         l_owner_type_actual,
         l_assignee_type_actual,
         m_source_object_id,
         m_source_object_type_code,
         m_application_id,
         l_work_item_status_id,
         p_user_id,
         p_login_id,
         l_curr_ws_id,
         l_distribution_status_id,
         l_msg_data,
         x_return_status
        );

Line: 1770


                          select a.ws_id
                          into   l_ws_id
                          from   ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
                          where  (parent_ws_id =  l_curr_ws_id)
                          and   a.ws_id = b.ws_id
--                          and   nvl(b.not_valid_flag, 'N') = 'N';

Line: 1810


                                               FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_WR_ITEM_FAILED');

Line: 1811


                                               FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 1839


         FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_WR_ITEM_FAILED');

Line: 1840


         FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 1863


  ROLLBACK TO update_wr_items_sp;

Line: 1874


  ROLLBACK TO update_wr_items_sp;

Line: 1886


  ROLLBACK TO update_wr_items_sp;

Line: 1900


END UPDATE_WR_ITEM;

Line: 1954


  l_date_selected   varchar2(1);

Line: 1976


     select work_item_id, owner_type, assignee_type
     from   ieu_uwqm_items
     where  workitem_obj_code = p_obj_code;

Line: 1982


     select work_item_id, owner_type, assignee_type, source_object_id, source_object_type_code
     from   ieu_uwqm_items
     where  workitem_obj_code = p_child_obj_code
     and    source_object_type_code = p_parent_obj_code;

Line: 1988


   select tb.task_id, tb.task_number, tb.customer_id, tb.owner_id, tb.owner_type_code,
  tb.source_object_id, tb.source_object_type_code,
--  decode(tb.date_selected, 'P', tb.planned_end_date,
--         'A', tb.actual_end_date, 'S', tb.scheduled_end_date, null, tb.scheduled_end_date) due_date,
  tb.planned_start_date, tb.planned_end_date, tb.actual_start_date, tb.actual_end_date,
  tb.scheduled_start_date, tb.scheduled_end_date,tb.task_type_id,
  tb.task_status_id, tt.task_name, tp.importance_level, ip.priority_code, tb.task_priority_id
  from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip
  where tb.entity = 'TASK' and nvl(tb.deleted_flag, 'N') = 'N' and tb.task_id = tt.task_id
  and tt.language = userenv('LANG') and tp.task_priority_id = nvl(tb.task_priority_id, 4)
  and least(tp.importance_level, 4) = ip.priority_level
  and tb.open_flag = 'Y'
  and tb.source_object_type_code = p_source_object_type_code;

Line: 2003


   SELECT TASK_ID,
          DECODE(DELETED_FLAG, 'Y', 4, 3) "STATUS_ID"
   FROM JTF_TASKS_B
   WHERE SOURCE_OBJECT_TYPE_CODE = p_source_object_type_code
   AND ((OPEN_FLAG = 'N' AND DELETED_FLAG = 'N') OR (DELETED_FLAG = 'Y'))
   AND ENTITY = 'TASK';

Line: 2066


       Select ws_id, ws_type, object_code
       into   l_ws_id, l_ws_type, l_obj_code
       from   ieu_uwqm_work_sources_b
       where  ws_code = p_ws_code
--       and nvl(not_valid_flag, 'N') = 'N';

Line: 2115


           SELECT parent_ws_id, child_ws_id, dist_st_based_on_parent_flag , tasks_rules_function
           INTO   l_parent_ws_id, l_child_ws_id, l_dist_st_based_on_parent , l_tasks_rules_func
           FROM   IEU_UWQM_WS_ASSCT_PROPS
           WHERE  ws_id = l_ws_id;

Line: 2141


           SELECT object_code
           INTO   l_parent_obj_code
           FROM   IEU_UWQM_WORK_SOURCES_B
           WHERE  ws_id = l_parent_ws_id
--           and nvl(not_valid_flag, 'N') = 'N';

Line: 2169


           SELECT object_code
           INTO   l_child_obj_code
           FROM   IEU_UWQM_WORK_SOURCES_B
           WHERE  ws_id = l_child_ws_id
--           and nvl(not_valid_flag, 'N') = 'N';

Line: 2266


           update ieu_uwqm_items
           set    ws_id = l_ws_id,
                  distribution_status_id = l_distribution_status_id
           where work_item_id = cur_rec.work_item_id;

Line: 2294


	    --  insert into p_temp(msg) values (' count after fetch: '||l_tmp_var);

Line: 2299


                select 'SLEEP' into l_task_status
                from jtf_task_statuses_vl
                where (nvl(on_hold_flag,'N') = 'Y')
                and task_status_id = l_task_status_id;

Line: 2309


	        select booking_end_date
		into   l_due_date
		from   jtf_task_all_assignments
		where  task_id = l_task_id
		and    assignee_role = 'OWNER';

Line: 2329


                 select count(*) into l_uwqm_count
                 from ieu_uwqm_items
--                 where workitem_obj_code = 'TASK'
                 where workitem_obj_code = l_workitem_obj_code_1
                 and workitem_pk_id = l_task_id;

Line: 2341


                 l_task_data_var := 'UPDATE_TASK';

Line: 2363


                                                     l_date_selected,
                                                     l_planned_start_date,
                                                     l_planned_end_date,
                                                     l_scheduled_start_date,
                                                     l_scheduled_end_date,
                                                     l_actual_start_date,
                                                     l_actual_end_date,
                                                     null,
                                                     null,
                                                     null);

Line: 2456


                 SELECT distribution_status_id, status_id
                 INTO   l_parent_dist_status, l_parent_status_id
                 FROM   ieu_uwqm_items
                 WHERE  workitem_pk_id = cur_rec.source_object_id
                 AND    workitem_obj_code = cur_rec.source_object_type_code;

Line: 2511


              update ieu_uwqm_items
              set    ws_id = l_ws_id,
                  distribution_status_id = l_distribution_status_id
              where work_item_id = cur_rec.work_item_id;

Line: 2534


	--	fnd_file.put_line(FND_FILE.LOG,'Begin update');

Line: 2536


			update IEU_UWQM_ITEMS
			set	status_id = l_task_status_rec.l_status_id_list(i),
         			LAST_UPDATED_BY        = FND_GLOBAL.USER_ID,
	        		LAST_UPDATE_DATE       = SYSDATE,
		        	LAST_UPDATE_LOGIN      = FND_GLOBAL.LOGIN_ID
			where   workitem_obj_code = 'TASK'
                        and     workitem_pk_id = l_task_status_rec.l_task_id_list(i)
                        and     source_object_type_code = l_parent_obj_code;

Line: 2551


                       FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');

Line: 2570


             l_task_status_rec.l_task_id_list.DELETE;

Line: 2571


             l_task_status_rec.l_status_id_list.DELETE;

Line: 2692


       Select ws_id, ws_type, object_code
       into   l_ws_id, l_ws_type, l_obj_code
       from   ieu_uwqm_work_sources_b
       where  ws_code = p_ws_det_list(i).ws_code
--       and nvl(not_valid_flag, 'N') = 'N';

Line: 2867


        select owner_type, assignee_type, ws_id, source_object_id, source_object_type_code
        into   l_owner_type , l_assignee_type, l_ws_id, l_source_object_id, l_source_object_type_code
        from   ieu_uwqm_items
        where  workitem_pk_id = p_wr_item_list(i).workitem_pk_id
        and    workitem_obj_code = p_wr_item_list(i).workitem_obj_code;

Line: 2880


         FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');

Line: 2881


         FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 2898


       Select ws_code, ws_type
       into   l_ws_code, l_ws_type
       from   ieu_uwqm_work_sources_b
       where  ws_id = l_ws_id
--       and    nvl(not_valid_flag, 'N') = 'N';

Line: 2929


           SELECT parent_ws_id, child_ws_id, dist_st_based_on_parent_flag
           INTO   l_parent_ws_id, l_child_ws_id, l_dist_st_based_on_parent
           FROM   IEU_UWQM_WS_ASSCT_PROPS
           WHERE  ws_id = l_ws_id;

Line: 2962


              SELECT distribution_status_id, status_id
              INTO   l_parent_dist_status, l_parent_status_id
              FROM   ieu_uwqm_items
              WHERE  workitem_pk_id = l_source_object_id
              AND    workitem_obj_code = l_source_object_type_code;

Line: 3080


      update ieu_uwqm_items
      set distribution_status_id = l_distribution_status_id
      where workitem_pk_id = p_wr_item_list(i).workitem_pk_id
      and   workitem_obj_code = p_wr_item_list(i).workitem_obj_code;

Line: 3223


   select work_item_id, workitem_pk_id, workitem_obj_code
   from   ieu_uwqm_items
   where  source_object_id = p_source_object_id
   and    source_object_type_code = p_source_object_type_code
   and ( distribution_status_id = 0 or distribution_status_id = 1);

Line: 3262


      SAVEPOINT insert_wr_items_sp;

Line: 3369


          SELECT object_code, object_function
          INTO   l_workitem_obj_code, l_object_function
          FROM   jtf_objects_b
          WHERE  object_code = p_workitem_obj_code;

Line: 3412


             SELECT priority_id, priority_level
             INTO   l_priority_id, l_priority_level
             FROM   ieu_uwqm_priorities_b
             WHERE  priority_code = p_priority_code;

Line: 3448


         (p_work_item_status = 'DELETE') OR
            (p_work_item_status = 'SLEEP')
      THEN
            l_work_item_status_valid_flag := 'T';

Line: 3592


         ELSIF (p_work_item_status = 'DELETE')
         THEN
             l_work_item_status_id := 4;

Line: 3608


       Select ws_id , ws_code
       into   l_ws_id1, l_ws_code1
       from   ieu_uwqm_work_sources_b
       where  object_code = p_workitem_obj_code
--       and    nvl(not_valid_flag,'N') = 'N';

Line: 3639


         Select ws_id , ws_code
         into   l_ws_id2, l_ws_code2
         from   ieu_uwqm_work_sources_b
         where  object_code = p_source_object_type_code
--         and    nvl(not_valid_flag,'N') = 'N';

Line: 3660


                   SELECT a.ws_id, b.ws_code
                   INTO   l_association_ws_id, l_assct_ws_code
                   FROM   ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
                   WHERE  child_ws_id = l_ws_id1
                   AND    parent_ws_id = l_ws_id2
                   AND    a.ws_id = b.ws_id
--                   AND    nvl(b.not_valid_flag,'N') = 'N';

Line: 3689


           SELECT  ws_a_props.dist_st_based_on_parent_flag
           INTO   l_dist_st_based_on_parent
           FROM   ieu_uwqm_work_sources_b ws_b, IEU_UWQM_WS_ASSCT_PROPS ws_a_props
           WHERE  ws_b.ws_id = l_association_ws_id
           AND    ws_b.ws_id = ws_a_props.ws_id
--           AND    nvl(ws_b.not_valid_flag,'N') = 'N';

Line: 3725


           SELECT distribute_from, distribute_to
           INTO   l_dist_from, l_dist_to
           FROM   ieu_uwqm_work_sources_b
           WHERE  ws_id = l_ws_id1;

Line: 3756


              SELECT distribution_status_id, status_id
              INTO   l_parent_dist_status, l_parent_status_id
              FROM   ieu_uwqm_items
              WHERE  workitem_pk_id = p_source_object_id
              AND    workitem_obj_code = p_source_object_type_code;

Line: 3884


           SELECT distribute_from, distribute_to
           INTO   l_log_dist_from, l_log_dist_to
           FROM   ieu_uwqm_work_sources_b
           WHERE  ws_id = l_curr_ws_id;

Line: 3953


      IEU_WR_ITEMS_PKG.INSERT_ROW
       ( p_workitem_obj_code,
         p_workitem_pk_id,
         p_work_item_number,
         p_title,
         p_party_id,
         l_priority_id,
         l_priority_level,
         p_due_date,
         l_work_item_status_id,
         p_owner_id,
         l_owner_type,
         p_assignee_id,
         l_assignee_type,
         l_owner_type_actual,
         l_assignee_type_actual,
         p_source_object_id,
         p_source_object_type_code,
         p_application_id,
         p_ieu_enum_type_uuid,
         p_user_id,
         p_login_id,
         l_curr_ws_id,
         l_distribution_status_id,
         x_work_item_id,
         l_msg_data,
         x_return_status
       );

Line: 4035


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_curr_ws_code,
		P_APPLICATION_ID => p_application_id,
		P_WORKITEM_PK_ID => p_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => p_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => null,
		P_WORK_ITEM_STATUS_CURR	=> l_work_item_status_id,
		P_OWNER_ID_PREV	 => null,
		P_OWNER_ID_CURR	=> p_owner_id,
		P_OWNER_TYPE_PREV => null,
		P_OWNER_TYPE_CURR => l_owner_type,
		P_ASSIGNEE_ID_PREV => null,
		P_ASSIGNEE_ID_CURR => p_assignee_id,
		P_ASSIGNEE_TYPE_PREV => null,
		P_ASSIGNEE_TYPE_CURR => l_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => null,
		P_SOURCE_OBJECT_ID_CURR => p_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => null,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => p_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => null,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => null,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => null,
		P_WORKITEM_DIST_STATUS_CURR => l_distribution_status_id,
		P_PRIORITY_PREV => null,
		P_PRIORITY_CURR	=> l_priority_id,
		P_DUE_DATE_PREV	=> null,
		P_DUE_DATE_CURR	=> p_due_date,
		P_RESCHEDULE_TIME_PREV => null,
		P_RESCHEDULE_TIME_CURR => sysdate,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => l_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status);

Line: 4097


                        select a.ws_id
                        into   l_ws_id
                        from   ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
                        where  (parent_ws_id =  l_curr_ws_id)
                        and   a.ws_id = b.ws_id
--                        and   nvl(b.not_valid_flag, 'N') = 'N';

Line: 4204


  ROLLBACK TO insert_wr_items_sp;

Line: 4223


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_curr_ws_code,
		P_APPLICATION_ID => p_application_id,
		P_WORKITEM_PK_ID => p_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => p_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => null,
		P_WORK_ITEM_STATUS_CURR	=> l_work_item_status_id,
		P_OWNER_ID_PREV	 => null,
		P_OWNER_ID_CURR	=> p_owner_id,
		P_OWNER_TYPE_PREV => null,
		P_OWNER_TYPE_CURR => l_owner_type,
		P_ASSIGNEE_ID_PREV => null,
		P_ASSIGNEE_ID_CURR => p_assignee_id,
		P_ASSIGNEE_TYPE_PREV => null,
		P_ASSIGNEE_TYPE_CURR => l_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => null,
		P_SOURCE_OBJECT_ID_CURR => p_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => null,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => p_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => null,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => null,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => null,
		P_WORKITEM_DIST_STATUS_CURR => l_distribution_status_id,
		P_PRIORITY_PREV => null,
		P_PRIORITY_CURR	=> l_priority_id,
		P_DUE_DATE_PREV	=> null,
		P_DUE_DATE_CURR	=> p_due_date,
		P_RESCHEDULE_TIME_PREV => null,
		P_RESCHEDULE_TIME_CURR => sysdate,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => x_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status); commit;

Line: 4283


  ROLLBACK TO insert_wr_items_sp;

Line: 4303


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_curr_ws_code,
		P_APPLICATION_ID => p_application_id,
		P_WORKITEM_PK_ID => p_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => p_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => null,
		P_WORK_ITEM_STATUS_CURR	=> l_work_item_status_id,
		P_OWNER_ID_PREV	 => null,
		P_OWNER_ID_CURR	=> p_owner_id,
		P_OWNER_TYPE_PREV => null,
		P_OWNER_TYPE_CURR => l_owner_type,
		P_ASSIGNEE_ID_PREV => null,
		P_ASSIGNEE_ID_CURR => p_assignee_id,
		P_ASSIGNEE_TYPE_PREV => null,
		P_ASSIGNEE_TYPE_CURR => l_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => null,
		P_SOURCE_OBJECT_ID_CURR => p_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => null,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => p_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => null,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => null,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => null,
		P_WORKITEM_DIST_STATUS_CURR => l_distribution_status_id,
		P_PRIORITY_PREV => null,
		P_PRIORITY_CURR	=> l_priority_id,
		P_DUE_DATE_PREV	=> null,
		P_DUE_DATE_CURR	=> p_due_date,
		P_RESCHEDULE_TIME_PREV => null,
		P_RESCHEDULE_TIME_CURR => sysdate,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => x_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status); commit;

Line: 4363


  ROLLBACK TO insert_wr_items_sp;

Line: 4382


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_curr_ws_code,
		P_APPLICATION_ID => p_application_id,
		P_WORKITEM_PK_ID => p_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => p_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => null,
		P_WORK_ITEM_STATUS_CURR	=> l_work_item_status_id,
		P_OWNER_ID_PREV	 => null,
		P_OWNER_ID_CURR	=> p_owner_id,
		P_OWNER_TYPE_PREV => null,
		P_OWNER_TYPE_CURR => l_owner_type,
		P_ASSIGNEE_ID_PREV => null,
		P_ASSIGNEE_ID_CURR => p_assignee_id,
		P_ASSIGNEE_TYPE_PREV => null,
		P_ASSIGNEE_TYPE_CURR => l_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => null,
		P_SOURCE_OBJECT_ID_CURR => p_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => null,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => p_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => null,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => null,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => null,
		P_WORKITEM_DIST_STATUS_CURR => l_distribution_status_id,
		P_PRIORITY_PREV => null,
		P_PRIORITY_CURR	=> l_priority_id,
		P_DUE_DATE_PREV	=> null,
		P_DUE_DATE_CURR	=> p_due_date,
		P_RESCHEDULE_TIME_PREV => null,
		P_RESCHEDULE_TIME_CURR => sysdate,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => x_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status); commit;

Line: 4447


PROCEDURE UPDATE_WR_ITEM
( p_api_version               IN NUMBER,
  p_init_msg_list             IN VARCHAR2 DEFAULT NULL,
  p_commit                    IN VARCHAR2 DEFAULT NULL,
  p_workitem_obj_code         IN VARCHAR2 DEFAULT NULL,
  p_workitem_pk_id            IN NUMBER   DEFAULT NULL,
  p_title                           IN VARCHAR2 DEFAULT NULL,
  p_party_id                        IN NUMBER,
  p_priority_code             IN VARCHAR2 DEFAULT NULL,
  p_due_date                  IN DATE,
  p_owner_id                  IN NUMBER   DEFAULT NULL,
  p_owner_type                IN VARCHAR2 DEFAULT NULL,
  p_assignee_id               IN NUMBER,
  p_assignee_type             IN VARCHAR2,
  p_source_object_id          IN NUMBER,
  p_source_object_type_code   IN VARCHAR2,
  p_application_id            IN NUMBER   DEFAULT NULL,
  p_work_item_status          IN VARCHAR2 DEFAULT NULL,
  p_user_id                   IN NUMBER   DEFAULT NULL,
  p_login_id                  IN NUMBER   DEFAULT NULL,
  p_audit_trail_rec	      IN SYSTEM.WR_AUDIT_TRAIL_NST,
  x_msg_count                 OUT NOCOPY  NUMBER,
  x_msg_data                  OUT NOCOPY VARCHAR2,
  x_return_status             OUT NOCOPY VARCHAR2) AS

  l_api_version  NUMBER        := 1.0;

Line: 4519


   select work_item_id, workitem_pk_id, workitem_obj_code
   from   ieu_uwqm_items
   where  source_object_id = p_source_object_id
   and    source_object_type_code = p_source_object_type_code
   and ( distribution_status_id = 0 or distribution_status_id = 1);

Line: 4580


  l_api_name  := 'UPDATE_WR_ITEM';

Line: 4582


      SAVEPOINT update_wr_items_sp;

Line: 4644


         FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 4662


	      select decode(p_title, FND_API.G_MISS_CHAR, title, p_title) title,
		     decode(p_party_id, FND_API.G_MISS_NUM, party_id, p_party_id) party_id,
		     decode(p_due_date, FND_API.G_MISS_DATE, due_date, p_due_date) due_date,
		     decode(p_owner_id, FND_API.G_MISS_NUM, owner_id, p_owner_id) owner_id,
		     decode(p_owner_type, FND_API.G_MISS_CHAR, owner_type_actual, p_owner_type) owner_type_actual,
		     decode(p_assignee_id, FND_API.G_MISS_NUM, assignee_id, p_assignee_id) assignee_id,
		     decode(p_assignee_type, FND_API.G_MISS_CHAR, assignee_type_actual, p_assignee_type) assignee_type_actual,
		     decode(p_source_object_id, FND_API.G_MISS_NUM, source_object_id, p_source_object_id) source_object_id,
		     decode(p_source_object_type_code, FND_API.G_MISS_CHAR, source_object_type_code, p_source_object_type_code) source_object_type_code,
		     decode(p_application_id, FND_API.G_MISS_NUM, application_id, p_application_id) application_id
	       into  m_title,
		     m_party_id,
		     m_due_date,
		     m_owner_id,
		     m_owner_type,
		     m_assignee_id,
		     m_assignee_type,
		     m_source_object_id,
		     m_source_object_type_code,
		     m_application_id
	       from ieu_uwqm_items
	       where workitem_obj_code = p_workitem_obj_code
		 and workitem_pk_id = p_workitem_pk_id;

Line: 4692


            FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 4709


	      select title,
		     party_id,
		     due_date,
		     owner_id,
		     owner_type_actual,
		     assignee_id,
		     assignee_type_actual,
		     source_object_id,
		     source_object_type_code,
		     application_id
	       into  m_title,
		     m_party_id,
		     m_due_date,
		     m_owner_id,
		     m_owner_type,
		     m_assignee_id,
		     m_assignee_type,
		     m_source_object_id,
		     m_source_object_type_code,
		     m_application_id
	       from ieu_uwqm_items
	       where workitem_obj_code = p_workitem_obj_code
		 and workitem_pk_id = p_workitem_pk_id;

Line: 4738


            FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 4797


		select decode(p_priority_code, FND_API.G_MISS_CHAR, b.priority_code, p_priority_code) priority_code
		into m_priority_code
		from ieu_uwqm_items a, ieu_uwqm_priorities_b b
		where a.priority_id = b.priority_id
		  and a.priority_level = b.priority_level
		  and a.workitem_obj_code = p_workitem_obj_code
		  and a.workitem_pk_id = p_workitem_pk_id;

Line: 4810


            FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 4825


	       select decode(p_work_item_status, FND_API.G_MISS_CHAR, decode(status_id, 0, 'OPEN', 3, 'CLOSE', 4, 'DELETE', 5, 'SLEEP'), p_work_item_status) status_id
	       into m_work_item_status
	       from ieu_uwqm_items
	       where workitem_obj_code = p_workitem_obj_code
		 and workitem_pk_id = p_workitem_pk_id;

Line: 4835


            FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 4862


          SELECT 1
          INTO   l_workitem_obj_code
          FROM   jtf_objects_b
          WHERE  object_code = p_workitem_obj_code;

Line: 4883


            FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 4905


             SELECT priority_id, priority_level
             INTO   l_priority_id, l_priority_level
             FROM   ieu_uwqm_priorities_b
             WHERE  priority_code = m_priority_code;

Line: 4922


            FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 4939


         (m_work_item_status = 'DELETE') OR
            (m_work_item_status = 'SLEEP')
      THEN
            l_work_item_status_valid_flag := 'T';

Line: 4970


            FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 5019


	  FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 5079


         ELSIF (m_work_item_status = 'DELETE')
         THEN
             l_work_item_status_id := 4;

Line: 5095


       Select ws_id, ws_code
       into   l_ws_id1, l_ws_code1
       from   ieu_uwqm_work_sources_b
       where  object_code = p_workitem_obj_code
--       and    nvl(not_valid_flag,'N') = 'N';

Line: 5126


         Select ws_id, ws_code
         into   l_ws_id2, l_ws_code2
         from   ieu_uwqm_work_sources_b
         where  object_code = m_source_object_type_code
--         and    nvl(not_valid_flag,'N') = 'N';

Line: 5147


                   SELECT a.ws_id, b.ws_code
                   INTO   l_association_ws_id, l_assct_ws_code
                   FROM   ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
                   WHERE  child_ws_id = l_ws_id1
                   AND    parent_ws_id = l_ws_id2
                   AND    a.ws_id = b.ws_id
--                   AND    nvl(b.not_valid_flag,'N') = 'N';

Line: 5176


           SELECT ws_a_props.dist_st_based_on_parent_flag
           INTO   l_dist_st_based_on_parent
           FROM   ieu_uwqm_work_sources_b ws_b, IEU_UWQM_WS_ASSCT_PROPS ws_a_props
           WHERE  ws_b.ws_id = l_association_ws_id
           AND    ws_b.ws_id = ws_a_props.ws_id
--           AND    nvl(ws_b.not_valid_flag, 'N') = 'N';

Line: 5211


           SELECT distribute_from, distribute_to
           INTO   l_dist_from, l_dist_to
           FROM   ieu_uwqm_work_sources_b
           WHERE  ws_id = l_ws_id1;

Line: 5242


              SELECT distribution_status_id, status_id
              INTO   l_parent_dist_status, l_parent_status_id
              FROM   ieu_uwqm_items
              WHERE  workitem_pk_id = m_source_object_id
              AND    workitem_obj_code = m_source_object_type_code;

Line: 5368


		SELECT owner_id, owner_type, assignee_id, assignee_type, status_id,
		       priority_id, due_date, reschedule_time, distribution_status_id, source_object_id, source_object_type_code
		INTO   l_prev_owner_id, l_prev_owner_type, l_prev_assignee_id, l_prev_assignee_type, l_prev_status_id,
		       l_prev_priority_id, l_prev_due_date, l_prev_reschedule_time, l_prev_distribution_status_id,
		       l_prev_source_object_id, l_prev_source_object_type_code
		FROM IEU_UWQM_ITEMS
		WHERE  workitem_obj_code = p_workitem_obj_code
		AND    workitem_pk_id = p_workitem_pk_id;

Line: 5392


			   SELECT distribute_from, distribute_to
			   INTO   l_log_dist_from, l_log_dist_to
			   FROM   ieu_uwqm_work_sources_b
			   WHERE  ws_id = l_curr_ws_id;

Line: 5463


      IEU_WR_ITEMS_PKG.UPDATE_ROW
       ( p_workitem_obj_code,
         p_workitem_pk_id,
         m_title,
         m_party_id,
         l_priority_id,
         l_priority_level,
         m_due_date,
         m_owner_id,
         l_owner_type,
         m_assignee_id,
         l_assignee_type,
         l_owner_type_actual,
         l_assignee_type_actual,
         m_source_object_id,
         m_source_object_type_code,
         m_application_id,
         l_work_item_status_id,
         p_user_id,
         p_login_id,
         l_curr_ws_id,
         l_distribution_status_id,
         l_msg_data,
         x_return_status
        );

Line: 5523


       l_action_key := 'WORKITEM_UPDATE';

Line: 5563


			 l_event_key := 'UPDATE_WR_ITEM';

Line: 5580


              l_event_key := 'UPDATE_WR_ITEM';

Line: 5587


        ( (l_audit_log_val = 'MINIMAL') AND ( (l_action_key is NULL) OR (l_action_key = 'WORKITEM_UPDATE')) )
     then

	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_curr_ws_code,
		P_APPLICATION_ID => p_application_id,
		P_WORKITEM_PK_ID => p_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => p_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_prev_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_work_item_status_id,
		P_OWNER_ID_PREV	 => l_prev_owner_id,
		P_OWNER_ID_CURR	=> m_owner_id,
		P_OWNER_TYPE_PREV => l_prev_owner_type,
		P_OWNER_TYPE_CURR => l_owner_type,
		P_ASSIGNEE_ID_PREV => l_prev_assignee_id,
		P_ASSIGNEE_ID_CURR => m_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_prev_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_prev_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => m_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_prev_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => m_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => l_parent_status_id,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => l_parent_dist_status,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => l_prev_distribution_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_distribution_status_id,
		P_PRIORITY_PREV => l_prev_priority_id,
		P_PRIORITY_CURR	=> l_priority_id,
		P_DUE_DATE_PREV	=> l_prev_due_date,
		P_DUE_DATE_CURR	=> m_due_date,
		P_RESCHEDULE_TIME_PREV => l_prev_reschedule_time,
		P_RESCHEDULE_TIME_CURR => l_prev_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => l_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status);

Line: 5654


                          select a.ws_id
                          into   l_ws_id
                          from   ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
                          where  (parent_ws_id =  l_curr_ws_id)
                          and   a.ws_id = b.ws_id
--                          and   nvl(b.not_valid_flag, 'N') = 'N';

Line: 5698


					 l_action_key := 'WORKITEM_UPDATE';

Line: 5707


										'IEU_WR_PUB.UPDATE_WR_ITEM',
										null,
										null,
										null,
										null,
										null);

Line: 5734


                                               FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_WR_ITEM_FAILED');

Line: 5735


                                               FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 5763


         FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_WR_ITEM_FAILED');

Line: 5764


         FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 5787


  ROLLBACK TO update_wr_items_sp;

Line: 5796


	       l_action_key := 'WORKITEM_UPDATE';

Line: 5804


	       l_event_key := 'UPDATE_WR_ITEM';

Line: 5807


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_curr_ws_code,
		P_APPLICATION_ID => p_application_id,
		P_WORKITEM_PK_ID => p_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => p_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_prev_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_work_item_status_id,
		P_OWNER_ID_PREV	 => l_prev_owner_id,
		P_OWNER_ID_CURR	=> m_owner_id,
		P_OWNER_TYPE_PREV => l_prev_owner_type,
		P_OWNER_TYPE_CURR => l_owner_type,
		P_ASSIGNEE_ID_PREV => l_prev_assignee_id,
		P_ASSIGNEE_ID_CURR => m_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_prev_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_prev_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => m_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_prev_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => m_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => l_parent_status_id,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => l_parent_dist_status,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => l_prev_distribution_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_distribution_status_id,
		P_PRIORITY_PREV => l_prev_priority_id,
		P_PRIORITY_CURR	=> l_priority_id,
		P_DUE_DATE_PREV	=> l_prev_due_date,
		P_DUE_DATE_CURR	=> m_due_date,
		P_RESCHEDULE_TIME_PREV => l_prev_reschedule_time,
		P_RESCHEDULE_TIME_CURR => l_prev_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => x_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status);

Line: 5869


  ROLLBACK TO update_wr_items_sp;

Line: 5878


	       l_action_key := 'WORKITEM_UPDATE';

Line: 5886


	       l_event_key := 'UPDATE_WR_ITEM';

Line: 5889


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_curr_ws_code,
		P_APPLICATION_ID => p_application_id,
		P_WORKITEM_PK_ID => p_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => p_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_prev_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_work_item_status_id,
		P_OWNER_ID_PREV	 => l_prev_owner_id,
		P_OWNER_ID_CURR	=> m_owner_id,
		P_OWNER_TYPE_PREV => l_prev_owner_type,
		P_OWNER_TYPE_CURR => l_owner_type,
		P_ASSIGNEE_ID_PREV => l_prev_assignee_id,
		P_ASSIGNEE_ID_CURR => m_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_prev_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_prev_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => m_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_prev_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => m_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => l_parent_status_id,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => l_parent_dist_status,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => l_prev_distribution_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_distribution_status_id,
		P_PRIORITY_PREV => l_prev_priority_id,
		P_PRIORITY_CURR	=> l_priority_id,
		P_DUE_DATE_PREV	=> l_prev_due_date,
		P_DUE_DATE_CURR	=> m_due_date,
		P_RESCHEDULE_TIME_PREV => l_prev_reschedule_time,
		P_RESCHEDULE_TIME_CURR => l_prev_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => x_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status);

Line: 5952


  ROLLBACK TO update_wr_items_sp;

Line: 5961


	       l_action_key := 'WORKITEM_UPDATE';

Line: 5969


	       l_event_key := 'UPDATE_WR_ITEM';

Line: 5972


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_curr_ws_code,
		P_APPLICATION_ID => p_application_id,
		P_WORKITEM_PK_ID => p_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => p_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_prev_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_work_item_status_id,
		P_OWNER_ID_PREV	 => l_prev_owner_id,
		P_OWNER_ID_CURR	=> m_owner_id,
		P_OWNER_TYPE_PREV => l_prev_owner_type,
		P_OWNER_TYPE_CURR => l_owner_type,
		P_ASSIGNEE_ID_PREV => l_prev_assignee_id,
		P_ASSIGNEE_ID_CURR => m_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_prev_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_prev_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => m_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_prev_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => m_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => l_parent_status_id,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => l_parent_dist_status,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => l_prev_distribution_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_distribution_status_id,
		P_PRIORITY_PREV => l_prev_priority_id,
		P_PRIORITY_CURR	=> l_priority_id,
		P_DUE_DATE_PREV	=> l_prev_due_date,
		P_DUE_DATE_CURR	=> m_due_date,
		P_RESCHEDULE_TIME_PREV => l_prev_reschedule_time,
		P_RESCHEDULE_TIME_CURR => l_prev_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => x_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status);

Line: 6037


END UPDATE_WR_ITEM;

Line: 6066


  l_old_status_update_user_id NUMBER;

Line: 6067


  l_new_status_update_user_id NUMBER;

Line: 6208


          SELECT work_item_id
          INTO   l_work_item_id
          FROM   ieu_uwqm_items
          WHERE  workitem_obj_code = p_workitem_obj_code
          AND    workitem_pk_id    = p_workitem_pk_id;

Line: 6249


          SELECT object_code, object_function
          INTO   l_workitem_obj_code, l_object_function
          FROM   jtf_objects_b
          WHERE  object_code = p_workitem_obj_code;

Line: 6297


		SELECT ws_id, owner_id, owner_type, assignee_id, assignee_type, status_id,
		       priority_id, due_date, reschedule_time, distribution_status_id, source_object_id, source_object_type_code, workitem_pk_id, workitem_obj_code
		INTO   l_ws_id, l_prev_owner_id, l_prev_owner_type, l_prev_assignee_id, l_prev_assignee_type, l_prev_status_id,
		       l_prev_priority_id, l_prev_due_date, l_prev_reschedule_time, l_prev_distribution_status_id,
		       l_prev_source_object_id, l_prev_source_object_type_code, l_workitem_pk_id, l_obj_code
		FROM IEU_UWQM_ITEMS
		WHERE  WORK_ITEM_ID = P_WORK_ITEM_ID;

Line: 6312


		SELECT ws_id, owner_id, owner_type, assignee_id, assignee_type, status_id,
		       priority_id, due_date, reschedule_time, distribution_status_id, source_object_id, source_object_type_code
		INTO   l_ws_id, l_prev_owner_id, l_prev_owner_type, l_prev_assignee_id, l_prev_assignee_type, l_prev_status_id,
		       l_prev_priority_id, l_prev_due_date, l_prev_reschedule_time, l_prev_distribution_status_id,
		       l_prev_source_object_id, l_prev_source_object_type_code
		FROM IEU_UWQM_ITEMS
		WHERE  workitem_obj_code = p_workitem_obj_code
		AND    workitem_pk_id = p_workitem_pk_id;

Line: 6331


            UPDATE IEU_UWQM_ITEMS
            SET    reschedule_time = P_reschedule_time
            WHERE  WORK_ITEM_ID = P_WORK_ITEM_ID;

Line: 6337


            UPDATE IEU_UWQM_ITEMS
            SET    reschedule_time = P_reschedule_time
            WHERE  WORKITEM_PK_ID = P_WORKITEM_PK_ID
            AND    WORKITEM_OBJ_CODE = P_WORKITEM_OBJ_CODE;

Line: 6365


		select ws_code
		into   l_ws_code
		from   ieu_uwqm_work_sources_b
		where  ws_id = l_ws_id;

Line: 6375


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_ws_code,
		P_APPLICATION_ID => 696,
--		P_WORKITEM_PK_ID => p_workitem_pk_id,
--		P_WORKITEM_OBJ_CODE => p_workitem_obj_code,
		P_WORKITEM_PK_ID => l_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => l_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_prev_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_prev_status_id,
		P_OWNER_ID_PREV	 => l_prev_owner_id,
		P_OWNER_ID_CURR	=> l_prev_owner_id,
		P_OWNER_TYPE_PREV => l_prev_owner_type,
		P_OWNER_TYPE_CURR => l_prev_owner_type,
		P_ASSIGNEE_ID_PREV => l_prev_assignee_id,
		P_ASSIGNEE_ID_CURR => l_prev_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_prev_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_prev_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_prev_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => l_prev_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_prev_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => l_prev_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => l_parent_status_id,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => l_parent_dist_status,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => l_prev_distribution_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_prev_distribution_status_id,
		P_PRIORITY_PREV => l_prev_priority_id,
		P_PRIORITY_CURR	=> l_prev_priority_id,
		P_DUE_DATE_PREV	=> l_prev_due_date,
		P_DUE_DATE_CURR	=> l_prev_due_date,
		P_RESCHEDULE_TIME_PREV => l_prev_reschedule_time,
		P_RESCHEDULE_TIME_CURR => P_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => fnd_api.g_ret_sts_success,
		P_ERROR_CODE => l_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status);

Line: 6475


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_curr_ws_code,
		P_APPLICATION_ID => 696,
--		P_WORKITEM_PK_ID => p_workitem_pk_id,
--		P_WORKITEM_OBJ_CODE => p_workitem_obj_code,
		P_WORKITEM_PK_ID => l_workitem_pk_id,
         	P_WORKITEM_OBJ_CODE => l_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_prev_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_prev_status_id,
		P_OWNER_ID_PREV	 => l_prev_owner_id,
		P_OWNER_ID_CURR	=> l_prev_owner_id,
		P_OWNER_TYPE_PREV => l_prev_owner_type,
		P_OWNER_TYPE_CURR => l_prev_owner_type,
		P_ASSIGNEE_ID_PREV => l_prev_assignee_id,
		P_ASSIGNEE_ID_CURR => l_prev_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_prev_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_prev_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_prev_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => l_prev_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_prev_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => l_prev_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => l_parent_status_id,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => l_parent_dist_status,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => l_distribution_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_distribution_status_id,
		P_PRIORITY_PREV => l_prev_priority_id,
		P_PRIORITY_CURR	=> l_prev_priority_id,
		P_DUE_DATE_PREV	=> l_prev_due_date,
		P_DUE_DATE_CURR	=> l_prev_due_date,
		P_RESCHEDULE_TIME_PREV => l_prev_reschedule_time,
		P_RESCHEDULE_TIME_CURR => P_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => x_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status); commit;

Line: 6554


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_curr_ws_code,
		P_APPLICATION_ID => 696,
--		P_WORKITEM_PK_ID => p_workitem_pk_id,
--		P_WORKITEM_OBJ_CODE => p_workitem_obj_code,
		P_WORKITEM_PK_ID => l_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => l_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_prev_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_prev_status_id,
		P_OWNER_ID_PREV	 => l_prev_owner_id,
		P_OWNER_ID_CURR	=> l_prev_owner_id,
		P_OWNER_TYPE_PREV => l_prev_owner_type,
		P_OWNER_TYPE_CURR => l_prev_owner_type,
		P_ASSIGNEE_ID_PREV => l_prev_assignee_id,
		P_ASSIGNEE_ID_CURR => l_prev_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_prev_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_prev_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_prev_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => l_prev_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_prev_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => l_prev_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => l_parent_status_id,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => l_parent_dist_status,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => l_distribution_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_distribution_status_id,
		P_PRIORITY_PREV => l_prev_priority_id,
		P_PRIORITY_CURR	=> l_prev_priority_id,
		P_DUE_DATE_PREV	=> l_prev_due_date,
		P_DUE_DATE_CURR	=> l_prev_due_date,
		P_RESCHEDULE_TIME_PREV => l_prev_reschedule_time,
		P_RESCHEDULE_TIME_CURR => P_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => x_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status); commit;

Line: 6633


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_curr_ws_code,
		P_APPLICATION_ID => 696,
--		P_WORKITEM_PK_ID => p_workitem_pk_id,
--		P_WORKITEM_OBJ_CODE => p_workitem_obj_code,
		P_WORKITEM_PK_ID => l_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => l_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_prev_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_prev_status_id,
		P_OWNER_ID_PREV	 => l_prev_owner_id,
		P_OWNER_ID_CURR	=> l_prev_owner_id,
		P_OWNER_TYPE_PREV => l_prev_owner_type,
		P_OWNER_TYPE_CURR => l_prev_owner_type,
		P_ASSIGNEE_ID_PREV => l_prev_assignee_id,
		P_ASSIGNEE_ID_CURR => l_prev_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_prev_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_prev_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_prev_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => l_prev_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_prev_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => l_prev_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => l_parent_status_id,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => l_parent_dist_status,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => l_distribution_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_distribution_status_id,
		P_PRIORITY_PREV => l_prev_priority_id,
		P_PRIORITY_CURR	=> l_prev_priority_id,
		P_DUE_DATE_PREV	=> l_prev_due_date,
		P_DUE_DATE_CURR	=> l_prev_due_date,
		P_RESCHEDULE_TIME_PREV => l_prev_reschedule_time,
		P_RESCHEDULE_TIME_CURR => P_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => x_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status); commit;

Line: 6755


  l_date_selected   varchar2(1);

Line: 6772


     select work_item_id, owner_type, assignee_type
     from   ieu_uwqm_items
     where  workitem_obj_code = p_obj_code;

Line: 6778


     select work_item_id, workitem_pk_id, workitem_obj_code, owner_id, owner_type, assignee_id, assignee_type, source_object_id, source_object_type_code,
            status_id, priority_id, due_date
     from   ieu_uwqm_items
     where  workitem_obj_code = p_child_obj_code
     and    source_object_type_code = p_parent_obj_code;

Line: 6785


   select tb.task_id, tb.task_number, tb.customer_id, tb.owner_id, tb.owner_type_code,
  tb.source_object_id, tb.source_object_type_code,
--  decode(tb.date_selected, 'P', tb.planned_end_date,
--         'A', tb.actual_end_date, 'S', tb.scheduled_end_date, null, tb.scheduled_end_date) due_date,
  tb.planned_start_date, tb.planned_end_date, tb.actual_start_date, tb.actual_end_date,
  tb.scheduled_start_date, tb.scheduled_end_date,tb.task_type_id,
  tb.task_status_id, tt.task_name, tp.importance_level, ip.priority_code, tb.task_priority_id
  from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip
  where tb.entity = 'TASK' and nvl(tb.deleted_flag, 'N') = 'N' and tb.task_id = tt.task_id
  and tt.language = userenv('LANG') and tp.task_priority_id = nvl(tb.task_priority_id, 4)
  and least(tp.importance_level, 4) = ip.priority_level
  and tb.open_flag = 'Y'
  and tb.source_object_type_code = p_source_object_type_code;

Line: 6840


   SELECT TASK_ID,
          DECODE(DELETED_FLAG, 'Y', 4, 3) "STATUS_ID"
   FROM JTF_TASKS_B
   WHERE SOURCE_OBJECT_TYPE_CODE = p_source_object_type_code
   AND ((OPEN_FLAG = 'N' AND DELETED_FLAG = 'N') OR (DELETED_FLAG = 'Y'))
   AND ENTITY = 'TASK';

Line: 6903


       Select ws_id, ws_type, object_code
       into   l_ws_id, l_ws_type, l_obj_code
       from   ieu_uwqm_work_sources_b
       where  ws_code = p_ws_code
--       and nvl(not_valid_flag, 'N') = 'N';

Line: 6952


           SELECT parent_ws_id, child_ws_id, dist_st_based_on_parent_flag , tasks_rules_function
           INTO   l_parent_ws_id, l_child_ws_id, l_dist_st_based_on_parent , l_tasks_rules_func
           FROM   IEU_UWQM_WS_ASSCT_PROPS
           WHERE  ws_id = l_ws_id;

Line: 6978


           SELECT object_code
           INTO   l_parent_obj_code
           FROM   IEU_UWQM_WORK_SOURCES_B
           WHERE  ws_id = l_parent_ws_id
--           and nvl(not_valid_flag, 'N') = 'N';

Line: 7006


           SELECT object_code
           INTO   l_child_obj_code
           FROM   IEU_UWQM_WORK_SOURCES_B
           WHERE  ws_id = l_child_ws_id
--           and nvl(not_valid_flag, 'N') = 'N';

Line: 7103


           update ieu_uwqm_items
           set    ws_id = l_ws_id,
                  distribution_status_id = l_distribution_status_id
           where work_item_id = cur_rec.work_item_id;

Line: 7174


                select 'SLEEP' into l_task_status
                from jtf_task_statuses_vl
                where (nvl(on_hold_flag,'N') = 'Y')
                and task_status_id = l_task_status_id;

Line: 7184


	        select booking_end_date
		into   l_due_date
		from   jtf_task_all_assignments
		where  task_id = l_task_id
		and    assignee_role = 'OWNER';

Line: 7204


                 select count(*) into l_uwqm_count
                 from ieu_uwqm_items
--                 where workitem_obj_code = 'TASK'
                 where workitem_obj_code = l_workitem_obj_code_1
                 and workitem_pk_id = l_task_id;

Line: 7216


                 l_task_data_var := 'UPDATE_TASK';

Line: 7237


                                                     l_date_selected,
                                                     l_planned_start_date,
                                                     l_planned_end_date,
                                                     l_scheduled_start_date,
                                                     l_scheduled_end_date,
                                                     l_actual_start_date,
                                                     l_actual_end_date,
                                                     null,
                                                     null,
                                                     null);

Line: 7269


			SELECT priority_id
			into   l_priority_id
			from   ieu_uwqm_priorities_b
			where  priority_code = l_priority_code;

Line: 7279


		     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
		     (
			P_ACTION_KEY => l_action_key,
			P_EVENT_KEY =>	l_event_key,
			P_MODULE => l_module,
			P_WS_CODE => p_ws_code,
			P_APPLICATION_ID => 696,
			P_WORKITEM_PK_ID => l_task_id,
			P_WORKITEM_OBJ_CODE => 'TASK',
			P_WORK_ITEM_STATUS_PREV => null,
			P_WORK_ITEM_STATUS_CURR	=> l_task_status_id,
			P_OWNER_ID_PREV	 => null,
			P_OWNER_ID_CURR	=> l_owner_id,
			P_OWNER_TYPE_PREV => null,
			P_OWNER_TYPE_CURR => l_owner_type_code,
			P_ASSIGNEE_ID_PREV => null,
			P_ASSIGNEE_ID_CURR => null,
			P_ASSIGNEE_TYPE_PREV => null,
			P_ASSIGNEE_TYPE_CURR => null,
			P_SOURCE_OBJECT_ID_PREV => null,
			P_SOURCE_OBJECT_ID_CURR => l_source_object_id,
			P_SOURCE_OBJECT_TYPE_CODE_PREV => null,
			P_SOURCE_OBJECT_TYPE_CODE_CURR => l_source_object_type_code,
			P_PARENT_WORKITEM_STATUS_PREV => null,
			P_PARENT_WORKITEM_STATUS_CURR => null,
			P_PARENT_DIST_STATUS_PREV => null,
			P_PARENT_DIST_STATUS_CURR => null,
			P_WORKITEM_DIST_STATUS_PREV => null,
			P_WORKITEM_DIST_STATUS_CURR => null,
			P_PRIORITY_PREV => null,
			P_PRIORITY_CURR	=> l_priority_id,
			P_DUE_DATE_PREV	=> null,
			P_DUE_DATE_CURR	=> l_due_date,
			P_RESCHEDULE_TIME_PREV => sysdate,
			P_RESCHEDULE_TIME_CURR => sysdate,
			P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
			P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
			P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
			P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
			P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
			P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
			P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
			P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
			P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
			P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
			P_STATUS => l_return_status,
			P_ERROR_CODE => l_msg_data ,
			X_AUDIT_LOG_ID => l_audit_log_id,
			X_MSG_DATA => l_msg_data,
			X_RETURN_STATUS => l_return_status);

Line: 7343


                 SELECT distribution_status_id, status_id
                 INTO   l_parent_dist_status, l_parent_status_id
                 FROM   ieu_uwqm_items
                 WHERE  workitem_pk_id = cur_rec.source_object_id
                 AND    workitem_obj_code = cur_rec.source_object_type_code;

Line: 7459


              update ieu_uwqm_items
              set    ws_id = l_ws_id,
                  distribution_status_id = l_distribution_status_id
              where work_item_id = cur_rec.work_item_id;

Line: 7469


		     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
		     (
			P_ACTION_KEY => l_action_key,
			P_EVENT_KEY =>	l_event_key,
			P_MODULE => l_module,
			P_WS_CODE => p_ws_code,
			P_APPLICATION_ID => 696,
			P_WORKITEM_PK_ID => cur_rec.workitem_pk_id,
			P_WORKITEM_OBJ_CODE => cur_rec.workitem_obj_code,
			P_WORK_ITEM_STATUS_PREV => null,
			P_WORK_ITEM_STATUS_CURR	=> cur_rec.status_id,
			P_OWNER_ID_PREV	 => null,
			P_OWNER_ID_CURR	=> cur_rec.owner_id,
			P_OWNER_TYPE_PREV => null,
			P_OWNER_TYPE_CURR => cur_rec.owner_type,
			P_ASSIGNEE_ID_PREV => null,
			P_ASSIGNEE_ID_CURR => cur_rec.assignee_id,
			P_ASSIGNEE_TYPE_PREV => null,
			P_ASSIGNEE_TYPE_CURR => cur_rec.assignee_type,
			P_SOURCE_OBJECT_ID_PREV => null,
			P_SOURCE_OBJECT_ID_CURR => cur_rec.source_object_id,
			P_SOURCE_OBJECT_TYPE_CODE_PREV => null,
			P_SOURCE_OBJECT_TYPE_CODE_CURR => cur_rec.source_object_type_code,
			P_PARENT_WORKITEM_STATUS_PREV => null,
			P_PARENT_WORKITEM_STATUS_CURR => null,
			P_PARENT_DIST_STATUS_PREV => null,
			P_PARENT_DIST_STATUS_CURR => null,
			P_WORKITEM_DIST_STATUS_PREV => null,
			P_WORKITEM_DIST_STATUS_CURR => null,
			P_PRIORITY_PREV => null,
			P_PRIORITY_CURR	=> cur_rec.priority_id,
			P_DUE_DATE_PREV	=> null,
			P_DUE_DATE_CURR	=> cur_rec.due_date,
			P_RESCHEDULE_TIME_PREV => null,
			P_RESCHEDULE_TIME_CURR => sysdate,
			P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
			P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
			P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
			P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
			P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
			P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
			P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
			P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
			P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
			P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
			P_STATUS => l_return_status,
			P_ERROR_CODE => l_msg_data ,
			X_AUDIT_LOG_ID => l_audit_log_id,
			X_MSG_DATA => l_msg_data,
			X_RETURN_STATUS => l_return_status);

Line: 7539


	--	fnd_file.put_line(FND_FILE.LOG,'Begin update');

Line: 7541


			update IEU_UWQM_ITEMS
			set	status_id = l_task_status_rec.l_status_id_list(i),
         			LAST_UPDATED_BY        = FND_GLOBAL.USER_ID,
	        		LAST_UPDATE_DATE       = SYSDATE,
		        	LAST_UPDATE_LOGIN      = FND_GLOBAL.LOGIN_ID
			where   workitem_obj_code = 'TASK'
                        and     workitem_pk_id = l_task_status_rec.l_task_id_list(i)
                        and     source_object_type_code = l_parent_obj_code;

Line: 7556


                       FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');

Line: 7572


             l_task_status_rec.l_task_id_list.DELETE;

Line: 7573


             l_task_status_rec.l_status_id_list.DELETE;

Line: 7603


     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
     (
	P_ACTION_KEY => l_action_key,
	P_EVENT_KEY =>	l_event_key,
	P_MODULE => l_module,
	P_WS_CODE => p_ws_code,
	P_APPLICATION_ID => 696,
	P_WORKITEM_PK_ID => null,
	P_WORKITEM_OBJ_CODE => null,
	P_WORK_ITEM_STATUS_PREV => null,
	P_WORK_ITEM_STATUS_CURR	=> null,
	P_OWNER_ID_PREV	 => null,
	P_OWNER_ID_CURR	=> null,
	P_OWNER_TYPE_PREV => null,
	P_OWNER_TYPE_CURR => null,
	P_ASSIGNEE_ID_PREV => null,
	P_ASSIGNEE_ID_CURR => null,
	P_ASSIGNEE_TYPE_PREV => null,
	P_ASSIGNEE_TYPE_CURR => null,
	P_SOURCE_OBJECT_ID_PREV => null,
	P_SOURCE_OBJECT_ID_CURR => null,
	P_SOURCE_OBJECT_TYPE_CODE_PREV => null,
	P_SOURCE_OBJECT_TYPE_CODE_CURR => null,
	P_PARENT_WORKITEM_STATUS_PREV => null,
	P_PARENT_WORKITEM_STATUS_CURR => null,
	P_PARENT_DIST_STATUS_PREV => null,
	P_PARENT_DIST_STATUS_CURR => null,
	P_WORKITEM_DIST_STATUS_PREV => null,
	P_WORKITEM_DIST_STATUS_CURR => null,
	P_PRIORITY_PREV => null,
	P_PRIORITY_CURR	=> null,
	P_DUE_DATE_PREV	=> null,
	P_DUE_DATE_CURR	=> null,
	P_RESCHEDULE_TIME_PREV => null,
	P_RESCHEDULE_TIME_CURR => null,
	P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
	P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
	P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
	P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
	P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
	P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
	P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
	P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
	P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
	P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
	P_STATUS => x_return_status,
	P_ERROR_CODE => x_msg_data ,
	X_AUDIT_LOG_ID => l_audit_log_id,
	X_MSG_DATA => l_msg_data,
	X_RETURN_STATUS => l_return_status); commit;

Line: 7674


     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
     (
	P_ACTION_KEY => l_action_key,
	P_EVENT_KEY =>	l_event_key,
	P_MODULE => l_module,
	P_WS_CODE => p_ws_code,
	P_APPLICATION_ID => 696,
	P_WORKITEM_PK_ID => null,
	P_WORKITEM_OBJ_CODE => null,
	P_WORK_ITEM_STATUS_PREV => null,
	P_WORK_ITEM_STATUS_CURR	=> null,
	P_OWNER_ID_PREV	 => null,
	P_OWNER_ID_CURR	=> null,
	P_OWNER_TYPE_PREV => null,
	P_OWNER_TYPE_CURR => null,
	P_ASSIGNEE_ID_PREV => null,
	P_ASSIGNEE_ID_CURR => null,
	P_ASSIGNEE_TYPE_PREV => null,
	P_ASSIGNEE_TYPE_CURR => null,
	P_SOURCE_OBJECT_ID_PREV => null,
	P_SOURCE_OBJECT_ID_CURR => null,
	P_SOURCE_OBJECT_TYPE_CODE_PREV => null,
	P_SOURCE_OBJECT_TYPE_CODE_CURR => null,
	P_PARENT_WORKITEM_STATUS_PREV => null,
	P_PARENT_WORKITEM_STATUS_CURR => null,
	P_PARENT_DIST_STATUS_PREV => null,
	P_PARENT_DIST_STATUS_CURR => null,
	P_WORKITEM_DIST_STATUS_PREV => null,
	P_WORKITEM_DIST_STATUS_CURR => null,
	P_PRIORITY_PREV => null,
	P_PRIORITY_CURR	=> null,
	P_DUE_DATE_PREV	=> null,
	P_DUE_DATE_CURR	=> null,
	P_RESCHEDULE_TIME_PREV => null,
	P_RESCHEDULE_TIME_CURR => null,
	P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
	P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
	P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
	P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
	P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
	P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
	P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
	P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
	P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
	P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
	P_STATUS => x_return_status,
	P_ERROR_CODE => x_msg_data ,
	X_AUDIT_LOG_ID => l_audit_log_id,
	X_MSG_DATA => l_msg_data,
	X_RETURN_STATUS => l_return_status); commit;

Line: 7746


     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
     (
	P_ACTION_KEY => l_action_key,
	P_EVENT_KEY =>	l_event_key,
	P_MODULE => l_module,
	P_WS_CODE => p_ws_code,
	P_APPLICATION_ID => 696,
	P_WORKITEM_PK_ID => null,
	P_WORKITEM_OBJ_CODE => null,
	P_WORK_ITEM_STATUS_PREV => null,
	P_WORK_ITEM_STATUS_CURR	=> null,
	P_OWNER_ID_PREV	 => null,
	P_OWNER_ID_CURR	=> null,
	P_OWNER_TYPE_PREV => null,
	P_OWNER_TYPE_CURR => null,
	P_ASSIGNEE_ID_PREV => null,
	P_ASSIGNEE_ID_CURR => null,
	P_ASSIGNEE_TYPE_PREV => null,
	P_ASSIGNEE_TYPE_CURR => null,
	P_SOURCE_OBJECT_ID_PREV => null,
	P_SOURCE_OBJECT_ID_CURR => null,
	P_SOURCE_OBJECT_TYPE_CODE_PREV => null,
	P_SOURCE_OBJECT_TYPE_CODE_CURR => null,
	P_PARENT_WORKITEM_STATUS_PREV => null,
	P_PARENT_WORKITEM_STATUS_CURR => null,
	P_PARENT_DIST_STATUS_PREV => null,
	P_PARENT_DIST_STATUS_CURR => null,
	P_WORKITEM_DIST_STATUS_PREV => null,
	P_WORKITEM_DIST_STATUS_CURR => null,
	P_PRIORITY_PREV => null,
	P_PRIORITY_CURR	=> null,
	P_DUE_DATE_PREV	=> null,
	P_DUE_DATE_CURR	=> null,
	P_RESCHEDULE_TIME_PREV => null,
	P_RESCHEDULE_TIME_CURR => null,
	P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
	P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
	P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
	P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
	P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
	P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
	P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
	P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
	P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
	P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
	P_STATUS => x_return_status,
	P_ERROR_CODE => x_msg_data ,
	X_AUDIT_LOG_ID => l_audit_log_id,
	X_MSG_DATA => l_msg_data,
	X_RETURN_STATUS => l_return_status); commit;

Line: 7930


       Select ws_id, ws_type, object_code
       into   l_ws_id, l_ws_type, l_obj_code
       from   ieu_uwqm_work_sources_b
       where  ws_code = p_ws_det_list(i).ws_code
--       and nvl(not_valid_flag, 'N') = 'N';

Line: 8048


    SELECT distribution_status_id, reschedule_time, due_date
    INTO   l_dist_status_id, l_reschedule_time, l_due_date
    FROM   ieu_uwqm_items
    WHERE  workitem_pk_id = l_workitem_pk_id
    AND    workitem_obj_code = l_workitem_obj_code;

Line: 8095


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => null,
		P_APPLICATION_ID => 696,
		P_WORKITEM_PK_ID => l_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => l_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_workitem_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_workitem_status_id,
		P_OWNER_ID_PREV	 => l_owner_id,
		P_OWNER_ID_CURR	=> l_owner_id,
		P_OWNER_TYPE_PREV => l_owner_type,
		P_OWNER_TYPE_CURR => l_owner_type,
		P_ASSIGNEE_ID_PREV => l_assignee_id,
		P_ASSIGNEE_ID_CURR => l_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => l_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => l_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => null,
		P_PARENT_WORKITEM_STATUS_CURR => null,
		P_PARENT_DIST_STATUS_PREV => null,
		P_PARENT_DIST_STATUS_CURR => null,
		P_WORKITEM_DIST_STATUS_PREV => l_dist_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_dist_status_id,
		P_PRIORITY_PREV => l_priority_id,
		P_PRIORITY_CURR	=> l_priority_id,
		P_DUE_DATE_PREV	=> l_due_date,
		P_DUE_DATE_CURR	=> l_due_date,
		P_RESCHEDULE_TIME_PREV => l_reschedule_time,
		P_RESCHEDULE_TIME_CURR => l_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => l_message,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status);

Line: 8172


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => null,
		P_APPLICATION_ID => 696,
		P_WORKITEM_PK_ID => l_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => l_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_workitem_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_workitem_status_id,
		P_OWNER_ID_PREV	 => l_owner_id,
		P_OWNER_ID_CURR	=> l_owner_id,
		P_OWNER_TYPE_PREV => l_owner_type,
		P_OWNER_TYPE_CURR => l_owner_type,
		P_ASSIGNEE_ID_PREV => l_assignee_id,
		P_ASSIGNEE_ID_CURR => l_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => l_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => l_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => null,
		P_PARENT_WORKITEM_STATUS_CURR => null,
		P_PARENT_DIST_STATUS_PREV => null,
		P_PARENT_DIST_STATUS_CURR => null,
		P_WORKITEM_DIST_STATUS_PREV => l_dist_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_dist_status_id,
		P_PRIORITY_PREV => l_priority_id,
		P_PRIORITY_CURR	=> l_priority_id,
		P_DUE_DATE_PREV	=> l_due_date,
		P_DUE_DATE_CURR	=> l_due_date,
		P_RESCHEDULE_TIME_PREV => l_reschedule_time,
		P_RESCHEDULE_TIME_CURR => l_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => l_message ,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status); commit;

Line: 8246


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => null,
		P_APPLICATION_ID => 696,
		P_WORKITEM_PK_ID => l_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => l_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_workitem_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_workitem_status_id,
		P_OWNER_ID_PREV	 => l_owner_id,
		P_OWNER_ID_CURR	=> l_owner_id,
		P_OWNER_TYPE_PREV => l_owner_type,
		P_OWNER_TYPE_CURR => l_owner_type,
		P_ASSIGNEE_ID_PREV => l_assignee_id,
		P_ASSIGNEE_ID_CURR => l_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => l_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => l_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => null,
		P_PARENT_WORKITEM_STATUS_CURR => null,
		P_PARENT_DIST_STATUS_PREV => null,
		P_PARENT_DIST_STATUS_CURR => null,
		P_WORKITEM_DIST_STATUS_PREV => l_dist_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_dist_status_id,
		P_PRIORITY_PREV => l_priority_id,
		P_PRIORITY_CURR	=> l_priority_id,
		P_DUE_DATE_PREV	=> l_due_date,
		P_DUE_DATE_CURR	=> l_due_date,
		P_RESCHEDULE_TIME_PREV => l_reschedule_time,
		P_RESCHEDULE_TIME_CURR => l_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => l_message ,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status); commit;

Line: 8322


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => null,
		P_APPLICATION_ID => 696,
		P_WORKITEM_PK_ID => l_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => l_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_workitem_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_workitem_status_id,
		P_OWNER_ID_PREV	 => l_owner_id,
		P_OWNER_ID_CURR	=> l_owner_id,
		P_OWNER_TYPE_PREV => l_owner_type,
		P_OWNER_TYPE_CURR => l_owner_type,
		P_ASSIGNEE_ID_PREV => l_assignee_id,
		P_ASSIGNEE_ID_CURR => l_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => l_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => l_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => null,
		P_PARENT_WORKITEM_STATUS_CURR => null,
		P_PARENT_DIST_STATUS_PREV => null,
		P_PARENT_DIST_STATUS_CURR => null,
		P_WORKITEM_DIST_STATUS_PREV => l_dist_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_dist_status_id,
		P_PRIORITY_PREV => l_priority_id,
		P_PRIORITY_CURR	=> l_priority_id,
		P_DUE_DATE_PREV	=> l_due_date,
		P_DUE_DATE_CURR	=> l_due_date,
		P_RESCHEDULE_TIME_PREV => l_reschedule_time,
		P_RESCHEDULE_TIME_CURR => l_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => l_message ,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status);commit;

Line: 8512


	select ws_id, owner_id, owner_type, assignee_id, assignee_type, status_id,
	       priority_id, due_date, reschedule_time, distribution_status_id,  source_object_id, source_object_type_code
	into   l_ws_id, l_owner_id, l_owner_type, l_assignee_id, l_assignee_type, l_prev_status_id,
	       l_priority_id, l_due_date, l_reschedule_time, l_prev_distribution_status_id,  l_source_object_id, l_source_object_type_code
        from   ieu_uwqm_items
        where  workitem_pk_id = p_wr_item_list(i).workitem_pk_id
        and    workitem_obj_code = p_wr_item_list(i).workitem_obj_code;

Line: 8527


         FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');

Line: 8528


         FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

Line: 8546


       Select ws_code, ws_type, distribute_from, distribute_to
       into   l_ws_code, l_ws_type, l_log_dist_from, l_log_dist_to
       from   ieu_uwqm_work_sources_b
       where  ws_id = l_ws_id
--       and    nvl(not_valid_flag, 'N') = 'N';

Line: 8576


           SELECT parent_ws_id, child_ws_id, dist_st_based_on_parent_flag
           INTO   l_parent_ws_id, l_child_ws_id, l_dist_st_based_on_parent
           FROM   IEU_UWQM_WS_ASSCT_PROPS
           WHERE  ws_id = l_ws_id;

Line: 8609


              SELECT distribution_status_id, status_id
              INTO   l_parent_dist_status, l_parent_status_id
              FROM   ieu_uwqm_items
              WHERE  workitem_pk_id = l_source_object_id
              AND    workitem_obj_code = l_source_object_type_code;

Line: 8727


      update ieu_uwqm_items
      set distribution_status_id = l_distribution_status_id
      where workitem_pk_id = p_wr_item_list(i).workitem_pk_id
      and   workitem_obj_code = p_wr_item_list(i).workitem_obj_code;

Line: 8837


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_ws_code,
		P_APPLICATION_ID => 696,
		P_WORKITEM_PK_ID => p_wr_item_list(i).workitem_pk_id,
		P_WORKITEM_OBJ_CODE => p_wr_item_list(i).workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_prev_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_prev_status_id,
		P_OWNER_ID_PREV	 => l_owner_id,
		P_OWNER_ID_CURR	=> l_owner_id,
		P_OWNER_TYPE_PREV => l_owner_type,
		P_OWNER_TYPE_CURR => l_owner_type,
		P_ASSIGNEE_ID_PREV => l_assignee_id,
		P_ASSIGNEE_ID_CURR => l_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => l_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => l_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => p_wr_item_list(i).prev_parent_workitem_status_id,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => p_wr_item_list(i).prev_parent_dist_status_id,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => l_prev_distribution_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_distribution_status_id,
		P_PRIORITY_PREV => l_priority_id,
		P_PRIORITY_CURR	=> l_priority_id,
		P_DUE_DATE_PREV	=> l_due_date,
		P_DUE_DATE_CURR	=> l_due_date,
		P_RESCHEDULE_TIME_PREV => l_reschedule_time,
		P_RESCHEDULE_TIME_CURR => l_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => 'S',
		P_ERROR_CODE => l_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status);

Line: 8932


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_ws_code,
		P_APPLICATION_ID => 696,
		P_WORKITEM_PK_ID => l_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => l_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_prev_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_status_id,
		P_OWNER_ID_PREV	 => l_owner_id,
		P_OWNER_ID_CURR	=> l_owner_id,
		P_OWNER_TYPE_PREV => l_owner_type,
		P_OWNER_TYPE_CURR => l_owner_type,
		P_ASSIGNEE_ID_PREV => l_assignee_id,
		P_ASSIGNEE_ID_CURR => l_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => l_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => l_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => l_parent_status_id,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => l_parent_dist_status,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => l_prev_distribution_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_distribution_status_id,
		P_PRIORITY_PREV => l_priority_id,
		P_PRIORITY_CURR	=> l_priority_id,
		P_DUE_DATE_PREV	=> l_due_date,
		P_DUE_DATE_CURR	=> l_due_date,
		P_RESCHEDULE_TIME_PREV => l_reschedule_time,
		P_RESCHEDULE_TIME_CURR => l_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => 'E',
		P_ERROR_CODE => l_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status);

Line: 9024


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_ws_code,
		P_APPLICATION_ID => 696,
		P_WORKITEM_PK_ID => l_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => l_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_prev_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_status_id,
		P_OWNER_ID_PREV	 => l_owner_id,
		P_OWNER_ID_CURR	=> l_owner_id,
		P_OWNER_TYPE_PREV => l_owner_type,
		P_OWNER_TYPE_CURR => l_owner_type,
		P_ASSIGNEE_ID_PREV => l_assignee_id,
		P_ASSIGNEE_ID_CURR => l_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => l_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => l_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => l_parent_status_id,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => l_parent_dist_status,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => l_prev_distribution_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_distribution_status_id,
		P_PRIORITY_PREV => l_priority_id,
		P_PRIORITY_CURR	=> l_priority_id,
		P_DUE_DATE_PREV	=> l_due_date,
		P_DUE_DATE_CURR	=> l_due_date,
		P_RESCHEDULE_TIME_PREV => l_reschedule_time,
		P_RESCHEDULE_TIME_CURR => l_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => fnd_api.g_ret_sts_unexp_error,
		P_ERROR_CODE => l_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status);

Line: 9117


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_ws_code,
		P_APPLICATION_ID => 696,
		P_WORKITEM_PK_ID => l_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => l_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_prev_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_status_id,
		P_OWNER_ID_PREV	 => l_owner_id,
		P_OWNER_ID_CURR	=> l_owner_id,
		P_OWNER_TYPE_PREV => l_owner_type,
		P_OWNER_TYPE_CURR => l_owner_type,
		P_ASSIGNEE_ID_PREV => l_assignee_id,
		P_ASSIGNEE_ID_CURR => l_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => l_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => l_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => l_parent_status_id,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => l_parent_dist_status,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => l_prev_distribution_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_distribution_status_id,
		P_PRIORITY_PREV => l_priority_id,
		P_PRIORITY_CURR	=> l_priority_id,
		P_DUE_DATE_PREV	=> l_due_date,
		P_DUE_DATE_CURR	=> l_due_date,
		P_RESCHEDULE_TIME_PREV => l_reschedule_time,
		P_RESCHEDULE_TIME_CURR => l_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => fnd_api.g_ret_sts_unexp_error,
		P_ERROR_CODE => l_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data,
		X_RETURN_STATUS => l_return_status);

Line: 9254


         select ws_code
         into l_ws_code
         from ieu_uwqm_work_sources_b
         where ws_code = p_ws_code
--         and nvl(not_valid_flag, 'N') = 'N';

Line: 9284


          update ieu_uwqm_work_sources_b
          set active_flag = l_active_flag
          where ws_code = p_ws_code;

Line: 9412


         select ws_code, nvl(active_flag,'N')
         into l_ws_code, l_ws_activation_status
         from ieu_uwqm_work_sources_b
         where ws_code = p_ws_code
--         and nvl(not_valid_flag, 'N') = 'N';

Line: 9556


          SELECT 1
          INTO   l_workitem_obj_code
          FROM   jtf_objects_b
          WHERE  object_code = p_object_type;

Line: 9597


       DELETE /*+ INDEX(IEU_UWQM_ITEMS IEU_UWQM_ITEMS_U2) */
	  from IEU_UWQM_ITEMS
       WHERE WORKITEM_OBJ_CODE = p_object_type
         and WORKITEM_PK_ID in
             (
              SELECT t.object_id
              FROM   JTF_OBJECT_PURGE_PARAM_TMP t
              WHERE t.object_type = p_object_type
		    AND   t.processing_set_id = p_processing_set_id
	         AND   nvl(t.purge_status,'S') <> 'E'
             );

Line: 9838


          SELECT 1
          INTO   l_workitem_obj_code
          FROM   jtf_objects_b
          WHERE  object_code = p_workitem_obj_code;

Line: 9878


		SELECT owner_id, owner_type, assignee_id, assignee_type, status_id,
		       priority_id, due_date, reschedule_time, distribution_status_id, source_object_id, source_object_type_code
		INTO   l_prev_owner_id, l_prev_owner_type, l_prev_assignee_id, l_prev_assignee_type, l_prev_status_id,
		       l_prev_priority_id, l_prev_due_date, l_prev_reschedule_time, l_prev_distribution_status_id,
		       l_prev_source_object_id, l_prev_source_object_type_code
		FROM IEU_UWQM_ITEMS
		WHERE  workitem_obj_code = p_workitem_obj_code
		AND    workitem_pk_id = p_workitem_pk_id;

Line: 9893


      IEU_WR_ITEMS_PKG.DELETE_ROW
       ( p_workitem_obj_code,
         p_workitem_pk_id,
         l_msg_data,
         x_return_status
        );

Line: 9967


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_curr_ws_code,
		P_APPLICATION_ID => p_application_id,
		P_WORKITEM_PK_ID => p_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => p_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_prev_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_prev_status_id,
		P_OWNER_ID_PREV	 => l_prev_owner_id,
		P_OWNER_ID_CURR	=> l_prev_owner_id,
		P_OWNER_TYPE_PREV => l_prev_owner_type,
		P_OWNER_TYPE_CURR => l_prev_owner_type,
		P_ASSIGNEE_ID_PREV => l_prev_assignee_id,
		P_ASSIGNEE_ID_CURR => l_prev_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_prev_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_prev_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_prev_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => l_prev_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_prev_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => l_prev_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => l_parent_status_id,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => l_parent_dist_status,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => l_prev_distribution_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_prev_distribution_status_id,
		P_PRIORITY_PREV => l_prev_priority_id,
		P_PRIORITY_CURR	=> l_prev_priority_id,
		P_DUE_DATE_PREV	=> l_prev_due_date,
		P_DUE_DATE_CURR	=> l_prev_due_date,
		P_RESCHEDULE_TIME_PREV => l_prev_reschedule_time,
		P_RESCHEDULE_TIME_CURR => l_prev_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => l_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data2,
		X_RETURN_STATUS => l_return_status);

Line: 10058


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_curr_ws_code,
		P_APPLICATION_ID => p_application_id,
		P_WORKITEM_PK_ID => p_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => p_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_prev_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_prev_status_id,
		P_OWNER_ID_PREV	 => l_prev_owner_id,
		P_OWNER_ID_CURR	=> l_prev_owner_id,
		P_OWNER_TYPE_PREV => l_prev_owner_type,
		P_OWNER_TYPE_CURR => l_prev_owner_type,
		P_ASSIGNEE_ID_PREV => l_prev_assignee_id,
		P_ASSIGNEE_ID_CURR => l_prev_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_prev_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_prev_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_prev_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => l_prev_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_prev_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => l_prev_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => l_parent_status_id,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => l_parent_dist_status,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => l_prev_distribution_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_prev_distribution_status_id,
		P_PRIORITY_PREV => l_prev_priority_id,
		P_PRIORITY_CURR	=> l_prev_priority_id,
		P_DUE_DATE_PREV	=> l_prev_due_date,
		P_DUE_DATE_CURR	=> l_prev_due_date,
		P_RESCHEDULE_TIME_PREV => l_prev_reschedule_time,
		P_RESCHEDULE_TIME_CURR => l_prev_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => l_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data2,
		X_RETURN_STATUS => l_return_status);

Line: 10126


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_curr_ws_code,
		P_APPLICATION_ID => p_application_id,
		P_WORKITEM_PK_ID => p_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => p_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_prev_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_prev_status_id,
		P_OWNER_ID_PREV	 => l_prev_owner_id,
		P_OWNER_ID_CURR	=> l_prev_owner_id,
		P_OWNER_TYPE_PREV => l_prev_owner_type,
		P_OWNER_TYPE_CURR => l_prev_owner_type,
		P_ASSIGNEE_ID_PREV => l_prev_assignee_id,
		P_ASSIGNEE_ID_CURR => l_prev_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_prev_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_prev_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_prev_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => l_prev_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_prev_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => l_prev_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => l_parent_status_id,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => l_parent_dist_status,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => l_prev_distribution_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_prev_distribution_status_id,
		P_PRIORITY_PREV => l_prev_priority_id,
		P_PRIORITY_CURR	=> l_prev_priority_id,
		P_DUE_DATE_PREV	=> l_prev_due_date,
		P_DUE_DATE_CURR	=> l_prev_due_date,
		P_RESCHEDULE_TIME_PREV => l_prev_reschedule_time,
		P_RESCHEDULE_TIME_CURR => l_prev_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => l_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data2,
		X_RETURN_STATUS => l_return_status);

Line: 10194


	     IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
	     (
		P_ACTION_KEY => l_action_key,
		P_EVENT_KEY =>	l_event_key,
		P_MODULE => l_module,
		P_WS_CODE => l_curr_ws_code,
		P_APPLICATION_ID => p_application_id,
		P_WORKITEM_PK_ID => p_workitem_pk_id,
		P_WORKITEM_OBJ_CODE => p_workitem_obj_code,
		P_WORK_ITEM_STATUS_PREV => l_prev_status_id,
		P_WORK_ITEM_STATUS_CURR	=> l_prev_status_id,
		P_OWNER_ID_PREV	 => l_prev_owner_id,
		P_OWNER_ID_CURR	=> l_prev_owner_id,
		P_OWNER_TYPE_PREV => l_prev_owner_type,
		P_OWNER_TYPE_CURR => l_prev_owner_type,
		P_ASSIGNEE_ID_PREV => l_prev_assignee_id,
		P_ASSIGNEE_ID_CURR => l_prev_assignee_id,
		P_ASSIGNEE_TYPE_PREV => l_prev_assignee_type,
		P_ASSIGNEE_TYPE_CURR => l_prev_assignee_type,
		P_SOURCE_OBJECT_ID_PREV => l_prev_source_object_id,
		P_SOURCE_OBJECT_ID_CURR => l_prev_source_object_id,
		P_SOURCE_OBJECT_TYPE_CODE_PREV => l_prev_source_object_type_code,
		P_SOURCE_OBJECT_TYPE_CODE_CURR => l_prev_source_object_type_code,
		P_PARENT_WORKITEM_STATUS_PREV => l_parent_status_id,
		P_PARENT_WORKITEM_STATUS_CURR => l_parent_status_id,
		P_PARENT_DIST_STATUS_PREV => l_parent_dist_status,
		P_PARENT_DIST_STATUS_CURR => l_parent_dist_status,
		P_WORKITEM_DIST_STATUS_PREV => l_prev_distribution_status_id,
		P_WORKITEM_DIST_STATUS_CURR => l_prev_distribution_status_id,
		P_PRIORITY_PREV => l_prev_priority_id,
		P_PRIORITY_CURR	=> l_prev_priority_id,
		P_DUE_DATE_PREV	=> l_prev_due_date,
		P_DUE_DATE_CURR	=> l_prev_due_date,
		P_RESCHEDULE_TIME_PREV => l_prev_reschedule_time,
		P_RESCHEDULE_TIME_CURR => l_prev_reschedule_time,
		P_IEU_COMMENT_CODE1 => l_ieu_comment_code1,
		P_IEU_COMMENT_CODE2 => l_ieu_comment_code2,
		P_IEU_COMMENT_CODE3 => l_ieu_comment_code3,
		P_IEU_COMMENT_CODE4 => l_ieu_comment_code4,
		P_IEU_COMMENT_CODE5 => l_ieu_comment_code5,
		P_WORKITEM_COMMENT_CODE1 => l_workitem_comment_code1,
		P_WORKITEM_COMMENT_CODE2 => l_workitem_comment_code2,
		P_WORKITEM_COMMENT_CODE3 => l_workitem_comment_code3,
		P_WORKITEM_COMMENT_CODE4 => l_workitem_comment_code4,
		P_WORKITEM_COMMENT_CODE5 => l_workitem_comment_code5,
		P_STATUS => x_return_status,
		P_ERROR_CODE => l_msg_data,
		X_AUDIT_LOG_ID => l_audit_log_id,
		X_MSG_DATA => l_msg_data2,
		X_RETURN_STATUS => l_return_status);

Line: 10310


  select ws_code
  from  ieu_uwqm_work_sources_b b, ieu_uwqm_ws_assct_props p
  where b.ws_id = p.ws_id
  and   p.parent_ws_id = l_ws_id;

Line: 10370


         select ws_code, ws_id
         into l_ws_code, l_ws_id
         from ieu_uwqm_work_sources_b
         where ws_code = p_ws_code
--         and nvl(not_valid_flag, 'N') = 'N';

Line: 10401


          update ieu_uwqm_work_sources_b
          set active_flag = l_active_flag
          where ws_code = p_ws_code;

Line: 10407


	    update ieu_uwqm_work_sources_b
	    set active_flag = l_active_flag
	    where ws_code = cur_rec.ws_code;

Line: 10607


      WORKITEM_PK_ID_LIST.delete;

Line: 10608


      WORKITEM_OBJ_CODE_LIST.delete;

Line: 10610


      SELECT Count(*)
      INTO   l_count
      FROM  IEU_UWQM_ITEMS_GTT
      WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID
      AND  WORKITEM_STATUS NOT IN ('OPEN', 'CLOSE', 'DELETE', 'SLEEP');

Line: 10619


         SELECT   WORKITEM_PK_ID
                , WORKITEM_OBJ_CODE
         BULK COLLECT INTO
                  WORKITEM_PK_ID_LIST
                , WORKITEM_OBJ_CODE_LIST
         FROM  IEU_UWQM_ITEMS_GTT
         WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID
         AND  WORKITEM_STATUS NOT IN ('OPEN', 'CLOSE', 'DELETE', 'SLEEP')
         AND ROWNUM <= 5;

Line: 10657


      WORKITEM_PK_ID_LIST.delete;

Line: 10658


      WORKITEM_OBJ_CODE_LIST.delete;

Line: 10660


      SELECT count(*)
      INTO   l_count
      FROM   IEU_UWQM_ITEMS_GTT A
      WHERE  A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
      AND NOT EXISTS
         ( SELECT 1
           FROM JTF_OBJECTS_B
           WHERE OBJECT_CODE = A.WORKITEM_OBJ_CODE );

Line: 10671


         SELECT   WORKITEM_PK_ID
                , WORKITEM_OBJ_CODE
         BULK COLLECT INTO
                  WORKITEM_PK_ID_LIST
                , WORKITEM_OBJ_CODE_LIST
         FROM   IEU_UWQM_ITEMS_GTT A
         WHERE  A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
         AND    ROWNUM <= 5
         AND NOT EXISTS
            ( SELECT 1
              FROM JTF_OBJECTS_B
              WHERE OBJECT_CODE = A.WORKITEM_OBJ_CODE );

Line: 10711


      WORKITEM_PK_ID_LIST.delete;

Line: 10712


      WORKITEM_OBJ_CODE_LIST.delete;

Line: 10714


      SELECT count(*)
      INTO   l_count
      FROM   IEU_UWQM_ITEMS_GTT A
      WHERE  A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
      AND NOT EXISTS
         ( SELECT 1
           FROM IEU_UWQM_PRIORITIES_B B
           WHERE B.PRIORITY_CODE = A.PRIORITY_CODE );

Line: 10726


         SELECT   WORKITEM_PK_ID
                , WORKITEM_OBJ_CODE
         BULK COLLECT INTO
                  WORKITEM_PK_ID_LIST
                , WORKITEM_OBJ_CODE_LIST
         FROM   IEU_UWQM_ITEMS_GTT A
         WHERE  A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
         AND    ROWNUM <= 5
         AND NOT EXISTS
            ( SELECT 1
              FROM IEU_UWQM_PRIORITIES_B B
              WHERE B.PRIORITY_CODE = A.PRIORITY_CODE );

Line: 10771


      WORKITEM_PK_ID_LIST.delete;

Line: 10772


      WORKITEM_OBJ_CODE_LIST.delete;

Line: 10774


      SELECT count(*)
      INTO   l_count
      FROM   IEU_UWQM_ITEMS_GTT A
      WHERE  A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
      AND NOT EXISTS
         ( SELECT 1
           FROM IEU_UWQM_WORK_SOURCES_B
           WHERE OBJECT_CODE = A.WORKITEM_OBJ_CODE
           AND NVL(NOT_VALID_FLAG, 'N') = L_NOT_VALID_FLAG );

Line: 10787


         SELECT   WORKITEM_PK_ID
                , WORKITEM_OBJ_CODE
         BULK COLLECT INTO
                  WORKITEM_PK_ID_LIST
                , WORKITEM_OBJ_CODE_LIST
         FROM   IEU_UWQM_ITEMS_GTT A
         WHERE  A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
         AND    ROWNUM <= 5
         AND NOT EXISTS
            ( SELECT 1
              FROM IEU_UWQM_WORK_SOURCES_B
              WHERE OBJECT_CODE = A.WORKITEM_OBJ_CODE
              AND NVL(NOT_VALID_FLAG, 'N') = L_NOT_VALID_FLAG );

Line: 10830


     UPDATE IEU_UWQM_ITEMS_GTT A
     SET A.WS_ID1 =
         (SELECT B.WS_ID
          FROM IEU_UWQM_WORK_SOURCES_B B
          WHERE  A.WORKITEM_OBJ_CODE =  B.OBJECT_CODE
          AND    NVL(B.NOT_VALID_FLAG, 'N') = L_NOT_VALID_FLAG)
       , A.WS_ID2 =
         (SELECT C.WS_ID
          FROM IEU_UWQM_WORK_SOURCES_B C
          WHERE A.SOURCE_OBJECT_TYPE_CODE = C.OBJECT_CODE
          AND   NVL(C.NOT_VALID_FLAG, 'N') = L_NOT_VALID_FLAG)
     WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID;

Line: 10846


     UPDATE IEU_UWQM_ITEMS_GTT A
     SET A.ASSOCIATION_WS_ID =
         (SELECT B.WS_ID
          FROM   IEU_UWQM_WS_ASSCT_PROPS B
               , IEU_UWQM_WORK_SOURCES_B C
          WHERE B.CHILD_WS_ID = A.WS_ID1
          AND   B.PARENT_WS_ID = A.WS_ID2
          AND   B.WS_ID = C.WS_ID
          AND   NVL(C.NOT_VALID_FLAG, 'N') = L_NOT_VALID_FLAG)
     WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
     AND   A.WS_ID2 IS NOT NULL;

Line: 10864


       UPDATE IEU_UWQM_ITEMS_GTT A
       SET ( A.DIST_ST_BASED_ON_PARENT_FLAG
           , A.DIST_FROM
           , A.DIST_TO
           ) =
           (SELECT  C.DIST_ST_BASED_ON_PARENT_FLAG
                  , 'GROUP_OWNED'
                  , 'INDIVIDUAL_ASSIGNED'
           FROM   IEU_UWQM_WORK_SOURCES_B B
                , IEU_UWQM_WS_ASSCT_PROPS C
           WHERE A.ASSOCIATION_WS_ID = B.WS_ID
           AND   B.WS_ID = C.WS_ID
           AND   NVL(B.NOT_VALID_FLAG, 'N') = L_NOT_VALID_FLAG)
       WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
       AND   A.ASSOCIATION_WS_ID IS NOT NULL;

Line: 10910


      UPDATE IEU_UWQM_ITEMS_GTT A
      SET  A.OWNER_TYPE = CASE WHEN (A.OWNER_TYPE_ACTUAL <> 'RS_GROUP' AND A.OWNER_TYPE_ACTUAL <> 'RS_TEAM') THEN 'RS_INDIVIDUAL'
                         ELSE A.OWNER_TYPE_ACTUAL
                         END
          , A.ASSIGNEE_TYPE = CASE WHEN (A.ASSIGNEE_TYPE_ACTUAL <> 'RS_GROUP' AND A.ASSIGNEE_TYPE_ACTUAL <> 'RS_TEAM') THEN 'RS_INDIVIDUAL'
                            ELSE A.ASSIGNEE_TYPE_ACTUAL
                            END
          , A.STATUS_ID = DECODE(A.WORKITEM_STATUS, 'OPEN', 0, 'CLOSE', 3, 'DELETE', 4, 'SLEEP', 5, A.STATUS_ID)
          , ( A.PRIORITY_ID
            , A.PRIORITY_LEVEL
            ) =
            (SELECT  B.PRIORITY_ID
                   , B.PRIORITY_LEVEL
             FROM IEU_UWQM_PRIORITIES_B B
             WHERE A.PRIORITY_CODE =  B.PRIORITY_CODE)
      WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID;

Line: 10928


     UPDATE IEU_UWQM_ITEMS_GTT A
     SET   A.DIST_FROM = 'GROUP_OWNED'
         , A.DIST_TO = 'INDIVIDUAL_ASSIGNED'
     WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
     AND   A.ASSOCIATION_WS_ID IS NULL;

Line: 10934


     UPDATE IEU_UWQM_ITEMS_GTT A
     SET A.WS_ID = NVL(A.ASSOCIATION_WS_ID, A.WS_ID1)
     WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID;

Line: 10941


     UPDATE IEU_UWQM_ITEMS_GTT A
     SET ( A.PARENT_STATUS_ID
         , A.PARENT_DIST_STATUS_ID
         ) =
           (SELECT   B.STATUS_ID
                   , B.DISTRIBUTION_STATUS_ID
            FROM IEU_UWQM_ITEMS B
            WHERE A.SOURCE_OBJECT_ID = B.WORKITEM_PK_ID
            AND   A.SOURCE_OBJECT_TYPE_CODE = B.WORKITEM_OBJ_CODE)
     WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
     AND   A.DIST_ST_BASED_ON_PARENT_FLAG = 'Y';

Line: 10957


     UPDATE IEU_UWQM_ITEMS_GTT
     SET   DIST_ID_FLAG =  CASE WHEN DIST_ST_BASED_ON_PARENT_FLAG = 'Y' THEN
                            CASE WHEN PARENT_STATUS_ID = 3 THEN 'T'
                            ELSE CASE WHEN PARENT_DIST_STATUS_ID <> 3 THEN 'F'
                                 ELSE 'T'
                                 END
                            END
                           ELSE 'T'
                           END
     WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID;

Line: 10968


     UPDATE IEU_UWQM_ITEMS_GTT
     SET DISTRIBUTION_STATUS_ID = CASE WHEN (DIST_ID_FLAG = 'T') THEN
                                   CASE WHEN (PARENT_DIST_STATUS_ID <> 3) THEN 0
                                   ELSE CASE WHEN (DIST_FROM = 'GROUP_OWNED') AND (DIST_TO = 'INDIVIDUAL_ASSIGNED') THEN
                                         CASE WHEN (OWNER_TYPE = 'RS_GROUP') AND ((ASSIGNEE_TYPE IS NULL)
                                                                         OR (ASSIGNEE_TYPE <> 'RS_INDIVIDUAL')) THEN 1
                                         ELSE CASE WHEN (ASSIGNEE_TYPE = 'RS_INDIVIDUAL') THEN 3
                                              ELSE 0
                                              END
                                         END
                                        ELSE 0
                                        END
                                   END
                                  ELSE 0
                                  END
     WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID;

Line: 10988


      l_wr_items_rec.WORKITEM_OBJ_CODE_LST.delete;

Line: 10989


      l_wr_items_rec.WORKITEM_PK_ID_LST.delete;

Line: 10990


      l_wr_items_rec.STATUS_ID_LIST.delete;

Line: 10991


      l_wr_items_rec.PRIORITY_ID_LIST.delete;

Line: 10992


      l_wr_items_rec.PRIORITY_LEVEL_LIST.delete;

Line: 10993


      l_wr_items_rec.DUE_DATE_LIST.delete;

Line: 10994


      l_wr_items_rec.TITLE_LIST.delete;

Line: 10995


      l_wr_items_rec.PARTY_ID_LIST.delete;

Line: 10996


      l_wr_items_rec.OWNER_TYPE_LIST.delete;

Line: 10997


      l_wr_items_rec.OWNER_ID_LIST.delete;

Line: 10998


      l_wr_items_rec.ASSIGNEE_TYPE_LIST.delete;

Line: 10999


      l_wr_items_rec.ASSIGNEE_ID_LIST.delete;

Line: 11000


      l_wr_items_rec.SOURCE_OBJECT_ID_LIST.delete;

Line: 11001


      l_wr_items_rec.SOURCE_OBJECT_TYPE_CODE_LIST.delete;

Line: 11002


      l_wr_items_rec.OWNER_TYPE_ACTUAL_LIST.delete;

Line: 11003


      l_wr_items_rec.ASSIGNEE_TYPE_ACTUAL_LIST.delete;

Line: 11004


      l_wr_items_rec.APPLICATION_ID_LIST.delete;

Line: 11005


      l_wr_items_rec.IEU_ENUM_TYPE_UUID_LIST.delete;

Line: 11006


      l_wr_items_rec.WORK_ITEM_NUMBER_LIST.delete;

Line: 11007


      l_wr_items_rec.WS_ID_LIST.delete;

Line: 11008


      l_wr_items_rec.DISTRIBUTION_STATUS_ID_LIST.delete;

Line: 11010


      SELECT  WORKITEM_OBJ_CODE
            , WORKITEM_PK_ID
            , STATUS_ID
            , PRIORITY_ID
            , PRIORITY_LEVEL
            , DUE_DATE
            , TITLE
            , PARTY_ID
            , OWNER_TYPE
            , OWNER_ID
            , ASSIGNEE_TYPE
            , ASSIGNEE_ID
            , SOURCE_OBJECT_ID
            , SOURCE_OBJECT_TYPE_CODE
            , OWNER_TYPE_ACTUAL
            , ASSIGNEE_TYPE_ACTUAL
            , APPLICATION_ID
            , IEU_ENUM_TYPE_UUID
            , WORK_ITEM_NUMBER
            , WS_ID
            , DISTRIBUTION_STATUS_ID
            , 1
      BULK COLLECT INTO l_wr_items_rec.WORKITEM_OBJ_CODE_LST
            , l_wr_items_rec.WORKITEM_PK_ID_LST
            , l_wr_items_rec.STATUS_ID_LIST
            , l_wr_items_rec.PRIORITY_ID_LIST
            , l_wr_items_rec.PRIORITY_LEVEL_LIST
            , l_wr_items_rec.DUE_DATE_LIST
            , l_wr_items_rec.TITLE_LIST
            , l_wr_items_rec.PARTY_ID_LIST
            , l_wr_items_rec.OWNER_TYPE_LIST
            , l_wr_items_rec.OWNER_ID_LIST
            , l_wr_items_rec.ASSIGNEE_TYPE_LIST
            , l_wr_items_rec.ASSIGNEE_ID_LIST
            , l_wr_items_rec.SOURCE_OBJECT_ID_LIST
            , l_wr_items_rec.SOURCE_OBJECT_TYPE_CODE_LIST
            , l_wr_items_rec.OWNER_TYPE_ACTUAL_LIST
            , l_wr_items_rec.ASSIGNEE_TYPE_ACTUAL_LIST
            , l_wr_items_rec.APPLICATION_ID_LIST
            , l_wr_items_rec.IEU_ENUM_TYPE_UUID_LIST
            , l_wr_items_rec.WORK_ITEM_NUMBER_LIST
            , l_wr_items_rec.WS_ID_LIST
            , l_wr_items_rec.DISTRIBUTION_STATUS_ID_LIST
            , l_wr_items_rec.l_ins_flag
      FROM IEU_UWQM_ITEMS_GTT
      WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID;

Line: 11059


        INSERT INTO IEU_UWQM_ITEMS
         ( WORK_ITEM_ID
         , OBJECT_VERSION_NUMBER
         , CREATED_BY
         , CREATION_DATE
         , LAST_UPDATED_BY
         , LAST_UPDATE_DATE
         , LAST_UPDATE_LOGIN
         , WORKITEM_OBJ_CODE
         , WORKITEM_PK_ID
         , WORK_ITEM_NUMBER
         , STATUS_ID
         , PRIORITY_ID
         , PRIORITY_LEVEL
         , DUE_DATE
         , TITLE
         , PARTY_ID
         , OWNER_ID
         , OWNER_TYPE
         , ASSIGNEE_ID
         , ASSIGNEE_TYPE
         , OWNER_TYPE_ACTUAL
         , ASSIGNEE_TYPE_ACTUAL
         , SOURCE_OBJECT_ID
         , SOURCE_OBJECT_TYPE_CODE
         , APPLICATION_ID
         , IEU_ENUM_TYPE_UUID
         , RESCHEDULE_TIME
         , STATUS_UPDATE_USER_ID
         , WS_ID
         , DISTRIBUTION_STATUS_ID
         ) VALUES
         ( IEU_UWQM_ITEMS_S1.NEXTVAL
         , 1
         , P_USER_ID
         , SYSDATE
         , P_USER_ID
         , SYSDATE
         , P_LOGIN_ID
         , l_wr_items_rec.WORKITEM_OBJ_CODE_LST(i)
         , l_wr_items_rec.WORKITEM_PK_ID_LST(i)
         , l_wr_items_rec.WORK_ITEM_NUMBER_LIST(i)
         , l_wr_items_rec.STATUS_ID_LIST(i)
         , l_wr_items_rec.PRIORITY_ID_LIST(i)
         , l_wr_items_rec.PRIORITY_LEVEL_LIST(i)
         , l_wr_items_rec.DUE_DATE_LIST(i)
         , l_wr_items_rec.TITLE_LIST(i)
         , l_wr_items_rec.PARTY_ID_LIST(i)
         , l_wr_items_rec.OWNER_ID_LIST(i)
         , l_wr_items_rec.OWNER_TYPE_LIST(i)
         , l_wr_items_rec.ASSIGNEE_ID_LIST(i)
         , l_wr_items_rec.ASSIGNEE_TYPE_LIST(i)
         , l_wr_items_rec.OWNER_TYPE_ACTUAL_LIST(i)
         , l_wr_items_rec.ASSIGNEE_TYPE_ACTUAL_LIST(i)
         , l_wr_items_rec.SOURCE_OBJECT_ID_LIST(i)
         , l_wr_items_rec.SOURCE_OBJECT_TYPE_CODE_LIST(i)
         , l_wr_items_rec.APPLICATION_ID_LIST(i)
         , l_wr_items_rec.IEU_ENUM_TYPE_UUID_LIST(i)
         , SYSDATE
         , P_USER_ID
         , l_wr_items_rec.WS_ID_LIST(i)
         , l_wr_items_rec.DISTRIBUTION_STATUS_ID_LIST(i)
         );

Line: 11133


         FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INSERT_FAILED');

Line: 11157


          UPDATE IEU_UWQM_ITEMS
          SET   OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
              , CREATED_BY = P_USER_ID
              , CREATION_DATE = SYSDATE
              , LAST_UPDATED_BY = P_USER_ID
              , LAST_UPDATE_DATE = SYSDATE
              , LAST_UPDATE_LOGIN = P_LOGIN_ID
              , STATUS_UPDATE_USER_ID = P_USER_ID
              , RESCHEDULE_TIME = SYSDATE
              , STATUS_ID = l_wr_items_rec.STATUS_ID_LIST(i)
              , PRIORITY_ID = l_wr_items_rec.PRIORITY_ID_LIST(i)
              , PRIORITY_LEVEL = l_wr_items_rec.PRIORITY_LEVEL_LIST(i)
              , DUE_DATE = l_wr_items_rec.DUE_DATE_LIST(i)
              , TITLE = l_wr_items_rec.TITLE_LIST(i)
              , PARTY_ID = l_wr_items_rec.PARTY_ID_LIST(i)
              , OWNER_TYPE = l_wr_items_rec.OWNER_TYPE_LIST(i)
              , OWNER_ID = l_wr_items_rec.OWNER_ID_LIST(i)
              , ASSIGNEE_TYPE = l_wr_items_rec.ASSIGNEE_TYPE_LIST(i)
              , ASSIGNEE_ID = l_wr_items_rec.ASSIGNEE_ID_LIST(i)
              , SOURCE_OBJECT_ID = l_wr_items_rec.SOURCE_OBJECT_ID_LIST(i)
              , SOURCE_OBJECT_TYPE_CODE = l_wr_items_rec.SOURCE_OBJECT_TYPE_CODE_LIST(i)
              , OWNER_TYPE_ACTUAL = l_wr_items_rec.OWNER_TYPE_ACTUAL_LIST(i)
              , ASSIGNEE_TYPE_ACTUAL = l_wr_items_rec.ASSIGNEE_TYPE_ACTUAL_LIST(i)
              , APPLICATION_ID = l_wr_items_rec.APPLICATION_ID_LIST(i)
              , IEU_ENUM_TYPE_UUID = l_wr_items_rec.IEU_ENUM_TYPE_UUID_LIST(i)
              , WORK_ITEM_NUMBER = l_wr_items_rec.WORK_ITEM_NUMBER_LIST(i)
              , WS_ID = l_wr_items_rec.WS_ID_LIST(i)
              , DISTRIBUTION_STATUS_ID = l_wr_items_rec.DISTRIBUTION_STATUS_ID_LIST(i)
          WHERE WORKITEM_OBJ_CODE = l_wr_items_rec.WORKITEM_OBJ_CODE_LST(i)
          AND WORKITEM_PK_ID = l_wr_items_rec.WORKITEM_PK_ID_LST(i)
  	    AND l_wr_items_rec.l_ins_flag(i) = 0;

Line: 11194


           FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');

Line: 11214


       l_wr_items_rec.WORKITEM_OBJ_CODE_LST.delete;

Line: 11215


       l_wr_items_rec.WORKITEM_PK_ID_LST.delete;

Line: 11216


       l_wr_items_rec.STATUS_ID_LIST.delete;

Line: 11217


       l_wr_items_rec.PRIORITY_ID_LIST.delete;

Line: 11218


       l_wr_items_rec.PRIORITY_LEVEL_LIST.delete;

Line: 11219


       l_wr_items_rec.DUE_DATE_LIST.delete;

Line: 11220


       l_wr_items_rec.TITLE_LIST.delete;

Line: 11221


       l_wr_items_rec.PARTY_ID_LIST.delete;

Line: 11222


       l_wr_items_rec.OWNER_TYPE_LIST.delete;

Line: 11223


       l_wr_items_rec.OWNER_ID_LIST.delete;

Line: 11224


       l_wr_items_rec.ASSIGNEE_TYPE_LIST.delete;

Line: 11225


       l_wr_items_rec.ASSIGNEE_ID_LIST.delete;

Line: 11226


       l_wr_items_rec.SOURCE_OBJECT_ID_LIST.delete;

Line: 11227


       l_wr_items_rec.SOURCE_OBJECT_TYPE_CODE_LIST.delete;

Line: 11228


       l_wr_items_rec.OWNER_TYPE_ACTUAL_LIST.delete;

Line: 11229


       l_wr_items_rec.ASSIGNEE_TYPE_ACTUAL_LIST.delete;

Line: 11230


       l_wr_items_rec.APPLICATION_ID_LIST.delete;

Line: 11231


       l_wr_items_rec.IEU_ENUM_TYPE_UUID_LIST.delete;

Line: 11232


       l_wr_items_rec.WORK_ITEM_NUMBER_LIST.delete;

Line: 11233


       l_wr_items_rec.WS_ID_LIST.delete;

Line: 11234


       l_wr_items_rec.DISTRIBUTION_STATUS_ID_LIST.delete;

Line: 11315


   select  /*+ ordered parallel(tb) parallel(tt) use_nl(tp,ip,sts_b) */
           tb.task_id
         , tb.task_priority_id
         , tp.importance_level
         , decode(tb.date_selected, 'P', tb.planned_end_date, 'A', tb.actual_end_date, 'S', tb.scheduled_end_date, null, tb.scheduled_end_date) due_date
         , substr(tt.task_name,1,1990) task_name
         , tb.customer_id
         , tb.owner_type_code
         , tb.owner_id
         , tb.source_object_id
         , tb.source_object_type_code
         , tb.task_number
         , tb.planned_start_date
         , tb.planned_end_date
         , tb.actual_start_date
         , tb.actual_end_date
         , tb.scheduled_start_date
         , tb.scheduled_end_date
         , tb.task_type_id
         , ip.priority_code
         , tb.date_selected
         , decode(nvl(sts_b.on_hold_flag, 'N'), 'Y', 'SLEEP', 'OPEN') workitem_status
         , tb.task_status_id
  from   jtf_tasks_b tb
       , jtf_tasks_tl tt
       , jtf_task_priorities_vl tp
       , ieu_uwqm_priorities_b ip
       , jtf_task_statuses_b sts_b
  where tb.entity = 'TASK'
  and nvl(tb.deleted_flag, 'N') = 'N'
  and tb.task_id = tt.task_id
  and tt.language = userenv('LANG')
  and tp.task_priority_id = nvl(tb.task_priority_id, 4)
  and least(tp.importance_level, 4) = ip.priority_level
  and tb.open_flag = 'Y'
  and tb.task_status_id = sts_b.task_status_id
  and tb.source_object_type_code = p_source_object_type_code;

Line: 11380


  , DATE_SELECTED_LIST           CHAR_TAB
  , WORKITEM_STATUS_LIST         CHAR_TAB
  , STATUS_ID                    NUMBER_TAB
  );

Line: 11397


   SELECT TASK_ID,
          DECODE(DELETED_FLAG, 'Y', 4, 3) "STATUS_ID"
   FROM JTF_TASKS_B
   WHERE SOURCE_OBJECT_TYPE_CODE = p_source_object_type_code
   AND ((OPEN_FLAG = 'N' AND DELETED_FLAG = 'N') OR (DELETED_FLAG = 'Y'))
   AND ENTITY = 'TASK';

Line: 11449


       Select ws_id, ws_type, object_code
       into   l_ws_id, l_ws_type, l_obj_code
       from   ieu_uwqm_work_sources_b
       where  ws_code = p_ws_code
       and nvl(not_valid_flag, 'N') = l_not_valid_flag;

Line: 11505


           SELECT parent_ws_id, child_ws_id, dist_st_based_on_parent_flag , tasks_rules_function
           INTO   l_parent_ws_id, l_child_ws_id, l_dist_st_based_on_parent , l_tasks_rules_func
           FROM   IEU_UWQM_WS_ASSCT_PROPS
           WHERE  ws_id = l_ws_id;

Line: 11535


           SELECT object_code, NVL(active_flag, 'N')
           INTO   l_parent_obj_code, l_active_flag
           FROM   IEU_UWQM_WORK_SOURCES_B
           WHERE  ws_id = l_parent_ws_id
           and nvl(not_valid_flag, 'N') = l_not_valid_flag;

Line: 11543


             SELECT ws_name
             INTO   l_ws_name
             FROM IEU_UWQM_WORK_SOURCES_TL
             WHERE ws_id = l_ws_id
             AND language = userenv('LANG');

Line: 11569


             SELECT ws_name
             INTO   l_parent_ws_name
             FROM IEU_UWQM_WORK_SOURCES_TL
             WHERE ws_id = l_parent_ws_id
             AND language = userenv('LANG');

Line: 11640


           SELECT object_code
           INTO   l_child_obj_code
           FROM   IEU_UWQM_WORK_SOURCES_B
           WHERE  ws_id = l_child_ws_id
           and nvl(not_valid_flag, 'N') = l_not_valid_flag;

Line: 11674


          select IEU_UWQM_ITEMS_GTT_S1.NEXTVAL into l_processing_set_id from dual;

Line: 11679


              delete from IEU_UWQM_ITEMS_GTT;

Line: 11680


              l_ws_details_rec.WORKITEM_PK_ID_LIST.delete;

Line: 11681


              l_ws_details_rec.TASK_PRIORITY_ID_LIST.delete;

Line: 11682


              l_ws_details_rec.IMPORTANCE_LEVEL_LIST.delete;

Line: 11683


              l_ws_details_rec.DUE_DATE_LIST.delete;

Line: 11684


              l_ws_details_rec.TITLE_LIST.delete;

Line: 11685


              l_ws_details_rec.PARTY_ID_LIST.delete;

Line: 11686


              l_ws_details_rec.OWNER_TYPE_LIST.delete;

Line: 11687


              l_ws_details_rec.OWNER_ID_LIST.delete;

Line: 11688


              l_ws_details_rec.SOURCE_OBJECT_ID_LIST.delete;

Line: 11689


              l_ws_details_rec.SOURCE_OBJECT_TYPE_CODE_LIST.delete;

Line: 11690


              l_ws_details_rec.WORK_ITEM_NUMBER_LIST.delete;

Line: 11691


              l_ws_details_rec.PLANNED_START_DATE_LIST.delete;

Line: 11692


              l_ws_details_rec.PLANNED_END_DATE_LIST.delete;

Line: 11693


              l_ws_details_rec.ACTUAL_START_DATE_LIST.delete;

Line: 11694


              l_ws_details_rec.ACTUAL_END_DATE_LIST.delete;

Line: 11695


              l_ws_details_rec.SCHEDULED_START_DATE_LIST.delete;

Line: 11696


              l_ws_details_rec.SCHEDULED_END_DATE_LIST.delete;

Line: 11697


              l_ws_details_rec.TASK_TYPE_ID_LIST.delete;

Line: 11698


              l_ws_details_rec.PRIORITY_CODE_LIST.delete;

Line: 11699


              l_ws_details_rec.DATE_SELECTED_LIST.delete;

Line: 11700


              l_ws_details_rec.WORKITEM_STATUS_LIST.delete;

Line: 11701


              l_ws_details_rec.STATUS_ID.delete;

Line: 11723


              , l_ws_details_rec.DATE_SELECTED_LIST
              , l_ws_details_rec.WORKITEM_STATUS_LIST
              , l_ws_details_rec.STATUS_ID
              LIMIT l_limit;

Line: 11733


                Insert into  ieu_uwqm_items_gtt
                ( PROCESSING_SET_ID
                , WORKITEM_OBJ_CODE
                , WORKITEM_PK_ID
                , STATUS_ID
                , DUE_DATE
                , TITLE
                , PARTY_ID
                , OWNER_ID
                , SOURCE_OBJECT_ID
                , SOURCE_OBJECT_TYPE_CODE
                , OWNER_TYPE_ACTUAL
                , APPLICATION_ID
                , IEU_ENUM_TYPE_UUID
                , WORK_ITEM_NUMBER
                , WORKITEM_STATUS
                , PRIORITY_CODE
                , PLANNED_START_DATE
                , PLANNED_END_DATE
                , ACTUAL_START_DATE
                , ACTUAL_END_DATE
                , SCHEDULED_START_DATE
                , SCHEDULED_END_DATE
                , DATE_SELECTED
                , TASK_TYPE_ID
                , TASK_PRIORITY_ID
                , UWQ_DEF_WORK_ITEM_STATUS
                , UWQ_DEF_PRIORITY_CODE
                , UWQ_DEF_DUE_DATE
                , UWQ_DEF_IEU_ENUM_TYPE_UUID
                )
                values
                ( l_processing_set_id
                , l_child_obj_code
                , l_ws_details_rec.WORKITEM_PK_ID_LIST(i)
                , l_ws_details_rec.STATUS_ID(i)
                , l_ws_details_rec.DUE_DATE_LIST(i)
                , l_ws_details_rec.TITLE_LIST(i)
                , l_ws_details_rec.PARTY_ID_LIST(i)
                , l_ws_details_rec.OWNER_ID_LIST(i)
                , l_ws_details_rec.SOURCE_OBJECT_ID_LIST(i)
                , l_ws_details_rec.SOURCE_OBJECT_TYPE_CODE_LIST(i)
                , l_ws_details_rec.OWNER_TYPE_LIST(i)
                , 696
                , 'TASKS'
                , l_ws_details_rec.WORK_ITEM_NUMBER_LIST(i)
                , l_ws_details_rec.WORKITEM_STATUS_LIST(i)
                , l_ws_details_rec.PRIORITY_CODE_LIST(i)
                , l_ws_details_rec.PLANNED_START_DATE_LIST(i)
                , l_ws_details_rec.PLANNED_END_DATE_LIST(i)
                , l_ws_details_rec.ACTUAL_START_DATE_LIST(i)
                , l_ws_details_rec.ACTUAL_END_DATE_LIST(i)
                , l_ws_details_rec.SCHEDULED_START_DATE_LIST(i)
                , l_ws_details_rec.SCHEDULED_END_DATE_LIST(i)
                , l_ws_details_rec.DATE_SELECTED_LIST(i)
                , l_ws_details_rec.TASK_TYPE_ID_LIST(i)
                , l_ws_details_rec.TASK_PRIORITY_ID_LIST(i)
                , l_ws_details_rec.WORKITEM_STATUS_LIST(i)
                , l_ws_details_rec.PRIORITY_CODE_LIST(i)
                , l_ws_details_rec.DUE_DATE_LIST(i)
                , 'TASKS'
                );

Line: 11820


                 FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INSERT_FAILED');

Line: 11844


		update ieu_uwqm_items_gtt gtt
		set due_date = (select booking_end_date
		from jtf_task_all_assignments asg
		where asg.task_id = gtt.workitem_pk_id
		and asg.assignee_role= 'OWNER');

Line: 11852


			 FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');

Line: 11905


	--	fnd_file.put_line(FND_FILE.LOG,'Begin update');

Line: 11907


			update IEU_UWQM_ITEMS
			set	status_id = l_task_status_rec.l_status_id_list(i),
         			LAST_UPDATED_BY        = FND_GLOBAL.USER_ID,
	        		LAST_UPDATE_DATE       = SYSDATE,
		        	LAST_UPDATE_LOGIN      = FND_GLOBAL.LOGIN_ID
			where   workitem_obj_code = 'TASK'
                        and     workitem_pk_id = l_task_status_rec.l_task_id_list(i)
                        and     source_object_type_code = l_parent_obj_code;

Line: 11940


                       FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');

Line: 11956


             l_task_status_rec.l_task_id_list.DELETE;

Line: 11957


             l_task_status_rec.l_status_id_list.DELETE;

Line: 12029


        SELECT resource_id, WORKITEM_PK_ID, resource_type_code
        from (SELECT GTT.WORKITEM_PK_ID, asg.resource_id, asg.resource_type_code,
                     max(asg.last_update_date) over (partition by asg.task_id) max_update_date, asg.last_update_date
                 FROM IEU_UWQM_ITEMS_GTT GTT, JTF_TASK_ASSIGNMENTS ASG
                 WHERE GTT.PROCESSING_SET_ID = P_PROCESSING_SET_ID
                 AND GTT.WORKITEM_PK_ID = ASG.TASK_ID
                 and GTT.OWNER_TYPE_ACTUAL = 'RS_GROUP'
                 and asg.resource_type_code not in ('RS_GROUP', 'RS_TEAM')
                 and asg.assignee_role = 'ASSIGNEE'
                 and exists
                 (SELECT /*+ index(a,JTF_RS_GROUP_MEMBERS_N1) */ null
                    FROM JTF_RS_GROUP_MEMBERS a
                   WHERE a.group_id= GTT.owner_id
                   and a.RESOURCE_ID = asg.resource_id
                   AND NVL(DELETE_FLAG,'N') <> 'Y' )
                 and exists
                 (select  1
                  from jtf_task_statuses_b sts
                  where sts.task_status_id = asg.assignment_status_id
                  and (nvl(sts.closed_flag, 'N') = 'N'
                  and nvl(sts.completed_flag, 'N') = 'N'
                  and nvl(sts.cancelled_flag, 'N') = 'N'
                  and nvl(sts.rejected_flag, 'N') = 'N'))) a
        where a.last_update_date = a.max_update_date;

Line: 12092


			update IEU_UWQM_ITEMS_GTT
			set	assignee_id = l_task_asg_rec.l_asg_id_list(i),
				assignee_type_actual = l_task_asg_rec.l_asg_type_act_list(i)
			where processing_set_id = p_processing_set_id
                  and   workitem_pk_id = l_task_asg_rec.l_asg_task_id_list(i);

Line: 12104


                       FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');

Line: 12122


	     l_task_asg_rec.l_asg_id_list.DELETE;

Line: 12123


	     l_task_asg_rec.l_asg_task_id_list.DELETE;

Line: 12124


	     l_task_asg_rec.l_asg_type_act_list.DELETE;

Line: 12193


                /* insert into p_temp(msg, ctr) values('srchStrCtr: '||l_search_str_ctr, l_ws_ctr); commit;

Line: 12194


		insert into p_temp(msg, ctr) values(' strt ctr: '||l_start_ctr, l_ws_ctr); commit;

Line: 12195


                insert into p_temp(msg, ctr) values ('tmp str: '||l_temp_str, l_ws_ctr); commit;  */

Line: 12218


		--insert into p_temp(msg, ctr) values('wsCode '||l_ws_code_str, l_ws_ctr); commit;

Line: 12219


		--insert into p_temp(msg, ctr) values(' temp Str: '||l_temp_str, l_ws_ctr); commit;

Line: 12229


	        --insert into p_temp(msg, ctr) values('strrt ctr: '||l_start_ctr||' srch ctr: '||l_search_ctr||' ws ctr: '||l_ws_ctr, l_ws_ctr); commit;

Line: 12236


	insert into p_temp(msg) values ('ws code in list: '||l_ws_det_list(i).ws_code); commit;

Line: 12258


		--insert into p_temp values('error in get work', 2); commit;

Line: 12430


       Select ws_id, ws_type, object_code
       into   l_ws_id, l_ws_type, l_obj_code
       from   ieu_uwqm_work_sources_b
       where  ws_code = p_ws_code
       and nvl(not_valid_flag, 'N') = l_not_valid_flag;

Line: 12467


       WORKITEM_PK_ID_LIST.delete;

Line: 12468


       WORKITEM_OBJ_CODE_LIST.delete;

Line: 12470


       SELECT count(*)
       INTO   l_count
       FROM   IEU_UWQM_ITEMS_GTT A
       WHERE  A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
       AND    A.WORKITEM_OBJ_CODE <> L_OBJ_CODE;

Line: 12479


         SELECT   WORKITEM_PK_ID
                , WORKITEM_OBJ_CODE
         BULK COLLECT INTO
                  WORKITEM_PK_ID_LIST
                , WORKITEM_OBJ_CODE_LIST
         FROM   IEU_UWQM_ITEMS_GTT A
         WHERE  A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
         AND    A.WORKITEM_OBJ_CODE <> L_OBJ_CODE
         AND    ROWNUM <= 5;

Line: 12517


           SELECT parent_ws_id, child_ws_id
           INTO   l_parent_ws_id, l_child_ws_id
           FROM   IEU_UWQM_WS_ASSCT_PROPS
           WHERE  ws_id = l_ws_id;

Line: 12546


           SELECT object_code
           INTO   l_parent_obj_code
           FROM   IEU_UWQM_WORK_SOURCES_B
           WHERE  ws_id = l_parent_ws_id
           and nvl(not_valid_flag, 'N') = l_not_valid_flag;

Line: 12575


           SELECT object_code
           INTO   l_child_obj_code
           FROM   IEU_UWQM_WORK_SOURCES_B
           WHERE  ws_id = l_child_ws_id
           and nvl(not_valid_flag, 'N') = l_not_valid_flag;

Line: 12607


      WORKITEM_PK_ID_LIST.delete;

Line: 12608


      WORKITEM_OBJ_CODE_LIST.delete;

Line: 12610


      SELECT count(*)
      INTO   l_count
      FROM   IEU_UWQM_ITEMS_GTT A
      WHERE  A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
      AND ( A.WORKITEM_OBJ_CODE <> L_CHILD_OBJ_CODE OR A.SOURCE_OBJECT_TYPE_CODE <> L_PARENT_OBJ_CODE);

Line: 12619


         SELECT   WORKITEM_PK_ID
                , WORKITEM_OBJ_CODE
         BULK COLLECT INTO
                  WORKITEM_PK_ID_LIST
                , WORKITEM_OBJ_CODE_LIST
         FROM   IEU_UWQM_ITEMS_GTT A
         WHERE  A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
         AND    (A.WORKITEM_OBJ_CODE <> L_CHILD_OBJ_CODE OR A.SOURCE_OBJECT_TYPE_CODE <> L_PARENT_OBJ_CODE)
         AND    ROWNUM <= 5;

Line: 12659


      WORKITEM_PK_ID_LIST.delete;

Line: 12660


      WORKITEM_OBJ_CODE_LIST.delete;

Line: 12662


      SELECT Count(*)
      INTO   l_count
      FROM  IEU_UWQM_ITEMS_GTT
      WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID
      AND  WORKITEM_STATUS NOT IN ('CLOSE', 'DELETE');

Line: 12671


         SELECT   WORKITEM_PK_ID
                , WORKITEM_OBJ_CODE
         BULK COLLECT INTO
                  WORKITEM_PK_ID_LIST
                , WORKITEM_OBJ_CODE_LIST
         FROM  IEU_UWQM_ITEMS_GTT
         WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID
         AND  WORKITEM_STATUS NOT IN ('CLOSE', 'DELETE')
         AND ROWNUM <= 5;

Line: 12705


      l_wr_item_status_rec.WORKITEM_OBJ_CODE_LST.delete;

Line: 12706


      l_wr_item_status_rec.WORKITEM_PK_ID_LST.delete;

Line: 12707


      l_wr_item_status_rec.STATUS_ID_LIST.delete;

Line: 12709


      SELECT  WORKITEM_OBJ_CODE
            , WORKITEM_PK_ID
            , DECODE(WORKITEM_STATUS, 'CLOSE', 3, 'DELETE', 4, STATUS_ID) "STATUS_ID"
      BULK COLLECT INTO l_wr_item_status_rec.WORKITEM_OBJ_CODE_LST
            , l_wr_item_status_rec.WORKITEM_PK_ID_LST
            , l_wr_item_status_rec.STATUS_ID_LIST
      FROM IEU_UWQM_ITEMS_GTT
      WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID;

Line: 12722


          UPDATE IEU_UWQM_ITEMS
          SET   OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
              , LAST_UPDATED_BY = FND_GLOBAL.USER_ID
              , LAST_UPDATE_DATE = SYSDATE
              , LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
              , STATUS_UPDATE_USER_ID = FND_GLOBAL.USER_ID
              , STATUS_ID = l_wr_item_status_rec.STATUS_ID_LIST(i)
          WHERE WORKITEM_OBJ_CODE = l_wr_item_status_rec.WORKITEM_OBJ_CODE_LST(i)
          AND WORKITEM_PK_ID = l_wr_item_status_rec.WORKITEM_PK_ID_LST(i);

Line: 12738


            FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');

Line: 12756


       l_wr_item_status_rec.WORKITEM_OBJ_CODE_LST.delete;

Line: 12757


       l_wr_item_status_rec.WORKITEM_PK_ID_LST.delete;

Line: 12758


       l_wr_item_status_rec.STATUS_ID_LIST.delete;

Line: 12808


PROCEDURE UPDATE_WR_ITEM_STATUS
( p_api_version               IN NUMBER,
  p_init_msg_list             IN VARCHAR2 DEFAULT NULL,
  p_commit                    IN VARCHAR2 DEFAULT NULL,
  p_ws_code                   IN VARCHAR2 DEFAULT NULL,
  x_msg_count                 OUT NOCOPY NUMBER,
  x_msg_data                  OUT NOCOPY VARCHAR2,
  x_return_status             OUT NOCOPY VARCHAR2) AS

  l_api_version        CONSTANT NUMBER        := 1.0;

Line: 12818


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

Line: 12842


   select work_item_id
   from ieu_uwqm_items
   where ws_id = p_ws_id
   and status_id = 0;

Line: 12854


      SAVEPOINT UPDATE_WR_ITEM_STATUS_SP;

Line: 12883


       Select ws_id
       into   l_ws_id
       from   ieu_uwqm_work_sources_b
       where  ws_code = p_ws_code
       and nvl(not_valid_flag, 'N') = l_not_valid_flag;

Line: 12897


            FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM_STATUS');

Line: 12914


     l_wr_item_status_rec.WORK_ITEM_ID_LIST.delete;

Line: 12929


              UPDATE IEU_UWQM_ITEMS
              SET   OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
                  , LAST_UPDATED_BY = FND_GLOBAL.USER_ID
                  , LAST_UPDATE_DATE = SYSDATE
                  , LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
                  , STATUS_UPDATE_USER_ID = FND_GLOBAL.USER_ID
                  , STATUS_ID = 3
              WHERE WORK_ITEM_ID = l_wr_item_status_rec.WORK_ITEM_ID_LIST(i);

Line: 12943


                FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');

Line: 12944


                FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.UPDATE_WR_ITEM_STATUS');

Line: 12964


          l_wr_item_status_rec.WORK_ITEM_ID_LIST.DELETE;

Line: 12976


  ROLLBACK TO UPDATE_WR_ITEM_STATUS_SP;

Line: 12987


  ROLLBACK TO UPDATE_WR_ITEM_STATUS_SP;

Line: 12999


  ROLLBACK TO UPDATE_WR_ITEM_STATUS_SP;

Line: 13014


END UPDATE_WR_ITEM_STATUS;