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

Line 37: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

33: l_debug_header VARCHAR(550);
34:
35: BEGIN
36: /* Initialize out parameters */
37: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
38: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
39:
40: /* Get security clause for Manager based security */
41: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

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

146: x_custom_sql := l_SQLText ;
147:
148: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
149: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
150: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
151: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
152: x_custom_output.extend;
153: x_custom_output(1) := l_custom_rec;
154:

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

147:
148: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
149: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
150: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
151: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
152: x_custom_output.extend;
153: x_custom_output(1) := l_custom_rec;
154:
155: l_custom_rec.attribute_name := ':GLOBAL_RATE';

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

153: x_custom_output(1) := l_custom_rec;
154:
155: l_custom_rec.attribute_name := ':GLOBAL_RATE';
156: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
157: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
158: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
159: x_custom_output.extend;
160: x_custom_output(2) := l_custom_rec;
161:

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

154:
155: l_custom_rec.attribute_name := ':GLOBAL_RATE';
156: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
157: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
158: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
159: x_custom_output.extend;
160: x_custom_output(2) := l_custom_rec;
161:
162: END get_sql_ctr2;

Line 194: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

190: l_debug_header VARCHAR(550);
191:
192: BEGIN
193: /* Initialize out parameters */
194: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
195: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
196:
197: /* Get security clause for Manager based security */
198: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

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

297: x_custom_sql := l_SQLText ;
298:
299: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
300: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
301: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
302: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
303: x_custom_output.extend;
304: x_custom_output(1) := l_custom_rec;
305:

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

298:
299: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
300: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
301: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
302: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
303: x_custom_output.extend;
304: x_custom_output(1) := l_custom_rec;
305:
306: l_custom_rec.attribute_name := ':GLOBAL_RATE';

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

304: x_custom_output(1) := l_custom_rec;
305:
306: l_custom_rec.attribute_name := ':GLOBAL_RATE';
307: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
308: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
309: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
310: x_custom_output.extend;
311: x_custom_output(2) := l_custom_rec;
312:

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

305:
306: l_custom_rec.attribute_name := ':GLOBAL_RATE';
307: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
308: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
309: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
310: x_custom_output.extend;
311: x_custom_output(2) := l_custom_rec;
312:
313: l_custom_rec.attribute_name := ':HRI_COUNTRY_CODE';

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

311: x_custom_output(2) := l_custom_rec;
312:
313: l_custom_rec.attribute_name := ':HRI_COUNTRY_CODE';
314: l_custom_rec.attribute_value := l_country_code;
315: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
316: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
317: x_custom_output.extend;
318: x_custom_output(3) := l_custom_rec;
319:

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

312:
313: l_custom_rec.attribute_name := ':HRI_COUNTRY_CODE';
314: l_custom_rec.attribute_value := l_country_code;
315: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
316: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
317: x_custom_output.extend;
318: x_custom_output(3) := l_custom_rec;
319:
320: END get_sql_rgn2;

Line 354: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

350: l_region_code VARCHAR(240);
351:
352: BEGIN
353: /* Initialize out parameters */
354: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
355: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
356:
357: /* Get security clause for Manager based security */
358: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

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

469: x_custom_sql := l_SQLText ;
470:
471: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
472: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
473: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
474: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
475: x_custom_output.extend;
476: x_custom_output(1) := l_custom_rec;
477:

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

470:
471: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
472: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
473: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
474: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
475: x_custom_output.extend;
476: x_custom_output(1) := l_custom_rec;
477:
478: l_custom_rec.attribute_name := ':GLOBAL_RATE';

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

476: x_custom_output(1) := l_custom_rec;
477:
478: l_custom_rec.attribute_name := ':GLOBAL_RATE';
479: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
480: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
481: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
482: x_custom_output.extend;
483: x_custom_output(2) := l_custom_rec;
484:

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

477:
478: l_custom_rec.attribute_name := ':GLOBAL_RATE';
479: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
480: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
481: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
482: x_custom_output.extend;
483: x_custom_output(2) := l_custom_rec;
484:
485: l_custom_rec.attribute_name := ':HRI_COUNTRY_CODE';

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

483: x_custom_output(2) := l_custom_rec;
484:
485: l_custom_rec.attribute_name := ':HRI_COUNTRY_CODE';
486: l_custom_rec.attribute_value := l_country_code;
487: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
488: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
489: x_custom_output.extend;
490: x_custom_output(3) := l_custom_rec;
491:

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

484:
485: l_custom_rec.attribute_name := ':HRI_COUNTRY_CODE';
486: l_custom_rec.attribute_value := l_country_code;
487: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
488: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
489: x_custom_output.extend;
490: x_custom_output(3) := l_custom_rec;
491:
492: l_custom_rec.attribute_name := ':HRI_REGION_CODE';

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

490: x_custom_output(3) := l_custom_rec;
491:
492: l_custom_rec.attribute_name := ':HRI_REGION_CODE';
493: l_custom_rec.attribute_value := l_region_code;
494: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
495: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
496: x_custom_output.extend;
497: x_custom_output(4) := l_custom_rec;
498:

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

491:
492: l_custom_rec.attribute_name := ':HRI_REGION_CODE';
493: l_custom_rec.attribute_value := l_region_code;
494: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
495: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
496: x_custom_output.extend;
497: x_custom_output(4) := l_custom_rec;
498:
499: END get_sql_cit2;

Line 529: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

525:
526: BEGIN
527:
528: /* Initialize out parameters */
529: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
530: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
531:
532: /* Get security clause for Manager based security */
533: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

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

627: x_custom_sql := l_SQLText;
628:
629: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
630: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
631: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
632: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
633: x_custom_output.extend;
634: x_custom_output(1) := l_custom_rec;
635:

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

628:
629: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
630: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
631: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
632: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
633: x_custom_output.extend;
634: x_custom_output(1) := l_custom_rec;
635:
636: l_custom_rec.attribute_name := ':GLOBAL_RATE';

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

634: x_custom_output(1) := l_custom_rec;
635:
636: l_custom_rec.attribute_name := ':GLOBAL_RATE';
637: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
638: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
639: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
640: x_custom_output.extend;
641: x_custom_output(2) := l_custom_rec;
642:

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

635:
636: l_custom_rec.attribute_name := ':GLOBAL_RATE';
637: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
638: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
639: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
640: x_custom_output.extend;
641: x_custom_output(2) := l_custom_rec;
642:
643: END get_sql_jfm2;

Line 677: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

673:
674: BEGIN
675:
676: /* Initialize out parameters */
677: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
678: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
679:
680: /* Get security clause for Manager based security */
681: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

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

790: x_custom_sql := l_SQLText;
791:
792: l_custom_rec.attribute_name := ':HRI_JOB_FUNCTION';
793: l_custom_rec.attribute_value := l_job_function_code;
794: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
795: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
796: x_custom_output.extend;
797: x_custom_output(1) := l_custom_rec;
798:

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

791:
792: l_custom_rec.attribute_name := ':HRI_JOB_FUNCTION';
793: l_custom_rec.attribute_value := l_job_function_code;
794: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
795: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
796: x_custom_output.extend;
797: x_custom_output(1) := l_custom_rec;
798:
799: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';

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

797: x_custom_output(1) := l_custom_rec;
798:
799: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
800: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
801: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
802: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
803: x_custom_output.extend;
804: x_custom_output(2) := l_custom_rec;
805:

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

798:
799: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
800: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
801: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
802: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
803: x_custom_output.extend;
804: x_custom_output(2) := l_custom_rec;
805:
806: l_custom_rec.attribute_name := ':GLOBAL_RATE';

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

804: x_custom_output(2) := l_custom_rec;
805:
806: l_custom_rec.attribute_name := ':GLOBAL_RATE';
807: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
808: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
809: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
810: x_custom_output.extend;
811: x_custom_output(3) := l_custom_rec;
812:

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

805:
806: l_custom_rec.attribute_name := ':GLOBAL_RATE';
807: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
808: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
809: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
810: x_custom_output.extend;
811: x_custom_output(3) := l_custom_rec;
812:
813: END get_sql_jfmfn2;