DBA Data[Home] [Help]

APPS.IEU_UWQ_GET_NEXT_WORK_PVT dependencies on WR_ITEM_DATA_OBJ

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

1877: end if;
1878:
1879: --dbms_output.put_line('ws id matches: '||l_nw_items_list(i).ws_id|| ' ID: '||l_nw_items_list(i).WORKITEM_PK_ID);
1880: l_dist_items.extend;
1881: l_dist_items(l_dist_items.last) := SYSTEM.WR_ITEM_DATA_OBJ(l_nw_items_list(z).WORK_ITEM_ID,
1882: l_nw_items_list(z).WORKITEM_OBJ_CODE,
1883: l_nw_items_list(z).WORKITEM_PK_ID,
1884: l_work_item_status,
1885: l_nw_items_list(z).PRIORITY_ID,

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

2242: --dbms_output.put_line('dist status set to TRUE work item pkid: '||l_dist_items(j).WORKITEM_PK_ID);
2243:
2244: l_num_of_items_distributed := l_num_of_items_distributed + 1;
2245: -- Update the same object
2246: l_dist_items(l_dist_items.LAST) := SYSTEM.WR_ITEM_DATA_OBJ(l_dist_items(j).WORK_ITEM_ID,
2247: l_dist_items(j).WORKITEM_OBJ_CODE,
2248: l_dist_items(j).WORKITEM_PK_ID,
2249: l_work_item_status_id,
2250: l_dist_items(j).PRIORITY_ID,

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

3108: end if;
3109:
3110: --dbms_output.put_line('ws id matches: '||l_nw_items_list(i).ws_id|| ' ID: '||l_nw_items_list(i).WORKITEM_PK_ID);
3111: l_dist_items.extend;
3112: l_dist_items(l_dist_items.last) := SYSTEM.WR_ITEM_DATA_OBJ(l_nw_items_list2(i).WORK_ITEM_ID,
3113: l_nw_items_list2(i).WORKITEM_OBJ_CODE,
3114: l_nw_items_list2(i).WORKITEM_PK_ID,
3115: l_work_item_status,
3116: l_nw_items_list2(i).PRIORITY_ID,

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

3511: --dbms_output.put_line('dist status set to TRUE work item pkid: '||l_dist_items(j).WORKITEM_PK_ID);
3512:
3513: x_num_of_items_distributed := x_num_of_items_distributed + 1;
3514: x_uwqm_workitem_data.extend;
3515: x_uwqm_workitem_data(x_uwqm_workitem_data.last) := SYSTEM.WR_ITEM_DATA_OBJ(l_dist_items(j).WORK_ITEM_ID,
3516: l_dist_items(j).WORKITEM_OBJ_CODE,
3517: l_dist_items(j).WORKITEM_PK_ID,
3518: l_work_item_status_id,
3519: l_dist_items(j).PRIORITY_ID,