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

Line 27: l_col_tbl POA_DBI_UTIL_PKG.POA_DBI_COL_TBL;

23: l_comparison_type VARCHAR2(1) := 'Y';
24:
25: l_nested_pattern NUMBER;
26: l_cur_suffix VARCHAR2(2);
27: l_col_tbl POA_DBI_UTIL_PKG.POA_DBI_COL_TBL;
28: l_url VARCHAR2(300);
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_where_clause VARCHAR2(2000);

Line 29: l_join_tbl POA_DBI_UTIL_PKG.POA_DBI_JOIN_TBL;

25: l_nested_pattern NUMBER;
26: l_cur_suffix VARCHAR2(2);
27: l_col_tbl POA_DBI_UTIL_PKG.POA_DBI_COL_TBL;
28: l_url VARCHAR2(300);
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_where_clause VARCHAR2(2000);
32: l_mv VARCHAR2(30);
33: ERR_MSG VARCHAR2(100);

Line 30: l_in_join_tbl POA_DBI_UTIL_PKG.POA_DBI_IN_JOIN_TBL;

26: l_cur_suffix VARCHAR2(2);
27: l_col_tbl POA_DBI_UTIL_PKG.POA_DBI_COL_TBL;
28: l_url VARCHAR2(300);
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_where_clause VARCHAR2(2000);
32: l_mv VARCHAR2(30);
33: ERR_MSG VARCHAR2(100);
34: ERR_CDE NUMBER;

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

34: ERR_CDE NUMBER;
35: l_context_code VARCHAR2(10);
36: l_to_date_type VARCHAR2(10);
37: BEGIN
38: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
39: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
40: poa_dbi_sutil_pkg.process_parameters(p_param
41: ,l_view_by
42: ,l_view_by_col

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

35: l_context_code VARCHAR2(10);
36: l_to_date_type VARCHAR2(10);
37: BEGIN
38: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
39: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
40: poa_dbi_sutil_pkg.process_parameters(p_param
41: ,l_view_by
42: ,l_view_by_col
43: ,l_view_by_value

Line 68: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_'

64: l_to_date_type := 'XTD';
65: END IF;
66:
67:
68: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_'
69: || l_cur_suffix, 'purchase_amt',p_to_date_type => l_to_date_type);
70:
71: poa_dbi_util_pkg.add_column(l_col_tbl,
72: 'pbpcqcs_amt_' || l_cur_suffix, 'pbpcqcs_amt',p_to_date_type => l_to_date_type);

Line 71: poa_dbi_util_pkg.add_column(l_col_tbl,

67:
68: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_'
69: || l_cur_suffix, 'purchase_amt',p_to_date_type => l_to_date_type);
70:
71: poa_dbi_util_pkg.add_column(l_col_tbl,
72: 'pbpcqcs_amt_' || l_cur_suffix, 'pbpcqcs_amt',p_to_date_type => l_to_date_type);
73:
74:
75: if(l_view_by= 'ITEM+POA_ITEMS') then

Line 76: poa_dbi_util_pkg.add_column(l_col_tbl, 'quantity' , 'quantity',p_to_date_type => l_to_date_type);

72: 'pbpcqcs_amt_' || l_cur_suffix, 'pbpcqcs_amt',p_to_date_type => l_to_date_type);
73:
74:
75: if(l_view_by= 'ITEM+POA_ITEMS') then
76: poa_dbi_util_pkg.add_column(l_col_tbl, 'quantity' , 'quantity',p_to_date_type => l_to_date_type);
77: end if;
78:
79: if((l_view_by='ITEM+ENI_ITEM_PO_CAT') and (l_view_by_value is not null)
80: and (instr(l_view_by_value,',') =0)) then

Line 202: ' || poa_dbi_util_pkg.change_clause('c_purchase_amt','p_purchase_amt') || ' POA_PERCENT2,

198: l_sel_clause := l_sel_clause ||
199: 'nvl(c_purchase_amt,0) - nvl(c_pbpcqcs_amt,0) POA_MEASURE1,
200: ((c_purchase_amt - c_pbpcqcs_amt)/decode(c_purchase_amt,0,null,c_purchase_amt))*100 POA_PERCENT1,
201: nvl(c_purchase_amt,0) POA_MEASURE2,
202: ' || poa_dbi_util_pkg.change_clause('c_purchase_amt','p_purchase_amt') || ' POA_PERCENT2,
203: nvl(c_purchase_amt_total,0) - nvl(c_pbpcqcs_amt_total,0) POA_MEASURE3,
204: ((c_purchase_amt_total - c_pbpcqcs_amt_total)/decode(c_purchase_amt_total,0,null,c_purchase_amt_total))*100 POA_MEASURE4,
205: nvl(c_purchase_amt_total,0) POA_MEASURE5,
206: ' || poa_dbi_util_pkg.change_clause('c_purchase_amt_total','p_purchase_amt_total') || ' POA_MEASURE6,

Line 206: ' || poa_dbi_util_pkg.change_clause('c_purchase_amt_total','p_purchase_amt_total') || ' POA_MEASURE6,

202: ' || poa_dbi_util_pkg.change_clause('c_purchase_amt','p_purchase_amt') || ' POA_PERCENT2,
203: nvl(c_purchase_amt_total,0) - nvl(c_pbpcqcs_amt_total,0) POA_MEASURE3,
204: ((c_purchase_amt_total - c_pbpcqcs_amt_total)/decode(c_purchase_amt_total,0,null,c_purchase_amt_total))*100 POA_MEASURE4,
205: nvl(c_purchase_amt_total,0) POA_MEASURE5,
206: ' || poa_dbi_util_pkg.change_clause('c_purchase_amt_total','p_purchase_amt_total') || ' POA_MEASURE6,
207: nvl(p_purchase_amt,0) - nvl(p_pbpcqcs_amt,0) POA_MEASURE8,
208: nvl(p_purchase_amt_total,0) - nvl(p_pbpcqcs_amt_total,0) POA_MEASURE10';
209:
210: RETURN l_sel_clause;

Line 241: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

237: IS
238: l_query varchar2(8000);
239: l_cur_suffix varchar2(2);
240: l_where_clause varchar2(2000);
241: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
242: l_in_join_tables VARCHAR2(240) := '';
243: l_filter_where VARCHAR2(240);
244: BEGIN
245:

Line 403: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);

399: ORDER BY rnk';
400:
401: x_custom_sql := l_query;
402:
403: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);
404:
405: end;
406:
407: END POA_DBI_PC_PKG;