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.ENI_DBI_COL_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 60: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

56: l_reason_value VARCHAR2(1000);
57: l_oa_url VARCHAR2(1000);
58: BEGIN
59:
60: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
61: x_custom_output := bis_query_attributes_tbl();
62:
63: ENI_DBI_UTIL_PKG.get_parameters( p_page_parameter_tbl
64: , l_period_type

Line 272: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

268:
269: x_custom_output.extend;
270: l_custom_rec.attribute_name := ':STATUS_ID';
271: l_custom_rec.attribute_value := replace(l_status,'''');
272: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
273: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
274: x_custom_output(1) := l_custom_rec;
275:
276: x_custom_output.extend;

Line 273: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

269: x_custom_output.extend;
270: l_custom_rec.attribute_name := ':STATUS_ID';
271: l_custom_rec.attribute_value := replace(l_status,'''');
272: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
273: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
274: x_custom_output(1) := l_custom_rec;
275:
276: x_custom_output.extend;
277: l_custom_rec.attribute_name := ':PRIORITY_ID';

Line 279: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

275:
276: x_custom_output.extend;
277: l_custom_rec.attribute_name := ':PRIORITY_ID';
278: l_custom_rec.attribute_value := l_priority;
279: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
280: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
281: x_custom_output(2) := l_custom_rec;
282:
283: x_custom_output.extend;

Line 280: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

276: x_custom_output.extend;
277: l_custom_rec.attribute_name := ':PRIORITY_ID';
278: l_custom_rec.attribute_value := l_priority;
279: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
280: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
281: x_custom_output(2) := l_custom_rec;
282:
283: x_custom_output.extend;
284: l_custom_rec.attribute_name := ':TYPE_ID';

Line 286: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

282:
283: x_custom_output.extend;
284: l_custom_rec.attribute_name := ':TYPE_ID';
285: l_custom_rec.attribute_value := REPLACE(l_type,'''');
286: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
287: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
288: x_custom_output(3) := l_custom_rec;
289:
290: x_custom_output.extend;

Line 287: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

283: x_custom_output.extend;
284: l_custom_rec.attribute_name := ':TYPE_ID';
285: l_custom_rec.attribute_value := REPLACE(l_type,'''');
286: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
287: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
288: x_custom_output(3) := l_custom_rec;
289:
290: x_custom_output.extend;
291: l_custom_rec.attribute_name := ':REASON_ID';

Line 293: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

289:
290: x_custom_output.extend;
291: l_custom_rec.attribute_name := ':REASON_ID';
292: l_custom_rec.attribute_value := l_reason;
293: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
294: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
295: x_custom_output(4) := l_custom_rec;
296:
297: x_custom_output.extend;

Line 294: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

290: x_custom_output.extend;
291: l_custom_rec.attribute_name := ':REASON_ID';
292: l_custom_rec.attribute_value := l_reason;
293: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
294: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
295: x_custom_output(4) := l_custom_rec;
296:
297: x_custom_output.extend;
298: l_custom_rec.attribute_name := ':ORGANIZATION_ID';

Line 300: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

296:
297: x_custom_output.extend;
298: l_custom_rec.attribute_name := ':ORGANIZATION_ID';
299: l_custom_rec.attribute_value := REPLACE(l_org,'''');
300: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
301: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
302: x_custom_output(5) := l_custom_rec;
303:
304: x_custom_output.extend;

Line 301: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

297: x_custom_output.extend;
298: l_custom_rec.attribute_name := ':ORGANIZATION_ID';
299: l_custom_rec.attribute_value := REPLACE(l_org,'''');
300: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
301: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
302: x_custom_output(5) := l_custom_rec;
303:
304: x_custom_output.extend;
305: l_custom_rec.attribute_name := ':ITEM_ID';

Line 307: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

303:
304: x_custom_output.extend;
305: l_custom_rec.attribute_name := ':ITEM_ID';
306: l_custom_rec.attribute_value := l_item;
307: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
308: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
309: x_custom_output(6) := l_custom_rec;
310:
311: x_custom_output.extend;

Line 308: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

304: x_custom_output.extend;
305: l_custom_rec.attribute_name := ':ITEM_ID';
306: l_custom_rec.attribute_value := l_item;
307: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
308: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
309: x_custom_output(6) := l_custom_rec;
310:
311: x_custom_output.extend;
312: l_custom_rec.attribute_name := ':NVL_DATE';

Line 314: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

310:
311: x_custom_output.extend;
312: l_custom_rec.attribute_name := ':NVL_DATE';
313: l_custom_rec.attribute_value := '31/12/3000';
314: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
315: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
316: x_custom_output(7) := l_custom_rec;
317:
318: x_custom_output.extend;

Line 315: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

311: x_custom_output.extend;
312: l_custom_rec.attribute_name := ':NVL_DATE';
313: l_custom_rec.attribute_value := '31/12/3000';
314: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
315: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
316: x_custom_output(7) := l_custom_rec;
317:
318: x_custom_output.extend;
319: l_custom_rec.attribute_name := ':OA_URL';

Line 321: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

317:
318: x_custom_output.extend;
319: l_custom_rec.attribute_name := ':OA_URL';
320: l_custom_rec.attribute_value := l_oa_url;
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(8) := l_custom_rec;
324:
325: x_custom_output.extend;

Line 322: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

318: x_custom_output.extend;
319: l_custom_rec.attribute_name := ':OA_URL';
320: l_custom_rec.attribute_value := l_oa_url;
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(8) := l_custom_rec;
324:
325: x_custom_output.extend;
326: l_custom_rec.attribute_name := ':START_DATE';

Line 328: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

324:
325: x_custom_output.extend;
326: l_custom_rec.attribute_name := ':START_DATE';
327: l_custom_rec.attribute_value := to_char(l_start_date,'DD/MM/YYYY');
328: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
329: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
330: x_custom_output(9) := l_custom_rec;
331:
332: x_custom_output.extend;

Line 329: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

325: x_custom_output.extend;
326: l_custom_rec.attribute_name := ':START_DATE';
327: l_custom_rec.attribute_value := to_char(l_start_date,'DD/MM/YYYY');
328: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
329: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
330: x_custom_output(9) := l_custom_rec;
331:
332: x_custom_output.extend;
333: l_custom_rec.attribute_name := ':END_DATE';

Line 335: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

331:
332: x_custom_output.extend;
333: l_custom_rec.attribute_name := ':END_DATE';
334: l_custom_rec.attribute_value := to_char(l_end_date,'DD/MM/YYYY');
335: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
336: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
337: x_custom_output(10) := l_custom_rec;
338: END GET_SQL;
339:

Line 336: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

332: x_custom_output.extend;
333: l_custom_rec.attribute_name := ':END_DATE';
334: l_custom_rec.attribute_value := to_char(l_end_date,'DD/MM/YYYY');
335: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
336: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
337: x_custom_output(10) := l_custom_rec;
338: END GET_SQL;
339:
340: PROCEDURE GET_COL_PARAMETERS (