DBA Data[Home] [Help]

APPS.WFA_SEC dependencies on FND_GLOBAL

Line 15: -- context counter to validate if any FND_GLOBAL initialize API

11: -- ICX Session Id cache
12: g_session_id number := -1;
13:
14: -- Bug 7828862 cache variables for EBS context synchronization
15: -- context counter to validate if any FND_GLOBAL initialize API
16: -- was called. We will default to the standard values used in WF
17: g_cached boolean := false;
18: g_session_ctx number := 0;
19: g_user_id number := 0;

Line 855: WF_CORE.LOCAL_CS_NL := Fnd_Global.Local_Chr(ascii_chr);

851: begin
852: if (ascii_chr = 10) then
853:
854: if (WF_CORE.LOCAL_CS_NL is null) then
855: WF_CORE.LOCAL_CS_NL := Fnd_Global.Local_Chr(ascii_chr);
856: end if;
857:
858: return WF_CORE.LOCAL_CS_NL;
859:

Line 863: WF_CORE.LOCAL_CS_TB := Fnd_Global.Local_Chr(ascii_chr);

859:
860: elsif (ascii_chr = 9) then
861:
862: if (WF_CORE.LOCAL_CS_TB is null) then
863: WF_CORE.LOCAL_CS_TB := Fnd_Global.Local_Chr(ascii_chr);
864: end if;
865:
866: return WF_CORE.LOCAL_CS_TB;
867:

Line 871: WF_CORE.LOCAL_CS_CR := Fnd_Global.Local_Chr(ascii_chr);

867:
868: elsif (ascii_chr = 13) then
869:
870: if (WF_CORE.LOCAL_CS_CR is null) then
871: WF_CORE.LOCAL_CS_CR := Fnd_Global.Local_Chr(ascii_chr);
872: end if;
873:
874: return WF_CORE.LOCAL_CS_CR;
875:

Line 878: return(Fnd_Global.Local_Chr(ascii_chr));

874: return WF_CORE.LOCAL_CS_CR;
875:
876: else
877:
878: return(Fnd_Global.Local_Chr(ascii_chr));
879:
880: end if;
881:
882: end Local_Chr;

Line 912: return FND_GLOBAL.USER_NAME;

908: function GetFWKUserName
909: return varchar2
910: is
911: begin
912: return FND_GLOBAL.USER_NAME;
913: exception
914: when others then
915: Wf_Core.Context('Wfa_Sec', 'GetFWKUserName');
916: raise;

Line 1020: -- Return current user id, in apps, wrapper to FND_GLOBAL.user_id

1016:
1017:
1018: --
1019: -- user_id
1020: -- Return current user id, in apps, wrapper to FND_GLOBAL.user_id
1021: -- In standalone, returns -1.
1022: function user_id return number is
1023:
1024: begin

Line 1025: return FND_GLOBAL.user_id;

1021: -- In standalone, returns -1.
1022: function user_id return number is
1023:
1024: begin
1025: return FND_GLOBAL.user_id;
1026: end;
1027:
1028: --
1029: -- login_id

Line 1030: -- Return current login id, in apps, wrapper to FND_GLOBAL.login_id

1026: end;
1027:
1028: --
1029: -- login_id
1030: -- Return current login id, in apps, wrapper to FND_GLOBAL.login_id
1031: -- In standalone, returns -1.
1032: function login_id return number is
1033: begin
1034: return FND_GLOBAL.login_id;

Line 1034: return FND_GLOBAL.login_id;

1030: -- Return current login id, in apps, wrapper to FND_GLOBAL.login_id
1031: -- In standalone, returns -1.
1032: function login_id return number is
1033: begin
1034: return FND_GLOBAL.login_id;
1035: end;
1036:
1037: --
1038: -- security_group_id

Line 1040: -- FND_GLOBAL.security_group_id In standalone, returns -1.

1036:
1037: --
1038: -- security_group_id
1039: -- Return current security_group_id, in apps, wrapper to
1040: -- FND_GLOBAL.security_group_id In standalone, returns -1.
1041: function security_group_id return number is
1042: begin
1043: return FND_GLOBAL.security_group_id;
1044: end;

Line 1043: return FND_GLOBAL.security_group_id;

1039: -- Return current security_group_id, in apps, wrapper to
1040: -- FND_GLOBAL.security_group_id In standalone, returns -1.
1041: function security_group_id return number is
1042: begin
1043: return FND_GLOBAL.security_group_id;
1044: end;
1045:
1046: --
1047: -- CheckSession

Line 1080: -- resp_appl_id and so on from FND_GLOBAL package

1076:
1077: --
1078: -- CacheCtx
1079: -- Caches current session context values such as user_id, resp_id,
1080: -- resp_appl_id and so on from FND_GLOBAL package
1081: --
1082: procedure Cache_Ctx is
1083: l_msg varchar2(500);
1084: begin

Line 1090: g_session_ctx := fnd_global.get_session_context;

1086: if (g_cached) then
1087: return;
1088: end if;
1089:
1090: g_session_ctx := fnd_global.get_session_context;
1091:
1092: -- No context initialized yet, initialize a default context typically
1093: -- used in workflow background services
1094: if (g_session_ctx is null or g_session_ctx <= 0) then

