APPS.POA_DBI_UTIL_PKG dependencies on BIS_BUCKET_PUB

Line 457: , x_bucket_rec out nocopy bis_bucket_pub.bis_bucket_rec_type

453: (p_short_name in varchar2
454: , p_col_tbl in out nocopy poa_DBI_UTIL_PKG.poa_dbi_col_tbl
455: , p_col_name in varchar2
456: , p_alias_name in varchar2
457: , x_bucket_rec out nocopy bis_bucket_pub.bis_bucket_rec_type
458: , p_grand_total in varchar2 := 'Y'
459: , p_prior_code in varchar2 := BOTH_PRIORS
460: , p_to_date_type in varchar2 := 'XTD'
461: )

Line 463: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;

459: , p_prior_code in varchar2 := BOTH_PRIORS
460: , p_to_date_type in varchar2 := 'XTD'
461: )
462: is
463: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
464: l_return_status varchar2(3);
465: l_error_tbl bis_utilities_pub.error_tbl_type;
466: begin
467: bis_bucket_pub.retrieve_bis_bucket

Line 467: bis_bucket_pub.retrieve_bis_bucket

463: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
464: l_return_status varchar2(3);
465: l_error_tbl bis_utilities_pub.error_tbl_type;
466: begin
467: bis_bucket_pub.retrieve_bis_bucket
468: ( p_short_name => p_short_name
469: , x_bis_bucket_rec => l_bucket_rec
470: , x_return_status => l_return_status
471: , x_error_tbl => l_error_tbl

Line 625: ( p_bucket_rec in bis_bucket_pub.bis_bucket_rec_type

621: p_alias_name = similar to 'BIV_MEASURE10' => you want to alias
622: BIV_MEASURE10_B1, BIV_MEASURE10_B2, etc..
623: */
624: function get_bucket_outer_query
625: ( p_bucket_rec in bis_bucket_pub.bis_bucket_rec_type
626: , p_col_name in varchar2
627: , p_alias_name in varchar2
628: , p_prefix in varchar2
629: , p_suffix in varchar2

Line 706: ( p_bucket_rec in bis_bucket_pub.bis_bucket_rec_type

702: p_prefix || p_suffix || ' ' || p_alias_name || bucket_num
703:
704: ***************************************************************************/
705: function get_bucket_drill_url
706: ( p_bucket_rec in bis_bucket_pub.bis_bucket_rec_type
707: , p_alias_name in varchar2
708: , p_prefix in varchar2
709: , p_suffix in varchar2
710: , p_add_bucket_num in varchar2

Line 1308: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;

1304: l_range_low number;
1305: l_range_high number;
1306:
1307: l_range_id number;
1308: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
1309: l_return_status varchar2(3);
1310: l_error_tbl bis_utilities_pub.error_tbl_type;
1311:
1312: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 1326: bis_bucket_pub.retrieve_bis_bucket

1322: if l_range_id is null then
1323: return;
1324: end if;
1325:
1326: bis_bucket_pub.retrieve_bis_bucket
1327: ( p_short_name => p_short_name
1328: , x_bis_bucket_rec => l_bucket_rec
1329: , x_return_status => l_return_status
1330: , x_error_tbl => l_error_tbl