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 772: p_user_name varchar2(30) :=FND_GLOBAL.USER_NAME; --FND_PROFILE.VALUE('USERNAME');

768: where plan_id = arg_plan_id
769: and mp.sr_instance_id = mai.instance_id
770: and mai.instance_type = 3; -- xml fix
771:
772: p_user_name varchar2(30) :=FND_GLOBAL.USER_NAME; --FND_PROFILE.VALUE('USERNAME');
773: p_resp_name varchar2(80) :=FND_GLOBAL.RESP_NAME;
774: p_dblink varchar2(128);
775: p_instance_id number;
776: p_instance_code varchar2(3);

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

769: and mp.sr_instance_id = mai.instance_id
770: and mai.instance_type = 3; -- xml fix
771:
772: p_user_name varchar2(30) :=FND_GLOBAL.USER_NAME; --FND_PROFILE.VALUE('USERNAME');
773: p_resp_name varchar2(80) :=FND_GLOBAL.RESP_NAME;
774: p_dblink varchar2(128);
775: p_instance_id number;
776: p_instance_code varchar2(3);
777: lv_sql_stmt varchar2(2000);

Line 1189: p_user_id number := FND_GLOBAL.USER_ID;

1185: , arg_so_rel_count IN OUT NOCOPY NumTblTyp
1186: , arg_so_pwb_count IN OUT NOCOPY NumTblTyp) IS
1187:
1188: -- p_user_id number := FND_PROFILE.value('USER_ID');
1189: p_user_id number := FND_GLOBAL.USER_ID;
1190: p_resp_id number := FND_GLOBAL.RESP_ID;
1191: p_release_by_user varchar2(3) :=
1192: nvl(FND_PROFILE.value('MSC_RELEASED_BY_USER_ONLY'),'N');
1193:

Line 1190: p_resp_id number := FND_GLOBAL.RESP_ID;

1186: , arg_so_pwb_count IN OUT NOCOPY NumTblTyp) IS
1187:
1188: -- p_user_id number := FND_PROFILE.value('USER_ID');
1189: p_user_id number := FND_GLOBAL.USER_ID;
1190: p_resp_id number := FND_GLOBAL.RESP_ID;
1191: p_release_by_user varchar2(3) :=
1192: nvl(FND_PROFILE.value('MSC_RELEASED_BY_USER_ONLY'),'N');
1193:
1194: TYPE NumTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

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

1232: -- and mai.instance_type <> 3 -- xml fix
1233: and nvl(mai.apps_ver,1) <> 1; -- not back port to 107 yet
1234:
1235: -- p_user_name varchar2(30) :=FND_PROFILE.VALUE('USERNAME');
1236: p_user_name varchar2(80) :=FND_GLOBAL.USER_NAME;
1237: p_resp_name varchar2(80) :=FND_GLOBAL.RESP_NAME;
1238: p_dblink varchar2(128);
1239: p_aps_dblink varchar2(128);
1240: p_inst_id number;

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

1233: and nvl(mai.apps_ver,1) <> 1; -- not back port to 107 yet
1234:
1235: -- p_user_name varchar2(30) :=FND_PROFILE.VALUE('USERNAME');
1236: p_user_name varchar2(80) :=FND_GLOBAL.USER_NAME;
1237: p_resp_name varchar2(80) :=FND_GLOBAL.RESP_NAME;
1238: p_dblink varchar2(128);
1239: p_aps_dblink varchar2(128);
1240: p_inst_id number;
1241: lv_sql_stmt varchar2(2000);

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

1610:
1611:
1612:
1613: --l_user_name varchar2(30) :=FND_PROFILE.VALUE('USERNAME');
1614: l_user_name varchar2(30) := FND_GLOBAL.USER_NAME;
1615:
1616:
1617: CURSOR db_cur IS
1618: select decode(M2A_dblink,null,' ','@'||M2A_dblink),

Line 1629: l_user_id number := FND_GLOBAL.USER_ID;

1625:
1626: sql_stmt varchar2(500);
1627: v_valid VARCHAR2(80);
1628:
1629: l_user_id number := FND_GLOBAL.USER_ID;
1630: l_resp_id number := FND_GLOBAL.RESP_ID;
1631: l_application_id number;
1632:
1633: BEGIN

Line 1630: l_resp_id number := FND_GLOBAL.RESP_ID;

1626: sql_stmt varchar2(500);
1627: v_valid VARCHAR2(80);
1628:
1629: l_user_id number := FND_GLOBAL.USER_ID;
1630: l_resp_id number := FND_GLOBAL.RESP_ID;
1631: l_application_id number;
1632:
1633: BEGIN
1634:

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

1672: p_valid := 'S';
1673: end if;
1674:
1675: -- initialize context back to what it was initially
1676: fnd_global.apps_initialize(l_user_id, l_resp_id, l_application_id);
1677:
1678:
1679: exception when others then
1680: raise;

Line 1980: fnd_global.user_id,

1976: p_org_id,
1977: p_instance_id,
1978: p_owning_org,
1979: p_owning_instance,
1980: fnd_global.user_id,
1981: p_wip_group_id,
1982: null,
1983: null,
1984: p_apps_ver);

Line 1993: fnd_global.user_id,

1989: p_org_id,
1990: p_instance_id,
1991: p_owning_org,
1992: p_owning_instance,
1993: fnd_global.user_id,
1994: p_wip_group_id,
1995: null,
1996: null);
1997:

Line 2005: fnd_global.user_id,

2001: p_org_id,
2002: p_instance_id,
2003: p_owning_org,
2004: p_owning_instance,
2005: fnd_global.user_id,
2006: p_wip_group_id,
2007: null,
2008: null,
2009: p_apps_ver,

Line 2025: fnd_global.user_id,

2021: p_org_id,
2022: p_instance_id,
2023: p_owning_org,
2024: p_owning_instance,
2025: fnd_global.user_id,
2026: p_po_group_by,
2027: p_po_batch_number,
2028: null,
2029: null);

Line 2037: fnd_global.user_id,

2033: p_org_id,
2034: p_instance_id,
2035: p_owning_org,
2036: p_owning_instance,
2037: fnd_global.user_id,
2038: p_wip_group_id,
2039: null,
2040: null,
2041: p_apps_ver);

Line 2049: fnd_global.user_id,

2045: p_org_id,
2046: p_instance_id,
2047: p_owning_org,
2048: p_owning_instance,
2049: fnd_global.user_id,
2050: p_wip_group_id,
2051: null,
2052: null);
2053: end if;

Line 2112: USING FND_GLOBAL.USER_NAME,

2108: ||p_dblink
2109: ||'( :p_user, :p_resp, :p_app );'
2110: ||' END;';
2111: EXECUTE IMMEDIATE lv_sql_stmt
2112: USING FND_GLOBAL.USER_NAME,
2113: FND_GLOBAL.RESP_NAME,
2114: FND_GLOBAL.APPLICATION_NAME;
2115:
2116: msc_util.msc_debug('start reschedule in instance '||p_instance_code);

Line 2113: FND_GLOBAL.RESP_NAME,

2109: ||'( :p_user, :p_resp, :p_app );'
2110: ||' END;';
2111: EXECUTE IMMEDIATE lv_sql_stmt
2112: USING FND_GLOBAL.USER_NAME,
2113: FND_GLOBAL.RESP_NAME,
2114: FND_GLOBAL.APPLICATION_NAME;
2115:
2116: msc_util.msc_debug('start reschedule in instance '||p_instance_code);
2117: if p_load_type in (WIP_DIS_MASS_LOAD,WIP_REP_MASS_LOAD,

Line 2114: FND_GLOBAL.APPLICATION_NAME;

2110: ||' END;';
2111: EXECUTE IMMEDIATE lv_sql_stmt
2112: USING FND_GLOBAL.USER_NAME,
2113: FND_GLOBAL.RESP_NAME,
2114: FND_GLOBAL.APPLICATION_NAME;
2115:
2116: msc_util.msc_debug('start reschedule in instance '||p_instance_code);
2117: if p_load_type in (WIP_DIS_MASS_LOAD,WIP_REP_MASS_LOAD,
2118: WIP_DIS_MASS_RESCHEDULE) then

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

2394: where application_Id = l_application_id
2395: and rownum =1 ;
2396: end;
2397:
2398: fnd_global.apps_initialize(l_user_id, l_resp_id, l_application_id);
2399: END init_db;
2400:
2401: PROCEDURE close_dblink(p_dblink varchar2) IS
2402: lv_sql_stmt VARCHAR2(2000);

Line 2452: SELECT FND_GLOBAL.USER_NAME,

2448: INTO lv_dblink, lv_dblink2
2449: FROM msc_apps_instances
2450: WHERE instance_id = p_instance_id;
2451:
2452: SELECT FND_GLOBAL.USER_NAME,
2453: FND_GLOBAL.RESP_NAME,
2454: FND_GLOBAL.APPLICATION_NAME
2455: INTO lv_user_name,
2456: lv_resp_name,

Line 2453: FND_GLOBAL.RESP_NAME,

2449: FROM msc_apps_instances
2450: WHERE instance_id = p_instance_id;
2451:
2452: SELECT FND_GLOBAL.USER_NAME,
2453: FND_GLOBAL.RESP_NAME,
2454: FND_GLOBAL.APPLICATION_NAME
2455: INTO lv_user_name,
2456: lv_resp_name,
2457: lv_application_name

Line 2454: FND_GLOBAL.APPLICATION_NAME

2450: WHERE instance_id = p_instance_id;
2451:
2452: SELECT FND_GLOBAL.USER_NAME,
2453: FND_GLOBAL.RESP_NAME,
2454: FND_GLOBAL.APPLICATION_NAME
2455: INTO lv_user_name,
2456: lv_resp_name,
2457: lv_application_name
2458: FROM dual;

Line 2717: last_updated_by = fnd_global.user_id

2713: reschedule_flag = 1,
2714: release_status = 1,
2715: status = 0,
2716: applied =2,
2717: last_updated_by = fnd_global.user_id
2718: where plan_id = p_plan_id
2719: and demand_id = v_set_demand_id(a);
2720: else -- if v_set_demand_id(a) = p_demand_id then
2721: p_arrival_date := v_planned_arrival_date(a);

Line 2817: last_updated_by = fnd_global.user_id

2813: reschedule_flag = 1,
2814: release_status = 1,
2815: status = 0,
2816: applied =2,
2817: last_updated_by = fnd_global.user_id
2818: where plan_id = p_plan_id
2819: and demand_id = v_set_demand_id(a);
2820: else -- if v_set_demand_id(a) = p_demand_id then
2821: p_ship_date := v_ship_date(a);