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

Line 30: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

26: l_nested_pattern number;
27: l_cur_suffix varchar2(2);
28: l_url varchar2(300);
29: l_custom_sql varchar2(4000);
30: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
31: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
32: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
33: l_where_clause VARCHAR2(2000);
34: l_view_by_value VARCHAR2(100);

Line 31: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

27: l_cur_suffix varchar2(2);
28: l_url varchar2(300);
29: l_custom_sql varchar2(4000);
30: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
31: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
32: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
33: l_where_clause VARCHAR2(2000);
34: l_view_by_value VARCHAR2(100);
35: l_mv VARCHAR2(30);

Line 32: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

28: l_url varchar2(300);
29: l_custom_sql varchar2(4000);
30: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
31: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
32: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
33: l_where_clause VARCHAR2(2000);
34: l_view_by_value VARCHAR2(100);
35: l_mv VARCHAR2(30);
36: l_context_code VARCHAR2(30);

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

35: l_mv VARCHAR2(30);
36: l_context_code VARCHAR2(30);
37: l_to_date_type VARCHAR2(30);
38: BEGIN
39: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
40: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
41:
42: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value, l_comparison_type,
43: l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern,

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

36: l_context_code VARCHAR2(30);
37: l_to_date_type VARCHAR2(30);
38: BEGIN
39: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
40: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
41:
42: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value, l_comparison_type,
43: l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern,
44: l_where_clause, l_mv, l_join_tbl, l_in_join_tbl,

Line 55: poa_dbi_util_pkg.add_column(l_col_tbl, 'manual_dist_count', 'manual_dist_count',p_to_date_type => l_to_date_type);

51: ELSE
52: l_to_date_type := 'XTD';
53: END IF;
54:
55: poa_dbi_util_pkg.add_column(l_col_tbl, 'manual_dist_count', 'manual_dist_count',p_to_date_type => l_to_date_type);
56: poa_dbi_util_pkg.add_column(l_col_tbl, 'dist_count', 'dist_count',p_to_date_type => l_to_date_type);
57:
58: if((l_view_by = 'HRI_PERSON+HRI_PER') and (l_view_by_value is not null) and (instr(l_view_by_value,',') = 0)) then
59: l_url := null;

Line 56: poa_dbi_util_pkg.add_column(l_col_tbl, 'dist_count', 'dist_count',p_to_date_type => l_to_date_type);

52: l_to_date_type := 'XTD';
53: END IF;
54:
55: poa_dbi_util_pkg.add_column(l_col_tbl, 'manual_dist_count', 'manual_dist_count',p_to_date_type => l_to_date_type);
56: poa_dbi_util_pkg.add_column(l_col_tbl, 'dist_count', 'dist_count',p_to_date_type => l_to_date_type);
57:
58: if((l_view_by = 'HRI_PERSON+HRI_PER') and (l_view_by_value is not null) and (instr(l_view_by_value,',') = 0)) then
59: l_url := null;
60: else

Line 91: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

87: l_comparison_type varchar2(1) := 'Y';
88: l_nested_pattern number;
89: l_cur_suffix varchar2(2);
90: l_custom_sql varchar2(4000);
91: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
92: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
93: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
94: l_mv VARCHAR2(30);
95: l_where_clause VARCHAR2(4000);

Line 92: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

88: l_nested_pattern number;
89: l_cur_suffix varchar2(2);
90: l_custom_sql varchar2(4000);
91: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
92: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
93: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
94: l_mv VARCHAR2(30);
95: l_where_clause VARCHAR2(4000);
96: l_view_by_value VARCHAR2(100);

Line 93: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

89: l_cur_suffix varchar2(2);
90: l_custom_sql varchar2(4000);
91: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
92: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
93: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
94: l_mv VARCHAR2(30);
95: l_where_clause VARCHAR2(4000);
96: l_view_by_value VARCHAR2(100);
97: l_context_code VARCHAR2(30);

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

