PACKAGE: APPS.FII_AP_HOLD_SUM

Source

1 PACKAGE fii_ap_hold_sum AUTHID CURRENT_USER AS
2 /* $Header: FIIAPS3S.pls 115.1 2003/06/24 19:54:39 djanaswa noship $ */
3 
4 -- For the Holds Summary report --
5 
6 PROCEDURE  get_hold_sum (
7         p_page_parameter_tbl    IN  BIS_PMV_PAGE_PARAMETER_TBL,
8         get_hold_sum_sql        OUT NOCOPY VARCHAR2,
9         get_hold_sum_output     OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
10 
11 
12 PROCEDURE  get_hold_discount_sum (
13         p_page_parameter_tbl              IN  BIS_PMV_PAGE_PARAMETER_TBL,
14         get_hold_discount_sum_sql        OUT NOCOPY VARCHAR2,
15         get_hold_discount_sum_output     OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
16 
17 
18 PROCEDURE get_hold_cat_sum
19      ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
20        get_hold_cat_sum_sql out NOCOPY VARCHAR2,
21        get_hold_cat_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
22 
23 PROCEDURE get_hold_type_sum
24      ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
25        get_hold_type_sum_sql out NOCOPY VARCHAR2,
26        get_hold_type_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
27 
28 
29 PROCEDURE get_hold_trend (
30    p_page_parameter_tbl    IN  BIS_PMV_PAGE_PARAMETER_TBL,
31    get_hold_trend_sql        OUT NOCOPY VARCHAR2,
32    get_hold_trend_output     OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
33 
34 
35 END fii_ap_hold_sum;