APPS.MSC_UPDATE_RESOURCE dependencies on MSC_RESOURCE_REQUIREMENTS

Line 1417: from msc_resource_requirements

1413: p_changed_op number,
1414: p_changed_res number) RETURN boolean IS
1415: cursor op_c is
1416: select operation_seq_num,resource_seq_num
1417: from msc_resource_requirements
1418: where plan_id = p_plan_id
1419: and supply_id = p_supply_id
1420: and parent_id = 2
1421: order by operation_seq_num,resource_seq_num;

Line 1516: from msc_resource_requirements

1512: nvl(firm_start_date,start_date),
1513: nvl(firm_end_date,end_date),
1514: operation_sequence_id,
1515: routing_sequence_id
1516: from msc_resource_requirements
1517: where plan_id = p_plan_id
1518: and supply_id = p_supply_id
1519: and parent_id = 2
1520: order by operation_seq_num,resource_seq_num;

Line 1644: update msc_resource_requirements

1640: a number;
1641: BEGIN
1642:
1643: forall a in 1..p_trans_id.count
1644: update msc_resource_requirements
1645: set firm_start_date = p_start_time(a),
1646: firm_end_date = p_end_time(a),
1647: assigned_units = p_resource_units(a), --bug 5973698
1648: status = 0,

Line 1852: from msc_resource_requirements

1848: to_char(firm_end_date,'MM/DD/RRRR HH24:MI') firm_end_time,
1849: to_char(start_date,'MM/DD/RRRR HH24:MI') start_time,
1850: to_char(end_date,'MM/DD/RRRR HH24:MI') end_time,
1851: resource_hours, overloaded_capacity
1852: from msc_resource_requirements
1853: where plan_id = p_plan_id
1854: and supply_id = p_supply_id
1855: and parent_id = 2
1856: order by operation_seq_num,resource_seq_num;