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 6662: l_user_id := FND_GLOBAL.USER_ID;

6658: BEGIN
6659:
6660: msc_util.msc_log('******** LOAD_SD_FULL_UNALLOC_UNOPT Begin ********');
6661:
6662: l_user_id := FND_GLOBAL.USER_ID;
6663:
6664: INSERT INTO MSC_ATP_SUMMARY_SD (
6665: plan_id,
6666: sr_instance_id,

Line 6802: l_user_id := FND_GLOBAL.USER_ID;

6798: BEGIN
6799:
6800: msc_util.msc_log('******** LOAD_SD_FULL_UNALLOC_UNOPT_PF Begin ********');
6801:
6802: l_user_id := FND_GLOBAL.USER_ID;
6803:
6804: INSERT INTO MSC_ATP_SUMMARY_SD (
6805: plan_id,
6806: sr_instance_id,

Line 6978: l_user_id := FND_GLOBAL.USER_ID;

6974: BEGIN
6975:
6976: msc_util.msc_log('******** LOAD_SD_FULL_UNALLOC_OPT Begin ********');
6977:
6978: l_user_id := FND_GLOBAL.USER_ID;
6979:
6980: INSERT INTO MSC_ATP_SUMMARY_SD (
6981: plan_id,
6982: sr_instance_id,

Line 7086: l_user_id := FND_GLOBAL.USER_ID;

7082: BEGIN
7083:
7084: msc_util.msc_log('******** LOAD_SD_FULL_UNALLOC_OPT_PF Begin ********');
7085:
7086: l_user_id := FND_GLOBAL.USER_ID;
7087:
7088: INSERT INTO MSC_ATP_SUMMARY_SD (
7089: plan_id,
7090: sr_instance_id,

Line 7238: l_user_id := FND_GLOBAL.USER_ID;

7234: BEGIN
7235:
7236: msc_util.msc_log('******** LOAD_SD_FULL_ALLOC Begin ********');
7237:
7238: l_user_id := FND_GLOBAL.USER_ID;
7239:
7240: INSERT INTO MSC_ATP_SUMMARY_SD (
7241: plan_id,
7242: sr_instance_id,

Line 7476: l_user_id := FND_GLOBAL.USER_ID;

7472: msc_util.msc_log('LOAD_SD_NET_UNALLOC: ' || 'p_last_refresh_number - ' || p_last_refresh_number);
7473: msc_util.msc_log('LOAD_SD_NET_UNALLOC: ' || 'p_new_refresh_number - ' || p_new_refresh_number);
7474: msc_util.msc_log('LOAD_SD_NET_UNALLOC: ' || 'p_time_phased_pf - ' || p_time_phased_pf);
7475:
7476: l_user_id := FND_GLOBAL.USER_ID;
7477:
7478: IF p_time_phased_pf = 2 THEN
7479: OPEN c_net_sd(p_plan_id, p_last_refresh_number, p_new_refresh_number);
7480: FETCH c_net_sd BULK COLLECT INTO l_sr_instance_id_tab,

Line 7637: l_user_id := FND_GLOBAL.USER_ID;

7633: BEGIN
7634:
7635: msc_util.msc_log('******** LOAD_SD_NET_ALLOC Begin ********');
7636:
7637: l_user_id := FND_GLOBAL.USER_ID;
7638:
7639: OPEN c_net_sd(p_plan_id, p_last_refresh_number, p_new_refresh_number);
7640: FETCH c_net_sd BULK COLLECT INTO l_sr_instance_id_tab,
7641: l_organization_id_tab,

Line 7766: l_user_id := FND_GLOBAL.USER_ID;

7762: msc_util.msc_log('LOAD_SUP_DATA_FULL: ' || 'l_instance_id = ' || l_instance_id);
7763: msc_util.msc_log('LOAD_SUP_DATA_FULL: ' || 'l_org_id = ' || l_org_id);
7764: msc_util.msc_log('LOAD_SUP_DATA_FULL: ' || 'l_calendar_code = ' || l_calendar_code);
7765:
7766: l_user_id := FND_GLOBAL.USER_ID;
7767:
7768: INSERT INTO MSC_ATP_SUMMARY_SUP(
7769: plan_id,
7770: sr_instance_id,

Line 8014: l_user_id := FND_GLOBAL.USER_ID;

8010: BEGIN
8011:
8012: msc_util.msc_log('******** LOAD_SUP_DATA_NET Begin ********');
8013:
8014: l_user_id := FND_GLOBAL.USER_ID;
8015:
8016: OPEN c_net_sup(p_plan_id, p_last_refresh_number, p_new_refresh_number);
8017: FETCH c_net_sup BULK COLLECT INTO l_sr_instance_id_tab,
8018: l_inventory_item_id_tab,

Line 8115: l_user_id := FND_GLOBAL.USER_ID;

8111: BEGIN
8112:
8113: msc_util.msc_log('******** LOAD_RES_FULL_UNOPT_BATCH Begin ********');
8114:
8115: l_user_id := FND_GLOBAL.USER_ID;
8116:
8117: -- summary enhancement - made changes to make it consistent with regular SQLs in MSCRATPB
8118: INSERT INTO MSC_ATP_SUMMARY_RES(
8119: plan_id,

Line 8267: l_user_id := FND_GLOBAL.USER_ID;

8263: BEGIN
8264:
8265: msc_util.msc_log('******** LOAD_RES_FULL_OPT_BATCH Begin ********');
8266:
8267: l_user_id := FND_GLOBAL.USER_ID;
8268:
8269: -- summary enhancement - made changes to make it consistent with regular SQLs in MSCRATPB
8270: INSERT INTO MSC_ATP_SUMMARY_RES(
8271: plan_id,

Line 8411: l_user_id := FND_GLOBAL.USER_ID;

8407: BEGIN
8408:
8409: msc_util.msc_log('******** LOAD_RES_FULL_UNOPT_NOBATCH Begin ********');
8410:
8411: l_user_id := FND_GLOBAL.USER_ID;
8412:
8413: -- summary enhancement - made changes to make it consistent with regular SQLs in MSCRATPB
8414: INSERT INTO MSC_ATP_SUMMARY_RES(
8415: plan_id,

Line 8528: l_user_id := FND_GLOBAL.USER_ID;

8524: BEGIN
8525:
8526: msc_util.msc_log('******** LOAD_RES_FULL_OPT_NOBATCH Begin ********');
8527:
8528: l_user_id := FND_GLOBAL.USER_ID;
8529:
8530: -- summary enhancement - made changes to make it consistent with regular SQLs in MSCRATPB
8531: INSERT INTO MSC_ATP_SUMMARY_RES(
8532: plan_id,

Line 8674: l_user_id := FND_GLOBAL.USER_ID;

8670: BEGIN
8671:
8672: msc_util.msc_log('******** LOAD_RES_DATA_NET Begin ********');
8673:
8674: l_user_id := FND_GLOBAL.USER_ID;
8675:
8676: OPEN c_net_res(p_plan_id, p_last_refresh_number, p_new_refresh_number);
8677: FETCH c_net_res BULK COLLECT INTO l_department_id_tab,
8678: l_resource_id_tab,