DBA Data[Home] [Help]

APPS.MSC_AATP_REQ dependencies on MSC_ATP_DB_UTILS

Line 299: MSC_ATP_DB_UTILS.Clear_SD_Details_Temp();

295: ELSE -- IF (NVL(p_insert_flag, 0) = 0 ) THEN
296: -- IF (NVL(p_insert_flag, 0) <> 0 )
297: -- OR p_scenario_id = -1
298: -- get the details
299: MSC_ATP_DB_UTILS.Clear_SD_Details_Temp();
300:
301: -- time_phased_atp
302: IF l_time_phased_atp = 'Y' THEN
303: MSC_ATP_PF.Item_Prealloc_Avail_Pf_Dtls(

Line 1844: MSC_ATP_DB_UTILS.Add_Mat_Demand(l_atp_rec,

1840: --l_atp_rec.demand_source_type := 2;
1841: l_atp_rec.demand_source_type := p_demand_source_type;--cmro
1842: l_atp_rec.demand_source_header_id := -1;
1843:
1844: MSC_ATP_DB_UTILS.Add_Mat_Demand(l_atp_rec,
1845: p_plan_id,
1846: 1, -- Demand Class True for forward stealing.
1847: l_demand_id);
1848:

Line 1896: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_demand_pegging_id);

1892: --parent is model entity
1893: OR (p_get_mat_in_rec.bom_item_type in (1, 4) and p_get_mat_in_rec.replenish_to_ord_flag = 'Y') THEN
1894: l_pegging_rec.model_sd_flag := 1;
1895: END IF;
1896: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_demand_pegging_id);
1897:
1898: --s_cto_rearch: pass demand pegg back just in case PO date is better than Sch. rec. date
1899: x_get_mat_out_rec.demand_pegging_id := l_demand_pegging_id;
1900:

Line 2032: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, x_atp_pegging_tab(1));

2028: msc_sch_wb.atp_debug('ATP_Check: ' || 'Inside ELSE');
2029: END IF;
2030: END IF;
2031: -- Bug 3826234 end
2032: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, x_atp_pegging_tab(1));
2033:
2034: IF PG_DEBUG in ('Y', 'C') THEN
2035: msc_sch_wb.atp_debug('Get_Forward_Material_Atp: ' || 'after Add_Pegging : ' || x_atp_pegging_tab(1));
2036: END IF;

Line 2058: MSC_ATP_DB_UTILS.Add_Stealing_Supply_Details (

2054: IF p_demand_class <> l_used_dc_tab(i) THEN
2055: -- Add the Stealing Data.
2056:
2057: IF l_time_phased_atp = 'N' THEN
2058: MSC_ATP_DB_UTILS.Add_Stealing_Supply_Details (
2059: p_plan_id,
2060: p_identifier,
2061: l_inv_item_id,
2062: p_organization_id,

Line 2158: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, x_atp_pegging_tab(i));

2154:
2155: l_pegging_rec.summary_flag := MSC_ATP_PVT.G_SUMMARY_FLAG; -- for summary enhancement
2156: l_pegging_rec.required_date := p_requested_date;
2157: l_pegging_rec.model_sd_flag := 2;
2158: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, x_atp_pegging_tab(i));
2159:
2160: END LOOP; --FOR i IN 1..l_used_dc_qty.COUNT LOOP
2161: END IF; --IF NVL(l_stealing_flag, 'N') = 'Y' THEN
2162: