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.ZPB_METADATA_NAMES dependencies on ZPB_AW

Line 40: return zpb_aw.get_aw_short_name(p_aw)||'_ANNOTATIONS_V';

36: -------------------------------------------------------------------------------
37: function GET_ALL_ANNOTATIONS_VIEW (p_aw in varchar2)
38: return varchar2 is
39: begin
40: return zpb_aw.get_aw_short_name(p_aw)||'_ANNOTATIONS_V';
41: end GET_ALL_ANNOTATIONS_VIEW;
42:
43: -------------------------------------------------------------------------------
44: -- GET_ALL_ANNOT_PERS_VIEW - Gets the personal all annotations view name

Line 52: return zpb_aw.get_aw_short_name(p_aw)||'_PERS_ANNOTS_V';

48: -------------------------------------------------------------------------------
49: function GET_ALL_ANNOT_PERS_VIEW (p_aw in varchar2)
50: return varchar2 is
51: begin
52: return zpb_aw.get_aw_short_name(p_aw)||'_PERS_ANNOTS_V';
53: end GET_ALL_ANNOT_PERS_VIEW;
54:
55: -------------------------------------------------------------------------------
56: -- GET_ATTRIBUTE_COLUMN - Gets the column name for an attribute

Line 98: return zpb_aw.get_aw_short_name(p_aw)||'_ATTRSCOPE_V';

94: -------------------------------------------------------------------------------
95: function GET_ATTRIBUTE_SCOPE_VIEW (p_aw in varchar2)
96: return varchar2 is
97: begin
98: return zpb_aw.get_aw_short_name(p_aw)||'_ATTRSCOPE_V';
99: end GET_ATTRIBUTE_SCOPE_VIEW;
100:
101: -------------------------------------------------------------------------------
102: -- GET_CATALOG_CWM2_NAME - Gets the cwm2 name for a catalog

Line 111: return zpb_aw.get_aw_short_name(p_aw)||'_CAT';

107: function GET_CATALOG_CWM2_NAME (p_aw in varchar2)
108: return varchar2 is
109: begin
110: if (instr (p_aw, 'ZPBDATA') > 0) then
111: return zpb_aw.get_aw_short_name(p_aw)||'_CAT';
112: else
113: return 'PERSONAL_CAT';
114: end if;
115: end GET_CATALOG_CWM2_NAME;

Line 127: return zpb_aw.get_aw_short_name(p_aw)||'_DATAEXC_V';

123: -------------------------------------------------------------------------------
124: function GET_DATA_EXCEPTION_VIEW (p_aw in varchar2)
125: return varchar2 is
126: begin
127: return zpb_aw.get_aw_short_name(p_aw)||'_DATAEXC_V';
128: end GET_DATA_EXCEPTION_VIEW;
129:
130: -------------------------------------------------------------------------------
131: -- GET_DIMENSION_COLUMN - Gets the column name for a dimension

Line 154: return zpb_aw.get_aw_short_name(p_aw)||'_DIM_'||convert_ID(p_dimID);

150: p_dimID in varchar2)
151: return varchar2 is
152: begin
153: if (instr (p_aw, 'ZPBDATA') > 0) then
154: return zpb_aw.get_aw_short_name(p_aw)||'_DIM_'||convert_ID(p_dimID);
155: else
156: return 'PERSONAL_DIM_'||convert_ID(p_dimID);
157: end if;
158: end GET_DIMENSION_CWM2_NAME;

Line 177: l_aw := zpb_aw.get_aw_tiny_name(p_aw)||'PRS';

173: return varchar2 is
174: l_aw varchar2(30);
175: begin
176: if (p_type = 'PERSONAL') then
177: l_aw := zpb_aw.get_aw_tiny_name(p_aw)||'PRS';
178: else
179: l_aw := zpb_aw.get_aw_tiny_name(p_aw);
180: end if;
181: if (instr(p_hierarchyID, 'V') > 0) then

Line 179: l_aw := zpb_aw.get_aw_tiny_name(p_aw);

175: begin
176: if (p_type = 'PERSONAL') then
177: l_aw := zpb_aw.get_aw_tiny_name(p_aw)||'PRS';
178: else
179: l_aw := zpb_aw.get_aw_tiny_name(p_aw);
180: end if;
181: if (instr(p_hierarchyID, 'V') > 0) then
182: return l_aw||'_'||convert_id(p_dimID)||'_HV'||
183: substr(p_hierarchyID, instr(p_hierarchyID, 'V')+1)||'_V';

Line 275: return zpb_aw.get_aw_short_name(p_aw)||'_'||convert_id(p_dimID)||'_LONG_NM';

271: begin
272: if (instr (p_aw, 'ZPBDATA') > 0) then
273: return 'LONG DESCRIPTION';
274: else
275: return zpb_aw.get_aw_short_name(p_aw)||'_'||convert_id(p_dimID)||'_LONG_NM';
276: end if;
277: end GET_DIM_LONG_NAME_CWM2;
278:
279: -------------------------------------------------------------------------------

Line 344: return zpb_aw.get_aw_short_name(p_aw)||'_'||

340: begin
341: if (instr (p_aw, 'ZPBDATA') > 0) then
342: return 'SHORT DESCRIPTION';
343: else
344: return zpb_aw.get_aw_short_name(p_aw)||'_'||
345: convert_id(p_dimID)||'_SHORT_NM';
346: end if;
347: end GET_DIM_SHORT_NAME_CWM2;
348:

Line 372: return zpb_aw.get_aw_short_name(p_aw)||'_EXCPT_T';

368: -------------------------------------------------------------------------------
369: function GET_EXCEPTION_CHECK_TBL (p_aw in varchar2)
370: return varchar2 is
371: begin
372: return zpb_aw.get_aw_short_name(p_aw)||'_EXCPT_T';
373: end GET_EXCEPTION_CHECK_TBL;
374:
375: -------------------------------------------------------------------------------
376: -- GET_EXCEPTION_COLUMN - Gets the generic exception check column

Line 400: l_name := zpb_aw.get_aw_short_name(p_aw);

396: return varchar2 is
397: l_name varchar2(30);
398: begin
399: if (instr (p_aw, 'ZPBDATA') > 0) then
400: l_name := zpb_aw.get_aw_short_name(p_aw);
401: else
402: l_name := 'PERSONAL_';
403: end if;
404: return l_name||'_EXCEPT_'||p_instance||'_CB';

Line 421: l_name := zpb_aw.get_aw_short_name(p_aw);

417: return varchar2 is
418: l_name varchar2(30);
419: begin
420: if (instr (p_aw, 'ZPBDATA') > 0) then
421: l_name := zpb_aw.get_aw_short_name(p_aw);
422: else
423: l_name := 'PERSONAL_';
424: end if;
425: return l_name||'SHV'||p_instance||'_EXC_DF';

Line 438: return zpb_aw.get_aw_short_name(p_aw)||'_RATES_V';

434: -------------------------------------------------------------------------------
435: function GET_EXCH_RATES_VIEW (p_aw in varchar2)
436: return varchar2 is
437: begin
438: return zpb_aw.get_aw_short_name(p_aw)||'_RATES_V';
439: end GET_EXCH_RATES_VIEW;
440:
441: ---------------------------------------------------------------------------
442: -- GET_EXCH_SCENARIO_VIEW - Gets the exchange scenario view name

Line 451: return zpb_aw.get_aw_short_name(p_aw)||'_SCENARIO_V';

447: -------------------------------------------------------------------------------
448: function GET_EXCH_SCENARIO_VIEW (p_aw in varchar2)
449: return varchar2 is
450: begin
451: return zpb_aw.get_aw_short_name(p_aw)||'_SCENARIO_V';
452: end GET_EXCH_SCENARIO_VIEW;
453:
454: -------------------------------------------------------------------------------
455: -- GET_FULL_SCOPE_COLUMN - Gets the full scope column

Line 478: l_aw := zpb_aw.get_aw_short_name(p_aw);

474: function GET_FULL_SCOPE_CWM2_NAME (p_aw in varchar2)
475: return varchar2 is
476: l_aw VARCHAR2(60);
477: begin
478: l_aw := zpb_aw.get_aw_short_name(p_aw);
479: --
480: -- For backwards compatibility to rel 1. Bug 4507185
481: --
482: if (l_aw = 'ZPBDATA') then

Line 502: return zpb_aw.get_aw_short_name(p_aw)||'_'||p_dimID||'H_'||

498: p_hierarchyID in varchar2)
499: return varchar2 is
500: begin
501: if (instr (p_aw, 'ZPBDATA') > 0) then
502: return zpb_aw.get_aw_short_name(p_aw)||'_'||p_dimID||'H_'||
503: nvl(p_hierarchyID, 0);
504: else
505: return 'PERSONAL_'||p_dimID||'H_'||nvl(p_hierarchyID, 0);
506: end if;

Line 520: return zpb_aw.get_aw_short_name(p_aw)||'_HIERSCP_'||p_dimID||'_V';

516: function GET_HIERARCHY_SCOPE_VIEW (p_aw in varchar2,
517: p_dimID in varchar2)
518: return varchar2 is
519: begin
520: return zpb_aw.get_aw_short_name(p_aw)||'_HIERSCP_'||p_dimID||'_V';
521: end GET_HIERARCHY_SCOPE_VIEW;
522:
523: -------------------------------------------------------------------------------
524: -- GET_LEVEL_COLUMN - Gets the level column name

Line 563: return zpb_aw.get_aw_short_name(p_aw)||'_'||p_dimID||'H'||

