APPS.MSC_ATP_DB_UTILS dependencies on MSC_RESOURCE_REQUIREMENTS

Line 1222: -- Insert demand into msc_resource_requirements

1218: END IF;
1219:
1220: x_return_status := FND_API.G_RET_STS_SUCCESS;
1221:
1222: -- Insert demand into msc_resource_requirements
1223: INSERT into msc_resource_requirements
1224: (plan_id,
1225: supply_id,
1226: transaction_id,

Line 1223: INSERT into msc_resource_requirements

1219:
1220: x_return_status := FND_API.G_RET_STS_SUCCESS;
1221:
1222: -- Insert demand into msc_resource_requirements
1223: INSERT into msc_resource_requirements
1224: (plan_id,
1225: supply_id,
1226: transaction_id,
1227: organization_id,

Line 1255: msc_resource_requirements_s.nextval,

1251: record_source, -- This field was not getting populated before. added with summary enhancement
1252: refresh_number) -- for summary enhancement
1253: VALUES (p_plan_id,
1254: p_supply_id,
1255: msc_resource_requirements_s.nextval,
1256: p_organization_id,
1257: p_instance_id,
1258: 1,
1259: p_resource_id,

Line 2689: DELETE FROM MSC_RESOURCE_REQUIREMENTS

2685: END IF; -- IF c1.identifier2 <> -1 THEN
2686: --bug 4267076: Delete only if demand_id/transaction id is available
2687: ELSIF c1.identifier3 is not null then -- IF NVL(c1.inventory_item_id, -1) > 0 THEN
2688:
2689: DELETE FROM MSC_RESOURCE_REQUIREMENTS
2690: WHERE transaction_id = c1.identifier3
2691: AND plan_id = c1.identifier2
2692: AND sr_instance_id = c1.identifier1 -- Bug 2675487 --3395085: Use correct instance_id
2693: returning department_id, resource_id, organization_id, start_date, sr_instance_id

Line 6077: UPDATE MSC_RESOURCE_REQUIREMENTS

6073: END IF;
6074: END IF;
6075: ELSE -- IF NVL(c1.inventory_item_id, -1) > 0 THEN
6076:
6077: UPDATE MSC_RESOURCE_REQUIREMENTS
6078: SET resource_id = -1*resource_id
6079: WHERE transaction_id = c1.identifier3
6080: AND plan_id = c1.identifier2
6081: AND sr_instance_id = c1.identifier1

Line 6085: msc_sch_wb.atp_debug('Hide_SD_Rec: ' || 'No. of demand deleted from msc_resource_requirements = '|| SQL%ROWCOUNT);

6081: AND sr_instance_id = c1.identifier1
6082: AND resource_id > 0;
6083:
6084: IF PG_DEBUG in ('Y', 'C') THEN
6085: msc_sch_wb.atp_debug('Hide_SD_Rec: ' || 'No. of demand deleted from msc_resource_requirements = '|| SQL%ROWCOUNT);
6086: END IF;
6087:
6088: END IF; -- IF NVL(c1.inventory_item_id, -1) > 0 THEN
6089: END IF; -- IF c1.supply_demand_type = 2 THEN

Line 6244: DELETE FROM MSC_RESOURCE_REQUIREMENTS

6240: END IF;
6241:
6242: ELSE -- IF NVL(c1.inventory_item_id, -1) > 0 THEN
6243:
6244: DELETE FROM MSC_RESOURCE_REQUIREMENTS
6245: WHERE transaction_id = c1.identifier3
6246: AND plan_id = c1.identifier2
6247: AND sr_instance_id = c1.identifier1;
6248:

Line 6250: msc_sch_wb.atp_debug('Delete_SD_Rec: ' || 'No. of demand deleted from msc_resource_requirements = '|| SQL%ROWCOUNT);

6246: AND plan_id = c1.identifier2
6247: AND sr_instance_id = c1.identifier1;
6248:
6249: IF PG_DEBUG in ('Y', 'C') THEN
6250: msc_sch_wb.atp_debug('Delete_SD_Rec: ' || 'No. of demand deleted from msc_resource_requirements = '|| SQL%ROWCOUNT);
6251: END IF;
6252:
6253: END IF; -- IF NVL(c1.inventory_item_id, -1) > 0 THEN
6254: END IF; -- IF c1.supply_demand_type = 2 THEN

Line 6421: UPDATE MSC_RESOURCE_REQUIREMENTS

6417: END IF;
6418:
6419: ELSE -- IF NVL(c1.inventory_item_id, -1) > 0 THEN
6420:
6421: UPDATE MSC_RESOURCE_REQUIREMENTS
6422: SET resource_id = -1*resource_id
6423: WHERE transaction_id = c1.identifier3
6424: AND plan_id = c1.identifier2
6425: AND sr_instance_id = c1.identifier1

Line 6429: msc_sch_wb.atp_debug('Restore_SD_Rec: ' || 'No. of demand updated from msc_resource_requirements = '|| SQL%ROWCOUNT);

6425: AND sr_instance_id = c1.identifier1
6426: AND resource_id < 0;
6427:
6428: IF PG_DEBUG in ('Y', 'C') THEN
6429: msc_sch_wb.atp_debug('Restore_SD_Rec: ' || 'No. of demand updated from msc_resource_requirements = '|| SQL%ROWCOUNT);
6430: END IF;
6431: END IF; -- IF NVL(c1.inventory_item_id, -1) > 0 THEN
6432: END IF; -- IF c1.supply_demand_type = 2 THEN
6433: END LOOP;