APPS.WSH_PR_CRITERIA dependencies on WSH_PR_WORKERS

Line 21: FROM wsh_pr_workers

17:
18:
19: CURSOR c_work_cursorID(l_batch_id NUMBER, l_organization_id NUMBER, l_mode VARCHAR2) IS
20: SELECT organization_id, inventory_item_id, mo_start_line_number, mo_line_count
21: FROM wsh_pr_workers
22: WHERE batch_id = l_batch_id
23: AND organization_id = l_organization_id
24: AND type = 'PICK'
25: AND processed = 'N'

Line 29: FROM wsh_pr_workers

25: AND processed = 'N'
26: AND l_mode = 'PICK'
27: UNION
28: SELECT organization_id, inventory_item_id, mo_start_line_number, mo_line_count
29: FROM wsh_pr_workers
30: WHERE batch_id = l_batch_id
31: AND organization_id = l_organization_id
32: AND type = 'PICK'
33: AND processed = 'N'

Line 2636: INSERT INTO WSH_PR_WORKERS (

2632: DBMS_SQL.Column_Value(v_CursorID, 1, v_org_id);
2633: DBMS_SQL.Column_Value(v_CursorID, 2, v_inventory_item_id);
2634: DBMS_SQL.Column_Value(v_CursorID, 3, v_count);
2635:
2636: INSERT INTO WSH_PR_WORKERS (
2637: batch_id,
2638: type,
2639: mo_header_id,
2640: organization_id,

Line 2911: FROM wsh_pr_workers

2907: PRAGMA EXCEPTION_INIT(worker_row_locked, -54);
2908: BEGIN
2909: SELECT 'Y'
2910: INTO l_temp
2911: FROM wsh_pr_workers
2912: WHERE batch_id = p_batch_id
2913: AND organization_id = v_pr_org_id
2914: AND NVL(inventory_item_id,-99) = NVL(v_pr_inv_item_id,-99)
2915: AND type = 'PICK'

Line 2973: UPDATE wsh_pr_workers

2969: EXIT;
2970: ELSIF l_temp = 'Y' THEN --{
2971: -- Update Worker Record as processed
2972: BEGIN
2973: UPDATE wsh_pr_workers
2974: SET processed = 'Y'
2975: WHERE batch_id = p_batch_id
2976: AND organization_id = v_pr_org_id
2977: AND NVL(inventory_item_id,-99) = NVL(v_pr_inv_item_id,-99)