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

Line 71: -- l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

67: l_where_clause1 VARCHAR2 (2000);
68: l_where_clause2 VARCHAR2 (2000);
69: l_filter_where VARCHAR2 (340);
70: l_mv VARCHAR2 (2000);
71: -- l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
72: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
73: l_to_date_xed VARCHAR2 (3) ;
74: l_to_date_xtd VARCHAR2 (3);
75: l_to_date_ytd VARCHAR2 (3);

Line 72: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

68: l_where_clause2 VARCHAR2 (2000);
69: l_filter_where VARCHAR2 (340);
70: l_mv VARCHAR2 (2000);
71: -- l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
72: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
73: l_to_date_xed VARCHAR2 (3) ;
74: l_to_date_xtd VARCHAR2 (3);
75: l_to_date_ytd VARCHAR2 (3);
76: l_to_date_itd VARCHAR2 (3);

Line 79: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;

75: l_to_date_ytd VARCHAR2 (3);
76: l_to_date_itd VARCHAR2 (3);
77: l_mv1 VARCHAR2(100);
78: l_mv2 VARCHAR2(100);
79: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
80: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
81: l_xtd1 VARCHAR2(10);
82: l_xtd2 VARCHAR2(10);
83: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

Line 80: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;

76: l_to_date_itd VARCHAR2 (3);
77: l_mv1 VARCHAR2(100);
78: l_mv2 VARCHAR2(100);
79: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
80: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
81: l_xtd1 VARCHAR2(10);
82: l_xtd2 VARCHAR2(10);
83: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
84:

Line 83: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

79: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
80: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
81: l_xtd1 VARCHAR2(10);
82: l_xtd2 VARCHAR2(10);
83: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
84:
85: BEGIN
86: l_to_date_xed := 'XED';
87: l_to_date_xtd := 'XTD';

Line 92: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();

88: l_to_date_ytd := 'YTD';
89: l_to_date_itd := 'ITD';
90: l_comparison_type := 'Y';
91:
92: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
93: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
94: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
95: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
96: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

Line 93: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();

89: l_to_date_itd := 'ITD';
90: l_comparison_type := 'Y';
91:
92: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
93: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
94: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
95: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
96: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
97: , p_view_by => l_view_by

Line 94: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();

90: l_comparison_type := 'Y';
91:
92: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
93: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
94: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
95: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
96: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
97: , p_view_by => l_view_by
98: , p_view_by_col_name => l_view_by_col

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

91:
92: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
93: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
94: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
95: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
96: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
97: , p_view_by => l_view_by
98: , p_view_by_col_name => l_view_by_col
99: , p_comparison_type => l_comparison_type

Line 119: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

115:
116:
117: -- Populate col table with regular columns
118: -- Period Renewal node
119: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
120: , p_col_name => 'g_r_amt_' || l_cur_suffix
121: , p_alias_name => 'Gr'
122: , p_to_date_type => l_to_date_xtd);
123:

Line 124: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

120: , p_col_name => 'g_r_amt_' || l_cur_suffix
121: , p_alias_name => 'Gr'
122: , p_to_date_type => l_to_date_xtd);
123:
124: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
125: , p_col_name => 'g_o_amt_' || l_cur_suffix
126: , p_alias_name => 'Go'
127: , p_to_date_type => l_to_date_xtd);
128:

Line 149: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2

145: , p_version => '6.0'
146: , p_role => NULL
147: , p_mv_set => 'SRM_EC_71'
148: , p_rg_where => 'Y');
149: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
150: , p_col_name => 'f_f_amt_' || l_cur_suffix
151: , p_alias_name => 'Fcf'
152: , p_to_date_type => l_to_date_xed
153: , p_prior_code => poa_dbi_util_pkg.no_priors);

Line 153: , p_prior_code => poa_dbi_util_pkg.no_priors);

149: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
150: , p_col_name => 'f_f_amt_' || l_cur_suffix
151: , p_alias_name => 'Fcf'
152: , p_to_date_type => l_to_date_xed
153: , p_prior_code => poa_dbi_util_pkg.no_priors);
154:
155: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
156: , p_col_name => 'f_r_amt_' || l_cur_suffix
157: , p_alias_name => 'Fcr'

Line 155: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2

151: , p_alias_name => 'Fcf'
152: , p_to_date_type => l_to_date_xed
153: , p_prior_code => poa_dbi_util_pkg.no_priors);
154:
155: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
156: , p_col_name => 'f_r_amt_' || l_cur_suffix
157: , p_alias_name => 'Fcr'
158: , p_to_date_type => l_to_date_xed
159: , p_prior_code => poa_dbi_util_pkg.no_priors);

Line 159: , p_prior_code => poa_dbi_util_pkg.no_priors);

155: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
156: , p_col_name => 'f_r_amt_' || l_cur_suffix
157: , p_alias_name => 'Fcr'
158: , p_to_date_type => l_to_date_xed
159: , p_prior_code => poa_dbi_util_pkg.no_priors);
160:
161: l_mv_tbl.extend;
162: l_mv_tbl(1).mv_name := l_mv1;
163: l_mv_tbl(1).mv_col := l_col_tbl1;

Line 412: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

408: l_nested_pattern NUMBER;
409: l_cur_suffix VARCHAR2 (2);
410: l_where_clause VARCHAR2 (2000);
411: l_mv VARCHAR2 (2000);
412: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
413: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
414: l_to_date_xed VARCHAR2 (3);
415: l_to_date_xtd VARCHAR2 (3);
416:

Line 413: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

409: l_cur_suffix VARCHAR2 (2);
410: l_where_clause VARCHAR2 (2000);
411: l_mv VARCHAR2 (2000);
412: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
413: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
414: l_to_date_xed VARCHAR2 (3);
415: l_to_date_xtd VARCHAR2 (3);
416:
417: l_rpt_specific_where VARCHAR2 (1000);

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

425:
426: l_to_date_xed := 'XED';
427: l_to_date_xtd := 'XTD';
428: l_comparison_type := 'Y';
429: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
430: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
431:
432: oki_dbi_util_pvt.process_parameters ( p_param => p_param
433: , p_view_by => l_view_by

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

426: l_to_date_xed := 'XED';
427: l_to_date_xtd := 'XTD';
428: l_comparison_type := 'Y';
429: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
430: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
431:
432: oki_dbi_util_pvt.process_parameters ( p_param => p_param
433: , p_view_by => l_view_by
434: , p_view_by_col_name => l_view_by_col

Line 459: poa_dbi_util_pkg.add_column ( p_col_tbl => l_col_tbl

455: and &BIS_CURRENT_ASOF_DATE';
456:
457: l_group_by := ' GROUP BY fact.chr_id, fact.customer_party_id, fact.resource_id , fact.date_signed';
458:
459: poa_dbi_util_pkg.add_column ( p_col_tbl => l_col_tbl
460: , p_col_name => 'price_negotiated_' || l_cur_suffix
461: , p_alias_name => 'affected_value'
462: , p_prior_code => poa_dbi_util_pkg.no_priors);
463:

Line 462: , p_prior_code => poa_dbi_util_pkg.no_priors);

458:
459: poa_dbi_util_pkg.add_column ( p_col_tbl => l_col_tbl
460: , p_col_name => 'price_negotiated_' || l_cur_suffix
461: , p_alias_name => 'affected_value'
462: , p_prior_code => poa_dbi_util_pkg.no_priors);
463:
464: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
465:
466: oki_dbi_util_pvt.join_rpt_where ( p_join_tbl => l_join_tbl

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

460: , p_col_name => 'price_negotiated_' || l_cur_suffix
461: , p_alias_name => 'affected_value'
462: , p_prior_code => poa_dbi_util_pkg.no_priors);
463:
464: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
465:
466: oki_dbi_util_pvt.join_rpt_where ( p_join_tbl => l_join_tbl
467: , p_func_area => 'SRM'
468: , p_version => '6.0'

Line 514: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

510: l_nested_pattern NUMBER;
511: l_curr_suffix VARCHAR2 (2);
512: l_where_clause VARCHAR2 (2000);
513: l_mv VARCHAR2 (2000);
514: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
515: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
516: l_to_date_xed VARCHAR2 (3);
517: l_to_date_xtd VARCHAR2 (3);
518:

Line 515: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

511: l_curr_suffix VARCHAR2 (2);
512: l_where_clause VARCHAR2 (2000);
513: l_mv VARCHAR2 (2000);
514: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
515: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
516: l_to_date_xed VARCHAR2 (3);
517: l_to_date_xtd VARCHAR2 (3);
518:
519: l_filter_where varchar2(1000);

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

529:
530: l_to_date_xed := 'XED';
531: l_to_date_xtd := 'XTD';
532: l_comparison_type := 'Y';
533: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
534: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
535: oki_dbi_util_pvt.process_parameters ( p_param => p_param
536: , p_view_by => l_view_by
537: , p_view_by_col_name => l_view_by_col

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

530: l_to_date_xed := 'XED';
531: l_to_date_xtd := 'XTD';
532: l_comparison_type := 'Y';
533: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
534: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
535: oki_dbi_util_pvt.process_parameters ( p_param => p_param
536: , p_view_by => l_view_by
537: , p_view_by_col_name => l_view_by_col
538: , p_comparison_type => l_comparison_type

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

561: /* Additional filter needed to avoid displaying records queried due to total values at node */
562: l_filter_where := ' ( ABS(oki_measure_1) ) <> 0 ';
563:
564:
565: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
566:
567: oki_dbi_util_pvt.join_rpt_where (p_join_tbl => l_join_tbl
568: , p_func_area => 'SRM'
569: , p_version => '6.0'

Line 760: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

756: l_nested_pattern NUMBER;
757: l_cur_suffix VARCHAR2 (2);
758: l_where_clause VARCHAR2 (2000);
759: l_mv VARCHAR2 (2000);
760: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
761: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
762: l_to_date_xed VARCHAR2 (3);
763: l_to_date_xtd VARCHAR2 (3);
764:

Line 761: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

757: l_cur_suffix VARCHAR2 (2);
758: l_where_clause VARCHAR2 (2000);
759: l_mv VARCHAR2 (2000);
760: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
761: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
762: l_to_date_xed VARCHAR2 (3);
763: l_to_date_xtd VARCHAR2 (3);
764:
765: l_rpt_specific_where VARCHAR2 (1000);

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

771:
772: l_to_date_xed := 'XED';
773: l_to_date_xtd := 'XTD';
774: l_comparison_type := 'Y';
775: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
776: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
777: oki_dbi_util_pvt.process_parameters ( p_param => p_param
778: , p_view_by => l_view_by
779: , p_view_by_col_name => l_view_by_col

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

772: l_to_date_xed := 'XED';
773: l_to_date_xtd := 'XTD';
774: l_comparison_type := 'Y';
775: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
776: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
777: oki_dbi_util_pvt.process_parameters ( p_param => p_param
778: , p_view_by => l_view_by
779: , p_view_by_col_name => l_view_by_col
780: , p_comparison_type => l_comparison_type

Line 807: poa_dbi_util_pkg.add_column

803:
804: l_group_by := ' GROUP BY fact.chr_id, fact.customer_party_id, fact.resource_id';
805:
806:
807: poa_dbi_util_pkg.add_column
808: ( p_col_tbl => l_col_tbl
809: , p_col_name => 'price_negotiated_' || l_cur_suffix
810: , p_alias_name => 'affected_full_value'
811: , p_prior_code => poa_dbi_util_pkg.no_priors);

Line 811: , p_prior_code => poa_dbi_util_pkg.no_priors);

807: poa_dbi_util_pkg.add_column
808: ( p_col_tbl => l_col_tbl
809: , p_col_name => 'price_negotiated_' || l_cur_suffix
810: , p_alias_name => 'affected_full_value'
811: , p_prior_code => poa_dbi_util_pkg.no_priors);
812:
813: poa_dbi_util_pkg.add_column
814: ( p_col_tbl => l_col_tbl
815: , p_col_name => 'win_percent *.01 *price_negotiated_' || l_cur_suffix

Line 813: poa_dbi_util_pkg.add_column

809: , p_col_name => 'price_negotiated_' || l_cur_suffix
810: , p_alias_name => 'affected_full_value'
811: , p_prior_code => poa_dbi_util_pkg.no_priors);
812:
813: poa_dbi_util_pkg.add_column
814: ( p_col_tbl => l_col_tbl
815: , p_col_name => 'win_percent *.01 *price_negotiated_' || l_cur_suffix
816: , p_alias_name => 'affected_forecast_value'
817: , p_prior_code => poa_dbi_util_pkg.no_priors);

Line 817: , p_prior_code => poa_dbi_util_pkg.no_priors);

813: poa_dbi_util_pkg.add_column
814: ( p_col_tbl => l_col_tbl
815: , p_col_name => 'win_percent *.01 *price_negotiated_' || l_cur_suffix
816: , p_alias_name => 'affected_forecast_value'
817: , p_prior_code => poa_dbi_util_pkg.no_priors);
818:
819: /* Additional filter needed to avoid displaying records queried due to total values at node */
820: l_filter_where := ' ( ABS(oki_measure_1) + ABS(oki_measure_3) ) <> 0 ';
821:

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

818:
819: /* Additional filter needed to avoid displaying records queried due to total values at node */
820: l_filter_where := ' ( ABS(oki_measure_1) + ABS(oki_measure_3) ) <> 0 ';
821:
822: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
823: oki_dbi_util_pvt.join_rpt_where (p_join_tbl => l_join_tbl
824: , p_func_area => 'SRM'
825: , p_version => '6.0'
826: , p_role => NULL

Line 966: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

962:
963: l_filter_where VARCHAR2 (1000);
964:
965: l_mv VARCHAR2 (2000);
966: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
967: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
968: l_to_date_xed VARCHAR2 (3) ;
969: l_to_date_xtd VARCHAR2 (3) ;
970: l_to_date_ytd VARCHAR2 (3) ;

Line 967: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

963: l_filter_where VARCHAR2 (1000);
964:
965: l_mv VARCHAR2 (2000);
966: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
967: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
968: l_to_date_xed VARCHAR2 (3) ;
969: l_to_date_xtd VARCHAR2 (3) ;
970: l_to_date_ytd VARCHAR2 (3) ;
971: l_to_date_itd VARCHAR2 (3) ;

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

980: l_to_date_xtd := 'XTD';
981: l_comparison_type := 'Y';
982: l_to_date_ytd := 'YTD';
983: l_to_date_itd := 'ITD';
984: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
985: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
986: oki_dbi_util_pvt.process_parameters (p_param => p_param
987: , p_view_by => l_view_by
988: , p_view_by_col_name => l_view_by_col

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

981: l_comparison_type := 'Y';
982: l_to_date_ytd := 'YTD';
983: l_to_date_itd := 'ITD';
984: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
985: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
986: oki_dbi_util_pvt.process_parameters (p_param => p_param
987: , p_view_by => l_view_by
988: , p_view_by_col_name => l_view_by_col
989: , p_comparison_type => l_comparison_type

Line 1010: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

1006:
1007:
1008: -- Populate col table with regular columns
1009:
1010: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
1011: , p_col_name => 'g_r_amt_' || l_cur_suffix
1012: , p_alias_name => 'Gr'
1013: , p_to_date_type => l_to_date_xtd);
1014:

Line 1016: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

1012: , p_alias_name => 'Gr'
1013: , p_to_date_type => l_to_date_xtd);
1014:
1015:
1016: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
1017: , p_col_name => 'gl_r_amt_' || l_cur_suffix
1018: , p_alias_name => 'Glr'
1019: , p_to_date_type => l_to_date_xtd);
1020:

Line 1022: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

1018: , p_alias_name => 'Glr'
1019: , p_to_date_type => l_to_date_xtd);
1020:
1021:
1022: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
1023: , p_col_name => 'gr_r_amt_' || l_cur_suffix
1024: , p_alias_name => 'Grr'
1025: , p_to_date_type => l_to_date_xtd);
1026:

Line 1028: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

1024: , p_alias_name => 'Grr'
1025: , p_to_date_type => l_to_date_xtd);
1026:
1027:
1028: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
1029: , p_col_name => 'gl_days'
1030: , p_alias_name => 'Gld'
1031: , p_to_date_type => l_to_date_xtd
1032: , p_prior_code => poa_dbi_util_pkg.no_priors);

Line 1032: , p_prior_code => poa_dbi_util_pkg.no_priors);

1028: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
1029: , p_col_name => 'gl_days'
1030: , p_alias_name => 'Gld'
1031: , p_to_date_type => l_to_date_xtd
1032: , p_prior_code => poa_dbi_util_pkg.no_priors);
1033:
1034:
1035: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
1036: , p_col_name => 'gl_days_count'

Line 1035: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

1031: , p_to_date_type => l_to_date_xtd
1032: , p_prior_code => poa_dbi_util_pkg.no_priors);
1033:
1034:
1035: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
1036: , p_col_name => 'gl_days_count'
1037: , p_alias_name => 'Gld_count'
1038: , p_to_date_type => l_to_date_xtd
1039: , p_prior_code => poa_dbi_util_pkg.no_priors);

Line 1039: , p_prior_code => poa_dbi_util_pkg.no_priors);

1035: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
1036: , p_col_name => 'gl_days_count'
1037: , p_alias_name => 'Gld_count'
1038: , p_to_date_type => l_to_date_xtd
1039: , p_prior_code => poa_dbi_util_pkg.no_priors);
1040:
1041:
1042: /* Additional filter needed to avoid displaying records queried due to total values at node */
1043: l_filter_where := ' ( ABS(oki_measure_1) + ABS(oki_measure_2) + ABS(oki_measure_5) ) <> 0 ';

Line 1221: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Glr','oset13.c_Gr') || 'c_late_Rate '||

1217: ' , oset13.c_Gr '||
1218: ' , oset13.c_Gr_tot '||
1219: ' , oset13.c_Glr '||
1220: ' , oset13.c_Glr_tot '||
1221: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Glr','oset13.c_Gr') || 'c_late_Rate '||
1222: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Glr','oset13.p_Gr') || 'p_late_Rate '||
1223: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Glr_tot','oset13.c_Gr_tot') || 'c_late_Rate_tot '||
1224: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Glr_tot','oset13.p_Gr_tot') || 'p_late_Rate_tot '||
1225: ' , oset13.c_Grr '||

Line 1222: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Glr','oset13.p_Gr') || 'p_late_Rate '||

1218: ' , oset13.c_Gr_tot '||
1219: ' , oset13.c_Glr '||
1220: ' , oset13.c_Glr_tot '||
1221: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Glr','oset13.c_Gr') || 'c_late_Rate '||
1222: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Glr','oset13.p_Gr') || 'p_late_Rate '||
1223: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Glr_tot','oset13.c_Gr_tot') || 'c_late_Rate_tot '||
1224: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Glr_tot','oset13.p_Gr_tot') || 'p_late_Rate_tot '||
1225: ' , oset13.c_Grr '||
1226: ' , oset13.c_Grr_tot '||

Line 1223: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Glr_tot','oset13.c_Gr_tot') || 'c_late_Rate_tot '||

1219: ' , oset13.c_Glr '||
1220: ' , oset13.c_Glr_tot '||
1221: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Glr','oset13.c_Gr') || 'c_late_Rate '||
1222: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Glr','oset13.p_Gr') || 'p_late_Rate '||
1223: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Glr_tot','oset13.c_Gr_tot') || 'c_late_Rate_tot '||
1224: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Glr_tot','oset13.p_Gr_tot') || 'p_late_Rate_tot '||
1225: ' , oset13.c_Grr '||
1226: ' , oset13.c_Grr_tot '||
1227: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Grr','oset13.c_Gr') || 'c_grace_Rate '||

Line 1224: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Glr_tot','oset13.p_Gr_tot') || 'p_late_Rate_tot '||

1220: ' , oset13.c_Glr_tot '||
1221: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Glr','oset13.c_Gr') || 'c_late_Rate '||
1222: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Glr','oset13.p_Gr') || 'p_late_Rate '||
1223: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Glr_tot','oset13.c_Gr_tot') || 'c_late_Rate_tot '||
1224: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Glr_tot','oset13.p_Gr_tot') || 'p_late_Rate_tot '||
1225: ' , oset13.c_Grr '||
1226: ' , oset13.c_Grr_tot '||
1227: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Grr','oset13.c_Gr') || 'c_grace_Rate '||
1228: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Grr','oset13.p_Gr') || 'p_grace_Rate '||

Line 1227: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Grr','oset13.c_Gr') || 'c_grace_Rate '||

1223: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Glr_tot','oset13.c_Gr_tot') || 'c_late_Rate_tot '||
1224: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Glr_tot','oset13.p_Gr_tot') || 'p_late_Rate_tot '||
1225: ' , oset13.c_Grr '||
1226: ' , oset13.c_Grr_tot '||
1227: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Grr','oset13.c_Gr') || 'c_grace_Rate '||
1228: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Grr','oset13.p_Gr') || 'p_grace_Rate '||
1229: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Grr_tot','oset13.c_Gr_tot') || 'c_grace_Rate_tot '||
1230: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Grr_tot','oset13.p_Gr_tot') || 'p_grace_Rate_tot '||
1231: ' , NVL(oset13.c_avg_late,0) c_avg_late '||

Line 1228: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Grr','oset13.p_Gr') || 'p_grace_Rate '||

1224: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Glr_tot','oset13.p_Gr_tot') || 'p_late_Rate_tot '||
1225: ' , oset13.c_Grr '||
1226: ' , oset13.c_Grr_tot '||
1227: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Grr','oset13.c_Gr') || 'c_grace_Rate '||
1228: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Grr','oset13.p_Gr') || 'p_grace_Rate '||
1229: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Grr_tot','oset13.c_Gr_tot') || 'c_grace_Rate_tot '||
1230: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Grr_tot','oset13.p_Gr_tot') || 'p_grace_Rate_tot '||
1231: ' , NVL(oset13.c_avg_late,0) c_avg_late '||
1232: ' , NVL(oset13.c_avg_late_tot,0) c_avg_late_tot '||

Line 1229: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Grr_tot','oset13.c_Gr_tot') || 'c_grace_Rate_tot '||

1225: ' , oset13.c_Grr '||
1226: ' , oset13.c_Grr_tot '||
1227: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Grr','oset13.c_Gr') || 'c_grace_Rate '||
1228: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Grr','oset13.p_Gr') || 'p_grace_Rate '||
1229: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Grr_tot','oset13.c_Gr_tot') || 'c_grace_Rate_tot '||
1230: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Grr_tot','oset13.p_Gr_tot') || 'p_grace_Rate_tot '||
1231: ' , NVL(oset13.c_avg_late,0) c_avg_late '||
1232: ' , NVL(oset13.c_avg_late_tot,0) c_avg_late_tot '||
1233: ' from '||

Line 1230: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Grr_tot','oset13.p_Gr_tot') || 'p_grace_Rate_tot '||

1226: ' , oset13.c_Grr_tot '||
1227: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Grr','oset13.c_Gr') || 'c_grace_Rate '||
1228: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Grr','oset13.p_Gr') || 'p_grace_Rate '||
1229: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_Grr_tot','oset13.c_Gr_tot') || 'c_grace_Rate_tot '||
1230: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_Grr_tot','oset13.p_Gr_tot') || 'p_grace_Rate_tot '||
1231: ' , NVL(oset13.c_avg_late,0) c_avg_late '||
1232: ' , NVL(oset13.c_avg_late_tot,0) c_avg_late_tot '||
1233: ' from '||
1234: ' (select '||

Line 1249: ' ,'||POA_DBI_UTIL_PKG.rate_clause('NVL(oset10.c_Gld,0)','oset10.c_Gld_count','NP') || 'c_avg_late '||

1245: ' , oset10.c_Grr '||
1246: ' , oset10.p_Grr '||
1247: ' , oset10.c_Grr_tot '||
1248: ' , oset10.p_Grr_tot '||
1249: ' ,'||POA_DBI_UTIL_PKG.rate_clause('NVL(oset10.c_Gld,0)','oset10.c_Gld_count','NP') || 'c_avg_late '||
1250: ' ,'||POA_DBI_UTIL_PKG.rate_clause('NVL(oset10.c_Gld_tot,0)','oset10.c_Gld_count_tot','NP') || 'c_avg_late_tot '||
1251: ' from '||
1252: ' ( select '||
1253: ' oset05.'||p_view_by_col ||

Line 1250: ' ,'||POA_DBI_UTIL_PKG.rate_clause('NVL(oset10.c_Gld_tot,0)','oset10.c_Gld_count_tot','NP') || 'c_avg_late_tot '||

1246: ' , oset10.p_Grr '||
1247: ' , oset10.c_Grr_tot '||
1248: ' , oset10.p_Grr_tot '||
1249: ' ,'||POA_DBI_UTIL_PKG.rate_clause('NVL(oset10.c_Gld,0)','oset10.c_Gld_count','NP') || 'c_avg_late '||
1250: ' ,'||POA_DBI_UTIL_PKG.rate_clause('NVL(oset10.c_Gld_tot,0)','oset10.c_Gld_count_tot','NP') || 'c_avg_late_tot '||
1251: ' from '||
1252: ' ( select '||
1253: ' oset05.'||p_view_by_col ||
1254: ' , nvl(oset05.c_Gr,0) c_Gr '||

Line 1302: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

1298:
1299: l_filter_where VARCHAR2 (1000);
1300:
1301: l_mv VARCHAR2 (2000);
1302: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1303: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1304: l_to_date_xed VARCHAR2 (3) ;
1305: l_to_date_xtd VARCHAR2 (3);
1306: l_to_date_ytd VARCHAR2 (3);

Line 1303: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

1299: l_filter_where VARCHAR2 (1000);
1300:
1301: l_mv VARCHAR2 (2000);
1302: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1303: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1304: l_to_date_xed VARCHAR2 (3) ;
1305: l_to_date_xtd VARCHAR2 (3);
1306: l_to_date_ytd VARCHAR2 (3);
1307: l_to_date_itd VARCHAR2 (3);

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

1356: l_to_date_xtd := 'XTD';
1357: l_comparison_type := 'Y';
1358: l_to_date_ytd := 'YTD';
1359: l_to_date_itd := 'ITD';
1360: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1361: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1362: oki_dbi_util_pvt.process_parameters ( p_param => p_param
1363: , p_view_by => l_view_by
1364: , p_view_by_col_name => l_view_by_col

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

1357: l_comparison_type := 'Y';
1358: l_to_date_ytd := 'YTD';
1359: l_to_date_itd := 'ITD';
1360: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1361: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1362: oki_dbi_util_pvt.process_parameters ( p_param => p_param
1363: , p_view_by => l_view_by
1364: , p_view_by_col_name => l_view_by_col
1365: , p_comparison_type => l_comparison_type

Line 1383: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

1379: , p_mv_set => 'SRM_CN_71'
1380: , p_rg_where => 'Y');
1381: --, p_rpt_type => 'SUMMARY'
1382:
1383: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
1384: , p_col_name => 'c_r_amt_' || l_cur_suffix
1385: , p_alias_name => 'Cr'
1386: , p_to_date_type => l_to_date_xtd);
1387:

Line 1487: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset20.C_cncl','oset20.C_cncl_tot') || ' oki_measure_3 '||

1483: -- AK Attribute naming
1484: ' ,'|| p_view_by_col ||
1485: ' , oset20.C_cncl oki_measure_1 '||
1486: ' , oset20.cncl_chg oki_measure_2 '||
1487: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset20.C_cncl','oset20.C_cncl_tot') || ' oki_measure_3 '||
1488: ' , oset20.C_cncl_tot oki_measure_11 '||
1489: ' , oset20.cncl_chg_tot oki_measure_12 '||
1490: ' , oset20.p_cncl oki_measure_21 '||
1491: ' from '||

Line 1552: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

1548: l_nested_pattern NUMBER;
1549: l_curr_suffix VARCHAR2 (2);
1550: l_where_clause VARCHAR2 (2000);
1551: l_mv VARCHAR2 (2000);
1552: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1553: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1554: l_to_date_xed VARCHAR2 (3);
1555: l_to_date_xtd VARCHAR2 (3);
1556:

Line 1553: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

1549: l_curr_suffix VARCHAR2 (2);
1550: l_where_clause VARCHAR2 (2000);
1551: l_mv VARCHAR2 (2000);
1552: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1553: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1554: l_to_date_xed VARCHAR2 (3);
1555: l_to_date_xtd VARCHAR2 (3);
1556:
1557: l_rpt_specific_where VARCHAR2 (1000);

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

1563:
1564: l_to_date_xed := 'XED';
1565: l_to_date_xtd := 'XTD';
1566: l_comparison_type := 'Y';
1567: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1568: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1569: oki_dbi_util_pvt.process_parameters ( p_param => p_param
1570: , p_view_by => l_view_by
1571: , p_view_by_col_name => l_view_by_col

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

1564: l_to_date_xed := 'XED';
1565: l_to_date_xtd := 'XTD';
1566: l_comparison_type := 'Y';
1567: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1568: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1569: oki_dbi_util_pvt.process_parameters ( p_param => p_param
1570: , p_view_by => l_view_by
1571: , p_view_by_col_name => l_view_by_col
1572: , p_comparison_type => l_comparison_type

Line 1596: poa_dbi_util_pkg.add_column ( p_col_tbl => l_col_tbl

1592: and &BIS_CURRENT_ASOF_DATE';
1593:
1594: l_group_by := ' GROUP BY fact.chr_id, fact.customer_party_id, fact.resource_id, fact.sts_code ';
1595:
1596: poa_dbi_util_pkg.add_column ( p_col_tbl => l_col_tbl
1597: , p_col_name => 'price_negotiated_' || l_curr_suffix
1598: , p_alias_name => 'cancelled_value'
1599: , p_prior_code => poa_dbi_util_pkg.no_priors);
1600:

Line 1599: , p_prior_code => poa_dbi_util_pkg.no_priors);

1595:
1596: poa_dbi_util_pkg.add_column ( p_col_tbl => l_col_tbl
1597: , p_col_name => 'price_negotiated_' || l_curr_suffix
1598: , p_alias_name => 'cancelled_value'
1599: , p_prior_code => poa_dbi_util_pkg.no_priors);
1600:
1601: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1602:
1603: oki_dbi_util_pvt.join_rpt_where ( p_join_tbl => l_join_tbl

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

1597: , p_col_name => 'price_negotiated_' || l_curr_suffix
1598: , p_alias_name => 'cancelled_value'
1599: , p_prior_code => poa_dbi_util_pkg.no_priors);
1600:
1601: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1602:
1603: oki_dbi_util_pvt.join_rpt_where ( p_join_tbl => l_join_tbl
1604: , p_func_area => 'SRM'
1605: , p_version => '6.0'

Line 1759: l_col_rec poa_dbi_util_pkg.poa_dbi_col_rec;

1755: l_custom_sql VARCHAR2 (32767);
1756: l_custom_rec bis_query_attributes;
1757: l_where_clause VARCHAR2 (2000);
1758: l_mv VARCHAR2 (2000);
1759: l_col_rec poa_dbi_util_pkg.poa_dbi_col_rec;
1760: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1761: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1762: l_url VARCHAR2 (500);
1763: l_to_date_xed VARCHAR2 (3) ;

Line 1760: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

1756: l_custom_rec bis_query_attributes;
1757: l_where_clause VARCHAR2 (2000);
1758: l_mv VARCHAR2 (2000);
1759: l_col_rec poa_dbi_util_pkg.poa_dbi_col_rec;
1760: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1761: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1762: l_url VARCHAR2 (500);
1763: l_to_date_xed VARCHAR2 (3) ;
1764: l_to_date_xtd VARCHAR2 (3);

Line 1761: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

1757: l_where_clause VARCHAR2 (2000);
1758: l_mv VARCHAR2 (2000);
1759: l_col_rec poa_dbi_util_pkg.poa_dbi_col_rec;
1760: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1761: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1762: l_url VARCHAR2 (500);
1763: l_to_date_xed VARCHAR2 (3) ;
1764: l_to_date_xtd VARCHAR2 (3);
1765:

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

1787:
1788: l_to_date_xed := 'XED';
1789: l_to_date_xtd := 'XTD';
1790: l_comparison_type := 'Y';
1791: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1792: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1793: oki_dbi_util_pvt.process_parameters (p_param => p_param
1794: , p_view_by => l_view_by
1795: , p_view_by_col_name => l_view_by_col

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

1788: l_to_date_xed := 'XED';
1789: l_to_date_xtd := 'XTD';
1790: l_comparison_type := 'Y';
1791: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1792: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1793: oki_dbi_util_pvt.process_parameters (p_param => p_param
1794: , p_view_by => l_view_by
1795: , p_view_by_col_name => l_view_by_col
1796: , p_comparison_type => l_comparison_type

Line 1986: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

1982: l_dim_bmap NUMBER;
1983: l_cur_suffix VARCHAR2 (2);
1984: l_custom_sql VARCHAR2 (10000);
1985: l_period_type VARCHAR2(10);
1986: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1987: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1988:
1989: l_period_code varchar2(1);
1990: l_where_clause1 VARCHAR2 (2000);

Line 1987: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

1983: l_cur_suffix VARCHAR2 (2);
1984: l_custom_sql VARCHAR2 (10000);
1985: l_period_type VARCHAR2(10);
1986: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1987: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1988:
1989: l_period_code varchar2(1);
1990: l_where_clause1 VARCHAR2 (2000);
1991: l_where_clause2 VARCHAR2 (2000);

Line 1997: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;

1993: l_to_date_xtd VARCHAR2 (3) ;
1994: l_to_date_xed VARCHAR2 (3) ;
1995: l_mv1 VARCHAR2(100);
1996: l_mv2 VARCHAR2(100);
1997: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
1998: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
1999: l_xtd1 VARCHAR2(10);
2000: l_xtd2 VARCHAR2(10);
2001: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

Line 1998: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;

1994: l_to_date_xed VARCHAR2 (3) ;
1995: l_mv1 VARCHAR2(100);
1996: l_mv2 VARCHAR2(100);
1997: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
1998: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
1999: l_xtd1 VARCHAR2(10);
2000: l_xtd2 VARCHAR2(10);
2001: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
2002:

Line 2001: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

1997: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
1998: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
1999: l_xtd1 VARCHAR2(10);
2000: l_xtd2 VARCHAR2(10);
2001: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
2002:
2003: BEGIN
2004:
2005: l_to_date_xed := 'XED';

Line 2009: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();

2005: l_to_date_xed := 'XED';
2006: l_to_date_xtd := 'XTD';
2007: l_comparison_type := 'Y';
2008:
2009: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
2010: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
2011: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
2012: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
2013:

Line 2010: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();

2006: l_to_date_xtd := 'XTD';
2007: l_comparison_type := 'Y';
2008:
2009: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
2010: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
2011: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
2012: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
2013:
2014: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

Line 2011: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();

2007: l_comparison_type := 'Y';
2008:
2009: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
2010: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
2011: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
2012: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
2013:
2014: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
2015: , p_view_by => l_view_by

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

2008:
2009: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
2010: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
2011: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
2012: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
2013:
2014: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
2015: , p_view_by => l_view_by
2016: , p_view_by_col_name => l_view_by_col

Line 2036: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

2032: , p_rg_where => 'Y');
2033:
2034: -- Populate col table with regular columns
2035: -- Period Renewal node
2036: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
2037: , p_col_name => 'g_r_amt_' || l_cur_suffix
2038: , p_alias_name => 'g_r_amt_xtd'
2039: , p_grand_total => 'N'
2040: , p_to_date_type => 'XTD');

Line 2041: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

2037: , p_col_name => 'g_r_amt_' || l_cur_suffix
2038: , p_alias_name => 'g_r_amt_xtd'
2039: , p_grand_total => 'N'
2040: , p_to_date_type => 'XTD');
2041: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
2042: , p_col_name => 'g_r_amt_' || l_cur_suffix
2043: , p_alias_name => 'g_r_amt_tot'
2044: , p_grand_total => 'N'
2045: , p_to_date_type => 'XED');

Line 2066: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2

2062: , p_version => '6.0'
2063: , p_role => NULL
2064: , p_mv_set => 'SRM_EC_71'
2065: , p_rg_where => 'Y');
2066: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
2067: , p_col_name => 'f_f_amt_' || l_cur_suffix
2068: , p_alias_name => 'f_f_amt_xed'
2069: , p_grand_total => 'N'
2070: , p_to_date_type => 'XED');