[Home] [Help]
620: msc_sch_wb.atp_debug('Atp_Sources: ' || 'we are in ship set and receiving party is customer');
621: END IF;
622:
623: -- rmehra Replaced views by procedure for bug 2585710
624: MSC_ATP_PROC.Get_Sources_Info(order_sch_wb.debug_session_id, null, l_customer_id,
625: p_customer_site_id, p_assign_set_id, l_count, x_atp_sources, l_return_status,
626: p_partner_type, p_party_site_id, p_order_line_id ); --2814895
627:
628: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
799: -- ngoel 9/26/2001, since view msc_scatp_sources_v resolves the hierarchy,
800: -- no need to have either union all or separate clause for customer site and region
801:
802: -- bug 2585710. Replaced views by procedure
803: MSC_ATP_PROC.Get_Sources_Info(order_sch_wb.debug_session_id, l_inv_item_id, l_customer_id,
804: p_customer_site_id, p_assign_set_id, null, x_atp_sources, l_return_status,
805: p_partner_type, p_party_site_id, p_order_line_id ); --2814895
806:
807: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3228: l_request_item_id NUMBER := NULL;
3229: l_sources mrp_atp_pvt.atp_source_typ;
3230: l_item_arr mrp_atp_pub.number_arr := mrp_atp_pub.number_arr(1);
3231: l_item_sourcing_rec MSC_ATP_CTO.Item_Sourcing_Info_Rec;
3232: l_other_cols order_sch_wb.other_cols_typ;
3233: l_item_id NUMBER;
3234: l_sr_instance_id NUMBER;
3235: l_organization_id NUMBER;
3236: l_customer_id NUMBER;
3900: l_dest_org_id NUMBER,
3901: l_dest_instance_id NUMBER,
3902: counter NUMBER,
3903: x_atp_sources IN OUT NoCopy mrp_atp_pvt.atp_source_typ,
3904: x_other_cols IN OUT NoCopy order_sch_wb.other_cols_typ) IS
3905:
3906: l_from_location_id NUMBER;
3907: l_to_location_id NUMBER;
3908: BEGIN
3951: NVL(MSC_SCATP_PUB.get_default_ship_method(l_from_location_id,
3952: x_atp_sources.instance_id(counter),
3953: l_to_location_id,
3954: l_dest_instance_id,
3955: order_sch_wb.debug_session_id,
3956: l_ship_to_site_use_id),
3957: MSC_SCATP_PUB.get_ship_method(x_atp_sources.organization_id(counter),
3958: x_atp_sources.instance_id(counter),
3959: l_dest_org_id,
3965: l_from_location_id,
3966: x_atp_sources.instance_id(counter),
3967: l_to_location_id,
3968: l_dest_instance_id,
3969: order_sch_wb.debug_session_id,
3970: l_ship_to_site_use_id),
3971: NVL(MSC_SCATP_PUB.get_intransit_time(
3972: x_atp_sources.organization_id(counter),
3973: x_atp_sources.instance_id(counter),
4028: PROCEDURE insert_atp_sources(x_session_id NUMBER,
4029: x_dblink VARCHAR2,
4030: x_calling_inst VARCHAR2,
4031: x_atp_sources mrp_atp_pvt.atp_source_typ,
4032: x_other_cols order_sch_wb.other_cols_typ)
4033: IS
4034: sql_stmt VARCHAR2(32000);
4035: l_dynstring VARCHAR2(129);
4036:
4042: msc_sch_wb.atp_debug('insert_atp_sources: ' || 'inserting sources link '||l_dynstring);
4043: END IF;
4044: END IF;
4045:
4046: order_sch_wb.debug_session_id := x_session_id;
4047: IF PG_DEBUG in ('Y', 'C') THEN
4048: msc_sch_wb.atp_debug('insert_atp_sources: ' || 'inserting sources count = '||x_atp_sources.organization_id.count);
4049: END IF;
4050:
4175: BEGIN
4176: /* p_mode tells from which table to select
4177: 1- summary_so 2- Summary_sd 3- summary_res 4-Summary_sup */
4178:
4179: IF order_sch_wb.mr_debug = 'Y' THEN -- if debug mode is on
4180: IF PG_DEBUG in ('Y', 'C') THEN
4181: msc_sch_wb.atp_debug('**** In SHOW_SUMMARY_QUANTITY Debug mode is on ****');
4182: msc_sch_wb.atp_debug('SHOW_SUMMARY_QUANTITY: ' || 'p_instance_id := ' || p_instance_id);
4183: msc_sch_wb.atp_debug('SHOW_SUMMARY_QUANTITY: ' || 'p_plan_id := ' || p_plan_id);
4266: IF PG_DEBUG in ('Y', 'C') THEN
4267: msc_sch_wb.atp_debug('SHOW_SUMMARY_QUANTITY: ' || 'temp_sd_qty := ' || temp_sd_qty);
4268: msc_sch_wb.atp_debug('**** END SHOW_SUMMARY_QUANTITY ****');
4269: END IF;
4270: END IF; -- IF order_sch_wb.mr_debug = 'Y
4271:
4272: END SHOW_SUMMARY_QUANTITY;
4273:
4274: PROCEDURE GET_ITEM_ATTRIBUTES (p_instance_id IN NUMBER,