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_TRN_SUP_BCKT dependencies on BIS_PMV_PARAMETERS_PUB

Line 82: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

78: l_comp_term_hdc_na NUMBER;
79:
80: BEGIN
81: /* Initialize out parameters */
82: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
83: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
84:
85: /* Get common parameter values */
86: hri_oltp_pmv_util_param.get_parameters_from_table

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

388:
389: /* Binds Will be inserted Below */
390: l_custom_rec.attribute_name := ':HRI_CURR_TERM_HDC';
391: l_custom_rec.attribute_value := l_curr_term_hdc;
392: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
393: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_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.numeric_bind;

389: /* Binds Will be inserted Below */
390: l_custom_rec.attribute_name := ':HRI_CURR_TERM_HDC';
391: l_custom_rec.attribute_value := l_curr_term_hdc;
392: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
393: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
394: x_custom_output.extend;
395: x_custom_output(1) := l_custom_rec;
396:
397: l_custom_rec.attribute_name := ':HRI_CURR_TERM_HDC_B1';

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 := ':HRI_CURR_TERM_HDC_B1';
398: l_custom_rec.attribute_value := l_curr_term_hdc_b1;
399: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
400: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_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.numeric_bind;

396:
397: l_custom_rec.attribute_name := ':HRI_CURR_TERM_HDC_B1';
398: l_custom_rec.attribute_value := l_curr_term_hdc_b1;
399: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
400: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
401: x_custom_output.extend;
402: x_custom_output(2) := l_custom_rec;
403:
404: l_custom_rec.attribute_name := ':HRI_CURR_TERM_HDC_B2';

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 := ':HRI_CURR_TERM_HDC_B2';
405: l_custom_rec.attribute_value := l_curr_term_hdc_b2;
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 := ':HRI_CURR_TERM_HDC_B2';
405: l_custom_rec.attribute_value := l_curr_term_hdc_b2;
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: l_custom_rec.attribute_name := ':HRI_CURR_TERM_HDC_B3';

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

409: x_custom_output(3) := l_custom_rec;
410:
411: l_custom_rec.attribute_name := ':HRI_CURR_TERM_HDC_B3';
412: l_custom_rec.attribute_value := l_curr_term_hdc_b3;
413: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
414: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
415: x_custom_output.extend;
416: x_custom_output(4) := l_custom_rec;
417:

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

410:
411: l_custom_rec.attribute_name := ':HRI_CURR_TERM_HDC_B3';
412: l_custom_rec.attribute_value := l_curr_term_hdc_b3;
413: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
414: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
415: x_custom_output.extend;
416: x_custom_output(4) := l_custom_rec;
417:
418: l_custom_rec.attribute_name := ':HRI_CURR_TERM_HDC_NA';

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

416: x_custom_output(4) := l_custom_rec;
417:
418: l_custom_rec.attribute_name := ':HRI_CURR_TERM_HDC_NA';
419: l_custom_rec.attribute_value := l_curr_term_hdc_na;
420: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
421: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
422: x_custom_output.extend;
423: x_custom_output(5) := l_custom_rec;
424:

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

417:
418: l_custom_rec.attribute_name := ':HRI_CURR_TERM_HDC_NA';
419: l_custom_rec.attribute_value := l_curr_term_hdc_na;
420: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
421: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
422: x_custom_output.extend;
423: x_custom_output(5) := l_custom_rec;
424:
425: l_custom_rec.attribute_name := ':HRI_COMP_TERM_HDC';

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

423: x_custom_output(5) := l_custom_rec;
424:
425: l_custom_rec.attribute_name := ':HRI_COMP_TERM_HDC';
426: l_custom_rec.attribute_value := l_comp_term_hdc;
427: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
428: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
429: x_custom_output.extend;
430: x_custom_output(6) := l_custom_rec;
431:

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

424:
425: l_custom_rec.attribute_name := ':HRI_COMP_TERM_HDC';
426: l_custom_rec.attribute_value := l_comp_term_hdc;
427: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
428: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
429: x_custom_output.extend;
430: x_custom_output(6) := l_custom_rec;
431:
432: l_custom_rec.attribute_name := ':HRI_COMP_TERM_HDC_B1';

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

430: x_custom_output(6) := l_custom_rec;
431:
432: l_custom_rec.attribute_name := ':HRI_COMP_TERM_HDC_B1';
433: l_custom_rec.attribute_value := l_comp_term_hdc_b1;
434: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
435: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
436: x_custom_output.extend;
437: x_custom_output(7) := l_custom_rec;
438:

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

431:
432: l_custom_rec.attribute_name := ':HRI_COMP_TERM_HDC_B1';
433: l_custom_rec.attribute_value := l_comp_term_hdc_b1;
434: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
435: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
436: x_custom_output.extend;
437: x_custom_output(7) := l_custom_rec;
438:
439: l_custom_rec.attribute_name := ':HRI_COMP_TERM_HDC_B2';

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

437: x_custom_output(7) := l_custom_rec;
438:
439: l_custom_rec.attribute_name := ':HRI_COMP_TERM_HDC_B2';
440: l_custom_rec.attribute_value := l_comp_term_hdc_b2;
441: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
442: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
443: x_custom_output.extend;
444: x_custom_output(8) := l_custom_rec;
445:

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

438:
439: l_custom_rec.attribute_name := ':HRI_COMP_TERM_HDC_B2';
440: l_custom_rec.attribute_value := l_comp_term_hdc_b2;
441: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
442: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
443: x_custom_output.extend;
444: x_custom_output(8) := l_custom_rec;
445:
446: l_custom_rec.attribute_name := ':HRI_COMP_TERM_HDC_B3';

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

444: x_custom_output(8) := l_custom_rec;
445:
446: l_custom_rec.attribute_name := ':HRI_COMP_TERM_HDC_B3';
447: l_custom_rec.attribute_value := l_comp_term_hdc_b3;
448: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
449: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
450: x_custom_output.extend;
451: x_custom_output(9) := l_custom_rec;
452:

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

445:
446: l_custom_rec.attribute_name := ':HRI_COMP_TERM_HDC_B3';
447: l_custom_rec.attribute_value := l_comp_term_hdc_b3;
448: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
449: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
450: x_custom_output.extend;
451: x_custom_output(9) := l_custom_rec;
452:
453: l_custom_rec.attribute_name := ':HRI_COMP_TERM_HDC_NA';

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

451: x_custom_output(9) := l_custom_rec;
452:
453: l_custom_rec.attribute_name := ':HRI_COMP_TERM_HDC_NA';
454: l_custom_rec.attribute_value := l_comp_term_hdc_na;
455: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
456: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
457: x_custom_output.extend;
458: x_custom_output(10) := l_custom_rec;
459:

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

452:
453: l_custom_rec.attribute_name := ':HRI_COMP_TERM_HDC_NA';
454: l_custom_rec.attribute_value := l_comp_term_hdc_na;
455: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
456: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
457: x_custom_output.extend;
458: x_custom_output(10) := l_custom_rec;
459:
460: END GET_SQL_BKCT_PERF;

Line 511: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

507:
508: BEGIN
509:
510: /* Initialize out parameters */
511: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
512: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
513:
514: /* Get common parameter values */
515: hri_oltp_pmv_util_param.get_parameters_from_table

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

775: --l_parameter_rec.debug_header || l_SQLText;
776:
777: l_custom_rec.attribute_name := ':HRI_TOT_TERM_HDC';
778: l_custom_rec.attribute_value := l_term_hdc;
779: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
780: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
781: x_custom_output.extend;
782: x_custom_output(1) := l_custom_rec;
783:

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

776:
777: l_custom_rec.attribute_name := ':HRI_TOT_TERM_HDC';
778: l_custom_rec.attribute_value := l_term_hdc;
779: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
780: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
781: x_custom_output.extend;
782: x_custom_output(1) := l_custom_rec;
783:
784: l_custom_rec.attribute_name := ':HRI_TOT_TERM_HDC_B1';

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

782: x_custom_output(1) := l_custom_rec;
783:
784: l_custom_rec.attribute_name := ':HRI_TOT_TERM_HDC_B1';
785: l_custom_rec.attribute_value := l_term_hdc_b1;
786: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
787: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
788: x_custom_output.extend;
789: x_custom_output(2) := l_custom_rec;
790:

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

783:
784: l_custom_rec.attribute_name := ':HRI_TOT_TERM_HDC_B1';
785: l_custom_rec.attribute_value := l_term_hdc_b1;
786: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
787: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
788: x_custom_output.extend;
789: x_custom_output(2) := l_custom_rec;
790:
791: l_custom_rec.attribute_name := ':HRI_TOT_TERM_HDC_B2';

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

789: x_custom_output(2) := l_custom_rec;
790:
791: l_custom_rec.attribute_name := ':HRI_TOT_TERM_HDC_B2';
792: l_custom_rec.attribute_value := l_term_hdc_b2;
793: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
794: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
795: x_custom_output.extend;
796: x_custom_output(3) := l_custom_rec;
797:

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

790:
791: l_custom_rec.attribute_name := ':HRI_TOT_TERM_HDC_B2';
792: l_custom_rec.attribute_value := l_term_hdc_b2;
793: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
794: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
795: x_custom_output.extend;
796: x_custom_output(3) := l_custom_rec;
797:
798: l_custom_rec.attribute_name := ':HRI_TOT_TERM_HDC_B3';

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

796: x_custom_output(3) := l_custom_rec;
797:
798: l_custom_rec.attribute_name := ':HRI_TOT_TERM_HDC_B3';
799: l_custom_rec.attribute_value := l_term_hdc_b3;
800: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
801: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
802: x_custom_output.extend;
803: x_custom_output(4) := l_custom_rec;
804:

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

797:
798: l_custom_rec.attribute_name := ':HRI_TOT_TERM_HDC_B3';
799: l_custom_rec.attribute_value := l_term_hdc_b3;
800: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
801: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
802: x_custom_output.extend;
803: x_custom_output(4) := l_custom_rec;
804:
805: l_custom_rec.attribute_name := ':HRI_TOT_TERM_HDC_B4';

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

803: x_custom_output(4) := l_custom_rec;
804:
805: l_custom_rec.attribute_name := ':HRI_TOT_TERM_HDC_B4';
806: l_custom_rec.attribute_value := l_term_hdc_b4;
807: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
808: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
809: x_custom_output.extend;
810: x_custom_output(5) := l_custom_rec;
811:

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

804:
805: l_custom_rec.attribute_name := ':HRI_TOT_TERM_HDC_B4';
806: l_custom_rec.attribute_value := l_term_hdc_b4;
807: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
808: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
809: x_custom_output.extend;
810: x_custom_output(5) := l_custom_rec;
811:
812: l_custom_rec.attribute_name := ':HRI_TOT_TERM_HDC_B5';

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

810: x_custom_output(5) := l_custom_rec;
811:
812: l_custom_rec.attribute_name := ':HRI_TOT_TERM_HDC_B5';
813: l_custom_rec.attribute_value := l_term_hdc_b5;
814: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
815: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
816: x_custom_output.extend;
817: x_custom_output(6) := l_custom_rec;
818:

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

811:
812: l_custom_rec.attribute_name := ':HRI_TOT_TERM_HDC_B5';
813: l_custom_rec.attribute_value := l_term_hdc_b5;
814: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
815: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
816: x_custom_output.extend;
817: x_custom_output(6) := l_custom_rec;
818:
819: END GET_TRN_POW_SQL;

Line 863: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

859: --
860: BEGIN
861: --
862: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
863: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
864: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
865: --
866: -- Get the parameter information from the page parameter table
867: --