APPS.IEU_TASKS_WR_MIG_PVT dependencies on IEU_UWQM_ITEMS

Line 406: insert into ieu_uwqm_items

402: end if;
403:
404: BEGIN
405: FORALL i in 1..l_task_det_rec.l_task_id_list.COUNT SAVE EXCEPTIONS
406: insert into ieu_uwqm_items
407: ( WORK_ITEM_ID,
408: OBJECT_VERSION_NUMBER,
409: CREATED_BY,
410: CREATION_DATE,

Line 436: IEU_UWQM_ITEMS_S1.NEXTVAL,

432: RESCHEDULE_TIME,
433: WS_ID,
434: DISTRIBUTION_STATUS_ID )
435: values (
436: IEU_UWQM_ITEMS_S1.NEXTVAL,
437: 0,
438: l_user_id,
439: SYSDATE,
440: l_user_id,

Line 532: UPDATE IEU_UWQM_ITEMS

528: then
529: -- fnd_file.put_line(FND_FILE.LOG,'begin update');
530: BEGIN
531: FORALL i in 1..l_task_det_rec.l_task_id_list.COUNT SAVE EXCEPTIONS
532: UPDATE IEU_UWQM_ITEMS
533: set
534: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
535: -- CREATED_BY = l_user_id,
536: -- CREATION_DATE = SYSDATE,

Line 654: tabname => 'IEU_UWQM_ITEMS');

650: close c_task_details_1;
651:
652: DBMS_STATS.DELETE_TABLE_STATS (
653: ownname => 'IEU',
654: tabname => 'IEU_UWQM_ITEMS');
655:
656: DBMS_STATS.GATHER_TABLE_STATS (
657: ownname => 'IEU',
658: tabname => 'IEU_UWQM_ITEMS',

Line 658: tabname => 'IEU_UWQM_ITEMS',

654: tabname => 'IEU_UWQM_ITEMS');
655:
656: DBMS_STATS.GATHER_TABLE_STATS (
657: ownname => 'IEU',
658: tabname => 'IEU_UWQM_ITEMS',
659: degree => 8,
660: cascade => TRUE);
661:
662:

Line 680: update IEU_UWQM_ITEMS

676:
677: BEGIN
678: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');
679: FORALL i in 1..l_task_duedate_rec.l_task_id_list.COUNT SAVE EXCEPTIONS
680: update IEU_UWQM_ITEMS
681: set due_date = l_task_duedate_rec.l_due_date_list(i)
682: where workitem_pk_id = l_task_duedate_rec.l_task_id_list(i)
683: and workitem_obj_code = 'TASK'
684: and ws_id = l_ws_id;

Line 770: update IEU_UWQM_ITEMS

766:
767: BEGIN
768: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');
769: FORALL i in 1..l_task_status_rec.l_task_id_list.COUNT SAVE EXCEPTIONS
770: update IEU_UWQM_ITEMS
771: set status_id = l_task_status_rec.l_status_id_list(i),
772: LAST_UPDATED_BY = l_user_id,
773: LAST_UPDATE_DATE = SYSDATE,
774: LAST_UPDATE_LOGIN = l_login_id

Line 859: update IEU_UWQM_ITEMS

855:
856: BEGIN
857: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');
858: FORALL i in 1..l_task_asg_rec.l_asg_task_id_list.COUNT SAVE EXCEPTIONS
859: update IEU_UWQM_ITEMS
860: set assignee_id = l_task_asg_rec.l_asg_id_list(i),
861: assignee_type = 'RS_INDIVIDUAL',
862: assignee_type_actual = l_task_asg_rec.l_asg_type_act_list(i),
863: DISTRIBUTION_STATUS_ID = 3

Line 1000: tabname => 'IEU_UWQM_ITEMS');

996: -- dbms_output.put_line(l_workitem_sum_msg);
997:
998: DBMS_STATS.DELETE_TABLE_STATS (
999: ownname => 'IEU',
1000: tabname => 'IEU_UWQM_ITEMS');
1001:
1002: DBMS_STATS.GATHER_TABLE_STATS (
1003: ownname => 'IEU',
1004: tabname => 'IEU_UWQM_ITEMS',

Line 1004: tabname => 'IEU_UWQM_ITEMS',

1000: tabname => 'IEU_UWQM_ITEMS');
1001:
1002: DBMS_STATS.GATHER_TABLE_STATS (
1003: ownname => 'IEU',
1004: tabname => 'IEU_UWQM_ITEMS',
1005: degree => 8,
1006: cascade => TRUE);
1007:
1008: EXCEPTION