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 1332: from ieu_uwqm_priorities_b

1328: -- Add items to the Table of rec
1329: BEGIN
1330: select priority_code
1331: into l_priority_code
1332: from ieu_uwqm_priorities_b
1333: where priority_id = l_dist_nw_item.PRIORITY_ID;
1334: EXCEPTION
1335: WHEN OTHERS THEN
1336: null;

Line 1597: from ieu_uwqm_priorities_b

1593: --insert into p_temp(msg) values('Attempting Dist for ID: '||l_nw_items_list(z).workitem_pk_id); commit;
1594: BEGIN
1595: select priority_level
1596: into l_priority_level
1597: from ieu_uwqm_priorities_b
1598: where priority_code = l_nw_items_list(z).priority_code;
1599: EXCEPTION
1600: WHEN OTHERS THEN
1601: null;

Line 2717: l_priority_code IEU_UWQM_PRIORITIES_B.PRIORITY_CODE%TYPE;

2713: L_MSG_DATA VARCHAR2(4000);
2714: L_RETURN_STATUS VARCHAR2(10);
2715: l_ctr NUMBER := 1;
2716: l_curr_ws_id NUMBER;
2717: l_priority_code IEU_UWQM_PRIORITIES_B.PRIORITY_CODE%TYPE;
2718: l_ws_code VARCHAR2(500);
2719: l_work_item_status VARCHAR2(500);
2720: l_work_item_status_id NUMBER;
2721: l_wr_cur_cnt NUMBER;

Line 2937: from ieu_uwqm_priorities_b

2933:
2934: -- Add items to the Table of rec
2935: select priority_code
2936: into l_priority_code
2937: from ieu_uwqm_priorities_b
2938: where priority_id = l_nw_item.PRIORITY_ID;
2939:
2940: l_nw_items_list(l_ctr).WORK_ITEM_ID := l_nw_item.WORK_ITEM_ID;
2941: l_nw_items_list(l_ctr).WORKITEM_OBJ_CODE := l_nw_item.WORKITEM_OBJ_CODE;