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.

APPS.MSC_ATP_DB_UTILS dependencies on MSC_ATP_UTILS

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

164: p_atp_rec.demand_source_type,
165: p_atp_rec.demand_source_header_id,
166: p_atp_rec.demand_source_line,
167: p_atp_rec.demand_source_delivery,
168: MSC_ATP_UTILS.Truncate_Demand(p_atp_rec.quantity_ordered), --5598066
169: 0,
170: 1,
171: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY , -- For bug 2259824
172: sysdate,

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

265: p_atp_rec.demand_source_type,
266: p_atp_rec.demand_source_header_id,
267: p_atp_rec.demand_source_line,
268: p_atp_rec.demand_source_delivery,
269: MSC_ATP_UTILS.Truncate_Demand(p_atp_rec.quantity_ordered), --5598066
270: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY , -- For bug 2259824
271: FND_GLOBAL.USER_ID,
272: FND_GLOBAL.USER_ID,
273: p_atp_rec.demand_class,

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

536: ARRIVAL_SET_NAME --bug3263368
537: )
538: VALUES(
539: msc_demands_s.nextval,
540: MSC_ATP_UTILS.Truncate_Demand(p_atp_rec.quantity_ordered), -- 5598066
541: -- start changes for plan by request date
542: decode(p_atp_rec.origination_type,
543: 6, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
544: 30, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

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

707: p_atp_rec.demand_class,
708: p_atp_rec.demand_source_type,--CMRO
709: p_atp_rec.requested_ship_date, -- QUESTION arrival items ?
710: x_demand_id,
711: MSC_ATP_UTILS.Truncate_Demand(p_atp_rec.quantity_ordered), -- 5598066
712: p_atp_rec.origination_type,
713: -- rajjain 04/25/2003 Bug 2770175 populate order_number column with the
714:
715: --decode(p_atp_rec.origination_type, 1, x_demand_id, p_atp_rec.order_number),

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

1810: CREATED_BY,
1811: RECORD_SOURCE,
1812: REFRESH_NUMBER)
1813: VALUES (l_copy_demand_id(i),
1814: MSC_ATP_UTILS.Truncate_Demand(l_ins_qty_tab(i)), -- 5598066
1815: l_ins_date_tab(i),
1816: 1, -- Discrete
1817: 52, -- Copy sales order
1818: i_ins_item_id_tab(i),

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

2157: p_instance_id,
2158: l_ins_demand_class_tab(i),
2159: l_ins_date_tab(i),
2160: l_copy_demand_id(i), -- parent demand id
2161: MSC_ATP_UTILS.Truncate_Demand(l_ins_qty_tab(i)), --5598066
2162: 52, -- Copy sales order
2163: FND_GLOBAL.USER_ID,
2164: sysdate,
2165: FND_GLOBAL.USER_ID,

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

3201:
3202: l_prim_uom_dmd_qty := p_quantity * nvl(p_uom_conv_rate, 1);
3203:
3204: UPDATE msc_demands
3205: SET USING_REQUIREMENT_QUANTITY = MSC_ATP_UTILS.Truncate_Demand(l_prim_uom_dmd_qty),
3206: -- 24x7 -- 5598066
3207: atp_synchronization_flag = 0
3208: WHERE demand_id = l_demand_id
3209: AND plan_id = l_plan_id

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

3248: msc_sch_wb.atp_debug('Update_Planned_Order: before update of' ||
3249: ' msc_alloc_demands');
3250: END IF;
3251: UPDATE msc_alloc_demands
3252: SET allocated_quantity = MSC_ATP_UTILS.Truncate_Demand(l_prim_uom_dmd_qty) --5598066
3253: WHERE parent_demand_id = l_demand_id
3254: AND plan_id = l_plan_id;
3255:
3256: IF PG_DEBUG in ('Y', 'C') THEN

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

3626: ship_set_name = p_ship_set_name, --plan by request date
3627: arrival_set_name = p_arrival_set_name, --plan by request date
3628: atp_override_flag = decode(upper(p_override_flag),'Y',1,2), --plan by request date
3629: --end changes for plan by request date
3630: USING_REQUIREMENT_QUANTITY = MSC_ATP_UTILS.Truncate_Demand(NVL(p_supply_demand_qty,USING_REQUIREMENT_QUANTITY)), -- Bug 1501787
3631: -- 24x7 -- 5598066
3632: ATP_SYNCHRONIZATION_FLAG = 0,
3633: -- bug 2795053-reopen (ssurendr) update the demand_satisfied_date in msc_demands
3634: DMD_SATISFIED_DATE = TRUNC(GREATEST(p_dmd_satisfied_date,DMD_SATISFIED_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

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

3675: ' msc_alloc_demands');
3676: END IF;
3677:
3678: UPDATE MSC_ALLOC_DEMANDS
3679: SET ALLOCATED_QUANTITY = MSC_ATP_UTILS.Truncate_Demand(NVL(p_supply_demand_qty,
3680: ALLOCATED_QUANTITY)), --5598066
3681: DEMAND_DATE = NVL(p_supply_demand_date, DEMAND_DATE),
3682: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3683: LAST_UPDATE_DATE = sysdate

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

3886: --3720018, reverting back incase, rescheduling fails
3887: IF (p_del_ods_demand_ids IS NOT NULL AND p_del_ods_demand_ids.count > 0) THEN
3888: FOR m in 1..p_del_ods_demand_ids.count LOOP
3889: Update msc_sales_orders
3890: set Primary_uom_quantity = MSC_ATP_UTILS.Truncate_Demand(Old_primary_uom_quantity), --5598066
3891: reservation_quantity = MSC_ATP_UTILS.Truncate_Demand(old_reservation_quantity), --5598066
3892: inventory_item_id = p_del_ods_inv_item_ids(m),
3893: atp_refresh_number = p_del_ods_atp_refresh_no(m)
3894: WHERE sr_instance_id = p_instance_id

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

3887: IF (p_del_ods_demand_ids IS NOT NULL AND p_del_ods_demand_ids.count > 0) THEN
3888: FOR m in 1..p_del_ods_demand_ids.count LOOP
3889: Update msc_sales_orders
3890: set Primary_uom_quantity = MSC_ATP_UTILS.Truncate_Demand(Old_primary_uom_quantity), --5598066
3891: reservation_quantity = MSC_ATP_UTILS.Truncate_Demand(old_reservation_quantity), --5598066
3892: inventory_item_id = p_del_ods_inv_item_ids(m),
3893: atp_refresh_number = p_del_ods_atp_refresh_no(m)
3894: WHERE sr_instance_id = p_instance_id
3895: AND demand_id = p_del_ods_demand_ids(m)

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

3919: --3720018, reverting back in case, rescheduling fails
3920: IF (p_del_ods_cto_demand_ids IS NOT NULL AND p_del_ods_cto_demand_ids.count > 0) THEN
3921: FOR m in 1..p_del_ods_cto_demand_ids.count LOOP
3922: Update msc_sales_orders
3923: set Primary_uom_quantity = MSC_ATP_UTILS.Truncate_Demand(Old_primary_uom_quantity), --5598066
3924: inventory_item_id = p_del_ods_cto_inv_item_ids(m),
3925: reservation_quantity = MSC_ATP_UTILS.Truncate_Demand(old_reservation_quantity), -- 5598066
3926: atp_refresh_number = p_del_ods_cto_atp_refresh_no(m)
3927: WHERE sr_instance_id = p_instance_id

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

3921: FOR m in 1..p_del_ods_cto_demand_ids.count LOOP
3922: Update msc_sales_orders
3923: set Primary_uom_quantity = MSC_ATP_UTILS.Truncate_Demand(Old_primary_uom_quantity), --5598066
3924: inventory_item_id = p_del_ods_cto_inv_item_ids(m),
3925: reservation_quantity = MSC_ATP_UTILS.Truncate_Demand(old_reservation_quantity), -- 5598066
3926: atp_refresh_number = p_del_ods_cto_atp_refresh_no(m)
3927: WHERE sr_instance_id = p_instance_id
3928: AND demand_id = p_del_ods_cto_demand_ids(m)
3929: AND decode(demand_source_type,100,demand_source_type,-1)

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

3949: END IF;
3950:
3951: FORALL m IN 1..p_del_demand_ids.COUNT
3952: UPDATE msc_demands
3953: SET using_requirement_quantity = MSC_ATP_UTILS.Truncate_Demand(old_demand_quantity), -- 5598066
3954: -- bug 2863322 : change the column used to store date
3955: using_assembly_demand_date = old_using_assembly_demand_date,
3956: inventory_item_id = p_inv_item_ids(m),
3957: applied = 2,

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

4058: IF p_time_phased_set = 'Y' THEN
4059:
4060: FORALL m IN 1..p_del_demand_ids.COUNT
4061: UPDATE msc_alloc_demands
4062: SET allocated_quantity = MSC_ATP_UTILS.Truncate_Demand(old_allocated_quantity), --5598066
4063: demand_date = old_demand_date ,
4064: old_allocated_quantity = null,
4065: old_demand_date = null,
4066: --inventory_item_id = p_inv_item_ids(m),

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

4075: ELSE
4076:
4077: FORALL m IN 1..p_del_demand_ids.COUNT
4078: UPDATE msc_alloc_demands
4079: SET allocated_quantity = MSC_ATP_UTILS.Truncate_Demand(old_allocated_quantity), --5598066
4080: demand_date = old_demand_date ,
4081: old_allocated_quantity = null,
4082: old_demand_date = null,
4083: inventory_item_id = p_inv_item_ids(m),