Line 1095: fnd_global.apps_initialize(user_id => g_user_id,

1091:
1092: -- No context initialized yet, initialize a default context typically
1093: -- used in workflow background services
1094: if (g_session_ctx is null or g_session_ctx <= 0) then
1095: fnd_global.apps_initialize(user_id => g_user_id,
1096: resp_id => g_resp_id,
1097: resp_appl_id => g_resp_appl_id,
1098: security_group_id => g_security_group_id,
1099: server_id => g_server_id);

Line 1100: g_session_ctx := fnd_global.get_session_context;

1096: resp_id => g_resp_id,
1097: resp_appl_id => g_resp_appl_id,
1098: security_group_id => g_security_group_id,
1099: server_id => g_server_id);
1100: g_session_ctx := fnd_global.get_session_context;
1101: end if;
1102:
1103: -- cache
1104: g_user_id := fnd_global.user_id;

Line 1104: g_user_id := fnd_global.user_id;

1100: g_session_ctx := fnd_global.get_session_context;
1101: end if;
1102:
1103: -- cache
1104: g_user_id := fnd_global.user_id;
1105: g_resp_id := fnd_global.resp_id;
1106: g_resp_appl_id := fnd_global.resp_appl_id;
1107: g_security_group_id := fnd_global.security_group_id;
1108: g_server_id := fnd_global.server_id;

Line 1105: g_resp_id := fnd_global.resp_id;

1101: end if;
1102:
1103: -- cache
1104: g_user_id := fnd_global.user_id;
1105: g_resp_id := fnd_global.resp_id;
1106: g_resp_appl_id := fnd_global.resp_appl_id;
1107: g_security_group_id := fnd_global.security_group_id;
1108: g_server_id := fnd_global.server_id;
1109:

Line 1106: g_resp_appl_id := fnd_global.resp_appl_id;

1102:
1103: -- cache
1104: g_user_id := fnd_global.user_id;
1105: g_resp_id := fnd_global.resp_id;
1106: g_resp_appl_id := fnd_global.resp_appl_id;
1107: g_security_group_id := fnd_global.security_group_id;
1108: g_server_id := fnd_global.server_id;
1109:
1110: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

Line 1107: g_security_group_id := fnd_global.security_group_id;

1103: -- cache
1104: g_user_id := fnd_global.user_id;
1105: g_resp_id := fnd_global.resp_id;
1106: g_resp_appl_id := fnd_global.resp_appl_id;
1107: g_security_group_id := fnd_global.security_group_id;
1108: g_server_id := fnd_global.server_id;
1109:
1110: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1111: l_msg := 'Cached - '||g_user_id||':'||g_resp_id||':'||g_resp_appl_id||':'

Line 1108: g_server_id := fnd_global.server_id;

1104: g_user_id := fnd_global.user_id;
1105: g_resp_id := fnd_global.resp_id;
1106: g_resp_appl_id := fnd_global.resp_appl_id;
1107: g_security_group_id := fnd_global.security_group_id;
1108: g_server_id := fnd_global.server_id;
1109:
1110: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1111: l_msg := 'Cached - '||g_user_id||':'||g_resp_id||':'||g_resp_appl_id||':'
1112: ||g_security_group_id||':'||g_server_id||'->'||g_session_ctx;

Line 1147: if (not fnd_global.compare_session_context(g_session_ctx)) then

1143: end if;
1144:
1145: -- if the current context is different from the cached context
1146: -- it would have been modified after it was cached
1147: if (not fnd_global.compare_session_context(g_session_ctx)) then
1148:
1149: -- fnd_global.compare_session_context: returns true if the session_context is
1150: -- the same as context_id, otherwise returns false.
1151: -- fnd_global.get_session_context is changed whenever fnd_global.apps_initialize

Line 1149: -- fnd_global.compare_session_context: returns true if the session_context is

1145: -- if the current context is different from the cached context
1146: -- it would have been modified after it was cached
1147: if (not fnd_global.compare_session_context(g_session_ctx)) then
1148:
1149: -- fnd_global.compare_session_context: returns true if the session_context is
1150: -- the same as context_id, otherwise returns false.
1151: -- fnd_global.get_session_context is changed whenever fnd_global.apps_initialize
1152: -- is being called.
1153: fnd_global.apps_initialize(user_id => g_user_id,

Line 1151: -- fnd_global.get_session_context is changed whenever fnd_global.apps_initialize

1147: if (not fnd_global.compare_session_context(g_session_ctx)) then
1148:
1149: -- fnd_global.compare_session_context: returns true if the session_context is
1150: -- the same as context_id, otherwise returns false.
1151: -- fnd_global.get_session_context is changed whenever fnd_global.apps_initialize
1152: -- is being called.
1153: fnd_global.apps_initialize(user_id => g_user_id,
1154: resp_id => g_resp_id,
1155: resp_appl_id => g_resp_appl_id,

Line 1153: fnd_global.apps_initialize(user_id => g_user_id,

1149: -- fnd_global.compare_session_context: returns true if the session_context is
1150: -- the same as context_id, otherwise returns false.
1151: -- fnd_global.get_session_context is changed whenever fnd_global.apps_initialize
1152: -- is being called.
1153: fnd_global.apps_initialize(user_id => g_user_id,
1154: resp_id => g_resp_id,
1155: resp_appl_id => g_resp_appl_id,
1156: security_group_id => g_security_group_id,
1157: server_id => g_server_id);

Line 1159: g_session_ctx := fnd_global.get_session_context;

1155: resp_appl_id => g_resp_appl_id,
1156: security_group_id => g_security_group_id,
1157: server_id => g_server_id);
1158:
1159: g_session_ctx := fnd_global.get_session_context;
1160:
1161: -- bug 9747572 :
1162: -- If next activity is being deferred to WF background in same db-session
1163: -- for same itemtype and itemkey, let selector function be executed in next iteration .