DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on MSC_ATP_FUNC

Line 427: MSC_ATP_FUNC.get_inv_item_id(p_instance_id,

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

Line 502: MSC_ATP_FUNC.get_inv_item_id(p_instance_id,

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

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

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

Line 3012: l_process_seq_id := MSC_ATP_FUNC.get_process_seq_id(

3008: msc_sch_wb.atp_debug('Add_Coproducts: ' || 'coproduct date = ' || p_request_date);
3009: END IF;
3010: /* rajjain 02/19/2003 Bug 2788302 Begin
3011: * get Process Sequence ID */
3012: l_process_seq_id := MSC_ATP_FUNC.get_process_seq_id(
3013: p_plan_id,
3014: l_coproducts_rec.inventory_item_id(rec_count),
3015: p_org_id,
3016: p_instance_id,

Line 3589: msc_atp_func.get_location_id(l_sr_instance_id,

3585: l_sources,
3586: l_other_cols);
3587:
3588: l_to_location_id :=
3589: msc_atp_func.get_location_id(l_sr_instance_id,
3590: l_organization_id,
3591: l_customer_id,
3592: l_customer_site_id,
3593: l_sources.supplier_id(counter), l_sources.supplier_site_id(counter));

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

3601: -- cnazarma need to have l_from_location_id since org_id
3602: --might be diff from its location_id Bug #2422940
3603:
3604: l_from_location_id :=
3605: msc_atp_func.get_location_id (p_instance_id => l_sources.instance_id(counter),
3606: p_organization_id => l_sources.organization_id(counter),
3607: p_customer_id => NULL,
3608: p_customer_site_id => NULL,
3609: p_supplier_id => NULL,

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

3909: || ' find the ship_method and intransit LT');
3910: END IF;
3911:
3912: l_from_location_id :=
3913: msc_atp_func.get_location_id (p_instance_id => l_dest_instance_id,
3914: p_organization_id => x_atp_sources.organization_id(counter),
3915: p_customer_id => NULL,
3916: p_customer_site_id => NULL,
3917: p_supplier_id => NULL,

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

3923: END IF;
3924:
3925: -- find the to_location_id
3926: l_to_location_id :=
3927: msc_atp_func.get_location_id(p_instance_id => l_dest_instance_id,
3928: p_organization_id => l_dest_org_id,
3929: p_customer_id => l_customer_id,
3930: p_customer_site_id => l_ship_to_site_use_id,
3931: p_supplier_id => NULL,

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

5030: -----------------------------------------------------------
5031: --else -- p_to_org_id is not NULL
5032: elsif p_to_customer_site_id is NOT NULL then
5033: -- Bug 3515520, verify that customer site is populated.
5034: l_from_location_id := MSC_ATP_FUNC.get_location_id ( p_from_instance_id,
5035: p_from_organization_id,
5036: NULL,
5037: NULL,
5038: NULL,

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

5038: NULL,
5039: NULL
5040: );
5041:
5042: l_to_location_id := MSC_ATP_FUNC.get_location_id ( p_to_instance_id,
5043: NULL,
5044: p_to_customer_id,
5045: p_to_customer_site_id,
5046: NULL,

Line 8791: l_to_loc_id := MSC_ATP_FUNC.get_location_id(

8787: END IF;
8788:
8789: IF l_to_loc_id IS NULL THEN
8790: IF p_customer_id IS NOT NULL AND p_customer_site_id IS NOT NULL THEN
8791: l_to_loc_id := MSC_ATP_FUNC.get_location_id(
8792: p_instance_id,
8793: NULL,
8794: p_customer_id,
8795: p_customer_site_id,

Line 8801: l_to_loc_id := MSC_ATP_FUNC.get_location_id(

8797: NULL);
8798: --ELSE
8799: ELSIF p_to_org_id IS NOT NULL AND (p_customer_id is NULL AND p_customer_site_id IS NULL) THEN
8800: -- Bug 3515520, don't use org in case customer/site is populated.
8801: l_to_loc_id := MSC_ATP_FUNC.get_location_id(
8802: p_instance_id,
8803: p_to_org_id,
8804: NULL,
8805: NULL,

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

8817:
8818: IF l_from_loc_id IS NULL AND p_from_org_id IS NOT NULL THEN
8819: -- For supplier intransit LT project
8820: -- call get_location only when from_org is passsed
8821: l_from_loc_id := MSC_ATP_FUNC.get_location_id(p_instance_id,
8822: p_from_org_id,
8823: NULL,
8824: NULL,
8825: p_supplier_id,