[Home] [Help]
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)
5722: msc_sch_wb.atp_debug('***** Begin Add_Offset_Resource_Reqs *****');
5723: END IF;
5724: IF PG_DEBUG in ('Y', 'C') THEN
5725: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: ' ||
5726: 'Offsetting msc_resource_requirements for identifier = '
5727: || p_identifier ||' : plan id = '||p_plan_id);
5728: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: Config Line Id = ' || p_config_line_id );
5729: END IF ;
5730:
5744:
5745: l_sysdate := sysdate;
5746: l_user_id := FND_GLOBAL.USER_ID;
5747:
5748: -- Insert demand into msc_resource_requirements
5749: SELECT
5750: supply_id,
5751: sr_instance_id,
5752: msc_resource_requirements_s.nextval,
5748: -- Insert demand into msc_resource_requirements
5749: SELECT
5750: supply_id,
5751: sr_instance_id,
5752: msc_resource_requirements_s.nextval,
5753: organization_id,
5754: inventory_item_id,
5755: basis_type,
5756: operation_seq_num,
5810: decode(map.resource_id,-1,map.relief_quantity,to_number(null)) load_rate,
5811: REQ.assigned_units, -- 0 originally.
5812: REQ.std_op_code
5813: FROM msc_atp_pegging map,
5814: msc_resource_requirements REQ,
5815: -- Bug 3381464 -- Join to Pegging to obtain offset supply ids.
5816: msc_atp_pegging map2
5817: WHERE map.plan_id = p_plan_id
5818: --AND map.sr_instance_id = p_instance_id -- removed to support multiple instances in plan.
5864: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: ' ||
5865: 'Total Rows to add = ' || l_del_rows );
5866: END IF;
5867: FORALL i in 1..l_del_rows
5868: INSERT into msc_resource_requirements
5869: (plan_id,
5870: supply_id,
5871: transaction_id,
5872: organization_id,
6416: x_return_status := FND_API.G_RET_STS_SUCCESS;
6417:
6418: --Bug 3629191
6419: FORALL m IN 1..p_del_resrc_reqs.COUNT
6420: DELETE msc_resource_requirements
6421: WHERE
6422: -- Bug 3629191 :All where clause except and transaction_id are commmented
6423: /*sr_instance_id = p_instance_id
6424: (SELECT sr_instance_id