APPS.MO_GLOBAL dependencies on FND_GLOBAL

Line 123: WHERE USER_ID = FND_GLOBAL.USER_ID

119:
120: CURSOR c5 IS
121: SELECT organization_id
122: FROM fnd_mo_sp_preferences
123: WHERE USER_ID = FND_GLOBAL.USER_ID
124: AND RESP_ID = FND_GLOBAL.RESP_ID;
125:
126: BEGIN
127:

Line 124: AND RESP_ID = FND_GLOBAL.RESP_ID;

120: CURSOR c5 IS
121: SELECT organization_id
122: FROM fnd_mo_sp_preferences
123: WHERE USER_ID = FND_GLOBAL.USER_ID
124: AND RESP_ID = FND_GLOBAL.RESP_ID;
125:
126: BEGIN
127:
128: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 300: where user_id = FND_GLOBAL.USER_ID

296: -- IF t_delete_org_id.COUNT <> t_pref_org_id.COUNT THEN
297: IF (t_delete_org_id.COUNT > 0) THEN
298: FORALL m IN t_delete_org_id.FIRST .. t_delete_org_id.LAST
299: delete from FND_MO_SP_PREFERENCES
300: where user_id = FND_GLOBAL.USER_ID
301: and resp_id = FND_GLOBAL.RESP_ID
302: and organization_id = t_delete_org_id(m);
303: commit;
304: END IF;

Line 301: and resp_id = FND_GLOBAL.RESP_ID

297: IF (t_delete_org_id.COUNT > 0) THEN
298: FORALL m IN t_delete_org_id.FIRST .. t_delete_org_id.LAST
299: delete from FND_MO_SP_PREFERENCES
300: where user_id = FND_GLOBAL.USER_ID
301: and resp_id = FND_GLOBAL.RESP_ID
302: and organization_id = t_delete_org_id(m);
303: commit;
304: END IF;
305: END IF;

Line 1044: fnd_global.initialize('ORG_ID',g_current_org_id);

1040: --
1041: dbms_session.set_context('multi_org2', 'current_org_id', p_org_id);
1042: g_current_org_id := p_org_id;
1043: -- Bug 7227733 Passing current org id to FND
1044: fnd_global.initialize('ORG_ID',g_current_org_id);
1045:
1046: END IF;
1047:
1048: ELSIF (p_access_mode = 'M') THEN

Line 1064: fnd_global.initialize('ORG_ID',g_current_org_id);

1060: --
1061: dbms_session.set_context('multi_org2', 'current_org_id', '');
1062: g_current_org_id := NULL;
1063: -- Bug 7227733 Passing current org id to FND
1064: fnd_global.initialize('ORG_ID',g_current_org_id);
1065: END IF;
1066:
1067: ELSIF (p_access_mode = 'A') and g_init_access_mode = 'A' THEN
1068: IF (g_access_mode is NULL OR g_access_mode <> 'A') THEN

Line 1083: fnd_global.initialize('ORG_ID',g_current_org_id);

1079: --
1080: dbms_session.set_context('multi_org2', 'current_org_id', '');
1081: g_current_org_id := NULL;
1082: -- Bug 7227733 Passing current org id to FND
1083: fnd_global.initialize('ORG_ID',g_current_org_id);
1084: END IF;
1085:
1086: ELSIF (p_access_mode in ('X','B')) THEN
1087: if sys_context('multi_org2','current_org_id') is not null then

Line 1111: fnd_global.initialize('ORG_ID',g_current_org_id);

1107: --
1108: dbms_session.set_context('multi_org2', 'current_org_id', '');
1109: g_current_org_id := NULL;
1110: -- Bug 7227733 Passing current org id to FND
1111: fnd_global.initialize('ORG_ID',g_current_org_id);
1112: END IF;
1113:
1114: END IF;
1115: