DBA Data[Home] [Help]

APPS.MO_GLOBAL dependencies on FND_ADG_COMPILE_DIRECTIVE

Line 304: $if fnd_adg_compile_directive.enable_rpc

300: -- IF t_delete_org_id.COUNT <> t_pref_org_id.COUNT THEN
301: IF (t_delete_org_id.COUNT > 0) THEN
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:

Line 356: $if fnd_adg_compile_directive.enable_rpc

352: IF(sync_ind = 'Y') AND ( t_delete_org_id.COUNT < t_pref_org_id.COUNT) THEN
353: FOR i IN t_common_org_id.FIRST .. t_common_org_id.LAST LOOP
354: if ( fnd_adg_support.is_standby )
355: then
356: $if fnd_adg_compile_directive.enable_rpc
357: $then
358: INSERT
359: INTO mo_glob_org_access_tmp_remote
360: (organization_id

Line 384: $if fnd_adg_compile_directive.enable_rpc

380: ELSE
381: FOR i IN t_org_id.FIRST .. t_org_id.LAST LOOP
382: if ( fnd_adg_support.is_standby )
383: then
384: $if fnd_adg_compile_directive.enable_rpc
385: $then
386: INSERT
387: INTO mo_glob_org_access_tmp_remote
388: (organization_id

Line 484: $if fnd_adg_compile_directive.enable_rpc

480: END IF;
481:
482: if ( fnd_adg_support.is_standby )
483: then
484: $if fnd_adg_compile_directive.enable_rpc
485: $then
486: DELETE FROM mo_glob_org_access_tmp_remote;
487: $else
488: null;

Line 898: $if fnd_adg_compile_directive.enable_rpc

894:
895: ELSIF g_access_mode IS NOT NULL THEN
896: IF g_access_mode = 'M' THEN
897:
898: $if fnd_adg_compile_directive.enable_rpc
899: $then
900: if ( fnd_adg_support.is_standby )
901: then
902: RETURN 'EXISTS (SELECT /*+ no_unnest */ 1 --bug 13891445

Line 1009: $if fnd_adg_compile_directive.enable_rpc

1005:
1006: ELSIF (GET_OU_COUNT > 1) OR (g_access_mode = 'M') THEN -- added g_access_mode for Bug4575131
1007: -- if mo initialization is done
1008:
1009: $if fnd_adg_compile_directive.enable_rpc
1010: $then
1011: if ( fnd_adg_support.is_standby )
1012: then
1013:

Line 1065: $if fnd_adg_compile_directive.enable_rpc

1061: l_ou_name mo_glob_org_access_tmp.organization_name%TYPE;
1062:
1063: BEGIN
1064:
1065: $if fnd_adg_compile_directive.enable_rpc
1066: $then
1067: if ( fnd_adg_support.is_standby )
1068: then
1069:

Line 1645: $if fnd_adg_compile_directive.enable_rpc

1641: RETURN 'org_id = sys_context(''multi_org2'',''current_org_id'') OR (org_id = -3116)';
1642:
1643: ELSIF g_access_mode = 'M' THEN
1644:
1645: $if fnd_adg_compile_directive.enable_rpc
1646: $then
1647: if ( fnd_adg_support.is_standby )
1648: then
1649: RETURN '(EXISTS (SELECT 1