APPS.HRI_OLTP_PMV_WMV_SAL_SUP dependencies on BIS_PMV_PARAMETERS_PUB

Line 34: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

30:
31: BEGIN
32:
33: /* Initialize out parameters */
34: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
35: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
36:
37: /* Get security clause for Manager based security */
38: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

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

166: x_custom_sql := l_SQLText;
167:
168: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
169: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
170: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
171: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
172: x_custom_output.extend;
173: x_custom_output(1) := l_custom_rec;
174:

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

167:
168: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
169: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
170: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
171: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
172: x_custom_output.extend;
173: x_custom_output(1) := l_custom_rec;
174:
175: l_custom_rec.attribute_name := ':GLOBAL_RATE';

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

173: x_custom_output(1) := l_custom_rec;
174:
175: l_custom_rec.attribute_name := ':GLOBAL_RATE';
176: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
177: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
178: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
179: x_custom_output.extend;
180: x_custom_output(2) := l_custom_rec;
181:

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

174:
175: l_custom_rec.attribute_name := ':GLOBAL_RATE';
176: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
177: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
178: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
179: x_custom_output.extend;
180: x_custom_output(2) := l_custom_rec;
181:
182: END get_sql2;

Line 221: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

217: --
218: BEGIN
219: --
220: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
221: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
222: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
223: --
224: -- Get the parameter information from the page parameter table
225: --

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

271: -- Set value for global currency
272: --
273: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
274: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
275: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
276: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
277: x_custom_output.extend;
278: x_custom_output(1) := l_custom_rec;
279: --

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

272: --
273: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
274: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
275: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
276: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
277: x_custom_output.extend;
278: x_custom_output(1) := l_custom_rec;
279: --
280: -- Set the value for global rate

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

280: -- Set the value for global rate
281: --
282: l_custom_rec.attribute_name := ':GLOBAL_RATE';
283: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
284: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
285: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
286: x_custom_output.extend;
287: x_custom_output(2) := l_custom_rec;
288: --

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

281: --
282: l_custom_rec.attribute_name := ':GLOBAL_RATE';
283: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
284: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
285: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
286: x_custom_output.extend;
287: x_custom_output(2) := l_custom_rec;
288: --
289: END get_sal_kpi;