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

9419:
9420: msc_util.msc_log('before creating table : ' || l_alloc_temp_table);
9421:
9422: BEGIN
9423: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9424: APPLICATION_SHORT_NAME => 'MSC',
9425: STATEMENT_TYPE => ad_ddl.create_table,
9426: STATEMENT => l_insert_stmt,
9427: OBJECT_NAME => l_alloc_temp_table);

Line 9425: STATEMENT_TYPE => ad_ddl.create_table,

9421:
9422: BEGIN
9423: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9424: APPLICATION_SHORT_NAME => 'MSC',
9425: STATEMENT_TYPE => ad_ddl.create_table,
9426: STATEMENT => l_insert_stmt,
9427: OBJECT_NAME => l_alloc_temp_table);
9428: msc_util.msc_log('after creating table : ' || l_alloc_temp_table);
9429:

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

9431: WHEN others THEN
9432: msc_util.msc_log(sqlcode || ': ' || sqlerrm);
9433: msc_util.msc_log('Exception of create table : ' || l_alloc_temp_table);
9434:
9435: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9436: APPLICATION_SHORT_NAME => 'MSC',
9437: STATEMENT_TYPE => ad_ddl.drop_table,
9438: STATEMENT => 'DROP TABLE ' || l_alloc_temp_table,
9439: OBJECT_NAME => l_alloc_temp_table);

Line 9437: STATEMENT_TYPE => ad_ddl.drop_table,

9433: msc_util.msc_log('Exception of create table : ' || l_alloc_temp_table);
9434:
9435: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9436: APPLICATION_SHORT_NAME => 'MSC',
9437: STATEMENT_TYPE => ad_ddl.drop_table,
9438: STATEMENT => 'DROP TABLE ' || l_alloc_temp_table,
9439: OBJECT_NAME => l_alloc_temp_table);
9440:
9441: msc_util.msc_log('After Drop table : ' ||l_alloc_temp_table);

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

9440:
9441: msc_util.msc_log('After Drop table : ' ||l_alloc_temp_table);
9442: msc_util.msc_log('Before exception create table : ' ||l_alloc_temp_table);
9443:
9444: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9445: APPLICATION_SHORT_NAME => 'MSC',
9446: STATEMENT_TYPE => ad_ddl.create_table,
9447: STATEMENT => l_insert_stmt,
9448: OBJECT_NAME => l_alloc_temp_table);

Line 9446: STATEMENT_TYPE => ad_ddl.create_table,

9442: msc_util.msc_log('Before exception create table : ' ||l_alloc_temp_table);
9443:
9444: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9445: APPLICATION_SHORT_NAME => 'MSC',
9446: STATEMENT_TYPE => ad_ddl.create_table,
9447: STATEMENT => l_insert_stmt,
9448: OBJECT_NAME => l_alloc_temp_table);
9449:
9450: msc_util.msc_log('After exception create table : ' ||l_alloc_temp_table);

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

9520: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
9521:
9522: msc_util.msc_log('Before index : ' || l_alloc_temp_table || '.' || l_alloc_temp_table || '_N1');
9523:
9524: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9525: APPLICATION_SHORT_NAME => 'MSC',
9526: STATEMENT_TYPE => ad_ddl.create_index,
9527: STATEMENT => l_sql_stmt_1,
9528: OBJECT_NAME => l_alloc_temp_table);

Line 9526: STATEMENT_TYPE => ad_ddl.create_index,

9522: msc_util.msc_log('Before index : ' || l_alloc_temp_table || '.' || l_alloc_temp_table || '_N1');
9523:
9524: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9525: APPLICATION_SHORT_NAME => 'MSC',
9526: STATEMENT_TYPE => ad_ddl.create_index,
9527: STATEMENT => l_sql_stmt_1,
9528: OBJECT_NAME => l_alloc_temp_table);
9529:
9530: msc_util.msc_log('After index : ' || l_alloc_temp_table || '.' || l_alloc_temp_table || '_N1');

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

