eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJM_COMMITMENT_UTILS dependencies on AD_DDL

Line 590: AD_DDL.DO_DDL( applsys_schema

586: CLOSE s;
587: --
588: -- Drop the view just in case
589: --
590: AD_DDL.DO_DDL( applsys_schema
591: , 'PJM'
592: , AD_DDL.DROP_VIEW
593: , 'DROP VIEW ' || X_synonym_name
594: , X_synonym_name );

Line 592: , AD_DDL.DROP_VIEW

588: -- Drop the view just in case
589: --
590: AD_DDL.DO_DDL( applsys_schema
591: , 'PJM'
592: , AD_DDL.DROP_VIEW
593: , 'DROP VIEW ' || X_synonym_name
594: , X_synonym_name );
595:
596: create_flag := 'Y';

Line 604: AD_DDL.DO_DDL( applsys_schema

600: --
601: -- Synonym exists but points to a different object. We need to drop
602: -- the existing synonym first before recreating the new one
603: --
604: AD_DDL.DO_DDL( applsys_schema
605: , 'PJM'
606: , AD_DDL.DROP_SYNONYM
607: , 'DROP SYNONYM ' || X_synonym_name
608: , X_synonym_name );

Line 606: , AD_DDL.DROP_SYNONYM

602: -- the existing synonym first before recreating the new one
603: --
604: AD_DDL.DO_DDL( applsys_schema
605: , 'PJM'
606: , AD_DDL.DROP_SYNONYM
607: , 'DROP SYNONYM ' || X_synonym_name
608: , X_synonym_name );
609:
610: create_flag := 'Y';

Line 620: AD_DDL.DO_DDL( applsys_schema

616: END IF;
617: END IF;
618: IF ( create_flag = 'Y' ) THEN
619: sqlstmt := 'CREATE SYNONYM ' || X_synonym_name || ' FOR ' || X_table_name;
620: AD_DDL.DO_DDL( applsys_schema
621: , 'PJM'
622: , AD_DDL.CREATE_SYNONYM
623: , sqlstmt
624: , X_synonym_name );

Line 622: , AD_DDL.CREATE_SYNONYM

618: IF ( create_flag = 'Y' ) THEN
619: sqlstmt := 'CREATE SYNONYM ' || X_synonym_name || ' FOR ' || X_table_name;
620: AD_DDL.DO_DDL( applsys_schema
621: , 'PJM'
622: , AD_DDL.CREATE_SYNONYM
623: , sqlstmt
624: , X_synonym_name );
625: synonym_changed := TRUE;
626: END IF;

Line 673: AD_DDL.DO_DDL( applsys_schema

669: --
670: -- Recompile the PA commitment view just as a housekeeping step
671: -- Do not worry about the outcome
672: --
673: AD_DDL.DO_DDL( applsys_schema
674: , 'PA'
675: , AD_DDL.ALTER_VIEW
676: , 'ALTER VIEW PA_COMMITMENT_TXNS_V COMPILE'
677: , 'PA_COMMITMENT_TXNS_V' );

Line 675: , AD_DDL.ALTER_VIEW

671: -- Do not worry about the outcome
672: --
673: AD_DDL.DO_DDL( applsys_schema
674: , 'PA'
675: , AD_DDL.ALTER_VIEW
676: , 'ALTER VIEW PA_COMMITMENT_TXNS_V COMPILE'
677: , 'PA_COMMITMENT_TXNS_V' );
678: EXCEPTION
679: WHEN OTHERS THEN