APPS.PJM_INSTALL dependencies on AD_DDL

Line 359: ad_ddl.do_ddl( applsys_schema

355: close s;
356: --
357: -- Drop the view just in case
358: --
359: ad_ddl.do_ddl( applsys_schema
360: , 'PJM'
361: , ad_ddl.drop_view
362: , 'DROP VIEW ' || X_synonym_name
363: , X_synonym_name );

Line 361: , ad_ddl.drop_view

357: -- Drop the view just in case
358: --
359: ad_ddl.do_ddl( applsys_schema
360: , 'PJM'
361: , ad_ddl.drop_view
362: , 'DROP VIEW ' || X_synonym_name
363: , X_synonym_name );
364:
365: create_flag := 'Y';

Line 373: ad_ddl.do_ddl( applsys_schema

369: --
370: -- Synonym exists but points to a different object. We need to drop
371: -- the existing synonym first before recreating the new one
372: --
373: ad_ddl.do_ddl( applsys_schema
374: , 'PJM'
375: , ad_ddl.drop_synonym
376: , 'DROP SYNONYM ' || X_synonym_name
377: , X_synonym_name );

Line 375: , ad_ddl.drop_synonym

371: -- the existing synonym first before recreating the new one
372: --
373: ad_ddl.do_ddl( applsys_schema
374: , 'PJM'
375: , ad_ddl.drop_synonym
376: , 'DROP SYNONYM ' || X_synonym_name
377: , X_synonym_name );
378: create_flag := 'Y';
379: else

Line 388: ad_ddl.do_ddl( applsys_schema

384: end if;
385: end if;
386: if ( create_flag = 'Y' ) then
387: sqlstmt := 'CREATE SYNONYM ' || X_synonym_name || ' FOR ' || X_table_name;
388: ad_ddl.do_ddl( applsys_schema
389: , 'PJM'
390: , ad_ddl.create_synonym
391: , sqlstmt
392: , X_synonym_name );

Line 390: , ad_ddl.create_synonym

386: if ( create_flag = 'Y' ) then
387: sqlstmt := 'CREATE SYNONYM ' || X_synonym_name || ' FOR ' || X_table_name;
388: ad_ddl.do_ddl( applsys_schema
389: , 'PJM'
390: , ad_ddl.create_synonym
391: , sqlstmt
392: , X_synonym_name );
393: end if;
394: end create_synonym;