APPS.IEU_UWQ_GET_NEXT_WORK_PVT dependencies on IEU_UWQM_PRIORITIES_B

Line 981: l_priority_code IEU_UWQM_PRIORITIES_B.PRIORITY_CODE%TYPE;

977: l_dist_bus_rules SYSTEM.DIST_BUS_RULES_NST;
978: l_work_item_status VARCHAR2(50);
979: l_work_item_status_id NUMBER;
980: l_dist_items SYSTEM.WR_ITEM_DATA_NST;
981: l_priority_code IEU_UWQM_PRIORITIES_B.PRIORITY_CODE%TYPE;
982: l_NUM_OF_DIST_ITEMS NUMBER := 1;
983: l_dist_wr_cur_cnt NUMBER;
984: l_dist_work_item_id NUMBER;
985: l_priority_level NUMBER;

Line 1369: from ieu_uwqm_priorities_b

1365: -- Add items to the Table of rec
1366: BEGIN
1367: select priority_code
1368: into l_priority_code
1369: from ieu_uwqm_priorities_b
1370: where priority_id = l_dist_nw_item.PRIORITY_ID;
1371: EXCEPTION
1372: WHEN OTHERS THEN
1373: null;

Line 1631: from ieu_uwqm_priorities_b

1627: --insert into p_temp(msg) values('Attempting Dist for ID: '||l_nw_items_list(z).workitem_pk_id); commit;
1628: BEGIN
1629: select priority_level
1630: into l_priority_level
1631: from ieu_uwqm_priorities_b
1632: where priority_code = l_nw_items_list(z).priority_code;
1633: EXCEPTION
1634: WHEN OTHERS THEN
1635: null;

Line 2751: l_priority_code IEU_UWQM_PRIORITIES_B.PRIORITY_CODE%TYPE;

2747: L_MSG_DATA VARCHAR2(4000);
2748: L_RETURN_STATUS VARCHAR2(10);
2749: l_ctr NUMBER := 1;
2750: l_curr_ws_id NUMBER;
2751: l_priority_code IEU_UWQM_PRIORITIES_B.PRIORITY_CODE%TYPE;
2752: l_ws_code VARCHAR2(500);
2753: l_work_item_status VARCHAR2(500);
2754: l_work_item_status_id NUMBER;
2755: l_wr_cur_cnt NUMBER;

Line 2971: from ieu_uwqm_priorities_b

2967:
2968: -- Add items to the Table of rec
2969: select priority_code
2970: into l_priority_code
2971: from ieu_uwqm_priorities_b
2972: where priority_id = l_nw_item.PRIORITY_ID;
2973:
2974: l_nw_items_list(l_ctr).WORK_ITEM_ID := l_nw_item.WORK_ITEM_ID;
2975: l_nw_items_list(l_ctr).WORKITEM_OBJ_CODE := l_nw_item.WORKITEM_OBJ_CODE;