APPS.MSC_DEMANTRA_PKG dependencies on MSC_APCC_CUSTOM_HIER

Line 156: delete from msc_apcc_custom_hier;

152: msc_phub_util.log('(g_demantra_schema is null)');
153: return;
154: end if;
155:
156: delete from msc_apcc_custom_hier;
157: msc_phub_util.log('msc_demantra_pkg.build_custom_hierarchy: delete from msc_apcc_custom_hier: '||sql%rowcount);
158: commit;
159:
160: delete from msc_translated_message where lang_id='00' and msg_num like g_msg_num_prefix1||'%';

Line 157: msc_phub_util.log('msc_demantra_pkg.build_custom_hierarchy: delete from msc_apcc_custom_hier: '||sql%rowcount);

153: return;
154: end if;
155:
156: delete from msc_apcc_custom_hier;
157: msc_phub_util.log('msc_demantra_pkg.build_custom_hierarchy: delete from msc_apcc_custom_hier: '||sql%rowcount);
158: commit;
159:
160: delete from msc_translated_message where lang_id='00' and msg_num like g_msg_num_prefix1||'%';
161: msc_phub_util.log('msc_demantra_pkg.build_custom_hierarchy: delete from msc_translated_message: '||sql%rowcount);

Line 178: ' insert into msc_apcc_custom_hier('||LF||

174: l_sql2 := 'select count(1) from ('||l_sql||')';
175: execute immediate l_sql2 into l_n;
176: if (l_n > 0) then
177: l_sql2 :=
178: ' insert into msc_apcc_custom_hier('||LF||
179: ' detail_id,'||LF||
180: ' '||list_result('select ''level''||level_id from ('||l_sql||') where gtable<>''t_ep_item''', ','||LF)||
181: ' created_by, creation_date,'||LF||
182: ' last_update_date, last_updated_by, last_update_login,'||LF||

Line 200: msc_phub_util.log('msc_demantra_pkg.build_custom_hierarchy: insert into msc_apcc_custom_hier: '||sql%rowcount);

196: ' t_ep_item.ebs_item_dest_key is not null';
197:
198: msc_phub_util.log_sql(l_sql2);
199: execute immediate l_sql2;
200: msc_phub_util.log('msc_demantra_pkg.build_custom_hierarchy: insert into msc_apcc_custom_hier: '||sql%rowcount);
201: commit;
202:
203: l_sql2 :=
204: ' insert into msc_translated_message(lang_id, msg_num, msg_text)'||LF||