111:
112: -----------------------
113: -- Package Constants --
114: -----------------------
115: c_resp_app_id CONSTANT NUMBER := FND_GLOBAL.RESP_APPL_ID;
116:
117: c_user_id CONSTANT NUMBER := FND_GLOBAL.USER_ID;
118: c_login_id NUMBER := FND_GLOBAL.Login_Id;
119:
113: -- Package Constants --
114: -----------------------
115: c_resp_app_id CONSTANT NUMBER := FND_GLOBAL.RESP_APPL_ID;
116:
117: c_user_id CONSTANT NUMBER := FND_GLOBAL.USER_ID;
118: c_login_id NUMBER := FND_GLOBAL.Login_Id;
119:
120: c_module_pkg CONSTANT VARCHAR2(80) := 'fem.plsql.fem_dimension_util_pkg';
121: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_DIMENSION_UTIL_PKG';
114: -----------------------
115: c_resp_app_id CONSTANT NUMBER := FND_GLOBAL.RESP_APPL_ID;
116:
117: c_user_id CONSTANT NUMBER := FND_GLOBAL.USER_ID;
118: c_login_id NUMBER := FND_GLOBAL.Login_Id;
119:
120: c_module_pkg CONSTANT VARCHAR2(80) := 'fem.plsql.fem_dimension_util_pkg';
121: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_DIMENSION_UTIL_PKG';
122:
310: IF (v_session_ledger_id IS NULL)
311: THEN
312: v_ledger_id := FND_PROFILE.VALUE_SPECIFIC (
313: c_fem_ledger,
314: fnd_global.user_id,
315: null ,null);
316: ELSE
317: v_ledger_id := v_session_ledger_id;
318: END IF;
426: IF (v_session_ledger_id IS NULL)
427: THEN
428: v_ledger_id := FND_PROFILE.VALUE_SPECIFIC (
429: c_fem_ledger,
430: fnd_global.user_id,
431: null ,null);
432: ELSE
433: v_ledger_id := v_session_ledger_id;
434: END IF;
716: --Bug#5604779: Use Value_Specific to prevent caching
717: --v_current_session_ledger_id := FND_PROFILE.VALUE (c_fem_ledger);
718: v_current_session_ledger_id := FND_PROFILE.VALUE_SPECIFIC(
719: c_fem_ledger,
720: fnd_global.user_id,
721: null,null);
722: ELSE v_current_session_ledger_id := p_ledger_id;
723: END IF;
724: