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 3193: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

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

Line 3195: STATEMENT_TYPE => ad_ddl.create_table,

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

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

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

Line 3210: STATEMENT_TYPE => ad_ddl.drop_table,

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

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

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

Line 3221: STATEMENT_TYPE => ad_ddl.create_table,

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

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

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

Line 4425: statement_type => AD_DDL.CREATE_INDEX,

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

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

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

Line 4448: statement_type => AD_DDL.CREATE_INDEX,

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

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

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

Line 4472: statement_type => AD_DDL.CREATE_INDEX,

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

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

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

Line 4493: statement_type => AD_DDL.CREATE_INDEX,

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

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

4517: BEGIN
4518: IF PG_DEBUG in ('Y', 'C') THEN
4519: msc_util.msc_log('Before alter table msc_atp_pegging');
4520: END IF;
4521: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
4522: APPLICATION_SHORT_NAME => 'MSC',
4523: STATEMENT_TYPE => ad_ddl.alter_table,
4524: STATEMENT => l_sql_stmt,
4525: OBJECT_NAME => 'MSC_ATP_PEGGING');

Line 4523: STATEMENT_TYPE => ad_ddl.alter_table,

4519: msc_util.msc_log('Before alter table msc_atp_pegging');
4520: END IF;
4521: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
4522: APPLICATION_SHORT_NAME => 'MSC',
4523: STATEMENT_TYPE => ad_ddl.alter_table,
4524: STATEMENT => l_sql_stmt,
4525: OBJECT_NAME => 'MSC_ATP_PEGGING');
4526: END;
4527: