DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_TRN_SUMMRY dependencies on BIS_PMV_PARAMETERS_PUB

Line 170: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

166:
167: BEGIN
168:
169: /* Initialize out parameters */
170: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
171: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
172:
173: /* Get common parameter values */
174: hri_oltp_pmv_util_param.get_parameters_from_table

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

393: x_custom_sql := l_SQLText;
394:
395: l_custom_rec.attribute_name := ':HRI_ANL_FACTOR';
396: l_custom_rec.attribute_value := l_calc_anl_factor;
397: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
398: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
399: x_custom_output.extend;
400: x_custom_output(1) := l_custom_rec;
401:

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

394:
395: l_custom_rec.attribute_name := ':HRI_ANL_FACTOR';
396: l_custom_rec.attribute_value := l_calc_anl_factor;
397: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
398: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
399: x_custom_output.extend;
400: x_custom_output(1) := l_custom_rec;
401:
402: l_custom_rec.attribute_name := ':HRI_CURR_TERM_VOL';

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

400: x_custom_output(1) := l_custom_rec;
401:
402: l_custom_rec.attribute_name := ':HRI_CURR_TERM_VOL';
403: l_custom_rec.attribute_value := l_curr_term_vol;
404: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
405: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
406: x_custom_output.extend;
407: x_custom_output(2) := l_custom_rec;
408:

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

401:
402: l_custom_rec.attribute_name := ':HRI_CURR_TERM_VOL';
403: l_custom_rec.attribute_value := l_curr_term_vol;
404: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
405: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
406: x_custom_output.extend;
407: x_custom_output(2) := l_custom_rec;
408:
409: l_custom_rec.attribute_name := ':HRI_CURR_TERM_INVOL';

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

407: x_custom_output(2) := l_custom_rec;
408:
409: l_custom_rec.attribute_name := ':HRI_CURR_TERM_INVOL';
410: l_custom_rec.attribute_value := l_curr_term_invol;
411: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
412: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
413: x_custom_output.extend;
414: x_custom_output(3) := l_custom_rec;
415:

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

408:
409: l_custom_rec.attribute_name := ':HRI_CURR_TERM_INVOL';
410: l_custom_rec.attribute_value := l_curr_term_invol;
411: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
412: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
413: x_custom_output.extend;
414: x_custom_output(3) := l_custom_rec;
415:
416: l_custom_rec.attribute_name := ':HRI_COMP_TERM_VOL';

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

414: x_custom_output(3) := l_custom_rec;
415:
416: l_custom_rec.attribute_name := ':HRI_COMP_TERM_VOL';
417: l_custom_rec.attribute_value := l_comp_term_vol;
418: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
419: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
420: x_custom_output.extend;
421: x_custom_output(4) := l_custom_rec;
422:

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

415:
416: l_custom_rec.attribute_name := ':HRI_COMP_TERM_VOL';
417: l_custom_rec.attribute_value := l_comp_term_vol;
418: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
419: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
420: x_custom_output.extend;
421: x_custom_output(4) := l_custom_rec;
422:
423: l_custom_rec.attribute_name := ':HRI_COMP_TERM_INVOL';

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

421: x_custom_output(4) := l_custom_rec;
422:
423: l_custom_rec.attribute_name := ':HRI_COMP_TERM_INVOL';
424: l_custom_rec.attribute_value := l_comp_term_invol;
425: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
426: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
427: x_custom_output.extend;
428: x_custom_output(5) := l_custom_rec;
429:

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

422:
423: l_custom_rec.attribute_name := ':HRI_COMP_TERM_INVOL';
424: l_custom_rec.attribute_value := l_comp_term_invol;
425: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
426: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
427: x_custom_output.extend;
428: x_custom_output(5) := l_custom_rec;
429:
430: END get_sql_pvt;