APPS.HRI_OLTP_PMV_WMV_SAL_CTR_SUP dependencies on BIS_PMV_PARAMETERS_PUB

Line 35: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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

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

181: x_custom_sql := l_SQLText;
182:
183: l_custom_rec.attribute_name := ':HRI_NO_COUNTRIES_TO_SHOW';
184: l_custom_rec.attribute_value := g_no_countries_to_show;
185: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
186: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
187: x_custom_output.extend;
188: x_custom_output(1) := l_custom_rec;
189:

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

182:
183: l_custom_rec.attribute_name := ':HRI_NO_COUNTRIES_TO_SHOW';
184: l_custom_rec.attribute_value := g_no_countries_to_show;
185: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
186: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
187: x_custom_output.extend;
188: x_custom_output(1) := l_custom_rec;
189:
190: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';

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

188: x_custom_output(1) := l_custom_rec;
189:
190: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
191: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
192: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
193: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
194: x_custom_output.extend;
195: x_custom_output(2) := l_custom_rec;
196:

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

189:
190: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
191: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
192: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
193: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
194: x_custom_output.extend;
195: x_custom_output(2) := l_custom_rec;
196:
197: l_custom_rec.attribute_name := ':GLOBAL_RATE';

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

195: x_custom_output(2) := l_custom_rec;
196:
197: l_custom_rec.attribute_name := ':GLOBAL_RATE';
198: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
199: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
200: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
201: x_custom_output.extend;
202: x_custom_output(3) := l_custom_rec;
203:

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

196:
197: l_custom_rec.attribute_name := ':GLOBAL_RATE';
198: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
199: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
200: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
201: x_custom_output.extend;
202: x_custom_output(3) := l_custom_rec;
203:
204: END get_sql2;