17:
18: BEGIN
19:
20: /* Initialize out parameters */
21: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
22: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
23:
24: /* Get common parameter values */
25: hri_oltp_pmv_util_param.get_parameters_from_table
139: x_custom_sql := l_SQL_Text;
140:
141: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
142: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
143: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
144: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
145: x_custom_output.extend;
146: x_custom_output(1) := l_custom_rec;
147:
140:
141: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
142: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
143: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
144: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
145: x_custom_output.extend;
146: x_custom_output(1) := l_custom_rec;
147:
148: l_custom_rec.attribute_name := ':GLOBAL_RATE';
146: x_custom_output(1) := l_custom_rec;
147:
148: l_custom_rec.attribute_name := ':GLOBAL_RATE';
149: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
150: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
151: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
152: x_custom_output.extend;
153: x_custom_output(2) := l_custom_rec;
154: --
147:
148: l_custom_rec.attribute_name := ':GLOBAL_RATE';
149: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
150: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
151: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
152: x_custom_output.extend;
153: x_custom_output(2) := l_custom_rec;
154: --
155: END get_sql2;