APPS.MSC_DEMANTRA_PKG dependencies on MSC_PHUB_PKG

Line 126: select upper('msc_'||entity_name||'_f') into l_entity_name from table(msc_phub_pkg.meta_info) where fact_type=p_fact_type;

122:
123: function fact_table(p_fact_type number) return varchar2 is
124: l_entity_name varchar2(30);
125: begin
126: select upper('msc_'||entity_name||'_f') into l_entity_name from table(msc_phub_pkg.meta_info) where fact_type=p_fact_type;
127: return l_entity_name;
128: exception
129: when others then
130: return null;

Line 136: select upper('msc_st_'||entity_name||'_f') into l_entity_name from table(msc_phub_pkg.meta_info) where fact_type=p_fact_type;

132:
133: function staging_table(p_fact_type number) return varchar2 is
134: l_entity_name varchar2(30);
135: begin
136: select upper('msc_st_'||entity_name||'_f') into l_entity_name from table(msc_phub_pkg.meta_info) where fact_type=p_fact_type;
137: return l_entity_name;
138: exception
139: when others then
140: return null;

Line 228: from dba_tab_columns f, table(msc_phub_pkg.meta_info) m, user_synonyms syn

224:
225: merge into msc_apcc_custom_measures b
226: using
227: (select m.fact_type, f.column_name
228: from dba_tab_columns f, table(msc_phub_pkg.meta_info) m, user_synonyms syn
229: where m.fact_type in (4,5)
230: and syn.synonym_name='MSC_'||upper(m.entity_name)||'_F'
231: and f.owner=g_msc_schema
232: and f.column_name like 'ATTRIBUTE%'

Line 255: from dba_tab_columns f, table(msc_phub_pkg.meta_info) m, user_synonyms syn

251:
252: delete from msc_apcc_custom_measures b
253: where not exists
254: (select 1
255: from dba_tab_columns f, table(msc_phub_pkg.meta_info) m, user_synonyms syn
256: where m.fact_type in (4,5)
257: and syn.synonym_name='MSC_'||upper(m.entity_name)||'_F'
258: and f.owner=g_msc_schema
259: and f.column_name like 'ATTRIBUTE%'

Line 473: ' (select 4 fact_type, ''apps.msc_phub_pkg.archive_demantra_ods'' proc_name from dual'||LF||

469: ' (select /*+ ordered */ distinct m.fact_type, c.computed_name, c.computed_title, c.int_aggr_func'||LF||
470: ' from'||LF||
471: ' (select /*+ ordered */ distinct b.fact_type, q.id'||LF||
472: ' from'||LF||
473: ' (select 4 fact_type, ''apps.msc_phub_pkg.archive_demantra_ods'' proc_name from dual'||LF||
474: ' union select 5 fact_type, ''apps.msc_phub_pkg.archive_demantra_plan'' proc_name from dual'||LF||
475: ' ) b,'||LF||
476: ' (select extract(f.column_value, ''/PROCEDURE'') s'||LF||
477: ' from msc_hub_query t, xmltable(''/WORKFLOW/STOREDPROCEDURESTEP/PROCEDURE'' PASSING xmltype(t.clob1)) f'||LF||

Line 474: ' union select 5 fact_type, ''apps.msc_phub_pkg.archive_demantra_plan'' proc_name from dual'||LF||

470: ' from'||LF||
471: ' (select /*+ ordered */ distinct b.fact_type, q.id'||LF||
472: ' from'||LF||
473: ' (select 4 fact_type, ''apps.msc_phub_pkg.archive_demantra_ods'' proc_name from dual'||LF||
474: ' union select 5 fact_type, ''apps.msc_phub_pkg.archive_demantra_plan'' proc_name from dual'||LF||
475: ' ) b,'||LF||
476: ' (select extract(f.column_value, ''/PROCEDURE'') s'||LF||
477: ' from msc_hub_query t, xmltable(''/WORKFLOW/STOREDPROCEDURESTEP/PROCEDURE'' PASSING xmltype(t.clob1)) f'||LF||
478: ' where t.query_id='||l_qid_wf||LF||

Line 567: from msc_apcc_custom_measures f, table(msc_phub_pkg.meta_info) m

563: select
564: '00' lang_id,
565: g_msg_num_prefix2||upper(m.entity_name)||'_'||substr(to_char(substr(f.column_name,10),'09'),2) msg_num,
566: f.column_title msg_text
567: from msc_apcc_custom_measures f, table(msc_phub_pkg.meta_info) m
568: where f.fact_type=m.fact_type
569: and f.source_column_name is not null
570: order by to_number(substr(f.column_name,10));
571: msc_phub_util.log('msc_demantra_pkg.register_custom_measures: insert into msc_translated_message: '||sql%rowcount);