APPS.POA_DBI_PR_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 36: procedure status_sql(p_param in bis_pmv_page_parameter_tbl

32: function get_amt_filter_where(p_view_by in VARCHAR2) return varchar2;
33: function get_req_age_filter_where(p_view_by in VARCHAR2) return varchar2;
34: /*public procedure definitions*/
35:
36: procedure status_sql(p_param in bis_pmv_page_parameter_tbl
37: ,x_custom_sql out nocopy varchar2
38: ,x_custom_output out nocopy bis_query_attributes_tbl)
39: is
40: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

Line 313: p_param in bis_pmv_page_parameter_tbl,

309: end;
310:
311:
312: procedure status_sum_sql(
313: 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: )
317: is

Line 542: procedure amt_sql(p_param in bis_pmv_page_parameter_tbl

538:
539:
540: /* PROCESSED REQUISITIONS AMOUNT REPORT */
541:
542: procedure amt_sql(p_param in bis_pmv_page_parameter_tbl
543: ,x_custom_sql out nocopy varchar2
544: ,x_custom_output out nocopy bis_query_attributes_tbl)
545: is
546: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

Line 814: procedure age_sql(p_param in bis_pmv_page_parameter_tbl

810: end;
811:
812: /* PROCESSED REQUISITIONS AGING REPORT */
813:
814: procedure age_sql(p_param in bis_pmv_page_parameter_tbl
815: ,x_custom_sql out nocopy varchar2
816: ,x_custom_output out nocopy bis_query_attributes_tbl)
817: is
818: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

Line 1121: procedure amt_trend_sql(p_param in bis_pmv_page_parameter_tbl

1117:
1118:
1119: /* PROCESSED LINES AMOUNT TREND REPORT */
1120:
1121: procedure amt_trend_sql(p_param in bis_pmv_page_parameter_tbl
1122: ,x_custom_sql out nocopy varchar2
1123: ,x_custom_output out nocopy bis_query_attributes_tbl)
1124: is
1125: l_query varchar2(10000);

Line 1248: procedure age_trend_sql(p_param in bis_pmv_page_parameter_tbl

1244:
1245:
1246: /* PROCESSED AVERAGE AGE TREND REPORT */
1247:
1248: procedure age_trend_sql(p_param in bis_pmv_page_parameter_tbl
1249: ,x_custom_sql out nocopy varchar2
1250: ,x_custom_output out nocopy bis_query_attributes_tbl)
1251: is
1252: l_query varchar2(10000);

Line 1384: procedure au_trend_sql(p_param in bis_pmv_page_parameter_tbl

1380:
1381:
1382: /* PROCESSED LINES AUTOMATION TREND REPORT */
1383:
1384: procedure au_trend_sql(p_param in bis_pmv_page_parameter_tbl
1385: ,x_custom_sql out nocopy varchar2
1386: ,x_custom_output out nocopy bis_query_attributes_tbl)
1387: is
1388: l_query varchar2(10000);

Line 1504: procedure dtl_sql(p_param in bis_pmv_page_parameter_tbl

1500: ';
1501: return l_sel_clause;
1502: end;
1503:
1504: procedure dtl_sql(p_param in bis_pmv_page_parameter_tbl
1505: ,x_custom_sql out nocopy varchar2
1506: ,x_custom_output out nocopy bis_query_attributes_tbl)
1507: is
1508: l_query varchar2(10000);