9714: */
9715:
9716: msc_util.msc_log('before creating table : ' || l_temp_table);
9717: BEGIN
9718: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9719: APPLICATION_SHORT_NAME => 'MSC',
9720: STATEMENT_TYPE => ad_ddl.create_table,
9721: STATEMENT => l_insert_stmt,
9722: OBJECT_NAME => l_temp_table);

Line 9720: STATEMENT_TYPE => ad_ddl.create_table,

9716: msc_util.msc_log('before creating table : ' || l_temp_table);
9717: BEGIN
9718: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9719: APPLICATION_SHORT_NAME => 'MSC',
9720: STATEMENT_TYPE => ad_ddl.create_table,
9721: STATEMENT => l_insert_stmt,
9722: OBJECT_NAME => l_temp_table);
9723: msc_util.msc_log('after creating table : ' || l_temp_table);
9724:

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

9726: WHEN others THEN
9727: msc_util.msc_log(sqlcode || ': ' || sqlerrm);
9728: msc_util.msc_log('Exception of create table : ' || l_temp_table);
9729:
9730: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9731: APPLICATION_SHORT_NAME => 'MSC',
9732: STATEMENT_TYPE => ad_ddl.drop_table,
9733: STATEMENT => 'DROP TABLE ' || l_temp_table,
9734: OBJECT_NAME => l_temp_table);

Line 9732: STATEMENT_TYPE => ad_ddl.drop_table,

9728: msc_util.msc_log('Exception of create table : ' || l_temp_table);
9729:
9730: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9731: APPLICATION_SHORT_NAME => 'MSC',
9732: STATEMENT_TYPE => ad_ddl.drop_table,
9733: STATEMENT => 'DROP TABLE ' || l_temp_table,
9734: OBJECT_NAME => l_temp_table);
9735:
9736: msc_util.msc_log('After Drop table : ' ||l_temp_table);

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

9735:
9736: msc_util.msc_log('After Drop table : ' ||l_temp_table);
9737: msc_util.msc_log('Before exception create table : ' ||l_temp_table);
9738:
9739: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9740: APPLICATION_SHORT_NAME => 'MSC',
9741: STATEMENT_TYPE => ad_ddl.create_table,
9742: STATEMENT => l_insert_stmt,
9743: OBJECT_NAME => l_temp_table);

Line 9741: STATEMENT_TYPE => ad_ddl.create_table,

9737: msc_util.msc_log('Before exception create table : ' ||l_temp_table);
9738:
9739: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9740: APPLICATION_SHORT_NAME => 'MSC',
9741: STATEMENT_TYPE => ad_ddl.create_table,
9742: STATEMENT => l_insert_stmt,
9743: OBJECT_NAME => l_temp_table);
9744: msc_util.msc_log('After exception create table : ' ||l_temp_table);
9745: END;

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

9796: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
9797:
9798: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N1');
9799:
9800: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9801: APPLICATION_SHORT_NAME => 'MSC',
9802: STATEMENT_TYPE => ad_ddl.create_index,
9803: STATEMENT => l_sql_stmt_1,
9804: OBJECT_NAME => l_temp_table);

Line 9802: STATEMENT_TYPE => ad_ddl.create_index,

9798: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N1');
9799:
9800: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9801: APPLICATION_SHORT_NAME => 'MSC',
9802: STATEMENT_TYPE => ad_ddl.create_index,
9803: STATEMENT => l_sql_stmt_1,
9804: OBJECT_NAME => l_temp_table);
9805:
9806: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N1');

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

9813: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
9814:
9815: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N2');
9816:
9817: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9818: APPLICATION_SHORT_NAME => 'MSC',
9819: STATEMENT_TYPE => ad_ddl.create_index,
9820: STATEMENT => l_sql_stmt_1,
9821: OBJECT_NAME => l_temp_table);

Line 9819: STATEMENT_TYPE => ad_ddl.create_index,

9815: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N2');
9816:
9817: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9818: APPLICATION_SHORT_NAME => 'MSC',
9819: STATEMENT_TYPE => ad_ddl.create_index,
9820: STATEMENT => l_sql_stmt_1,
9821: OBJECT_NAME => l_temp_table);
9822:
9823: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N2');

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

9830: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
9831:
9832: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N3');
9833:
9834: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9835: APPLICATION_SHORT_NAME => 'MSC',
9836: STATEMENT_TYPE => ad_ddl.create_index,
9837: STATEMENT => l_sql_stmt_1,
9838: OBJECT_NAME => l_temp_table);

Line 9836: STATEMENT_TYPE => ad_ddl.create_index,

9832: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N3');
9833:
9834: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9835: APPLICATION_SHORT_NAME => 'MSC',
9836: STATEMENT_TYPE => ad_ddl.create_index,
9837: STATEMENT => l_sql_stmt_1,
9838: OBJECT_NAME => l_temp_table);
9839:
9840: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N3');

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

9899: */
9900:
9901: msc_util.msc_log('before creating table : ' || l_temp_table);
9902: BEGIN
9903: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9904: APPLICATION_SHORT_NAME => 'MSC',
9905: STATEMENT_TYPE => ad_ddl.create_table,
9906: STATEMENT => l_insert_stmt,
9907: OBJECT_NAME => l_temp_table);

Line 9905: STATEMENT_TYPE => ad_ddl.create_table,

9901: msc_util.msc_log('before creating table : ' || l_temp_table);
9902: BEGIN
9903: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9904: APPLICATION_SHORT_NAME => 'MSC',
9905: STATEMENT_TYPE => ad_ddl.create_table,
9906: STATEMENT => l_insert_stmt,
9907: OBJECT_NAME => l_temp_table);
9908: msc_util.msc_log('after creating table : ' || l_temp_table);
9909:

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

9911: WHEN others THEN
9912: msc_util.msc_log(sqlcode || ': ' || sqlerrm);
9913: msc_util.msc_log('Exception of create table : ' || l_temp_table);
9914:
9915: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9916: APPLICATION_SHORT_NAME => 'MSC',
9917: STATEMENT_TYPE => ad_ddl.drop_table,
9918: STATEMENT => 'DROP TABLE ' || l_temp_table,
9919: OBJECT_NAME => l_temp_table);

Line 9917: STATEMENT_TYPE => ad_ddl.drop_table,

9913: msc_util.msc_log('Exception of create table : ' || l_temp_table);
9914:
9915: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9916: APPLICATION_SHORT_NAME => 'MSC',
9917: STATEMENT_TYPE => ad_ddl.drop_table,
9918: STATEMENT => 'DROP TABLE ' || l_temp_table,
9919: OBJECT_NAME => l_temp_table);
9920:
9921: msc_util.msc_log('After Drop table : ' ||l_temp_table);

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

9920:
9921: msc_util.msc_log('After Drop table : ' ||l_temp_table);
9922: msc_util.msc_log('Before exception create table : ' ||l_temp_table);
9923:
9924: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9925: APPLICATION_SHORT_NAME => 'MSC',
9926: STATEMENT_TYPE => ad_ddl.create_table,
9927: STATEMENT => l_insert_stmt,
9928: OBJECT_NAME => l_temp_table);

Line 9926: STATEMENT_TYPE => ad_ddl.create_table,

9922: msc_util.msc_log('Before exception create table : ' ||l_temp_table);
9923:
9924: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9925: APPLICATION_SHORT_NAME => 'MSC',
9926: STATEMENT_TYPE => ad_ddl.create_table,
9927: STATEMENT => l_insert_stmt,
9928: OBJECT_NAME => l_temp_table);
9929: msc_util.msc_log('After exception create table : ' ||l_temp_table);
9930: END;

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

9980: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
9981:
9982: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N1');
9983:
9984: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9985: APPLICATION_SHORT_NAME => 'MSC',
9986: STATEMENT_TYPE => ad_ddl.create_index,
9987: STATEMENT => l_sql_stmt_1,
9988: OBJECT_NAME => l_temp_table);

Line 9986: STATEMENT_TYPE => ad_ddl.create_index,

9982: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N1');
9983:
9984: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
9985: APPLICATION_SHORT_NAME => 'MSC',
9986: STATEMENT_TYPE => ad_ddl.create_index,
9987: STATEMENT => l_sql_stmt_1,
9988: OBJECT_NAME => l_temp_table);
9989:
9990: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N1');

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

9997: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
9998:
9999: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N2');
10000:
10001: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
10002: APPLICATION_SHORT_NAME => 'MSC',
10003: STATEMENT_TYPE => ad_ddl.create_index,
10004: STATEMENT => l_sql_stmt_1,
10005: OBJECT_NAME => l_temp_table);

Line 10003: STATEMENT_TYPE => ad_ddl.create_index,

9999: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N2');
10000:
10001: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
10002: APPLICATION_SHORT_NAME => 'MSC',
10003: STATEMENT_TYPE => ad_ddl.create_index,
10004: STATEMENT => l_sql_stmt_1,
10005: OBJECT_NAME => l_temp_table);
10006:
10007: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N2');

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

10014: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
10015:
10016: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N3');
10017:
10018: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
10019: APPLICATION_SHORT_NAME => 'MSC',
10020: STATEMENT_TYPE => ad_ddl.create_index,
10021: STATEMENT => l_sql_stmt_1,
10022: OBJECT_NAME => l_temp_table);

Line 10020: STATEMENT_TYPE => ad_ddl.create_index,

10016: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N3');
10017:
10018: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
10019: APPLICATION_SHORT_NAME => 'MSC',
10020: STATEMENT_TYPE => ad_ddl.create_index,
10021: STATEMENT => l_sql_stmt_1,
10022: OBJECT_NAME => l_temp_table);
10023:
10024: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N3');

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

10040: ' including indexes without validation';
10041:
10042: BEGIN
10043: msc_util.msc_log('Before alter table msc_alloc_demands');
10044: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
10045: APPLICATION_SHORT_NAME => 'MSC',
10046: STATEMENT_TYPE => ad_ddl.alter_table,
10047: STATEMENT => l_sql_stmt,
10048: OBJECT_NAME => 'MSC_ALLOC_DEMANDS');

Line 10046: STATEMENT_TYPE => ad_ddl.alter_table,

10042: BEGIN
10043: msc_util.msc_log('Before alter table msc_alloc_demands');
10044: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
10045: APPLICATION_SHORT_NAME => 'MSC',
10046: STATEMENT_TYPE => ad_ddl.alter_table,
10047: STATEMENT => l_sql_stmt,
10048: OBJECT_NAME => 'MSC_ALLOC_DEMANDS');
10049: END;
10050:

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

10058: ' including indexes without validation';
10059:
10060: BEGIN
10061: msc_util.msc_log('Before alter table msc_alloc_supplies');
10062: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
10063: APPLICATION_SHORT_NAME => 'MSC',
10064: STATEMENT_TYPE => ad_ddl.alter_table,
10065: STATEMENT => l_sql_stmt,
10066: OBJECT_NAME => 'MSC_ALLOC_SUPPLIES');

Line 10064: STATEMENT_TYPE => ad_ddl.alter_table,

10060: BEGIN
10061: msc_util.msc_log('Before alter table msc_alloc_supplies');
10062: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
10063: APPLICATION_SHORT_NAME => 'MSC',
10064: STATEMENT_TYPE => ad_ddl.alter_table,
10065: STATEMENT => l_sql_stmt,
10066: OBJECT_NAME => 'MSC_ALLOC_SUPPLIES');
10067: END;
10068: