DBA Data[Home] [Help]

APPS.OE_INSTALL dependencies on AD_APPS_PRIVATE

Line 95: system.ad_apps_private.exact_synonym_match(p_schema_name,p_synonym_name,

91:
92: BEGIN
93:
94: -- Check if the synonym already exists
95: system.ad_apps_private.exact_synonym_match(p_schema_name,p_synonym_name,
96: p_schema_name,p_object_name,p_exact_match,p_found_object_with_same_name,
97: p_type_for_object_found);
98: if NOT p_exact_match THEN
99: system.ad_apps_private.drop_object(p_schema_name,

Line 99: system.ad_apps_private.drop_object(p_schema_name,

95: system.ad_apps_private.exact_synonym_match(p_schema_name,p_synonym_name,
96: p_schema_name,p_object_name,p_exact_match,p_found_object_with_same_name,
97: p_type_for_object_found);
98: if NOT p_exact_match THEN
99: system.ad_apps_private.drop_object(p_schema_name,
100: p_synonym_name,'SYNONYM');
101:
102: -- Recreate the synonym
103:

Line 108: system.ad_apps_private.do_apps_ddl(p_schema_name,statement);

104: statement := 'create synonym '|| p_synonym_name ||' for '
105: || p_object_name;
106: --dbms_output.put_line('Statement :'|| statement);
107:
108: system.ad_apps_private.do_apps_ddl(p_schema_name,statement);
109: else
110: -- Synonym already exists. Do nothing.
111: -- dbms_output.put_line('Synonym already exists');
112: null;