DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MSC_ATP_FUNC

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

1399: G_ITEM_INFO_REC := l_item_attribute_rec;
1400: l_atp_flag := G_ITEM_INFO_REC.atp_flag;
1401: l_atp_comp_flag := G_ITEM_INFO_REC.atp_comp_flag;
1402: /* Modularize Item and Org Info */
1403: /*l_atp_flag := MSC_ATP_FUNC.get_atp_flag(p_instance_id,
1404: l_plan_id,
1405: l_requested_item_id,
1406: l_process_org_id);
1407: Modularize Item and Org Info */

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

1871:
1872: IF MSC_ATP_PVT.G_INV_CTP = 4 THEN
1873: /* Modularize Item and Org Info */
1874: -- Information already obtained
1875: /*l_atp_comp_flag := MSC_ATP_FUNC.get_atp_comp_flag(p_instance_id,
1876: l_plan_id,
1877: l_requested_item_id,
1878: l_process_org_id);
1879: Modularize Item and Org Info */

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

2668: -- time_phased_atp
2669: IF l_time_phased_atp = 'Y' or l_pf_atp = 'Y' THEN
2670: l_item_substitute_rec.Family_sr_id(l_count) := l_process_item_id;
2671: l_item_substitute_rec.Family_dest_id(l_count) := MSC_ATP_PVT.G_ITEM_INFO_REC.product_family_id;
2672: l_item_substitute_rec.Family_item_name(l_count) := MSC_ATP_FUNC.Get_Inv_Item_Name(
2673: p_instance_id,
2674: l_process_item_id,
2675: l_atp_rec.organization_id
2676: );

Line 3304: MSC_ATP_FUNC.get_inv_item_name(p_instance_id,

3300: l_atp_table.Inventory_Item_Name(i)) ;
3301: ELSE
3302: -- If item has changed then make the call.
3303: l_atp_table.Inventory_Item_Name(i) := NVL(
3304: MSC_ATP_FUNC.get_inv_item_name(p_instance_id,
3305: --- bug 2152184
3306: l_atp_table.inventory_item_id(i),
3307: --l_requested_item_id, -- 1197692
3308: l_atp_rec.organization_id),

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

3329: MSC_ATP_PROC.get_global_org_info (p_instance_id,
3330: l_atp_rec.organization_id);
3331: l_atp_table.Source_Organization_Code(i) := G_ORG_INFO_REC.org_code;
3332: /*l_atp_table.Source_Organization_Code(i):=
3333: MSC_ATP_FUNC.get_org_code(p_instance_id, l_atp_rec.organization_id);
3334: Modularize Item and Org Info */
3335: IF PG_DEBUG in ('Y', 'C') THEN
3336: msc_sch_wb.atp_debug ('Schedule: ' || 'after code');
3337: END IF;

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

6740: (l_atp_flag <> 'N') OR (l_atp_comp_flag <> 'N') THEN */
6741:
6742: /* ship_rec_cal changes begin
6743: -- translate the l_requested_ship_date to a workday.
6744: l_requested_ship_date := MSC_ATP_FUNC.prev_work_day(p_atp_record.organization_id,
6745: p_atp_record.instance_id,
6746: l_requested_ship_date);
6747:
6748: -- bug 1192311

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

6778: NULL;
6779: END;
6780:
6781: /* -- for bug 1124538 : find the prev working date of sysdate
6782: l_sysdate := NVL(MSC_ATP_FUNC.prev_work_day(p_atp_record.organization_id,
6783: p_atp_record.instance_id,
6784: sysdate), sysdate); */
6785:
6786: IF PG_DEBUG in ('Y', 'C') THEN

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

7008: -- Re_use Information.
7009: -- time_phased_atp - Now C_ITEM_INFO_REC stores member item info in ODS case
7010: l_atp_insert_rec.inventory_item_id := C_ITEM_INFO_REC.dest_inv_item_id;
7011: -- No need to call function below.
7012: /*l_atp_insert_rec.inventory_item_id := MSC_ATP_FUNC.get_inv_item_id
7013: (p_atp_record.instance_id,
7014: --- 2152184
7015: l_request_item_id,
7016: --p_atp_record.request_item_id,

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

7082:
7083: /* Modularize Item and Org Info */
7084: -- Re-Use info instead of making unnecessary call.
7085: l_inv_item_id := C_ITEM_INFO_REC.dest_inv_item_id;
7086: /*l_inv_item_id := MSC_ATP_FUNC.get_inv_item_id(
7087: p_atp_record.instance_id,
7088: p_atp_record.inventory_item_id,
7089: null,
7090: p_atp_record.organization_id);

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

7437: END IF;
7438: /* Modularize Item and Org Info */
7439: -- Re-Use info instead of making unnecessary call.
7440: l_inv_item_name := C_ITEM_INFO_REC.item_name;
7441: /*l_inv_item_name := MSC_ATP_FUNC.get_inv_item_name(p_atp_record.instance_id,
7442: p_atp_record.inventory_item_id,
7443: p_atp_record.organization_id);
7444:
7445: Modularize Item and Org Info */

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

7445: Modularize Item and Org Info */
7446: MSC_ATP_PROC.get_global_org_info (p_atp_record.instance_id,
7447: p_atp_record.organization_id );
7448: l_org_code := G_ORG_INFO_REC.org_code;
7449: /*l_org_code := MSC_ATP_FUNC.get_org_code(p_atp_record.instance_id,
7450: p_atp_record.organization_id);
7451: Modularize Item and Org Info */
7452: l_atp_date_this_level := null;
7453: --MSC_ATP_PVT.G_DEMAND_PEGGING_ID := p_parent_pegging_id;

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

7702: msc_sch_wb.atp_debug('ATP_Check: ' || 'Initialize atp_date and atp_quantity_this_level');
7703: END IF;
7704:
7705: /* s_cto_rearch: chnage call to MSC_ATP_PROC.get_infinite_time_fence_date procedure
7706: l_atp_date_this_level := GREATEST(MSC_ATP_FUNC.get_infinite_time_fence_date(
7707: p_atp_record.instance_id, p_atp_record.inventory_item_id,
7708: p_atp_record.organization_id,p_plan_id), l_requested_ship_date);
7709: e_cto_rearch*/
7710:

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

7806: l_atp_insert_rec.requested_date_quantity := l_requested_date_quantity;
7807: -- time_phased_atp changes end
7808:
7809: -- No need to call function below.
7810: /*l_atp_insert_rec.inventory_item_id := MSC_ATP_FUNC.get_inv_item_id
7811: (p_atp_record.instance_id,
7812: --2152184
7813: --p_atp_record.request_item_id,
7814: l_request_item_id,

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

7928:
7929: /* Modularize Item and Org Info */
7930: -- Re-Use info instead of making unnecessary call.
7931: l_inv_item_name := C_ITEM_INFO_REC.item_name;
7932: /*l_inv_item_name := MSC_ATP_FUNC.get_inv_item_name(p_atp_record.instance_id,
7933: p_atp_record.inventory_item_id,
7934: p_atp_record.organization_id);
7935:
7936: Modularize Item and Org Info */

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

7936: Modularize Item and Org Info */
7937: MSC_ATP_PROC.get_global_org_info (p_atp_record.instance_id,
7938: p_atp_record.organization_id);
7939: l_org_code := G_ORG_INFO_REC.org_code;
7940: /* l_org_code := MSC_ATP_FUNC.get_org_code(p_atp_record.instance_id,
7941: p_atp_record.organization_id);
7942: Modularize Item and Org Info */
7943:
7944: IF p_search = 1 and p_parent_pegging_id is null THEN

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

10595: /* Modularize Item and Org Info */
10596: -- Buy case
10597: -- Re-Use info instead of making unnecessary call.
10598: l_inv_item_id := C_ITEM_INFO_REC.dest_inv_item_id;
10599: /*l_inv_item_id := MSC_ATP_FUNC.get_inv_item_id(
10600: l_atp_rec.instance_id,
10601: l_atp_rec.inventory_item_id,
10602: null,
10603: l_atp_rec.organization_id);

Line 11740: MSC_ATP_FUNC.get_location_id(p_atp_record.instance_id,

11736: l_atp_rec.ship_date := null;
11737: l_atp_rec.action := p_atp_record.action;
11738: l_atp_rec.insert_flag := p_atp_record.insert_flag;
11739: l_atp_rec.to_location_id :=
11740: MSC_ATP_FUNC.get_location_id(p_atp_record.instance_id,
11741: p_atp_record.organization_id,
11742: null,
11743: null,
11744: null,

Line 11902: MSC_ATP_FUNC.get_org_code(p_atp_record.instance_id,

11898: MSC_ATP_PROC.get_global_org_info(p_atp_record.instance_id,
11899: l_pegging_rec.organization_id);
11900: l_pegging_rec.organization_code := MSC_ATP_PVT.G_ORG_INFO_REC.org_code;
11901: /* l_pegging_rec.organization_code :=
11902: MSC_ATP_FUNC.get_org_code(p_atp_record.instance_id,
11903: l_pegging_rec.organization_id);
11904: Modularize Item and Org Info */
11905: END IF;
11906: /* Modularize Item and Org Info */

Line 11928: MSC_ATP_FUNC.get_supplier_name(p_atp_record.instance_id,

11924: l_pegging_rec.supplier_site_name := NULL;
11925: ELSE
11926: l_pegging_rec.supplier_id := l_sources.supplier_id(j);
11927: l_pegging_rec.supplier_name :=
11928: MSC_ATP_FUNC.get_supplier_name(p_atp_record.instance_id,
11929: l_pegging_rec.supplier_id);
11930: l_pegging_rec.supplier_site_id :=
11931: l_sources.supplier_site_id(j);
11932: l_pegging_rec.supplier_site_name :=

Line 11933: MSC_ATP_FUNC.get_supplier_site_name(p_atp_record.instance_id,

11929: l_pegging_rec.supplier_id);
11930: l_pegging_rec.supplier_site_id :=
11931: l_sources.supplier_site_id(j);
11932: l_pegging_rec.supplier_site_name :=
11933: MSC_ATP_FUNC.get_supplier_site_name(p_atp_record.instance_id,
11934: l_pegging_rec.supplier_site_id);
11935: END IF;
11936: END IF;
11937:

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

13238: --we do not get process effectivity when checking base model's
13239: -- capacity for config item
13240: IF l_check_model_capacity = 2 THEN
13241: /* Make case Get the Process Sequence ID.*/
13242: -- (ssurendr) Bug 2865389 : Replace call to function MSC_ATP_FUNC.get_process_seq_id
13243: -- by procedure MSC_ATP_PROC.get_process_effectivity
13244: --Details. Derive Item's Start Date by Offsetting
13245: --Due date with LT. Check effectivity on Start Date.
13246: /* ship_rec_cal

Line 13332: MSC_ATP_FUNC.get_org_code(p_atp_record.instance_id,

13328: l_pegging_rec.organization_id :=
13329: p_atp_record.organization_id;
13330: --l_pegging_rec.organization_code := l_org_code;
13331: l_pegging_rec.organization_code :=
13332: MSC_ATP_FUNC.get_org_code(p_atp_record.instance_id,
13333: l_pegging_rec.organization_id);--5222584
13334: l_pegging_rec.identifier1:= p_atp_record.instance_id;
13335: l_pegging_rec.identifier2:= p_plan_id;
13336: l_pegging_rec.identifier3 := l_transaction_id;

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

15671: IF PG_DEBUG in ('Y', 'C') THEN
15672: msc_sch_wb.atp_debug('ATP_Check: ' || 'l_inv_item_name := ' || l_inv_item_name);
15673: END IF;
15674:
15675: /*l_inv_item_name := MSC_ATP_FUNC.get_inv_item_name(p_atp_record.instance_id,
15676: p_atp_record.inventory_item_id,
15677: p_atp_record.organization_id);
15678: Modularize Item and Org Info */
15679:

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

15676: p_atp_record.inventory_item_id,
15677: p_atp_record.organization_id);
15678: Modularize Item and Org Info */
15679:
15680: l_supplier_name := MSC_ATP_FUNC.get_supplier_name(p_atp_record.instance_id,
15681: p_atp_record.supplier_id);
15682: l_supplier_site_name :=
15683: MSC_ATP_FUNC.get_supplier_site_name(p_atp_record.instance_id,
15684: p_atp_record.supplier_site_id);

Line 15683: MSC_ATP_FUNC.get_supplier_site_name(p_atp_record.instance_id,

15679:
15680: l_supplier_name := MSC_ATP_FUNC.get_supplier_name(p_atp_record.instance_id,
15681: p_atp_record.supplier_id);
15682: l_supplier_site_name :=
15683: MSC_ATP_FUNC.get_supplier_site_name(p_atp_record.instance_id,
15684: p_atp_record.supplier_site_id);
15685:
15686: l_pegging_rec.session_id:= MSC_ATP_PVT.G_SESSION_ID;
15687: l_pegging_rec.order_line_id:= MSC_ATP_PVT.G_ORDER_LINE_ID;

Line 17180: l_prev_work_ship_date := MSC_ATP_FUNC.prev_work_day

17176: x_atp_table.requested_date_quantity(m) :=
17177: x_atp_table.quantity_ordered(m);
17178: END IF;
17179: /* Bug 3449812 - l_prev_work_ship_date not required as ship date has already been validated
17180: l_prev_work_ship_date := MSC_ATP_FUNC.prev_work_day
17181: (x_atp_table.source_organization_id(m),
17182: p_instance_id,
17183: x_atp_table.ship_date(m));
17184: