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_PF dependencies on AD_DDL

Line 9397: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

9393:
9394: msc_util.msc_log('before creating table : ' || l_alloc_temp_table);
9395:
9396: BEGIN
9397: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9398: APPLICATION_SHORT_NAME => 'MSC',
9399: STATEMENT_TYPE => ad_ddl.create_table,
9400: STATEMENT => l_insert_stmt,
9401: OBJECT_NAME => l_alloc_temp_table);

Line 9399: STATEMENT_TYPE => ad_ddl.create_table,

9395:
9396: BEGIN
9397: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9398: APPLICATION_SHORT_NAME => 'MSC',
9399: STATEMENT_TYPE => ad_ddl.create_table,
9400: STATEMENT => l_insert_stmt,
9401: OBJECT_NAME => l_alloc_temp_table);
9402: msc_util.msc_log('after creating table : ' || l_alloc_temp_table);
9403:

Line 9409: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

9405: WHEN others THEN
9406: msc_util.msc_log(sqlcode || ': ' || sqlerrm);
9407: msc_util.msc_log('Exception of create table : ' || l_alloc_temp_table);
9408:
9409: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9410: APPLICATION_SHORT_NAME => 'MSC',
9411: STATEMENT_TYPE => ad_ddl.drop_table,
9412: STATEMENT => 'DROP TABLE ' || l_alloc_temp_table,
9413: OBJECT_NAME => l_alloc_temp_table);

Line 9411: STATEMENT_TYPE => ad_ddl.drop_table,

9407: msc_util.msc_log('Exception of create table : ' || l_alloc_temp_table);
9408:
9409: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9410: APPLICATION_SHORT_NAME => 'MSC',
9411: STATEMENT_TYPE => ad_ddl.drop_table,
9412: STATEMENT => 'DROP TABLE ' || l_alloc_temp_table,
9413: OBJECT_NAME => l_alloc_temp_table);
9414:
9415: msc_util.msc_log('After Drop table : ' ||l_alloc_temp_table);

Line 9418: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

9414:
9415: msc_util.msc_log('After Drop table : ' ||l_alloc_temp_table);
9416: msc_util.msc_log('Before exception create table : ' ||l_alloc_temp_table);
9417:
9418: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9419: APPLICATION_SHORT_NAME => 'MSC',
9420: STATEMENT_TYPE => ad_ddl.create_table,
9421: STATEMENT => l_insert_stmt,
9422: OBJECT_NAME => l_alloc_temp_table);

Line 9420: STATEMENT_TYPE => ad_ddl.create_table,

9416: msc_util.msc_log('Before exception create table : ' ||l_alloc_temp_table);
9417:
9418: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9419: APPLICATION_SHORT_NAME => 'MSC',
9420: STATEMENT_TYPE => ad_ddl.create_table,
9421: STATEMENT => l_insert_stmt,
9422: OBJECT_NAME => l_alloc_temp_table);
9423:
9424: msc_util.msc_log('After exception create table : ' ||l_alloc_temp_table);

Line 9498: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

9494: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
9495:
9496: msc_util.msc_log('Before index : ' || l_alloc_temp_table || '.' || l_alloc_temp_table || '_N1');
9497:
9498: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9499: APPLICATION_SHORT_NAME => 'MSC',
9500: STATEMENT_TYPE => ad_ddl.create_index,
9501: STATEMENT => l_sql_stmt_1,
9502: OBJECT_NAME => l_alloc_temp_table);

Line 9500: STATEMENT_TYPE => ad_ddl.create_index,

9496: msc_util.msc_log('Before index : ' || l_alloc_temp_table || '.' || l_alloc_temp_table || '_N1');
9497:
9498: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9499: APPLICATION_SHORT_NAME => 'MSC',
9500: STATEMENT_TYPE => ad_ddl.create_index,
9501: STATEMENT => l_sql_stmt_1,
9502: OBJECT_NAME => l_alloc_temp_table);
9503:
9504: msc_util.msc_log('After index : ' || l_alloc_temp_table || '.' || l_alloc_temp_table || '_N1');

Line 9692: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

9688: */
9689:
9690: msc_util.msc_log('before creating table : ' || l_temp_table);
9691: BEGIN
9692: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9693: APPLICATION_SHORT_NAME => 'MSC',
9694: STATEMENT_TYPE => ad_ddl.create_table,
9695: STATEMENT => l_insert_stmt,
9696: OBJECT_NAME => l_temp_table);

Line 9694: STATEMENT_TYPE => ad_ddl.create_table,

9690: msc_util.msc_log('before creating table : ' || l_temp_table);
9691: BEGIN
9692: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9693: APPLICATION_SHORT_NAME => 'MSC',
9694: STATEMENT_TYPE => ad_ddl.create_table,
9695: STATEMENT => l_insert_stmt,
9696: OBJECT_NAME => l_temp_table);
9697: msc_util.msc_log('after creating table : ' || l_temp_table);
9698:

Line 9704: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

9700: WHEN others THEN
9701: msc_util.msc_log(sqlcode || ': ' || sqlerrm);
9702: msc_util.msc_log('Exception of create table : ' || l_temp_table);
9703:
9704: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9705: APPLICATION_SHORT_NAME => 'MSC',
9706: STATEMENT_TYPE => ad_ddl.drop_table,
9707: STATEMENT => 'DROP TABLE ' || l_temp_table,
9708: OBJECT_NAME => l_temp_table);

Line 9706: STATEMENT_TYPE => ad_ddl.drop_table,

9702: msc_util.msc_log('Exception of create table : ' || l_temp_table);
9703:
9704: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9705: APPLICATION_SHORT_NAME => 'MSC',
9706: STATEMENT_TYPE => ad_ddl.drop_table,
9707: STATEMENT => 'DROP TABLE ' || l_temp_table,
9708: OBJECT_NAME => l_temp_table);
9709:
9710: msc_util.msc_log('After Drop table : ' ||l_temp_table);

Line 9713: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

9709:
9710: msc_util.msc_log('After Drop table : ' ||l_temp_table);
9711: msc_util.msc_log('Before exception create table : ' ||l_temp_table);
9712:
9713: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9714: APPLICATION_SHORT_NAME => 'MSC',
9715: STATEMENT_TYPE => ad_ddl.create_table,
9716: STATEMENT => l_insert_stmt,
9717: OBJECT_NAME => l_temp_table);

Line 9715: STATEMENT_TYPE => ad_ddl.create_table,

9711: msc_util.msc_log('Before exception create table : ' ||l_temp_table);
9712:
9713: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9714: APPLICATION_SHORT_NAME => 'MSC',
9715: STATEMENT_TYPE => ad_ddl.create_table,
9716: STATEMENT => l_insert_stmt,
9717: OBJECT_NAME => l_temp_table);
9718: msc_util.msc_log('After exception create table : ' ||l_temp_table);
9719: END;

Line 9774: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

9770: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
9771:
9772: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N1');
9773:
9774: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9775: APPLICATION_SHORT_NAME => 'MSC',
9776: STATEMENT_TYPE => ad_ddl.create_index,
9777: STATEMENT => l_sql_stmt_1,
9778: OBJECT_NAME => l_temp_table);

Line 9776: STATEMENT_TYPE => ad_ddl.create_index,

9772: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N1');
9773:
9774: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9775: APPLICATION_SHORT_NAME => 'MSC',
9776: STATEMENT_TYPE => ad_ddl.create_index,
9777: STATEMENT => l_sql_stmt_1,
9778: OBJECT_NAME => l_temp_table);
9779:
9780: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N1');

Line 9791: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

9787: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
9788:
9789: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N2');
9790:
9791: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9792: APPLICATION_SHORT_NAME => 'MSC',
9793: STATEMENT_TYPE => ad_ddl.create_index,
9794: STATEMENT => l_sql_stmt_1,
9795: OBJECT_NAME => l_temp_table);

Line 9793: STATEMENT_TYPE => ad_ddl.create_index,

9789: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N2');
9790:
9791: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9792: APPLICATION_SHORT_NAME => 'MSC',
9793: STATEMENT_TYPE => ad_ddl.create_index,
9794: STATEMENT => l_sql_stmt_1,
9795: OBJECT_NAME => l_temp_table);
9796:
9797: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N2');

Line 9808: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

9804: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
9805:
9806: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N3');
9807:
9808: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9809: APPLICATION_SHORT_NAME => 'MSC',
9810: STATEMENT_TYPE => ad_ddl.create_index,
9811: STATEMENT => l_sql_stmt_1,
9812: OBJECT_NAME => l_temp_table);

Line 9810: STATEMENT_TYPE => ad_ddl.create_index,

9806: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N3');
9807:
9808: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9809: APPLICATION_SHORT_NAME => 'MSC',
9810: STATEMENT_TYPE => ad_ddl.create_index,
9811: STATEMENT => l_sql_stmt_1,
9812: OBJECT_NAME => l_temp_table);
9813:
9814: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N3');

Line 9877: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

9873: */
9874:
9875: msc_util.msc_log('before creating table : ' || l_temp_table);
9876: BEGIN
9877: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9878: APPLICATION_SHORT_NAME => 'MSC',
9879: STATEMENT_TYPE => ad_ddl.create_table,
9880: STATEMENT => l_insert_stmt,
9881: OBJECT_NAME => l_temp_table);

Line 9879: STATEMENT_TYPE => ad_ddl.create_table,

9875: msc_util.msc_log('before creating table : ' || l_temp_table);
9876: BEGIN
9877: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9878: APPLICATION_SHORT_NAME => 'MSC',
9879: STATEMENT_TYPE => ad_ddl.create_table,
9880: STATEMENT => l_insert_stmt,
9881: OBJECT_NAME => l_temp_table);
9882: msc_util.msc_log('after creating table : ' || l_temp_table);
9883:

Line 9889: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

9885: WHEN others THEN
9886: msc_util.msc_log(sqlcode || ': ' || sqlerrm);
9887: msc_util.msc_log('Exception of create table : ' || l_temp_table);
9888:
9889: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9890: APPLICATION_SHORT_NAME => 'MSC',
9891: STATEMENT_TYPE => ad_ddl.drop_table,
9892: STATEMENT => 'DROP TABLE ' || l_temp_table,
9893: OBJECT_NAME => l_temp_table);

Line 9891: STATEMENT_TYPE => ad_ddl.drop_table,

9887: msc_util.msc_log('Exception of create table : ' || l_temp_table);
9888:
9889: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9890: APPLICATION_SHORT_NAME => 'MSC',
9891: STATEMENT_TYPE => ad_ddl.drop_table,
9892: STATEMENT => 'DROP TABLE ' || l_temp_table,
9893: OBJECT_NAME => l_temp_table);
9894:
9895: msc_util.msc_log('After Drop table : ' ||l_temp_table);

Line 9898: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

9894:
9895: msc_util.msc_log('After Drop table : ' ||l_temp_table);
9896: msc_util.msc_log('Before exception create table : ' ||l_temp_table);
9897:
9898: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9899: APPLICATION_SHORT_NAME => 'MSC',
9900: STATEMENT_TYPE => ad_ddl.create_table,
9901: STATEMENT => l_insert_stmt,
9902: OBJECT_NAME => l_temp_table);

Line 9900: STATEMENT_TYPE => ad_ddl.create_table,

9896: msc_util.msc_log('Before exception create table : ' ||l_temp_table);
9897:
9898: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9899: APPLICATION_SHORT_NAME => 'MSC',
9900: STATEMENT_TYPE => ad_ddl.create_table,
9901: STATEMENT => l_insert_stmt,
9902: OBJECT_NAME => l_temp_table);
9903: msc_util.msc_log('After exception create table : ' ||l_temp_table);
9904: END;

Line 9958: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