96: l_view_by_value VARCHAR2(100);
97: l_context_code VARCHAR2(30);
98: l_to_date_type VARCHAR2(30);
99: BEGIN
100: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
101: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
102:
103: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value,l_comparison_type,
104: l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern,

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

97: l_context_code VARCHAR2(30);
98: l_to_date_type VARCHAR2(30);
99: BEGIN
100: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
101: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
102:
103: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value,l_comparison_type,
104: l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern,
105: l_where_clause, l_mv, l_join_tbl, l_in_join_tbl,x_custom_output,

Line 114: poa_dbi_util_pkg.add_column(l_col_tbl, 'manual_dist_count', 'manual_dist_count', 'N',p_to_date_type => l_to_date_type);

110: l_to_date_type := 'RLX';
111: ELSE
112: l_to_date_type := 'XTD';
113: END IF;
114: poa_dbi_util_pkg.add_column(l_col_tbl, 'manual_dist_count', 'manual_dist_count', 'N',p_to_date_type => l_to_date_type);
115: poa_dbi_util_pkg.add_column(l_col_tbl, 'dist_count', 'dist_count', 'N',p_to_date_type => l_to_date_type);
116:
117: l_query := get_trend_sel_clause || ' from
118: '|| poa_dbi_template_pkg.trend_sql(

Line 115: poa_dbi_util_pkg.add_column(l_col_tbl, 'dist_count', 'dist_count', 'N',p_to_date_type => l_to_date_type);

111: ELSE
112: l_to_date_type := 'XTD';
113: END IF;
114: poa_dbi_util_pkg.add_column(l_col_tbl, 'manual_dist_count', 'manual_dist_count', 'N',p_to_date_type => l_to_date_type);
115: poa_dbi_util_pkg.add_column(l_col_tbl, 'dist_count', 'dist_count', 'N',p_to_date_type => l_to_date_type);
116:
117: l_query := get_trend_sel_clause || ' from
118: '|| poa_dbi_template_pkg.trend_sql(
119: l_xtd,

Line 145: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

141: l_nested_pattern number;
142: l_org_where varchar2(500);
143: l_cur_suffix varchar2(2);
144: l_custom_sql varchar2(4000);
145: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
146: l_where_clause varchar2(1000);
147: l_mv varchar2(30);
148: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
149: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 148: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;

144: l_custom_sql varchar2(4000);
145: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
146: l_where_clause varchar2(1000);
147: l_mv varchar2(30);
148: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
149: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
150: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
151: l_custom_rec BIS_QUERY_ATTRIBUTES;
152: l_view_by_value VARCHAR2(100);

Line 149: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

145: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
146: l_where_clause varchar2(1000);
147: l_mv varchar2(30);
148: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
149: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
150: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
151: l_custom_rec BIS_QUERY_ATTRIBUTES;
152: l_view_by_value VARCHAR2(100);
153: l_context_code VARCHAR2(30);

Line 150: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

146: l_where_clause varchar2(1000);
147: l_mv varchar2(30);
148: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
149: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
150: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
151: l_custom_rec BIS_QUERY_ATTRIBUTES;
152: l_view_by_value VARCHAR2(100);
153: l_context_code VARCHAR2(30);
154: l_to_date_type VARCHAR2(30);

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

152: l_view_by_value VARCHAR2(100);
153: l_context_code VARCHAR2(30);
154: l_to_date_type VARCHAR2(30);
155: BEGIN
156: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
157: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
158:
159: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value,l_comparison_type,
160: l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern,

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

153: l_context_code VARCHAR2(30);
154: l_to_date_type VARCHAR2(30);
155: BEGIN
156: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
157: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
158:
159: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value,l_comparison_type,
160: l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern,
161: l_where_clause, l_mv, l_join_tbl, l_in_join_tbl,x_custom_output,

