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

Line 114: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

110: WHEN (l_item_cat_flag = 1 and l_customer_flag = 1) THEN l_agg_level := 5;
111: WHEN (l_item_cat_flag = 3 and l_customer_flag = 1) THEN l_agg_level := 3;
112: END CASE;
113:
114: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
115: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
116:
117: -- Retrieve record to get bucket labels
118: bis_bucket_pub.RETRIEVE_BIS_BUCKET('ISC_DBI_DAYS_SHIP_AGING', l_bucket_rec, l_status, l_error_tbl);

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

310: x_custom_sql := l_stmt;
311:
312: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
313: l_custom_rec.attribute_value := to_char(l_agg_level);
314: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
315: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
316: x_custom_output.extend;
317: x_custom_output(1) := l_custom_rec;
318:

Line 315: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

311:
312: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
313: l_custom_rec.attribute_value := to_char(l_agg_level);
314: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
315: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
316: x_custom_output.extend;
317: x_custom_output(1) := l_custom_rec;
318:
319: l_custom_rec.attribute_name := ':ISC_R1';

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

317: x_custom_output(1) := l_custom_rec;
318:
319: l_custom_rec.attribute_name := ':ISC_R1';
320: l_custom_rec.attribute_value := l_bucket_rec.range1_name;
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(2) := 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 := ':ISC_R1';
320: l_custom_rec.attribute_value := l_bucket_rec.range1_name;
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(2) := l_custom_rec;
325:
326: l_custom_rec.attribute_name := ':ISC_R2';

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

324: x_custom_output(2) := l_custom_rec;
325:
326: l_custom_rec.attribute_name := ':ISC_R2';
327: l_custom_rec.attribute_value := l_bucket_rec.range2_name;
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(3) := 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 := ':ISC_R2';
327: l_custom_rec.attribute_value := l_bucket_rec.range2_name;
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(3) := l_custom_rec;
332:
333: l_custom_rec.attribute_name := ':ISC_R3';

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

331: x_custom_output(3) := l_custom_rec;
332:
333: l_custom_rec.attribute_name := ':ISC_R3';
334: l_custom_rec.attribute_value := l_bucket_rec.range3_name;
335: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
336: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
337: x_custom_output.extend;
338: x_custom_output(4) := l_custom_rec;
339:

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

332:
333: l_custom_rec.attribute_name := ':ISC_R3';
334: l_custom_rec.attribute_value := l_bucket_rec.range3_name;
335: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
336: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
337: x_custom_output.extend;
338: x_custom_output(4) := l_custom_rec;
339:
340: l_custom_rec.attribute_name := ':ISC_R4';

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

338: x_custom_output(4) := l_custom_rec;
339:
340: l_custom_rec.attribute_name := ':ISC_R4';
341: l_custom_rec.attribute_value := l_bucket_rec.range4_name;
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(5) := 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 := ':ISC_R4';
341: l_custom_rec.attribute_value := l_bucket_rec.range4_name;
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(5) := l_custom_rec;
346:
347: l_custom_rec.attribute_name := ':ISC_R5';

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

345: x_custom_output(5) := l_custom_rec;
346:
347: l_custom_rec.attribute_name := ':ISC_R5';
348: l_custom_rec.attribute_value := l_bucket_rec.range5_name;
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(6) := 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 := ':ISC_R5';
348: l_custom_rec.attribute_value := l_bucket_rec.range5_name;
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(6) := l_custom_rec;
353:
354: l_custom_rec.attribute_name := ':ISC_R6';

Line 356: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

352: x_custom_output(6) := l_custom_rec;
353:
354: l_custom_rec.attribute_name := ':ISC_R6';
355: l_custom_rec.attribute_value := l_bucket_rec.range6_name;
356: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
357: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
358: x_custom_output.extend;
359: x_custom_output(7) := l_custom_rec;
360:

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

353:
354: l_custom_rec.attribute_name := ':ISC_R6';
355: l_custom_rec.attribute_value := l_bucket_rec.range6_name;
356: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
357: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
358: x_custom_output.extend;
359: x_custom_output(7) := l_custom_rec;
360:
361: l_custom_rec.attribute_name := ':ISC_R7';

Line 363: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

359: x_custom_output(7) := l_custom_rec;
360:
361: l_custom_rec.attribute_name := ':ISC_R7';
362: l_custom_rec.attribute_value := l_bucket_rec.range7_name;
363: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
364: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
365: x_custom_output.extend;
366: x_custom_output(8) := l_custom_rec;
367:

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

360:
361: l_custom_rec.attribute_name := ':ISC_R7';
362: l_custom_rec.attribute_value := l_bucket_rec.range7_name;
363: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
364: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
365: x_custom_output.extend;
366: x_custom_output(8) := l_custom_rec;
367:
368: l_custom_rec.attribute_name := ':ISC_R8';

Line 370: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

366: x_custom_output(8) := l_custom_rec;
367:
368: l_custom_rec.attribute_name := ':ISC_R8';
369: l_custom_rec.attribute_value := l_bucket_rec.range8_name;
370: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
371: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
372: x_custom_output.extend;
373: x_custom_output(9) := l_custom_rec;
374:

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

367:
368: l_custom_rec.attribute_name := ':ISC_R8';
369: l_custom_rec.attribute_value := l_bucket_rec.range8_name;
370: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
371: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
372: x_custom_output.extend;
373: x_custom_output(9) := l_custom_rec;
374:
375: l_custom_rec.attribute_name := ':ISC_R9';

Line 377: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

373: x_custom_output(9) := l_custom_rec;
374:
375: l_custom_rec.attribute_name := ':ISC_R9';
376: l_custom_rec.attribute_value := l_bucket_rec.range9_name;
377: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
378: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
379: x_custom_output.extend;
380: x_custom_output(10) := l_custom_rec;
381:

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

374:
375: l_custom_rec.attribute_name := ':ISC_R9';
376: l_custom_rec.attribute_value := l_bucket_rec.range9_name;
377: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
378: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
379: x_custom_output.extend;
380: x_custom_output(10) := l_custom_rec;
381:
382: l_custom_rec.attribute_name := ':ISC_R10';

Line 384: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

380: x_custom_output(10) := l_custom_rec;
381:
382: l_custom_rec.attribute_name := ':ISC_R10';
383: l_custom_rec.attribute_value := l_bucket_rec.range10_name;
384: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
385: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
386: x_custom_output.extend;
387: x_custom_output(11) := l_custom_rec;
388:

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

381:
382: l_custom_rec.attribute_name := ':ISC_R10';
383: l_custom_rec.attribute_value := l_bucket_rec.range10_name;
384: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
385: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
386: x_custom_output.extend;
387: x_custom_output(11) := l_custom_rec;
388:
389: END Get_Sql;