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

Line 26: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

22:
23:
24: /* Initialize out parameters */
25:
26: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
27: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
28:
29:
30: /* Get common parameter values */

Line 224: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

220: BEGIN
221:
222: /* Initialize out parameters */
223:
224: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
225: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
226:
227:
228: /* Get common parameter values */

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

307: x_custom_sql := l_SQLText;
308:
309: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
310: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
311: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
312: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
313: x_custom_output.extend;
314: x_custom_output(1) := l_custom_rec;
315:

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

308:
309: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
310: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
311: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
312: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
313: x_custom_output.extend;
314: x_custom_output(1) := l_custom_rec;
315:
316: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';

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

314: x_custom_output(1) := l_custom_rec;
315:
316: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
317: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
318: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
319: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
320: x_custom_output.extend;
321: x_custom_output(2) := l_custom_rec;
322:

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

315:
316: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
317: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
318: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
319: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
320: x_custom_output.extend;
321: x_custom_output(2) := l_custom_rec;
322:
323: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';

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

321: x_custom_output(2) := l_custom_rec;
322:
323: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
324: l_custom_rec.attribute_value := l_previous_periods;
325: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
326: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
327: x_custom_output.extend;
328: x_custom_output(3) := l_custom_rec;
329:

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

322:
323: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
324: l_custom_rec.attribute_value := l_previous_periods;
325: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
326: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
327: x_custom_output.extend;
328: x_custom_output(3) := l_custom_rec;
329:
330: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';

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

328: x_custom_output(3) := l_custom_rec;
329:
330: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
331: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
332: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
333: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
334: x_custom_output.extend;
335: x_custom_output(4) := l_custom_rec;
336:

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

329:
330: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
331: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
332: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
333: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
334: x_custom_output.extend;
335: x_custom_output(4) := l_custom_rec;
336:
337: l_custom_rec.attribute_name := ':GLOBAL_RATE';

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

335: x_custom_output(4) := l_custom_rec;
336:
337: l_custom_rec.attribute_name := ':GLOBAL_RATE';
338: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
339: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
340: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
341: x_custom_output.extend;
342: x_custom_output(5) := l_custom_rec;
343:

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

336:
337: l_custom_rec.attribute_name := ':GLOBAL_RATE';
338: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
339: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
340: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
341: x_custom_output.extend;
342: x_custom_output(5) := l_custom_rec;
343:
344: l_custom_rec.attribute_name := ':HRI_TOT_WMV_PREV';

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

342: x_custom_output(5) := l_custom_rec;
343:
344: l_custom_rec.attribute_name := ':HRI_TOT_WMV_PREV';
345: l_custom_rec.attribute_value := l_period_ago_wmv_count;
346: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
347: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
348: x_custom_output.extend;
349: x_custom_output(6) := l_custom_rec;
350:

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

343:
344: l_custom_rec.attribute_name := ':HRI_TOT_WMV_PREV';
345: l_custom_rec.attribute_value := l_period_ago_wmv_count;
346: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
347: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
348: x_custom_output.extend;
349: x_custom_output(6) := l_custom_rec;
350:
351: l_custom_rec.attribute_name := ':HRI_TOT_WMV_START';

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

349: x_custom_output(6) := l_custom_rec;
350:
351: l_custom_rec.attribute_name := ':HRI_TOT_WMV_START';
352: l_custom_rec.attribute_value := l_tot_wmv_start;
353: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
354: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
355: x_custom_output.extend;
356: x_custom_output(7) := l_custom_rec;
357:

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

350:
351: l_custom_rec.attribute_name := ':HRI_TOT_WMV_START';
352: l_custom_rec.attribute_value := l_tot_wmv_start;
353: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
354: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
355: x_custom_output.extend;
356: x_custom_output(7) := l_custom_rec;
357:
358: END GET_ORG_SQL;