APPS.MSC_UPDATE_RESOURCE dependencies on MSC_RESOURCE_REQUIREMENTS

Line 1695: from msc_resource_requirements

1691: p_changed_op number,
1692: p_changed_res number) RETURN boolean IS
1693: cursor op_c is
1694: select operation_seq_num,resource_seq_num
1695: from msc_resource_requirements
1696: where plan_id = p_plan_id
1697: and supply_id = p_supply_id
1698: and parent_id = 2
1699: order by operation_seq_num,resource_seq_num;

Line 1794: from msc_resource_requirements

1790: nvl(firm_start_date,start_date),
1791: nvl(firm_end_date,end_date),
1792: operation_sequence_id,
1793: routing_sequence_id
1794: from msc_resource_requirements
1795: where plan_id = p_plan_id
1796: and supply_id = p_supply_id
1797: and parent_id = 2
1798: order by operation_seq_num,resource_seq_num;

Line 1922: update msc_resource_requirements

1918: a number;
1919: BEGIN
1920:
1921: forall a in 1..p_trans_id.count
1922: update msc_resource_requirements
1923: set firm_start_date = p_start_time(a),
1924: firm_end_date = p_end_time(a),
1925: assigned_units = p_resource_units(a), --bug 5973698
1926: status = 0,

Line 2137: from msc_resource_requirements

2133: to_char(firm_end_date,'MM/DD/RRRR HH24:MI') firm_end_time,
2134: to_char(start_date,'MM/DD/RRRR HH24:MI') start_time,
2135: to_char(end_date,'MM/DD/RRRR HH24:MI') end_time,
2136: resource_hours, overloaded_capacity
2137: from msc_resource_requirements
2138: where plan_id = p_plan_id
2139: and supply_id = p_supply_id
2140: and parent_id = 2
2141: order by operation_seq_num,resource_seq_num;