APPS.HRI_OLTP_PMV_GAIN_HIRE_SUPJOB dependencies on BIS_PMV_PARAMETERS_PUB

Line 19: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

15:
16: BEGIN
17:
18: /* Initialize out parameters */
19: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
20: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
21:
22: /* Get common parameter values */
23: hri_oltp_pmv_util_param.get_parameters_from_table

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

138: x_custom_sql := l_SQL_Text;
139:
140: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
141: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
142: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
143: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
144: x_custom_output.extend;
145: x_custom_output(1) := l_custom_rec;
146:

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

139:
140: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
141: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
142: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
143: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
144: x_custom_output.extend;
145: x_custom_output(1) := l_custom_rec;
146:
147: l_custom_rec.attribute_name := ':GLOBAL_RATE';

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

145: x_custom_output(1) := l_custom_rec;
146:
147: l_custom_rec.attribute_name := ':GLOBAL_RATE';
148: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
149: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
150: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
151: x_custom_output.extend;
152: x_custom_output(2) := l_custom_rec;
153: --

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

146:
147: l_custom_rec.attribute_name := ':GLOBAL_RATE';
148: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
149: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
150: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
151: x_custom_output.extend;
152: x_custom_output(2) := l_custom_rec;
153: --
154: END get_sql2;