APPS.WIP_WS_SHORTAGE dependencies on WIP_WS_CRITICAL_RES_TEMP

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

1163: l_res_req NUMBER;
1164: prev_res_id NUMBER;
1165:
1166: cursor critical_res_csr IS
1167: select organization_id, resource_id, department_id from wip_ws_critical_res_temp;
1168:
1169:
1170: BEGIN
1171: wip_ws_util.trace_log('WIP_WS_SHORTAGE:get_job_critical_resources:Entered ');

Line 1227: insert into wip_ws_critical_res_temp

1223: g_wip_job_critical_res_tbl(j).SHIFT_NUM := l_shift_num;
1224: g_wip_job_critical_res_tbl(j).SHIFT_SEQ := l_shift_seq;
1225: --insert a record for dept resource
1226: begin
1227: insert into wip_ws_critical_res_temp
1228: (organization_id,
1229: resource_id,
1230: department_id)
1231: values

Line 1774: wip_ws_critical_res_temp

1770: p_res_avail_date DATE, p_shift_num NUMBER,
1771: p_onhand_qty NUMBER, p_proj_onhand NUMBER) IS
1772: BEGIN
1773: update
1774: wip_ws_critical_res_temp
1775: set
1776: resource_avail_date = p_res_avail_date,
1777: resource_shift_num = p_shift_num,
1778: onhand_qty = p_onhand_qty,

Line 2010: from wip_ws_critical_res_temp

2006: onhand_qty,
2007: projected_avail_qty,
2008: resource_avail_date,
2009: resource_shift_num
2010: from wip_ws_critical_res_temp
2011: where organization_id = p_org_id
2012: and department_id = p_dept_id
2013: and resource_id = p_res_id;
2014: