DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MSC_ATP_FUNC

Line 1448: /*l_atp_flag := MSC_ATP_FUNC.get_atp_flag(p_instance_id,

1444: G_ITEM_INFO_REC := l_item_attribute_rec;
1445: l_atp_flag := G_ITEM_INFO_REC.atp_flag;
1446: l_atp_comp_flag := G_ITEM_INFO_REC.atp_comp_flag;
1447: /* Modularize Item and Org Info */
1448: /*l_atp_flag := MSC_ATP_FUNC.get_atp_flag(p_instance_id,
1449: l_plan_id,
1450: l_requested_item_id,
1451: l_process_org_id);
1452: Modularize Item and Org Info */

Line 1939: /*l_atp_comp_flag := MSC_ATP_FUNC.get_atp_comp_flag(p_instance_id,

1935:
1936: IF MSC_ATP_PVT.G_INV_CTP = 4 THEN
1937: /* Modularize Item and Org Info */
1938: -- Information already obtained
1939: /*l_atp_comp_flag := MSC_ATP_FUNC.get_atp_comp_flag(p_instance_id,
1940: l_plan_id,
1941: l_requested_item_id,
1942: l_process_org_id);
1943: Modularize Item and Org Info */

Line 2930: l_item_substitute_rec.Family_item_name(l_count) := MSC_ATP_FUNC.Get_Inv_Item_Name(

2926: -- time_phased_atp
2927: IF l_time_phased_atp = 'Y' or l_pf_atp = 'Y' THEN
2928: l_item_substitute_rec.Family_sr_id(l_count) := l_process_item_id;
2929: l_item_substitute_rec.Family_dest_id(l_count) := MSC_ATP_PVT.G_ITEM_INFO_REC.product_family_id;
2930: l_item_substitute_rec.Family_item_name(l_count) := MSC_ATP_FUNC.Get_Inv_Item_Name(
2931: p_instance_id,
2932: l_process_item_id,
2933: l_atp_rec.organization_id
2934: );

Line 3895: MSC_ATP_FUNC.get_inv_item_name(p_instance_id,

3891: l_atp_table.Inventory_Item_Name(i)) ;
3892: ELSE
3893: -- If item has changed then make the call.
3894: l_atp_table.Inventory_Item_Name(i) := NVL(
3895: MSC_ATP_FUNC.get_inv_item_name(p_instance_id,
3896: --- bug 2152184
3897: l_atp_table.inventory_item_id(i),
3898: --l_requested_item_id, -- 1197692
3899: l_atp_rec.organization_id),

Line 3924: MSC_ATP_FUNC.get_org_code(p_instance_id, l_atp_rec.organization_id);

3920: MSC_ATP_PROC.get_global_org_info (p_instance_id,
3921: l_atp_rec.organization_id);
3922: l_atp_table.Source_Organization_Code(i) := G_ORG_INFO_REC.org_code;
3923: /*l_atp_table.Source_Organization_Code(i):=
3924: MSC_ATP_FUNC.get_org_code(p_instance_id, l_atp_rec.organization_id);
3925: Modularize Item and Org Info */
3926: IF PG_DEBUG in ('Y', 'C') THEN
3927: msc_sch_wb.atp_debug ('Schedule: ' || 'after code');
3928: END IF;

Line 6985: MSC_ATP_PVT.G_ALLOCATED_ATP := MSC_ATP_FUNC.check_alloc_exists(p_atp_record.instance_id,

6981: IF PG_DEBUG in ('Y', 'C') THEN
6982: msc_sch_wb.atp_debug('ATP_Check: ' || 'G_HYBRID_ALLOC_ATP is Y');
6983: END IF;
6984:
6985: MSC_ATP_PVT.G_ALLOCATED_ATP := MSC_ATP_FUNC.check_alloc_exists(p_atp_record.instance_id,
6986: -1, --PLAN_ID
6987: p_atp_record.Inventory_Item_Id,
6988: p_atp_record.organization_id,
6989: nvl(p_atp_record.Requested_Arrival_Date, p_atp_record.Requested_Ship_Date));

Line 7378: l_requested_ship_date := MSC_ATP_FUNC.prev_work_day(p_atp_record.organization_id,

7374: (l_atp_flag <> 'N') OR (l_atp_comp_flag <> 'N') THEN */
7375:
7376: /* ship_rec_cal changes begin
7377: -- translate the l_requested_ship_date to a workday.
7378: l_requested_ship_date := MSC_ATP_FUNC.prev_work_day(p_atp_record.organization_id,
7379: p_atp_record.instance_id,
7380: l_requested_ship_date);
7381:
7382: -- bug 1192311

Line 7416: l_sysdate := NVL(MSC_ATP_FUNC.prev_work_day(p_atp_record.organization_id,

7412: NULL;
7413: END;
7414:
7415: /* -- for bug 1124538 : find the prev working date of sysdate
7416: l_sysdate := NVL(MSC_ATP_FUNC.prev_work_day(p_atp_record.organization_id,
7417: p_atp_record.instance_id,
7418: sysdate), sysdate); */
7419:
7420: IF PG_DEBUG in ('Y', 'C') THEN

Line 7646: /*l_atp_insert_rec.inventory_item_id := MSC_ATP_FUNC.get_inv_item_id

7642: -- Re_use Information.
7643: -- time_phased_atp - Now C_ITEM_INFO_REC stores member item info in ODS case
7644: l_atp_insert_rec.inventory_item_id := C_ITEM_INFO_REC.dest_inv_item_id;
7645: -- No need to call function below.
7646: /*l_atp_insert_rec.inventory_item_id := MSC_ATP_FUNC.get_inv_item_id
7647: (p_atp_record.instance_id,
7648: --- 2152184
7649: l_request_item_id,
7650: --p_atp_record.request_item_id,

Line 7720: /*l_inv_item_id := MSC_ATP_FUNC.get_inv_item_id(

7716:
7717: /* Modularize Item and Org Info */
7718: -- Re-Use info instead of making unnecessary call.
7719: l_inv_item_id := C_ITEM_INFO_REC.dest_inv_item_id;
7720: /*l_inv_item_id := MSC_ATP_FUNC.get_inv_item_id(
7721: p_atp_record.instance_id,
7722: p_atp_record.inventory_item_id,
7723: null,
7724: p_atp_record.organization_id);

Line 8075: /*l_inv_item_name := MSC_ATP_FUNC.get_inv_item_name(p_atp_record.instance_id,

8071: END IF;
8072: /* Modularize Item and Org Info */
8073: -- Re-Use info instead of making unnecessary call.
8074: l_inv_item_name := C_ITEM_INFO_REC.item_name;
8075: /*l_inv_item_name := MSC_ATP_FUNC.get_inv_item_name(p_atp_record.instance_id,
8076: p_atp_record.inventory_item_id,
8077: p_atp_record.organization_id);
8078:
8079: Modularize Item and Org Info */

Line 8083: /*l_org_code := MSC_ATP_FUNC.get_org_code(p_atp_record.instance_id,

8079: Modularize Item and Org Info */
8080: MSC_ATP_PROC.get_global_org_info (p_atp_record.instance_id,
8081: p_atp_record.organization_id );
8082: l_org_code := G_ORG_INFO_REC.org_code;
8083: /*l_org_code := MSC_ATP_FUNC.get_org_code(p_atp_record.instance_id,
8084: p_atp_record.organization_id);
8085: Modularize Item and Org Info */
8086: l_atp_date_this_level := null;
8087: --MSC_ATP_PVT.G_DEMAND_PEGGING_ID := p_parent_pegging_id;

Line 8340: l_atp_date_this_level := GREATEST(MSC_ATP_FUNC.get_infinite_time_fence_date(

8336: msc_sch_wb.atp_debug('ATP_Check: ' || 'Initialize atp_date and atp_quantity_this_level');
8337: END IF;
8338:
8339: /* s_cto_rearch: chnage call to MSC_ATP_PROC.get_infinite_time_fence_date procedure
8340: l_atp_date_this_level := GREATEST(MSC_ATP_FUNC.get_infinite_time_fence_date(
8341: p_atp_record.instance_id, p_atp_record.inventory_item_id,
8342: p_atp_record.organization_id,p_plan_id), l_requested_ship_date);
8343: e_cto_rearch*/
8344:

Line 8444: /*l_atp_insert_rec.inventory_item_id := MSC_ATP_FUNC.get_inv_item_id

8440: l_atp_insert_rec.requested_date_quantity := l_requested_date_quantity;
8441: -- time_phased_atp changes end
8442:
8443: -- No need to call function below.
8444: /*l_atp_insert_rec.inventory_item_id := MSC_ATP_FUNC.get_inv_item_id
8445: (p_atp_record.instance_id,
8446: --2152184
8447: --p_atp_record.request_item_id,
8448: l_request_item_id,

Line 8583: /*l_inv_item_name := MSC_ATP_FUNC.get_inv_item_name(p_atp_record.instance_id,

8579:
8580: /* Modularize Item and Org Info */
8581: -- Re-Use info instead of making unnecessary call.
8582: l_inv_item_name := C_ITEM_INFO_REC.item_name;
8583: /*l_inv_item_name := MSC_ATP_FUNC.get_inv_item_name(p_atp_record.instance_id,
8584: p_atp_record.inventory_item_id,
8585: p_atp_record.organization_id);
8586:
8587: Modularize Item and Org Info */

Line 8591: /* l_org_code := MSC_ATP_FUNC.get_org_code(p_atp_record.instance_id,

8587: Modularize Item and Org Info */
8588: MSC_ATP_PROC.get_global_org_info (p_atp_record.instance_id,
8589: p_atp_record.organization_id);
8590: l_org_code := G_ORG_INFO_REC.org_code;
8591: /* l_org_code := MSC_ATP_FUNC.get_org_code(p_atp_record.instance_id,
8592: p_atp_record.organization_id);
8593: Modularize Item and Org Info */
8594:
8595: IF p_search = 1 and p_parent_pegging_id is null THEN

Line 11321: /*l_inv_item_id := MSC_ATP_FUNC.get_inv_item_id(

11317: /* Modularize Item and Org Info */
11318: -- Buy case
11319: -- Re-Use info instead of making unnecessary call.
11320: l_inv_item_id := C_ITEM_INFO_REC.dest_inv_item_id;
11321: /*l_inv_item_id := MSC_ATP_FUNC.get_inv_item_id(
11322: l_atp_rec.instance_id,
11323: l_atp_rec.inventory_item_id,
11324: null,
11325: l_atp_rec.organization_id);

Line 12495: MSC_ATP_FUNC.get_location_id(p_atp_record.instance_id,

12491: l_atp_rec.ship_date := null;
12492: l_atp_rec.action := p_atp_record.action;
12493: l_atp_rec.insert_flag := p_atp_record.insert_flag;
12494: l_atp_rec.to_location_id :=
12495: MSC_ATP_FUNC.get_location_id(p_atp_record.instance_id,
12496: p_atp_record.organization_id,
12497: null,
12498: null,
12499: null,

Line 12657: MSC_ATP_FUNC.get_org_code(p_atp_record.instance_id,

12653: MSC_ATP_PROC.get_global_org_info(p_atp_record.instance_id,
12654: l_pegging_rec.organization_id);
12655: l_pegging_rec.organization_code := MSC_ATP_PVT.G_ORG_INFO_REC.org_code;
12656: /* l_pegging_rec.organization_code :=
12657: MSC_ATP_FUNC.get_org_code(p_atp_record.instance_id,
12658: l_pegging_rec.organization_id);
12659: Modularize Item and Org Info */
12660: END IF;
12661: /* Modularize Item and Org Info */

Line 12683: MSC_ATP_FUNC.get_supplier_name(p_atp_record.instance_id,

12679: l_pegging_rec.supplier_site_name := NULL;
12680: ELSE
12681: l_pegging_rec.supplier_id := l_sources.supplier_id(j);
12682: l_pegging_rec.supplier_name :=
12683: MSC_ATP_FUNC.get_supplier_name(p_atp_record.instance_id,
12684: l_pegging_rec.supplier_id);
12685: l_pegging_rec.supplier_site_id :=
12686: l_sources.supplier_site_id(j);
12687: l_pegging_rec.supplier_site_name :=

Line 12688: MSC_ATP_FUNC.get_supplier_site_name(p_atp_record.instance_id,

12684: l_pegging_rec.supplier_id);
12685: l_pegging_rec.supplier_site_id :=
12686: l_sources.supplier_site_id(j);
12687: l_pegging_rec.supplier_site_name :=
12688: MSC_ATP_FUNC.get_supplier_site_name(p_atp_record.instance_id,
12689: l_pegging_rec.supplier_site_id);
12690: END IF;
12691: END IF;
12692:

Line 14039: -- (ssurendr) Bug 2865389 : Replace call to function MSC_ATP_FUNC.get_process_seq_id

14035: --we do not get process effectivity when checking base model's
14036: -- capacity for config item
14037: IF l_check_model_capacity = 2 THEN
14038: /* Make case Get the Process Sequence ID.*/
14039: -- (ssurendr) Bug 2865389 : Replace call to function MSC_ATP_FUNC.get_process_seq_id
14040: -- by procedure MSC_ATP_PROC.get_process_effectivity
14041: --Details. Derive Item's Start Date by Offsetting
14042: --Due date with LT. Check effectivity on Start Date.
14043: /* ship_rec_cal

Line 14129: MSC_ATP_FUNC.get_org_code(p_atp_record.instance_id,

14125: l_pegging_rec.organization_id :=
14126: p_atp_record.organization_id;
14127: --l_pegging_rec.organization_code := l_org_code;
14128: l_pegging_rec.organization_code :=
14129: MSC_ATP_FUNC.get_org_code(p_atp_record.instance_id,
14130: l_pegging_rec.organization_id);--5222584
14131: l_pegging_rec.identifier1:= p_atp_record.instance_id;
14132: l_pegging_rec.identifier2:= p_plan_id;
14133: l_pegging_rec.identifier3 := l_transaction_id;

Line 16526: /*l_inv_item_name := MSC_ATP_FUNC.get_inv_item_name(p_atp_record.instance_id,

16522: IF PG_DEBUG in ('Y', 'C') THEN
16523: msc_sch_wb.atp_debug('ATP_Check: ' || 'l_inv_item_name := ' || l_inv_item_name);
16524: END IF;
16525:
16526: /*l_inv_item_name := MSC_ATP_FUNC.get_inv_item_name(p_atp_record.instance_id,
16527: p_atp_record.inventory_item_id,
16528: p_atp_record.organization_id);
16529: Modularize Item and Org Info */
16530:

Line 16531: l_supplier_name := MSC_ATP_FUNC.get_supplier_name(p_atp_record.instance_id,

16527: p_atp_record.inventory_item_id,
16528: p_atp_record.organization_id);
16529: Modularize Item and Org Info */
16530:
16531: l_supplier_name := MSC_ATP_FUNC.get_supplier_name(p_atp_record.instance_id,
16532: p_atp_record.supplier_id);
16533: l_supplier_site_name :=
16534: MSC_ATP_FUNC.get_supplier_site_name(p_atp_record.instance_id,
16535: p_atp_record.supplier_site_id);

Line 16534: MSC_ATP_FUNC.get_supplier_site_name(p_atp_record.instance_id,

16530:
16531: l_supplier_name := MSC_ATP_FUNC.get_supplier_name(p_atp_record.instance_id,
16532: p_atp_record.supplier_id);
16533: l_supplier_site_name :=
16534: MSC_ATP_FUNC.get_supplier_site_name(p_atp_record.instance_id,
16535: p_atp_record.supplier_site_id);
16536:
16537: l_pegging_rec.session_id:= MSC_ATP_PVT.G_SESSION_ID;
16538: l_pegging_rec.order_line_id:= MSC_ATP_PVT.G_ORDER_LINE_ID;

Line 18045: l_prev_work_ship_date := MSC_ATP_FUNC.prev_work_day

18041: l_atp_output_table.requested_date_quantity(m) :=
18042: l_atp_output_table.quantity_ordered(m);
18043: END IF;
18044: /* Bug 3449812 - l_prev_work_ship_date not required as ship date has already been validated
18045: l_prev_work_ship_date := MSC_ATP_FUNC.prev_work_day
18046: (x_atp_table.source_organization_id(m),
18047: p_instance_id,
18048: x_atp_table.ship_date(m));
18049: