DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_SUP dependencies on BIS_PMV_PARAMETERS_PUB

Line 54: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

50:
51: BEGIN
52:
53: /* Initialize out parameters */
54: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
55: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
56:
57: /* Get common parameter values */
58: hri_oltp_pmv_util_param.get_parameters_from_table

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

264: x_custom_sql := l_SQLText;
265:
266: l_custom_rec.attribute_name := ':HRI_TOT_GAIN_HIRE';
267: l_custom_rec.attribute_value := l_tot_gain_hire;
268: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
269: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
270: x_custom_output.extend;
271: x_custom_output(1) := l_custom_rec;
272:

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

265:
266: l_custom_rec.attribute_name := ':HRI_TOT_GAIN_HIRE';
267: l_custom_rec.attribute_value := l_tot_gain_hire;
268: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
269: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
270: x_custom_output.extend;
271: x_custom_output(1) := l_custom_rec;
272:
273: l_custom_rec.attribute_name := ':HRI_TOT_GAIN_TRANSFER';

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

271: x_custom_output(1) := l_custom_rec;
272:
273: l_custom_rec.attribute_name := ':HRI_TOT_GAIN_TRANSFER';
274: l_custom_rec.attribute_value := l_tot_gain_transfer;
275: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
276: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
277: x_custom_output.extend;
278: x_custom_output(2) := l_custom_rec;
279:

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

272:
273: l_custom_rec.attribute_name := ':HRI_TOT_GAIN_TRANSFER';
274: l_custom_rec.attribute_value := l_tot_gain_transfer;
275: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
276: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
277: x_custom_output.extend;
278: x_custom_output(2) := l_custom_rec;
279:
280: l_custom_rec.attribute_name := ':HRI_TOT_LOSS_TERM';

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

278: x_custom_output(2) := l_custom_rec;
279:
280: l_custom_rec.attribute_name := ':HRI_TOT_LOSS_TERM';
281: l_custom_rec.attribute_value := l_tot_loss_term;
282: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
283: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
284: x_custom_output.extend;
285: x_custom_output(3) := l_custom_rec;
286:

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

279:
280: l_custom_rec.attribute_name := ':HRI_TOT_LOSS_TERM';
281: l_custom_rec.attribute_value := l_tot_loss_term;
282: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
283: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
284: x_custom_output.extend;
285: x_custom_output(3) := l_custom_rec;
286:
287: l_custom_rec.attribute_name := ':HRI_TOT_LOSS_TRANSFER';

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

285: x_custom_output(3) := l_custom_rec;
286:
287: l_custom_rec.attribute_name := ':HRI_TOT_LOSS_TRANSFER';
288: l_custom_rec.attribute_value := l_tot_loss_transfer;
289: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
290: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
291: x_custom_output.extend;
292: x_custom_output(4) := l_custom_rec;
293:

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

286:
287: l_custom_rec.attribute_name := ':HRI_TOT_LOSS_TRANSFER';
288: l_custom_rec.attribute_value := l_tot_loss_transfer;
289: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
290: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
291: x_custom_output.extend;
292: x_custom_output(4) := l_custom_rec;
293:
294: l_custom_rec.attribute_name := ':HRI_TOT_NET_GAIN_LOSS';

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

292: x_custom_output(4) := l_custom_rec;
293:
294: l_custom_rec.attribute_name := ':HRI_TOT_NET_GAIN_LOSS';
295: l_custom_rec.attribute_value := l_tot_net;
296: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
297: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
298: x_custom_output.extend;
299: x_custom_output(5) := l_custom_rec;
300:

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

293:
294: l_custom_rec.attribute_name := ':HRI_TOT_NET_GAIN_LOSS';
295: l_custom_rec.attribute_value := l_tot_net;
296: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
297: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
298: x_custom_output.extend;
299: x_custom_output(5) := l_custom_rec;
300:
301: END get_sql2;

Line 341: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

337: --
338: BEGIN
339: --
340: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
341: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
342: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
343: --
344: -- Get the parameter information from the page parameter table
345: --

Line 418: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

414:
415: BEGIN
416:
417: /* Initialize out parameters */
418: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
419: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
420:
421: /* Get common parameter values */
422: hri_oltp_pmv_util_param.get_parameters_from_table

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

470: ||l_security_clause;
471:
472: l_custom_rec.attribute_name := ':MONTHS_MULTIPLIER';
473: l_custom_rec.attribute_value := 30.42;
474: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
475: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
476: x_custom_output.extend;
477: x_custom_output(1) := l_custom_rec;
478:

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

471:
472: l_custom_rec.attribute_name := ':MONTHS_MULTIPLIER';
473: l_custom_rec.attribute_value := 30.42;
474: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
475: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
476: x_custom_output.extend;
477: x_custom_output(1) := l_custom_rec;
478:
479: END get_wmv_c_low_kpi;

Line 504: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

500:
501: BEGIN
502:
503: /* Initialize out parameters */
504: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
505: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
506:
507: /* Get common parameter values */
508: hri_oltp_pmv_util_param.get_parameters_from_table