APPS.POA_DBI_CUD_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 10: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

6: FUNCTION get_pcl_dtl_filter_where return VARCHAR2;
7:
8: PROCEDURE con_drill_rpt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
9: x_custom_sql OUT NOCOPY VARCHAR2,
10: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
11: IS
12: l_query varchar2(8000);
13: l_cur_suffix varchar2(2);
14: l_where_clause varchar2(2000);

Line 20: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

16: l_in_join_tables VARCHAR2(1000) ;
17: l_sec_context varchar2(10);
18: BEGIN
19: l_in_join_tables := '';
20: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
21:
22: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
23: if(l_sec_context = 'OU' or l_sec_context = 'OU/COM') then
24: poa_dbi_sutil_pkg.drill_process_parameters(

Line 154: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

150:
151:
152: PROCEDURE ncp_drill_rpt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
153: x_custom_sql OUT NOCOPY VARCHAR2,
154: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
155: IS
156: l_query varchar2(10000);
157: l_cur_suffix varchar2(2);
158: l_where_clause varchar2(2000);

Line 164: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

160: l_in_join_tables VARCHAR2(1000);
161: l_sec_context varchar2(10);
162: BEGIN
163: l_in_join_tables := '';
164: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
165:
166: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
167: if(l_sec_context = 'OU' or l_sec_context = 'OU/COM') then
168: poa_dbi_sutil_pkg.drill_process_parameters(

Line 265: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

261: end;
262:
263: PROCEDURE pcl_drill_rpt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
264: x_custom_sql OUT NOCOPY VARCHAR2,
265: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
266: IS
267: l_query varchar2(10000);
268: l_cur_suffix varchar2(2);
269: l_where_clause varchar2(2000);

Line 275: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

271: l_in_join_tables VARCHAR2(1000) ;
272: l_sec_context varchar2(10);
273: BEGIN
274: l_in_join_tables := '';
275: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
276:
277: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
278: if(l_sec_context = 'OU' or l_sec_context = 'OU/COM') then
279: poa_dbi_sutil_pkg.drill_process_parameters(