APPS.MSC_CL_SUPPLY_ODS_LOAD dependencies on AD_DDL

Line 72: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

68: BEGIN
69:
70: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'FND', lv_dummy1, lv_dummy2, MSC_CL_COLLECTION.v_applsys_schema);
71:
72: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
73: application_short_name => 'MSC',
74: statement_type => AD_DDL.CREATE_INDEX,
75: statement =>
76: 'create index supplies_nx_'||MSC_CL_COLLECTION.v_instance_code

Line 74: statement_type => AD_DDL.CREATE_INDEX,

70: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'FND', lv_dummy1, lv_dummy2, MSC_CL_COLLECTION.v_applsys_schema);
71:
72: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
73: application_short_name => 'MSC',
74: statement_type => AD_DDL.CREATE_INDEX,
75: statement =>
76: 'create index supplies_nx_'||MSC_CL_COLLECTION.v_instance_code
77: ||' on '||'supplies_'||MSC_CL_COLLECTION.v_instance_code
78: ||'(disposition_id, order_type) '

Line 85: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

81: object_name => 'supplies_nx_'||MSC_CL_COLLECTION.v_instance_code);
82:
83: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SUPPLIES_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');
84:
85: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
86: application_short_name => 'MSC',
87: statement_type => AD_DDL.CREATE_INDEX,
88: statement =>
89: 'create index supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code

Line 87: statement_type => AD_DDL.CREATE_INDEX,

83: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SUPPLIES_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');
84:
85: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
86: application_short_name => 'MSC',
87: statement_type => AD_DDL.CREATE_INDEX,
88: statement =>
89: 'create index supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code
90: ||' on '||'supplies_'||MSC_CL_COLLECTION.v_instance_code
91: ||'(plan_id, sr_instance_id, order_number, purch_line_num) '

Line 98: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

94: object_name => 'supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code);
95:
96: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SUPPLIES_NX1_'||MSC_CL_COLLECTION.v_instance_code||' created.');
97:
98: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
99: application_short_name => 'MSC',
100: statement_type => AD_DDL.CREATE_INDEX,
101: statement =>
102: 'create index supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code

Line 100: statement_type => AD_DDL.CREATE_INDEX,

96: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SUPPLIES_NX1_'||MSC_CL_COLLECTION.v_instance_code||' created.');
97:
98: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
99: application_short_name => 'MSC',
100: statement_type => AD_DDL.CREATE_INDEX,
101: statement =>
102: 'create index supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code
103: ||' on '||'supplies_'||MSC_CL_COLLECTION.v_instance_code
104: ||'(plan_id, sr_instance_id, disposition_id, po_line_id ) '

Line 157: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

153:
154: IF (lv_drop_index = 1) THEN
155:
156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index :'||lv_ind_name);
157: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
158: application_short_name => 'MSC',
159: statement_type => AD_DDL.DROP_INDEX,
160: statement =>
161: 'drop index supplies_nx_'||MSC_CL_COLLECTION.v_instance_code,

Line 159: statement_type => AD_DDL.DROP_INDEX,

155:
156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index :'||lv_ind_name);
157: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
158: application_short_name => 'MSC',
159: statement_type => AD_DDL.DROP_INDEX,
160: statement =>
161: 'drop index supplies_nx_'||MSC_CL_COLLECTION.v_instance_code,
162: object_name => 'supplies_nx_'||MSC_CL_COLLECTION.v_instance_code);
163: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropped the index :'||lv_ind_name);

Line 176: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

172: USING lv_msc_schema,lv_msc_schema,lv_ind_name;
173:
174: IF (lv_drop_index = 1) THEN
175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index :'||lv_ind_name);
176: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
177: application_short_name => 'MSC',
178: statement_type => AD_DDL.DROP_INDEX,
179: statement =>
180: 'drop index supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code,

Line 178: statement_type => AD_DDL.DROP_INDEX,

174: IF (lv_drop_index = 1) THEN
175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index :'||lv_ind_name);
176: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
177: application_short_name => 'MSC',
178: statement_type => AD_DDL.DROP_INDEX,
179: statement =>
180: 'drop index supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code,
181: object_name => 'supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code);
182:

Line 195: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

191: USING lv_msc_schema,lv_msc_schema,lv_ind_name;
192:
193: IF (lv_drop_index = 1) THEN
194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index :'||lv_ind_name);
195: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
196: application_short_name => 'MSC',
197: statement_type => AD_DDL.DROP_INDEX,
198: statement =>
199: 'drop index supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code,

Line 197: statement_type => AD_DDL.DROP_INDEX,

193: IF (lv_drop_index = 1) THEN
194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index :'||lv_ind_name);
195: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
196: application_short_name => 'MSC',
197: statement_type => AD_DDL.DROP_INDEX,
198: statement =>
199: 'drop index supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code,
200: object_name => 'supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code);
201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropped the index :'||lv_ind_name);