APPS.OPI_DBI_INV_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 74: BIS_QUERY_ATTRIBUTES_TBL)

70:
71: PROCEDURE inv_turns_tbl_sql(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
72: x_custom_sql OUT NOCOPY VARCHAR2,
73: x_custom_output OUT NOCOPY
74: BIS_QUERY_ATTRIBUTES_TBL)
75: IS
76: l_query varchar2(8000);
77: l_view_by varchar2(120);
78: l_as_of_date date;

Line 181: x_custom_output := bis_query_attributes_tbl();

177: l_total_col_tbl);
178:
179:
180: -- empty the output table because we have no bind values to pass back
181: x_custom_output := bis_query_attributes_tbl();
182:
183: -- return the query
184: x_custom_sql := l_query;
185:

Line 399: BIS_QUERY_ATTRIBUTES_TBL)

395:
396: PROCEDURE inv_turns_trd_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
397: x_custom_sql OUT NOCOPY VARCHAR2,
398: x_custom_output OUT NOCOPY
399: BIS_QUERY_ATTRIBUTES_TBL)
400: IS
401: l_query varchar2(12000);
402: l_view_by varchar2(120);
403: l_as_of_date date;

Line 422: l_custom_attr_rec BIS_QUERY_ATTRIBUTES;

418: l_col_tbl OPI_DBI_COL_TBL;
419: l_total_col_tbl OPI_DBI_COL_TBL;
420:
421:
422: l_custom_attr_rec BIS_QUERY_ATTRIBUTES;
423: l_period_type VARCHAR2(30);
424:
425: BEGIN
426:

Line 507: x_custom_output := bis_query_attributes_tbl();

503: l_period_type := 'FII_TIME_WEEK';
504: end if;
505:
506: l_custom_attr_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
507: x_custom_output := bis_query_attributes_tbl();
508:
509: l_custom_attr_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
510: l_custom_attr_rec.attribute_value := 'TIME+'||l_period_type;
511: l_custom_attr_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;