PACKAGE: APPS.FII_AP_INV_ACTIVITY

Source

1 PACKAGE FII_AP_INV_ACTIVITY AUTHID CURRENT_USER AS
2 /* $Header: FIIAPS4S.pls 115.3 2003/07/02 10:29:39 supandey noship $ */
3 
4   PROCEDURE get_inv_activity(
5 	p_page_parameter_tbl in         BIS_PMV_PAGE_PARAMETER_TBL,
6 	inv_act_anal_sql     out NOCOPY VARCHAR2,
7 	inv_act_anal_output  out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
8 
9   PROCEDURE get_inv_type(
10 	p_page_parameter_tbl in         BIS_PMV_PAGE_PARAMETER_TBL,
11 	inv_type_sql         out NOCOPY VARCHAR2,
12 	inv_type_output      out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
13 
14   PROCEDURE get_electronic_inv(
15 	p_page_parameter_tbl in         BIS_PMV_PAGE_PARAMETER_TBL,
16 	elec_inv_sql         out NOCOPY VARCHAR2,
17 	elec_inv_output      out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
18 
19   PROCEDURE get_hold_activity(
20 	p_page_parameter_tbl in         BIS_PMV_PAGE_PARAMETER_TBL,
21 	get_hold_sql         out NOCOPY VARCHAR2,
22 	get_hold_output      out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
23 
24   PROCEDURE Local_Bind_Variable
25                 ( p_sqlstmt IN Varchar2,
26                   p_page_parameter_tbl        IN BIS_PMV_PAGE_PARAMETER_TBL,
27                   p_sql_output                OUT NOCOPY Varchar2,
28                   p_bind_output_table         OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,
29                   p_record_type_id            IN Number   Default Null,
30                   p_view_by                   IN Varchar2 Default Null,
31                   p_gid                       IN Number   Default Null,
32                   p_period_start              IN Date     Default null,
33                   p_report_start              IN Date     Default null,
34                   p_cur_effective_num         IN Number   Default Null,
35                   p_period_id                 IN Number   Default Null);
36 
37   PROCEDURE get_period_details(p_page_parameter_tbl IN  BIS_PMV_PAGE_PARAMETER_TBL,
38                             p_period_start       OUT NOCOPY Date,
39                             p_cur_period         OUT NOCOPY Number,
40                             p_id_column          OUT NOCOPY Varchar2,
41                             p_report_start       OUT NOCOPY DATE,
42                             p_cur_effective_num  OUT NOCOPY number,
43                             p_period_id          OUT NOCOPY number);
44 
45   PROCEDURE get_electronic_inv_trend (
46         p_page_parameter_tbl            IN  BIS_PMV_PAGE_PARAMETER_TBL,
47         electronic_inv_trend_sql        OUT NOCOPY VARCHAR2,
48         electronic_inv_trend_output     OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
49 
50 
51 END fii_ap_inv_activity;