eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_OLTP_PMV_WMV_WF_SUP dependencies on BIS_PMV_PARAMETERS_PUB

Line 32: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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

Line 149: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

145:
146: BEGIN
147:
148: /* Initialize out parameters */
149: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
150: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
151:
152: /* Get common parameter values */
153: hri_oltp_pmv_util_param.get_parameters_from_table

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

377: /* Total not yet code for */
378:
379: l_custom_rec.attribute_name := ':HRI_TOT_GAIN_HIRE';
380: l_custom_rec.attribute_value := l_tot_gain_hire;
381: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
382: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
383: x_custom_output.extend;
384: x_custom_output(1) := l_custom_rec;
385:

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

378:
379: l_custom_rec.attribute_name := ':HRI_TOT_GAIN_HIRE';
380: l_custom_rec.attribute_value := l_tot_gain_hire;
381: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
382: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
383: x_custom_output.extend;
384: x_custom_output(1) := l_custom_rec;
385:
386: l_custom_rec.attribute_name := ':HRI_TOT_GAIN_PLACE';

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

384: x_custom_output(1) := l_custom_rec;
385:
386: l_custom_rec.attribute_name := ':HRI_TOT_GAIN_PLACE';
387: l_custom_rec.attribute_value := l_tot_gain_place;
388: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
389: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
390: x_custom_output.extend;
391: x_custom_output(2) := l_custom_rec;
392:

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

385:
386: l_custom_rec.attribute_name := ':HRI_TOT_GAIN_PLACE';
387: l_custom_rec.attribute_value := l_tot_gain_place;
388: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
389: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
390: x_custom_output.extend;
391: x_custom_output(2) := l_custom_rec;
392:
393: l_custom_rec.attribute_name := ':HRI_TOT_GAIN_TRANSFER';

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

391: x_custom_output(2) := l_custom_rec;
392:
393: l_custom_rec.attribute_name := ':HRI_TOT_GAIN_TRANSFER';
394: l_custom_rec.attribute_value := l_tot_gain_transfer_all;
395: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
396: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
397: x_custom_output.extend;
398: x_custom_output(3) := l_custom_rec;
399:

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

392:
393: l_custom_rec.attribute_name := ':HRI_TOT_GAIN_TRANSFER';
394: l_custom_rec.attribute_value := l_tot_gain_transfer_all;
395: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
396: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
397: x_custom_output.extend;
398: x_custom_output(3) := l_custom_rec;
399:
400: l_custom_rec.attribute_name := ':HRI_TOT_LOSS_TERM';

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

398: x_custom_output(3) := l_custom_rec;
399:
400: l_custom_rec.attribute_name := ':HRI_TOT_LOSS_TERM';
401: l_custom_rec.attribute_value := l_tot_loss_term;
402: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
403: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
404: x_custom_output.extend;
405: x_custom_output(4) := l_custom_rec;
406:

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

399:
400: l_custom_rec.attribute_name := ':HRI_TOT_LOSS_TERM';
401: l_custom_rec.attribute_value := l_tot_loss_term;
402: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
403: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
404: x_custom_output.extend;
405: x_custom_output(4) := l_custom_rec;
406:
407: l_custom_rec.attribute_name := ':HRI_TOT_LOSS_PLACE';

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

405: x_custom_output(4) := l_custom_rec;
406:
407: l_custom_rec.attribute_name := ':HRI_TOT_LOSS_PLACE';
408: l_custom_rec.attribute_value := l_tot_loss_place;
409: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
410: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
411: x_custom_output.extend;
412: x_custom_output(5) := l_custom_rec;
413:

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

406:
407: l_custom_rec.attribute_name := ':HRI_TOT_LOSS_PLACE';
408: l_custom_rec.attribute_value := l_tot_loss_place;
409: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
410: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
411: x_custom_output.extend;
412: x_custom_output(5) := l_custom_rec;
413:
414: l_custom_rec.attribute_name := ':HRI_TOT_LOSS_TRANSFER';

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

412: x_custom_output(5) := l_custom_rec;
413:
414: l_custom_rec.attribute_name := ':HRI_TOT_LOSS_TRANSFER';
415: l_custom_rec.attribute_value := l_tot_loss_transfer_all;
416: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
417: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
418: x_custom_output.extend;
419: x_custom_output(6) := l_custom_rec;
420:

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

413:
414: l_custom_rec.attribute_name := ':HRI_TOT_LOSS_TRANSFER';
415: l_custom_rec.attribute_value := l_tot_loss_transfer_all;
416: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
417: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
418: x_custom_output.extend;
419: x_custom_output(6) := l_custom_rec;
420:
421: l_custom_rec.attribute_name := ':HRI_TOT_NET_GAIN_LOSS';

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

419: x_custom_output(6) := l_custom_rec;
420:
421: l_custom_rec.attribute_name := ':HRI_TOT_NET_GAIN_LOSS';
422: l_custom_rec.attribute_value := l_tot_net;
423: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
424: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
425: x_custom_output.extend;
426: x_custom_output(7) := l_custom_rec;
427:

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

420:
421: l_custom_rec.attribute_name := ':HRI_TOT_NET_GAIN_LOSS';
422: l_custom_rec.attribute_value := l_tot_net;
423: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
424: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
425: x_custom_output.extend;
426: x_custom_output(7) := l_custom_rec;
427:
428: END get_sql;