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

Line 32: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

28: BEGIN
29:
30: /* Initialize out parameters */
31:
32: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
33: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
34:
35:
36: /* Get common parameter values */

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

170: x_custom_sql := l_SQLText;
171:
172: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
173: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
174: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
175: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
176: x_custom_output.extend;
177: x_custom_output(1) := l_custom_rec;
178:

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

171:
172: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
173: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
174: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
175: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
176: x_custom_output.extend;
177: x_custom_output(1) := l_custom_rec;
178:
179: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';

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

177: x_custom_output(1) := l_custom_rec;
178:
179: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
180: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
181: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
182: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
183: x_custom_output.extend;
184: x_custom_output(2) := l_custom_rec;
185:

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

178:
179: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
180: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
181: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
182: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
183: x_custom_output.extend;
184: x_custom_output(2) := l_custom_rec;
185:
186: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';

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

184: x_custom_output(2) := l_custom_rec;
185:
186: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
187: l_custom_rec.attribute_value := l_previous_periods;
188: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
189: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
190: x_custom_output.extend;
191: x_custom_output(3) := l_custom_rec;
192:

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

185:
186: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
187: l_custom_rec.attribute_value := l_previous_periods;
188: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
189: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
190: x_custom_output.extend;
191: x_custom_output(3) := l_custom_rec;
192:
193: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';

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

191: x_custom_output(3) := l_custom_rec;
192:
193: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
194: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
195: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
196: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
197: x_custom_output.extend;
198: x_custom_output(4) := l_custom_rec;
199:

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

192:
193: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
194: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
195: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
196: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
197: x_custom_output.extend;
198: x_custom_output(4) := l_custom_rec;
199:
200: l_custom_rec.attribute_name := ':GLOBAL_RATE';

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

198: x_custom_output(4) := l_custom_rec;
199:
200: l_custom_rec.attribute_name := ':GLOBAL_RATE';
201: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
202: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
203: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
204: x_custom_output.extend;
205: x_custom_output(5) := l_custom_rec;
206:

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

199:
200: l_custom_rec.attribute_name := ':GLOBAL_RATE';
201: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
202: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
203: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
204: x_custom_output.extend;
205: x_custom_output(5) := l_custom_rec;
206:
207: END GET_SQL;

Line 233: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

229: BEGIN
230:
231: /* Initialize out parameters */
232:
233: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
234: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
235:
236:
237: /* Get common parameter values */

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

317: x_custom_sql := l_SQLText;
318:
319: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
320: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
321: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
322: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
323: x_custom_output.extend;
324: x_custom_output(1) := l_custom_rec;
325:

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

318:
319: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
320: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
321: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
322: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
323: x_custom_output.extend;
324: x_custom_output(1) := l_custom_rec;
325:
326: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';

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

324: x_custom_output(1) := l_custom_rec;
325:
326: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
327: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
328: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
329: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
330: x_custom_output.extend;
331: x_custom_output(2) := l_custom_rec;
332:

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

325:
326: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
327: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
328: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
329: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
330: x_custom_output.extend;
331: x_custom_output(2) := l_custom_rec;
332:
333: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';

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

331: x_custom_output(2) := l_custom_rec;
332:
333: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
334: l_custom_rec.attribute_value := l_previous_periods;
335: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
336: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
337: x_custom_output.extend;
338: x_custom_output(3) := l_custom_rec;
339:

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

332:
333: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
334: l_custom_rec.attribute_value := l_previous_periods;
335: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
336: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
337: x_custom_output.extend;
338: x_custom_output(3) := l_custom_rec;
339:
340: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';

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

338: x_custom_output(3) := l_custom_rec;
339:
340: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
341: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
342: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
343: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
344: x_custom_output.extend;
345: x_custom_output(4) := l_custom_rec;
346:

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

339:
340: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
341: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
342: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
343: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
344: x_custom_output.extend;
345: x_custom_output(4) := l_custom_rec;
346:
347: l_custom_rec.attribute_name := ':GLOBAL_RATE';

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

345: x_custom_output(4) := l_custom_rec;
346:
347: l_custom_rec.attribute_name := ':GLOBAL_RATE';
348: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
349: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
350: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
351: x_custom_output.extend;
352: x_custom_output(5) := l_custom_rec;
353:

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

346:
347: l_custom_rec.attribute_name := ':GLOBAL_RATE';
348: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
349: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
350: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
351: x_custom_output.extend;
352: x_custom_output(5) := l_custom_rec;
353:
354: END GET_LBRCST_SQL;

Line 380: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

376: BEGIN
377:
378: /* Initialize out parameters */
379:
380: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
381: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
382:
383:
384: /* Get common parameter values */

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

453: x_custom_sql := l_SQLText;
454:
455: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
456: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
457: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
458: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
459: x_custom_output.extend;
460: x_custom_output(1) := l_custom_rec;
461:

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

454:
455: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
456: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
457: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
458: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
459: x_custom_output.extend;
460: x_custom_output(1) := l_custom_rec;
461:
462: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';

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

460: x_custom_output(1) := l_custom_rec;
461:
462: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
463: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
464: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
465: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
466: x_custom_output.extend;
467: x_custom_output(2) := l_custom_rec;
468:

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

461:
462: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
463: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
464: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
465: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
466: x_custom_output.extend;
467: x_custom_output(2) := l_custom_rec;
468:
469: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';

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

467: x_custom_output(2) := l_custom_rec;
468:
469: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
470: l_custom_rec.attribute_value := l_previous_periods;
471: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
472: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
473: x_custom_output.extend;
474: x_custom_output(3) := l_custom_rec;
475:

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

468:
469: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
470: l_custom_rec.attribute_value := l_previous_periods;
471: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
472: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
473: x_custom_output.extend;
474: x_custom_output(3) := l_custom_rec;
475:
476: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';

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

474: x_custom_output(3) := l_custom_rec;
475:
476: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
477: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
478: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
479: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
480: x_custom_output.extend;
481: x_custom_output(4) := l_custom_rec;
482:

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

475:
476: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
477: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
478: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
479: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
480: x_custom_output.extend;
481: x_custom_output(4) := l_custom_rec;
482:
483: l_custom_rec.attribute_name := ':GLOBAL_RATE';

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

481: x_custom_output(4) := l_custom_rec;
482:
483: l_custom_rec.attribute_name := ':GLOBAL_RATE';
484: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
485: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
486: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
487: x_custom_output.extend;
488: x_custom_output(5) := l_custom_rec;
489:

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

482:
483: l_custom_rec.attribute_name := ':GLOBAL_RATE';
484: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
485: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
486: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
487: x_custom_output.extend;
488: x_custom_output(5) := l_custom_rec;
489:
490: END GET_HDCNT_SQL;