1 PACKAGE FII_AP_INV_DETAIL AS
2 /* $Header: FIIAPD1S.pls 120.1 2005/10/30 05:05:10 appldev noship $ */
3
4 -- To show the as-of-date in the report title --
5 FUNCTION get_report_title(
6 p_page_parameter_tbl BIS_PMV_PAGE_PARAMETER_TBL) RETURN VARCHAR2;
7
8
9 -- To get last_update_date for Past Due Invoices report --
10
11 FUNCTION get_past_due_inv_up_date RETURN VARCHAR2;
12
13
14 -- For Current Past Due Invoices report --
15 PROCEDURE get_current_top_pdue (
16 p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
17 inv_dtl_sql OUT NOCOPY VARCHAR2,
18 inv_dtl_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
19
20 -- For the Invoice Detail report --
21 PROCEDURE get_inv_detail (
22 p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
23 inv_dtl_sql OUT NOCOPY VARCHAR2,
24 inv_dtl_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
25
26 END FII_AP_INV_DETAIL;
27
28 -- End of package
29