DBA Data[Home] [Help]

APPS.POA_DBI_POP_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 19: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

15: -- public methods
16:
17: PROCEDURE status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
18: x_custom_sql OUT NOCOPY VARCHAR2,
19: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
20: IS
21: l_query varchar2(4000);
22: l_view_by varchar2(120);
23: l_view_by_col varchar2(120);

Line 80: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

76:
77:
78: PROCEDURE trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
79: x_custom_sql OUT NOCOPY VARCHAR2,
80: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
81: IS
82: l_query varchar2(32000);
83: l_view_by varchar2(120);
84: l_view_by_col varchar2(120);

Line 132: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

128: END;
129:
130: PROCEDURE kpi_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
131: x_custom_sql OUT NOCOPY VARCHAR2,
132: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
133: IS
134:
135: l_query varchar2(4000);
136: l_view_by varchar2(120);

Line 153: l_custom_rec BIS_QUERY_ATTRIBUTES;

149: l_where_clause varchar2(1000);
150: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
151: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
152: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
153: l_custom_rec BIS_QUERY_ATTRIBUTES;
154: l_view_by_value VARCHAR2(100);
155: l_sel_clause VARCHAR2(4000);
156: l_context_code VARCHAR2(10);
157: l_to_date_type VARCHAR2(10);