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.HRI_OLTP_PMV_WMV_TRN_SUP dependencies on BIS_PMV_PARAMETERS_PUB

Line 50: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

46:
47: BEGIN
48:
49: /* Initialize out parameters */
50: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
51: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
52:
53: /* Get security clause for Manager based security */
54: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

Line 271: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

267: x_custom_sql := l_SQLText;
268:
269: l_custom_rec.attribute_name := ':HRI_ANL_FACTOR';
270: l_custom_rec.attribute_value := l_calc_anl_factor;
271: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
272: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
273: x_custom_output.extend;
274: x_custom_output(1) := l_custom_rec;
275:

Line 272: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;

268:
269: l_custom_rec.attribute_name := ':HRI_ANL_FACTOR';
270: l_custom_rec.attribute_value := l_calc_anl_factor;
271: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
272: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
273: x_custom_output.extend;
274: x_custom_output(1) := l_custom_rec;
275:
276: l_custom_rec.attribute_name := ':HRI_CURR_TERM_VOL';

Line 278: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

274: x_custom_output(1) := l_custom_rec;
275:
276: l_custom_rec.attribute_name := ':HRI_CURR_TERM_VOL';
277: l_custom_rec.attribute_value := l_curr_term_vol;
278: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
279: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
280: x_custom_output.extend;
281: x_custom_output(2) := l_custom_rec;
282:

Line 279: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;

275:
276: l_custom_rec.attribute_name := ':HRI_CURR_TERM_VOL';
277: l_custom_rec.attribute_value := l_curr_term_vol;
278: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
279: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
280: x_custom_output.extend;
281: x_custom_output(2) := l_custom_rec;
282:
283: l_custom_rec.attribute_name := ':HRI_CURR_TERM_INVOL';

Line 285: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

281: x_custom_output(2) := l_custom_rec;
282:
283: l_custom_rec.attribute_name := ':HRI_CURR_TERM_INVOL';
284: l_custom_rec.attribute_value := l_curr_term_invol;
285: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
286: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
287: x_custom_output.extend;
288: x_custom_output(3) := l_custom_rec;
289:

Line 286: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;

282:
283: l_custom_rec.attribute_name := ':HRI_CURR_TERM_INVOL';
284: l_custom_rec.attribute_value := l_curr_term_invol;
285: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
286: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
287: x_custom_output.extend;
288: x_custom_output(3) := l_custom_rec;
289:
290: l_custom_rec.attribute_name := ':HRI_COMP_TERM_VOL';

Line 292: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

288: x_custom_output(3) := l_custom_rec;
289:
290: l_custom_rec.attribute_name := ':HRI_COMP_TERM_VOL';
291: l_custom_rec.attribute_value := l_comp_term_vol;
292: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
293: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
294: x_custom_output.extend;
295: x_custom_output(4) := l_custom_rec;
296:

Line 293: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;

289:
290: l_custom_rec.attribute_name := ':HRI_COMP_TERM_VOL';
291: l_custom_rec.attribute_value := l_comp_term_vol;
292: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
293: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
294: x_custom_output.extend;
295: x_custom_output(4) := l_custom_rec;
296:
297: l_custom_rec.attribute_name := ':HRI_COMP_TERM_INVOL';

Line 299: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

295: x_custom_output(4) := l_custom_rec;
296:
297: l_custom_rec.attribute_name := ':HRI_COMP_TERM_INVOL';
298: l_custom_rec.attribute_value := l_comp_term_invol;
299: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
300: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
301: x_custom_output.extend;
302: x_custom_output(5) := l_custom_rec;
303:

Line 300: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;

296:
297: l_custom_rec.attribute_name := ':HRI_COMP_TERM_INVOL';
298: l_custom_rec.attribute_value := l_comp_term_invol;
299: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
300: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
301: x_custom_output.extend;
302: x_custom_output(5) := l_custom_rec;
303:
304: END get_sql2;

Line 386: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

382: 'HRI_P_SUPH_RO_CA=HRI_P_SUPH_RO_CA&' ||
383: 'pParamIds=Y';
384:
385: /* Initialize out parameters */
386: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
387: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
388:
389: /* Get security clause for Manager based security */
390: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

Line 574: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

570: x_custom_sql := l_SQLText;
571:
572: l_custom_rec.attribute_name := ':HRI_ANL_FACTOR';
573: l_custom_rec.attribute_value := l_calc_anl_factor;
574: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
575: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
576: x_custom_output.extend;
577: x_custom_output(1) := l_custom_rec;
578:

Line 575: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;

571:
572: l_custom_rec.attribute_name := ':HRI_ANL_FACTOR';
573: l_custom_rec.attribute_value := l_calc_anl_factor;
574: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
575: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
576: x_custom_output.extend;
577: x_custom_output(1) := l_custom_rec;
578:
579: l_custom_rec.attribute_name := ':HRI_CURR_TERM_VOL';

Line 581: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

577: x_custom_output(1) := l_custom_rec;
578:
579: l_custom_rec.attribute_name := ':HRI_CURR_TERM_VOL';
580: l_custom_rec.attribute_value := l_curr_term_vol;
581: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
582: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
583: x_custom_output.extend;
584: x_custom_output(2) := l_custom_rec;
585:

Line 582: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;

578:
579: l_custom_rec.attribute_name := ':HRI_CURR_TERM_VOL';
580: l_custom_rec.attribute_value := l_curr_term_vol;
581: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
582: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
583: x_custom_output.extend;
584: x_custom_output(2) := l_custom_rec;
585:
586: l_custom_rec.attribute_name := ':HRI_CURR_TERM_INVOL';

Line 588: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

584: x_custom_output(2) := l_custom_rec;
585:
586: l_custom_rec.attribute_name := ':HRI_CURR_TERM_INVOL';
587: l_custom_rec.attribute_value := l_curr_term_invol;
588: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
589: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
590: x_custom_output.extend;
591: x_custom_output(3) := l_custom_rec;
592:

Line 589: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;

585:
586: l_custom_rec.attribute_name := ':HRI_CURR_TERM_INVOL';
587: l_custom_rec.attribute_value := l_curr_term_invol;
588: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
589: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
590: x_custom_output.extend;
591: x_custom_output(3) := l_custom_rec;
592:
593: END get_actual_detail_sql2;

Line 636: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

632: l_dummy1 NUMBER;
633:
634: BEGIN
635: /* Initialize out parameters */
636: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
637: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
638:
639: /* Get common parameter values */
640: hri_oltp_pmv_util_param.get_parameters_from_table

Line 861: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

857:
858: /* Binds Will be inserted Below */
859: l_custom_rec.attribute_name := ':HRI_CURR_TERM_HDC';
860: l_custom_rec.attribute_value := l_curr_trn_vol + l_curr_trn_invol;
861: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
862: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
863: x_custom_output.extend;
864: x_custom_output(1) := l_custom_rec;
865:

Line 862: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;

858: /* Binds Will be inserted Below */
859: l_custom_rec.attribute_name := ':HRI_CURR_TERM_HDC';
860: l_custom_rec.attribute_value := l_curr_trn_vol + l_curr_trn_invol;
861: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
862: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
863: x_custom_output.extend;
864: x_custom_output(1) := l_custom_rec;
865:
866: l_custom_rec.attribute_name := ':HRI_PREV_TERM_HDC';

Line 868: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

864: x_custom_output(1) := l_custom_rec;
865:
866: l_custom_rec.attribute_name := ':HRI_PREV_TERM_HDC';
867: l_custom_rec.attribute_value := l_comp_trn_vol + l_comp_trn_invol;
868: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
869: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
870: x_custom_output.extend;
871: x_custom_output(2) := l_custom_rec;
872:

Line 869: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;

865:
866: l_custom_rec.attribute_name := ':HRI_PREV_TERM_HDC';
867: l_custom_rec.attribute_value := l_comp_trn_vol + l_comp_trn_invol;
868: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
869: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
870: x_custom_output.extend;
871: x_custom_output(2) := l_custom_rec;
872:
873: END GET_SQL_TRN_PVT;

Line 1023: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1019:
1020: BEGIN
1021: --
1022: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1023: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1024: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
1025: --
1026: -- Get the parameter information from the page parameter table
1027: --

Line 1138: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

1134: -- Set the annualization factor
1135: --
1136: l_custom_rec.attribute_name := ':HRI_ANL_FACTOR';
1137: l_custom_rec.attribute_value := l_calc_anl_factor;
1138: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1139: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
1140: x_custom_output.extend;
1141: x_custom_output(1) := l_custom_rec;
1142: --

Line 1139: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;

1135: --
1136: l_custom_rec.attribute_name := ':HRI_ANL_FACTOR';
1137: l_custom_rec.attribute_value := l_calc_anl_factor;
1138: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1139: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
1140: x_custom_output.extend;
1141: x_custom_output(1) := l_custom_rec;
1142: --
1143: END get_wmv_trn_kpi;