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.FND_PROFILE dependencies on FND_GLOBAL

Line 575: orgId IN NUMBER DEFAULT fnd_global.org_id

571: FUNCTION get_org_value
572: (
573: profileOptionId IN NUMBER,
574: applicationId IN NUMBER,
575: orgId IN NUMBER DEFAULT fnd_global.org_id
576: ) RETURN VARCHAR2 RESULT_CACHE IS
577: orgLevelValue VARCHAR2(240);
578: profileName VARCHAR2(80) := get_profile_name(profileOptionId,
579: applicationId);

Line 1316: ** CALL VIA FND_GLOBAL.INITIALIZE('ORG_ID',org_id)

1312: | Private AOL INTERNAL USE ONLY APIs
1313: ========================================================================*/
1314: /*
1315: ** FOR AOL INTERNAL USE ONLY - DO NOT CALL DIRECTLY,
1316: ** CALL VIA FND_GLOBAL.INITIALIZE('ORG_ID',org_id)
1317: ** FND_PROFILE.INITIALIZE also calls this API to initialize the org context.
1318: **
1319: ** initialize_org_context - Initializes the org context
1320: */

Line 1324: profiles_org_id := fnd_global.org_id;

1320: */
1321: PROCEDURE initialize_org_context IS
1322: BEGIN
1323: -- Set Global organization context
1324: profiles_org_id := fnd_global.org_id;
1325: -- Cache org-specific transient profile options in Public Put cache
1326: put('CURRENT_ORG_CONTEXT', to_char(fnd_global.org_id));
1327: put('ORG_NAME', fnd_global.org_name);
1328: -- Bug 16327915, ORG_ID is stored in Public PUT cache by Forms user exit.

Line 1326: put('CURRENT_ORG_CONTEXT', to_char(fnd_global.org_id));

1322: BEGIN
1323: -- Set Global organization context
1324: profiles_org_id := fnd_global.org_id;
1325: -- Cache org-specific transient profile options in Public Put cache
1326: put('CURRENT_ORG_CONTEXT', to_char(fnd_global.org_id));
1327: put('ORG_NAME', fnd_global.org_name);
1328: -- Bug 16327915, ORG_ID is stored in Public PUT cache by Forms user exit.
1329: -- purge previous context cached value of ORG_ID
1330: -- so that the value for current context can be found.

Line 1327: put('ORG_NAME', fnd_global.org_name);

1323: -- Set Global organization context
1324: profiles_org_id := fnd_global.org_id;
1325: -- Cache org-specific transient profile options in Public Put cache
1326: put('CURRENT_ORG_CONTEXT', to_char(fnd_global.org_id));
1327: put('ORG_NAME', fnd_global.org_name);
1328: -- Bug 16327915, ORG_ID is stored in Public PUT cache by Forms user exit.
1329: -- purge previous context cached value of ORG_ID
1330: -- so that the value for current context can be found.
1331: put('ORG_ID', FND_DELETE_VALUE);

Line 1334: -- equivalent of FND_GLOBAL.ORG_ID, which is the org context. The

1330: -- so that the value for current context can be found.
1331: put('ORG_ID', FND_DELETE_VALUE);
1332:
1333: -- Note: For R12, the profile option ORG_ID is not always an
1334: -- equivalent of FND_GLOBAL.ORG_ID, which is the org context. The
1335: -- global variable PROFILES_ORG_ID is the org context used for
1336: -- evaluating org-level profile option values and should be equal to
1337: -- FND_GLOBAL.ORG_ID. A value fetch on the profile option ORG_ID
1338: -- should return the profile option table value, not the org context.

Line 1337: -- FND_GLOBAL.ORG_ID. A value fetch on the profile option ORG_ID

1333: -- Note: For R12, the profile option ORG_ID is not always an
1334: -- equivalent of FND_GLOBAL.ORG_ID, which is the org context. The
1335: -- global variable PROFILES_ORG_ID is the org context used for
1336: -- evaluating org-level profile option values and should be equal to
1337: -- FND_GLOBAL.ORG_ID. A value fetch on the profile option ORG_ID
1338: -- should return the profile option table value, not the org context.
1339: -- This behavior was confirmed with JMARY and SHNARAYA of the MO Team.
1340: -- CURRENT_ORG_CONTEXT is being introduced so that profiles code can
1341: -- provide similar functionality such that FND_GLOBAL.ORG_ID will be

Line 1341: -- provide similar functionality such that FND_GLOBAL.ORG_ID will be

1337: -- FND_GLOBAL.ORG_ID. A value fetch on the profile option ORG_ID
1338: -- should return the profile option table value, not the org context.
1339: -- This behavior was confirmed with JMARY and SHNARAYA of the MO Team.
1340: -- CURRENT_ORG_CONTEXT is being introduced so that profiles code can
1341: -- provide similar functionality such that FND_GLOBAL.ORG_ID will be
1342: -- equivalent to FND_PROFILE.VALUE('CURRENT_ORG_CONTEXT').
1343: -- FND_PROFILE.VALUE('ORG_ID') will return a value obtained in the
1344: -- FND_PROFILE_OPTION_VALUES table.
1345:

