DBA Data[Home] [Help]

APPS.MSC_ATP_PEG dependencies on MSC_RESOURCE_REQUIREMENTS

Line 1107: FROM msc_resource_requirements req

1103: res_peg_tab.inventory_item_id, res_peg_tab.supply_id, res_peg_tab.resource_id,
1104: res_peg_tab.department_id, res_peg_tab.resource_hours, res_peg_tab.daily_resource_hours,
1105: res_peg_tab.start_date, res_peg_tab.end_date, res_peg_tab.relief_quantity,
1106: res_peg_tab.daily_relief_qty
1107: FROM msc_resource_requirements req
1108: WHERE req.plan_id = atp_peg_tab.plan_id(i)
1109: AND req.sr_instance_id = atp_peg_tab.sr_instance_id(i)
1110: AND req.organization_id = atp_peg_tab.organization_id(i)
1111: AND req.supply_id = atp_peg_tab.supply_id(i)

Line 5740: 'Offsetting msc_resource_requirements for identifier = '

5736: msc_sch_wb.atp_debug('***** Begin Add_Offset_Resource_Reqs *****');
5737: END IF;
5738: IF PG_DEBUG in ('Y', 'C') THEN
5739: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: ' ||
5740: 'Offsetting msc_resource_requirements for identifier = '
5741: || p_identifier ||' : plan id = '||p_plan_id);
5742: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: Config Line Id = ' || p_config_line_id );
5743: END IF ;
5744:

Line 5762: -- Insert demand into msc_resource_requirements

5758:
5759: l_sysdate := sysdate;
5760: l_user_id := FND_GLOBAL.USER_ID;
5761:
5762: -- Insert demand into msc_resource_requirements
5763: SELECT
5764: supply_id,
5765: sr_instance_id,
5766: msc_resource_requirements_s.nextval,

Line 5766: msc_resource_requirements_s.nextval,

5762: -- Insert demand into msc_resource_requirements
5763: SELECT
5764: supply_id,
5765: sr_instance_id,
5766: msc_resource_requirements_s.nextval,
5767: organization_id,
5768: inventory_item_id,
5769: basis_type,
5770: operation_seq_num,

Line 5828: msc_resource_requirements REQ,

5824: decode(map.resource_id,-1,map.relief_quantity,to_number(null)) load_rate,
5825: REQ.assigned_units, -- 0 originally.
5826: REQ.std_op_code
5827: FROM msc_atp_pegging map,
5828: msc_resource_requirements REQ,
5829: -- Bug 3381464 -- Join to Pegging to obtain offset supply ids.
5830: msc_atp_pegging map2
5831: WHERE map.plan_id = p_plan_id
5832: --AND map.sr_instance_id = p_instance_id -- removed to support multiple instances in plan.

Line 5882: INSERT into msc_resource_requirements

5878: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: ' ||
5879: 'Total Rows to add = ' || l_del_rows );
5880: END IF;
5881: FORALL i in 1..l_del_rows
5882: INSERT into msc_resource_requirements
5883: (plan_id,
5884: supply_id,
5885: transaction_id,
5886: organization_id,

Line 6434: DELETE msc_resource_requirements

6430: x_return_status := FND_API.G_RET_STS_SUCCESS;
6431:
6432: --Bug 3629191
6433: FORALL m IN 1..p_del_resrc_reqs.COUNT
6434: DELETE msc_resource_requirements
6435: WHERE
6436: -- Bug 3629191 :All where clause except and transaction_id are commmented
6437: /*sr_instance_id = p_instance_id
6438: (SELECT sr_instance_id