559: p_levelID in varchar2)
560: return varchar2 is
561: begin
562: if (instr (p_aw, 'ZPBDATA') > 0) then
563: return zpb_aw.get_aw_short_name(p_aw)||'_'||p_dimID||'H'||
564: nvl(p_hierID, 0)||'LV'||nvl(p_levelID, 0);
565: else
566: return 'PERSONAL_'||p_dimID||'H'||nvl(p_hierID, 0)||
567: 'LV'||nvl(p_levelID, 0);

Line 582: return zpb_aw.get_aw_short_name(p_aw)||'_LVLSCP_'||p_dimID||'_V';

578: function GET_LEVEL_SCOPE_VIEW (p_aw in varchar2,
579: p_dimID in varchar2)
580: return varchar2 is
581: begin
582: return zpb_aw.get_aw_short_name(p_aw)||'_LVLSCP_'||p_dimID||'_V';
583: end GET_LEVEL_SCOPE_VIEW;
584:
585: -------------------------------------------------------------------------------
586: -- GET_MEASURE_ANNOT_CWM2 - Gets the measure annotation cwm2 name

Line 604: l_name := zpb_aw.get_aw_short_name(p_aw);

600: return varchar2 is
601: l_name varchar2(60);
602: begin
603: if (instr (p_aw, 'ZPBDATA') > 0) then
604: l_name := zpb_aw.get_aw_short_name(p_aw);
605: else
606: l_name := 'PERSONAL_';
607: end if;
608: l_name := l_name||get_measure_type_abbrev(p_type)||p_instance;

Line 647: l_name := zpb_aw.get_aw_short_name(p_aw);

643: return varchar2 is
644: l_name varchar2(60);
645: begin
646: if (instr (p_aw, 'ZPBDATA') > 0) then
647: l_name := zpb_aw.get_aw_short_name(p_aw);
648: else
649: l_name := 'PERSONAL_';
650: end if;
651: l_name := l_name||get_measure_type_abbrev(p_type)||p_instance;

Line 691: l_name := zpb_aw.get_aw_short_name(p_aw);

687: return varchar2 is
688: l_name varchar2(60);
689: begin
690: if (instr (p_aw, 'ZPBDATA') > 0) then
691: l_name := zpb_aw.get_aw_short_name(p_aw);
692: else
693: l_name := 'PERSONAL_';
694: end if;
695: l_name := l_name||get_measure_type_abbrev(p_type)||p_instance;

Line 733: l_name := zpb_aw.get_aw_short_name(p_aw);

729: return varchar2 is
730: l_name varchar2(60);
731: begin
732: if (instr (p_aw, 'ZPBDATA') > 0) then
733: l_name := zpb_aw.get_aw_short_name(p_aw);
734: else
735: l_name := 'PERSONAL_';
736: end if;
737: l_name := l_name||get_measure_type_abbrev(p_type)||p_instance;

Line 759: l_name := zpb_aw.get_aw_short_name(p_aw);

755: return varchar2 is
756: l_name varchar2(60);
757: begin
758: if (instr (p_aw, 'ZPBDATA') > 0) then
759: l_name := zpb_aw.get_aw_short_name(p_aw);
760: else
761: l_name := 'PERSONAL_';
762: end if;
763: l_name := l_name||get_measure_type_abbrev(p_type)||p_instance;

Line 791: l_name := zpb_aw.get_aw_short_name(p_aw);

787: return varchar2 is
788: l_name varchar2(60);
789: begin
790: if (instr (p_aw, 'ZPBDATA') > 0) then
791: l_name := zpb_aw.get_aw_short_name(p_aw);
792: else
793: l_name := 'PERSONAL_';
794: end if;
795: l_name := l_name||get_measure_type_abbrev(p_type)||p_instance;

Line 839: l_name := zpb_aw.get_aw_short_name(p_aw);

835: return varchar2 is
836: l_name varchar2(60);
837: begin
838: if (instr (p_aw, 'ZPBDATA') > 0) then
839: l_name := zpb_aw.get_aw_short_name(p_aw);
840: else
841: l_name := 'PERSONAL_';
842: end if;
843: l_name := l_name||get_measure_type_abbrev(p_type)||p_instance;

Line 865: l_name := zpb_aw.get_aw_short_name(p_aw);

861: return varchar2 is
862: l_name varchar2(60);
863: begin
864: if (instr (p_aw, 'ZPBDATA') > 0) then
865: l_name := zpb_aw.get_aw_short_name(p_aw);
866: else
867: l_name := 'PERSONAL_';
868: end if;
869: l_name := l_name||get_measure_type_abbrev(p_type)||p_instance;

Line 896: return zpb_aw.get_aw_short_name(p_aw)||'_OWNERMAP_CB';

