APPS.POA_DBI_FR_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 28: ,x_custom_output out nocopy bis_query_attributes_tbl)

24: /*Procedure and Function definitions*/
25: /*Fulfilled Requisitions report*/
26: procedure status_sql(p_param in bis_pmv_page_parameter_tbl
27: ,x_custom_sql out nocopy varchar2
28: ,x_custom_output out nocopy bis_query_attributes_tbl)
29: is
30: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
31: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
32: l_query varchar2(10000);

Line 315: ,x_custom_output out nocopy bis_query_attributes_tbl)

311:
312: /*Fulfilled Requisition Lines Summary*/
313: procedure status_summary_sql(p_param in bis_pmv_page_parameter_tbl
314: ,x_custom_sql out nocopy varchar2
315: ,x_custom_output out nocopy bis_query_attributes_tbl)
316: is
317: err_msg varchar2(100);
318: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
319: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 546: ,x_custom_output out nocopy bis_query_attributes_tbl)

542:
543: /*Fulfilled Requisitions Amount report*/
544: procedure amt_sql(p_param in bis_pmv_page_parameter_tbl
545: ,x_custom_sql out nocopy varchar2
546: ,x_custom_output out nocopy bis_query_attributes_tbl)
547: is
548: err_msg varchar2(100);
549: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
550: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 808: ,x_custom_output out nocopy bis_query_attributes_tbl)

804:
805: /*fulfilled Requisition Lines report*/
806: procedure req_lines_sql(p_param in bis_pmv_page_parameter_tbl
807: ,x_custom_sql out nocopy varchar2
808: ,x_custom_output out nocopy bis_query_attributes_tbl)
809: is
810: l_query varchar2(10000);
811: l_option number;
812: l_cur_suffix varchar2(2);

Line 967: ,x_custom_output out nocopy bis_query_attributes_tbl)

963:
964: /*Fulfilled Requisitions Aging report*/
965: procedure req_age_sql(p_param in bis_pmv_page_parameter_tbl
966: ,x_custom_sql out nocopy varchar2
967: ,x_custom_output out nocopy bis_query_attributes_tbl)
968: is
969: err_msg varchar2(100);
970: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
971: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 1264: ,x_custom_output out nocopy bis_query_attributes_tbl)

1260:
1261: /*Fulfilled Lines Automation Trend report*/
1262: procedure trend_sql(p_param in bis_pmv_page_parameter_tbl
1263: ,x_custom_sql out nocopy varchar2
1264: ,x_custom_output out nocopy bis_query_attributes_tbl)
1265: is
1266: l_query varchar2(10000);
1267: l_view_by varchar2(120);
1268: l_view_by_col_name varchar2(120);

Line 1358: ,x_custom_output out nocopy bis_query_attributes_tbl)

1354:
1355: /*Fulfilled Requisitions Amount Trend*/
1356: procedure amt_trend_sql(p_param in bis_pmv_page_parameter_tbl
1357: ,x_custom_sql out nocopy varchar2
1358: ,x_custom_output out nocopy bis_query_attributes_tbl)
1359: is
1360: l_query varchar2(10000);
1361: l_view_by varchar2(120);
1362: l_view_by_col_name varchar2(120);

Line 1457: ,x_custom_output out nocopy bis_query_attributes_tbl)

1453:
1454: /*Percent Fulfilled Past Expected Date Trend report*/
1455: procedure ped_trend_sql(p_param in bis_pmv_page_parameter_tbl
1456: ,x_custom_sql out nocopy varchar2
1457: ,x_custom_output out nocopy bis_query_attributes_tbl)
1458: is
1459: l_query varchar2(10000);
1460: l_view_by varchar2(120);
1461: l_view_by_col_name varchar2(120);