DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_GAIN_HIRE_PVT dependencies on BIS_PMV_PARAMETERS_PUB

Line 21: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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

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

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:

Line 144: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

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';

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

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: --

Line 151: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

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;