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 FND_GLOBAL

Line 127: FND_GLOBAL.USER_ID,

123: 0,
124: 1,
125: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY , -- For bug 2259824
126: sysdate,
127: FND_GLOBAL.USER_ID,
128: sysdate,
129: FND_GLOBAL.USER_ID,
130: p_atp_rec.demand_class,
131: p_atp_rec.refresh_number,

Line 129: FND_GLOBAL.USER_ID,

125: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY , -- For bug 2259824
126: sysdate,
127: FND_GLOBAL.USER_ID,
128: sysdate,
129: FND_GLOBAL.USER_ID,
130: p_atp_rec.demand_class,
131: p_atp_rec.refresh_number,
132: p_atp_rec.order_number,
133: p_atp_rec.ato_model_line_id,

Line 204: FND_GLOBAL.USER_ID,

200: trunc(p_atp_rec.requested_ship_date),
201: p_atp_rec.quantity_ordered,
202: Decode(p_dc_flag, 1, NVL(p_atp_rec.demand_class, '@@@') ,'@@@'),
203: sysdate,
204: FND_GLOBAL.USER_ID,
205: sysdate,
206: FND_GLOBAL.USER_ID);
207: EXCEPTION
208: WHEN DUP_VAL_ON_INDEX THEN

Line 206: FND_GLOBAL.USER_ID);

202: Decode(p_dc_flag, 1, NVL(p_atp_rec.demand_class, '@@@') ,'@@@'),
203: sysdate,
204: FND_GLOBAL.USER_ID,
205: sysdate,
206: FND_GLOBAL.USER_ID);
207: EXCEPTION
208: WHEN DUP_VAL_ON_INDEX THEN
209: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_atp_rec.instance_id,
210: -1,

Line 264: last_updated_by = FND_GLOBAL.USER_ID,

260: origination_type = p_atp_rec.origination_type,
261: plan_id = p_plan_id,
262: organization_id = p_atp_rec.organization_id,
263: last_update_date = sysdate,
264: last_updated_by = FND_GLOBAL.USER_ID,
265: demand_class = p_atp_rec.demand_class,
266: refresh_number = p_atp_rec.refresh_number,
267: order_number = decode(p_atp_rec.origination_type, 6, p_atp_rec.order_number,
268: 30, p_atp_rec.order_number,

Line 316: last_updated_by = FND_GLOBAL.USER_ID,

312: inventory_item_id = p_atp_rec.inventory_item_id,
313: order_number = decode(p_atp_rec.origination_type,
314: 6, p_atp_rec.order_number,
315: 30, p_atp_rec.order_number, null),
316: last_updated_by = FND_GLOBAL.USER_ID,
317: last_update_date = sysdate,
318: refresh_number = p_atp_rec.refresh_number -- For summary enhancement
319: WHERE sr_instance_id = p_atp_rec.instance_id
320: AND plan_id = p_plan_id

Line 451: FND_GLOBAL.USER_ID,

447: l_insert_item_id, -- for time_phased_atp
448: p_atp_rec.demand_source_line,
449: p_atp_rec.instance_id,
450: sysdate,
451: FND_GLOBAL.USER_ID,
452: sysdate,
453: FND_GLOBAL.USER_ID,
454: --p_atp_rec.demand_class,
455: ---bug 2424357: we do not store the converted demand class

Line 453: FND_GLOBAL.USER_ID,

449: p_atp_rec.instance_id,
450: sysdate,
451: FND_GLOBAL.USER_ID,
452: sysdate,
453: FND_GLOBAL.USER_ID,
454: --p_atp_rec.demand_class,
455: ---bug 2424357: we do not store the converted demand class
456: -- always store the actual demand class.
457: DECODE(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 1, MSC_ATP_PVT.G_ATP_DEMAND_CLASS,

Line 567: FND_GLOBAL.USER_ID,

563: -- s_cto_rearch insert order number
564: p_atp_rec.order_number,
565:
566: p_atp_rec.demand_source_line,
567: FND_GLOBAL.USER_ID,
568: sysdate,
569: FND_GLOBAL.USER_ID,
570: sysdate,
571: p_atp_rec.refresh_number,

Line 569: FND_GLOBAL.USER_ID,

565:
566: p_atp_rec.demand_source_line,
567: FND_GLOBAL.USER_ID,
568: sysdate,
569: FND_GLOBAL.USER_ID,
570: sysdate,
571: p_atp_rec.refresh_number,
572: --bug3684383
573: decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_ID,

Line 839: , FND_GLOBAL.USER_ID -- created_by

835: p_pegging_rec.request_item_id,
836: p_pegging_rec.ptf_date
837: -- dsting
838: , sysdate -- creation_date
839: , FND_GLOBAL.USER_ID -- created_by
840: , sysdate -- creation_date
841: , FND_GLOBAL.USER_ID -- created_by
842: , FND_GLOBAL.USER_ID, -- last_update_login
843: --diag_atp

Line 841: , FND_GLOBAL.USER_ID -- created_by

837: -- dsting
838: , sysdate -- creation_date
839: , FND_GLOBAL.USER_ID -- created_by
840: , sysdate -- creation_date
841: , FND_GLOBAL.USER_ID -- created_by
842: , FND_GLOBAL.USER_ID, -- last_update_login
843: --diag_atp
844: p_pegging_rec.FIXED_LEAD_TIME,
845: p_pegging_rec.VARIABLE_LEAD_TIME,

Line 842: , FND_GLOBAL.USER_ID, -- last_update_login

838: , sysdate -- creation_date
839: , FND_GLOBAL.USER_ID -- created_by
840: , sysdate -- creation_date
841: , FND_GLOBAL.USER_ID -- created_by
842: , FND_GLOBAL.USER_ID, -- last_update_login
843: --diag_atp
844: p_pegging_rec.FIXED_LEAD_TIME,
845: p_pegging_rec.VARIABLE_LEAD_TIME,
846: p_pegging_rec.PREPROCESSING_LEAD_TIME,

Line 1126: FND_GLOBAL.USER_ID,

1122: 5,
1123: p_std_op_code,
1124: --MSC_ATP_PVT.G_OPTIMIZED_PLAN, Bug 3327819 Default parent_id to NULL.
1125: sysdate,
1126: FND_GLOBAL.USER_ID,
1127: sysdate,
1128: FND_GLOBAL.USER_ID,
1129: 2, -- This field was not getting populated before. added with summary enhancement
1130: p_refresh_number -- for summary enhancement

Line 1128: FND_GLOBAL.USER_ID,

1124: --MSC_ATP_PVT.G_OPTIMIZED_PLAN, Bug 3327819 Default parent_id to NULL.
1125: sysdate,
1126: FND_GLOBAL.USER_ID,
1127: sysdate,
1128: FND_GLOBAL.USER_ID,
1129: 2, -- This field was not getting populated before. added with summary enhancement
1130: p_refresh_number -- for summary enhancement
1131: )
1132: RETURNING transaction_id INTO x_transaction_id;

Line 1194: FND_GLOBAL.USER_ID,

1190: p_resource_id,
1191: trunc(p_start_date),
1192: -1 * p_resource_cap_hrs,
1193: sysdate,
1194: FND_GLOBAL.USER_ID,
1195: sysdate,
1196: FND_GLOBAL.USER_ID);
1197: EXCEPTION
1198: WHEN DUP_VAL_ON_INDEX THEN

Line 1196: FND_GLOBAL.USER_ID);

1192: -1 * p_resource_cap_hrs,
1193: sysdate,
1194: FND_GLOBAL.USER_ID,
1195: sysdate,
1196: FND_GLOBAL.USER_ID);
1197: EXCEPTION
1198: WHEN DUP_VAL_ON_INDEX THEN
1199:
1200: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

Line 1671: FND_GLOBAL.USER_ID,

1667: l_ins_org_id_tab(i),
1668: i_ins_item_id_tab(i),
1669: p_instance_id,
1670: sysdate,
1671: FND_GLOBAL.USER_ID,
1672: sysdate,
1673: FND_GLOBAL.USER_ID,
1674: 2,
1675: l_ins_refresh_number_tab(i));

Line 1673: FND_GLOBAL.USER_ID,

1669: p_instance_id,
1670: sysdate,
1671: FND_GLOBAL.USER_ID,
1672: sysdate,
1673: FND_GLOBAL.USER_ID,
1674: 2,
1675: l_ins_refresh_number_tab(i));
1676:
1677: ELSE

Line 2010: FND_GLOBAL.USER_ID,

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

Line 2012: FND_GLOBAL.USER_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,
2013: sysdate,
2014: l_ins_refresh_number_tab(i));
2015: END IF; -- IF i_ins_item_id_tab IS NOT NULL and i_ins_item_id_tab.COUNT > 0 THEN
2016:

Line 2630: , last_updated_by = FND_GLOBAL.USER_ID

2626: --required_date = NVL(p_date, supply_demand_date)
2627: actual_supply_demand_date = NVL(p_date, supply_demand_date)
2628: -- dsting
2629: , last_update_date = sysdate
2630: , last_updated_by = FND_GLOBAL.USER_ID
2631: , last_update_login = FND_GLOBAL.USER_ID
2632: WHERE pegging_id = p_pegging_id
2633: AND session_id = MSC_ATP_PVT.G_SESSION_ID
2634: AND record_type = 3;

Line 2631: , last_update_login = FND_GLOBAL.USER_ID

2627: actual_supply_demand_date = NVL(p_date, supply_demand_date)
2628: -- dsting
2629: , last_update_date = sysdate
2630: , last_updated_by = FND_GLOBAL.USER_ID
2631: , last_update_login = FND_GLOBAL.USER_ID
2632: WHERE pegging_id = p_pegging_id
2633: AND session_id = MSC_ATP_PVT.G_SESSION_ID
2634: AND record_type = 3;
2635:

Line 2850: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2846: SET old_supply_date = supply_date,
2847: old_allocated_quantity = allocated_quantity,
2848: supply_date = NVL(p_date, supply_date),
2849: allocated_quantity = NVL(p_quantity, allocated_quantity),
2850: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2851: LAST_UPDATE_DATE = sysdate
2852: WHERE plan_id = p_plan_id
2853: AND parent_transaction_id = l_transaction_id;
2854:

Line 3365: FND_GLOBAL.USER_ID,

3361: trunc(p_supply_demand_date),
3362: l_sd_qty,
3363: Decode(p_dc_flag, 1, NVL(l_demand_class, '@@@') ,'@@@'),
3364: sysdate,
3365: FND_GLOBAL.USER_ID,
3366: sysdate,
3367: FND_GLOBAL.USER_ID);
3368: EXCEPTION
3369: WHEN DUP_VAL_ON_INDEX THEN

Line 3367: FND_GLOBAL.USER_ID);

3363: Decode(p_dc_flag, 1, NVL(l_demand_class, '@@@') ,'@@@'),
3364: sysdate,
3365: FND_GLOBAL.USER_ID,
3366: sysdate,
3367: FND_GLOBAL.USER_ID);
3368: EXCEPTION
3369: WHEN DUP_VAL_ON_INDEX THEN
3370: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
3371: -1,

Line 3515: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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
3517: WHERE PLAN_ID = p_plan_id
3518: AND PARENT_DEMAND_ID = l_demand_id
3519: AND INVENTORY_ITEM_ID = l_inventory_item_id

Line 4091: l_user_id := FND_GLOBAL.USER_ID;

4087: msc_sch_wb.atp_debug('DELETE_SUMMARY_ROW: ' || 'No row found that need to be deleted from summary table');
4088: END IF;
4089: END;
4090: -- 5357370: need user id for insert
4091: l_user_id := FND_GLOBAL.USER_ID;
4092: l_sysdate := sysdate;
4093:
4094:
4095: IF PG_DEBUG in ('Y', 'C') THEN

Line 4313: FND_GLOBAL.USER_ID,

4309: trunc(p_date),
4310: p_quantity,
4311: '@@@',
4312: sysdate,
4313: FND_GLOBAL.USER_ID,
4314: sysdate,
4315: FND_GLOBAL.USER_ID);
4316: EXCEPTION
4317: WHEN DUP_VAL_ON_INDEX THEN

Line 4315: FND_GLOBAL.USER_ID);

4311: '@@@',
4312: sysdate,
4313: FND_GLOBAL.USER_ID,
4314: sysdate,
4315: FND_GLOBAL.USER_ID);
4316: EXCEPTION
4317: WHEN DUP_VAL_ON_INDEX THEN
4318: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
4319: p_plan_id,

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

4400: VALUES
4401: (p_plan_id, p_inventory_item_id, p_organization_id,
4402: p_sr_instance_id, p_stealing_demand_class, p_ship_date,
4403: p_transaction_id, p_stealing_quantity, 46, p_identifier,p_demand_source_type, 1, ---cmro
4404: FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID, sysdate, p_stolen_demand_class,
4405: p_ato_model_line_id, p_refresh_number, -- For summary enhancement
4406: --bug3684383
4407: p_order_number,MSC_ATP_PVT.G_PARTNER_ID,MSC_ATP_PVT.G_PARTNER_SITE_ID);
4408:

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

4425: VALUES
4426: (p_plan_id, p_inventory_item_id, p_organization_id,
4427: p_sr_instance_id, p_stolen_demand_class, p_ship_date,
4428: p_transaction_id, -1 * p_stealing_quantity, 47, p_identifier,p_demand_source_type,1, --cmro
4429: FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID, sysdate, p_stealing_demand_class,
4430: p_ato_model_line_id, p_refresh_number, -- For summary enhancement
4431: --bug3684383
4432: p_order_number,MSC_ATP_PVT.G_PARTNER_ID,MSC_ATP_PVT.G_PARTNER_SITE_ID);
4433:

Line 4901: FND_GLOBAL.USER_ID,

4897: p_supply_rec_type.organization_id,
4898: p_supply_rec_type.instance_id,
4899: l_insert_item_id, -- for time_phased_atp
4900: sysdate,
4901: FND_GLOBAL.USER_ID,
4902: sysdate,
4903: FND_GLOBAL.USER_ID,
4904: -- For bug 2259824, move the supply to the end of day
4905: TRUNC(p_supply_rec_type.schedule_date) + MSC_ATP_PVT.G_END_OF_DAY,

Line 4903: FND_GLOBAL.USER_ID,

4899: l_insert_item_id, -- for time_phased_atp
4900: sysdate,
4901: FND_GLOBAL.USER_ID,
4902: sysdate,
4903: FND_GLOBAL.USER_ID,
4904: -- For bug 2259824, move the supply to the end of day
4905: TRUNC(p_supply_rec_type.schedule_date) + MSC_ATP_PVT.G_END_OF_DAY,
4906: p_supply_rec_type.disposition_status_type, -- 1512366: open
4907: p_supply_rec_type.supply_type,

Line 5007: FND_GLOBAL.USER_ID,

5003: p_supply_rec_type.schedule_date,
5004: p_supply_rec_type.transaction_id,
5005: p_supply_rec_type.order_quantity,
5006: p_supply_rec_type.supply_type,
5007: FND_GLOBAL.USER_ID,
5008: sysdate,
5009: FND_GLOBAL.USER_ID,
5010: sysdate,
5011: p_supply_rec_type.refresh_number); -- for summary enhancement

Line 5009: FND_GLOBAL.USER_ID,

5005: p_supply_rec_type.order_quantity,
5006: p_supply_rec_type.supply_type,
5007: FND_GLOBAL.USER_ID,
5008: sysdate,
5009: FND_GLOBAL.USER_ID,
5010: sysdate,
5011: p_supply_rec_type.refresh_number); -- for summary enhancement
5012: END IF;
5013:

Line 5639: l_user_id := FND_GLOBAL.USER_ID;

5635: msc_sch_wb.atp_debug('UNDO_DELETE_SUMMARY_ROW: ' || 'No row found that need to be deleted from summary table');
5636: END IF;
5637: END;
5638: -- 5357370: need user id for insert
5639: l_user_id := FND_GLOBAL.USER_ID;
5640: l_sysdate := sysdate;
5641:
5642: IF PG_DEBUG in ('Y', 'C') THEN
5643: msc_sch_wb.atp_debug('UNDO_DELETE_SUMMARY_ROW: ' || 'l_inventory_item_id.count := ' || l_inventory_item_id.count);