eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.MSC_ATP_DB_UTILS dependencies on MSC_ATP_UTILS

Line 122: MSC_ATP_UTILS.Truncate_Demand(p_atp_rec.quantity_ordered), --5598066

118: p_atp_rec.demand_source_type,
119: p_atp_rec.demand_source_header_id,
120: p_atp_rec.demand_source_line,
121: p_atp_rec.demand_source_delivery,
122: MSC_ATP_UTILS.Truncate_Demand(p_atp_rec.quantity_ordered), --5598066
123: 0,
124: 1,
125: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY , -- For bug 2259824
126: sysdate,

Line 396: MSC_ATP_UTILS.Truncate_Demand(p_atp_rec.quantity_ordered), -- 5598066

392: ARRIVAL_SET_NAME --bug3263368
393: )
394: VALUES(
395: msc_demands_s.nextval,
396: MSC_ATP_UTILS.Truncate_Demand(p_atp_rec.quantity_ordered), -- 5598066
397: -- start changes for plan by request date
398: decode(p_atp_rec.origination_type,
399: 6, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
400: 30, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

Line 558: MSC_ATP_UTILS.Truncate_Demand(p_atp_rec.quantity_ordered), -- 5598066

554: p_atp_rec.demand_class,
555: p_atp_rec.demand_source_type,--CMRO
556: p_atp_rec.requested_ship_date, -- QUESTION arrival items ?
557: x_demand_id,
558: MSC_ATP_UTILS.Truncate_Demand(p_atp_rec.quantity_ordered), -- 5598066
559: p_atp_rec.origination_type,
560: -- rajjain 04/25/2003 Bug 2770175 populate order_number column with the
561:
562: --decode(p_atp_rec.origination_type, 1, x_demand_id, p_atp_rec.order_number),

Line 1661: MSC_ATP_UTILS.Truncate_Demand(l_ins_qty_tab(i)), -- 5598066

1657: CREATED_BY,
1658: RECORD_SOURCE,
1659: REFRESH_NUMBER)
1660: VALUES (l_copy_demand_id(i),
1661: MSC_ATP_UTILS.Truncate_Demand(l_ins_qty_tab(i)), -- 5598066
1662: l_ins_date_tab(i),
1663: 1, -- Discrete
1664: 52, -- Copy sales order
1665: i_ins_item_id_tab(i),

Line 2008: MSC_ATP_UTILS.Truncate_Demand(l_ins_qty_tab(i)), --5598066

2004: p_instance_id,
2005: l_ins_demand_class_tab(i),
2006: l_ins_date_tab(i),
2007: l_copy_demand_id(i), -- parent demand id
2008: MSC_ATP_UTILS.Truncate_Demand(l_ins_qty_tab(i)), --5598066
2009: 52, -- Copy sales order
2010: FND_GLOBAL.USER_ID,
2011: sysdate,
2012: FND_GLOBAL.USER_ID,

Line 3043: SET USING_REQUIREMENT_QUANTITY = MSC_ATP_UTILS.Truncate_Demand(l_prim_uom_dmd_qty),

3039:
3040: l_prim_uom_dmd_qty := p_quantity * nvl(p_uom_conv_rate, 1);
3041:
3042: UPDATE msc_demands
3043: SET USING_REQUIREMENT_QUANTITY = MSC_ATP_UTILS.Truncate_Demand(l_prim_uom_dmd_qty),
3044: -- 24x7 -- 5598066
3045: atp_synchronization_flag = 0
3046: WHERE demand_id = l_demand_id
3047: AND plan_id = l_plan_id

Line 3090: SET allocated_quantity = MSC_ATP_UTILS.Truncate_Demand(l_prim_uom_dmd_qty) --5598066

3086: msc_sch_wb.atp_debug('Update_Planned_Order: before update of' ||
3087: ' msc_alloc_demands');
3088: END IF;
3089: UPDATE msc_alloc_demands
3090: SET allocated_quantity = MSC_ATP_UTILS.Truncate_Demand(l_prim_uom_dmd_qty) --5598066
3091: WHERE parent_demand_id = l_demand_id
3092: AND plan_id = l_plan_id;
3093:
3094: IF PG_DEBUG in ('Y', 'C') THEN

Line 3463: USING_REQUIREMENT_QUANTITY = MSC_ATP_UTILS.Truncate_Demand(NVL(p_supply_demand_qty,USING_REQUIREMENT_QUANTITY)), -- Bug 1501787

3459: ship_set_name = p_ship_set_name, --plan by request date
3460: arrival_set_name = p_arrival_set_name, --plan by request date
3461: atp_override_flag = decode(upper(p_override_flag),'Y',1,2), --plan by request date
3462: --end changes for plan by request date
3463: USING_REQUIREMENT_QUANTITY = MSC_ATP_UTILS.Truncate_Demand(NVL(p_supply_demand_qty,USING_REQUIREMENT_QUANTITY)), -- Bug 1501787
3464: -- 24x7 -- 5598066
3465: ATP_SYNCHRONIZATION_FLAG = 0,
3466: -- bug 2795053-reopen (ssurendr) update the demand_satisfied_date in msc_demands
3467: DMD_SATISFIED_DATE = TRUNC(GREATEST(p_dmd_satisfied_date,DMD_SATISFIED_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

Line 3512: SET ALLOCATED_QUANTITY = MSC_ATP_UTILS.Truncate_Demand(NVL(p_supply_demand_qty,

3508: ' msc_alloc_demands');
3509: END IF;
3510:
3511: UPDATE MSC_ALLOC_DEMANDS
3512: SET ALLOCATED_QUANTITY = MSC_ATP_UTILS.Truncate_Demand(NVL(p_supply_demand_qty,
3513: ALLOCATED_QUANTITY)), --5598066
3514: DEMAND_DATE = NVL(p_supply_demand_date, DEMAND_DATE),
3515: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3516: LAST_UPDATE_DATE = sysdate

Line 3715: set Primary_uom_quantity = MSC_ATP_UTILS.Truncate_Demand(Old_primary_uom_quantity), --5598066

3711: --3720018, reverting back incase, rescheduling fails
3712: IF (p_del_ods_demand_ids IS NOT NULL AND p_del_ods_demand_ids.count > 0) THEN
3713: FOR m in 1..p_del_ods_demand_ids.count LOOP
3714: Update msc_sales_orders
3715: set Primary_uom_quantity = MSC_ATP_UTILS.Truncate_Demand(Old_primary_uom_quantity), --5598066
3716: reservation_quantity = MSC_ATP_UTILS.Truncate_Demand(old_reservation_quantity), --5598066
3717: inventory_item_id = p_del_ods_inv_item_ids(m),
3718: atp_refresh_number = p_del_ods_atp_refresh_no(m)
3719: WHERE sr_instance_id = p_instance_id

Line 3716: reservation_quantity = MSC_ATP_UTILS.Truncate_Demand(old_reservation_quantity), --5598066

3712: IF (p_del_ods_demand_ids IS NOT NULL AND p_del_ods_demand_ids.count > 0) THEN
3713: FOR m in 1..p_del_ods_demand_ids.count LOOP
3714: Update msc_sales_orders
3715: set Primary_uom_quantity = MSC_ATP_UTILS.Truncate_Demand(Old_primary_uom_quantity), --5598066
3716: reservation_quantity = MSC_ATP_UTILS.Truncate_Demand(old_reservation_quantity), --5598066
3717: inventory_item_id = p_del_ods_inv_item_ids(m),
3718: atp_refresh_number = p_del_ods_atp_refresh_no(m)
3719: WHERE sr_instance_id = p_instance_id
3720: AND demand_id = p_del_ods_demand_ids(m)

Line 3748: set Primary_uom_quantity = MSC_ATP_UTILS.Truncate_Demand(Old_primary_uom_quantity), --5598066

3744: --3720018, reverting back in case, rescheduling fails
3745: IF (p_del_ods_cto_demand_ids IS NOT NULL AND p_del_ods_cto_demand_ids.count > 0) THEN
3746: FOR m in 1..p_del_ods_cto_demand_ids.count LOOP
3747: Update msc_sales_orders
3748: set Primary_uom_quantity = MSC_ATP_UTILS.Truncate_Demand(Old_primary_uom_quantity), --5598066
3749: inventory_item_id = p_del_ods_cto_inv_item_ids(m),
3750: reservation_quantity = MSC_ATP_UTILS.Truncate_Demand(old_reservation_quantity), -- 5598066
3751: atp_refresh_number = p_del_ods_cto_atp_refresh_no(m)
3752: WHERE sr_instance_id = p_instance_id

Line 3750: reservation_quantity = MSC_ATP_UTILS.Truncate_Demand(old_reservation_quantity), -- 5598066

3746: FOR m in 1..p_del_ods_cto_demand_ids.count LOOP
3747: Update msc_sales_orders
3748: set Primary_uom_quantity = MSC_ATP_UTILS.Truncate_Demand(Old_primary_uom_quantity), --5598066
3749: inventory_item_id = p_del_ods_cto_inv_item_ids(m),
3750: reservation_quantity = MSC_ATP_UTILS.Truncate_Demand(old_reservation_quantity), -- 5598066
3751: atp_refresh_number = p_del_ods_cto_atp_refresh_no(m)
3752: WHERE sr_instance_id = p_instance_id
3753: AND demand_id = p_del_ods_cto_demand_ids(m)
3754: AND decode(demand_source_type,100,demand_source_type,-1)

Line 3778: SET using_requirement_quantity = MSC_ATP_UTILS.Truncate_Demand(old_demand_quantity), -- 5598066

3774: END IF;
3775:
3776: FORALL m IN 1..p_del_demand_ids.COUNT
3777: UPDATE msc_demands
3778: SET using_requirement_quantity = MSC_ATP_UTILS.Truncate_Demand(old_demand_quantity), -- 5598066
3779: -- bug 2863322 : change the column used to store date
3780: using_assembly_demand_date = old_using_assembly_demand_date,
3781: inventory_item_id = p_inv_item_ids(m),
3782: applied = 2,

Line 3887: SET allocated_quantity = MSC_ATP_UTILS.Truncate_Demand(old_allocated_quantity), --5598066

3883: IF p_time_phased_set = 'Y' THEN
3884:
3885: FORALL m IN 1..p_del_demand_ids.COUNT
3886: UPDATE msc_alloc_demands
3887: SET allocated_quantity = MSC_ATP_UTILS.Truncate_Demand(old_allocated_quantity), --5598066
3888: demand_date = old_demand_date ,
3889: old_allocated_quantity = null,
3890: old_demand_date = null,
3891: --inventory_item_id = p_inv_item_ids(m),

Line 3903: SET allocated_quantity = MSC_ATP_UTILS.Truncate_Demand(old_allocated_quantity), --5598066

3899: ELSE
3900:
3901: FORALL m IN 1..p_del_demand_ids.COUNT
3902: UPDATE msc_alloc_demands
3903: SET allocated_quantity = MSC_ATP_UTILS.Truncate_Demand(old_allocated_quantity), --5598066
3904: demand_date = old_demand_date ,
3905: old_allocated_quantity = null,
3906: old_demand_date = null,
3907: inventory_item_id = p_inv_item_ids(m),