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_PQC_PKG dependencies on POA_DBI_UTIL_PKG

Line 32: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

28: l_xtd varchar2(10);
29: l_comparison_type varchar2(1) := 'Y';
30: l_nested_pattern number;
31: l_cur_suffix varchar2(2);
32: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
33: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
34: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
35: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
36: l_where_clause varchar2(2000);

Line 33: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

29: l_comparison_type varchar2(1) := 'Y';
30: l_nested_pattern number;
31: l_cur_suffix varchar2(2);
32: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
33: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
34: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
35: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
36: l_where_clause varchar2(2000);
37: l_where_clause2 varchar2(2000);

Line 34: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;

30: l_nested_pattern number;
31: l_cur_suffix varchar2(2);
32: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
33: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
34: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
35: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
36: l_where_clause varchar2(2000);
37: l_where_clause2 varchar2(2000);
38: l_view_by_value varchar2(100);

Line 35: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;

31: l_cur_suffix varchar2(2);
32: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
33: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
34: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
35: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
36: l_where_clause varchar2(2000);
37: l_where_clause2 varchar2(2000);
38: l_view_by_value varchar2(100);
39: l_mv varchar2(30);

Line 46: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

42: l_prev_asof_year date;
43: l_url varchar2(300);
44: l_sec_context varchar2(10);
45: l_use_only_agg_mv varchar2(1);
46: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
47: BEGIN
48: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
49: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
50:

Line 48: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

44: l_sec_context varchar2(10);
45: l_use_only_agg_mv varchar2(1);
46: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
47: BEGIN
48: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
49: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
50:
51: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
52: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then

Line 49: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

45: l_use_only_agg_mv varchar2(1);
46: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
47: BEGIN
48: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
49: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
50:
51: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
52: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
53: poa_dbi_sutil_pkg.process_parameters(

Line 75: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbpcqco_amt_' || l_cur_suffix, 'benchmark_amt');

71: p_version => '6.0',
72: p_role => 'COM',
73: p_mv_set => 'PQC');
74:
75: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbpcqco_amt_' || l_cur_suffix, 'benchmark_amt');
76: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbcqco_amt_' || l_cur_suffix, 'fallback_amt');
77: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt');
78:
79: if(l_view_by = 'ITEM+POA_ITEMS') then

Line 76: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbcqco_amt_' || l_cur_suffix, 'fallback_amt');

72: p_role => 'COM',
73: p_mv_set => 'PQC');
74:
75: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbpcqco_amt_' || l_cur_suffix, 'benchmark_amt');
76: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbcqco_amt_' || l_cur_suffix, 'fallback_amt');
77: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt');
78:
79: if(l_view_by = 'ITEM+POA_ITEMS') then
80: poa_dbi_util_pkg.add_column(l_col_tbl, 'quantity', 'quantity');

Line 77: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt');

73: p_mv_set => 'PQC');
74:
75: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbpcqco_amt_' || l_cur_suffix, 'benchmark_amt');
76: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbcqco_amt_' || l_cur_suffix, 'fallback_amt');
77: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt');
78:
79: if(l_view_by = 'ITEM+POA_ITEMS') then
80: poa_dbi_util_pkg.add_column(l_col_tbl, 'quantity', 'quantity');
81: end if;

Line 80: poa_dbi_util_pkg.add_column(l_col_tbl, 'quantity', 'quantity');

76: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbcqco_amt_' || l_cur_suffix, 'fallback_amt');
77: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt');
78:
79: if(l_view_by = 'ITEM+POA_ITEMS') then
80: poa_dbi_util_pkg.add_column(l_col_tbl, 'quantity', 'quantity');
81: end if;
82:
83: if((l_view_by = 'SUPPLIER+POA_SUPPLIERS') and (l_view_by_value is not null) and (instr(l_view_by_value,',') = 0)) then
84: l_url := null;

Line 168: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbpcqco_amt_' || l_cur_suffix, 'benchmark_amt');

164: p_version => '8.0',
165: p_role => 'COM',
166: p_mv_set => 'PQCB');
167: end if;
168: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbpcqco_amt_' || l_cur_suffix, 'benchmark_amt');
169: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbcqco_amt_' || l_cur_suffix, 'fallback_amt');
170: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt');
171:
172: if(l_view_by = 'ITEM+POA_ITEMS') then

Line 169: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbcqco_amt_' || l_cur_suffix, 'fallback_amt');

165: p_role => 'COM',
166: p_mv_set => 'PQCB');
167: end if;
168: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbpcqco_amt_' || l_cur_suffix, 'benchmark_amt');
169: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbcqco_amt_' || l_cur_suffix, 'fallback_amt');
170: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt');
171:
172: if(l_view_by = 'ITEM+POA_ITEMS') then
173: poa_dbi_util_pkg.add_column(l_col_tbl, 'quantity', 'quantity');

Line 170: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt');

166: p_mv_set => 'PQCB');
167: end if;
168: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbpcqco_amt_' || l_cur_suffix, 'benchmark_amt');
169: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbcqco_amt_' || l_cur_suffix, 'fallback_amt');
170: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt');
171:
172: if(l_view_by = 'ITEM+POA_ITEMS') then
173: poa_dbi_util_pkg.add_column(l_col_tbl, 'quantity', 'quantity');
174: end if;

Line 173: poa_dbi_util_pkg.add_column(l_col_tbl, 'quantity', 'quantity');

169: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbcqco_amt_' || l_cur_suffix, 'fallback_amt');
170: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt');
171:
172: if(l_view_by = 'ITEM+POA_ITEMS') then
173: poa_dbi_util_pkg.add_column(l_col_tbl, 'quantity', 'quantity');
174: end if;
175:
176: if((l_view_by = 'SUPPLIER+POA_SUPPLIERS') and (l_view_by_value is not null) and (instr(l_view_by_value,',') = 0)) then
177: l_url := null;

Line 190: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl();

186: l_asof_year := fii_time_api.ent_cyr_start(l_as_of_date);
187: l_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_as_of_date);
188:
189: if(l_use_only_agg_mv = 'N') then
190: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl();
191: l_mv_tbl.extend;
192: l_mv_tbl(1).mv_name := l_mv;
193: l_mv_tbl(1).mv_col := l_col_tbl;
194: l_mv_tbl(1).mv_where := l_where_clause;

Line 374: ' || poa_dbi_util_pkg.rate_clause('c_benchmark_amt','c_amt') || '-100 POA_MEASURE2,

370:
371: IF (p_sameyear = 0) then
372: l_sel_clause := l_sel_clause || '
373: nvl(c_benchmark_amt,0) - nvl(c_amt,0) POA_MEASURE1,
374: ' || poa_dbi_util_pkg.rate_clause('c_benchmark_amt','c_amt') || '-100 POA_MEASURE2,
375: nvl(c_amt,0) POA_MEASURE3,
376: nvl(c_benchmark_amt,0) POA_MEASURE4,
377: nvl(p_benchmark_amt,0) POA_MEASURE5,
378: Nvl(c_benchmark_amt,0) - Nvl(p_benchmark_amt, 0) POA_MEASURE6,

Line 381: ' || poa_dbi_util_pkg.rate_clause('c_benchmark_amt_total','c_amt_total') || '-100 POA_MEASURE8,

377: nvl(p_benchmark_amt,0) POA_MEASURE5,
378: Nvl(c_benchmark_amt,0) - Nvl(p_benchmark_amt, 0) POA_MEASURE6,
379: Nvl(c_benchmark_amt,0) - Nvl(p_benchmark_amt, 0) POA_MEASURE17,
380: nvl(c_benchmark_amt_total,0) - nvl(c_amt_total,0) POA_MEASURE7,
381: ' || poa_dbi_util_pkg.rate_clause('c_benchmark_amt_total','c_amt_total') || '-100 POA_MEASURE8,
382: nvl(c_amt_total,0) poa_measure9,
383: nvl(c_benchmark_amt_total,0) POA_MEASURE10,
384: nvl(p_benchmark_amt_total,0) POA_MEASURE11,
385: nvl(c_benchmark_amt_total,0) - Nvl(p_benchmark_amt_total, 0) POA_MEASURE12

Line 390: ' || poa_dbi_util_pkg.rate_clause('c_benchmark_amt','c_amt') || '-100 POA_MEASURE2,

386: ';
387: ELSE
388: l_sel_clause := l_sel_clause || '
389: nvl(c_benchmark_amt,0) - nvl(c_amt,0) POA_MEASURE1,
390: ' || poa_dbi_util_pkg.rate_clause('c_benchmark_amt','c_amt') || '-100 POA_MEASURE2,
391: nvl(c_amt,0) POA_MEASURE3,
392: nvl(c_benchmark_amt,0) POA_MEASURE4,
393: nvl(p_fallback_amt,0) POA_MEASURE5,
394: nvl(c_benchmark_amt,0) - Nvl(p_fallback_amt, 0) POA_MEASURE6,

Line 397: ' || poa_dbi_util_pkg.rate_clause('c_benchmark_amt_total','c_amt_total') || '-100 POA_MEASURE8,

393: nvl(p_fallback_amt,0) POA_MEASURE5,
394: nvl(c_benchmark_amt,0) - Nvl(p_fallback_amt, 0) POA_MEASURE6,
395: nvl(c_benchmark_amt,0) - Nvl(p_fallback_amt, 0) POA_MEASURE17,
396: nvl(c_benchmark_amt_total,0) - nvl(c_amt_total,0) POA_MEASURE7,
397: ' || poa_dbi_util_pkg.rate_clause('c_benchmark_amt_total','c_amt_total') || '-100 POA_MEASURE8,
398: nvl(c_amt_total,0) poa_measure9,
399: nvl(c_benchmark_amt_total,0) POA_MEASURE10,
400: nvl(p_fallback_amt_total,0) POA_MEASURE11,
401: nvl(c_benchmark_amt_total,0) - Nvl(p_fallback_amt_total, 0) POA_MEASURE12

Line 431: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

427: l_where_clause2 varchar2(2000);
428: l_comparison_type varchar2(1) := 'Y';
429: l_nested_pattern number;
430: l_cur_suffix varchar2(2);
431: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
432: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
433: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
434: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
435: l_custom_rec bis_query_attributes;

Line 432: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

428: l_comparison_type varchar2(1) := 'Y';
429: l_nested_pattern number;
430: l_cur_suffix varchar2(2);
431: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
432: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
433: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
434: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
435: l_custom_rec bis_query_attributes;
436: l_sec_context varchar2(10);

Line 433: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;

429: l_nested_pattern number;
430: l_cur_suffix varchar2(2);
431: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
432: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
433: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
434: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
435: l_custom_rec bis_query_attributes;
436: l_sec_context varchar2(10);
437: l_use_only_agg_mv varchar2(1);

Line 434: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;

430: l_cur_suffix varchar2(2);
431: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
432: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
433: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
434: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
435: l_custom_rec bis_query_attributes;
436: l_sec_context varchar2(10);
437: l_use_only_agg_mv varchar2(1);
438: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

Line 438: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

434: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
435: l_custom_rec bis_query_attributes;
436: l_sec_context varchar2(10);
437: l_use_only_agg_mv varchar2(1);
438: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
439: begin
440: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
441: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
442: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

Line 440: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

436: l_sec_context varchar2(10);
437: l_use_only_agg_mv varchar2(1);
438: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
439: begin
440: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
441: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
442: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
443:
444: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);

Line 441: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

437: l_use_only_agg_mv varchar2(1);
438: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
439: begin
440: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
441: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
442: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
443:
444: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
445: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then

Line 468: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbpcqco_amt_' || l_cur_suffix, 'benchmark_amt','Y',poa_dbi_util_pkg.PREV_PREV);

464: p_version => '6.0',
465: p_role => 'COM',
466: p_mv_set => 'PQC');
467:
468: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbpcqco_amt_' || l_cur_suffix, 'benchmark_amt','Y',poa_dbi_util_pkg.PREV_PREV);
469: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbcqco_amt_' || l_cur_suffix, 'fallback_amt','Y',poa_dbi_util_pkg.PREV_PREV);
470: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt','Y');
471:
472: l_prev_prev_as_of_date := poa_dbi_calendar_pkg.previous_period_asof_date(l_prev_as_of_date, l_xtd, l_comparison_type);

Line 469: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbcqco_amt_' || l_cur_suffix, 'fallback_amt','Y',poa_dbi_util_pkg.PREV_PREV);

465: p_role => 'COM',
466: p_mv_set => 'PQC');
467:
468: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbpcqco_amt_' || l_cur_suffix, 'benchmark_amt','Y',poa_dbi_util_pkg.PREV_PREV);
469: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbcqco_amt_' || l_cur_suffix, 'fallback_amt','Y',poa_dbi_util_pkg.PREV_PREV);
470: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt','Y');
471:
472: l_prev_prev_as_of_date := poa_dbi_calendar_pkg.previous_period_asof_date(l_prev_as_of_date, l_xtd, l_comparison_type);
473:

Line 470: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt','Y');

466: p_mv_set => 'PQC');
467:
468: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbpcqco_amt_' || l_cur_suffix, 'benchmark_amt','Y',poa_dbi_util_pkg.PREV_PREV);
469: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbcqco_amt_' || l_cur_suffix, 'fallback_amt','Y',poa_dbi_util_pkg.PREV_PREV);
470: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt','Y');
471:
472: l_prev_prev_as_of_date := poa_dbi_calendar_pkg.previous_period_asof_date(l_prev_as_of_date, l_xtd, l_comparison_type);
473:
474: l_asof_year := fii_time_api.ent_cyr_start(l_as_of_date);

Line 526: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbpcqco_amt_' || l_cur_suffix, 'benchmark_amt','Y',poa_dbi_util_pkg.PREV_PREV);

522: p_version => '8.0',
523: p_role => 'COM',
524: p_mv_set => 'PQCA');
525:
526: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbpcqco_amt_' || l_cur_suffix, 'benchmark_amt','Y',poa_dbi_util_pkg.PREV_PREV);
527: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbcqco_amt_' || l_cur_suffix, 'fallback_amt','Y',poa_dbi_util_pkg.PREV_PREV);
528: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt','Y');
529:
530: l_prev_prev_as_of_date := poa_dbi_calendar_pkg.previous_period_asof_date(l_prev_as_of_date, l_xtd, l_comparison_type);

Line 527: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbcqco_amt_' || l_cur_suffix, 'fallback_amt','Y',poa_dbi_util_pkg.PREV_PREV);

523: p_role => 'COM',
524: p_mv_set => 'PQCA');
525:
526: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbpcqco_amt_' || l_cur_suffix, 'benchmark_amt','Y',poa_dbi_util_pkg.PREV_PREV);
527: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbcqco_amt_' || l_cur_suffix, 'fallback_amt','Y',poa_dbi_util_pkg.PREV_PREV);
528: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt','Y');
529:
530: l_prev_prev_as_of_date := poa_dbi_calendar_pkg.previous_period_asof_date(l_prev_as_of_date, l_xtd, l_comparison_type);
531:

Line 528: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt','Y');

524: p_mv_set => 'PQCA');
525:
526: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbpcqco_amt_' || l_cur_suffix, 'benchmark_amt','Y',poa_dbi_util_pkg.PREV_PREV);
527: poa_dbi_util_pkg.add_column(l_col_tbl, 'pbcqco_amt_' || l_cur_suffix, 'fallback_amt','Y',poa_dbi_util_pkg.PREV_PREV);
528: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt','Y');
529:
530: l_prev_prev_as_of_date := poa_dbi_calendar_pkg.previous_period_asof_date(l_prev_as_of_date, l_xtd, l_comparison_type);
531:
532: l_asof_year := fii_time_api.ent_cyr_start(l_as_of_date);

Line 569: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl();

565: p_version => '8.0',
566: p_role => 'COM',
567: p_mv_set => 'PQCB');
568:
569: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl();
570: l_mv_tbl.extend;
571: l_mv_tbl(1).mv_name := l_mv;
572: l_mv_tbl(1).mv_col := l_col_tbl;
573: l_mv_tbl(1).mv_where := l_where_clause;

Line 804: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

800: IS
801: l_query varchar2(8000);
802: l_cur_suffix varchar2(2);
803: l_where_clause varchar2(2000);
804: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
805: l_in_join_tables VARCHAR2(1000) := '';
806: l_filter_where VARCHAR2(1000);
807: l_sec_context varchar2(10);
808: BEGIN

Line 947: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);

943: and (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)
944: ORDER BY rnk';
945:
946: x_custom_sql := l_query;
947: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);
948: if(l_sec_context = 'COMP')then
949: poa_dbi_sutil_pkg.bind_com_cc_values(x_custom_output, p_param);
950: end if;
951: end;

Line 967: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

963: l_xtd varchar2(10);
964: l_comparison_type varchar2(1) := 'Y';
965: l_nested_pattern number;
966: l_cur_suffix varchar2(2);
967: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
968: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
969: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
970: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
971: l_mv varchar2(30);

Line 968: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

964: l_comparison_type varchar2(1) := 'Y';
965: l_nested_pattern number;
966: l_cur_suffix varchar2(2);
967: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
968: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
969: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
970: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
971: l_mv varchar2(30);
972: l_mv2 varchar2(30);

Line 969: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;

965: l_nested_pattern number;
966: l_cur_suffix varchar2(2);
967: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
968: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
969: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
970: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
971: l_mv varchar2(30);
972: l_mv2 varchar2(30);
973: l_where_clause varchar2(2000);

Line 970: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;

966: l_cur_suffix varchar2(2);
967: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
968: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
969: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
970: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
971: l_mv varchar2(30);
972: l_mv2 varchar2(30);
973: l_where_clause varchar2(2000);
974: l_where_clause2 varchar2(2000);

Line 1001: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();

997: /* sets up calls to ("fii_msg.get_curr_label") for col labels */
998: /*fii_gl_util_pkg.reset_globals;*/
999: poa_dbi_sutil_pkg.get_parameters(p_param);
1000:
1001: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1002: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1003:
1004: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
1005: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then

Line 1002: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();

998: /*fii_gl_util_pkg.reset_globals;*/
999: poa_dbi_sutil_pkg.get_parameters(p_param);
1000:
1001: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1002: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1003:
1004: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
1005: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
1006: poa_dbi_sutil_pkg.process_parameters(

Line 1470: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_user_profile;

1466: x_custom_output.EXTEND;
1467: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1468:
1469: l_custom_rec.attribute_name := '&FND_USER_ID';
1470: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_user_profile;
1471: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1472: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1473: x_custom_output.EXTEND;
1474: x_custom_output(x_custom_output.COUNT) := l_custom_rec;