DBA Data[Home] [Help]

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: l_user_id number;
127: l_resp_id number;

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: l_user_id number;
127: l_resp_id number;
128: l_del_org_id hr_operating_units.organization_id%TYPE;

Line 306: l_user_id := FND_GLOBAL.USER_ID;

302: if ( fnd_adg_support.is_standby )
303: then
304: $if fnd_adg_compile_directive.enable_rpc
305: $then
306: l_user_id := FND_GLOBAL.USER_ID;
307: l_resp_id := FND_GLOBAL.RESP_ID;
308:
309: FOR m IN t_delete_org_id.FIRST .. t_delete_org_id.LAST LOOP
310:

Line 307: l_resp_id := FND_GLOBAL.RESP_ID;

303: then
304: $if fnd_adg_compile_directive.enable_rpc
305: $then
306: l_user_id := FND_GLOBAL.USER_ID;
307: l_resp_id := FND_GLOBAL.RESP_ID;
308:
309: FOR m IN t_delete_org_id.FIRST .. t_delete_org_id.LAST LOOP
310:
311: l_del_org_id := t_delete_org_id(m);

Line 326: where user_id = FND_GLOBAL.USER_ID

322: else
323:
324: FORALL m IN t_delete_org_id.FIRST .. t_delete_org_id.LAST
325: delete from FND_MO_SP_PREFERENCES
326: where user_id = FND_GLOBAL.USER_ID
327: and resp_id = FND_GLOBAL.RESP_ID
328: and organization_id = t_delete_org_id(m);
329:
330: end if;

Line 327: and resp_id = FND_GLOBAL.RESP_ID

323:
324: FORALL m IN t_delete_org_id.FIRST .. t_delete_org_id.LAST
325: delete from FND_MO_SP_PREFERENCES
326: where user_id = FND_GLOBAL.USER_ID
327: and resp_id = FND_GLOBAL.RESP_ID
328: and organization_id = t_delete_org_id(m);
329:
330: end if;
331:

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

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:
1181: END IF;
1182:
1183: ELSIF (p_access_mode = 'M') THEN

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

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;
1201:
1202: ELSIF (p_access_mode = 'A') and g_init_access_mode = 'A' THEN
1203: IF (g_access_mode is NULL OR g_access_mode <> 'A') THEN

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

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;
1220:
1221: ELSIF (p_access_mode in ('X','B')) THEN
1222: if sys_context('multi_org2','current_org_id') is not null then

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

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;
1248:
1249: END IF;
1250: