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 OKI_DBI_UTIL_PVT

Line 96: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

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
100: , p_xtd => l_xtd1

Line 130: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

126: , p_alias_name => 'Go'
127: , p_to_date_type => l_to_date_xtd);
128:
129:
130: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
131: , p_view_by => l_view_by
132: , p_view_by_col_name => l_view_by_col
133: , p_comparison_type => l_comparison_type
134: , p_xtd => l_xtd1

Line 200: --oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

196: -- insert into brrao_temp values ( l_query);
197: -- commit;
198:
199: x_custom_sql := '/* OKI_DBI_SRM_RNWL_SUM_RPT */' ||l_query;
200: --oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
201: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
202:
203: END get_table_sql;
204:

Line 201: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

197: -- commit;
198:
199: x_custom_sql := '/* OKI_DBI_SRM_RNWL_SUM_RPT */' ||l_query;
200: --oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
201: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
202:
203: END get_table_sql;
204:
205:

Line 223: l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(p_view_by_dim, 'SRM', '6.0');

219: l_url_select VARCHAR2(32767);
220: BEGIN
221:
222:
223: l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(p_view_by_dim, 'SRM', '6.0');
224:
225: -- Bookings URL when view by is Salesrep
226: l_bookings_url := '''pFunctionName=OKI_DBI_SRM_RSBK_DTL_DRPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y''';
227: --l_bookings_url := '''pFunctionName=OKI_DBI_SRM_RSBK_DTL_DRPT''';

Line 321: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_Gr','oset15.P_Gr','NP') || ' bkg_chg '||

317: -- Change Calculation
318: ' '|| p_view_by_col ||
319: ' , oset15.C_Gr C_bkg '||
320: ' , oset15.P_Gr P_bkg '||
321: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_Gr','oset15.P_Gr','NP') || ' bkg_chg '||
322: ' , oset15.C_Fcf fcst '||
323: ' , oset15.C_Fcr fcst_full '||
324: ' , oset15.C_GrFcf exp_bkg '||
325: ' , oset15.C_GrFcr exp_bkg_full '||

Line 328: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_upl','oset15.P_upl','NP') || ' upl_chg '||

324: ' , oset15.C_GrFcf exp_bkg '||
325: ' , oset15.C_GrFcr exp_bkg_full '||
326: ' , oset15.C_upl c_upl '||
327: ' , oset15.P_upl p_upl '||
328: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_upl','oset15.P_upl','NP') || ' upl_chg '||
329: ' , oset15.C_Gr_tot C_bkg_tot '||
330: ' , oset15.P_Gr_tot P_bkg_tot '||
331: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_Gr_tot','oset15.P_Gr_tot','NP') || ' bkg_chg_tot '||
332: ' , oset15.C_Fcf_tot fcst_tot '||

Line 331: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_Gr_tot','oset15.P_Gr_tot','NP') || ' bkg_chg_tot '||

327: ' , oset15.P_upl p_upl '||
328: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_upl','oset15.P_upl','NP') || ' upl_chg '||
329: ' , oset15.C_Gr_tot C_bkg_tot '||
330: ' , oset15.P_Gr_tot P_bkg_tot '||
331: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_Gr_tot','oset15.P_Gr_tot','NP') || ' bkg_chg_tot '||
332: ' , oset15.C_Fcf_tot fcst_tot '||
333: ' , oset15.C_Fcr_tot fcst_full_tot '||
334: ' , oset15.C_GrFcf_tot exp_bkg_tot '||
335: ' , oset15.C_GrFcr_tot exp_bkg_full_tot '||

Line 338: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_upl_tot','oset15.P_upl_tot','NP') || ' upl_chg_tot '||

334: ' , oset15.C_GrFcf_tot exp_bkg_tot '||
335: ' , oset15.C_GrFcr_tot exp_bkg_full_tot '||
336: ' , oset15.C_upl_tot C_upl_tot '||
337: ' , oset15.P_upl_tot P_upl_tot '||
338: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_upl_tot','oset15.P_upl_tot','NP') || ' upl_chg_tot '||
339: ' from '||
340: ' (select '||
341: -- Calculated Measures
342: p_view_by_col ||

Line 347: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr','oset13.c_Fcf') ||' c_GrFcf '||

343: ' , oset13.c_Gr '||
344: ' , oset13.p_Gr '||
345: ' , oset13.c_Fcf '||
346: ' , oset13.c_Fcr '||
347: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr','oset13.c_Fcf') ||' c_GrFcf '||
348: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr','oset13.c_Fcr') ||' c_GrFcr '||
349: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_Gr','oset13.c_Go') ||' c_Upl '||
350: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_Gr','oset13.p_Go') ||' p_Upl '||
351: ' , oset13.c_Gr_tot '||

Line 348: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr','oset13.c_Fcr') ||' c_GrFcr '||

344: ' , oset13.p_Gr '||
345: ' , oset13.c_Fcf '||
346: ' , oset13.c_Fcr '||
347: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr','oset13.c_Fcf') ||' c_GrFcf '||
348: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr','oset13.c_Fcr') ||' c_GrFcr '||
349: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_Gr','oset13.c_Go') ||' c_Upl '||
350: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_Gr','oset13.p_Go') ||' p_Upl '||
351: ' , oset13.c_Gr_tot '||
352: ' , oset13.p_Gr_tot '||

Line 349: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_Gr','oset13.c_Go') ||' c_Upl '||

345: ' , oset13.c_Fcf '||
346: ' , oset13.c_Fcr '||
347: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr','oset13.c_Fcf') ||' c_GrFcf '||
348: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr','oset13.c_Fcr') ||' c_GrFcr '||
349: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_Gr','oset13.c_Go') ||' c_Upl '||
350: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_Gr','oset13.p_Go') ||' p_Upl '||
351: ' , oset13.c_Gr_tot '||
352: ' , oset13.p_Gr_tot '||
353: ' , oset13.c_Fcf_tot '||

Line 350: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_Gr','oset13.p_Go') ||' p_Upl '||

346: ' , oset13.c_Fcr '||
347: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr','oset13.c_Fcf') ||' c_GrFcf '||
348: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr','oset13.c_Fcr') ||' c_GrFcr '||
349: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_Gr','oset13.c_Go') ||' c_Upl '||
350: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_Gr','oset13.p_Go') ||' p_Upl '||
351: ' , oset13.c_Gr_tot '||
352: ' , oset13.p_Gr_tot '||
353: ' , oset13.c_Fcf_tot '||
354: ' , oset13.c_Fcr_tot '||

Line 355: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr_tot','oset13.c_Fcf_tot') ||' c_GrFcf_tot '||

351: ' , oset13.c_Gr_tot '||
352: ' , oset13.p_Gr_tot '||
353: ' , oset13.c_Fcf_tot '||
354: ' , oset13.c_Fcr_tot '||
355: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr_tot','oset13.c_Fcf_tot') ||' c_GrFcf_tot '||
356: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr_tot','oset13.c_Fcr_tot') ||' c_GrFcr_tot '||
357: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_Gr_tot','oset13.c_Go_tot') ||' c_Upl_tot '||
358: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_Gr_tot','oset13.p_Go_tot') ||' p_Upl_tot '||
359: ' from '||

Line 356: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr_tot','oset13.c_Fcr_tot') ||' c_GrFcr_tot '||

352: ' , oset13.p_Gr_tot '||
353: ' , oset13.c_Fcf_tot '||
354: ' , oset13.c_Fcr_tot '||
355: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr_tot','oset13.c_Fcf_tot') ||' c_GrFcf_tot '||
356: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr_tot','oset13.c_Fcr_tot') ||' c_GrFcr_tot '||
357: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_Gr_tot','oset13.c_Go_tot') ||' c_Upl_tot '||
358: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_Gr_tot','oset13.p_Go_tot') ||' p_Upl_tot '||
359: ' from '||
360: ' (select '||

Line 357: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_Gr_tot','oset13.c_Go_tot') ||' c_Upl_tot '||

353: ' , oset13.c_Fcf_tot '||
354: ' , oset13.c_Fcr_tot '||
355: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr_tot','oset13.c_Fcf_tot') ||' c_GrFcf_tot '||
356: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr_tot','oset13.c_Fcr_tot') ||' c_GrFcr_tot '||
357: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_Gr_tot','oset13.c_Go_tot') ||' c_Upl_tot '||
358: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_Gr_tot','oset13.p_Go_tot') ||' p_Upl_tot '||
359: ' from '||
360: ' (select '||
361: -- Measures Based on a formula

Line 358: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_Gr_tot','oset13.p_Go_tot') ||' p_Upl_tot '||

354: ' , oset13.c_Fcr_tot '||
355: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr_tot','oset13.c_Fcf_tot') ||' c_GrFcf_tot '||
356: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset13.c_Gr_tot','oset13.c_Fcr_tot') ||' c_GrFcr_tot '||
357: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_Gr_tot','oset13.c_Go_tot') ||' c_Upl_tot '||
358: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_Gr_tot','oset13.p_Go_tot') ||' p_Upl_tot '||
359: ' from '||
360: ' (select '||
361: -- Measures Based on a formula
362: p_view_by_col ||

Line 432: oki_dbi_util_pvt.process_parameters ( p_param => p_param

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
435: , p_comparison_type => l_comparison_type
436: , p_xtd => l_xtd

Line 466: oki_dbi_util_pvt.join_rpt_where ( p_join_tbl => l_join_tbl

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'
469: , p_role => NULL
470: , p_mv_set => 'SRM_DTL_RPT');

Line 491: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

487:
488: x_custom_sql := '/* OKI_DBI_SRM_RSBK_DTL_DRP */' || l_query;
489:
490:
491: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
492:
493:
494: END get_bookings_sql;
495:

Line 535: oki_dbi_util_pvt.process_parameters ( p_param => p_param

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
539: , p_xtd => l_xtd

Line 567: oki_dbi_util_pvt.join_rpt_where (p_join_tbl => l_join_tbl

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'
570: , p_role => NULL
571: , p_mv_set => 'SRM_TBK_RPT');

Line 586: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

582: , p_group_by => l_group_by
583: , p_from_clause => ' from '||l_mv ||' fact ');
584: x_custom_sql := '/* OKI_DBI_SRM_RSBK_DTL_DRPT */ ' || l_query;
585:
586: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
587:
588: END get_top_bookings_sql;
589:
590:

Line 722: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

718: l_query VARCHAR2 (32767);
719: BEGIN
720: l_query := 'Hello';
721: x_custom_sql := '/* OKI_DBI_SRM_RSBK_DTL_CRPT */ ' || l_query;
722: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
723: END get_bkngs_by_cust_sql;
724:
725: /*******************************************************************************/
726: /* get_bkngs_by_cust_sel_clause returns the top most select statement of the query

Line 777: oki_dbi_util_pvt.process_parameters ( p_param => p_param

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
781: , p_xtd => l_xtd

Line 823: oki_dbi_util_pvt.join_rpt_where (p_join_tbl => l_join_tbl

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
827: , p_mv_set => 'SRM_DTL_RPT');

Line 844: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

840: , p_group_by => l_group_by
841: , p_from_clause => ' from '||l_mv ||' fact ');
842:
843: x_custom_sql := '/* OKI_DBI_SRM_FCST_DTL_DRPT */' || l_query;
844: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
845:
846: END get_renewal_forecast_sql;
847:
848: FUNCTION get_renwlforecast_sel_clause (

Line 919: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

915: l_query VARCHAR2 (32767);
916: BEGIN
917: l_query := 'Hello';
918: x_custom_sql := '/* OKI_DBI_SRM_RSBK_DTL_CRPT */ ' || l_query;
919: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
920: END get_exp_bkngs_by_cust_sql;
921:
922: /*******************************************************************************
923: Function: get_exp_bkngs_cust_sel_clause

Line 986: oki_dbi_util_pvt.process_parameters (p_param => p_param

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
990: , p_xtd => l_xtd

Line 1070: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

1066: , p_paren_count => 7);
1067:
1068: x_custom_sql := '/* OKI_DBI_SRM_LATE_BKNG_LRPT */ ' || l_query;
1069:
1070: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
1071:
1072: END get_late_rnwl_table_sql;
1073:
1074: /*

Line 1090: l_viewby_select:= oki_dbi_util_pvt.get_viewby_select_clause(p_view_by_dim, 'SRM', '6.0');

1086: l_late_rnwl_booking_url VARCHAR2(300);
1087: BEGIN
1088:
1089:
1090: l_viewby_select:= oki_dbi_util_pvt.get_viewby_select_clause(p_view_by_dim, 'SRM', '6.0');
1091:
1092: -- Bookings URL when view by is Salesrep
1093: l_bookings_url := '''pFunctionName=OKI_DBI_SRM_RSBK_DTL_DRPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y''';
1094:

Line 1202: ' ,'||oki_dbi_util_pvt.change_clause('oset15.c_late_rate','oset15.p_late_rate','P') || ' late_chg '||

1198: ' , oset15.c_Glr_tot '||
1199: ' , oset15.c_late_rate '||
1200: ' , oset15.p_late_rate '||
1201: ' , oset15.c_late_rate_tot '||
1202: ' ,'||oki_dbi_util_pvt.change_clause('oset15.c_late_rate','oset15.p_late_rate','P') || ' late_chg '||
1203: ' ,'||oki_dbi_util_pvt.change_clause('oset15.c_late_rate_tot','oset15.p_late_rate_tot','P') || ' late_chg_tot '||
1204: ' , oset15.c_Grr '||
1205: ' , oset15.c_Grr_tot '||
1206: ' , oset15.c_grace_rate '||

Line 1203: ' ,'||oki_dbi_util_pvt.change_clause('oset15.c_late_rate_tot','oset15.p_late_rate_tot','P') || ' late_chg_tot '||

1199: ' , oset15.c_late_rate '||
1200: ' , oset15.p_late_rate '||
1201: ' , oset15.c_late_rate_tot '||
1202: ' ,'||oki_dbi_util_pvt.change_clause('oset15.c_late_rate','oset15.p_late_rate','P') || ' late_chg '||
1203: ' ,'||oki_dbi_util_pvt.change_clause('oset15.c_late_rate_tot','oset15.p_late_rate_tot','P') || ' late_chg_tot '||
1204: ' , oset15.c_Grr '||
1205: ' , oset15.c_Grr_tot '||
1206: ' , oset15.c_grace_rate '||
1207: ' , oset15.p_grace_rate '||

Line 1209: ' ,'||oki_dbi_util_pvt.change_clause('oset15.c_grace_rate','oset15.p_grace_rate','P') || ' grace_chg '||

1205: ' , oset15.c_Grr_tot '||
1206: ' , oset15.c_grace_rate '||
1207: ' , oset15.p_grace_rate '||
1208: ' , oset15.c_grace_rate_tot '||
1209: ' ,'||oki_dbi_util_pvt.change_clause('oset15.c_grace_rate','oset15.p_grace_rate','P') || ' grace_chg '||
1210: ' ,'||oki_dbi_util_pvt.change_clause('oset15.c_grace_rate_tot','oset15.p_grace_rate_tot','P') || ' grace_chg_tot '||
1211: ' , oset15.c_avg_late '||
1212: ' , oset15.c_avg_late_tot '||
1213: ' from '||

Line 1210: ' ,'||oki_dbi_util_pvt.change_clause('oset15.c_grace_rate_tot','oset15.p_grace_rate_tot','P') || ' grace_chg_tot '||

1206: ' , oset15.c_grace_rate '||
1207: ' , oset15.p_grace_rate '||
1208: ' , oset15.c_grace_rate_tot '||
1209: ' ,'||oki_dbi_util_pvt.change_clause('oset15.c_grace_rate','oset15.p_grace_rate','P') || ' grace_chg '||
1210: ' ,'||oki_dbi_util_pvt.change_clause('oset15.c_grace_rate_tot','oset15.p_grace_rate_tot','P') || ' grace_chg_tot '||
1211: ' , oset15.c_avg_late '||
1212: ' , oset15.c_avg_late_tot '||
1213: ' from '||
1214: ' (select '||

Line 1362: oki_dbi_util_pvt.process_parameters ( p_param => p_param

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
1366: , p_xtd => l_xtd

Line 1405: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

1401: , p_col_name => l_col_tbl
1402: , p_use_grpid => 'N'
1403: , p_paren_count => 7);
1404: x_custom_sql := '/* OKI_DBI_SRM_CNCL_SUM_RPT */' || l_query;
1405: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
1406:
1407: END get_cncl_table_sql;
1408:
1409:

Line 1425: l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(p_view_by_dim, 'SRM', '6.0');

1421:
1422: BEGIN
1423:
1424:
1425: l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(p_view_by_dim, 'SRM', '6.0');
1426:
1427: l_cancelled_value_url := '''pFunctionName=OKI_DBI_SRM_CNCL_DTL_LRPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y''';
1428: l_cancelled_value_reason_url:= '''pFunctionName=OKI_DBI_SRM_CNCL_DTL_LRPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y''';
1429:

Line 1497: ' ,'||oki_dbi_util_pvt.change_clause('oset15.C_Cr','oset15.P_Cr','NP') || ' cncl_chg '||

1493: -- Change Calculation
1494: ' '|| p_view_by_col ||
1495: ' , oset15.C_Cr C_cncl '||
1496: ' , oset15.P_Cr P_cncl '||
1497: ' ,'||oki_dbi_util_pvt.change_clause('oset15.C_Cr','oset15.P_Cr','NP') || ' cncl_chg '||
1498: ' , oset15.C_Cr_tot C_cncl_tot '||
1499: ' , oset15.P_Cr_tot P_cncl_tot '||
1500: ' ,'||oki_dbi_util_pvt.change_clause('oset15.C_Cr_tot','oset15.P_Cr_tot','NP') || ' cncl_chg_tot '||
1501: ' from '||

Line 1500: ' ,'||oki_dbi_util_pvt.change_clause('oset15.C_Cr_tot','oset15.P_Cr_tot','NP') || ' cncl_chg_tot '||

1496: ' , oset15.P_Cr P_cncl '||
1497: ' ,'||oki_dbi_util_pvt.change_clause('oset15.C_Cr','oset15.P_Cr','NP') || ' cncl_chg '||
1498: ' , oset15.C_Cr_tot C_cncl_tot '||
1499: ' , oset15.P_Cr_tot P_cncl_tot '||
1500: ' ,'||oki_dbi_util_pvt.change_clause('oset15.C_Cr_tot','oset15.P_Cr_tot','NP') || ' cncl_chg_tot '||
1501: ' from '||
1502: ' (select '||
1503: -- Calculated Measures
1504: p_view_by_col ||

Line 1569: oki_dbi_util_pvt.process_parameters ( p_param => p_param

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
1573: , p_xtd => l_xtd

Line 1603: oki_dbi_util_pvt.join_rpt_where ( p_join_tbl => l_join_tbl

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'
1606: , p_role => NULL
1607: , p_mv_set => 'SRM_DTL_RPT');

Line 1612: oki_dbi_util_pvt.add_join_table (p_join_tbl => l_join_tbl

1608:
1609: /* Additional filter needed to avoid displaying records queried due to total values at node */
1610: l_filter_where := ' ( ABS(oki_measure_1) ) <> 0 ';
1611:
1612: oki_dbi_util_pvt.add_join_table (p_join_tbl => l_join_tbl
1613: , p_column_name => 'id'
1614: , p_table_name => 'OKI_CANCEL_STATUSES_V'
1615: , p_table_alias => 'v'
1616: , p_fact_column => 'sts_code'

Line 1636: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

1632: , p_from_clause => ' from '||l_mv ||' fact ');
1633: x_custom_sql := '/* OKI_DBI_SRM_CNCL_DTL_LRPT */' || l_query;
1634:
1635:
1636: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
1637:
1638: END get_cancellations_sql;
1639:
1640: FUNCTION get_cancellations_sel_clause (

Line 1711: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

1707: l_query VARCHAR2 (32767);
1708: BEGIN
1709: l_query := 'Hello';
1710: x_custom_sql := '/* OKI_DBI_SRM_RSBK_DTL_CRPT */ ' || l_query;
1711: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
1712: END get_cancln_by_cust_sql;
1713:
1714:
1715:

Line 1793: oki_dbi_util_pvt.process_parameters (p_param => p_param

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
1797: , p_xtd => l_xtd

Line 1944: ,'||oki_dbi_util_pvt.change_clause('curr_late','prior_late','NP') ||' OKI_MEASURE_4

1940: ,bucket_type OKI_MEASURE_23
1941: ,NVL(line_cnt,0) OKI_MEASURE_1
1942: ,nvl(curr_late,0) OKI_MEASURE_2
1943: ,nvl(prior_late,0) OKI_MEASURE_3
1944: ,'||oki_dbi_util_pvt.change_clause('curr_late','prior_late','NP') ||' OKI_MEASURE_4
1945: ,nvl((sum(curr_late) over ()),0) OKI_MEASURE_12
1946: ,nvl((curr_late /decode(sum(curr_late) over (),0,NULL,sum(curr_late) over ())*100),0) OKI_MEASURE_5
1947: ,nvl((curr_late /decode(sum(curr_late) over (),0,NULL,sum(curr_late) over ())*100),0) OKI_MEASURE_6
1948: ,(nvl((sum(curr_late) over ()),0) - (sum(prior_late) over ()))/ decode(sum(prior_late) over (),0,NULL,sum(prior_late) over ()) *100 OKI_MEASURE_14

Line 1959: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

1955: ORDER BY BUCKET_TYPE ';
1956:
1957: x_custom_sql := '/* OKI_DBI_SRM_LATE_AGING_LRPT */' || l_query;
1958:
1959: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
1960: oki_dbi_util_pvt.get_bis_bucket_binds (x_custom_output, l_bucket_rec);
1961:
1962: END get_bucket_sql ;
1963:

Line 1960: oki_dbi_util_pvt.get_bis_bucket_binds (x_custom_output, l_bucket_rec);

1956:
1957: x_custom_sql := '/* OKI_DBI_SRM_LATE_AGING_LRPT */' || l_query;
1958:
1959: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
1960: oki_dbi_util_pvt.get_bis_bucket_binds (x_custom_output, l_bucket_rec);
1961:
1962: END get_bucket_sql ;
1963:
1964: /*******************************************************************************

Line 2014: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

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
2017: , p_comparison_type => l_comparison_type
2018: , p_xtd => l_xtd1

Line 2047: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

2043: , p_alias_name => 'g_r_amt_tot'
2044: , p_grand_total => 'N'
2045: , p_to_date_type => 'XED');
2046:
2047: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
2048: , p_view_by => l_view_by
2049: , p_view_by_col_name => l_view_by_col
2050: , p_comparison_type => l_comparison_type
2051: , p_xtd => l_xtd2

Line 2107: oki_dbi_util_pvt.get_custom_trend_binds (l_xtd1

2103: , p_col_name => l_col_tbl
2104: , p_use_grpid => 'R');
2105: */
2106: x_custom_sql := '/* OKI_DBI_SRM_BKNG_FCST_G */ ' || l_query;
2107: oki_dbi_util_pvt.get_custom_trend_binds (l_xtd1
2108: , l_comparison_type
2109: , x_custom_output);
2110:
2111: END get_bkng_trend_sql ;

Line 2138: , '||OKI_DBI_UTIL_PVT.change_clause('nvl(iset.c_g_r_amt_xtd,0)','iset.p_g_r_amt_xtd','NP')

2134: then iset.c_g_r_amt_tot else NULL END) OKI_MEASURE_5
2135: , nvl(iset.p_g_r_amt_tot,0) OKI_MEASURE_2
2136: , nvl(iset.c_g_r_amt_xtd,0) OKI_MEASURE_3
2137: , nvl(iset.p_g_r_amt_xtd,0) OKI_MEASURE_1
2138: , '||OKI_DBI_UTIL_PVT.change_clause('nvl(iset.c_g_r_amt_xtd,0)','iset.p_g_r_amt_xtd','NP')
2139: ||' OKI_MEASURE_6
2140: ,(case when iset.start_date = &BIS_CURRENT_EFFECTIVE_START_DATE
2141: then nvl(iset.c_f_f_amt_xed,0) + nvl(iset.c_g_r_amt_xtd,0) else NULL
2142: END) OKI_MEASURE_4

Line 2153: , '||OKI_DBI_UTIL_PVT.change_clause('nvl(c_g_r_amt_xtd,0)','p_g_r_amt_xtd','NP')

2149: then c_g_r_amt_tot else NULL END) OKI_MEASURE_5
2150: , nvl(p_g_r_amt_tot,0) OKI_MEASURE_2
2151: , nvl(c_g_r_amt_xtd,0) OKI_MEASURE_3
2152: , nvl(p_g_r_amt_xtd,0) OKI_MEASURE_1
2153: , '||OKI_DBI_UTIL_PVT.change_clause('nvl(c_g_r_amt_xtd,0)','p_g_r_amt_xtd','NP')
2154: ||' OKI_MEASURE_6
2155: ,(case when cal_start_date = &BIS_CURRENT_EFFECTIVE_START_DATE
2156: then nvl(c_f_f_amt_xed,0) + nvl(c_g_r_amt_xtd,0) else NULL
2157: END) OKI_MEASURE_4