892: -------------------------------------------------------------------------------
893: function GET_OWNERMAP_CWM2_CUBE (p_aw in varchar2)
894: return varchar2 is
895: begin
896: return zpb_aw.get_aw_short_name(p_aw)||'_OWNERMAP_CB';
897: end GET_OWNERMAP_CWM2_CUBE;
898:
899: -------------------------------------------------------------------------------
900: -- GET_OWNERMAP_CWM2_NAME - Gets the ownermap measure

Line 909: return zpb_aw.get_aw_short_name(p_aw)||'_MEAS_OWNERMAP';

905: -------------------------------------------------------------------------------
906: function GET_OWNERMAP_CWM2_NAME (p_aw in varchar2)
907: return varchar2 is
908: begin
909: return zpb_aw.get_aw_short_name(p_aw)||'_MEAS_OWNERMAP';
910: end GET_OWNERMAP_CWM2_NAME;
911:
912: -------------------------------------------------------------------
913: -- GET_OWNERMAP_VIEW - Gets the ownermap view

Line 922: return zpb_aw.get_aw_short_name(p_aw)||'_OWNERMAP_V';

918: -------------------------------------------------------------------------------
919: function GET_OWNERMAP_VIEW (p_aw in varchar2)
920: return varchar2 is
921: begin
922: return zpb_aw.get_aw_short_name(p_aw)||'_OWNERMAP_V';
923: end GET_OWNERMAP_VIEW;
924:
925: -------------------------------------------------------------------------------
926: -- GET_SCOPE_STATUS_VIEW - Gets the scope view name

Line 935: return zpb_aw.get_aw_short_name(p_aw)||'_SECSCPSTAT_V';

931: -------------------------------------------------------------------------------
932: function GET_SCOPE_STATUS_VIEW (p_aw in varchar2)
933: return varchar2 is
934: begin
935: return zpb_aw.get_aw_short_name(p_aw)||'_SECSCPSTAT_V';
936: end GET_SCOPE_STATUS_VIEW;
937:
938: ---------------------------------------------------------------------------
939: -- GET_SCOPING_VIEW - Gets the metadata scoping view

Line 948: return zpb_aw.get_aw_short_name(p_aw)||'_SCOPING_V';

944: -------------------------------------------------------------------------------
945: function GET_SCOPING_VIEW (p_aw in varchar2)
946: return varchar2 is
947: begin
948: return zpb_aw.get_aw_short_name(p_aw)||'_SCOPING_V';
949: end GET_SCOPING_VIEW;
950:
951: -------------------------------------------------------------------------------
952: -- GET_SECURITY_CWM2_CUBE - Gets the security (ownermap) cube

Line 961: return zpb_aw.get_aw_short_name(p_aw)||'_SECURITY_CB';

957: -------------------------------------------------------------------------------
958: function GET_SECURITY_CWM2_CUBE (p_aw in varchar2)
959: return varchar2 is
960: begin
961: return zpb_aw.get_aw_short_name(p_aw)||'_SECURITY_CB';
962: end GET_SECURITY_CWM2_CUBE;
963:
964: -------------------------------------------------------------------------------
965: -- GET_SECURITY_VIEW - Gets the security (ownermap) view

Line 974: return zpb_aw.get_aw_short_name(p_aw)||'_SECURITY_V';

970: -------------------------------------------------------------------------------
971: function GET_SECURITY_VIEW (p_aw in varchar2)
972: return varchar2 is
973: begin
974: return zpb_aw.get_aw_short_name(p_aw)||'_SECURITY_V';
975: end GET_SECURITY_VIEW;
976:
977: ---------------------------------------------------------------------------
978: -- GET_SOLVE_LEVEL_TABLE - Gets the solve input/output level table name

Line 987: return zpb_aw.get_aw_short_name(p_aw)||'_SOLVE_LEVEL_T';

983: -------------------------------------------------------------------------------
984: function GET_SOLVE_LEVEL_TABLE (p_aw in varchar2)
985: return varchar2 is
986: begin
987: return zpb_aw.get_aw_short_name(p_aw)||'_SOLVE_LEVEL_T';
988: end GET_SOLVE_LEVEL_TABLE;
989:
990: ---------------------------------------------------------------------------
991: -- GET_TO_CURRENCY_VIEW - Gets the to currency view name

Line 1000: return zpb_aw.get_aw_short_name(p_aw)||'_TO_CURRENCY_V';

996: -------------------------------------------------------------------------------
997: function GET_TO_CURRENCY_VIEW (p_aw in varchar2)
998: return varchar2 is
999: begin
1000: return zpb_aw.get_aw_short_name(p_aw)||'_TO_CURRENCY_V';
1001: end GET_TO_CURRENCY_VIEW;
1002:
1003: -------------------------------------------------------------------------------
1004: -- GET_VIEW_OBJECT - Gets the measure view object name