DBA Data[Home] [Help]

APPS.GL_ENT_FUNC_BAL_UPGRADE_PKG dependencies on AD_DDL

Line 866: AD_DDL.DO_DDL(x_applsys_schema, 'SQLGL', AD_DDL.ALTER_TABLE,

862: -- rename set_books_id column to ledger_id
863: sql_stmt := 'ALTER TABLE ' || l_table_name ||
864: ' RENAME COLUMN set_of_books_id TO ledger_id';
865:
866: AD_DDL.DO_DDL(x_applsys_schema, 'SQLGL', AD_DDL.ALTER_TABLE,
867: sql_stmt, l_table_name);
868:
869: -- add four BEQ columns
870: sql_stmt := 'ALTER TABLE ' || l_table_name || ' ADD ' ||

Line 876: AD_DDL.DO_DDL(x_applsys_schema, 'SQLGL', AD_DDL.ALTER_TABLE,

872: ' QUARTER_TO_DATE_CR_BEQ NUMBER,' ||
873: ' PROJECT_TO_DATE_DR_BEQ NUMBER,' ||
874: ' PROJECT_TO_DATE_CR_BEQ NUMBER)';
875:
876: AD_DDL.DO_DDL(x_applsys_schema, 'SQLGL', AD_DDL.ALTER_TABLE,
877: sql_stmt, l_table_name);
878: END IF;
879:
880: -- upgrade ADB balances table

Line 890: AD_DDL.DO_DDL(x_applsys_schema, 'SQLGL', AD_DDL.ALTER_TABLE,

886: -- rename set_books_id column to ledger_id
887: sql_stmt := 'ALTER TABLE ' || l_table_name ||
888: ' RENAME COLUMN set_of_books_id TO ledger_id';
889:
890: AD_DDL.DO_DDL(x_applsys_schema, 'SQLGL', AD_DDL.ALTER_TABLE,
891: sql_stmt, l_table_name);
892: END IF;
893:
894: -- dummy commit, to make sure the rollback segment will be set