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

Line 387: l_resp_name varchar2(80) :=FND_GLOBAL.RESP_NAME;

383: l_old_date date;
384: l_new_date date;
385: l_qty number;
386: l_planner varchar2(40) := FND_PROFILE.VALUE('USERNAME');
387: l_resp_name varchar2(80) :=FND_GLOBAL.RESP_NAME;
388: TYPE PoCurTyp IS REF CURSOR;
389: poCur PoCurTyp;
390:
391: CURSOR buyer_c IS

Line 792: p_user_name varchar2(100); -- :=FND_GLOBAL.USER_NAME; --FND_PROFILE.VALUE('USERNAME');

788: where plan_id = arg_plan_id
789: and mp.sr_instance_id = mai.instance_id
790: and mai.instance_type = 3; -- xml fix
791:
792: p_user_name varchar2(100); -- :=FND_GLOBAL.USER_NAME; --FND_PROFILE.VALUE('USERNAME');
793: p_resp_name varchar2(80); -- :=FND_GLOBAL.RESP_NAME;
794: p_dblink varchar2(128);
795: p_instance_id number;
796: p_instance_code varchar2(3);

Line 793: p_resp_name varchar2(80); -- :=FND_GLOBAL.RESP_NAME;

789: and mp.sr_instance_id = mai.instance_id
790: and mai.instance_type = 3; -- xml fix
791:
792: p_user_name varchar2(100); -- :=FND_GLOBAL.USER_NAME; --FND_PROFILE.VALUE('USERNAME');
793: p_resp_name varchar2(80); -- :=FND_GLOBAL.RESP_NAME;
794: p_dblink varchar2(128);
795: p_instance_id number;
796: p_instance_code varchar2(3);
797: lv_sql_stmt varchar2(2000);

Line 815: p_user_name :=FND_GLOBAL.USER_NAME;

811: p_plan_type NUMBER;
812: BEGIN
813:
814: arg_count :=0;
815: p_user_name :=FND_GLOBAL.USER_NAME;
816: p_resp_name :=FND_GLOBAL.RESP_NAME;
817:
818: OPEN c_plan_type(arg_plan_id);
819: FETCH c_plan_type INTO p_plan_type;

Line 816: p_resp_name :=FND_GLOBAL.RESP_NAME;

812: BEGIN
813:
814: arg_count :=0;
815: p_user_name :=FND_GLOBAL.USER_NAME;
816: p_resp_name :=FND_GLOBAL.RESP_NAME;
817:
818: OPEN c_plan_type(arg_plan_id);
819: FETCH c_plan_type INTO p_plan_type;
820: CLOSE c_plan_type;

Line 1341: p_user_id number := FND_GLOBAL.USER_ID;

1337: , arg_so_rel_count IN OUT NOCOPY NumTblTyp
1338: , arg_so_pwb_count IN OUT NOCOPY NumTblTyp) IS
1339:
1340: -- p_user_id number := FND_PROFILE.value('USER_ID');
1341: p_user_id number := FND_GLOBAL.USER_ID;
1342: p_resp_id number := FND_GLOBAL.RESP_ID;
1343: p_release_by_user varchar2(3) :=
1344: nvl(FND_PROFILE.value('MSC_RELEASED_BY_USER_ONLY'),'N');
1345:

Line 1342: p_resp_id number := FND_GLOBAL.RESP_ID;

1338: , arg_so_pwb_count IN OUT NOCOPY NumTblTyp) IS
1339:
1340: -- p_user_id number := FND_PROFILE.value('USER_ID');
1341: p_user_id number := FND_GLOBAL.USER_ID;
1342: p_resp_id number := FND_GLOBAL.RESP_ID;
1343: p_release_by_user varchar2(3) :=
1344: nvl(FND_PROFILE.value('MSC_RELEASED_BY_USER_ONLY'),'N');
1345:
1346: TYPE NumTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 1388: p_user_name varchar2(80) :=FND_GLOBAL.USER_NAME;

1384: -- and mai.instance_type <> 3 -- xml fix
1385: and nvl(mai.apps_ver,1) <> 1; -- not back port to 107 yet
1386:
1387: -- p_user_name varchar2(30) :=FND_PROFILE.VALUE('USERNAME');
1388: p_user_name varchar2(80) :=FND_GLOBAL.USER_NAME;
1389: p_resp_name varchar2(80) :=FND_GLOBAL.RESP_NAME;
1390: p_dblink varchar2(128);
1391: p_aps_dblink varchar2(128);
1392: p_inst_id number;

Line 1389: p_resp_name varchar2(80) :=FND_GLOBAL.RESP_NAME;

1385: and nvl(mai.apps_ver,1) <> 1; -- not back port to 107 yet
1386:
1387: -- p_user_name varchar2(30) :=FND_PROFILE.VALUE('USERNAME');
1388: p_user_name varchar2(80) :=FND_GLOBAL.USER_NAME;
1389: p_resp_name varchar2(80) :=FND_GLOBAL.RESP_NAME;
1390: p_dblink varchar2(128);
1391: p_aps_dblink varchar2(128);
1392: p_inst_id number;
1393: lv_sql_stmt varchar2(2000);

Line 1849: l_user_name varchar2(30) := FND_GLOBAL.USER_NAME;

1845:
1846:
1847:
1848: --l_user_name varchar2(30) :=FND_PROFILE.VALUE('USERNAME');
1849: l_user_name varchar2(30) := FND_GLOBAL.USER_NAME;
1850:
1851:
1852: CURSOR db_cur IS
1853: select decode(M2A_dblink,null,' ','@'||M2A_dblink),

Line 1864: l_user_id number := FND_GLOBAL.USER_ID;

1860:
1861: sql_stmt varchar2(500);
1862: v_valid VARCHAR2(80);
1863:
1864: l_user_id number := FND_GLOBAL.USER_ID;
1865: l_resp_id number := FND_GLOBAL.RESP_ID;
1866: l_application_id number;
1867:
1868: BEGIN

Line 1865: l_resp_id number := FND_GLOBAL.RESP_ID;

1861: sql_stmt varchar2(500);
1862: v_valid VARCHAR2(80);
1863:
1864: l_user_id number := FND_GLOBAL.USER_ID;
1865: l_resp_id number := FND_GLOBAL.RESP_ID;
1866: l_application_id number;
1867:
1868: BEGIN
1869:

Line 1911: fnd_global.apps_initialize(l_user_id, l_resp_id, l_application_id);

1907: p_valid := 'S';
1908: end if;
1909:
1910: -- initialize context back to what it was initially
1911: fnd_global.apps_initialize(l_user_id, l_resp_id, l_application_id);
1912:
1913:
1914: exception when others then
1915: raise;

Line 2231: fnd_global.user_id,

2227: p_org_id,
2228: p_instance_id,
2229: p_owning_org,
2230: p_owning_instance,
2231: fnd_global.user_id,
2232: p_wip_group_id,
2233: null,
2234: null,
2235: p_apps_ver);

Line 2244: fnd_global.user_id,

2240: p_org_id,
2241: p_instance_id,
2242: p_owning_org,
2243: p_owning_instance,
2244: fnd_global.user_id,
2245: p_wip_group_id,
2246: null,
2247: null);
2248:

Line 2256: fnd_global.user_id,

2252: p_org_id,
2253: p_instance_id,
2254: p_owning_org,
2255: p_owning_instance,
2256: fnd_global.user_id,
2257: p_wip_group_id,
2258: null,
2259: null,
2260: p_apps_ver,

Line 2276: fnd_global.user_id,

2272: p_org_id,
2273: p_instance_id,
2274: p_owning_org,
2275: p_owning_instance,
2276: fnd_global.user_id,
2277: p_po_group_by,
2278: p_po_batch_number,
2279: null,
2280: null);

Line 2288: fnd_global.user_id,

2284: p_org_id,
2285: p_instance_id,
2286: p_owning_org,
2287: p_owning_instance,
2288: fnd_global.user_id,
2289: p_wip_group_id,
2290: null,
2291: null,
2292: p_apps_ver);

Line 2300: fnd_global.user_id,

2296: p_org_id,
2297: p_instance_id,
2298: p_owning_org,
2299: p_owning_instance,
2300: fnd_global.user_id,
2301: p_wip_group_id,
2302: null,
2303: null);
2304: end if;

Line 2363: USING FND_GLOBAL.USER_NAME,

2359: ||p_dblink
2360: ||'( :p_user, :p_resp, :p_app );'
2361: ||' END;';
2362: EXECUTE IMMEDIATE lv_sql_stmt
2363: USING FND_GLOBAL.USER_NAME,
2364: FND_GLOBAL.RESP_NAME,
2365: FND_GLOBAL.APPLICATION_NAME;
2366:
2367: msc_util.msc_debug('start reschedule in instance '||p_instance_code);

Line 2364: FND_GLOBAL.RESP_NAME,

2360: ||'( :p_user, :p_resp, :p_app );'
2361: ||' END;';
2362: EXECUTE IMMEDIATE lv_sql_stmt
2363: USING FND_GLOBAL.USER_NAME,
2364: FND_GLOBAL.RESP_NAME,
2365: FND_GLOBAL.APPLICATION_NAME;
2366:
2367: msc_util.msc_debug('start reschedule in instance '||p_instance_code);
2368: if p_load_type in (WIP_DIS_MASS_LOAD,WIP_REP_MASS_LOAD,

Line 2365: FND_GLOBAL.APPLICATION_NAME;

2361: ||' END;';
2362: EXECUTE IMMEDIATE lv_sql_stmt
2363: USING FND_GLOBAL.USER_NAME,
2364: FND_GLOBAL.RESP_NAME,
2365: FND_GLOBAL.APPLICATION_NAME;
2366:
2367: msc_util.msc_debug('start reschedule in instance '||p_instance_code);
2368: if p_load_type in (WIP_DIS_MASS_LOAD,WIP_REP_MASS_LOAD,
2369: WIP_DIS_MASS_RESCHEDULE) then

Line 2649: fnd_global.apps_initialize(l_user_id, l_resp_id, l_application_id);

2645: where application_Id = l_application_id
2646: and rownum =1 ;
2647: end;
2648:
2649: fnd_global.apps_initialize(l_user_id, l_resp_id, l_application_id);
2650: END init_db;
2651:
2652: PROCEDURE close_dblink(p_dblink varchar2) IS
2653: lv_sql_stmt VARCHAR2(2000);

Line 2703: SELECT FND_GLOBAL.USER_NAME,

2699: INTO lv_dblink, lv_dblink2
2700: FROM msc_apps_instances
2701: WHERE instance_id = p_instance_id;
2702:
2703: SELECT FND_GLOBAL.USER_NAME,
2704: FND_GLOBAL.RESP_NAME,
2705: FND_GLOBAL.APPLICATION_NAME
2706: INTO lv_user_name,
2707: lv_resp_name,

Line 2704: FND_GLOBAL.RESP_NAME,

2700: FROM msc_apps_instances
2701: WHERE instance_id = p_instance_id;
2702:
2703: SELECT FND_GLOBAL.USER_NAME,
2704: FND_GLOBAL.RESP_NAME,
2705: FND_GLOBAL.APPLICATION_NAME
2706: INTO lv_user_name,
2707: lv_resp_name,
2708: lv_application_name

Line 2705: FND_GLOBAL.APPLICATION_NAME

2701: WHERE instance_id = p_instance_id;
2702:
2703: SELECT FND_GLOBAL.USER_NAME,
2704: FND_GLOBAL.RESP_NAME,
2705: FND_GLOBAL.APPLICATION_NAME
2706: INTO lv_user_name,
2707: lv_resp_name,
2708: lv_application_name
2709: FROM dual;

Line 2982: last_updated_by = fnd_global.user_id

2978: release_status = decode(sign(p_plan_type-100),1,13,1),
2979: --- for rp, 13= mark for release
2980: status = 0,
2981: applied =2,
2982: last_updated_by = fnd_global.user_id
2983: where plan_id = p_plan_id
2984: and demand_id = v_set_demand_id(a);
2985: else -- if v_set_demand_id(a) = p_demand_id then
2986: p_arrival_date := v_planned_arrival_date(a);

Line 3082: last_updated_by = fnd_global.user_id

3078: reschedule_flag = 1,
3079: release_status = decode(sign(p_plan_type-100),1,13,1),
3080: status = 0,
3081: applied =2,
3082: last_updated_by = fnd_global.user_id
3083: where plan_id = p_plan_id
3084: and demand_id = v_set_demand_id(a);
3085: else -- if v_set_demand_id(a) = p_demand_id then
3086: p_ship_date := v_ship_date(a);