APPS.POA_DBI_SUTIL_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 20: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,

16: p_trend IN VARCHAR2,
17: p_mv_set IN VARCHAR2,
18: p_xtd IN VARCHAR2,
19: p_comparison_type IN VARCHAR2,
20: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,
21: p_context_code IN VARCHAR2,
22: p_param IN BIS_PMV_PAGE_PARAMETER_TBL
23: ) ;
24: function get_msg (p_current in varchar2)return varchar2;

Line 27: p_custom_output IN OUT NOCOPY bis_query_attributes_tbl)

23: ) ;
24: function get_msg (p_current in varchar2)return varchar2;
25:
26: PROCEDURE bind_reqfact_date(
27: p_custom_output IN OUT NOCOPY bis_query_attributes_tbl)
28: is
29: l_last_refresh_date date;
30: l_custom_rec BIS_QUERY_ATTRIBUTES;
31: begin

Line 30: l_custom_rec BIS_QUERY_ATTRIBUTES;

26: PROCEDURE bind_reqfact_date(
27: p_custom_output IN OUT NOCOPY bis_query_attributes_tbl)
28: is
29: l_last_refresh_date date;
30: l_custom_rec BIS_QUERY_ATTRIBUTES;
31: begin
32:
33: IF p_custom_output is null THEN
34: p_custom_output := bis_query_attributes_tbl();

Line 34: p_custom_output := bis_query_attributes_tbl();

30: l_custom_rec BIS_QUERY_ATTRIBUTES;
31: begin
32:
33: IF p_custom_output is null THEN
34: p_custom_output := bis_query_attributes_tbl();
35: END IF;
36:
37: l_last_refresh_date := fnd_date.displaydt_to_date(
38: bis_collection_utilities.get_last_refresh_period('POAREQLN'));

Line 83: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,

79: p_where_clause out NOCOPY VARCHAR2,
80: p_mv out NOCOPY VARCHAR2,
81: p_join_tbl out NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl,
82: p_in_join_tbl out NOCOPY poa_dbi_util_pkg.poa_dbi_in_join_tbl,
83: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,
84: p_trend in VARCHAR2,
85: p_func_area IN VARCHAR2,
86: p_version IN VARCHAR2,
87: p_role IN VARCHAR2,

Line 1190: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,

1186: p_trend IN VARCHAR2,
1187: p_mv_set IN VARCHAR2,
1188: p_xtd IN VARCHAR2,
1189: p_comparison_type IN VARCHAR2,
1190: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,
1191: p_context_code IN VARCHAR2,
1192: p_param IN BIS_PMV_PAGE_PARAMETER_TBL
1193: )
1194: IS

Line 1195: l_custom_rec BIS_QUERY_ATTRIBUTES;

1191: p_context_code IN VARCHAR2,
1192: p_param IN BIS_PMV_PAGE_PARAMETER_TBL
1193: )
1194: IS
1195: l_custom_rec BIS_QUERY_ATTRIBUTES;
1196: BEGIN
1197: /* special case for PQC Cumulative trend, which cannot have the normal trend binds */
1198: if(p_trend = 'Y' and p_mv_set <> 'PQC') then
1199: poa_dbi_util_pkg.get_custom_trend_binds(p_xtd, p_comparison_type,x_custom_output);

Line 2304: x_custom_output in out nocopy bis_query_attributes_tbl,

2300: * This procedure populates x_custom_output with five binds that are
2301: * required for reports having company and cost center security.
2302: */
2303: procedure bind_com_cc_values(
2304: x_custom_output in out nocopy bis_query_attributes_tbl,
2305: p_param in bis_pmv_page_parameter_tbl
2306: )
2307: is
2308: l_company_value varchar2(30) := 'All';

Line 2313: l_custom_rec BIS_QUERY_ATTRIBUTES;

2309: l_top_company_value varchar2(30) := 'All';
2310: l_cost_ctr_value varchar2(30) := 'All';
2311: l_top_cost_ctr_value varchar2(30) := 'All';
2312: l_region_code varchar2(40);
2313: l_custom_rec BIS_QUERY_ATTRIBUTES;
2314: l_count number;
2315: begin
2316:
2317: for i in 1..p_param.count loop

Line 2379: x_custom_output := bis_query_attributes_tbl();

2375:
2376: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
2377:
2378: if x_custom_output is null then
2379: x_custom_output := bis_query_attributes_tbl();
2380: end if;
2381:
2382: l_custom_rec.attribute_name := '®IONCODE';
2383: l_custom_rec.attribute_value := l_region_code;