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 FND_GLOBAL

Line 173: FND_GLOBAL.USER_ID,

169: 0,
170: 1,
171: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY , -- For bug 2259824
172: sysdate,
173: FND_GLOBAL.USER_ID,
174: sysdate,
175: FND_GLOBAL.USER_ID,
176: p_atp_rec.demand_class,
177: p_atp_rec.refresh_number,

Line 175: FND_GLOBAL.USER_ID,

171: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY , -- For bug 2259824
172: sysdate,
173: FND_GLOBAL.USER_ID,
174: sysdate,
175: FND_GLOBAL.USER_ID,
176: p_atp_rec.demand_class,
177: p_atp_rec.refresh_number,
178: p_atp_rec.order_number,
179: p_atp_rec.ato_model_line_id,

Line 271: FND_GLOBAL.USER_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,
274: p_atp_rec.refresh_number,
275: p_atp_rec.order_number,

Line 272: FND_GLOBAL.USER_ID,

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,
274: p_atp_rec.refresh_number,
275: p_atp_rec.order_number,
276: p_atp_rec.ato_model_line_id,

Line 348: FND_GLOBAL.USER_ID,

344: trunc(p_atp_rec.requested_ship_date),
345: p_atp_rec.quantity_ordered,
346: Decode(p_dc_flag, 1, NVL(p_atp_rec.demand_class, '@@@') ,'@@@'),
347: sysdate,
348: FND_GLOBAL.USER_ID,
349: sysdate,
350: FND_GLOBAL.USER_ID);
351: EXCEPTION
352: WHEN DUP_VAL_ON_INDEX THEN

Line 350: FND_GLOBAL.USER_ID);

346: Decode(p_dc_flag, 1, NVL(p_atp_rec.demand_class, '@@@') ,'@@@'),
347: sysdate,
348: FND_GLOBAL.USER_ID,
349: sysdate,
350: FND_GLOBAL.USER_ID);
351: EXCEPTION
352: WHEN DUP_VAL_ON_INDEX THEN
353: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_atp_rec.instance_id,
354: -1,

Line 408: last_updated_by = FND_GLOBAL.USER_ID,

404: origination_type = p_atp_rec.origination_type,
405: plan_id = p_plan_id,
406: organization_id = p_atp_rec.organization_id,
407: last_update_date = sysdate,
408: last_updated_by = FND_GLOBAL.USER_ID,
409: demand_class = p_atp_rec.demand_class,
410: refresh_number = p_atp_rec.refresh_number,
411: order_number = decode(p_atp_rec.origination_type, 6, p_atp_rec.order_number,
412: 30, p_atp_rec.order_number,

Line 460: last_updated_by = FND_GLOBAL.USER_ID,

456: inventory_item_id = p_atp_rec.inventory_item_id,
457: order_number = decode(p_atp_rec.origination_type,
458: 6, p_atp_rec.order_number,
459: 30, p_atp_rec.order_number, null),
460: last_updated_by = FND_GLOBAL.USER_ID,
461: last_update_date = sysdate,
462: refresh_number = p_atp_rec.refresh_number -- For summary enhancement
463: WHERE sr_instance_id = p_atp_rec.instance_id
464: AND plan_id = p_plan_id

Line 595: FND_GLOBAL.USER_ID,

591: l_insert_item_id, -- for time_phased_atp
592: p_atp_rec.demand_source_line,
593: p_atp_rec.instance_id,
594: sysdate,
595: FND_GLOBAL.USER_ID,
596: sysdate,
597: FND_GLOBAL.USER_ID,
598: --p_atp_rec.demand_class,
599: ---bug 2424357: we do not store the converted demand class

Line 597: FND_GLOBAL.USER_ID,

593: p_atp_rec.instance_id,
594: sysdate,
595: FND_GLOBAL.USER_ID,
596: sysdate,
597: FND_GLOBAL.USER_ID,
598: --p_atp_rec.demand_class,
599: ---bug 2424357: we do not store the converted demand class
600: -- always store the actual demand class.
601: DECODE(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 1, MSC_ATP_PVT.G_ATP_DEMAND_CLASS,

Line 720: FND_GLOBAL.USER_ID,

716: -- s_cto_rearch insert order number
717: p_atp_rec.order_number,
718:
719: p_atp_rec.demand_source_line,
720: FND_GLOBAL.USER_ID,
721: sysdate,
722: FND_GLOBAL.USER_ID,
723: sysdate,
724: p_atp_rec.refresh_number,

Line 722: FND_GLOBAL.USER_ID,

718:
719: p_atp_rec.demand_source_line,
720: FND_GLOBAL.USER_ID,
721: sysdate,
722: FND_GLOBAL.USER_ID,
723: sysdate,
724: p_atp_rec.refresh_number,
725: --bug3684383
726: decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_ID,

Line 992: , FND_GLOBAL.USER_ID -- created_by

988: p_pegging_rec.request_item_id,
989: p_pegging_rec.ptf_date
990: -- dsting
991: , sysdate -- creation_date
992: , FND_GLOBAL.USER_ID -- created_by
993: , sysdate -- creation_date
994: , FND_GLOBAL.USER_ID -- created_by
995: , FND_GLOBAL.USER_ID, -- last_update_login
996: --diag_atp

Line 994: , FND_GLOBAL.USER_ID -- created_by

990: -- dsting
991: , sysdate -- creation_date
992: , FND_GLOBAL.USER_ID -- created_by
993: , sysdate -- creation_date
994: , FND_GLOBAL.USER_ID -- created_by
995: , FND_GLOBAL.USER_ID, -- last_update_login
996: --diag_atp
997: p_pegging_rec.FIXED_LEAD_TIME,
998: p_pegging_rec.VARIABLE_LEAD_TIME,

Line 995: , FND_GLOBAL.USER_ID, -- last_update_login

991: , sysdate -- creation_date
992: , FND_GLOBAL.USER_ID -- created_by
993: , sysdate -- creation_date
994: , FND_GLOBAL.USER_ID -- created_by
995: , FND_GLOBAL.USER_ID, -- last_update_login
996: --diag_atp
997: p_pegging_rec.FIXED_LEAD_TIME,
998: p_pegging_rec.VARIABLE_LEAD_TIME,
999: p_pegging_rec.PREPROCESSING_LEAD_TIME,

Line 1279: FND_GLOBAL.USER_ID,

1275: 5,
1276: p_std_op_code,
1277: --MSC_ATP_PVT.G_OPTIMIZED_PLAN, Bug 3327819 Default parent_id to NULL.
1278: sysdate,
1279: FND_GLOBAL.USER_ID,
1280: sysdate,
1281: FND_GLOBAL.USER_ID,
1282: 2, -- This field was not getting populated before. added with summary enhancement
1283: p_refresh_number -- for summary enhancement

Line 1281: FND_GLOBAL.USER_ID,

1277: --MSC_ATP_PVT.G_OPTIMIZED_PLAN, Bug 3327819 Default parent_id to NULL.
1278: sysdate,
1279: FND_GLOBAL.USER_ID,
1280: sysdate,
1281: FND_GLOBAL.USER_ID,
1282: 2, -- This field was not getting populated before. added with summary enhancement
1283: p_refresh_number -- for summary enhancement
1284: )
1285: RETURNING transaction_id INTO x_transaction_id;

Line 1347: FND_GLOBAL.USER_ID,

1343: p_resource_id,
1344: trunc(p_start_date),
1345: -1 * p_resource_cap_hrs,
1346: sysdate,
1347: FND_GLOBAL.USER_ID,
1348: sysdate,
1349: FND_GLOBAL.USER_ID);
1350: EXCEPTION
1351: WHEN DUP_VAL_ON_INDEX THEN

Line 1349: FND_GLOBAL.USER_ID);

1345: -1 * p_resource_cap_hrs,
1346: sysdate,
1347: FND_GLOBAL.USER_ID,
1348: sysdate,
1349: FND_GLOBAL.USER_ID);
1350: EXCEPTION
1351: WHEN DUP_VAL_ON_INDEX THEN
1352:
1353: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

Line 1824: FND_GLOBAL.USER_ID,

1820: l_ins_org_id_tab(i),
1821: i_ins_item_id_tab(i),
1822: p_instance_id,
1823: sysdate,
1824: FND_GLOBAL.USER_ID,
1825: sysdate,
1826: FND_GLOBAL.USER_ID,
1827: 2,
1828: l_ins_refresh_number_tab(i));

Line 1826: FND_GLOBAL.USER_ID,

1822: p_instance_id,
1823: sysdate,
1824: FND_GLOBAL.USER_ID,
1825: sysdate,
1826: FND_GLOBAL.USER_ID,
1827: 2,
1828: l_ins_refresh_number_tab(i));
1829:
1830: ELSE

Line 2163: FND_GLOBAL.USER_ID,

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,
2166: sysdate,
2167: l_ins_refresh_number_tab(i));

Line 2165: FND_GLOBAL.USER_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,
2166: sysdate,
2167: l_ins_refresh_number_tab(i));
2168: END IF; -- IF i_ins_item_id_tab IS NOT NULL and i_ins_item_id_tab.COUNT > 0 THEN
2169:

Line 2792: , last_updated_by = FND_GLOBAL.USER_ID

2788: --required_date = NVL(p_date, supply_demand_date)
2789: actual_supply_demand_date = NVL(p_date, supply_demand_date)
2790: -- dsting
2791: , last_update_date = sysdate
2792: , last_updated_by = FND_GLOBAL.USER_ID
2793: , last_update_login = FND_GLOBAL.USER_ID
2794: WHERE pegging_id = p_pegging_id
2795: AND session_id = MSC_ATP_PVT.G_SESSION_ID
2796: AND record_type = 3;

Line 2793: , last_update_login = FND_GLOBAL.USER_ID

2789: actual_supply_demand_date = NVL(p_date, supply_demand_date)
2790: -- dsting
2791: , last_update_date = sysdate
2792: , last_updated_by = FND_GLOBAL.USER_ID
2793: , last_update_login = FND_GLOBAL.USER_ID
2794: WHERE pegging_id = p_pegging_id
2795: AND session_id = MSC_ATP_PVT.G_SESSION_ID
2796: AND record_type = 3;
2797:

Line 3012: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

3008: SET old_supply_date = supply_date,
3009: old_allocated_quantity = allocated_quantity,
3010: supply_date = NVL(p_date, supply_date),
3011: allocated_quantity = NVL(p_quantity, allocated_quantity),
3012: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3013: LAST_UPDATE_DATE = sysdate
3014: WHERE plan_id = p_plan_id
3015: AND parent_transaction_id = l_transaction_id;
3016:

Line 3532: FND_GLOBAL.USER_ID,

3528: trunc(p_supply_demand_date),
3529: l_sd_qty,
3530: Decode(p_dc_flag, 1, NVL(l_demand_class, '@@@') ,'@@@'),
3531: sysdate,
3532: FND_GLOBAL.USER_ID,
3533: sysdate,
3534: FND_GLOBAL.USER_ID);
3535: EXCEPTION
3536: WHEN DUP_VAL_ON_INDEX THEN

Line 3534: FND_GLOBAL.USER_ID);

3530: Decode(p_dc_flag, 1, NVL(l_demand_class, '@@@') ,'@@@'),
3531: sysdate,
3532: FND_GLOBAL.USER_ID,
3533: sysdate,
3534: FND_GLOBAL.USER_ID);
3535: EXCEPTION
3536: WHEN DUP_VAL_ON_INDEX THEN
3537: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
3538: -1,

Line 3682: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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
3684: WHERE PLAN_ID = p_plan_id
3685: AND PARENT_DEMAND_ID = l_demand_id
3686: AND INVENTORY_ITEM_ID = l_inventory_item_id

Line 4273: l_user_id := FND_GLOBAL.USER_ID;

4269: msc_sch_wb.atp_debug('DELETE_SUMMARY_ROW: ' || 'No row found that need to be deleted from summary table');
4270: END IF;
4271: END;
4272: -- 5357370: need user id for insert
4273: l_user_id := FND_GLOBAL.USER_ID;
4274: l_sysdate := sysdate;
4275:
4276:
4277: IF PG_DEBUG in ('Y', 'C') THEN

Line 4495: FND_GLOBAL.USER_ID,

4491: trunc(p_date),
4492: p_quantity,
4493: '@@@',
4494: sysdate,
4495: FND_GLOBAL.USER_ID,
4496: sysdate,
4497: FND_GLOBAL.USER_ID);
4498: EXCEPTION
4499: WHEN DUP_VAL_ON_INDEX THEN

Line 4497: FND_GLOBAL.USER_ID);

4493: '@@@',
4494: sysdate,
4495: FND_GLOBAL.USER_ID,
4496: sysdate,
4497: FND_GLOBAL.USER_ID);
4498: EXCEPTION
4499: WHEN DUP_VAL_ON_INDEX THEN
4500: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
4501: p_plan_id,

Line 4586: FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID, sysdate, p_stolen_demand_class,

4582: VALUES
4583: (p_plan_id, p_inventory_item_id, p_organization_id,
4584: p_sr_instance_id, p_stealing_demand_class, p_ship_date,
4585: p_transaction_id, p_stealing_quantity, 46, p_identifier,p_demand_source_type, 1, ---cmro
4586: FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID, sysdate, p_stolen_demand_class,
4587: p_ato_model_line_id, p_refresh_number, -- For summary enhancement
4588: --bug3684383
4589: p_order_number,MSC_ATP_PVT.G_PARTNER_ID,MSC_ATP_PVT.G_PARTNER_SITE_ID);
4590:

Line 4611: FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID, sysdate, p_stealing_demand_class,

4607: VALUES
4608: (p_plan_id, p_inventory_item_id, p_organization_id,
4609: p_sr_instance_id, p_stolen_demand_class, p_ship_date,
4610: p_transaction_id, -1 * p_stealing_quantity, 47, p_identifier,p_demand_source_type,1, --cmro
4611: FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID, sysdate, p_stealing_demand_class,
4612: p_ato_model_line_id, p_refresh_number, -- For summary enhancement
4613: --bug3684383
4614: p_order_number,MSC_ATP_PVT.G_PARTNER_ID,MSC_ATP_PVT.G_PARTNER_SITE_ID);
4615:

Line 5083: FND_GLOBAL.USER_ID,

5079: p_supply_rec_type.organization_id,
5080: p_supply_rec_type.instance_id,
5081: l_insert_item_id, -- for time_phased_atp
5082: sysdate,
5083: FND_GLOBAL.USER_ID,
5084: sysdate,
5085: FND_GLOBAL.USER_ID,
5086: -- For bug 2259824, move the supply to the end of day
5087: TRUNC(p_supply_rec_type.schedule_date) + MSC_ATP_PVT.G_END_OF_DAY,

Line 5085: FND_GLOBAL.USER_ID,

5081: l_insert_item_id, -- for time_phased_atp
5082: sysdate,
5083: FND_GLOBAL.USER_ID,
5084: sysdate,
5085: FND_GLOBAL.USER_ID,
5086: -- For bug 2259824, move the supply to the end of day
5087: TRUNC(p_supply_rec_type.schedule_date) + MSC_ATP_PVT.G_END_OF_DAY,
5088: p_supply_rec_type.disposition_status_type, -- 1512366: open
5089: p_supply_rec_type.supply_type,

Line 5189: FND_GLOBAL.USER_ID,

5185: p_supply_rec_type.schedule_date,
5186: p_supply_rec_type.transaction_id,
5187: p_supply_rec_type.order_quantity,
5188: p_supply_rec_type.supply_type,
5189: FND_GLOBAL.USER_ID,
5190: sysdate,
5191: FND_GLOBAL.USER_ID,
5192: sysdate,
5193: p_supply_rec_type.refresh_number); -- for summary enhancement

Line 5191: FND_GLOBAL.USER_ID,

5187: p_supply_rec_type.order_quantity,
5188: p_supply_rec_type.supply_type,
5189: FND_GLOBAL.USER_ID,
5190: sysdate,
5191: FND_GLOBAL.USER_ID,
5192: sysdate,
5193: p_supply_rec_type.refresh_number); -- for summary enhancement
5194: END IF;
5195:

Line 5843: l_user_id := FND_GLOBAL.USER_ID;

5839: msc_sch_wb.atp_debug('UNDO_DELETE_SUMMARY_ROW: ' || 'No row found that need to be deleted from summary table');
5840: END IF;
5841: END;
5842: -- 5357370: need user id for insert
5843: l_user_id := FND_GLOBAL.USER_ID;
5844: l_sysdate := sysdate;
5845:
5846: IF PG_DEBUG in ('Y', 'C') THEN
5847: msc_sch_wb.atp_debug('UNDO_DELETE_SUMMARY_ROW: ' || 'l_inventory_item_id.count := ' || l_inventory_item_id.count);