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,ROWID -- Bug # 9369504 : added rowid
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,ROWID -- Bug # 9369504 : added rowid
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 2742: INSERT INTO WSH_PR_WORKERS (

2738: DBMS_SQL.Column_Value(v_CursorID, 1, v_org_id);
2739: DBMS_SQL.Column_Value(v_CursorID, 2, v_inventory_item_id);
2740: DBMS_SQL.Column_Value(v_CursorID, 3, v_count);
2741:
2742: INSERT INTO WSH_PR_WORKERS (
2743: batch_id,
2744: type,
2745: mo_header_id,
2746: organization_id,

Line 3022: FROM wsh_pr_workers

3018: BEGIN
3019: -- Bug # 9369504 : Added rowid in where clause.
3020: SELECT 'Y'
3021: INTO l_temp
3022: FROM wsh_pr_workers
3023: WHERE ROWID = v_rowid
3024: AND processed = 'N'
3025: FOR UPDATE NOWAIT;
3026: EXIT; -- successfully locked

Line 3082: UPDATE wsh_pr_workers

3078: ELSIF l_temp = 'Y' THEN --{
3079: -- Update Worker Record as processed
3080: BEGIN
3081: -- Bug # 9369504 : Added rowid in where clause.
3082: UPDATE wsh_pr_workers
3083: SET processed = 'Y'
3084: WHERE ROWID= v_rowid;
3085: EXCEPTION WHEN OTHERS THEN
3086: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;