[Home] [Help]
619: msc_sch_wb.atp_debug('Atp_Sources: ' || 'we are in ship set and receiving party is customer');
620: END IF;
621:
622: -- rmehra Replaced views by procedure for bug 2585710
623: MSC_ATP_PROC.Get_Sources_Info(order_sch_wb.debug_session_id, null, l_customer_id,
624: p_customer_site_id, p_assign_set_id, l_count, x_atp_sources, l_return_status,
625: p_partner_type, p_party_site_id, p_order_line_id ); --2814895
626:
627: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
798: -- ngoel 9/26/2001, since view msc_scatp_sources_v resolves the hierarchy,
799: -- no need to have either union all or separate clause for customer site and region
800:
801: -- bug 2585710. Replaced views by procedure
802: MSC_ATP_PROC.Get_Sources_Info(order_sch_wb.debug_session_id, l_inv_item_id, l_customer_id,
803: p_customer_site_id, p_assign_set_id, null, x_atp_sources, l_return_status,
804: p_partner_type, p_party_site_id, p_order_line_id ); --2814895
805:
806: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3219: l_request_item_id NUMBER := NULL;
3220: l_sources mrp_atp_pvt.atp_source_typ;
3221: l_item_arr mrp_atp_pub.number_arr := mrp_atp_pub.number_arr(1);
3222: l_item_sourcing_rec MSC_ATP_CTO.Item_Sourcing_Info_Rec;
3223: l_other_cols order_sch_wb.other_cols_typ;
3224: l_item_id NUMBER;
3225: l_sr_instance_id NUMBER;
3226: l_organization_id NUMBER;
3227: l_customer_id NUMBER;
3891: l_dest_org_id NUMBER,
3892: l_dest_instance_id NUMBER,
3893: counter NUMBER,
3894: x_atp_sources IN OUT NoCopy mrp_atp_pvt.atp_source_typ,
3895: x_other_cols IN OUT NoCopy order_sch_wb.other_cols_typ) IS
3896:
3897: l_from_location_id NUMBER;
3898: l_to_location_id NUMBER;
3899: BEGIN
3942: NVL(MSC_SCATP_PUB.get_default_ship_method(l_from_location_id,
3943: x_atp_sources.instance_id(counter),
3944: l_to_location_id,
3945: l_dest_instance_id,
3946: order_sch_wb.debug_session_id,
3947: l_ship_to_site_use_id),
3948: MSC_SCATP_PUB.get_ship_method(x_atp_sources.organization_id(counter),
3949: x_atp_sources.instance_id(counter),
3950: l_dest_org_id,
3956: l_from_location_id,
3957: x_atp_sources.instance_id(counter),
3958: l_to_location_id,
3959: l_dest_instance_id,
3960: order_sch_wb.debug_session_id,
3961: l_ship_to_site_use_id),
3962: NVL(MSC_SCATP_PUB.get_intransit_time(
3963: x_atp_sources.organization_id(counter),
3964: x_atp_sources.instance_id(counter),
4019: PROCEDURE insert_atp_sources(x_session_id NUMBER,
4020: x_dblink VARCHAR2,
4021: x_calling_inst VARCHAR2,
4022: x_atp_sources mrp_atp_pvt.atp_source_typ,
4023: x_other_cols order_sch_wb.other_cols_typ)
4024: IS
4025: sql_stmt VARCHAR2(32000);
4026: l_dynstring VARCHAR2(129);
4027:
4033: msc_sch_wb.atp_debug('insert_atp_sources: ' || 'inserting sources link '||l_dynstring);
4034: END IF;
4035: END IF;
4036:
4037: order_sch_wb.debug_session_id := x_session_id;
4038: IF PG_DEBUG in ('Y', 'C') THEN
4039: msc_sch_wb.atp_debug('insert_atp_sources: ' || 'inserting sources count = '||x_atp_sources.organization_id.count);
4040: END IF;
4041:
4166: BEGIN
4167: /* p_mode tells from which table to select
4168: 1- summary_so 2- Summary_sd 3- summary_res 4-Summary_sup */
4169:
4170: IF order_sch_wb.mr_debug = 'Y' THEN -- if debug mode is on
4171: IF PG_DEBUG in ('Y', 'C') THEN
4172: msc_sch_wb.atp_debug('**** In SHOW_SUMMARY_QUANTITY Debug mode is on ****');
4173: msc_sch_wb.atp_debug('SHOW_SUMMARY_QUANTITY: ' || 'p_instance_id := ' || p_instance_id);
4174: msc_sch_wb.atp_debug('SHOW_SUMMARY_QUANTITY: ' || 'p_plan_id := ' || p_plan_id);
4257: IF PG_DEBUG in ('Y', 'C') THEN
4258: msc_sch_wb.atp_debug('SHOW_SUMMARY_QUANTITY: ' || 'temp_sd_qty := ' || temp_sd_qty);
4259: msc_sch_wb.atp_debug('**** END SHOW_SUMMARY_QUANTITY ****');
4260: END IF;
4261: END IF; -- IF order_sch_wb.mr_debug = 'Y
4262:
4263: END SHOW_SUMMARY_QUANTITY;
4264:
4265: PROCEDURE GET_ITEM_ATTRIBUTES (p_instance_id IN NUMBER,