DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on MSC_ATP_FUNC

Line 428: MSC_ATP_FUNC.get_inv_item_id(p_instance_id,

424:
425: -- Get the dest inv item id and store that it in l_dest_ship_set_item_list
426: l_dest_ship_set_item_list.EXTEND;
427: l_dest_ship_set_item_list(l_dest_ship_set_item_list.COUNT) :=
428: MSC_ATP_FUNC.get_inv_item_id(p_instance_id,
429: p_item_sourcing_info_rec.sr_inventory_item_id(i),
430: p_item_sourcing_info_rec.match_item_id(i),
431: --p_ship_set_item(i),
432: p_organization_id);

Line 503: MSC_ATP_FUNC.get_inv_item_id(p_instance_id,

499:
500: -- Get the dest inv item id and store that it in l_dest_ship_set_item_list
501: l_dest_ship_set_item_list.EXTEND;
502: l_dest_ship_set_item_list(l_dest_ship_set_item_list.COUNT) :=
503: MSC_ATP_FUNC.get_inv_item_id(p_instance_id,
504: --p_ship_set_item(i),
505: p_item_sourcing_info_rec.sr_inventory_item_id(i),
506: p_item_sourcing_info_rec.match_item_id(i),
507: p_organization_id);

Line 562: l_inv_item_id := MSC_ATP_FUNC.get_inv_item_id (p_instance_id,

558: IF PG_DEBUG in ('Y', 'C') THEN
559: msc_sch_wb.atp_debug('Atp_Sources: ' || 'Request is for single line item and not ship set');
560: END IF;
561:
562: l_inv_item_id := MSC_ATP_FUNC.get_inv_item_id (p_instance_id,
563: --p_inventory_item_id,
564: --s_cto_rearch
565: p_item_sourcing_info_rec.sr_inventory_item_id(1),
566: p_item_sourcing_info_rec.match_item_id(1),

Line 3020: l_process_seq_id := MSC_ATP_FUNC.get_process_seq_id(

3016: msc_sch_wb.atp_debug('Add_Coproducts: ' || 'coproduct date = ' || p_request_date);
3017: END IF;
3018: /* rajjain 02/19/2003 Bug 2788302 Begin
3019: * get Process Sequence ID */
3020: l_process_seq_id := MSC_ATP_FUNC.get_process_seq_id(
3021: p_plan_id,
3022: l_coproducts_rec.inventory_item_id(rec_count),
3023: p_org_id,
3024: p_instance_id,

Line 3598: msc_atp_func.get_location_id(l_sr_instance_id,

3594: l_sources,
3595: l_other_cols);
3596:
3597: l_to_location_id :=
3598: msc_atp_func.get_location_id(l_sr_instance_id,
3599: l_organization_id,
3600: l_customer_id,
3601: l_customer_site_id,
3602: l_sources.supplier_id(counter), l_sources.supplier_site_id(counter));

Line 3614: msc_atp_func.get_location_id (p_instance_id => l_sources.instance_id(counter),

3610: -- cnazarma need to have l_from_location_id since org_id
3611: --might be diff from its location_id Bug #2422940
3612:
3613: l_from_location_id :=
3614: msc_atp_func.get_location_id (p_instance_id => l_sources.instance_id(counter),
3615: p_organization_id => l_sources.organization_id(counter),
3616: p_customer_id => NULL,
3617: p_customer_site_id => NULL,
3618: p_supplier_id => NULL,

Line 3922: msc_atp_func.get_location_id (p_instance_id => l_dest_instance_id,

3918: || ' find the ship_method and intransit LT');
3919: END IF;
3920:
3921: l_from_location_id :=
3922: msc_atp_func.get_location_id (p_instance_id => l_dest_instance_id,
3923: p_organization_id => x_atp_sources.organization_id(counter),
3924: p_customer_id => NULL,
3925: p_customer_site_id => NULL,
3926: p_supplier_id => NULL,

Line 3936: msc_atp_func.get_location_id(p_instance_id => l_dest_instance_id,

3932: END IF;
3933:
3934: -- find the to_location_id
3935: l_to_location_id :=
3936: msc_atp_func.get_location_id(p_instance_id => l_dest_instance_id,
3937: p_organization_id => l_dest_org_id,
3938: p_customer_id => l_customer_id,
3939: p_customer_site_id => l_ship_to_site_use_id,
3940: p_supplier_id => NULL,

Line 5043: l_from_location_id := MSC_ATP_FUNC.get_location_id ( p_from_instance_id,

5039: -----------------------------------------------------------
5040: --else -- p_to_org_id is not NULL
5041: elsif p_to_customer_site_id is NOT NULL then
5042: -- Bug 3515520, verify that customer site is populated.
5043: l_from_location_id := MSC_ATP_FUNC.get_location_id ( p_from_instance_id,
5044: p_from_organization_id,
5045: NULL,
5046: NULL,
5047: NULL,

Line 5051: l_to_location_id := MSC_ATP_FUNC.get_location_id ( p_to_instance_id,

5047: NULL,
5048: NULL
5049: );
5050:
5051: l_to_location_id := MSC_ATP_FUNC.get_location_id ( p_to_instance_id,
5052: NULL,
5053: p_to_customer_id,
5054: p_to_customer_site_id,
5055: NULL,

Line 8802: l_to_loc_id := MSC_ATP_FUNC.get_location_id(

8798: END IF;
8799:
8800: IF l_to_loc_id IS NULL THEN
8801: IF p_customer_id IS NOT NULL AND p_customer_site_id IS NOT NULL THEN
8802: l_to_loc_id := MSC_ATP_FUNC.get_location_id(
8803: p_instance_id,
8804: NULL,
8805: p_customer_id,
8806: p_customer_site_id,

Line 8812: l_to_loc_id := MSC_ATP_FUNC.get_location_id(

8808: NULL);
8809: --ELSE
8810: ELSIF p_to_org_id IS NOT NULL AND (p_customer_id is NULL AND p_customer_site_id IS NULL) THEN
8811: -- Bug 3515520, don't use org in case customer/site is populated.
8812: l_to_loc_id := MSC_ATP_FUNC.get_location_id(
8813: p_to_instance_id,--bug 7382923
8814: p_to_org_id,
8815: NULL,
8816: NULL,

Line 8832: l_from_loc_id := MSC_ATP_FUNC.get_location_id(p_instance_id,

8828:
8829: IF l_from_loc_id IS NULL AND p_from_org_id IS NOT NULL THEN
8830: -- For supplier intransit LT project
8831: -- call get_location only when from_org is passsed
8832: l_from_loc_id := MSC_ATP_FUNC.get_location_id(p_instance_id,
8833: p_from_org_id,
8834: NULL,
8835: NULL,
8836: p_supplier_id,