APPS.MSC_ATP_SUBST dependencies on MRP_ATP_DETAILS_TEMP

Line 176: x_pegging_rec OUT NOCOPY mrp_atp_details_temp%ROWTYPE,

172:
173: /*------------------------- PEGGING_REC PROCEDURES ------------------------- */
174:
175: PROCEDURE Prep_Common_Pegging_Rec(
176: x_pegging_rec OUT NOCOPY mrp_atp_details_temp%ROWTYPE,
177: p_atp_record IN MRP_ATP_PVT.AtpRec,
178: ORG_AVAIL_INFO IN MSC_ATP_SUBST.ATP_Org_Info_Rec_Typ,
179: p_org_idx IN NUMBER,
180: Item_Availability_Info IN Item_Info_Rec_Typ,

Line 221: x_pegging_rec OUT NOCOPY mrp_atp_details_temp%ROWTYPE,

217: END Prep_Common_Pegging_Rec;
218:
219:
220: PROCEDURE Prep_Demand_Pegging_Rec(
221: x_pegging_rec OUT NOCOPY mrp_atp_details_temp%ROWTYPE,
222: p_atp_record IN MRP_ATP_PVT.AtpRec,
223: ORG_AVAIL_INFO IN MSC_ATP_SUBST.ATP_Org_Info_Rec_Typ,
224: p_org_idx IN NUMBER,
225: Item_Availability_Info IN Item_Info_Rec_Typ,

Line 307: x_pegging_rec OUT NOCOPY mrp_atp_details_temp%ROWTYPE,

303: * supply_demand_type is always 2
304: *
305: */
306: PROCEDURE Prep_PO_Pegging_Rec(
307: x_pegging_rec OUT NOCOPY mrp_atp_details_temp%ROWTYPE,
308: p_atp_record IN MRP_ATP_PVT.AtpRec,
309: ORG_AVAIL_INFO IN MSC_ATP_SUBST.ATP_Org_Info_Rec_Typ,
310: p_org_idx IN NUMBER,
311: Item_Availability_Info IN Item_Info_Rec_Typ,

Line 436: x_pegging_rec OUT NOCOPY mrp_atp_details_temp%ROWTYPE,

432:
433: END Prep_PO_Pegging_Rec;
434:
435: PROCEDURE Prep_Supply_Pegging_Rec(
436: x_pegging_rec OUT NOCOPY mrp_atp_details_temp%ROWTYPE,
437: p_atp_record IN MRP_ATP_PVT.AtpRec,
438: ORG_AVAIL_INFO IN MSC_ATP_SUBST.ATP_Org_Info_Rec_Typ,
439: p_org_idx IN NUMBER,
440: Item_Availability_Info IN Item_Info_Rec_Typ,

Line 639: l_pegging_rec mrp_atp_details_temp%ROWTYPE;

635: l_sd_end_idx number;
636: l_sources_found number;
637: l_transfer_found number;
638: L_AVAILABLE_QUANTITY number;
639: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
640: L_PTF_DATE date;
641: L_START_DATE date;
642: l_dock_date date;
643: l_req_ship_date date;

Line 5501: p_pegging_rec IN mrp_atp_details_temp%ROWTYPE)

5497:
5498: END Delete_demand_subst;
5499:
5500: PROCEDURE ADD_PEGGING(
5501: p_pegging_rec IN mrp_atp_details_temp%ROWTYPE)
5502: IS
5503: BEGIN
5504: IF PG_DEBUG in ('Y', 'C') THEN
5505: msc_sch_wb.atp_debug('ADD_PEGGING: ' || 'Add pegging for Peg id : ' || p_pegging_rec.pegging_id);

Line 5510: INSERT into mrp_atp_details_temp

5506: msc_sch_wb.atp_debug('ADD_PEGGING: ' || 'intransit lead time: ' || p_pegging_rec.INTRANSIT_LEAD_TIME);
5507: msc_sch_wb.atp_debug('ADD_PEGGING: ' || 'aggregate_time_fence_date: ' || p_pegging_rec.aggregate_time_fence_date); --bug3467631
5508: END IF;
5509:
5510: INSERT into mrp_atp_details_temp
5511: (session_id,
5512: order_line_id,
5513: pegging_id,
5514: parent_pegging_id,