APPS.MO_GLOBAL dependencies on DBMS_SESSION

Line 780: dbms_session.set_context('multi_org2', 'current_org_id', '');

776: --
777: PROCEDURE clear_current_org_context(p_icx_session_id IN NUMBER)
778: IS
779: BEGIN
780: dbms_session.set_context('multi_org2', 'current_org_id', '');
781: fnd_session_management.clearSessionAttributeValue(p_name => 'JTTCURRENTORG',
782: p_session_id => p_icx_session_id);
783: g_current_org_id := NULL;
784: END;

Line 1167: dbms_session.set_context('multi_org', 'access_mode', p_access_mode);

1163: IF (g_access_mode is NULL OR g_access_mode <> 'S') THEN
1164: --
1165: -- If single operating unit access, then mode should be set to 'S'
1166: --
1167: dbms_session.set_context('multi_org', 'access_mode', p_access_mode);
1168: g_access_mode := p_access_mode;
1169: END IF;
1170: IF (g_current_org_id IS NULL OR g_current_org_id <> p_org_id
1171: OR sys_context('multi_org2','current_org_id') <> p_org_id -- Bug4916086

Line 1176: dbms_session.set_context('multi_org2', 'current_org_id', p_org_id);

1172: OR sys_context('multi_org2','current_org_id') is null) THEN
1173: --
1174: -- Set the current org context
1175: --
1176: dbms_session.set_context('multi_org2', 'current_org_id', p_org_id);
1177: g_current_org_id := p_org_id;
1178: -- Bug 7227733 Passing current org id to FND
1179: fnd_global.initialize('ORG_ID',g_current_org_id);
1180:

Line 1188: dbms_session.set_context('multi_org', 'access_mode', p_access_mode);

1184: IF (g_access_mode is NULL OR g_access_mode <> 'M') THEN
1185: --
1186: -- If multiple operating units access, then mode should be set to 'M'
1187: --
1188: dbms_session.set_context('multi_org', 'access_mode', p_access_mode);
1189: g_access_mode := p_access_mode;
1190: END IF;
1191: IF (g_current_org_id IS NOT NULL ) THEN
1192: --

Line 1196: dbms_session.set_context('multi_org2', 'current_org_id', '');

1192: --
1193: -- Unset the current org context, since it is not required for multiple
1194: -- access
1195: --
1196: dbms_session.set_context('multi_org2', 'current_org_id', '');
1197: g_current_org_id := NULL;
1198: -- Bug 7227733 Passing current org id to FND
1199: fnd_global.initialize('ORG_ID',g_current_org_id);
1200: END IF;

Line 1207: dbms_session.set_context('multi_org', 'access_mode', p_access_mode);

1203: IF (g_access_mode is NULL OR g_access_mode <> 'A') THEN
1204: --
1205: -- If all operating units access, then mode should be set to 'A'
1206: --
1207: dbms_session.set_context('multi_org', 'access_mode', p_access_mode);
1208: g_access_mode := p_access_mode;
1209: END IF;
1210: IF (g_current_org_id IS NOT NULL ) THEN
1211: --

Line 1215: dbms_session.set_context('multi_org2', 'current_org_id', '');

1211: --
1212: -- Unset the current org context, since it is not required for all
1213: -- access
1214: --
1215: dbms_session.set_context('multi_org2', 'current_org_id', '');
1216: g_current_org_id := NULL;
1217: -- Bug 7227733 Passing current org id to FND
1218: fnd_global.initialize('ORG_ID',g_current_org_id);
1219: END IF;

Line 1223: dbms_session.set_context('multi_org2', 'current_org_id', '');

1219: END IF;
1220:
1221: ELSIF (p_access_mode in ('X','B')) THEN
1222: if sys_context('multi_org2','current_org_id') is not null then
1223: dbms_session.set_context('multi_org2', 'current_org_id', '');
1224: end if;
1225:
1226: dbms_session.set_context('multi_org', 'access_mode', p_access_mode);
1227: g_current_org_id := NULL;

Line 1226: dbms_session.set_context('multi_org', 'access_mode', p_access_mode);

1222: if sys_context('multi_org2','current_org_id') is not null then
1223: dbms_session.set_context('multi_org2', 'current_org_id', '');
1224: end if;
1225:
1226: dbms_session.set_context('multi_org', 'access_mode', p_access_mode);
1227: g_current_org_id := NULL;
1228: g_access_mode := p_access_mode;
1229:
1230: ELSIF (p_access_mode is NULL) THEN

Line 1235: dbms_session.set_context('multi_org', 'access_mode', p_access_mode);

1231: IF (g_access_mode IS NOT NULL) THEN
1232: --
1233: -- If access_mode is not passed, then unset it
1234: --
1235: dbms_session.set_context('multi_org', 'access_mode', p_access_mode);
1236: g_access_mode := p_access_mode;
1237: END IF;
1238: IF (g_current_org_id IS NOT NULL ) THEN
1239: --

Line 1243: dbms_session.set_context('multi_org2', 'current_org_id', '');

1239: --
1240: -- Unset the current org context, since it is not required when mode
1241: -- is not set
1242: --
1243: dbms_session.set_context('multi_org2', 'current_org_id', '');
1244: g_current_org_id := NULL;
1245: -- Bug 7227733 Passing current org id to FND
1246: fnd_global.initialize('ORG_ID',g_current_org_id);
1247: END IF;