DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_DTL_SALARY dependencies on BIS_PMV_PARAMETERS_PUB

Line 43: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

39:
40: BEGIN
41:
42: /* Initialize table/record variables */
43: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
44: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
45:
46: /* Set drill URLS */
47: l_lnk_emp_name := p_lnk_emp_name;

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

203: x_custom_sql := l_sqltext;
204:
205: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
206: l_custom_rec.attribute_value := p_parameter_rec.currency_code;
207: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
208: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
209: x_custom_output.extend;
210: x_custom_output(1) := l_custom_rec;
211:

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

204:
205: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
206: l_custom_rec.attribute_value := p_parameter_rec.currency_code;
207: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
208: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
209: x_custom_output.extend;
210: x_custom_output(1) := l_custom_rec;
211:
212: l_custom_rec.attribute_name := ':GLOBAL_RATE';

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

210: x_custom_output(1) := l_custom_rec;
211:
212: l_custom_rec.attribute_name := ':GLOBAL_RATE';
213: l_custom_rec.attribute_value := p_parameter_rec.rate_type;
214: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
215: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
216: x_custom_output.extend;
217: x_custom_output(2) := l_custom_rec;
218:

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

211:
212: l_custom_rec.attribute_name := ':GLOBAL_RATE';
213: l_custom_rec.attribute_value := p_parameter_rec.rate_type;
214: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
215: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
216: x_custom_output.extend;
217: x_custom_output(2) := l_custom_rec;
218:
219: l_custom_rec.attribute_name := ':POW_FACTOR';

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

217: x_custom_output(2) := l_custom_rec;
218:
219: l_custom_rec.attribute_name := ':POW_FACTOR';
220: l_custom_rec.attribute_value := l_pow_factor;
221: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
222: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
223: x_custom_output.extend;
224: x_custom_output(3) := l_custom_rec;
225:

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

218:
219: l_custom_rec.attribute_name := ':POW_FACTOR';
220: l_custom_rec.attribute_value := l_pow_factor;
221: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
222: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
223: x_custom_output.extend;
224: x_custom_output(3) := l_custom_rec;
225:
226: END get_salary_detail_directs;

Line 260: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

256:
257: BEGIN
258:
259: /* Initialize table/record variables */
260: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
261: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
262:
263: /* Set drill URLS */
264: l_lnk_emp_name := p_lnk_emp_name;

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

388: x_custom_sql := l_sqltext;
389:
390: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
391: l_custom_rec.attribute_value := p_parameter_rec.currency_code;
392: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
393: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
394: x_custom_output.extend;
395: x_custom_output(1) := l_custom_rec;
396:

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

389:
390: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
391: l_custom_rec.attribute_value := p_parameter_rec.currency_code;
392: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
393: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
394: x_custom_output.extend;
395: x_custom_output(1) := l_custom_rec;
396:
397: l_custom_rec.attribute_name := ':GLOBAL_RATE';

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

395: x_custom_output(1) := l_custom_rec;
396:
397: l_custom_rec.attribute_name := ':GLOBAL_RATE';
398: l_custom_rec.attribute_value := p_parameter_rec.rate_type;
399: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
400: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
401: x_custom_output.extend;
402: x_custom_output(2) := l_custom_rec;
403:

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

396:
397: l_custom_rec.attribute_name := ':GLOBAL_RATE';
398: l_custom_rec.attribute_value := p_parameter_rec.rate_type;
399: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
400: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
401: x_custom_output.extend;
402: x_custom_output(2) := l_custom_rec;
403:
404: l_custom_rec.attribute_name := ':POW_FACTOR';

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

402: x_custom_output(2) := l_custom_rec;
403:
404: l_custom_rec.attribute_name := ':POW_FACTOR';
405: l_custom_rec.attribute_value := l_pow_factor;
406: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
407: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
408: x_custom_output.extend;
409: x_custom_output(3) := l_custom_rec;
410:

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

403:
404: l_custom_rec.attribute_name := ':POW_FACTOR';
405: l_custom_rec.attribute_value := l_pow_factor;
406: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
407: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
408: x_custom_output.extend;
409: x_custom_output(3) := l_custom_rec;
410:
411: END get_salary_detail_all;

Line 509: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

505:
506: BEGIN
507:
508: /* Initialize table/record variables */
509: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
510: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
511:
512: /* Get common parameter values */
513: hri_oltp_pmv_util_param.get_parameters_from_table