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.OPI_DBI_RPT_UTIL_PKG dependencies on POA_DBI_UTIL_PKG

Line 10: poa_dbi_util_pkg.poa_dbi_dim_map,

6: /*++++++++++++++++++++++++++++++++++++++++*/
7: /* Local Functions
8: /*++++++++++++++++++++++++++++++++++++++++*/
9: PROCEDURE init_dim_map (p_dim_map out NOCOPY
10: poa_dbi_util_pkg.poa_dbi_dim_map,
11: p_mv_set IN VARCHAR2);
12:
13: PROCEDURE reinit_dim_map (p_dim_map in out NOCOPY
14: poa_dbi_util_pkg.poa_dbi_dim_map,

Line 14: poa_dbi_util_pkg.poa_dbi_dim_map,

10: poa_dbi_util_pkg.poa_dbi_dim_map,
11: p_mv_set IN VARCHAR2);
12:
13: PROCEDURE reinit_dim_map (p_dim_map in out NOCOPY
14: poa_dbi_util_pkg.poa_dbi_dim_map,
15: p_mv IN VARCHAR2,
16: p_mv_set IN VARCHAR2);
17:
18: FUNCTION get_mv (p_mv_set IN VARCHAR2,

Line 21: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map)

17:
18: FUNCTION get_mv (p_mv_set IN VARCHAR2,
19: p_mv_level_flag IN VARCHAR2,
20: p_view_by IN VARCHAR2,
21: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map)
22: RETURN VARCHAR2;
23:
24: FUNCTION get_col_name (p_dim_name VARCHAR2)
25: RETURN VARCHAR2;

Line 95: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map,

91: FUNCTION get_trx_reason_where_clause (p_trend IN VARCHAR2 := 'N')
92: RETURN VARCHAR2;
93:
94: PROCEDURE get_join_info (p_view_by IN varchar2,
95: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map,
96: x_join_tbl OUT NOCOPY
97: poa_dbi_util_pkg.POA_DBI_JOIN_TBL,
98: p_mv_set IN VARCHAR2);
99:

Line 97: poa_dbi_util_pkg.POA_DBI_JOIN_TBL,

93:
94: PROCEDURE get_join_info (p_view_by IN varchar2,
95: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map,
96: x_join_tbl OUT NOCOPY
97: poa_dbi_util_pkg.POA_DBI_JOIN_TBL,
98: p_mv_set IN VARCHAR2);
99:
100: FUNCTION get_mv_level_flag (p_mv_flag_type VARCHAR2,
101: p_dim_name VARCHAR2,

Line 102: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map)

98: p_mv_set IN VARCHAR2);
99:
100: FUNCTION get_mv_level_flag (p_mv_flag_type VARCHAR2,
101: p_dim_name VARCHAR2,
102: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map)
103: RETURN VARCHAR2;
104:
105:
106: FUNCTION get_item_flag_val (p_dim_name VARCHAR2,

Line 107: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map)

103: RETURN VARCHAR2;
104:
105:
106: FUNCTION get_item_flag_val (p_dim_name VARCHAR2,
107: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map)
108: RETURN VARCHAR2;
109:
110: FUNCTION get_inv_val_aggr_flag (p_dim_name VARCHAR2,
111: p_dim_map IN

Line 112: poa_dbi_util_pkg.poa_dbi_dim_map)

108: RETURN VARCHAR2;
109:
110: FUNCTION get_inv_val_aggr_flag (p_dim_name VARCHAR2,
111: p_dim_map IN
112: poa_dbi_util_pkg.poa_dbi_dim_map)
113: RETURN VARCHAR2;
114:
115: FUNCTION get_wms_rtx_aggr_flag (p_dim_name VARCHAR2,
116: p_dim_map IN

Line 117: poa_dbi_util_pkg.poa_dbi_dim_map)

113: RETURN VARCHAR2;
114:
115: FUNCTION get_wms_rtx_aggr_flag (p_dim_name VARCHAR2,
116: p_dim_map IN
117: poa_dbi_util_pkg.poa_dbi_dim_map)
118: RETURN VARCHAR2;
119:
120: FUNCTION get_wms_rtp_aggr_flag (p_dim_name VARCHAR2,
121: p_dim_map IN

Line 122: poa_dbi_util_pkg.poa_dbi_dim_map)

118: RETURN VARCHAR2;
119:
120: FUNCTION get_wms_rtp_aggr_flag (p_dim_name VARCHAR2,
121: p_dim_map IN
122: poa_dbi_util_pkg.poa_dbi_dim_map)
123: RETURN VARCHAR2;
124:
125: FUNCTION get_resource_level_flag_val (p_dim_name IN VARCHAR2,
126: p_dim_map IN

Line 127: poa_dbi_util_pkg.poa_dbi_dim_map)

123: RETURN VARCHAR2;
124:
125: FUNCTION get_resource_level_flag_val (p_dim_name IN VARCHAR2,
126: p_dim_map IN
127: poa_dbi_util_pkg.poa_dbi_dim_map)
128: RETURN VARCHAR2;
129:
130: FUNCTION get_wms_c_utz_item_aggr_flag (p_dim_name VARCHAR2,
131: p_dim_map IN

Line 132: poa_dbi_util_pkg.poa_dbi_dim_map)

128: RETURN VARCHAR2;
129:
130: FUNCTION get_wms_c_utz_item_aggr_flag (p_dim_name VARCHAR2,
131: p_dim_map IN
132: poa_dbi_util_pkg.poa_dbi_dim_map)
133: RETURN VARCHAR2;
134:
135: FUNCTION get_wms_c_utz_sub_aggr_flag (p_dim_name VARCHAR2,
136: p_dim_map IN

Line 137: poa_dbi_util_pkg.poa_dbi_dim_map)

133: RETURN VARCHAR2;
134:
135: FUNCTION get_wms_c_utz_sub_aggr_flag (p_dim_name VARCHAR2,
136: p_dim_map IN
137: poa_dbi_util_pkg.poa_dbi_dim_map)
138: RETURN VARCHAR2;
139:
140: FUNCTION get_wms_stor_utz_aggr_flag (p_dim_name VARCHAR2,
141: p_dim_map IN

Line 142: poa_dbi_util_pkg.poa_dbi_dim_map)

138: RETURN VARCHAR2;
139:
140: FUNCTION get_wms_stor_utz_aggr_flag (p_dim_name VARCHAR2,
141: p_dim_map IN
142: poa_dbi_util_pkg.poa_dbi_dim_map)
143: RETURN VARCHAR2;
144:
145: /* mochawla - declare functions for Pick and OP in DBI 7.1*/
146: FUNCTION get_wms_pex_aggr_flag (p_dim_name VARCHAR2,

Line 148: poa_dbi_util_pkg.poa_dbi_dim_map)

144:
145: /* mochawla - declare functions for Pick and OP in DBI 7.1*/
146: FUNCTION get_wms_pex_aggr_flag (p_dim_name VARCHAR2,
147: p_dim_map IN
148: poa_dbi_util_pkg.poa_dbi_dim_map)
149: RETURN VARCHAR2;
150:
151: FUNCTION get_wms_per_aggr_flag (p_dim_name VARCHAR2,
152: p_dim_map IN

Line 153: poa_dbi_util_pkg.poa_dbi_dim_map)

149: RETURN VARCHAR2;
150:
151: FUNCTION get_wms_per_aggr_flag (p_dim_name VARCHAR2,
152: p_dim_map IN
153: poa_dbi_util_pkg.poa_dbi_dim_map)
154: RETURN VARCHAR2;
155:
156: FUNCTION get_wms_opp_aggr_flag (p_dim_name VARCHAR2,
157: p_dim_map IN

Line 158: poa_dbi_util_pkg.poa_dbi_dim_map)

154: RETURN VARCHAR2;
155:
156: FUNCTION get_wms_opp_aggr_flag (p_dim_name VARCHAR2,
157: p_dim_map IN
158: poa_dbi_util_pkg.poa_dbi_dim_map)
159: RETURN VARCHAR2;
160:
161: FUNCTION get_wms_oper_aggr_flag (p_dim_name VARCHAR2,
162: p_dim_map IN

Line 163: poa_dbi_util_pkg.poa_dbi_dim_map)

159: RETURN VARCHAR2;
160:
161: FUNCTION get_wms_oper_aggr_flag (p_dim_name VARCHAR2,
162: p_dim_map IN
163: poa_dbi_util_pkg.poa_dbi_dim_map)
164: RETURN VARCHAR2;
165:
166: /* Current Inventory Expiration Status */
167: FUNCTION get_rollup1_aggr_flag (p_dim_name VARCHAR2,

Line 169: poa_dbi_util_pkg.poa_dbi_dim_map)

165:
166: /* Current Inventory Expiration Status */
167: FUNCTION get_rollup1_aggr_flag (p_dim_name VARCHAR2,
168: p_dim_map IN
169: poa_dbi_util_pkg.poa_dbi_dim_map)
170: RETURN VARCHAR2;
171:
172: /*Scrap By Reason */
173: FUNCTION get_trx_reason_aggr_flag (p_dim_name VARCHAR2,

Line 175: poa_dbi_util_pkg.poa_dbi_dim_map)

171:
172: /*Scrap By Reason */
173: FUNCTION get_trx_reason_aggr_flag (p_dim_name VARCHAR2,
174: p_dim_map IN
175: poa_dbi_util_pkg.poa_dbi_dim_map)
176: RETURN VARCHAR2;
177:
178: /* changes for Cycle Count in DBI 7.0 */
179: FUNCTION get_cca_flag_where_clause(p_trend IN VARCHAR2 := 'N')

Line 185: poa_dbi_util_pkg.poa_dbi_dim_map)

181:
182:
183: FUNCTION get_cca_level_flag_val (p_dim_name IN VARCHAR2,
184: p_dim_map IN
185: poa_dbi_util_pkg.poa_dbi_dim_map)
186: RETURN VARCHAR2;
187:
188: FUNCTION get_agg_level (p_mv_lvl_tbl IN opi_dbi_rpt_util_pkg.MV_AGG_LVL_TBL,
189: p_dim_bmap IN NUMBER)

Line 198: poa_dbi_util_pkg.poa_dbi_dim_map)

194: */
195:
196: FUNCTION get_prodcat_cust_flag_val(p_dim_name IN VARCHAR2,
197: p_dim_map IN
198: poa_dbi_util_pkg.poa_dbi_dim_map)
199: RETURN VARCHAR2;
200:
201: FUNCTION get_prdcat_cust_where_clause(p_trend IN VARCHAR2 := 'N')
202: RETURN VARCHAR2;

Line 205: p_view_by IN VARCHAR2, p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map)

201: FUNCTION get_prdcat_cust_where_clause(p_trend IN VARCHAR2 := 'N')
202: RETURN VARCHAR2;
203:
204: FUNCTION select_mv (p_mv_set IN VARCHAR2, p_mv_level_flag IN VARCHAR2,
205: p_view_by IN VARCHAR2, p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map)
206: RETURN VARCHAR2;
207:
208: FUNCTION get_mv_where_clause_flag (p_mv IN VARCHAR2)
209: RETURN VARCHAR2;

Line 247: poa_dbi_util_pkg.poa_dbi_join_tbl,

243: p_cur_suffix OUT NOCOPY VARCHAR2,
244: p_where_clause OUT NOCOPY VARCHAR2,
245: p_mv OUT NOCOPY VARCHAR2,
246: p_join_tbl OUT NOCOPY
247: poa_dbi_util_pkg.poa_dbi_join_tbl,
248: p_mv_level_flag OUT NOCOPY VARCHAR2,
249: p_trend IN VARCHAR2,
250: p_func_area IN VaRCHAR2,
251: p_version IN VARCHAR2,

Line 256: l_dim_map poa_dbi_util_pkg.poa_dbi_dim_map;

252: p_role IN VARCHAR2,
253: p_mv_set IN VARCHAR2,
254: p_mv_flag_type IN VARCHAR2 := 'NONE')
255: IS
256: l_dim_map poa_dbi_util_pkg.poa_dbi_dim_map;
257: l_dim_bmap NUMBER := 0;
258: l_org_val VARCHAR2 (120) := NULL;
259:
260: l_as_of_date DATE;

Line 278: poa_dbi_util_pkg.get_parameter_values (p_param => p_param,

274:
275: -- Get the various parameter values from the utility package.
276: -- This package will also compute the l_dim_bmap
277: l_stmt_id := 20;
278: poa_dbi_util_pkg.get_parameter_values (p_param => p_param,
279: p_dim_map => l_dim_map,
280: p_view_by => p_view_by,
281: p_comparison_type => p_comparison_type,
282: p_xtd => p_xtd,

Line 341: p_where_clause := p_where_clause || poa_dbi_util_pkg.get_where_clauses (p_dim_map => l_dim_map,

337: p_where_clause := '';
338: end if;
339:
340: l_stmt_id := 80;
341: p_where_clause := p_where_clause || poa_dbi_util_pkg.get_where_clauses (p_dim_map => l_dim_map,
342: p_trend => p_trend);
343:
344: -- Attach the optional MV flag where clause
345: l_stmt_id := 90;

Line 888: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map)

884:
885: FUNCTION get_mv (p_mv_set IN VARCHAR2,
886: p_mv_level_flag IN VARCHAR2,
887: p_view_by IN VARCHAR2,
888: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map)
889: RETURN VARCHAR2
890:
891: IS
892:

Line 987: poa_dbi_util_pkg.poa_dbi_dim_map,

983: DBI 8.0 - For Scrap By Reason Report
984: OPI_MFG_TRX_REASON+OPI_MFG_MTL_TRX_REASON_LVL
985: */
986: PROCEDURE init_dim_map (p_dim_map out NOCOPY
987: poa_dbi_util_pkg.poa_dbi_dim_map,
988: p_mv_set IN VARCHAR2)
989: IS
990:
991: l_dim_rec poa_dbi_util_pkg.poa_dbi_dim_rec;

Line 991: l_dim_rec poa_dbi_util_pkg.poa_dbi_dim_rec;

987: poa_dbi_util_pkg.poa_dbi_dim_map,
988: p_mv_set IN VARCHAR2)
989: IS
990:
991: l_dim_rec poa_dbi_util_pkg.poa_dbi_dim_rec;
992:
993: BEGIN
994:
995: -- Category dimension level

Line 1150: poa_dbi_util_pkg.poa_dbi_dim_map,

1146: Product Gross Margin. If the MV determined by select_mv is the Inline View the
1147: column name is parent_id
1148: */
1149: PROCEDURE reinit_dim_map (p_dim_map in out NOCOPY
1150: poa_dbi_util_pkg.poa_dbi_dim_map,
1151: p_mv IN VARCHAR2,
1152: p_mv_set IN VARCHAR2)
1153: IS
1154:

Line 1155: l_dim_rec poa_dbi_util_pkg.poa_dbi_dim_rec;

1151: p_mv IN VARCHAR2,
1152: p_mv_set IN VARCHAR2)
1153: IS
1154:
1155: l_dim_rec poa_dbi_util_pkg.poa_dbi_dim_rec;
1156: BEGIN
1157: IF (p_mv <> 'OPI_PGM_SUM_MV' AND p_mv <> 'OPI_PGM_CAT_MV' AND p_mv_set = 'PGM') THEN
1158: l_dim_rec := p_dim_map('ITEM+ENI_ITEM_VBH_CAT');
1159: l_dim_rec.col_name := 'parent_id';

Line 1304: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map,

1300: 1. Add Product Category and Customer dimension to l_join_rec.column_name
1301: 2. Add 'PGM' to get join info for UOM
1302: */
1303: PROCEDURE get_join_info (p_view_by IN varchar2,
1304: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map,
1305: x_join_tbl OUT NOCOPY
1306: poa_dbi_util_pkg.POA_DBI_JOIN_TBL,
1307: p_mv_set IN VARCHAR2)
1308: IS

Line 1306: poa_dbi_util_pkg.POA_DBI_JOIN_TBL,

1302: */
1303: PROCEDURE get_join_info (p_view_by IN varchar2,
1304: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map,
1305: x_join_tbl OUT NOCOPY
1306: poa_dbi_util_pkg.POA_DBI_JOIN_TBL,
1307: p_mv_set IN VARCHAR2)
1308: IS
1309: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
1310:

Line 1309: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;

1305: x_join_tbl OUT NOCOPY
1306: poa_dbi_util_pkg.POA_DBI_JOIN_TBL,
1307: p_mv_set IN VARCHAR2)
1308: IS
1309: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
1310:
1311: BEGIN
1312:
1313: -- reinitialize the join table

Line 1314: x_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

1310:
1311: BEGIN
1312:
1313: -- reinitialize the join table
1314: x_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
1315:
1316: -- If the view by column is not in the bitmap, then
1317: -- there is nothing to join to. Can this ever be true?
1318: IF (NOT p_dim_map.exists(p_view_by)) THEN

Line 1588: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map)

1584: WMS_OPER- OP Exceptions by Reason
1585: */
1586: FUNCTION get_mv_level_flag (p_mv_flag_type VARCHAR2,
1587: p_dim_name VARCHAR2,
1588: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map)
1589: RETURN VARCHAR2
1590: IS
1591:
1592: l_mv_level_flag VARCHAR2 (10) := '';

Line 1654: poa_dbi_util_pkg.poa_dbi_dim_map)

1650: have to run against.
1651: */
1652: FUNCTION get_resource_level_flag_val (p_dim_name IN VARCHAR2,
1653: p_dim_map IN
1654: poa_dbi_util_pkg.poa_dbi_dim_map)
1655: RETURN VARCHAR2
1656: IS
1657:
1658: l_resource_level_flag varchar2(1) := '0';

Line 1774: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map)

1770: determine the aggregation level of the MV rows that the query will
1771: have to run against.
1772: */
1773: FUNCTION get_item_flag_val (p_dim_name VARCHAR2,
1774: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map)
1775: RETURN VARCHAR2
1776: IS
1777:
1778: l_item_flag varchar2(1);

Line 1858: poa_dbi_util_pkg.poa_dbi_dim_map)

1854: have to run against.
1855: */
1856: FUNCTION get_inv_val_aggr_flag (p_dim_name VARCHAR2,
1857: p_dim_map IN
1858: poa_dbi_util_pkg.poa_dbi_dim_map)
1859: RETURN VARCHAR2
1860: IS
1861:
1862: l_item_flag varchar2(1) := NULL;

Line 1932: poa_dbi_util_pkg.poa_dbi_dim_map)

1928: END get_inv_val_aggr_flag;
1929:
1930: FUNCTION get_wms_rtx_aggr_flag(p_dim_name VARCHAR2,
1931: p_dim_map IN
1932: poa_dbi_util_pkg.poa_dbi_dim_map)
1933: RETURN VARCHAR2
1934: IS
1935:
1936: l_item_flag varchar2(1) := NULL;

Line 1984: poa_dbi_util_pkg.poa_dbi_dim_map)

1980:
1981:
1982: FUNCTION get_wms_rtp_aggr_flag(p_dim_name VARCHAR2,
1983: p_dim_map IN
1984: poa_dbi_util_pkg.poa_dbi_dim_map)
1985: RETURN VARCHAR2
1986: IS
1987:
1988: l_item_flag varchar2(1) := NULL;

Line 2054: poa_dbi_util_pkg.poa_dbi_dim_map)

2050: of user selected parameters
2051: */
2052: FUNCTION get_cca_level_flag_val (p_dim_name IN VARCHAR2,
2053: p_dim_map IN
2054: poa_dbi_util_pkg.poa_dbi_dim_map)
2055: RETURN VARCHAR2
2056: IS
2057: -- Aggregation Levels for the various dimensions
2058: ITEM_LEVEL_ID CONSTANT INTEGER := 1;

Line 2187: poa_dbi_util_pkg.poa_dbi_dim_map)

2183: have to run against.
2184: */
2185: FUNCTION get_prodcat_cust_flag_val(p_dim_name IN VARCHAR2,
2186: p_dim_map IN
2187: poa_dbi_util_pkg.poa_dbi_dim_map)
2188: RETURN VARCHAR2
2189: IS
2190:
2191: l_org_val VARCHAR2 (120) := NULL;

Line 2281: poa_dbi_util_pkg.poa_dbi_dim_map)

2277:
2278: /* get_wms_c_utz_item_aggr_flag*/
2279: FUNCTION get_wms_c_utz_item_aggr_flag (p_dim_name VARCHAR2,
2280: p_dim_map IN
2281: poa_dbi_util_pkg.poa_dbi_dim_map)
2282: RETURN VARCHAR2
2283: IS
2284: l_grouping_level NUMBER;
2285:

Line 2353: poa_dbi_util_pkg.poa_dbi_dim_map)

2349:
2350: /* get_wms_c_utz_sub_aggr_flag*/
2351: FUNCTION get_wms_c_utz_sub_aggr_flag (p_dim_name VARCHAR2,
2352: p_dim_map IN
2353: poa_dbi_util_pkg.poa_dbi_dim_map)
2354: RETURN VARCHAR2
2355: IS
2356: l_grouping_level NUMBER;
2357:

Line 2405: poa_dbi_util_pkg.poa_dbi_dim_map)

2401:
2402: /* get_wms_stor_utz_aggr_flag*/
2403: FUNCTION get_wms_stor_utz_aggr_flag (p_dim_name VARCHAR2,
2404: p_dim_map IN
2405: poa_dbi_util_pkg.poa_dbi_dim_map)
2406: RETURN VARCHAR2
2407: IS
2408: l_grouping_level NUMBER;
2409:

Line 2480: poa_dbi_util_pkg.poa_dbi_dim_map)

2476: will run against for any combination of report parameters
2477: */
2478: FUNCTION get_wms_pex_aggr_flag(p_dim_name VARCHAR2,
2479: p_dim_map IN
2480: poa_dbi_util_pkg.poa_dbi_dim_map)
2481: RETURN VARCHAR2
2482: IS
2483: -- Aggregation Levels for the various dimensions
2484: ITEM_LEVEL_ID CONSTANT INTEGER := 1;

Line 2573: poa_dbi_util_pkg.poa_dbi_dim_map)

2569: will run against for any combination of report parameters
2570: */
2571: FUNCTION get_wms_per_aggr_flag(p_dim_name VARCHAR2,
2572: p_dim_map IN
2573: poa_dbi_util_pkg.poa_dbi_dim_map)
2574: RETURN VARCHAR2
2575: IS
2576: -- Aggregation Levels for the various dimensions
2577: REASON_LEVEL_ID CONSTANT INTEGER := 1;

Line 2681: poa_dbi_util_pkg.poa_dbi_dim_map)

2677: will run against for any combination of report parameters
2678: */
2679: FUNCTION get_wms_opp_aggr_flag(p_dim_name VARCHAR2,
2680: p_dim_map IN
2681: poa_dbi_util_pkg.poa_dbi_dim_map)
2682: RETURN VARCHAR2
2683: IS
2684: -- Aggregation Levels for the various dimensions
2685: OP_LEVEL_ID CONSTANT INTEGER := 0;

Line 2790: poa_dbi_util_pkg.poa_dbi_dim_map)

2786: will run against for any combination of report parameters
2787: */
2788: FUNCTION get_wms_oper_aggr_flag(p_dim_name VARCHAR2,
2789: p_dim_map IN
2790: poa_dbi_util_pkg.poa_dbi_dim_map)
2791: RETURN VARCHAR2
2792: IS
2793: -- Aggregation Levels for the various dimensions
2794: REASON_LEVEL_ID CONSTANT INTEGER := 0;

Line 2928: poa_dbi_util_pkg.poa_dbi_dim_map)

2924:
2925: */
2926: FUNCTION get_rollup1_aggr_flag (p_dim_name VARCHAR2,
2927: p_dim_map IN
2928: poa_dbi_util_pkg.poa_dbi_dim_map)
2929: RETURN VARCHAR2
2930: IS
2931: -- {
2932: l_grouping_level NUMBER;

Line 3005: poa_dbi_util_pkg.poa_dbi_dim_map)

3001: will run against for any combination of report parameters
3002: */
3003: FUNCTION get_trx_reason_aggr_flag(p_dim_name VARCHAR2,
3004: p_dim_map IN
3005: poa_dbi_util_pkg.poa_dbi_dim_map)
3006: RETURN VARCHAR2
3007: IS
3008: -- Aggregation Levels for the various dimensions
3009: REASON_LEVEL_ID CONSTANT INTEGER := 1;

Line 3103: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map)

3099: -Inline View.
3100: */
3101:
3102: FUNCTION select_mv (p_mv_set IN VARCHAR2, p_mv_level_flag IN VARCHAR2, p_view_by IN VARCHAR2,
3103: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map)
3104: RETURN VARCHAR2
3105: IS
3106: l_mv VARCHAR2(2000) := '';
3107: l_cat_val VARCHAR2 (120) := NULL;

Line 3501: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

3497: /* Build the fact view by columns string using the join table
3498: for queries using windowing.
3499: */
3500: FUNCTION get_fact_select_columns (p_join_tbl IN
3501: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
3502: RETURN VARCHAR2
3503: IS
3504: l_fact_select_cols VARCHAR2(400);
3505: BEGIN