APPS.MO_GLOBAL dependencies on FND_ADG_SUPPORT

Line 302: if ( fnd_adg_support.is_standby )

298: end if;
299: END LOOP;
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;

Line 354: if ( fnd_adg_support.is_standby )

350: */
351:
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

Line 382: if ( fnd_adg_support.is_standby )

378: g_ou_id_tab(i):=t_common_org_id(i);
379: END LOOP;
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

Line 482: if ( fnd_adg_support.is_standby )

478: 'fnd.plsql.MO_GLOBAL.DELETE_ORGS.begin',
479: 'Before flushing MO_GLOB_ORG_ACCESS_TMP');
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;

Line 736: if ( fnd_adg_support.is_standby )

732: p_appl_short_name VARCHAR2)
733: IS
734: begin
735:
736: if ( fnd_adg_support.is_standby )
737: then
738: do_set_org_access(p_org_id_char,p_sp_id_char,p_appl_short_name);
739: else
740: do_auto_set_org_access(p_org_id_char,p_sp_id_char,p_appl_short_name);

Line 900: if ( fnd_adg_support.is_standby )

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
903: FROM mo_glob_org_access_tmp_remote oa
904: WHERE oa.organization_id = org_id)';

Line 1011: if ( fnd_adg_support.is_standby )

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:
1014: SELECT 'Y'
1015: INTO l_org_exists

Line 1067: if ( fnd_adg_support.is_standby )

1063: BEGIN
1064:
1065: $if fnd_adg_compile_directive.enable_rpc
1066: $then
1067: if ( fnd_adg_support.is_standby )
1068: then
1069:
1070: SELECT organization_name
1071: INTO l_ou_name

Line 1647: if ( fnd_adg_support.is_standby )

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
1650: FROM mo_glob_org_access_tmp_remote oa
1651: WHERE oa.organization_id = org_id))