9954: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
9955:
9956: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N1');
9957:
9958: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9959: APPLICATION_SHORT_NAME => 'MSC',
9960: STATEMENT_TYPE => ad_ddl.create_index,
9961: STATEMENT => l_sql_stmt_1,
9962: OBJECT_NAME => l_temp_table);

Line 9960: STATEMENT_TYPE => ad_ddl.create_index,

9956: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N1');
9957:
9958: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9959: APPLICATION_SHORT_NAME => 'MSC',
9960: STATEMENT_TYPE => ad_ddl.create_index,
9961: STATEMENT => l_sql_stmt_1,
9962: OBJECT_NAME => l_temp_table);
9963:
9964: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N1');

Line 9975: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

9971: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
9972:
9973: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N2');
9974:
9975: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9976: APPLICATION_SHORT_NAME => 'MSC',
9977: STATEMENT_TYPE => ad_ddl.create_index,
9978: STATEMENT => l_sql_stmt_1,
9979: OBJECT_NAME => l_temp_table);

Line 9977: STATEMENT_TYPE => ad_ddl.create_index,

9973: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N2');
9974:
9975: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9976: APPLICATION_SHORT_NAME => 'MSC',
9977: STATEMENT_TYPE => ad_ddl.create_index,
9978: STATEMENT => l_sql_stmt_1,
9979: OBJECT_NAME => l_temp_table);
9980:
9981: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N2');

Line 9992: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

9988: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
9989:
9990: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N3');
9991:
9992: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9993: APPLICATION_SHORT_NAME => 'MSC',
9994: STATEMENT_TYPE => ad_ddl.create_index,
9995: STATEMENT => l_sql_stmt_1,
9996: OBJECT_NAME => l_temp_table);

Line 9994: STATEMENT_TYPE => ad_ddl.create_index,

9990: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N3');
9991:
9992: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9993: APPLICATION_SHORT_NAME => 'MSC',
9994: STATEMENT_TYPE => ad_ddl.create_index,
9995: STATEMENT => l_sql_stmt_1,
9996: OBJECT_NAME => l_temp_table);
9997:
9998: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N3');

Line 10018: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

10014: ' including indexes without validation';
10015:
10016: BEGIN
10017: msc_util.msc_log('Before alter table msc_alloc_demands');
10018: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
10019: APPLICATION_SHORT_NAME => 'MSC',
10020: STATEMENT_TYPE => ad_ddl.alter_table,
10021: STATEMENT => l_sql_stmt,
10022: OBJECT_NAME => 'MSC_ALLOC_DEMANDS');

Line 10020: STATEMENT_TYPE => ad_ddl.alter_table,

10016: BEGIN
10017: msc_util.msc_log('Before alter table msc_alloc_demands');
10018: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
10019: APPLICATION_SHORT_NAME => 'MSC',
10020: STATEMENT_TYPE => ad_ddl.alter_table,
10021: STATEMENT => l_sql_stmt,
10022: OBJECT_NAME => 'MSC_ALLOC_DEMANDS');
10023: END;
10024:

Line 10036: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

10032: ' including indexes without validation';
10033:
10034: BEGIN
10035: msc_util.msc_log('Before alter table msc_alloc_supplies');
10036: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
10037: APPLICATION_SHORT_NAME => 'MSC',
10038: STATEMENT_TYPE => ad_ddl.alter_table,
10039: STATEMENT => l_sql_stmt,
10040: OBJECT_NAME => 'MSC_ALLOC_SUPPLIES');

Line 10038: STATEMENT_TYPE => ad_ddl.alter_table,

10034: BEGIN
10035: msc_util.msc_log('Before alter table msc_alloc_supplies');
10036: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
10037: APPLICATION_SHORT_NAME => 'MSC',
10038: STATEMENT_TYPE => ad_ddl.alter_table,
10039: STATEMENT => l_sql_stmt,
10040: OBJECT_NAME => 'MSC_ALLOC_SUPPLIES');
10041: END;
10042: