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_SCM_PKG dependencies on OKI_DBI_UTIL_PVT

Line 36: OKI_DBI_UTIL_PVT.get_parameter_values(p_page_parameter_tbl, l_view_by, l_period_type, l_org, l_comparison_type, l_xtd,l_as_of_date, l_cur_suffix,l_pattern,l_period_type_id,l_period_code);

32:
33: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
34: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
35:
36: OKI_DBI_UTIL_PVT.get_parameter_values(p_page_parameter_tbl, l_view_by, l_period_type, l_org, l_comparison_type, l_xtd,l_as_of_date, l_cur_suffix,l_pattern,l_period_type_id,l_period_code);
37:
38: l_nw_amt := 's_nw_amt_'|| l_cur_suffix;
39: l_rn_amt := 's_rn_amt_'|| l_cur_suffix;
40: l_x_amt := 'x_amt_'|| l_cur_suffix;

Line 44: l_org_where := OKI_DBI_UTIL_PVT.get_org_where('ORGANIZATION',l_org);

40: l_x_amt := 'x_amt_'|| l_cur_suffix;
41: l_t_amt := 't_amt_'|| l_cur_suffix;
42: l_bgn_k_amt := 'bgn_k_amt_' || l_cur_suffix;
43:
44: l_org_where := OKI_DBI_UTIL_PVT.get_org_where('ORGANIZATION',l_org);
45:
46: -- Beginning Balance
47:
48: l_ytd_sql := '( SELECT fact.authoring_org_id org_id

Line 209: l_custom_rec.attribute_value := oki_dbi_util_pvt.get_sec_profile;

205:
206: x_custom_sql := '/* OKI_DBI_BAL_KPI */' || l_SQLText;
207:
208: l_custom_rec.attribute_name := '&SEC_ID';
209: l_custom_rec.attribute_value := oki_dbi_util_pvt.get_sec_profile;
210: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
211: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
212: x_custom_output.EXTEND;
213: x_custom_output(x_custom_output.COUNT) := l_custom_rec;

Line 251: OKI_DBI_UTIL_PVT.get_parameter_values(p_page_parameter_tbl, l_view_by, l_period_type, l_org, l_comparison_type, l_xtd,l_as_of_date, l_cur_suffix,l_pattern,l_period_type_id,l_period_code);

247:
248: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
249: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
250:
251: OKI_DBI_UTIL_PVT.get_parameter_values(p_page_parameter_tbl, l_view_by, l_period_type, l_org, l_comparison_type, l_xtd,l_as_of_date, l_cur_suffix,l_pattern,l_period_type_id,l_period_code);
252:
253: l_nw_amt := 's_nw_amt_'|| l_cur_suffix;
254: l_rn_amt := 's_rn_amt_'|| l_cur_suffix;
255: l_x_amt := 'x_amt_'|| l_cur_suffix;

Line 264: l_org_where := OKI_DBI_UTIL_PVT.get_org_where('ORGANIZATION',l_org);

260: l_xrgr_amt := 'x_rgr_amt_'|| l_cur_suffix; -- Current ren rate
261: l_xrgrn_amt := 'x_rgr_amt_n_'|| l_period_code || '_' || l_cur_suffix;
262:
263:
264: l_org_where := OKI_DBI_UTIL_PVT.get_org_where('ORGANIZATION',l_org);
265:
266: l_cur_sql :=
267: '(SELECT fact.authoring_org_id org_id
268: -- Current values

Line 411: l_custom_rec.attribute_value := oki_dbi_util_pvt.get_sec_profile;

407:
408: x_custom_sql := '/* OKI_DBI_OTHERS_KPI */' || l_sqltext;
409:
410: l_custom_rec.attribute_name := '&SEC_ID';
411: l_custom_rec.attribute_value := oki_dbi_util_pvt.get_sec_profile;
412: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
413: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
414: x_custom_output.EXTEND;
415: x_custom_output(x_custom_output.COUNT) := l_custom_rec;

Line 454: OKI_DBI_UTIL_PVT.get_parameter_values(p_page_parameter_tbl, l_view_by, l_period_type, l_org, l_comparison_type, l_xtd,l_as_of_date, l_cur_suffix,l_pattern,l_period_type_id,l_period_code);

450:
451: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
452: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
453:
454: OKI_DBI_UTIL_PVT.get_parameter_values(p_page_parameter_tbl, l_view_by, l_period_type, l_org, l_comparison_type, l_xtd,l_as_of_date, l_cur_suffix,l_pattern,l_period_type_id,l_period_code);
455:
456: l_x_amt := 'x_amt_'|| l_cur_suffix;
457: l_xrgr_amt := 'x_rgr_amt_'|| l_cur_suffix; -- Current ren rate
458: l_xrgrn_amt := 'x_rgr_amt_n_'|| l_period_code || '_' || l_cur_suffix;

Line 468: l_org_where := OKI_DBI_UTIL_PVT.get_org_where('ORGANIZATION',l_org);

464: --OKI_DBIDEBUG_PVT.g_portal_name := 'OKI_DBI_BAL';
465: OKI_DBIDEBUG_PVT.check_portal_param('OKI_DBI_BAL',p_page_parameter_tbl);
466: */
467:
468: l_org_where := OKI_DBI_UTIL_PVT.get_org_where('ORGANIZATION',l_org);
469:
470: l_itd := '(select mv.authoring_org_id org_id
471: ,SUM(DECODE (t.report_date,&BIS_CURRENT_ASOF_DATE-1,'||l_B_amt||',0)) cblog
472: ,SUM(DECODE (t.report_date,&BIS_PREVIOUS_ASOF_DATE-1,'||l_B_amt||',0)) pblog

Line 586: l_custom_rec.attribute_value := oki_dbi_util_pvt.get_sec_profile;

582:
583: x_custom_sql := '/* OKI_DBI_RATES_KPI */' || l_sqltext;
584:
585: l_custom_rec.attribute_name := '&SEC_ID';
586: l_custom_rec.attribute_value := oki_dbi_util_pvt.get_sec_profile;
587: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
588: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
589: x_custom_output.EXTEND;
590: x_custom_output(x_custom_output.COUNT) := l_custom_rec;

Line 635: OKI_DBI_UTIL_PVT.get_parameter_values(p_page_parameter_tbl, l_view_by, l_period, l_org, l_comparison_type, l_xtd,l_as_of_date, l_cur_suffix,l_pattern,l_period_type_id,l_period_code);

631:
632: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
633: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
634:
635: OKI_DBI_UTIL_PVT.get_parameter_values(p_page_parameter_tbl, l_view_by, l_period, l_org, l_comparison_type, l_xtd,l_as_of_date, l_cur_suffix,l_pattern,l_period_type_id,l_period_code);
636:
637: /* DEBUG
638: OKI_DBI_DEBUG_PVT.g_portal_name := 'OKI_DBI_BAL_TRND';
639: OKI_DBI_DEBUG_PVT.check_portal_param(p_page_parameter_tbl);

Line 649: l_org_where := OKI_DBI_UTIL_PVT.get_org_where('ORGANIZATION',l_org);

645: l_t_amt := 't_amt_'|| l_cur_suffix;
646: l_bgn_k_amt := 'bgn_k_amt_' || l_cur_suffix;
647:
648:
649: l_org_where := OKI_DBI_UTIL_PVT.get_org_where('ORGANIZATION',l_org);
650:
651: /* brrao modified -- as this is failing for the join clause with fii_time */
652:
653: l_org_where_value := l_org_where ;

Line 779: oki_dbi_util_pvt.change_clause('cbalance','pbalance') || ' OKI_MEASURE_2,

775: -- NVL(pbalance, 0) OKI_MEASURE_2,
776:
777: l_SQLText := 'select curr_bal.name VIEWBY,
778: NVL(pbalance, 0) OKI_MEASURE_1,' ||
779: oki_dbi_util_pvt.change_clause('cbalance','pbalance') || ' OKI_MEASURE_2,
780: NVL(cbalance, 0) OKI_MEASURE_3
781: from
782: ( select xtd.name
783: , NVL(begbal.curbal, 0) + NVL(xtd.c_sum, 0) cbalance

Line 798: l_custom_rec.attribute_value := oki_dbi_util_pvt.get_sec_profile;

794: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
795:
796:
797: l_custom_rec.attribute_name := '&SEC_ID';
798: l_custom_rec.attribute_value := oki_dbi_util_pvt.get_sec_profile;
799: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
800: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
801: x_custom_output.EXTEND;
802: x_custom_output(x_custom_output.COUNT) := l_custom_rec;