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.

[Home] [Help]

APPS.POA_DBI_REJ_PKG dependencies on POA_DBI_UTIL_PKG

Line 41: l_col_tbl POA_DBI_UTIL_PKG.POA_DBI_COL_TBL;

37: l_nested_pattern NUMBER;
38: l_cur_suffix VARCHAR2(2);
39: l_url VARCHAR2(300);
40: l_view_by_value VARCHAR2(30);
41: l_col_tbl POA_DBI_UTIL_PKG.POA_DBI_COL_TBL;
42: l_join_tbl POA_DBI_UTIL_PKG.POA_DBI_JOIN_TBL;
43: l_in_join_tbl POA_DBI_UTIL_PKG.POA_DBI_IN_JOIN_TBL;
44: l_where_clause VARCHAR2(2000);
45: l_mv VARCHAR2(30);

Line 42: l_join_tbl POA_DBI_UTIL_PKG.POA_DBI_JOIN_TBL;

38: l_cur_suffix VARCHAR2(2);
39: l_url VARCHAR2(300);
40: l_view_by_value VARCHAR2(30);
41: l_col_tbl POA_DBI_UTIL_PKG.POA_DBI_COL_TBL;
42: l_join_tbl POA_DBI_UTIL_PKG.POA_DBI_JOIN_TBL;
43: l_in_join_tbl POA_DBI_UTIL_PKG.POA_DBI_IN_JOIN_TBL;
44: l_where_clause VARCHAR2(2000);
45: l_mv VARCHAR2(30);
46: ERR_MSG VARCHAR2(100);

Line 43: l_in_join_tbl POA_DBI_UTIL_PKG.POA_DBI_IN_JOIN_TBL;

39: l_url VARCHAR2(300);
40: l_view_by_value VARCHAR2(30);
41: l_col_tbl POA_DBI_UTIL_PKG.POA_DBI_COL_TBL;
42: l_join_tbl POA_DBI_UTIL_PKG.POA_DBI_JOIN_TBL;
43: l_in_join_tbl POA_DBI_UTIL_PKG.POA_DBI_IN_JOIN_TBL;
44: l_where_clause VARCHAR2(2000);
45: l_mv VARCHAR2(30);
46: ERR_MSG VARCHAR2(100);
47: l_context_code VARCHAR2(10);

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

46: ERR_MSG VARCHAR2(100);
47: l_context_code VARCHAR2(10);
48: l_to_date_type VARCHAR2(10);
49: BEGIN
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:
53: poa_dbi_sutil_pkg.process_parameters(P_PARAM => p_param
54: ,P_VIEW_BY => l_view_by

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

47: l_context_code VARCHAR2(10);
48: l_to_date_type VARCHAR2(10);
49: BEGIN
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:
53: poa_dbi_sutil_pkg.process_parameters(P_PARAM => p_param
54: ,P_VIEW_BY => l_view_by
55: ,P_VIEW_BY_COL_NAME => l_view_by_col

Line 80: poa_dbi_util_pkg.add_column(l_col_tbl

76: ELSE
77: l_to_date_type := 'XTD';
78: END IF;
79:
80: poa_dbi_util_pkg.add_column(l_col_tbl
81: ,'amt_reject_' || l_cur_suffix
82: ,'amt_reject'
83: ,p_to_date_type => l_to_date_type);
84:

Line 85: poa_dbi_util_pkg.add_column(l_col_tbl

81: ,'amt_reject_' || l_cur_suffix
82: ,'amt_reject'
83: ,p_to_date_type => l_to_date_type);
84:
85: poa_dbi_util_pkg.add_column(l_col_tbl
86: ,'amt_receipt_' || l_cur_suffix
87: ,'amt_receipt'
88: ,p_to_date_type => l_to_date_type);
89:

Line 90: poa_dbi_util_pkg.add_column(l_col_tbl

86: ,'amt_receipt_' || l_cur_suffix
87: ,'amt_receipt'
88: ,p_to_date_type => l_to_date_type);
89:
90: poa_dbi_util_pkg.add_column(l_col_tbl
91: ,'amt_receipt_reject_' || l_cur_suffix
92: ,'amt_receipt_reject'
93: ,p_to_date_type => l_to_date_type);
94:

Line 95: poa_dbi_util_pkg.add_column(l_col_tbl

91: ,'amt_receipt_reject_' || l_cur_suffix
92: ,'amt_receipt_reject'
93: ,p_to_date_type => l_to_date_type);
94:
95: poa_dbi_util_pkg.add_column(l_col_tbl
96: ,'amt_inspected_' || l_cur_suffix
97: ,'amt_inspected'
98: ,p_to_date_type => l_to_date_type);
99:

Line 101: poa_dbi_util_pkg.add_column(l_col_tbl

97: ,'amt_inspected'
98: ,p_to_date_type => l_to_date_type);
99:
100: if(l_view_by = 'ITEM+POA_ITEMS') then
101: poa_dbi_util_pkg.add_column(l_col_tbl
102: ,'qty_reject'
103: ,'qty_reject'
104: ,p_to_date_type => l_to_date_type);
105:

Line 106: poa_dbi_util_pkg.add_column(l_col_tbl

102: ,'qty_reject'
103: ,'qty_reject'
104: ,p_to_date_type => l_to_date_type);
105:
106: poa_dbi_util_pkg.add_column(l_col_tbl
107: ,'qty_receipt'
108: ,'qty_receipt'
109: ,p_to_date_type => l_to_date_type);
110:

Line 247: '|| poa_dbi_util_pkg.change_clause('c_amt_reject','p_amt_reject') || ' POA_PERCENT1,

243: decode(base_uom,null,to_number(null),nvl(c_qty_receipt,0)) POA_MEASURE2, ';
244: END IF;
245: --
246: l_sel_clause := l_sel_clause || ' nvl(c_amt_reject,0) POA_MEASURE3,
247: '|| poa_dbi_util_pkg.change_clause('c_amt_reject','p_amt_reject') || ' POA_PERCENT1,
248: '|| 'nvl(c_amt_receipt,0) POA_MEASURE4,
249: nvl(c_amt_receipt_reject,0) POA_MEASURE5,
250: '|| poa_dbi_util_pkg.rate_clause('c_amt_receipt_reject','c_amt_receipt') || ' POA_PERCENT2,
251: '||'nvl(c_amt_inspected,0) POA_MEASURE7,

Line 250: '|| poa_dbi_util_pkg.rate_clause('c_amt_receipt_reject','c_amt_receipt') || ' POA_PERCENT2,

246: l_sel_clause := l_sel_clause || ' nvl(c_amt_reject,0) POA_MEASURE3,
247: '|| poa_dbi_util_pkg.change_clause('c_amt_reject','p_amt_reject') || ' POA_PERCENT1,
248: '|| 'nvl(c_amt_receipt,0) POA_MEASURE4,
249: nvl(c_amt_receipt_reject,0) POA_MEASURE5,
250: '|| poa_dbi_util_pkg.rate_clause('c_amt_receipt_reject','c_amt_receipt') || ' POA_PERCENT2,
251: '||'nvl(c_amt_inspected,0) POA_MEASURE7,
252: '|| poa_dbi_util_pkg.rate_clause('c_amt_reject','c_amt_inspected') || ' POA_MEASURE8,
253: '|| 'nvl(c_amt_reject_total,0) POA_MEASURE9,
254: '|| poa_dbi_util_pkg.change_clause('c_amt_reject_total','p_amt_reject_total') || ' POA_MEASURE10,

Line 252: '|| poa_dbi_util_pkg.rate_clause('c_amt_reject','c_amt_inspected') || ' POA_MEASURE8,

248: '|| 'nvl(c_amt_receipt,0) POA_MEASURE4,
249: nvl(c_amt_receipt_reject,0) POA_MEASURE5,
250: '|| poa_dbi_util_pkg.rate_clause('c_amt_receipt_reject','c_amt_receipt') || ' POA_PERCENT2,
251: '||'nvl(c_amt_inspected,0) POA_MEASURE7,
252: '|| poa_dbi_util_pkg.rate_clause('c_amt_reject','c_amt_inspected') || ' POA_MEASURE8,
253: '|| 'nvl(c_amt_reject_total,0) POA_MEASURE9,
254: '|| poa_dbi_util_pkg.change_clause('c_amt_reject_total','p_amt_reject_total') || ' POA_MEASURE10,
255: '||' nvl(c_amt_receipt_total,0) POA_MEASURE11,
256: nvl(c_amt_receipt_reject_total,0) POA_MEASURE12,

Line 254: '|| poa_dbi_util_pkg.change_clause('c_amt_reject_total','p_amt_reject_total') || ' POA_MEASURE10,

250: '|| poa_dbi_util_pkg.rate_clause('c_amt_receipt_reject','c_amt_receipt') || ' POA_PERCENT2,
251: '||'nvl(c_amt_inspected,0) POA_MEASURE7,
252: '|| poa_dbi_util_pkg.rate_clause('c_amt_reject','c_amt_inspected') || ' POA_MEASURE8,
253: '|| 'nvl(c_amt_reject_total,0) POA_MEASURE9,
254: '|| poa_dbi_util_pkg.change_clause('c_amt_reject_total','p_amt_reject_total') || ' POA_MEASURE10,
255: '||' nvl(c_amt_receipt_total,0) POA_MEASURE11,
256: nvl(c_amt_receipt_reject_total,0) POA_MEASURE12,
257: '|| poa_dbi_util_pkg.rate_clause('c_amt_receipt_reject_total','c_amt_receipt_total') || ' POA_MEASURE13,
258: '|| ' nvl(c_amt_inspected_total,0) POA_MEASURE14,

Line 257: '|| poa_dbi_util_pkg.rate_clause('c_amt_receipt_reject_total','c_amt_receipt_total') || ' POA_MEASURE13,

253: '|| 'nvl(c_amt_reject_total,0) POA_MEASURE9,
254: '|| poa_dbi_util_pkg.change_clause('c_amt_reject_total','p_amt_reject_total') || ' POA_MEASURE10,
255: '||' nvl(c_amt_receipt_total,0) POA_MEASURE11,
256: nvl(c_amt_receipt_reject_total,0) POA_MEASURE12,
257: '|| poa_dbi_util_pkg.rate_clause('c_amt_receipt_reject_total','c_amt_receipt_total') || ' POA_MEASURE13,
258: '|| ' nvl(c_amt_inspected_total,0) POA_MEASURE14,
259: '|| poa_dbi_util_pkg.rate_clause('c_amt_reject_total','c_amt_inspected_total') || ' POA_MEASURE15,
260: '|| poa_dbi_util_pkg.rate_clause('p_amt_receipt_reject','p_amt_receipt') || ' POA_PERCENT3,
261: '|| poa_dbi_util_pkg.rate_clause('p_amt_receipt_reject_total','p_amt_receipt_total') || ' POA_PERCENT4

Line 259: '|| poa_dbi_util_pkg.rate_clause('c_amt_reject_total','c_amt_inspected_total') || ' POA_MEASURE15,

255: '||' nvl(c_amt_receipt_total,0) POA_MEASURE11,
256: nvl(c_amt_receipt_reject_total,0) POA_MEASURE12,
257: '|| poa_dbi_util_pkg.rate_clause('c_amt_receipt_reject_total','c_amt_receipt_total') || ' POA_MEASURE13,
258: '|| ' nvl(c_amt_inspected_total,0) POA_MEASURE14,
259: '|| poa_dbi_util_pkg.rate_clause('c_amt_reject_total','c_amt_inspected_total') || ' POA_MEASURE15,
260: '|| poa_dbi_util_pkg.rate_clause('p_amt_receipt_reject','p_amt_receipt') || ' POA_PERCENT3,
261: '|| poa_dbi_util_pkg.rate_clause('p_amt_receipt_reject_total','p_amt_receipt_total') || ' POA_PERCENT4
262: ';
263: --

Line 260: '|| poa_dbi_util_pkg.rate_clause('p_amt_receipt_reject','p_amt_receipt') || ' POA_PERCENT3,

256: nvl(c_amt_receipt_reject_total,0) POA_MEASURE12,
257: '|| poa_dbi_util_pkg.rate_clause('c_amt_receipt_reject_total','c_amt_receipt_total') || ' POA_MEASURE13,
258: '|| ' nvl(c_amt_inspected_total,0) POA_MEASURE14,
259: '|| poa_dbi_util_pkg.rate_clause('c_amt_reject_total','c_amt_inspected_total') || ' POA_MEASURE15,
260: '|| poa_dbi_util_pkg.rate_clause('p_amt_receipt_reject','p_amt_receipt') || ' POA_PERCENT3,
261: '|| poa_dbi_util_pkg.rate_clause('p_amt_receipt_reject_total','p_amt_receipt_total') || ' POA_PERCENT4
262: ';
263: --
264: RETURN l_sel_clause;

Line 261: '|| poa_dbi_util_pkg.rate_clause('p_amt_receipt_reject_total','p_amt_receipt_total') || ' POA_PERCENT4

257: '|| poa_dbi_util_pkg.rate_clause('c_amt_receipt_reject_total','c_amt_receipt_total') || ' POA_MEASURE13,
258: '|| ' nvl(c_amt_inspected_total,0) POA_MEASURE14,
259: '|| poa_dbi_util_pkg.rate_clause('c_amt_reject_total','c_amt_inspected_total') || ' POA_MEASURE15,
260: '|| poa_dbi_util_pkg.rate_clause('p_amt_receipt_reject','p_amt_receipt') || ' POA_PERCENT3,
261: '|| poa_dbi_util_pkg.rate_clause('p_amt_receipt_reject_total','p_amt_receipt_total') || ' POA_PERCENT4
262: ';
263: --
264: RETURN l_sel_clause;
265: END get_status_sel_clause;

Line 289: l_col_tbl POA_DBI_UTIL_PKG.POA_DBI_COL_TBL;

285: l_url VARCHAR2(300);
286: l_view_by_value VARCHAR2(30);
287: l_where_clause VARCHAR2(2000);
288: l_mv VARCHAR2(30);
289: l_col_tbl POA_DBI_UTIL_PKG.POA_DBI_COL_TBL;
290: l_join_tbl POA_DBI_UTIL_PKG.POA_DBI_JOIN_TBL;
291: l_in_join_tbl POA_DBI_UTIL_PKG.POA_DBI_IN_JOIN_TBL;
292: ERR_MSG VARCHAR2(100);
293: l_context_code VARCHAR2(10);

Line 290: l_join_tbl POA_DBI_UTIL_PKG.POA_DBI_JOIN_TBL;

286: l_view_by_value VARCHAR2(30);
287: l_where_clause VARCHAR2(2000);
288: l_mv VARCHAR2(30);
289: l_col_tbl POA_DBI_UTIL_PKG.POA_DBI_COL_TBL;
290: l_join_tbl POA_DBI_UTIL_PKG.POA_DBI_JOIN_TBL;
291: l_in_join_tbl POA_DBI_UTIL_PKG.POA_DBI_IN_JOIN_TBL;
292: ERR_MSG VARCHAR2(100);
293: l_context_code VARCHAR2(10);
294: l_to_date_type VARCHAR2(10);

Line 291: l_in_join_tbl POA_DBI_UTIL_PKG.POA_DBI_IN_JOIN_TBL;

287: l_where_clause VARCHAR2(2000);
288: l_mv VARCHAR2(30);
289: l_col_tbl POA_DBI_UTIL_PKG.POA_DBI_COL_TBL;
290: l_join_tbl POA_DBI_UTIL_PKG.POA_DBI_JOIN_TBL;
291: l_in_join_tbl POA_DBI_UTIL_PKG.POA_DBI_IN_JOIN_TBL;
292: ERR_MSG VARCHAR2(100);
293: l_context_code VARCHAR2(10);
294: l_to_date_type VARCHAR2(10);
295: BEGIN

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

292: ERR_MSG VARCHAR2(100);
293: l_context_code VARCHAR2(10);
294: l_to_date_type VARCHAR2(10);
295: BEGIN
296: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
297: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
298: --
299: poa_dbi_sutil_pkg.process_parameters(p_param => p_param
300: ,p_view_by => l_view_by

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

293: l_context_code VARCHAR2(10);
294: l_to_date_type VARCHAR2(10);
295: BEGIN
296: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
297: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
298: --
299: poa_dbi_sutil_pkg.process_parameters(p_param => p_param
300: ,p_view_by => l_view_by
301: ,p_view_by_col_name => l_view_by_col

Line 326: poa_dbi_util_pkg.add_column(l_col_tbl,'amt_reject_' || l_cur_suffix,'amt_reject',p_to_date_type => l_to_date_type);

322: l_to_date_type := 'RLX';
323: ELSE
324: l_to_date_type := 'XTD';
325: END IF;
326: poa_dbi_util_pkg.add_column(l_col_tbl,'amt_reject_' || l_cur_suffix,'amt_reject',p_to_date_type => l_to_date_type);
327: poa_dbi_util_pkg.add_column(l_col_tbl,'amt_receipt_reject_' || l_cur_suffix,'amt_receipt_reject',p_to_date_type => l_to_date_type);
328: l_query := get_reason_sel_clause(P_VIEW_BY_DIM => l_view_by
329: ,P_VIEW_BY_COL => l_view_by_col
330: ,P_URL => null)

Line 327: poa_dbi_util_pkg.add_column(l_col_tbl,'amt_receipt_reject_' || l_cur_suffix,'amt_receipt_reject',p_to_date_type => l_to_date_type);

323: ELSE
324: l_to_date_type := 'XTD';
325: END IF;
326: poa_dbi_util_pkg.add_column(l_col_tbl,'amt_reject_' || l_cur_suffix,'amt_reject',p_to_date_type => l_to_date_type);
327: poa_dbi_util_pkg.add_column(l_col_tbl,'amt_receipt_reject_' || l_cur_suffix,'amt_receipt_reject',p_to_date_type => l_to_date_type);
328: l_query := get_reason_sel_clause(P_VIEW_BY_DIM => l_view_by
329: ,P_VIEW_BY_COL => l_view_by_col
330: ,P_URL => null)
331: || ' FROM ' ||

Line 399: ' || poa_dbi_util_pkg.change_clause('c_amt_reject','p_amt_reject') || ' POA_PERCENT1,

395: POA_MEASURE3,POA_MEASURE4
396: FROM (SELECT ' || p_view_by_col || ',' || p_view_by_col || ' VIEWBY,' || p_view_by_col || ' VIEWBYID, ' || p_view_by_col || ' POA_ATTRIBUTE1,';
397: l_sel_clause := l_sel_clause || '
398: nvl(c_amt_reject,0) POA_MEASURE1,
399: ' || poa_dbi_util_pkg.change_clause('c_amt_reject','p_amt_reject') || ' POA_PERCENT1,
400: ' || poa_dbi_util_pkg.rate_clause('c_amt_reject','c_amt_reject_total') || 'POA_PERCENT2,
401: ' || ' c_amt_reject_total POA_MEASURE2,
402: ' || poa_dbi_util_pkg.change_clause('c_amt_reject_total','p_amt_reject_total') || ' POA_MEASURE3,
403: ' || poa_dbi_util_pkg.rate_clause('c_amt_reject_total','c_amt_reject_total') || ' POA_MEASURE4

Line 400: ' || poa_dbi_util_pkg.rate_clause('c_amt_reject','c_amt_reject_total') || 'POA_PERCENT2,

396: FROM (SELECT ' || p_view_by_col || ',' || p_view_by_col || ' VIEWBY,' || p_view_by_col || ' VIEWBYID, ' || p_view_by_col || ' POA_ATTRIBUTE1,';
397: l_sel_clause := l_sel_clause || '
398: nvl(c_amt_reject,0) POA_MEASURE1,
399: ' || poa_dbi_util_pkg.change_clause('c_amt_reject','p_amt_reject') || ' POA_PERCENT1,
400: ' || poa_dbi_util_pkg.rate_clause('c_amt_reject','c_amt_reject_total') || 'POA_PERCENT2,
401: ' || ' c_amt_reject_total POA_MEASURE2,
402: ' || poa_dbi_util_pkg.change_clause('c_amt_reject_total','p_amt_reject_total') || ' POA_MEASURE3,
403: ' || poa_dbi_util_pkg.rate_clause('c_amt_reject_total','c_amt_reject_total') || ' POA_MEASURE4
404: ';

Line 402: ' || poa_dbi_util_pkg.change_clause('c_amt_reject_total','p_amt_reject_total') || ' POA_MEASURE3,

398: nvl(c_amt_reject,0) POA_MEASURE1,
399: ' || poa_dbi_util_pkg.change_clause('c_amt_reject','p_amt_reject') || ' POA_PERCENT1,
400: ' || poa_dbi_util_pkg.rate_clause('c_amt_reject','c_amt_reject_total') || 'POA_PERCENT2,
401: ' || ' c_amt_reject_total POA_MEASURE2,
402: ' || poa_dbi_util_pkg.change_clause('c_amt_reject_total','p_amt_reject_total') || ' POA_MEASURE3,
403: ' || poa_dbi_util_pkg.rate_clause('c_amt_reject_total','c_amt_reject_total') || ' POA_MEASURE4
404: ';
405: RETURN l_sel_clause;
406: END get_reason_sel_clause;

Line 403: ' || poa_dbi_util_pkg.rate_clause('c_amt_reject_total','c_amt_reject_total') || ' POA_MEASURE4

399: ' || poa_dbi_util_pkg.change_clause('c_amt_reject','p_amt_reject') || ' POA_PERCENT1,
400: ' || poa_dbi_util_pkg.rate_clause('c_amt_reject','c_amt_reject_total') || 'POA_PERCENT2,
401: ' || ' c_amt_reject_total POA_MEASURE2,
402: ' || poa_dbi_util_pkg.change_clause('c_amt_reject_total','p_amt_reject_total') || ' POA_MEASURE3,
403: ' || poa_dbi_util_pkg.rate_clause('c_amt_reject_total','c_amt_reject_total') || ' POA_MEASURE4
404: ';
405: RETURN l_sel_clause;
406: END get_reason_sel_clause;
407: --