The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_insert_flag IN NUMBER,
x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ)
IS
p_get_mat_in_rec MSC_ATP_REQ.get_mat_in_rec;
p_insert_flag,
x_atp_info,
x_atp_period,
x_atp_supply_demand,
p_get_mat_in_rec,
l_request_item_id, -- For time_phased_atp
l_atf_date); -- For time_phased_atp
p_insert_flag IN NUMBER,
p_max_capacity IN NUMBER,
p_batchable_flag IN NUMBER,
p_res_conversion_rate IN NUMBER,
p_res_uom_type IN NUMBER,
x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ)
IS
BEGIN
MSC_AATP_PVT.Res_Alloc_Cum_Atp(
p_plan_id,
p_level,
p_identifier,
p_scenario_id,
p_department_id,
p_resource_id,
p_organization_id,
p_instance_id,
p_demand_class,
p_request_date,
p_insert_flag,
p_max_capacity,
p_batchable_flag,
p_res_conversion_rate,
p_res_uom_type,
x_atp_info,
x_atp_period,
x_atp_supply_demand);
p_insert_flag IN NUMBER,
x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ
)
IS
BEGIN
/* ship_rec_cal
MSC_AATP_PVT.Supplier_Alloc_Cum_Atp(
p_plan_id,
p_level,
p_identifier,
p_scenario_id,
p_supplier_id,
p_supplier_site_id,
p_inventory_item_id,
p_organization_id,
p_instance_id,
p_demand_class,
p_request_date,
p_insert_flag,
NULL, -- SCLT changes Default value for p_sup_cap_cum_date
'@@@', -- For ship_rec_cal
NULL, -- For ship_rec_cal
x_atp_info,
x_atp_period,
x_atp_supply_demand,
NULL); -- for CTO*/