DBA Data[Home] [Help]

APPS.OPI_DBI_CURR_VAR_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 20: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

16:
17:
18: PROCEDURE curr_status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
19: x_custom_sql OUT NOCOPY VARCHAR2,
20: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
21: IS
22: l_query VARCHAR2(15000);
23: l_view_by VARCHAR2(120);
24: l_view_by_col VARCHAR2 (120);

Line 43: l_custom_rec BIS_QUERY_ATTRIBUTES;

39: l_org varchar(30);
40:
41: l_item_cat_flag varchar2(1) := '0';
42:
43: l_custom_rec BIS_QUERY_ATTRIBUTES;
44:
45: BEGIN
46:
47: -- clear out the tables.

Line 111: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

107: );
108:
109:
110: -- prepare output for bind variables
111: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
112: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
113:
114: -- set the basic bind variables for the status SQL
115: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);