eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ATP_DB_UTILS dependencies on MSC_RESOURCE_REQUIREMENTS

Line 1069: -- Insert demand into msc_resource_requirements

1065: END IF;
1066:
1067: x_return_status := FND_API.G_RET_STS_SUCCESS;
1068:
1069: -- Insert demand into msc_resource_requirements
1070: INSERT into msc_resource_requirements
1071: (plan_id,
1072: supply_id,
1073: transaction_id,

Line 1070: INSERT into msc_resource_requirements

1066:
1067: x_return_status := FND_API.G_RET_STS_SUCCESS;
1068:
1069: -- Insert demand into msc_resource_requirements
1070: INSERT into msc_resource_requirements
1071: (plan_id,
1072: supply_id,
1073: transaction_id,
1074: organization_id,

Line 1102: msc_resource_requirements_s.nextval,

1098: record_source, -- This field was not getting populated before. added with summary enhancement
1099: refresh_number) -- for summary enhancement
1100: VALUES (p_plan_id,
1101: p_supply_id,
1102: msc_resource_requirements_s.nextval,
1103: p_organization_id,
1104: p_instance_id,
1105: 1,
1106: p_resource_id,

Line 2532: DELETE FROM MSC_RESOURCE_REQUIREMENTS

2528: END IF; -- IF c1.identifier2 <> -1 THEN
2529: --bug 4267076: Delete only if demand_id/transaction id is available
2530: ELSIF c1.identifier3 is not null then -- IF NVL(c1.inventory_item_id, -1) > 0 THEN
2531:
2532: DELETE FROM MSC_RESOURCE_REQUIREMENTS
2533: WHERE transaction_id = c1.identifier3
2534: AND plan_id = c1.identifier2
2535: AND sr_instance_id = c1.identifier1 -- Bug 2675487 --3395085: Use correct instance_id
2536: returning department_id, resource_id, organization_id, start_date, sr_instance_id