DBA Data[Home] [Help]

APPS.FII_AP_INV_ACTIVITY dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 5: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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(

Line 10: 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(

Line 15: 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(

Line 20: 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

Line 26: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 37: PROCEDURE get_period_details(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 46: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

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: