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_SPND_PKG dependencies on POA_DBI_UTIL_PKG

Line 28: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

24: l_comparison_type VARCHAR2(1) ;
25: l_cur_suffix VARCHAR2(10);
26: l_url VARCHAR2(300);
27: l_view_by_value VARCHAR2(30);
28: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
29: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
30: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
31: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
32: l_where_clause VARCHAR2(2000);

Line 29: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

25: l_cur_suffix VARCHAR2(10);
26: l_url VARCHAR2(300);
27: l_view_by_value VARCHAR2(30);
28: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
29: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
30: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
31: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
32: l_where_clause VARCHAR2(2000);
33: l_mv VARCHAR2(30);

Line 30: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

26: l_url VARCHAR2(300);
27: l_view_by_value VARCHAR2(30);
28: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
29: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
30: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
31: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
32: l_where_clause VARCHAR2(2000);
33: l_mv VARCHAR2(30);
34: ERR_MSG VARCHAR2(100);

Line 31: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;

27: l_view_by_value VARCHAR2(30);
28: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
29: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
30: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
31: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
32: l_where_clause VARCHAR2(2000);
33: l_mv VARCHAR2(30);
34: ERR_MSG VARCHAR2(100);
35: ERR_CDE NUMBER;

Line 39: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;

35: ERR_CDE NUMBER;
36: l_context_code VARCHAR2(10);
37: l_to_date_type VARCHAR2(10);
38:
39: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;
40: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
41: l_col_tbl3 poa_dbi_util_pkg.POA_DBI_COL_TBL;
42: l_col_tbl4 poa_dbi_util_pkg.POA_DBI_COL_TBL;
43: l_where_clause1 VARCHAR2 (2000);

Line 40: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;

36: l_context_code VARCHAR2(10);
37: l_to_date_type VARCHAR2(10);
38:
39: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;
40: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
41: l_col_tbl3 poa_dbi_util_pkg.POA_DBI_COL_TBL;
42: l_col_tbl4 poa_dbi_util_pkg.POA_DBI_COL_TBL;
43: l_where_clause1 VARCHAR2 (2000);
44: l_where_clause2 VARCHAR2 (2000);

Line 41: l_col_tbl3 poa_dbi_util_pkg.POA_DBI_COL_TBL;

37: l_to_date_type VARCHAR2(10);
38:
39: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;
40: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
41: l_col_tbl3 poa_dbi_util_pkg.POA_DBI_COL_TBL;
42: l_col_tbl4 poa_dbi_util_pkg.POA_DBI_COL_TBL;
43: l_where_clause1 VARCHAR2 (2000);
44: l_where_clause2 VARCHAR2 (2000);
45: l_where_clause3 VARCHAR2 (2000);

Line 42: l_col_tbl4 poa_dbi_util_pkg.POA_DBI_COL_TBL;

38:
39: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;
40: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
41: l_col_tbl3 poa_dbi_util_pkg.POA_DBI_COL_TBL;
42: l_col_tbl4 poa_dbi_util_pkg.POA_DBI_COL_TBL;
43: l_where_clause1 VARCHAR2 (2000);
44: l_where_clause2 VARCHAR2 (2000);
45: l_where_clause3 VARCHAR2 (2000);
46: l_where_clause4 VARCHAR2 (2000);

Line 51: l_in_join_tbl1 poa_dbi_util_pkg.poa_dbi_in_join_tbl;

47: l_mv1 VARCHAR2 (30);
48: l_mv2 VARCHAR2 (30);
49: l_mv3 VARCHAR2 (30);
50: l_mv4 VARCHAR2 (30);
51: l_in_join_tbl1 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
52: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
53: l_in_join_tbl3 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
54: l_in_join_tbl4 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
55: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

Line 52: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;

48: l_mv2 VARCHAR2 (30);
49: l_mv3 VARCHAR2 (30);
50: l_mv4 VARCHAR2 (30);
51: l_in_join_tbl1 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
52: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
53: l_in_join_tbl3 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
54: l_in_join_tbl4 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
55: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
56:

Line 53: l_in_join_tbl3 poa_dbi_util_pkg.poa_dbi_in_join_tbl;

49: l_mv3 VARCHAR2 (30);
50: l_mv4 VARCHAR2 (30);
51: l_in_join_tbl1 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
52: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
53: l_in_join_tbl3 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
54: l_in_join_tbl4 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
55: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
56:
57: l_file varchar2(500);

Line 54: l_in_join_tbl4 poa_dbi_util_pkg.poa_dbi_in_join_tbl;

50: l_mv4 VARCHAR2 (30);
51: l_in_join_tbl1 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
52: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
53: l_in_join_tbl3 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
54: l_in_join_tbl4 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
55: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
56:
57: l_file varchar2(500);
58: BEGIN

Line 55: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

51: l_in_join_tbl1 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
52: l_in_join_tbl2 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
53: l_in_join_tbl3 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
54: l_in_join_tbl4 poa_dbi_util_pkg.poa_dbi_in_join_tbl;
55: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
56:
57: l_file varchar2(500);
58: BEGIN
59: l_comparison_type := 'Y';

Line 61: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl();

57: l_file varchar2(500);
58: BEGIN
59: l_comparison_type := 'Y';
60:
61: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl();
62: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl();
63: l_col_tbl3 := poa_dbi_util_pkg.poa_dbi_col_tbl();
64: l_col_tbl4 := poa_dbi_util_pkg.poa_dbi_col_tbl();
65:

Line 62: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl();

58: BEGIN
59: l_comparison_type := 'Y';
60:
61: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl();
62: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl();
63: l_col_tbl3 := poa_dbi_util_pkg.poa_dbi_col_tbl();
64: l_col_tbl4 := poa_dbi_util_pkg.poa_dbi_col_tbl();
65:
66: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl();

Line 63: l_col_tbl3 := poa_dbi_util_pkg.poa_dbi_col_tbl();

59: l_comparison_type := 'Y';
60:
61: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl();
62: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl();
63: l_col_tbl3 := poa_dbi_util_pkg.poa_dbi_col_tbl();
64: l_col_tbl4 := poa_dbi_util_pkg.poa_dbi_col_tbl();
65:
66: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl();
67:

Line 64: l_col_tbl4 := poa_dbi_util_pkg.poa_dbi_col_tbl();

60:
61: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl();
62: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl();
63: l_col_tbl3 := poa_dbi_util_pkg.poa_dbi_col_tbl();
64: l_col_tbl4 := poa_dbi_util_pkg.poa_dbi_col_tbl();
65:
66: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl();
67:
68: ---Get the Invoice Amount Entered Measure

Line 66: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl();

62: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl();
63: l_col_tbl3 := poa_dbi_util_pkg.poa_dbi_col_tbl();
64: l_col_tbl4 := poa_dbi_util_pkg.poa_dbi_col_tbl();
65:
66: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl();
67:
68: ---Get the Invoice Amount Entered Measure
69: poa_dbi_sutil_pkg.process_parameters(p_param,
70: l_view_by,

Line 90: poa_dbi_util_pkg.add_column(l_col_tbl1

86: p_version => '8.0',
87: p_role => 'VPP',
88: p_mv_set => 'FIIIV');
89:
90: poa_dbi_util_pkg.add_column(l_col_tbl1
91: , 'invoice_amt_entered_' || l_cur_suffix
92: , 'invoice_entered_amt'
93: , p_grand_total => 'N'
94: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 94: , p_prior_code => poa_dbi_util_pkg.both_priors

90: poa_dbi_util_pkg.add_column(l_col_tbl1
91: , 'invoice_amt_entered_' || l_cur_suffix
92: , 'invoice_entered_amt'
93: , p_grand_total => 'N'
94: , p_prior_code => poa_dbi_util_pkg.both_priors
95: , p_to_date_type => 'RLX');
96:
97: ---Get the Paid Amount Measure
98: poa_dbi_sutil_pkg.process_parameters(p_param,

Line 119: poa_dbi_util_pkg.add_column(l_col_tbl2

115: p_version => '8.0',
116: p_role => 'VPP',
117: p_mv_set => 'FIIPA');
118:
119: poa_dbi_util_pkg.add_column(l_col_tbl2
120: , 'paid_amt_' || l_cur_suffix
121: , 'paid_amt'
122: , p_grand_total => 'N'
123: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 123: , p_prior_code => poa_dbi_util_pkg.both_priors

119: poa_dbi_util_pkg.add_column(l_col_tbl2
120: , 'paid_amt_' || l_cur_suffix
121: , 'paid_amt'
122: , p_grand_total => 'N'
123: , p_prior_code => poa_dbi_util_pkg.both_priors
124: , p_to_date_type => 'RLX');
125:
126: ---Get the Purchased Amt. Measure
127: poa_dbi_sutil_pkg.process_parameters(p_param,

Line 148: poa_dbi_util_pkg.add_column(l_col_tbl3

144: p_version => '8.0',
145: p_role => 'VPP',
146: p_mv_set => 'POD');
147:
148: poa_dbi_util_pkg.add_column(l_col_tbl3
149: , 'purchase_amt_' || l_cur_suffix
150: , 'purchase_amt'
151: , p_grand_total => 'N'
152: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 152: , p_prior_code => poa_dbi_util_pkg.both_priors

148: poa_dbi_util_pkg.add_column(l_col_tbl3
149: , 'purchase_amt_' || l_cur_suffix
150: , 'purchase_amt'
151: , p_grand_total => 'N'
152: , p_prior_code => poa_dbi_util_pkg.both_priors
153: , p_to_date_type => 'RLX');
154:
155: --Get the Invoice Amt. which is Matched to PO mesaure
156: poa_dbi_sutil_pkg.process_parameters(p_param,

Line 177: poa_dbi_util_pkg.add_column(l_col_tbl4

173: p_version => '8.0',
174: p_role => 'VPP',
175: p_mv_set => 'API');
176:
177: poa_dbi_util_pkg.add_column(l_col_tbl4
178: , 'amount_' || l_cur_suffix
179: , 'invoice_matched_amt'
180: , p_grand_total => 'N'
181: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 181: , p_prior_code => poa_dbi_util_pkg.both_priors

177: poa_dbi_util_pkg.add_column(l_col_tbl4
178: , 'amount_' || l_cur_suffix
179: , 'invoice_matched_amt'
180: , p_grand_total => 'N'
181: , p_prior_code => poa_dbi_util_pkg.both_priors
182: , p_to_date_type => 'RLX');
183:
184: ---Now populate the MV table list
185: l_mv_tbl.extend;

Line 246: poa_dbi_util_pkg.change_clause('c_purchase_amt','p_purchase_amt') || ' POA_PERCENT1, ' ||

242: c_invoice_entered_amt POA_MEASURE2,
243: c_invoice_matched_amt POA_MEASURE3,
244: c_paid_amt POA_MEASURE4,'
245: ||
246: poa_dbi_util_pkg.change_clause('c_purchase_amt','p_purchase_amt') || ' POA_PERCENT1, ' ||
247: poa_dbi_util_pkg.change_clause('c_invoice_entered_amt','p_invoice_entered_amt') || ' POA_PERCENT2,'
248: || poa_dbi_util_pkg.change_clause('c_invoice_matched_amt','p_invoice_matched_amt') || ' POA_PERCENT3,'
249: || poa_dbi_util_pkg.change_clause('c_paid_amt','p_paid_amt') || ' POA_PERCENT4 ' ;
250:

Line 247: poa_dbi_util_pkg.change_clause('c_invoice_entered_amt','p_invoice_entered_amt') || ' POA_PERCENT2,'

243: c_invoice_matched_amt POA_MEASURE3,
244: c_paid_amt POA_MEASURE4,'
245: ||
246: poa_dbi_util_pkg.change_clause('c_purchase_amt','p_purchase_amt') || ' POA_PERCENT1, ' ||
247: poa_dbi_util_pkg.change_clause('c_invoice_entered_amt','p_invoice_entered_amt') || ' POA_PERCENT2,'
248: || poa_dbi_util_pkg.change_clause('c_invoice_matched_amt','p_invoice_matched_amt') || ' POA_PERCENT3,'
249: || poa_dbi_util_pkg.change_clause('c_paid_amt','p_paid_amt') || ' POA_PERCENT4 ' ;
250:
251: RETURN l_sel_clause;

Line 248: || poa_dbi_util_pkg.change_clause('c_invoice_matched_amt','p_invoice_matched_amt') || ' POA_PERCENT3,'

244: c_paid_amt POA_MEASURE4,'
245: ||
246: poa_dbi_util_pkg.change_clause('c_purchase_amt','p_purchase_amt') || ' POA_PERCENT1, ' ||
247: poa_dbi_util_pkg.change_clause('c_invoice_entered_amt','p_invoice_entered_amt') || ' POA_PERCENT2,'
248: || poa_dbi_util_pkg.change_clause('c_invoice_matched_amt','p_invoice_matched_amt') || ' POA_PERCENT3,'
249: || poa_dbi_util_pkg.change_clause('c_paid_amt','p_paid_amt') || ' POA_PERCENT4 ' ;
250:
251: RETURN l_sel_clause;
252: END get_trend_sel_clause ;

Line 249: || poa_dbi_util_pkg.change_clause('c_paid_amt','p_paid_amt') || ' POA_PERCENT4 ' ;

245: ||
246: poa_dbi_util_pkg.change_clause('c_purchase_amt','p_purchase_amt') || ' POA_PERCENT1, ' ||
247: poa_dbi_util_pkg.change_clause('c_invoice_entered_amt','p_invoice_entered_amt') || ' POA_PERCENT2,'
248: || poa_dbi_util_pkg.change_clause('c_invoice_matched_amt','p_invoice_matched_amt') || ' POA_PERCENT3,'
249: || poa_dbi_util_pkg.change_clause('c_paid_amt','p_paid_amt') || ' POA_PERCENT4 ' ;
250:
251: RETURN l_sel_clause;
252: END get_trend_sel_clause ;
253: