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

Line 176: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

172:
173: BEGIN
174:
175: /* Initialize out parameters */
176: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
177: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
178:
179: /* Get common parameter values */
180: hri_oltp_pmv_util_param.get_parameters_from_table

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

448: x_custom_sql := l_SQLText;
449:
450: l_custom_rec.attribute_name := ':HRI_ANL_FACTOR';
451: l_custom_rec.attribute_value := l_calc_anl_factor;
452: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
453: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
454: x_custom_output.extend;
455: x_custom_output(1) := l_custom_rec;
456:

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

449:
450: l_custom_rec.attribute_name := ':HRI_ANL_FACTOR';
451: l_custom_rec.attribute_value := l_calc_anl_factor;
452: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
453: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
454: x_custom_output.extend;
455: x_custom_output(1) := l_custom_rec;
456:
457: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';

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

455: x_custom_output(1) := l_custom_rec;
456:
457: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
458: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
459: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
460: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
461: x_custom_output.extend;
462: x_custom_output(2) := l_custom_rec;
463:

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

456:
457: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
458: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
459: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
460: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
461: x_custom_output.extend;
462: x_custom_output(2) := l_custom_rec;
463:
464: l_custom_rec.attribute_name := ':GLOBAL_RATE';

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

462: x_custom_output(2) := l_custom_rec;
463:
464: l_custom_rec.attribute_name := ':GLOBAL_RATE';
465: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
466: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
467: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
468: x_custom_output.extend;
469: x_custom_output(3) := l_custom_rec;
470:

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

463:
464: l_custom_rec.attribute_name := ':GLOBAL_RATE';
465: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
466: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
467: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
468: x_custom_output.extend;
469: x_custom_output(3) := l_custom_rec;
470:
471: l_custom_rec.attribute_name := ':HRI_CURR_TRN_VOL';

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

469: x_custom_output(3) := l_custom_rec;
470:
471: l_custom_rec.attribute_name := ':HRI_CURR_TRN_VOL';
472: l_custom_rec.attribute_value := l_curr_term_vol;
473: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
474: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
475: x_custom_output.extend;
476: x_custom_output(4) := l_custom_rec;
477:

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

470:
471: l_custom_rec.attribute_name := ':HRI_CURR_TRN_VOL';
472: l_custom_rec.attribute_value := l_curr_term_vol;
473: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
474: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
475: x_custom_output.extend;
476: x_custom_output(4) := l_custom_rec;
477:
478: l_custom_rec.attribute_name := ':HRI_CURR_TRN_INVOL';

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

476: x_custom_output(4) := l_custom_rec;
477:
478: l_custom_rec.attribute_name := ':HRI_CURR_TRN_INVOL';
479: l_custom_rec.attribute_value := l_curr_term_invol;
480: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
481: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
482: x_custom_output.extend;
483: x_custom_output(5) := l_custom_rec;
484:

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

477:
478: l_custom_rec.attribute_name := ':HRI_CURR_TRN_INVOL';
479: l_custom_rec.attribute_value := l_curr_term_invol;
480: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
481: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
482: x_custom_output.extend;
483: x_custom_output(5) := l_custom_rec;
484:
485: l_custom_rec.attribute_name := ':HRI_COMP_TRN_VOL';

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

483: x_custom_output(5) := l_custom_rec;
484:
485: l_custom_rec.attribute_name := ':HRI_COMP_TRN_VOL';
486: l_custom_rec.attribute_value := l_comp_term_vol;
487: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
488: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
489: x_custom_output.extend;
490: x_custom_output(6) := l_custom_rec;
491:

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

484:
485: l_custom_rec.attribute_name := ':HRI_COMP_TRN_VOL';
486: l_custom_rec.attribute_value := l_comp_term_vol;
487: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
488: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
489: x_custom_output.extend;
490: x_custom_output(6) := l_custom_rec;
491:
492: l_custom_rec.attribute_name := ':HRI_COMP_TRN_INVOL';

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

490: x_custom_output(6) := l_custom_rec;
491:
492: l_custom_rec.attribute_name := ':HRI_COMP_TRN_INVOL';
493: l_custom_rec.attribute_value := l_comp_term_invol;
494: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
495: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
496: x_custom_output.extend;
497: x_custom_output(7) := l_custom_rec;
498:

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

491:
492: l_custom_rec.attribute_name := ':HRI_COMP_TRN_INVOL';
493: l_custom_rec.attribute_value := l_comp_term_invol;
494: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
495: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
496: x_custom_output.extend;
497: x_custom_output(7) := l_custom_rec;
498:
499: END get_sql_pvt;