Line 170: poa_dbi_util_pkg.add_column(l_col_tbl, 'manual_dist_count', 'manual_dist_count',p_to_date_type => l_to_date_type);

166: l_to_date_type := 'RLX';
167: ELSE
168: l_to_date_type := 'XTD';
169: END IF;
170: poa_dbi_util_pkg.add_column(l_col_tbl, 'manual_dist_count', 'manual_dist_count',p_to_date_type => l_to_date_type);
171: poa_dbi_util_pkg.add_column(l_col_tbl, 'dist_count', 'dist_count',p_to_date_type => l_to_date_type);
172:
173: l_query :=
174: 'select v.value VIEWBY,

Line 171: poa_dbi_util_pkg.add_column(l_col_tbl, 'dist_count', 'dist_count',p_to_date_type => l_to_date_type);

167: ELSE
168: l_to_date_type := 'XTD';
169: END IF;
170: poa_dbi_util_pkg.add_column(l_col_tbl, 'manual_dist_count', 'manual_dist_count',p_to_date_type => l_to_date_type);
171: poa_dbi_util_pkg.add_column(l_col_tbl, 'dist_count', 'dist_count',p_to_date_type => l_to_date_type);
172:
173: l_query :=
174: 'select v.value VIEWBY,
175: v.id VIEWBYID,

Line 183: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count','c_dist_count') || ' POA_PERCENT1,

179: oset.POA_MEASURE2 POA_MEASURE2
180: from
181: (select * from
182: (select ' || l_view_by_col || ',
183: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count','c_dist_count') || ' POA_PERCENT1,
184: ' || poa_dbi_util_pkg.rate_clause('p_manual_dist_count','p_dist_count') || ' POA_PERCENT2,
185: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count_total','c_dist_count_total') || ' POA_MEASURE1,
186: ' || poa_dbi_util_pkg.rate_clause('p_manual_dist_count_total','p_dist_count_total') || ' POA_MEASURE2
187: from

Line 184: ' || poa_dbi_util_pkg.rate_clause('p_manual_dist_count','p_dist_count') || ' POA_PERCENT2,

180: from
181: (select * from
182: (select ' || l_view_by_col || ',
183: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count','c_dist_count') || ' POA_PERCENT1,
184: ' || poa_dbi_util_pkg.rate_clause('p_manual_dist_count','p_dist_count') || ' POA_PERCENT2,
185: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count_total','c_dist_count_total') || ' POA_MEASURE1,
186: ' || poa_dbi_util_pkg.rate_clause('p_manual_dist_count_total','p_dist_count_total') || ' POA_MEASURE2
187: from
188: ' || poa_dbi_template_pkg.status_sql(l_mv,

Line 185: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count_total','c_dist_count_total') || ' POA_MEASURE1,

181: (select * from
182: (select ' || l_view_by_col || ',
183: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count','c_dist_count') || ' POA_PERCENT1,
184: ' || poa_dbi_util_pkg.rate_clause('p_manual_dist_count','p_dist_count') || ' POA_PERCENT2,
185: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count_total','c_dist_count_total') || ' POA_MEASURE1,
186: ' || poa_dbi_util_pkg.rate_clause('p_manual_dist_count_total','p_dist_count_total') || ' POA_MEASURE2
187: from
188: ' || poa_dbi_template_pkg.status_sql(l_mv,
189: l_where_clause,

Line 186: ' || poa_dbi_util_pkg.rate_clause('p_manual_dist_count_total','p_dist_count_total') || ' POA_MEASURE2

182: (select ' || l_view_by_col || ',
183: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count','c_dist_count') || ' POA_PERCENT1,
184: ' || poa_dbi_util_pkg.rate_clause('p_manual_dist_count','p_dist_count') || ' POA_PERCENT2,
185: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count_total','c_dist_count_total') || ' POA_MEASURE1,
186: ' || poa_dbi_util_pkg.rate_clause('p_manual_dist_count_total','p_dist_count_total') || ' POA_MEASURE2
187: from
188: ' || poa_dbi_template_pkg.status_sql(l_mv,
189: l_where_clause,
190: l_join_tbl,

Line 266: ' || poa_dbi_util_pkg.change_clause('c_manual_dist_count','p_manual_dist_count') || ' POA_PERCENT1,

262: POA_MEASURE5, POA_MEASURE6, POA_MEASURE7 from
263: (select '||p_view_by_col_name||', '||
264: p_view_by_col_name ||' VIEWBY,
265: nvl(c_manual_dist_count,0) POA_MEASURE1,
266: ' || poa_dbi_util_pkg.change_clause('c_manual_dist_count','p_manual_dist_count') || ' POA_PERCENT1,
267: nvl(c_dist_count,0) POA_MEASURE3,
268: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count','c_dist_count') || ' POA_PERCENT2,
269: nvl(c_manual_dist_count_total,0) POA_MEASURE4,
270: nvl(c_dist_count_total,0) POA_MEASURE5,

Line 268: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count','c_dist_count') || ' POA_PERCENT2,

264: p_view_by_col_name ||' VIEWBY,
265: nvl(c_manual_dist_count,0) POA_MEASURE1,
266: ' || poa_dbi_util_pkg.change_clause('c_manual_dist_count','p_manual_dist_count') || ' POA_PERCENT1,
267: nvl(c_dist_count,0) POA_MEASURE3,
268: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count','c_dist_count') || ' POA_PERCENT2,
269: nvl(c_manual_dist_count_total,0) POA_MEASURE4,
270: nvl(c_dist_count_total,0) POA_MEASURE5,
271: ' || poa_dbi_util_pkg.change_clause('c_manual_dist_count_total','p_manual_dist_count_total') || ' POA_MEASURE6,
272: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count_total','c_dist_count_total') || ' POA_MEASURE7';

Line 271: ' || poa_dbi_util_pkg.change_clause('c_manual_dist_count_total','p_manual_dist_count_total') || ' POA_MEASURE6,

267: nvl(c_dist_count,0) POA_MEASURE3,
268: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count','c_dist_count') || ' POA_PERCENT2,
269: nvl(c_manual_dist_count_total,0) POA_MEASURE4,
270: nvl(c_dist_count_total,0) POA_MEASURE5,
271: ' || poa_dbi_util_pkg.change_clause('c_manual_dist_count_total','p_manual_dist_count_total') || ' POA_MEASURE6,
272: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count_total','c_dist_count_total') || ' POA_MEASURE7';
273: return l_sel_clause;
274:
275: end;

Line 272: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count_total','c_dist_count_total') || ' POA_MEASURE7';

268: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count','c_dist_count') || ' POA_PERCENT2,
269: nvl(c_manual_dist_count_total,0) POA_MEASURE4,
270: nvl(c_dist_count_total,0) POA_MEASURE5,
271: ' || poa_dbi_util_pkg.change_clause('c_manual_dist_count_total','p_manual_dist_count_total') || ' POA_MEASURE6,
272: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count_total','c_dist_count_total') || ' POA_MEASURE7';
273: return l_sel_clause;
274:
275: end;
276:

Line 288: ' || poa_dbi_util_pkg.change_clause('c_manual_dist_count','p_manual_dist_count') || ' POA_PERCENT3,

284: 'select cal.name VIEWBY,
285: nvl(p_manual_dist_count,0) POA_MEASURE1,
286: nvl(c_manual_dist_count,0) POA_MEASURE2,
287: nvl(p_manual_dist_count,0) POA_PERCENT1,
288: ' || poa_dbi_util_pkg.change_clause('c_manual_dist_count','p_manual_dist_count') || ' POA_PERCENT3,
289: nvl(c_manual_dist_count,0) POA_PERCENT2';
290:
291: return l_sel_clause;
292: