[Home] [Help]
353: x_return_status OUT NOCOPY VARCHAR2)
354: IS
355: -- local variables
356: l_inv_item_id PLS_INTEGER;
357: l_inv_item_name MSC_SYSTEM_ITEMS.ITEM_NAME%TYPE;
358: l_uom_code VARCHAR2(3);
359: l_dc_list_tab MRP_ATP_PUB.char80_arr;
360: l_dc_start_index MRP_ATP_PUB.number_arr;
361: l_dc_end_index MRP_ATP_PUB.number_arr;
392: --bug3700564 added family name
393: l_family_name VARCHAR2(250);
394: -- Bug 3823042
395: l_sys_next_date DATE;
396: l_item_name_to_use MSC_SYSTEM_ITEMS.ITEM_NAME%TYPE; --Bug 3823042
397: l_null_date DATE; -- Bug 3875786
398: l_null_char VARCHAR2(1); --Bug 3875786
399:
400: BEGIN
414: /* To support new logic for dependent demands allocation in time phased PF rule based AATP scenarios
415: Reset global variable*/
416: MSC_ATP_PVT.G_TIME_PHASED_PF_ENABLED := 'N';
417:
418: -- Get inventory_item_id and uom_code from msc_system_items
419: BEGIN
420: -- bug 2763784 (ssurendr)
421: -- Get the rounding control type as well
422: -- bug 2813095 (ssurendr)
428: INTO l_inv_item_id, l_uom_code,
429: l_inv_item_name,
430: l_org_code, l_atp_flag
431: --, G_ROUNDING_CONTROL_FLAG
432: FROM msc_system_items msi,
433: msc_trading_partners mtp
434: WHERE msi.plan_id = p_plan_id
435: AND msi.sr_instance_id = p_instance_id
436: AND msi.organization_id = p_organization_id
440: AND mtp.partner_type=3;
441: EXCEPTION
442: WHEN OTHERS THEN
443: IF PG_DEBUG in ('Y', 'C') THEN
444: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'Error selecting inventory item id from msc_system_items: ' || to_char(sqlcode) || ':' || SQLERRM);
445: END IF;
446: Set_Error(MSC_ATP_PVT.ATP_PROCESSING_ERROR);
447: x_return_status := FND_API.G_RET_STS_ERROR;
448: return;
603: l_pf_dest_id,
604: p_inventory_item_id,
605: l_pf_sr_id,
606: p_organization_id,
607: --bug3671294 now we donot need this as we will join with msc_system_items
608: --l_inv_item_name,
609: l_org_code,
610: p_instance_id,
611: p_plan_id,
1053: l_pf_dest_id,
1054: p_inventory_item_id,
1055: l_pf_sr_id,
1056: p_organization_id,
1057: --bug3671294 now we donot need this as we will join with msc_system_items
1058: --l_inv_item_name,
1059: l_org_code,
1060: p_instance_id,
1061: p_plan_id,
2038: l_pf_dest_id,
2039: p_inventory_item_id,
2040: l_pf_sr_id,
2041: p_organization_id,
2042: --bug3671294 now we donot need this as we will join with msc_system_items
2043: --l_inv_item_name,
2044: l_org_code,
2045: p_instance_id,
2046: p_plan_id,
3624: p_dest_family_item_id)))
3625: WHERE madt.Record_Type = 1
3626: AND madt.Session_Id = p_session_id;
3627: ELSE
3628: /* Removed join with msc_system_items as part of New allocation logic for time phased ATP changes*/
3629: UPDATE MRP_ATP_DETAILS_TEMP madt
3630: --rajjain 02/13/2003 Bug 2795636
3631: --SET (Allocation_Percent, Actual_Allocation_Percent)=
3632: SET (Actual_Allocation_Percent, Allocation_Percent)=
4293: p_dest_family_item_id)))
4294: WHERE madt.Record_Type = 1
4295: AND madt.Session_Id = p_session_id;
4296: ELSE
4297: /* Removed join with msc_system_items as part of New allocation logic for time phased ATP changes*/
4298: UPDATE MRP_ATP_DETAILS_TEMP madt
4299: --rajjain 02/13/2003 Bug 2795636
4300: --SET (Allocation_Percent, Actual_Allocation_Percent)=
4301: SET (Actual_Allocation_Percent, Allocation_Percent)=