PACKAGE: APPS.FII_AP_PAY_STATUS

Source

1 PACKAGE FII_AP_PAY_STATUS AUTHID CURRENT_USER AS
2 /* $Header: FIIAPPSS.pls 115.5 2003/10/25 00:51:43 djanaswa noship $ */
3 
4 -- For the Open Payables Status on the portal page --
5 PROCEDURE GET_OPEN_PAY_TABLE_PORTLET (
6 	p_page_parameter_tbl    IN  BIS_PMV_PAGE_PARAMETER_TBL,
7 	open_pay_sum_sql        OUT NOCOPY VARCHAR2,
8 	open_pay_sum_output     OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
9 
10 PROCEDURE get_pay_liability_pie (
11 	p_page_parameter_tbl   	IN  BIS_PMV_PAGE_PARAMETER_TBL,
12 	open_pay_sum_pie_sql   	OUT NOCOPY VARCHAR2,
13 	open_pay_sum_pie_output	OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
14 
15 PROCEDURE get_inv_aging (
16 	p_page_parameter_tbl    IN  BIS_PMV_PAGE_PARAMETER_TBL,
17 	inv_age_sql             OUT NOCOPY VARCHAR2,
18 	inv_age_output          OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
19 
20 PROCEDURE get_kpi (
21 	p_page_parameter_tbl    IN  BIS_PMV_PAGE_PARAMETER_TBL,
22 	kpi_sql                 OUT NOCOPY VARCHAR2,
23 	kpi_output              OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
24 
25 
26 PROCEDURE get_hold_sum (
27 	p_page_parameter_tbl    IN  BIS_PMV_PAGE_PARAMETER_TBL,
28 	get_hold_sum_sql                 OUT NOCOPY VARCHAR2,
29 	get_hold_sum_output              OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
30 
31 
32 END FII_AP_PAY_STATUS;
33