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.MSC_ATP_PEG dependencies on AD_DDL

Line 3191: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

3187: msc_util.msc_log('before creating table : ' || l_temp_table);
3188: END IF;
3189:
3190: BEGIN
3191: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
3192: APPLICATION_SHORT_NAME => 'MSC',
3193: STATEMENT_TYPE => ad_ddl.create_table,
3194: STATEMENT => l_insert_stmt,
3195: OBJECT_NAME => l_temp_table);

Line 3193: STATEMENT_TYPE => ad_ddl.create_table,

3189:
3190: BEGIN
3191: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
3192: APPLICATION_SHORT_NAME => 'MSC',
3193: STATEMENT_TYPE => ad_ddl.create_table,
3194: STATEMENT => l_insert_stmt,
3195: OBJECT_NAME => l_temp_table);
3196: IF PG_DEBUG in ('Y', 'C') THEN
3197: msc_util.msc_log('after creating table : ' || l_temp_table);

Line 3206: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

3202: IF PG_DEBUG in ('Y', 'C') THEN
3203: msc_util.msc_log(sqlcode || ': ' || sqlerrm);
3204: msc_util.msc_log('Exception of create table : ' || l_temp_table);
3205: END IF;
3206: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
3207: APPLICATION_SHORT_NAME => 'MSC',
3208: STATEMENT_TYPE => ad_ddl.drop_table,
3209: STATEMENT => 'DROP TABLE ' || l_temp_table,
3210: OBJECT_NAME => l_temp_table);

Line 3208: STATEMENT_TYPE => ad_ddl.drop_table,

3204: msc_util.msc_log('Exception of create table : ' || l_temp_table);
3205: END IF;
3206: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
3207: APPLICATION_SHORT_NAME => 'MSC',
3208: STATEMENT_TYPE => ad_ddl.drop_table,
3209: STATEMENT => 'DROP TABLE ' || l_temp_table,
3210: OBJECT_NAME => l_temp_table);
3211:
3212: IF PG_DEBUG in ('Y', 'C') THEN

Line 3217: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

3213: msc_util.msc_log('After Drop table : ' ||l_temp_table);
3214: msc_util.msc_log('Before exception create table : ' ||l_temp_table);
3215: END IF;
3216:
3217: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
3218: APPLICATION_SHORT_NAME => 'MSC',
3219: STATEMENT_TYPE => ad_ddl.create_table,
3220: STATEMENT => l_insert_stmt,
3221: OBJECT_NAME => l_temp_table);

Line 3219: STATEMENT_TYPE => ad_ddl.create_table,

3215: END IF;
3216:
3217: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
3218: APPLICATION_SHORT_NAME => 'MSC',
3219: STATEMENT_TYPE => ad_ddl.create_table,
3220: STATEMENT => l_insert_stmt,
3221: OBJECT_NAME => l_temp_table);
3222: IF PG_DEBUG in ('Y', 'C') THEN
3223: msc_util.msc_log('After exception create table : ' ||l_temp_table);

Line 4421: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,

4417: IF PG_DEBUG in ('Y', 'C') THEN
4418: msc_util.msc_log('Before creating index ' || l_temp_table ||
4419: '_N1 for table ');
4420: END IF;
4421: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
4422: application_short_name => l_msc_schema,
4423: statement_type => AD_DDL.CREATE_INDEX,
4424: statement => l_sql_stmt,
4425: object_name => l_temp_table );

Line 4423: statement_type => AD_DDL.CREATE_INDEX,

4419: '_N1 for table ');
4420: END IF;
4421: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
4422: application_short_name => l_msc_schema,
4423: statement_type => AD_DDL.CREATE_INDEX,
4424: statement => l_sql_stmt,
4425: object_name => l_temp_table );
4426: END ;
4427: l_sql_stmt := 'CREATE INDEX ' || l_temp_table || '_N2 ON ' || l_temp_table ||

Line 4444: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,

4440: IF PG_DEBUG in ('Y', 'C') THEN
4441: msc_util.msc_log('Before creating index ' || l_temp_table ||
4442: '_N2 for table ');
4443: END IF;
4444: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
4445: application_short_name => l_msc_schema,
4446: statement_type => AD_DDL.CREATE_INDEX,
4447: statement => l_sql_stmt,
4448: object_name => l_temp_table );

Line 4446: statement_type => AD_DDL.CREATE_INDEX,

4442: '_N2 for table ');
4443: END IF;
4444: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
4445: application_short_name => l_msc_schema,
4446: statement_type => AD_DDL.CREATE_INDEX,
4447: statement => l_sql_stmt,
4448: object_name => l_temp_table );
4449: END ;
4450: l_sql_stmt := 'CREATE INDEX ' || l_temp_table || '_N3 ON ' || l_temp_table ||

Line 4468: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,

4464: IF PG_DEBUG in ('Y', 'C') THEN
4465: msc_util.msc_log('Before creating index ' || l_temp_table ||
4466: '_N3 for table ');
4467: END IF;
4468: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
4469: application_short_name => l_msc_schema,
4470: statement_type => AD_DDL.CREATE_INDEX,
4471: statement => l_sql_stmt,
4472: object_name => l_temp_table );

Line 4470: statement_type => AD_DDL.CREATE_INDEX,

4466: '_N3 for table ');
4467: END IF;
4468: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
4469: application_short_name => l_msc_schema,
4470: statement_type => AD_DDL.CREATE_INDEX,
4471: statement => l_sql_stmt,
4472: object_name => l_temp_table );
4473: END ;
4474: -- Bug 3629191

Line 4489: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,

4485: IF PG_DEBUG in ('Y', 'C') THEN
4486: msc_util.msc_log('Before creating index ' || l_temp_table ||
4487: '_N4 for table ');
4488: END IF;
4489: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
4490: application_short_name => l_msc_schema,
4491: statement_type => AD_DDL.CREATE_INDEX,
4492: statement => l_sql_stmt,
4493: object_name => l_temp_table );

Line 4491: statement_type => AD_DDL.CREATE_INDEX,

4487: '_N4 for table ');
4488: END IF;
4489: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
4490: application_short_name => l_msc_schema,
4491: statement_type => AD_DDL.CREATE_INDEX,
4492: statement => l_sql_stmt,
4493: object_name => l_temp_table );
4494: END ;
4495: IF PG_DEBUG in ('Y', 'C') THEN

Line 4515: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

4511: BEGIN
4512: IF PG_DEBUG in ('Y', 'C') THEN
4513: msc_util.msc_log('Before alter table msc_atp_pegging');
4514: END IF;
4515: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
4516: APPLICATION_SHORT_NAME => 'MSC',
4517: STATEMENT_TYPE => ad_ddl.alter_table,
4518: STATEMENT => l_sql_stmt,
4519: OBJECT_NAME => 'MSC_ATP_PEGGING');

Line 4517: STATEMENT_TYPE => ad_ddl.alter_table,

4513: msc_util.msc_log('Before alter table msc_atp_pegging');
4514: END IF;
4515: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
4516: APPLICATION_SHORT_NAME => 'MSC',
4517: STATEMENT_TYPE => ad_ddl.alter_table,
4518: STATEMENT => l_sql_stmt,
4519: OBJECT_NAME => 'MSC_ATP_PEGGING');
4520: END;
4521: