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

Line 11: p_dim_map IN OUT NOCOPY poa_dbi_util_pkg.poa_dbi_dim_map);

7: p_version IN VARCHAR2,
8: p_role IN VARCHAR2,
9: p_mv_set IN VARCHAR2,
10: p_generate_where_clause IN VARCHAR2,
11: p_dim_map IN OUT NOCOPY poa_dbi_util_pkg.poa_dbi_dim_map);
12:
13: FUNCTION get_bmap(p_dim IN VARCHAR2) RETURN NUMBER;
14:
15: PROCEDURE get_binds(

Line 81: p_join_tbl out NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl,

77: p_cur_suffix out NOCOPY VARCHAR2,
78: p_nested_pattern out NOCOPY NUMBER,
79: p_where_clause out NOCOPY VARCHAR2,
80: p_mv out NOCOPY VARCHAR2,
81: p_join_tbl out NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl,
82: p_in_join_tbl out NOCOPY poa_dbi_util_pkg.poa_dbi_in_join_tbl,
83: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,
84: p_trend in VARCHAR2,
85: p_func_area IN VARCHAR2,

Line 82: p_in_join_tbl out NOCOPY poa_dbi_util_pkg.poa_dbi_in_join_tbl,

78: p_nested_pattern out NOCOPY NUMBER,
79: p_where_clause out NOCOPY VARCHAR2,
80: p_mv out NOCOPY VARCHAR2,
81: p_join_tbl out NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl,
82: p_in_join_tbl out NOCOPY poa_dbi_util_pkg.poa_dbi_in_join_tbl,
83: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,
84: p_trend in VARCHAR2,
85: p_func_area IN VARCHAR2,
86: p_version IN VARCHAR2,

Line 90: l_dim_map poa_dbi_util_pkg.poa_dbi_dim_map;

86: p_version IN VARCHAR2,
87: p_role IN VARCHAR2,
88: p_mv_set IN VARCHAR2)
89: IS
90: l_dim_map poa_dbi_util_pkg.poa_dbi_dim_map;
91: l_dim_bmap NUMBER;
92: l_commodity_value varchar2(10) := null;
93: l_region_code varchar2(30) := null;
94: l_company_value varchar2(30) := 'All';

Line 105: poa_dbi_util_pkg.get_parameter_values(p_param, l_dim_map,p_view_by, p_comparison_type, p_xtd, p_as_of_date, p_prev_as_of_date, p_cur_suffix, p_nested_pattern,l_dim_bmap );

101: l_dim_bmap :=0;
102: l_context_code := get_sec_context(p_param);
103: init_dim_map(l_dim_map, p_func_area, p_version, p_role, p_mv_set);
104:
105: poa_dbi_util_pkg.get_parameter_values(p_param, l_dim_map,p_view_by, p_comparison_type, p_xtd, p_as_of_date, p_prev_as_of_date, p_cur_suffix, p_nested_pattern,l_dim_bmap );
106:
107:
108: --- Begin Spend Analysis Trend change
109: IF(p_mv_set='FIIIV' OR p_mv_set='FIIPA')

Line 121: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap,SUPPLIER_BMAP);

117: ---ENd Spend Analysis Trend change
118:
119: /* add in the security dimensions that must always be present in bmap */
120: IF(l_context_code = 'SUPPLIER') THEN
121: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap,SUPPLIER_BMAP);
122: ELSIF(l_context_code = 'COMP') THEN
123: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap,COMPANY_BMAP);
124: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap,COSTCTR_BMAP);
125: ELSIF(l_context_code = 'OU/COM' OR l_context_code = 'OU' OR l_context_code = 'NEG' OR l_context_code = 'OUX' ) THEN

Line 123: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap,COMPANY_BMAP);

119: /* add in the security dimensions that must always be present in bmap */
120: IF(l_context_code = 'SUPPLIER') THEN
121: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap,SUPPLIER_BMAP);
122: ELSIF(l_context_code = 'COMP') THEN
123: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap,COMPANY_BMAP);
124: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap,COSTCTR_BMAP);
125: ELSIF(l_context_code = 'OU/COM' OR l_context_code = 'OU' OR l_context_code = 'NEG' OR l_context_code = 'OUX' ) THEN
126: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap, OPER_UNIT_BMAP);
127: /* if the role is commodity manager then commodity should be added to bmap*/

Line 124: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap,COSTCTR_BMAP);

120: IF(l_context_code = 'SUPPLIER') THEN
121: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap,SUPPLIER_BMAP);
122: ELSIF(l_context_code = 'COMP') THEN
123: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap,COMPANY_BMAP);
124: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap,COSTCTR_BMAP);
125: ELSIF(l_context_code = 'OU/COM' OR l_context_code = 'OU' OR l_context_code = 'NEG' OR l_context_code = 'OUX' ) THEN
126: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap, OPER_UNIT_BMAP);
127: /* if the role is commodity manager then commodity should be added to bmap*/
128: if (((p_role = 'COM') AND (l_context_code = 'OU/COM'))

Line 126: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap, OPER_UNIT_BMAP);

122: ELSIF(l_context_code = 'COMP') THEN
123: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap,COMPANY_BMAP);
124: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap,COSTCTR_BMAP);
125: ELSIF(l_context_code = 'OU/COM' OR l_context_code = 'OU' OR l_context_code = 'NEG' OR l_context_code = 'OUX' ) THEN
126: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap, OPER_UNIT_BMAP);
127: /* if the role is commodity manager then commodity should be added to bmap*/
128: if (((p_role = 'COM') AND (l_context_code = 'OU/COM'))
129: OR (l_context_code = 'NEG')) then
130: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap, COMMODITY_BMAP);

Line 130: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap, COMMODITY_BMAP);

126: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap, OPER_UNIT_BMAP);
127: /* if the role is commodity manager then commodity should be added to bmap*/
128: if (((p_role = 'COM') AND (l_context_code = 'OU/COM'))
129: OR (l_context_code = 'NEG')) then
130: l_dim_bmap := poa_dbi_util_pkg.bitor(l_dim_bmap, COMMODITY_BMAP);
131: end if;
132: END IF;
133:
134: if(p_mv_set='POD' or p_mv_set='PODCUT') then

Line 205: || poa_dbi_util_pkg.get_where_clauses(l_dim_map, p_trend)

201:
202: p_where_clause := p_where_clause
203: || l_and_agg_col
204: || l_aggregation_level || ' '
205: || poa_dbi_util_pkg.get_where_clauses(l_dim_map, p_trend)
206: || get_in_security_where_clauses(
207: l_dim_map
208: , l_context_code
209: , p_func_area

Line 225: p_in_join_tbl out NOCOPY poa_dbi_util_pkg.poa_dbi_in_join_tbl,

221:
222: PROCEDURE drill_process_parameters(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
223: p_cur_suffix out NOCOPY VARCHAR2,
224: p_where_clause out NOCOPY VARCHAR2,
225: p_in_join_tbl out NOCOPY poa_dbi_util_pkg.poa_dbi_in_join_tbl,
226: p_func_area IN VaRCHAR2,
227: p_version IN VARCHAR2,
228: p_role IN VARCHAR2,
229: p_mv_set IN VARCHAR2)

Line 231: l_dim_map poa_dbi_util_pkg.poa_dbi_dim_map;

227: p_version IN VARCHAR2,
228: p_role IN VARCHAR2,
229: p_mv_set IN VARCHAR2)
230: IS
231: l_dim_map poa_dbi_util_pkg.poa_dbi_dim_map;
232: l_context_code VARCHAR2(10) := 'OU/COM';
233: l_where_clause_unused varchar2(500);
234: BEGIN
235:

Line 240: poa_dbi_util_pkg.get_drill_param_values(p_param, l_dim_map, p_cur_suffix);

236: l_context_code := get_sec_context(p_param);
237:
238: init_dim_map(l_dim_map, p_func_area, p_version, p_role, p_mv_set);
239:
240: poa_dbi_util_pkg.get_drill_param_values(p_param, l_dim_map, p_cur_suffix);
241:
242: p_where_clause :=poa_dbi_util_pkg.get_where_clauses(l_dim_map, 'N')
243: || get_in_security_where_clauses(l_dim_map, l_context_code , p_func_area, p_version, p_role, 'N');
244:

Line 242: p_where_clause :=poa_dbi_util_pkg.get_where_clauses(l_dim_map, 'N')

238: init_dim_map(l_dim_map, p_func_area, p_version, p_role, p_mv_set);
239:
240: poa_dbi_util_pkg.get_drill_param_values(p_param, l_dim_map, p_cur_suffix);
241:
242: p_where_clause :=poa_dbi_util_pkg.get_where_clauses(l_dim_map, 'N')
243: || get_in_security_where_clauses(l_dim_map, l_context_code , p_func_area, p_version, p_role, 'N');
244:
245: /* note that we are passing a dummy to the p_where_clause parameter. The drill report is
246: * expected to provide its own security filters*/

Line 253: FUNCTION get_security_where_clauses(p_dim_map poa_dbi_util_pkg.poa_dbi_dim_map,

249: END;
250:
251: /* OBSOLETE-- No new code should call this. Use
252: get_in_security_where_clauses instead */
253: FUNCTION get_security_where_clauses(p_dim_map poa_dbi_util_pkg.poa_dbi_dim_map,
254: p_func_area in VARCHAR2,
255: p_version in VARCHAR2,
256: p_role in VARCHAR2,
257: p_trend in VARCHAR2 := 'N') return VARCHAR2 IS

Line 263: l_ou_where := poa_dbi_util_pkg.get_ou_sec_where(

259: l_commod_where VARCHAR2(1000);
260: l_ou_where VARCHAR2(1000);
261: BEGIN
262:
263: l_ou_where := poa_dbi_util_pkg.get_ou_sec_where(
264: p_dim_map('ORGANIZATION+FII_OPERATING_UNITS').value,
265: p_dim_map('ORGANIZATION+FII_OPERATING_UNITS').col_name,
266: p_trend);
267: if(l_ou_where is not null) then

Line 272: l_commod_where := poa_dbi_util_pkg.get_commodity_sec_where(

268: l_sec_where_clause := l_sec_where_clause || ' and ' || l_ou_where;
269: end if;
270:
271: if(p_version = '6.0') then
272: l_commod_where := poa_dbi_util_pkg.get_commodity_sec_where(
273: p_dim_map('ITEM+POA_COMMODITIES').value,
274: p_trend);
275: if(l_commod_where is not null ) then
276: l_sec_where_clause := l_sec_where_clause || ' and ' || l_commod_where;

Line 283: FUNCTION get_in_security_where_clauses(p_dim_map poa_dbi_util_pkg.poa_dbi_dim_map,

279:
280: return l_sec_where_clause;
281: END;
282:
283: FUNCTION get_in_security_where_clauses(p_dim_map poa_dbi_util_pkg.poa_dbi_dim_map,
284: p_context_code in VARCHAR2,
285: p_func_area in VARCHAR2,
286: p_version in VARCHAR2,
287: p_role in VARCHAR2,

Line 296: l_ou_where := poa_dbi_util_pkg.get_in_ou_sec_where(

292: l_ou_where VARCHAR2(1000) := '';
293: BEGIN
294: IF(p_context_code = 'OU/COM' or p_context_code ='OU' or p_context_code = 'NEG'
295: OR p_context_code = 'OUX' ) THEN
296: l_ou_where := poa_dbi_util_pkg.get_in_ou_sec_where(
297: p_dim_map('ORGANIZATION+FII_OPERATING_UNITS').value,
298: p_dim_map('ORGANIZATION+FII_OPERATING_UNITS').col_name,
299: p_use_bind => 'N');
300: if(l_ou_where is not null) then

Line 305: l_commod_where := poa_dbi_util_pkg.get_in_commodity_sec_where(

301: l_in_sec_where_clause := l_ou_where;
302: end if;
303: IF(p_context_code = 'OU/COM' or p_context_code = 'NEG') THEN
304: if(p_version = '6.0' or p_version = '7.0' or p_version = '8.0') then
305: l_commod_where := poa_dbi_util_pkg.get_in_commodity_sec_where(
306: p_dim_map('ITEM+POA_COMMODITIES').value,
307: p_trend);
308: if(l_commod_where is not null ) then
309: l_in_sec_where_clause := l_in_sec_where_clause || l_commod_where;

Line 314: l_sup_where := poa_dbi_util_pkg.get_in_supplier_sec_where(p_dim_map('SUPPLIER+POA_SUPPLIERS').value);

310: end if;
311: end if;
312: END IF;
313: ELSIF(p_context_code='SUPPLIER') THEN
314: l_sup_where := poa_dbi_util_pkg.get_in_supplier_sec_where(p_dim_map('SUPPLIER+POA_SUPPLIERS').value);
315: IF(l_sup_where IS NOT NULL) THEN
316: l_in_sec_where_clause := l_in_sec_where_clause || l_sup_where;
317: END IF;
318: END IF;

Line 329: p_dim_map IN OUT NOCOPY poa_dbi_util_pkg.poa_dbi_dim_map) IS

325: p_version IN VARCHAR2,
326: p_role IN VARCHAR2,
327: p_mv_set IN VARCHAR2,
328: p_generate_where_clause IN VARCHAR2,
329: p_dim_map IN OUT NOCOPY poa_dbi_util_pkg.poa_dbi_dim_map) IS
330:
331: l_dim_rec poa_dbi_util_pkg.poa_dbi_dim_rec;
332:
333: BEGIN

Line 331: l_dim_rec poa_dbi_util_pkg.poa_dbi_dim_rec;

327: p_mv_set IN VARCHAR2,
328: p_generate_where_clause IN VARCHAR2,
329: p_dim_map IN OUT NOCOPY poa_dbi_util_pkg.poa_dbi_dim_map) IS
330:
331: l_dim_rec poa_dbi_util_pkg.poa_dbi_dim_rec;
332:
333: BEGIN
334: l_dim_rec.col_name := get_col_name(p_dim,p_func_area, p_version, p_mv_set);
335: l_dim_rec.view_by_table := get_table(p_dim, p_func_area, p_version);

Line 342: PROCEDURE init_dim_map(p_dim_map out NOCOPY poa_dbi_util_pkg.poa_dbi_dim_map,

338: p_dim_map(p_dim) := l_dim_rec;
339: END;
340:
341:
342: PROCEDURE init_dim_map(p_dim_map out NOCOPY poa_dbi_util_pkg.poa_dbi_dim_map,
343: p_func_area IN VARCHAR2,
344: p_version IN VARCHAR2,
345: p_role IN VARCHAR2,
346: p_mv_set IN VARCHAR2) IS

Line 348: l_dim_rec poa_dbi_util_pkg.poa_dbi_dim_rec;

344: p_version IN VARCHAR2,
345: p_role IN VARCHAR2,
346: p_mv_set IN VARCHAR2) IS
347:
348: l_dim_rec poa_dbi_util_pkg.poa_dbi_dim_rec;
349:
350: BEGIN
351:
352: add_dimension('HRI_PERSON+HRI_PER',

Line 580: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map,

576:
577:
578:
579: PROCEDURE get_join_info(p_view_by IN varchar2,
580: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map,
581: x_join_tbl OUT NOCOPY poa_dbi_util_pkg.POA_DBI_JOIN_TBL,
582: p_func_area IN varchar2, p_version IN varchar2)
583: IS
584: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;

Line 581: x_join_tbl OUT NOCOPY poa_dbi_util_pkg.POA_DBI_JOIN_TBL,

577:
578:
579: PROCEDURE get_join_info(p_view_by IN varchar2,
580: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map,
581: x_join_tbl OUT NOCOPY poa_dbi_util_pkg.POA_DBI_JOIN_TBL,
582: p_func_area IN varchar2, p_version IN varchar2)
583: IS
584: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
585:

Line 584: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;

580: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map,
581: x_join_tbl OUT NOCOPY poa_dbi_util_pkg.POA_DBI_JOIN_TBL,
582: p_func_area IN varchar2, p_version IN varchar2)
583: IS
584: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
585:
586: BEGIN
587: x_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
588: if(NOT p_dim_map.exists(p_view_by)) then

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

583: IS
584: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
585:
586: BEGIN
587: x_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
588: if(NOT p_dim_map.exists(p_view_by)) then
589: return;
590: end if;
591:

Line 653: p_in_join_tbl out NOCOPY poa_dbi_util_pkg.poa_dbi_in_join_tbl

649: END;
650:
651:
652: PROCEDURE populate_in_join_tbl(
653: p_in_join_tbl out NOCOPY poa_dbi_util_pkg.poa_dbi_in_join_tbl
654: , p_param in BIS_PMV_PAGE_PARAMETER_TBL
655: , p_dim_map in poa_dbi_util_pkg.poa_dbi_dim_map
656: , p_context_code VARCHAR2
657: , p_version in VARCHAR2

Line 655: , p_dim_map in poa_dbi_util_pkg.poa_dbi_dim_map

651:
652: PROCEDURE populate_in_join_tbl(
653: p_in_join_tbl out NOCOPY poa_dbi_util_pkg.poa_dbi_in_join_tbl
654: , p_param in BIS_PMV_PAGE_PARAMETER_TBL
655: , p_dim_map in poa_dbi_util_pkg.poa_dbi_dim_map
656: , p_context_code VARCHAR2
657: , p_version in VARCHAR2
658: , p_mv_set in varchar2
659: , p_where_clause in out nocopy varchar2)

Line 663: l_in_join_rec poa_dbi_util_pkg.POA_DBI_IN_JOIN_REC;

659: , p_where_clause in out nocopy varchar2)
660: IS
661: l_ou_value VARCHAR2(10);
662: l_commodity_value VARCHAR2(10);
663: l_in_join_rec poa_dbi_util_pkg.POA_DBI_IN_JOIN_REC;
664: l_company_value varchar2(30) := 'All';
665: l_cost_ctr_value varchar2(30) := 'All';
666: l_region_code varchar2(40);
667: l_viewby varchar2(50);

Line 672: p_in_join_tbl := poa_dbi_util_pkg.poa_dbi_in_join_tbl();

668: l_sql varchar2(2000);
669: l_agg_flag varchar2(1);
670: BEGIN
671:
672: p_in_join_tbl := poa_dbi_util_pkg.poa_dbi_in_join_tbl();
673:
674: IF(p_context_code = 'OU/COM' or p_context_code = 'OU' or p_context_code = 'NEG'
675: OR p_context_code = 'OUX'
676: ) THEN

Line 1199: poa_dbi_util_pkg.get_custom_trend_binds(p_xtd, p_comparison_type,x_custom_output);

1195: l_custom_rec BIS_QUERY_ATTRIBUTES;
1196: BEGIN
1197: /* special case for PQC Cumulative trend, which cannot have the normal trend binds */
1198: if(p_trend = 'Y' and p_mv_set <> 'PQC') then
1199: poa_dbi_util_pkg.get_custom_trend_binds(p_xtd, p_comparison_type,x_custom_output);
1200: else
1201: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);
1202: end if;
1203:

Line 1201: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);

1197: /* special case for PQC Cumulative trend, which cannot have the normal trend binds */
1198: if(p_trend = 'Y' and p_mv_set <> 'PQC') then
1199: poa_dbi_util_pkg.get_custom_trend_binds(p_xtd, p_comparison_type,x_custom_output);
1200: else
1201: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);
1202: end if;
1203:
1204: if(p_xtd like 'RL%') then
1205: poa_dbi_util_pkg.get_custom_rolling_binds(x_custom_output, p_xtd);

Line 1205: poa_dbi_util_pkg.get_custom_rolling_binds(x_custom_output, p_xtd);

1201: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);
1202: end if;
1203:
1204: if(p_xtd like 'RL%') then
1205: poa_dbi_util_pkg.get_custom_rolling_binds(x_custom_output, p_xtd);
1206: end if;
1207:
1208: if(p_mv_set = 'REQS') then
1209: bind_reqfact_date(x_custom_output);

Line 1568: l_sec_profile_id := poa_dbi_util_pkg.get_sec_profile ;

1564: if(p_context_code = 'SUPPLIER' or p_context_code = 'COMP') then
1565: return '1';
1566: end if;
1567: ---Begin changes for MOAC
1568: l_sec_profile_id := poa_dbi_util_pkg.get_sec_profile ;
1569: ---End changes for MOAC
1570:
1571: -- for OU Secured dashboards
1572: l_exists := 0;

Line 1589: AND v.id = poa_dbi_util_pkg.get_ou_org_id ;

1585: SELECT COUNT(*)
1586: INTO l_exists
1587: FROM fii_operating_units_v v
1588: WHERE v.id = p_ou_id
1589: AND v.id = poa_dbi_util_pkg.get_ou_org_id ;
1590: END IF ;
1591: ---End changes for MOAC
1592:
1593: if(l_exists = 0) then