APPS.BIV_DBI_BAK_AGE_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 224: , p_custom_output in out nocopy bis_query_attributes_tbl

220:
221: procedure get_age_binds
222: ( p_period_type in varchar2
223: , p_comparison_type in varchar2
224: , p_custom_output in out nocopy bis_query_attributes_tbl
225: )
226: is
227:
228: l_lag number;

Line 235: l_custom_rec BIS_QUERY_ATTRIBUTES;

231: l_current_date date;
232: l_prior_date date;
233: l_current_start_date date;
234: last_refresh_date date;
235: l_custom_rec BIS_QUERY_ATTRIBUTES;
236:
237: begin
238:
239: select max(trunc(report_date))

Line 402: p_custom_output := bis_query_attributes_tbl();

398:
399: last_refresh_date := get_last_refresh_date('BIV_B_AGE_H_SUM_MV');
400:
401: if p_custom_output is null then
402: p_custom_output := bis_query_attributes_tbl();
403: end if;
404:
405: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
406:

Line 594: , x_custom_output out nocopy bis_query_attributes_tbl

590:
591: procedure get_tbl_sql
592: ( p_param in bis_pmv_page_parameter_tbl
593: , x_custom_sql out nocopy varchar2
594: , x_custom_output out nocopy bis_query_attributes_tbl
595: , p_distribution in varchar2 := 'N'
596: )
597: is
598:

Line 613: l_custom_output bis_query_attributes_tbl;

609:
610: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
611: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
612:
613: l_custom_output bis_query_attributes_tbl;
614:
615: l_to_date_type VARCHAR2 (3) ;
616: l_as_of_date date;
617:

Line 838: , x_custom_output out nocopy bis_query_attributes_tbl

834:
835: procedure get_dbn_tbl_sql
836: ( p_param in bis_pmv_page_parameter_tbl
837: , x_custom_sql out nocopy varchar2
838: , x_custom_output out nocopy bis_query_attributes_tbl
839: )
840: is
841: begin
842: get_tbl_sql

Line 855: , x_custom_output out nocopy bis_query_attributes_tbl

851:
852: procedure get_trd_sql
853: ( p_param in bis_pmv_page_parameter_tbl
854: , x_custom_sql out nocopy varchar2
855: , x_custom_output out nocopy bis_query_attributes_tbl
856: , p_distribution in varchar2 := 'N'
857: )
858: is
859:

Line 871: l_custom_output bis_query_attributes_tbl;

867: l_backlog_type varchar2(100);
868: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
869: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
870: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
871: l_custom_output bis_query_attributes_tbl;
872:
873: l_to_date_type VARCHAR2 (3) ;
874: l_as_of_date date;
875:

Line 1065: , x_custom_output out nocopy bis_query_attributes_tbl

1061:
1062: procedure get_dbn_trd_sql
1063: ( p_param in bis_pmv_page_parameter_tbl
1064: , x_custom_sql out nocopy varchar2
1065: , x_custom_output out nocopy bis_query_attributes_tbl
1066: )
1067: is
1068: begin
1069: get_trd_sql

Line 1082: , x_custom_output out nocopy bis_query_attributes_tbl

1078:
1079: procedure get_detail_sql
1080: ( p_param in bis_pmv_page_parameter_tbl
1081: , x_custom_sql out nocopy varchar2
1082: , x_custom_output out nocopy bis_query_attributes_tbl
1083: )as
1084:
1085: l_where_clause varchar2(10000);
1086: l_xtd varchar2(200);

Line 1094: l_custom_output bis_query_attributes_tbl;

1090: l_order_by varchar2(100);
1091: l_backlog_type varchar2(100);
1092:
1093: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1094: l_custom_output bis_query_attributes_tbl;
1095:
1096: l_drill_url varchar2(500);
1097: l_sr_id varchar2(100);
1098: