APPS.WIP_WS_SHORTAGE dependencies on WIP_WS_CRITICAL_RES_TEMP

Line 1236: select organization_id, resource_id, department_id from wip_ws_critical_res_temp;

1232: l_res_req NUMBER;
1233: prev_res_id NUMBER;
1234:
1235: cursor critical_res_csr IS
1236: select organization_id, resource_id, department_id from wip_ws_critical_res_temp;
1237:
1238:
1239: BEGIN
1240: wip_ws_util.trace_log('WIP_WS_SHORTAGE:get_job_critical_resources:Entered ');

Line 1298: insert into wip_ws_critical_res_temp

1294: g_wip_job_critical_res_tbl(j).SHIFT_NUM := l_shift_num;
1295: g_wip_job_critical_res_tbl(j).SHIFT_SEQ := l_shift_seq;
1296: --insert a record for dept resource
1297: begin
1298: insert into wip_ws_critical_res_temp
1299: (organization_id,
1300: resource_id,
1301: department_id)
1302: values

Line 1845: wip_ws_critical_res_temp

1841: p_res_avail_date DATE, p_shift_num NUMBER,
1842: p_onhand_qty NUMBER, p_proj_onhand NUMBER) IS
1843: BEGIN
1844: update
1845: wip_ws_critical_res_temp
1846: set
1847: resource_avail_date = p_res_avail_date,
1848: resource_shift_num = p_shift_num,
1849: onhand_qty = p_onhand_qty,

Line 2081: from wip_ws_critical_res_temp

2077: onhand_qty,
2078: projected_avail_qty,
2079: resource_avail_date,
2080: resource_shift_num
2081: from wip_ws_critical_res_temp
2082: where organization_id = p_org_id
2083: and department_id = p_dept_id
2084: and resource_id = p_res_id;
2085: