APPS.POA_DBI_FR_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 26: procedure status_sql(p_param in bis_pmv_page_parameter_tbl

22: /*End of forward declaration section*/
23:
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;

Line 313: procedure status_summary_sql(p_param in bis_pmv_page_parameter_tbl

309: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
310: end;
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);

Line 544: procedure amt_sql(p_param in bis_pmv_page_parameter_tbl

540: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
541: end;
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);

Line 806: procedure req_lines_sql(p_param in bis_pmv_page_parameter_tbl

802: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
803: end;
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);

Line 965: procedure req_age_sql(p_param in bis_pmv_page_parameter_tbl

961: err_msg := substr(sqlerrm,1,400);
962: end;
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);

Line 1262: procedure trend_sql(p_param in bis_pmv_page_parameter_tbl

1258: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
1259: end;
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);

Line 1356: procedure amt_trend_sql(p_param in bis_pmv_page_parameter_tbl

1352: return l_sel_clause;
1353: end;
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);

Line 1455: procedure ped_trend_sql(p_param in bis_pmv_page_parameter_tbl

1451: return l_sel_clause;
1452: end;
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);