Line 1350: ** FND_GLOBAL.APPS_INITIALIZE

1346: END initialize_org_context;
1347:
1348: /*
1349: ** FOR AOL INTERNAL USE ONLY - DO NOT CALL DIRECTLY, CALL VIA
1350: ** FND_GLOBAL.APPS_INITIALIZE
1351: ** initialize - Initialize the internal profile information
1352: ** The cache is cleared of all database (non-put) options first.
1353: ** Initializes the profiles for the level context information.
1354: */

Line 1370: -- should only be tested by FND_GLOBAL after a call to INITIALIZE

1366: -- Get session ID
1367: NewICXSessionId := icx_sec.g_session_id;
1368:
1369: -- Bug 12875860, We initialize the put cache clear flag here since it
1370: -- should only be tested by FND_GLOBAL after a call to INITIALIZE
1371: put_cache_is_clear := FALSE;
1372:
1373: -- Log the session IDs for reference.
1374: corelog_line('Session IDs: CISId=' || current_icx_session_id ||

Line 1394: -- mskees 9/1/2011 this is a little used flag for FND_GLOBAL

1390: (current_icx_session_id <> DEFAULT_CONTEXT) AND
1391: (NewICXSessionId <> DEFAULT_CONTEXT))) THEN
1392: name_tab.delete();
1393: val_tab.delete();
1394: -- mskees 9/1/2011 this is a little used flag for FND_GLOBAL
1395: inserted := 0; -- reset PUT count
1396: -- Bug 12875860 set flag for FND_GLOBAL
1397: put_cache_is_clear := TRUE;
1398: -- userenv('sessionid') is the database session id. It is used by

Line 1396: -- Bug 12875860 set flag for FND_GLOBAL

1392: name_tab.delete();
1393: val_tab.delete();
1394: -- mskees 9/1/2011 this is a little used flag for FND_GLOBAL
1395: inserted := 0; -- reset PUT count
1396: -- Bug 12875860 set flag for FND_GLOBAL
1397: put_cache_is_clear := TRUE;
1398: -- userenv('sessionid') is the database session id. It is used by
1399: -- FND_GLOBAL for core logging, and is used here to facilitate better
1400: -- readability of afcorelog_*.txt.

Line 1399: -- FND_GLOBAL for core logging, and is used here to facilitate better

1395: inserted := 0; -- reset PUT count
1396: -- Bug 12875860 set flag for FND_GLOBAL
1397: put_cache_is_clear := TRUE;
1398: -- userenv('sessionid') is the database session id. It is used by
1399: -- FND_GLOBAL for core logging, and is used here to facilitate better
1400: -- readability of afcorelog_*.txt.
1401: corelog_line('Public Put cache purged:CSId=' ||
1402: current_icx_session_id || ':SId=' || NewICXSessionId || ':' ||
1403: userenv('sessionid'));

Line 1411: profiles_server_id := fnd_global.server_id;

1407: current_icx_session_id := NewICXSessionId;
1408: profiles_user_id := user_id_z;
1409: profiles_resp_id := responsibility_id_z;
1410: profiles_appl_id := application_id_z;
1411: profiles_server_id := fnd_global.server_id;
1412:
1413: -- Cache the user context passed in
1414: IF (user_id_z IS NOT NULL) THEN
1415: put('USER_ID', to_char(user_id_z));

Line 1416: IF (user_id_z = fnd_global.user_id) THEN

1412:
1413: -- Cache the user context passed in
1414: IF (user_id_z IS NOT NULL) THEN
1415: put('USER_ID', to_char(user_id_z));
1416: IF (user_id_z = fnd_global.user_id) THEN
1417: -- Use global to avoid select if current user
1418: tempName := fnd_global.user_name;
1419: ELSIF (user_id_z = DEFAULT_CONTEXT) THEN
1420: tempName := 'DEFAULT_USER';

Line 1418: tempName := fnd_global.user_name;

1414: IF (user_id_z IS NOT NULL) THEN
1415: put('USER_ID', to_char(user_id_z));
1416: IF (user_id_z = fnd_global.user_id) THEN
1417: -- Use global to avoid select if current user
1418: tempName := fnd_global.user_name;
1419: ELSIF (user_id_z = DEFAULT_CONTEXT) THEN
1420: tempName := 'DEFAULT_USER';
1421: ELSE
1422: BEGIN

Line 1442: fnd_global.org_id,

1438: 'INITIALIZE',
1439: user_id_z,
1440: responsibility_id_z,
1441: application_id_z,
1442: fnd_global.org_id,
1443: fnd_global.server_id);
1444:
1445: -- Cache the responsibility context passed in
1446: IF ((responsibility_id_z IS NOT NULL) AND

Line 1443: fnd_global.server_id);

1439: user_id_z,
1440: responsibility_id_z,
1441: application_id_z,
1442: fnd_global.org_id,
1443: fnd_global.server_id);
1444:
1445: -- Cache the responsibility context passed in
1446: IF ((responsibility_id_z IS NOT NULL) AND
1447: (application_id_z IS NOT NULL)) THEN

Line 1450: IF ((responsibility_id_z = fnd_global.resp_id) AND

1446: IF ((responsibility_id_z IS NOT NULL) AND
1447: (application_id_z IS NOT NULL)) THEN
1448: put('RESP_ID', to_char(responsibility_id_z));
1449: put('RESP_APPL_ID', to_char(application_id_z));
1450: IF ((responsibility_id_z = fnd_global.resp_id) AND
1451: (application_id_z = fnd_global.resp_appl_id)) THEN
1452: -- Use global to avoid select if current resp
1453: tempName := fnd_global.resp_name;
1454: ELSIF ((responsibility_id_z = DEFAULT_CONTEXT) AND

Line 1451: (application_id_z = fnd_global.resp_appl_id)) THEN

1447: (application_id_z IS NOT NULL)) THEN
1448: put('RESP_ID', to_char(responsibility_id_z));
1449: put('RESP_APPL_ID', to_char(application_id_z));
1450: IF ((responsibility_id_z = fnd_global.resp_id) AND
1451: (application_id_z = fnd_global.resp_appl_id)) THEN
1452: -- Use global to avoid select if current resp
1453: tempName := fnd_global.resp_name;
1454: ELSIF ((responsibility_id_z = DEFAULT_CONTEXT) AND
1455: (application_id_z = DEFAULT_CONTEXT)) THEN

Line 1453: tempName := fnd_global.resp_name;

1449: put('RESP_APPL_ID', to_char(application_id_z));
1450: IF ((responsibility_id_z = fnd_global.resp_id) AND
1451: (application_id_z = fnd_global.resp_appl_id)) THEN
1452: -- Use global to avoid select if current resp
1453: tempName := fnd_global.resp_name;
1454: ELSIF ((responsibility_id_z = DEFAULT_CONTEXT) AND
1455: (application_id_z = DEFAULT_CONTEXT)) THEN
1456: tempName := 'DEFAULT_RESP';
1457: ELSE

Line 1473: put('SERVER_ID', to_char(fnd_global.server_id));

1469: put('RESP_NAME', tempName);
1470: END IF;
1471:
1472: -- Place the server context in Public Put cache
1473: put('SERVER_ID', to_char(fnd_global.server_id));
1474:
1475: BEGIN
1476: SELECT node_name
1477: INTO tempName

Line 1479: WHERE node_id = fnd_global.server_id;

1475: BEGIN
1476: SELECT node_name
1477: INTO tempName
1478: FROM fnd_nodes
1479: WHERE node_id = fnd_global.server_id;
1480: EXCEPTION
1481: WHEN OTHERS THEN
1482: tempName := '';
1483: END;

Line 1940: result := SAVE(x_name, x_value, 'USER', fnd_global.user_id);

1936: x_value IN VARCHAR2 /* Profile value you are setting */
1937: ) RETURN BOOLEAN IS
1938: result BOOLEAN;
1939: BEGIN
1940: result := SAVE(x_name, x_value, 'USER', fnd_global.user_id);
1941: RETURN result;
1942: END save_user;
1943:
1944: /*

Line 2226: nvl(fnd_global.user_id,

2222: x_level_value_app_id,
2223: levelValue2Actual,
2224: x_value,
2225: SYSDATE,
2226: nvl(fnd_global.user_id,
2227: DEFAULT_CONTEXT),
2228: nvl(fnd_global.login_id,
2229: DEFAULT_CONTEXT));
2230: -- raise cache invalidation event for processes monitoring the

Line 2228: nvl(fnd_global.login_id,

2224: x_value,
2225: SYSDATE,
2226: nvl(fnd_global.user_id,
2227: DEFAULT_CONTEXT),
2228: nvl(fnd_global.login_id,
2229: DEFAULT_CONTEXT));
2230: -- raise cache invalidation event for processes monitoring the
2231: -- event
2232: invalidate_cache(profNameUpper,

Line 2246: nvl(fnd_global.user_id,

2242: x_level_value_app_id,
2243: NULL,
2244: x_value,
2245: SYSDATE,
2246: nvl(fnd_global.user_id,
2247: DEFAULT_CONTEXT),
2248: nvl(fnd_global.login_id,
2249: DEFAULT_CONTEXT));
2250: -- raise cache invalidation event for processes monitoring the

Line 2248: nvl(fnd_global.login_id,

2244: x_value,
2245: SYSDATE,
2246: nvl(fnd_global.user_id,
2247: DEFAULT_CONTEXT),
2248: nvl(fnd_global.login_id,
2249: DEFAULT_CONTEXT));
2250: -- raise cache invalidation event for processes monitoring the
2251: -- event
2252: invalidate_cache(profNameUpper,