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_POST_PRO dependencies on FND_GLOBAL

Line 237: l_user_id := FND_GLOBAL.USER_ID;

233: END;
234: END IF;
235:
236: l_sys_date := sysdate;
237: l_user_id := FND_GLOBAL.USER_ID;
238: msc_util.msc_log('l_sys_date := ' || l_sys_date);
239: msc_util.msc_log('l_user_id := ' || l_user_id);
240:
241: /* rajjain 02/17/2003 GOP Performance Improvement - ODS Summary changes begin

Line 1211: l_user_id := FND_GLOBAL.USER_ID;

1207:
1208:
1209: msc_util.msc_log('LOAD_PLAN_SD: ' || 'share_partition := ' || share_partition);
1210: l_sysdate := sysdate;
1211: l_user_id := FND_GLOBAL.USER_ID;
1212:
1213: BEGIN -- Enclose summary specific operations within BEGIN-EXCEPTION-END block for summary enhancement
1214:
1215: IF share_partition='N' THEN

Line 1670: l_user_id := FND_GLOBAL.USER_ID;

1666: l_user_id number;
1667:
1668: BEGIN
1669: l_sysdate := sysdate;
1670: l_user_id := FND_GLOBAL.USER_ID;
1671:
1672: ---profile option for including purchase order
1673: MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE := NVL(FND_PROFILE.VALUE('MSC_PO_DOCK_DATE_CALC_PREF'), 2);
1674:

Line 1809: l_user_id := FND_GLOBAL.USER_ID;

1805: msc_util.msc_log('LOAD_RESOURCES: ' || 'No Batching');
1806: l_use_batching := 0;
1807: END IF;
1808: l_sysdate := sysdate;
1809: l_user_id := FND_GLOBAL.USER_ID;
1810:
1811: IF p_full_refresh = 1 THEN -- Full refresh - for summary enhancement
1812:
1813: -- Data for share_partition='N' has already been deleted

Line 2338: l_user_id := FND_GLOBAL.USER_ID;

2334: -- Deleted Related Code
2335:
2336: l_instance_id := p_instance_id;
2337: l_sysdate := sysdate;
2338: l_user_id := FND_GLOBAL.USER_ID;
2339: l_inv_ctp := NVL(FND_PROFILE.value('INV_CTP'), 5);
2340: l_enable_summary_mode := NVL(FND_PROFILE.value('MSC_ENABLE_ATP_SUMMARY'), 'N');
2341:
2342: msc_util.msc_log('inv_ctp := ' || l_inv_ctp);

Line 3216: l_user_id := FND_GLOBAL.USER_ID;

3212: ---- select org ids for the instance as we are going to do the summary per organization
3213:
3214: l_inv_ctp := NVL(FND_PROFILE.value('INV_CTP'), 5);
3215: l_sysdate := sysdate;
3216: l_user_id := FND_GLOBAL.USER_ID;
3217: l_enable_summary_mode := NVL(FND_PROFILE.value('MSC_ENABLE_ATP_SUMMARY'), 'N');
3218:
3219: msc_util.msc_log('inv_ctp := ' || l_inv_ctp);
3220: msc_util.msc_log('l_enable_summary_mode := ' || l_enable_summary_mode);

Line 4199: FND_GLOBAL.USER_ID

4195:
4196: l_retval := FND_INSTALLATION.GET_APP_INFO('FND', dummy1, dummy2, l_applsys_schema);
4197: SELECT a.oracle_username,
4198: sysdate,
4199: FND_GLOBAL.USER_ID
4200: INTO l_msc_schema,
4201: l_sysdate,
4202: l_user_id
4203: FROM fnd_oracle_userid a,

Line 6691: l_user_id := FND_GLOBAL.USER_ID;

6687: BEGIN
6688:
6689: msc_util.msc_log('******** LOAD_SD_FULL_UNALLOC_UNOPT Begin ********');
6690:
6691: l_user_id := FND_GLOBAL.USER_ID;
6692:
6693: INSERT INTO MSC_ATP_SUMMARY_SD (
6694: plan_id,
6695: sr_instance_id,

Line 6831: l_user_id := FND_GLOBAL.USER_ID;

6827: BEGIN
6828:
6829: msc_util.msc_log('******** LOAD_SD_FULL_UNALLOC_UNOPT_PF Begin ********');
6830:
6831: l_user_id := FND_GLOBAL.USER_ID;
6832:
6833: INSERT INTO MSC_ATP_SUMMARY_SD (
6834: plan_id,
6835: sr_instance_id,

Line 7007: l_user_id := FND_GLOBAL.USER_ID;

7003: BEGIN
7004:
7005: msc_util.msc_log('******** LOAD_SD_FULL_UNALLOC_OPT Begin ********');
7006:
7007: l_user_id := FND_GLOBAL.USER_ID;
7008:
7009: INSERT INTO MSC_ATP_SUMMARY_SD (
7010: plan_id,
7011: sr_instance_id,

Line 7115: l_user_id := FND_GLOBAL.USER_ID;

7111: BEGIN
7112:
7113: msc_util.msc_log('******** LOAD_SD_FULL_UNALLOC_OPT_PF Begin ********');
7114:
7115: l_user_id := FND_GLOBAL.USER_ID;
7116:
7117: INSERT INTO MSC_ATP_SUMMARY_SD (
7118: plan_id,
7119: sr_instance_id,

Line 7267: l_user_id := FND_GLOBAL.USER_ID;

7263: BEGIN
7264:
7265: msc_util.msc_log('******** LOAD_SD_FULL_ALLOC Begin ********');
7266:
7267: l_user_id := FND_GLOBAL.USER_ID;
7268:
7269: INSERT INTO MSC_ATP_SUMMARY_SD (
7270: plan_id,
7271: sr_instance_id,

Line 7505: l_user_id := FND_GLOBAL.USER_ID;

7501: msc_util.msc_log('LOAD_SD_NET_UNALLOC: ' || 'p_last_refresh_number - ' || p_last_refresh_number);
7502: msc_util.msc_log('LOAD_SD_NET_UNALLOC: ' || 'p_new_refresh_number - ' || p_new_refresh_number);
7503: msc_util.msc_log('LOAD_SD_NET_UNALLOC: ' || 'p_time_phased_pf - ' || p_time_phased_pf);
7504:
7505: l_user_id := FND_GLOBAL.USER_ID;
7506:
7507: IF p_time_phased_pf = 2 THEN
7508: OPEN c_net_sd(p_plan_id, p_last_refresh_number, p_new_refresh_number);
7509: FETCH c_net_sd BULK COLLECT INTO l_sr_instance_id_tab,

Line 7666: l_user_id := FND_GLOBAL.USER_ID;

7662: BEGIN
7663:
7664: msc_util.msc_log('******** LOAD_SD_NET_ALLOC Begin ********');
7665:
7666: l_user_id := FND_GLOBAL.USER_ID;
7667:
7668: OPEN c_net_sd(p_plan_id, p_last_refresh_number, p_new_refresh_number);
7669: FETCH c_net_sd BULK COLLECT INTO l_sr_instance_id_tab,
7670: l_organization_id_tab,

Line 7795: l_user_id := FND_GLOBAL.USER_ID;

7791: msc_util.msc_log('LOAD_SUP_DATA_FULL: ' || 'l_instance_id = ' || l_instance_id);
7792: msc_util.msc_log('LOAD_SUP_DATA_FULL: ' || 'l_org_id = ' || l_org_id);
7793: msc_util.msc_log('LOAD_SUP_DATA_FULL: ' || 'l_calendar_code = ' || l_calendar_code);
7794:
7795: l_user_id := FND_GLOBAL.USER_ID;
7796:
7797: INSERT INTO MSC_ATP_SUMMARY_SUP(
7798: plan_id,
7799: sr_instance_id,

Line 8043: l_user_id := FND_GLOBAL.USER_ID;

8039: BEGIN
8040:
8041: msc_util.msc_log('******** LOAD_SUP_DATA_NET Begin ********');
8042:
8043: l_user_id := FND_GLOBAL.USER_ID;
8044:
8045: OPEN c_net_sup(p_plan_id, p_last_refresh_number, p_new_refresh_number);
8046: FETCH c_net_sup BULK COLLECT INTO l_sr_instance_id_tab,
8047: l_inventory_item_id_tab,

Line 8144: l_user_id := FND_GLOBAL.USER_ID;

8140: BEGIN
8141:
8142: msc_util.msc_log('******** LOAD_RES_FULL_UNOPT_BATCH Begin ********');
8143:
8144: l_user_id := FND_GLOBAL.USER_ID;
8145:
8146: -- summary enhancement - made changes to make it consistent with regular SQLs in MSCRATPB
8147: INSERT INTO MSC_ATP_SUMMARY_RES(
8148: plan_id,

Line 8296: l_user_id := FND_GLOBAL.USER_ID;

8292: BEGIN
8293:
8294: msc_util.msc_log('******** LOAD_RES_FULL_OPT_BATCH Begin ********');
8295:
8296: l_user_id := FND_GLOBAL.USER_ID;
8297:
8298: -- summary enhancement - made changes to make it consistent with regular SQLs in MSCRATPB
8299: INSERT INTO MSC_ATP_SUMMARY_RES(
8300: plan_id,

Line 8440: l_user_id := FND_GLOBAL.USER_ID;

8436: BEGIN
8437:
8438: msc_util.msc_log('******** LOAD_RES_FULL_UNOPT_NOBATCH Begin ********');
8439:
8440: l_user_id := FND_GLOBAL.USER_ID;
8441:
8442: -- summary enhancement - made changes to make it consistent with regular SQLs in MSCRATPB
8443: INSERT INTO MSC_ATP_SUMMARY_RES(
8444: plan_id,

Line 8557: l_user_id := FND_GLOBAL.USER_ID;

8553: BEGIN
8554:
8555: msc_util.msc_log('******** LOAD_RES_FULL_OPT_NOBATCH Begin ********');
8556:
8557: l_user_id := FND_GLOBAL.USER_ID;
8558:
8559: -- summary enhancement - made changes to make it consistent with regular SQLs in MSCRATPB
8560: INSERT INTO MSC_ATP_SUMMARY_RES(
8561: plan_id,

Line 8703: l_user_id := FND_GLOBAL.USER_ID;

8699: BEGIN
8700:
8701: msc_util.msc_log('******** LOAD_RES_DATA_NET Begin ********');
8702:
8703: l_user_id := FND_GLOBAL.USER_ID;
8704:
8705: OPEN c_net_res(p_plan_id, p_last_refresh_number, p_new_refresh_number);
8706: FETCH c_net_res BULK COLLECT INTO l_department_id_tab,
8707: l_resource_id_tab,