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

Line 30: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;

26: l_cur_suffix VARCHAR2(10);
27: l_currency VARCHAR2(10);
28: l_custom_sql VARCHAR2 (10000);
29:
30: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;
31: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
32: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
33: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
34: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

Line 31: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;

27: l_currency VARCHAR2(10);
28: l_custom_sql VARCHAR2 (10000);
29:
30: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;
31: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
32: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
33: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
34: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
35:

Line 32: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

28: l_custom_sql VARCHAR2 (10000);
29:
30: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;
31: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
32: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
33: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
34: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
35:
36: l_where_clause VARCHAR2 (2000);

Line 33: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

29:
30: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;
31: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
32: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
33: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
34: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
35:
36: l_where_clause VARCHAR2 (2000);
37: l_mv1 VARCHAR2 (30);

Line 34: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

30: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;
31: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
32: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
33: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
34: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
35:
36: l_where_clause VARCHAR2 (2000);
37: l_mv1 VARCHAR2 (30);
38: l_mv2 VARCHAR2 (30);

Line 53: l_col_tbl1 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

49: l_aggregation_level_flag1 := '0';
50: l_aggregation_level_flag2 := '0';
51:
52: -- clear out the tables.
53: l_col_tbl1 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
54: l_col_tbl2 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
55: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
56: x_custom_sql := l_query;
57:

Line 54: l_col_tbl2 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

50: l_aggregation_level_flag2 := '0';
51:
52: -- clear out the tables.
53: l_col_tbl1 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
54: l_col_tbl2 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
55: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
56: x_custom_sql := l_query;
57:
58: -- get all the query parameters

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

51:
52: -- clear out the tables.
53: l_col_tbl1 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
54: l_col_tbl2 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
55: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
56: x_custom_sql := l_query;
57:
58: -- get all the query parameters
59: isc_dbi_sutil_pkg.process_parameters (

Line 90: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,

86: ELSE l_currency := 'g';
87: END IF;
88:
89:
90: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
91: p_col_name => 'fully_paid_amt_'|| l_currency,
92: p_alias_name => 'fully_paid_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 (p_col_tbl => l_col_tbl1,
91: p_col_name => 'fully_paid_amt_'|| l_currency,
92: p_alias_name => 'fully_paid_amt',
93: p_grand_total => 'N',
94: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
95: p_to_date_type => 'XTD');
96:
97: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
98: p_col_name => 'bill_amt_' || l_currency,

Line 97: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,

93: p_grand_total => 'N',
94: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
95: p_to_date_type => 'XTD');
96:
97: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
98: p_col_name => 'bill_amt_' || l_currency,
99: p_alias_name => 'bill_amt',
100: p_grand_total => 'N',
101: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 101: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

97: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
98: p_col_name => 'bill_amt_' || l_currency,
99: p_alias_name => 'bill_amt',
100: p_grand_total => 'N',
101: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
102: p_to_date_type => 'XTD');
103:
104: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
105: p_col_name => 'approved_amt_'||l_currency,

Line 104: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,

100: p_grand_total => 'N',
101: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
102: p_to_date_type => 'XTD');
103:
104: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
105: p_col_name => 'approved_amt_'||l_currency,
106: p_alias_name => 'approved_amt',
107: p_grand_total => 'N',
108: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 108: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

104: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
105: p_col_name => 'approved_amt_'||l_currency,
106: p_alias_name => 'approved_amt',
107: p_grand_total => 'N',
108: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
109: p_to_date_type => 'XTD');
110:
111:
112:

Line 148: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2,

144: ELSE l_currency := 'g';
145: END IF;
146:
147:
148: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2,
149: p_col_name => 'payment_amt_'||l_currency,
150: p_alias_name => 'payment_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 (p_col_tbl => l_col_tbl2,
149: p_col_name => 'payment_amt_'||l_currency,
150: p_alias_name => 'payment_amt',
151: p_grand_total => 'N',
152: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
153: p_to_date_type => 'XTD');
154:
155:
156: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();

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

152: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
153: p_to_date_type => 'XTD');
154:
155:
156: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
157:
158: l_mv_tbl.extend;
159: l_mv_tbl(1).mv_name := l_mv1;
160: l_mv_tbl(1).mv_col := l_col_tbl1;

Line 194: poa_dbi_util_pkg.get_custom_trend_binds (

190:
191: -- get all the basic binds used by POA queries
192: -- Do this before adding any of our binds, since the procedure
193: -- reinitializes the output table
194: poa_dbi_util_pkg.get_custom_trend_binds (
195: p_xtd => l_xtd2,
196: p_comparison_type => l_comparison_type,
197: x_custom_output => x_custom_output);
198: