DBA Data[Home] [Help]

APPS.ZPB_AW_STATUS dependencies on DBMS_AW

Line 420: dbms_aw.execute ('call cm.log(''moo'' 2 '''||p_aw||': '||p_query||': '||p_dimension||''')');

416: WHERE (query_path = p_query)
417: AND DIMENSION_NAME = p_dimension
418: ORDER BY ROW_NUM;
419: BEGIN
420: dbms_aw.execute ('call cm.log(''moo'' 2 '''||p_aw||': '||p_query||': '||p_dimension||''')');
421: dbms_aw.execute ('call cm.log(''moo'' 2 '''||sys_context('ZPB_CONTEXT', 'business_area_id')||''')');
422: if (instr (upper(p_aw), upper(zpb_aw.get_schema)||'.') = 0 and
423: instr (upper(p_aw), 'ZPB') > 0) then
424: l_aw := zpb_aw.get_schema||'.'||p_aw;

Line 421: dbms_aw.execute ('call cm.log(''moo'' 2 '''||sys_context('ZPB_CONTEXT', 'business_area_id')||''')');

417: AND DIMENSION_NAME = p_dimension
418: ORDER BY ROW_NUM;
419: BEGIN
420: dbms_aw.execute ('call cm.log(''moo'' 2 '''||p_aw||': '||p_query||': '||p_dimension||''')');
421: dbms_aw.execute ('call cm.log(''moo'' 2 '''||sys_context('ZPB_CONTEXT', 'business_area_id')||''')');
422: if (instr (upper(p_aw), upper(zpb_aw.get_schema)||'.') = 0 and
423: instr (upper(p_aw), 'ZPB') > 0) then
424: l_aw := zpb_aw.get_schema||'.'||p_aw;
425: else