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.POA_DBI_UPR_PKG dependencies on POA_DBI_UTIL_PKG

Line 29: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

25: x_custom_sql OUT NOCOPY VARCHAR2,
26: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
27: IS
28:
29: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
30: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
31: l_query varchar2(10000);
32: l_view_by varchar2(120);
33: l_view_by_col varchar2(120);

Line 30: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

26: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
27: IS
28:
29: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
30: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
31: l_query varchar2(10000);
32: l_view_by varchar2(120);
33: l_view_by_col varchar2(120);
34: l_as_of_date date;

Line 40: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

36: l_xtd varchar2(10);
37: l_comparison_type varchar2(1);
38: l_nested_pattern number;
39: l_cur_suffix varchar2(2);
40: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
41: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
42: l_where_clause VARCHAR2(2000);
43: l_mv VARCHAR2(30);
44: l_view_by_value varchar2(30);

Line 41: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;

37: l_comparison_type varchar2(1);
38: l_nested_pattern number;
39: l_cur_suffix varchar2(2);
40: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
41: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
42: l_where_clause VARCHAR2(2000);
43: l_mv VARCHAR2(30);
44: l_view_by_value varchar2(30);
45: ERR_MSG VARCHAR2(100);

Line 50: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();

46: ERR_CDE NUMBER;
47:
48: BEGIN
49:
50: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
51: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
52: l_comparison_type := 'Y';
53: poa_dbi_sutil_pkg.process_parameters(p_param
54: ,l_view_by

Line 51: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();

47:
48: BEGIN
49:
50: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
51: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
52: l_comparison_type := 'Y';
53: poa_dbi_sutil_pkg.process_parameters(p_param
54: ,l_view_by
55: ,l_view_by_col

Line 74: poa_dbi_util_pkg.add_column(l_col_tbl

70: ,p_version => '7.1'
71: ,p_role => 'VPP'
72: ,p_mv_set => 'REQS');
73:
74: poa_dbi_util_pkg.add_column(l_col_tbl
75: ,'num_days_unprocessed'
76: , 'num_days_unproc'
77: , p_grand_total => 'Y'
78: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 78: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

74: poa_dbi_util_pkg.add_column(l_col_tbl
75: ,'num_days_unprocessed'
76: , 'num_days_unproc'
77: , p_grand_total => 'Y'
78: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
79: , p_to_date_type => 'NA');
80:
81: poa_dbi_util_pkg.add_column(l_col_tbl
82: ,'unprocessed_cnt'

Line 81: poa_dbi_util_pkg.add_column(l_col_tbl

77: , p_grand_total => 'Y'
78: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
79: , p_to_date_type => 'NA');
80:
81: poa_dbi_util_pkg.add_column(l_col_tbl
82: ,'unprocessed_cnt'
83: , 'unproc_cnt'
84: , p_grand_total => 'Y'
85: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 85: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

81: poa_dbi_util_pkg.add_column(l_col_tbl
82: ,'unprocessed_cnt'
83: , 'unproc_cnt'
84: , p_grand_total => 'Y'
85: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
86: , p_to_date_type => 'NA');
87:
88:
89: poa_dbi_util_pkg.add_column(l_col_tbl

Line 89: poa_dbi_util_pkg.add_column(l_col_tbl

85: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
86: , p_to_date_type => 'NA');
87:
88:
89: poa_dbi_util_pkg.add_column(l_col_tbl
90: ,'unprocessed_ped_cnt'
91: , 'unproc_ped_cnt'
92: , p_grand_total => 'Y'
93: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 93: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

89: poa_dbi_util_pkg.add_column(l_col_tbl
90: ,'unprocessed_ped_cnt'
91: , 'unproc_ped_cnt'
92: , p_grand_total => 'Y'
93: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
94: , p_to_date_type => 'NA');
95:
96: poa_dbi_util_pkg.add_column(l_col_tbl
97: ,'unprocessed_amt_' || l_cur_suffix

Line 96: poa_dbi_util_pkg.add_column(l_col_tbl

92: , p_grand_total => 'Y'
93: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
94: , p_to_date_type => 'NA');
95:
96: poa_dbi_util_pkg.add_column(l_col_tbl
97: ,'unprocessed_amt_' || l_cur_suffix
98: , 'unproc_amt'
99: , p_grand_total => 'Y'
100: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 100: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

96: poa_dbi_util_pkg.add_column(l_col_tbl
97: ,'unprocessed_amt_' || l_cur_suffix
98: , 'unproc_amt'
99: , p_grand_total => 'Y'
100: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
101: , p_to_date_type => 'NA');
102:
103: if(l_view_by = 'ITEM+POA_ITEMS') then
104: poa_dbi_util_pkg.add_column(l_col_tbl

Line 104: poa_dbi_util_pkg.add_column(l_col_tbl

100: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
101: , p_to_date_type => 'NA');
102:
103: if(l_view_by = 'ITEM+POA_ITEMS') then
104: poa_dbi_util_pkg.add_column(l_col_tbl
105: , 'unprocessed_qty'
106: , 'unproc_qty'
107: , p_grand_total => 'N'
108: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 108: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

104: poa_dbi_util_pkg.add_column(l_col_tbl
105: , 'unprocessed_qty'
106: , 'unproc_qty'
107: , p_grand_total => 'N'
108: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
109: , p_to_date_type => 'NA');
110:
111: end if;
112:

Line 214: ' || poa_dbi_util_pkg.rate_clause('c_unproc_cnt','c_unproc_cnt_total', 'P') || ' POA_PERCENT1,

210: decode(base_uom,null,to_number(null),nvl(c_unproc_qty,0)) POA_MEASURE8,';
211: end if;
212:
213: l_sel_clause := l_sel_clause || ' nvl(c_unproc_cnt,0) POA_MEASURE1,
214: ' || poa_dbi_util_pkg.rate_clause('c_unproc_cnt','c_unproc_cnt_total', 'P') || ' POA_PERCENT1,
215: nvl(c_unproc_ped_cnt,0) POA_MEASURE2,
216: nvl(c_unproc_amt,0) POA_MEASURE3,
217: nvl(c_unproc_cnt_total,0) POA_MEASURE4,
218: decode(c_unproc_cnt_total,0,null,100) POA_PERCENT3,

Line 221: ' || poa_dbi_util_pkg.rate_clause('c_num_days_unproc','c_unproc_cnt', 'NP') || ' POA_MEASURE10,

217: nvl(c_unproc_cnt_total,0) POA_MEASURE4,
218: decode(c_unproc_cnt_total,0,null,100) POA_PERCENT3,
219: nvl(c_unproc_ped_cnt_total,0) POA_MEASURE5,
220: nvl(c_unproc_amt_total,0) POA_MEASURE6,
221: ' || poa_dbi_util_pkg.rate_clause('c_num_days_unproc','c_unproc_cnt', 'NP') || ' POA_MEASURE10,
222: ' || poa_dbi_util_pkg.rate_clause('c_num_days_unproc_total','c_unproc_cnt_total', 'NP') || ' POA_MEASURE11
223: ';
224:
225: return l_sel_clause;

Line 222: ' || poa_dbi_util_pkg.rate_clause('c_num_days_unproc_total','c_unproc_cnt_total', 'NP') || ' POA_MEASURE11

218: decode(c_unproc_cnt_total,0,null,100) POA_PERCENT3,
219: nvl(c_unproc_ped_cnt_total,0) POA_MEASURE5,
220: nvl(c_unproc_amt_total,0) POA_MEASURE6,
221: ' || poa_dbi_util_pkg.rate_clause('c_num_days_unproc','c_unproc_cnt', 'NP') || ' POA_MEASURE10,
222: ' || poa_dbi_util_pkg.rate_clause('c_num_days_unproc_total','c_unproc_cnt_total', 'NP') || ' POA_MEASURE11
223: ';
224:
225: return l_sel_clause;
226: END;

Line 260: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

256: x_custom_sql OUT NOCOPY VARCHAR2,
257: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
258: IS
259:
260: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
261: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
262: l_query varchar2(10000);
263: l_view_by varchar2(120);
264: l_view_by_col varchar2(120);

Line 261: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

257: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
258: IS
259:
260: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
261: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
262: l_query varchar2(10000);
263: l_view_by varchar2(120);
264: l_view_by_col varchar2(120);
265: l_as_of_date date;

Line 271: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

267: l_xtd varchar2(10);
268: l_comparison_type varchar2(1);
269: l_nested_pattern number;
270: l_cur_suffix varchar2(2);
271: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
272: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
273: l_where_clause VARCHAR2(2000);
274: l_mv VARCHAR2(30);
275: l_view_by_value varchar2(30);

Line 272: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;

268: l_comparison_type varchar2(1);
269: l_nested_pattern number;
270: l_cur_suffix varchar2(2);
271: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
272: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
273: l_where_clause VARCHAR2(2000);
274: l_mv VARCHAR2(30);
275: l_view_by_value varchar2(30);
276: l_bucket_rec BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE;

Line 282: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();

278: ERR_CDE NUMBER;
279:
280: BEGIN
281:
282: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
283: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
284: l_comparison_type :='Y';
285: poa_dbi_sutil_pkg.process_parameters(p_param
286: ,l_view_by

Line 283: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();

279:
280: BEGIN
281:
282: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
283: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
284: l_comparison_type :='Y';
285: poa_dbi_sutil_pkg.process_parameters(p_param
286: ,l_view_by
287: ,l_view_by_col

Line 306: poa_dbi_util_pkg.add_bucket_columns(

302: ,p_version => '7.1'
303: ,p_role => 'VPP'
304: ,p_mv_set => 'REQS');
305:
306: poa_dbi_util_pkg.add_bucket_columns(
307: p_short_name => 'POA_DBI_UPR_BUCKET'
308: ,p_col_tbl => l_col_tbl
309: ,p_col_name => 'unprocessed_amt_' || l_cur_suffix || '_age'
310: ,p_alias_name => 'unproc_amt_age'

Line 313: ,p_prior_code => poa_dbi_util_pkg.NO_PRIORS

309: ,p_col_name => 'unprocessed_amt_' || l_cur_suffix || '_age'
310: ,p_alias_name => 'unproc_amt_age'
311: ,x_bucket_rec => l_bucket_rec
312: ,p_grand_total => 'Y'
313: ,p_prior_code => poa_dbi_util_pkg.NO_PRIORS
314: ,p_to_date_type => 'NA');
315:
316: poa_dbi_util_pkg.add_column(l_col_tbl
317: ,'unprocessed_amt_' || l_cur_suffix

Line 316: poa_dbi_util_pkg.add_column(l_col_tbl

312: ,p_grand_total => 'Y'
313: ,p_prior_code => poa_dbi_util_pkg.NO_PRIORS
314: ,p_to_date_type => 'NA');
315:
316: poa_dbi_util_pkg.add_column(l_col_tbl
317: ,'unprocessed_amt_' || l_cur_suffix
318: , 'unproc_amt'
319: , p_grand_total => 'Y'
320: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 320: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

316: poa_dbi_util_pkg.add_column(l_col_tbl
317: ,'unprocessed_amt_' || l_cur_suffix
318: , 'unproc_amt'
319: , p_grand_total => 'Y'
320: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
321: , p_to_date_type => 'NA');
322:
323:
324: poa_dbi_util_pkg.add_column(l_col_tbl

Line 324: poa_dbi_util_pkg.add_column(l_col_tbl

320: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
321: , p_to_date_type => 'NA');
322:
323:
324: poa_dbi_util_pkg.add_column(l_col_tbl
325: ,'pen_src_amt_' || l_cur_suffix
326: , 'pen_src_amt'
327: , p_grand_total => 'Y'
328: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 328: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

324: poa_dbi_util_pkg.add_column(l_col_tbl
325: ,'pen_src_amt_' || l_cur_suffix
326: , 'pen_src_amt'
327: , p_grand_total => 'Y'
328: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
329: , p_to_date_type => 'NA');
330:
331:
332: poa_dbi_util_pkg.add_column(l_col_tbl

Line 332: poa_dbi_util_pkg.add_column(l_col_tbl

328: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
329: , p_to_date_type => 'NA');
330:
331:
332: poa_dbi_util_pkg.add_column(l_col_tbl
333: ,'pen_buyer_wk_amt_' || l_cur_suffix
334: , 'pen_buyer_wk_amt'
335: , p_grand_total => 'Y'
336: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 336: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

332: poa_dbi_util_pkg.add_column(l_col_tbl
333: ,'pen_buyer_wk_amt_' || l_cur_suffix
334: , 'pen_buyer_wk_amt'
335: , p_grand_total => 'Y'
336: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
337: , p_to_date_type => 'NA');
338:
339:
340: poa_dbi_util_pkg.add_column(l_col_tbl

Line 340: poa_dbi_util_pkg.add_column(l_col_tbl

336: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
337: , p_to_date_type => 'NA');
338:
339:
340: poa_dbi_util_pkg.add_column(l_col_tbl
341: ,'pen_po_submit_amt_' || l_cur_suffix
342: , 'pen_po_submit_amt'
343: , p_grand_total => 'Y'
344: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 344: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

340: poa_dbi_util_pkg.add_column(l_col_tbl
341: ,'pen_po_submit_amt_' || l_cur_suffix
342: , 'pen_po_submit_amt'
343: , p_grand_total => 'Y'
344: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
345: , p_to_date_type => 'NA');
346:
347: poa_dbi_util_pkg.add_column(l_col_tbl
348: ,'pen_po_appr_amt_' || l_cur_suffix

Line 347: poa_dbi_util_pkg.add_column(l_col_tbl

343: , p_grand_total => 'Y'
344: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
345: , p_to_date_type => 'NA');
346:
347: poa_dbi_util_pkg.add_column(l_col_tbl
348: ,'pen_po_appr_amt_' || l_cur_suffix
349: , 'pen_po_appr_amt'
350: , p_grand_total => 'Y'
351: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 351: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

347: poa_dbi_util_pkg.add_column(l_col_tbl
348: ,'pen_po_appr_amt_' || l_cur_suffix
349: , 'pen_po_appr_amt'
350: , p_grand_total => 'Y'
351: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
352: , p_to_date_type => 'NA');
353:
354: if(l_view_by = 'ITEM+POA_ITEMS') then
355: poa_dbi_util_pkg.add_column(l_col_tbl

Line 355: poa_dbi_util_pkg.add_column(l_col_tbl

351: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
352: , p_to_date_type => 'NA');
353:
354: if(l_view_by = 'ITEM+POA_ITEMS') then
355: poa_dbi_util_pkg.add_column(l_col_tbl
356: , 'unprocessed_qty'
357: , 'unproc_qty'
358: , p_grand_total => 'N'
359: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 359: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

355: poa_dbi_util_pkg.add_column(l_col_tbl
356: , 'unprocessed_qty'
357: , 'unproc_qty'
358: , p_grand_total => 'N'
359: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
360: , p_to_date_type => 'NA');
361:
362: end if;
363:

Line 424: || poa_dbi_util_pkg.get_bucket_outer_query(

420: oset.POA_MEASURE4 POA_MEASURE4, -- Lines Pending Buyers Workbench
421: oset.POA_MEASURE5 POA_MEASURE5, --Lines Pending PO submit
422: oset.POA_MEASURE6 POA_MEASURE6 --Lines Pending PO Approval '
423: || fnd_global.newline
424: || poa_dbi_util_pkg.get_bucket_outer_query(
425: p_bucket_rec
426: , p_col_name => 'oset.POA_MEASURE7'
427: , p_alias_name => 'POA_MEASURE7'
428: , p_prefix => ''

Line 438: || poa_dbi_util_pkg.get_bucket_outer_query(

434: oset.POA_MEASURE10 POA_MEASURE10, -- Grand Total for Buyers Wkbnch
435: oset.POA_MEASURE11 POA_MEASURE11, -- Grand Total for PO Submit
436: oset.POA_MEASURE12 POA_MEASURE12 -- Grand Total for PO Approval '
437: || fnd_global.newline
438: || poa_dbi_util_pkg.get_bucket_outer_query(
439: p_bucket_rec
440: , p_col_name => 'oset.POA_MEASURE13'
441: , p_alias_name => 'POA_MEASURE13'
442: , p_prefix => ''

Line 453: poa_dbi_util_pkg.get_bucket_drill_url(

449: oset.POA_MEASURE6 POA_MEASURE17' ;
450:
451:
452: l_sel_clause := l_sel_clause ||
453: poa_dbi_util_pkg.get_bucket_drill_url(
454: p_bucket_rec
455: , 'POA_ATTRIBUTE5'
456: ,
457: '''pFunctionName=POA_DBI_UPR_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&POA_ATTRIBUTE10=1&POA_BUCKET+REQUISITION_AGING='

Line 498: || poa_dbi_util_pkg.get_bucket_outer_query(

494: POA_MEASURE2,POA_MEASURE3,
495: POA_MEASURE4, POA_MEASURE5,
496: POA_MEASURE6'
497: || fnd_global.newline
498: || poa_dbi_util_pkg.get_bucket_outer_query(
499: p_bucket_rec
500: , p_col_name => 'POA_MEASURE7'
501: , p_alias_name => 'POA_MEASURE7'
502: , p_prefix => ''

Line 509: || poa_dbi_util_pkg.get_bucket_outer_query(

505: || fnd_global.newline ||
506: ' , POA_MEASURE8, POA_MEASURE9,
507: POA_MEASURE10, POA_MEASURE11,
508: POA_MEASURE12 '
509: || poa_dbi_util_pkg.get_bucket_outer_query(
510: p_bucket_rec
511: , p_col_name => 'POA_MEASURE13'
512: , p_alias_name => 'POA_MEASURE13'
513: , p_prefix => ''

Line 531: || poa_dbi_util_pkg.get_bucket_outer_query(

527: nvl(c_pen_po_appr_amt,0) POA_MEASURE6
528: ';
529:
530: l_sel_clause := l_sel_clause || fnd_global.newline
531: || poa_dbi_util_pkg.get_bucket_outer_query(
532: p_bucket_rec
533: , p_col_name => 'c_unproc_amt_age'
534: , p_alias_name => 'POA_MEASURE7'
535: , p_prefix => 'nvl('

Line 544: || poa_dbi_util_pkg.get_bucket_outer_query(

540: nvl(c_pen_src_amt_total,0) POA_MEASURE9,
541: nvl(c_pen_buyer_wk_amt_total,0) POA_MEASURE10,
542: nvl(c_pen_po_submit_amt_total,0) POA_MEASURE11,
543: nvl(c_pen_po_appr_amt_total,0) POA_MEASURE12'
544: || poa_dbi_util_pkg.get_bucket_outer_query(
545: p_bucket_rec
546: , p_col_name => 'c_unproc_amt_age'
547: , p_alias_name => 'POA_MEASURE13'
548: , p_prefix => 'nvl('

Line 587: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

583: x_custom_sql OUT NOCOPY VARCHAR2,
584: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
585: IS
586:
587: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
588: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
589: l_query varchar2(10000);
590: l_view_by varchar2(120);
591: l_view_by_col varchar2(120);

Line 588: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

584: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
585: IS
586:
587: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
588: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
589: l_query varchar2(10000);
590: l_view_by varchar2(120);
591: l_view_by_col varchar2(120);
592: l_as_of_date date;

Line 598: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

594: l_xtd varchar2(10);
595: l_comparison_type varchar2(1);
596: l_nested_pattern number;
597: l_cur_suffix varchar2(2);
598: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
599: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
600: l_where_clause VARCHAR2(2000);
601: l_mv VARCHAR2(30);
602: l_view_by_value varchar2(30);

Line 599: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;

595: l_comparison_type varchar2(1);
596: l_nested_pattern number;
597: l_cur_suffix varchar2(2);
598: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
599: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
600: l_where_clause VARCHAR2(2000);
601: l_mv VARCHAR2(30);
602: l_view_by_value varchar2(30);
603: l_bucket_rec BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE;

Line 609: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();

605: ERR_CDE NUMBER;
606:
607: BEGIN
608:
609: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
610: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
611: l_comparison_type := 'Y';
612: poa_dbi_sutil_pkg.process_parameters(p_param
613: ,l_view_by

Line 610: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();

606:
607: BEGIN
608:
609: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
610: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
611: l_comparison_type := 'Y';
612: poa_dbi_sutil_pkg.process_parameters(p_param
613: ,l_view_by
614: ,l_view_by_col

Line 633: poa_dbi_util_pkg.add_bucket_columns(

629: ,p_version => '7.1'
630: ,p_role => 'VPP'
631: ,p_mv_set => 'REQS');
632:
633: poa_dbi_util_pkg.add_bucket_columns(
634: p_short_name => 'POA_DBI_UPR_BUCKET'
635: ,p_col_tbl => l_col_tbl
636: ,p_col_name => 'unprocessed_cnt_age'
637: ,p_alias_name => 'unproc_cnt_age'

Line 640: ,p_prior_code => poa_dbi_util_pkg.NO_PRIORS

636: ,p_col_name => 'unprocessed_cnt_age'
637: ,p_alias_name => 'unproc_cnt_age'
638: ,x_bucket_rec => l_bucket_rec
639: ,p_grand_total => 'Y'
640: ,p_prior_code => poa_dbi_util_pkg.NO_PRIORS
641: ,p_to_date_type => 'NA');
642:
643: poa_dbi_util_pkg.add_column(l_col_tbl
644: ,'num_days_unprocessed'

Line 643: poa_dbi_util_pkg.add_column(l_col_tbl

639: ,p_grand_total => 'Y'
640: ,p_prior_code => poa_dbi_util_pkg.NO_PRIORS
641: ,p_to_date_type => 'NA');
642:
643: poa_dbi_util_pkg.add_column(l_col_tbl
644: ,'num_days_unprocessed'
645: , 'num_days_unproc'
646: , p_grand_total => 'Y'
647: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 647: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

643: poa_dbi_util_pkg.add_column(l_col_tbl
644: ,'num_days_unprocessed'
645: , 'num_days_unproc'
646: , p_grand_total => 'Y'
647: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
648: , p_to_date_type => 'NA');
649:
650:
651: poa_dbi_util_pkg.add_column(l_col_tbl

Line 651: poa_dbi_util_pkg.add_column(l_col_tbl

647: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
648: , p_to_date_type => 'NA');
649:
650:
651: poa_dbi_util_pkg.add_column(l_col_tbl
652: ,'unprocessed_cnt'
653: , 'unproc_cnt'
654: , p_grand_total => 'Y'
655: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 655: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

651: poa_dbi_util_pkg.add_column(l_col_tbl
652: ,'unprocessed_cnt'
653: , 'unproc_cnt'
654: , p_grand_total => 'Y'
655: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
656: , p_to_date_type => 'NA');
657:
658:
659: if(l_view_by = 'ITEM+POA_ITEMS') then

Line 660: poa_dbi_util_pkg.add_column(l_col_tbl

656: , p_to_date_type => 'NA');
657:
658:
659: if(l_view_by = 'ITEM+POA_ITEMS') then
660: poa_dbi_util_pkg.add_column(l_col_tbl
661: , 'unprocessed_qty'
662: , 'unproc_qty'
663: , p_grand_total => 'N'
664: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 664: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

660: poa_dbi_util_pkg.add_column(l_col_tbl
661: , 'unprocessed_qty'
662: , 'unproc_qty'
663: , p_grand_total => 'N'
664: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
665: , p_to_date_type => 'NA');
666:
667: end if;
668: l_query := get_age_sel_clause(l_view_by

Line 727: || poa_dbi_util_pkg.get_bucket_outer_query(

723: l_sel_clause := l_sel_clause ||
724: ' oset.POA_MEASURE7 POA_MEASURE7, -- Avg Age (days)
725: oset.POA_MEASURE2 POA_MEASURE2 -- Unprocessed Lines'
726: || fnd_global.newline
727: || poa_dbi_util_pkg.get_bucket_outer_query(
728: p_bucket_rec
729: , p_col_name => 'oset.POA_MEASURE3'
730: , p_alias_name => 'POA_MEASURE3'
731: , p_prefix => ''

Line 738: || poa_dbi_util_pkg.get_bucket_outer_query(

734: || fnd_global.newline || ',
735: oset.POA_MEASURE8 POA_MEASURE8, -- Grand Total by Avg Days
736: oset.POA_MEASURE4 POA_MEASURE4 -- Grand Total Unprocessed Lns'
737: || fnd_global.newline
738: || poa_dbi_util_pkg.get_bucket_outer_query(
739: p_bucket_rec
740: , p_col_name => 'oset.POA_MEASURE5'
741: , p_alias_name => 'POA_MEASURE5'
742: , p_prefix => ''

Line 748: poa_dbi_util_pkg.get_bucket_drill_url(

744: , p_total_flag => 'N')
745: || fnd_global.newline ;
746:
747: l_sel_clause := l_sel_clause ||
748: poa_dbi_util_pkg.get_bucket_drill_url(
749: p_bucket_rec
750: , 'POA_ATTRIBUTE5'
751: ,
752: '''pFunctionName=POA_DBI_UPR_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&POA_ATTRIBUTE10=1&POA_BUCKET+REQUISITION_AGING='

Line 777: || poa_dbi_util_pkg.get_bucket_outer_query(

773: end if;
774: l_sel_clause := l_sel_clause || ',
775: POA_MEASURE7,POA_MEASURE2'
776: || fnd_global.newline
777: || poa_dbi_util_pkg.get_bucket_outer_query(
778: p_bucket_rec
779: , p_col_name => 'POA_MEASURE3'
780: , p_alias_name => 'POA_MEASURE3'
781: , p_prefix => ''

Line 786: || poa_dbi_util_pkg.get_bucket_outer_query(

782: , p_suffix => ''
783: , p_total_flag => 'N')
784: || fnd_global.newline ||
785: ' , POA_MEASURE8, POA_MEASURE4'
786: || poa_dbi_util_pkg.get_bucket_outer_query(
787: p_bucket_rec
788: , p_col_name => 'POA_MEASURE5'
789: , p_alias_name => 'POA_MEASURE5'
790: , p_prefix => ''

Line 805: || poa_dbi_util_pkg.get_bucket_outer_query(

801: nvl(c_unproc_cnt,0) POA_MEASURE2
802: ';
803:
804: l_sel_clause := l_sel_clause || fnd_global.newline
805: || poa_dbi_util_pkg.get_bucket_outer_query(
806: p_bucket_rec
807: , p_col_name => 'c_unproc_cnt_age'
808: , p_alias_name => 'POA_MEASURE3'
809: , p_prefix => 'nvl('

Line 815: || poa_dbi_util_pkg.get_bucket_outer_query(

811: , p_total_flag => 'N')
812: || fnd_global.newline || ',
813: nvl(c_num_days_unproc_total,0)/decode(c_unproc_cnt_total,0,null,c_unproc_cnt_total) POA_MEASURE8,
814: nvl(c_unproc_cnt_total,0) POA_MEASURE4'
815: || poa_dbi_util_pkg.get_bucket_outer_query(
816: p_bucket_rec
817: , p_col_name => 'c_unproc_cnt_age'
818: , p_alias_name => 'POA_MEASURE5'
819: , p_prefix => 'nvl('

Line 852: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

848: x_custom_sql OUT NOCOPY VARCHAR2,
849: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
850: IS
851:
852: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
853: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
854: l_query varchar2(10000);
855: l_view_by varchar2(120);
856: l_view_by_col varchar2(120);

Line 853: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

849: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
850: IS
851:
852: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
853: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
854: l_query varchar2(10000);
855: l_view_by varchar2(120);
856: l_view_by_col varchar2(120);
857: l_as_of_date date;

Line 863: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

859: l_xtd varchar2(10);
860: l_comparison_type varchar2(1);
861: l_nested_pattern number;
862: l_cur_suffix varchar2(2);
863: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
864: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
865: l_where_clause VARCHAR2(2000);
866: l_mv VARCHAR2(30);
867: l_view_by_value varchar2(30);

Line 864: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;

860: l_comparison_type varchar2(1);
861: l_nested_pattern number;
862: l_cur_suffix varchar2(2);
863: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
864: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
865: l_where_clause VARCHAR2(2000);
866: l_mv VARCHAR2(30);
867: l_view_by_value varchar2(30);
868: ERR_MSG VARCHAR2(100);

Line 874: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();

870:
871:
872: BEGIN
873:
874: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
875: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
876: l_comparison_type := 'Y';
877: poa_dbi_sutil_pkg.process_parameters(p_param
878: ,l_view_by

Line 875: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();

871:
872: BEGIN
873:
874: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
875: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
876: l_comparison_type := 'Y';
877: poa_dbi_sutil_pkg.process_parameters(p_param
878: ,l_view_by
879: ,l_view_by_col

Line 897: poa_dbi_util_pkg.add_column(l_col_tbl

893: ,p_func_area => 'PO'
894: ,p_version => '7.1'
895: ,p_role => 'VPP'
896: ,p_mv_set => 'REQS');
897: poa_dbi_util_pkg.add_column(l_col_tbl
898: ,'pen_src_cnt'
899: ,'pen_src_cnt'
900: , p_grand_total => 'Y'
901: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 901: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

897: poa_dbi_util_pkg.add_column(l_col_tbl
898: ,'pen_src_cnt'
899: ,'pen_src_cnt'
900: , p_grand_total => 'Y'
901: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
902: , p_to_date_type => 'NA');
903:
904:
905: poa_dbi_util_pkg.add_column(l_col_tbl

Line 905: poa_dbi_util_pkg.add_column(l_col_tbl

901: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
902: , p_to_date_type => 'NA');
903:
904:
905: poa_dbi_util_pkg.add_column(l_col_tbl
906: ,'pen_buyer_wk_cnt'
907: ,'pen_buyer_wk_cnt'
908: , p_grand_total => 'Y'
909: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 909: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

905: poa_dbi_util_pkg.add_column(l_col_tbl
906: ,'pen_buyer_wk_cnt'
907: ,'pen_buyer_wk_cnt'
908: , p_grand_total => 'Y'
909: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
910: , p_to_date_type => 'NA');
911:
912:
913: poa_dbi_util_pkg.add_column(l_col_tbl

Line 913: poa_dbi_util_pkg.add_column(l_col_tbl

909: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
910: , p_to_date_type => 'NA');
911:
912:
913: poa_dbi_util_pkg.add_column(l_col_tbl
914: ,'pen_po_submit_cnt'
915: ,'pen_po_submit_cnt'
916: , p_grand_total => 'Y'
917: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 917: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

913: poa_dbi_util_pkg.add_column(l_col_tbl
914: ,'pen_po_submit_cnt'
915: ,'pen_po_submit_cnt'
916: , p_grand_total => 'Y'
917: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
918: , p_to_date_type => 'NA');
919:
920:
921: poa_dbi_util_pkg.add_column(l_col_tbl

Line 921: poa_dbi_util_pkg.add_column(l_col_tbl

917: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
918: , p_to_date_type => 'NA');
919:
920:
921: poa_dbi_util_pkg.add_column(l_col_tbl
922: ,'pen_po_appr_cnt'
923: ,'pen_po_appr_cnt'
924: , p_grand_total => 'Y'
925: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 925: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

921: poa_dbi_util_pkg.add_column(l_col_tbl
922: ,'pen_po_appr_cnt'
923: ,'pen_po_appr_cnt'
924: , p_grand_total => 'Y'
925: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
926: , p_to_date_type => 'NA');
927:
928:
929:

Line 930: poa_dbi_util_pkg.add_column(l_col_tbl

926: , p_to_date_type => 'NA');
927:
928:
929:
930: poa_dbi_util_pkg.add_column(l_col_tbl
931: ,'unprocessed_cnt'
932: , 'unproc_cnt'
933: , p_grand_total => 'Y'
934: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 934: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

930: poa_dbi_util_pkg.add_column(l_col_tbl
931: ,'unprocessed_cnt'
932: , 'unproc_cnt'
933: , p_grand_total => 'Y'
934: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
935: , p_to_date_type => 'NA');
936:
937:
938: poa_dbi_util_pkg.add_column(l_col_tbl

Line 938: poa_dbi_util_pkg.add_column(l_col_tbl

934: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
935: , p_to_date_type => 'NA');
936:
937:
938: poa_dbi_util_pkg.add_column(l_col_tbl
939: ,'unprocessed_ped_cnt'
940: , 'unproc_ped_cnt'
941: , p_grand_total => 'Y'
942: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 942: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

938: poa_dbi_util_pkg.add_column(l_col_tbl
939: ,'unprocessed_ped_cnt'
940: , 'unproc_ped_cnt'
941: , p_grand_total => 'Y'
942: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
943: , p_to_date_type => 'NA');
944:
945: poa_dbi_util_pkg.add_column(l_col_tbl
946: ,'unprocessed_emer_cnt'

Line 945: poa_dbi_util_pkg.add_column(l_col_tbl

941: , p_grand_total => 'Y'
942: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
943: , p_to_date_type => 'NA');
944:
945: poa_dbi_util_pkg.add_column(l_col_tbl
946: ,'unprocessed_emer_cnt'
947: , 'unproc_emer_cnt'
948: , p_grand_total => 'Y'
949: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 949: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

945: poa_dbi_util_pkg.add_column(l_col_tbl
946: ,'unprocessed_emer_cnt'
947: , 'unproc_emer_cnt'
948: , p_grand_total => 'Y'
949: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
950: , p_to_date_type => 'NA');
951:
952: poa_dbi_util_pkg.add_column(l_col_tbl
953: ,'unprocessed_urg_cnt'

Line 952: poa_dbi_util_pkg.add_column(l_col_tbl

948: , p_grand_total => 'Y'
949: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
950: , p_to_date_type => 'NA');
951:
952: poa_dbi_util_pkg.add_column(l_col_tbl
953: ,'unprocessed_urg_cnt'
954: , 'unproc_urg_cnt'
955: , p_grand_total => 'Y'
956: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 956: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

952: poa_dbi_util_pkg.add_column(l_col_tbl
953: ,'unprocessed_urg_cnt'
954: , 'unproc_urg_cnt'
955: , p_grand_total => 'Y'
956: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
957: , p_to_date_type => 'NA');
958:
959: if(l_view_by = 'ITEM+POA_ITEMS') then
960: poa_dbi_util_pkg.add_column(l_col_tbl

Line 960: poa_dbi_util_pkg.add_column(l_col_tbl

956: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
957: , p_to_date_type => 'NA');
958:
959: if(l_view_by = 'ITEM+POA_ITEMS') then
960: poa_dbi_util_pkg.add_column(l_col_tbl
961: , 'unprocessed_qty'
962: , 'unproc_qty'
963: , p_grand_total => 'N'
964: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 964: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

960: poa_dbi_util_pkg.add_column(l_col_tbl
961: , 'unprocessed_qty'
962: , 'unproc_qty'
963: , p_grand_total => 'N'
964: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
965: , p_to_date_type => 'NA');
966:
967: end if;
968: l_query := get_sum_sel_clause(l_view_by, l_view_by_col) || ' from '||

Line 1152: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

1148: IS
1149: l_query varchar2(10000);
1150: l_cur_suffix varchar2(2);
1151: l_where_clause varchar2(2000);
1152: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
1153: l_in_join_tables VARCHAR2(240) ;
1154: l_context NUMBER;
1155: l_context_where VARCHAR2(240);
1156: l_bucket VARCHAR2(50);

Line 1213: poa_dbi_util_pkg.bind_low_high(p_param

1209: ||' and (&RANGE_HIGH is null or '
1210: ||'(to_date(&REQ_FACT_UPDATE_DATE,''DD/MM/YYYY HH24:MI:SS'')-fact.req_approved_date)'
1211: || ' < &RANGE_HIGH)';
1212:
1213: poa_dbi_util_pkg.bind_low_high(p_param
1214: , 'POA_DBI_UPR_BUCKET'
1215: , 'POA_BUCKET+REQUISITION_AGING'
1216: , '&RANGE_LOW'
1217: , '&RANGE_HIGH'

Line 1369: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);

1365: end if;
1366:
1367: x_custom_sql := x_custom_sql || '
1368: ORDER BY rnk';
1369: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);
1370:
1371: end;
1372: end poa_dbi_upr_pkg;