DBA Data[Home] [Help]

APPS.IEU_UWQ_GET_NEXT_WORK_PVT dependencies on WR_ITEM_DATA_OBJ

Line 1915: l_dist_items(l_dist_items.last) := SYSTEM.WR_ITEM_DATA_OBJ(l_nw_items_list(z).WORK_ITEM_ID,

1911: end if;
1912:
1913: --dbms_output.put_line('ws id matches: '||l_nw_items_list(i).ws_id|| ' ID: '||l_nw_items_list(i).WORKITEM_PK_ID);
1914: l_dist_items.extend;
1915: l_dist_items(l_dist_items.last) := SYSTEM.WR_ITEM_DATA_OBJ(l_nw_items_list(z).WORK_ITEM_ID,
1916: l_nw_items_list(z).WORKITEM_OBJ_CODE,
1917: l_nw_items_list(z).WORKITEM_PK_ID,
1918: l_work_item_status,
1919: l_nw_items_list(z).PRIORITY_ID,

Line 2280: l_dist_items(l_dist_items.LAST) := SYSTEM.WR_ITEM_DATA_OBJ(l_dist_items(j).WORK_ITEM_ID,

2276: --dbms_output.put_line('dist status set to TRUE work item pkid: '||l_dist_items(j).WORKITEM_PK_ID);
2277:
2278: l_num_of_items_distributed := l_num_of_items_distributed + 1;
2279: -- Update the same object
2280: l_dist_items(l_dist_items.LAST) := SYSTEM.WR_ITEM_DATA_OBJ(l_dist_items(j).WORK_ITEM_ID,
2281: l_dist_items(j).WORKITEM_OBJ_CODE,
2282: l_dist_items(j).WORKITEM_PK_ID,
2283: l_work_item_status_id,
2284: l_dist_items(j).PRIORITY_ID,

Line 3146: l_dist_items(l_dist_items.last) := SYSTEM.WR_ITEM_DATA_OBJ(l_nw_items_list2(i).WORK_ITEM_ID,

3142: end if;
3143:
3144: --dbms_output.put_line('ws id matches: '||l_nw_items_list(i).ws_id|| ' ID: '||l_nw_items_list(i).WORKITEM_PK_ID);
3145: l_dist_items.extend;
3146: l_dist_items(l_dist_items.last) := SYSTEM.WR_ITEM_DATA_OBJ(l_nw_items_list2(i).WORK_ITEM_ID,
3147: l_nw_items_list2(i).WORKITEM_OBJ_CODE,
3148: l_nw_items_list2(i).WORKITEM_PK_ID,
3149: l_work_item_status,
3150: l_nw_items_list2(i).PRIORITY_ID,

Line 3549: x_uwqm_workitem_data(x_uwqm_workitem_data.last) := SYSTEM.WR_ITEM_DATA_OBJ(l_dist_items(j).WORK_ITEM_ID,

3545: --dbms_output.put_line('dist status set to TRUE work item pkid: '||l_dist_items(j).WORKITEM_PK_ID);
3546:
3547: x_num_of_items_distributed := x_num_of_items_distributed + 1;
3548: x_uwqm_workitem_data.extend;
3549: x_uwqm_workitem_data(x_uwqm_workitem_data.last) := SYSTEM.WR_ITEM_DATA_OBJ(l_dist_items(j).WORK_ITEM_ID,
3550: l_dist_items(j).WORKITEM_OBJ_CODE,
3551: l_dist_items(j).WORKITEM_PK_ID,
3552: l_work_item_status_id,
3553: l_dist_items(j).PRIORITY_ID,