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

Line 158: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

154: l_snapshot_taken := TRUE;
155:
156: END;
157:
158: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
159: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
160:
161: -- Retrieve record to get bucket labels
162: bis_bucket_pub.RETRIEVE_BIS_BUCKET('ISC_DBI_PAST_DUE', l_bucket_rec, l_status, l_error_tbl);

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

320: x_custom_sql := l_sql_stmt;
321:
322: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
323: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
324: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
325: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
326: x_custom_output.extend;
327: x_custom_output(1) := l_custom_rec;
328:

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

321:
322: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
323: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
324: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
325: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
326: x_custom_output.extend;
327: x_custom_output(1) := l_custom_rec;
328:
329: l_custom_rec.attribute_name := ':ISC_CUSTOMER_FLAG';

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

327: x_custom_output(1) := l_custom_rec;
328:
329: l_custom_rec.attribute_name := ':ISC_CUSTOMER_FLAG';
330: l_custom_rec.attribute_value := to_char(l_customer_flag);
331: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
332: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
333: x_custom_output.extend;
334: x_custom_output(2) := l_custom_rec;
335:

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

328:
329: l_custom_rec.attribute_name := ':ISC_CUSTOMER_FLAG';
330: l_custom_rec.attribute_value := to_char(l_customer_flag);
331: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
332: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
333: x_custom_output.extend;
334: x_custom_output(2) := l_custom_rec;
335:
336: l_custom_rec.attribute_name := ':ISC_R1';

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

334: x_custom_output(2) := l_custom_rec;
335:
336: l_custom_rec.attribute_name := ':ISC_R1';
337: l_custom_rec.attribute_value := l_bucket_rec.range1_name;
338: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
339: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
340: x_custom_output.extend;
341: x_custom_output(3) := l_custom_rec;
342:

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

335:
336: l_custom_rec.attribute_name := ':ISC_R1';
337: l_custom_rec.attribute_value := l_bucket_rec.range1_name;
338: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
339: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
340: x_custom_output.extend;
341: x_custom_output(3) := l_custom_rec;
342:
343: l_custom_rec.attribute_name := ':ISC_R2';

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

341: x_custom_output(3) := l_custom_rec;
342:
343: l_custom_rec.attribute_name := ':ISC_R2';
344: l_custom_rec.attribute_value := l_bucket_rec.range2_name;
345: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
346: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
347: x_custom_output.extend;
348: x_custom_output(4) := l_custom_rec;
349:

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

342:
343: l_custom_rec.attribute_name := ':ISC_R2';
344: l_custom_rec.attribute_value := l_bucket_rec.range2_name;
345: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
346: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
347: x_custom_output.extend;
348: x_custom_output(4) := l_custom_rec;
349:
350: l_custom_rec.attribute_name := ':ISC_R3';

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

348: x_custom_output(4) := l_custom_rec;
349:
350: l_custom_rec.attribute_name := ':ISC_R3';
351: l_custom_rec.attribute_value := l_bucket_rec.range3_name;
352: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
353: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
354: x_custom_output.extend;
355: x_custom_output(5) := l_custom_rec;
356:

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

349:
350: l_custom_rec.attribute_name := ':ISC_R3';
351: l_custom_rec.attribute_value := l_bucket_rec.range3_name;
352: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
353: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
354: x_custom_output.extend;
355: x_custom_output(5) := l_custom_rec;
356:
357: l_custom_rec.attribute_name := ':ISC_R4';

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

355: x_custom_output(5) := l_custom_rec;
356:
357: l_custom_rec.attribute_name := ':ISC_R4';
358: l_custom_rec.attribute_value := l_bucket_rec.range4_name;
359: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
360: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
361: x_custom_output.extend;
362: x_custom_output(6) := l_custom_rec;
363:

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

356:
357: l_custom_rec.attribute_name := ':ISC_R4';
358: l_custom_rec.attribute_value := l_bucket_rec.range4_name;
359: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
360: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
361: x_custom_output.extend;
362: x_custom_output(6) := l_custom_rec;
363:
364: l_custom_rec.attribute_name := ':ISC_R5';

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

362: x_custom_output(6) := l_custom_rec;
363:
364: l_custom_rec.attribute_name := ':ISC_R5';
365: l_custom_rec.attribute_value := l_bucket_rec.range5_name;
366: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
367: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
368: x_custom_output.extend;
369: x_custom_output(7) := l_custom_rec;
370:

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

363:
364: l_custom_rec.attribute_name := ':ISC_R5';
365: l_custom_rec.attribute_value := l_bucket_rec.range5_name;
366: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
367: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
368: x_custom_output.extend;
369: x_custom_output(7) := l_custom_rec;
370:
371: l_custom_rec.attribute_name := ':ISC_R6';

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

369: x_custom_output(7) := l_custom_rec;
370:
371: l_custom_rec.attribute_name := ':ISC_R6';
372: l_custom_rec.attribute_value := l_bucket_rec.range6_name;
373: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
374: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
375: x_custom_output.extend;
376: x_custom_output(8) := l_custom_rec;
377:

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

370:
371: l_custom_rec.attribute_name := ':ISC_R6';
372: l_custom_rec.attribute_value := l_bucket_rec.range6_name;
373: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
374: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
375: x_custom_output.extend;
376: x_custom_output(8) := l_custom_rec;
377:
378: l_custom_rec.attribute_name := ':ISC_R7';

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

376: x_custom_output(8) := l_custom_rec;
377:
378: l_custom_rec.attribute_name := ':ISC_R7';
379: l_custom_rec.attribute_value := l_bucket_rec.range7_name;
380: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
381: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
382: x_custom_output.extend;
383: x_custom_output(9) := l_custom_rec;
384:

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

377:
378: l_custom_rec.attribute_name := ':ISC_R7';
379: l_custom_rec.attribute_value := l_bucket_rec.range7_name;
380: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
381: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
382: x_custom_output.extend;
383: x_custom_output(9) := l_custom_rec;
384:
385: l_custom_rec.attribute_name := ':ISC_R8';

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

383: x_custom_output(9) := l_custom_rec;
384:
385: l_custom_rec.attribute_name := ':ISC_R8';
386: l_custom_rec.attribute_value := l_bucket_rec.range8_name;
387: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
388: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
389: x_custom_output.extend;
390: x_custom_output(10) := l_custom_rec;
391:

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

384:
385: l_custom_rec.attribute_name := ':ISC_R8';
386: l_custom_rec.attribute_value := l_bucket_rec.range8_name;
387: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
388: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
389: x_custom_output.extend;
390: x_custom_output(10) := l_custom_rec;
391:
392: l_custom_rec.attribute_name := ':ISC_R9';

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

390: x_custom_output(10) := l_custom_rec;
391:
392: l_custom_rec.attribute_name := ':ISC_R9';
393: l_custom_rec.attribute_value := l_bucket_rec.range9_name;
394: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
395: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
396: x_custom_output.extend;
397: x_custom_output(11) := l_custom_rec;
398:

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

391:
392: l_custom_rec.attribute_name := ':ISC_R9';
393: l_custom_rec.attribute_value := l_bucket_rec.range9_name;
394: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
395: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
396: x_custom_output.extend;
397: x_custom_output(11) := l_custom_rec;
398:
399: l_custom_rec.attribute_name := ':ISC_R10';

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

397: x_custom_output(11) := l_custom_rec;
398:
399: l_custom_rec.attribute_name := ':ISC_R10';
400: l_custom_rec.attribute_value := l_bucket_rec.range10_name;
401: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
402: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
403: x_custom_output.extend;
404: x_custom_output(12) := l_custom_rec;
405:

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

398:
399: l_custom_rec.attribute_name := ':ISC_R10';
400: l_custom_rec.attribute_value := l_bucket_rec.range10_name;
401: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
402: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
403: x_custom_output.extend;
404: x_custom_output(12) := l_custom_rec;
405:
406: END Get_Sql;