eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.FII_PMV_UTIL

Source


1 PACKAGE FII_PMV_UTIL AUTHID CURRENT_USER AS
2 /* $Header: FIIPMVUS.pls 120.2 2005/07/01 06:20:57 sajgeo ship $ */
3 FUNCTION get_msg (p_page_id           IN     VARCHAR2
4 ,p_user_id           IN     VARCHAR2
5 ,p_session_id           IN     VARCHAR2
6 ,p_function_name           IN     VARCHAR2
7 )RETURN VARCHAR2;
8 FUNCTION get_msg1 (p_page_id           IN     VARCHAR2
9 ,p_user_id           IN     VARCHAR2
10 ,p_session_id           IN     VARCHAR2
11 ,p_function_name           IN     VARCHAR2
12 )RETURN VARCHAR2;
13 FUNCTION get_curr RETURN VARCHAR2;
14 FUNCTION get_manager RETURN NUMBER;
15 FUNCTION get_dbi_params(region_id IN VARCHAR2) RETURN VARCHAR2;
16 FUNCTION get_sec_profile RETURN NUMBER;
17 FUNCTION get_prim_global_currency_code RETURN VARCHAR2;
18 FUNCTION get_sec_global_currency_code RETURN VARCHAR2;
19 FUNCTION get_display_currency(p_selected_operating_unit IN VARCHAR2) RETURN VARCHAR2;
20 PROCEDURE get_parameters (p_page_parameter_tbl   IN BIS_PMV_PAGE_PARAMETER_TBL,
21                             p_as_of_date  OUT NOCOPY Date,
22                             p_operating_unit  OUT NOCOPY Varchar2,
23                             p_supplier  OUT NOCOPY Varchar2,
24                             p_invoice_number  OUT NOCOPY Number,
25                             p_period_type OUT NOCOPY Varchar2,
26                             p_record_type_id OUT NOCOPY NUMBER,
27                             p_view_by OUT NOCOPY Varchar2,
28                             p_currency OUT NOCOPY Varchar2,
29                             p_column_name OUT NOCOPY VARCHAR2,
30                             p_table_name OUT NOCOPY VARCHAR2,
31                             p_gid OUT NOCOPY NUMBER,
32                             p_org_where OUT NOCOPY Varchar2,
33                             p_supplier_where OUT NOCOPY Varchar2
34                         );
35 PROCEDURE Bind_Variable
36              ( p_sqlstmt IN Varchar2, p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
37              p_sql_output OUT NOCOPY Varchar2, p_bind_output_table OUT BIS_QUERY_ATTRIBUTES_TBL,
38               p_invoice_number IN Varchar2 Default null,
39                p_record_type_id IN Number Default Null,
40                p_view_by IN Varchar2 Default Null, p_gid IN Number Default Null,
41                  p_period_start   IN Date     Default null,
42                p_check_id IN Number Default null,
43                p_created        IN Varchar2 Default null,
44                p_stopped        IN Varchar2 Default null,
45                p_stop_released  IN Varchar2 Default null,
46                p_cleared        IN Varchar2 Default null,
47                p_reconciled     IN Varchar2 Default null,
48                p_unreconciled   IN Varchar2 Default null,
49                p_uncleared      IN Varchar2 Default null,
50                p_voided         IN Varchar2 Default null,
51                p_entry          IN Varchar2 Default null,
52                p_hold_placed    IN Varchar2 Default null,
53                p_hold_released  IN Varchar2 Default null,
54                p_prepay_applied IN Varchar2 Default null,
55                p_prepay_unapplied IN Varchar2 Default null,
56                p_payment        IN Varchar2 Default null,
57                p_paymt_void     IN Varchar2 Default null,
58                p_paymt_stop     IN Varchar2 Default null,
59                p_paymt_release  IN Varchar2 Default null,
60 	       p_line_number   IN Number   Default null,
61                p_fiibind1       IN Varchar2 Default null,
62                p_fiibind2       IN Varchar2 Default null,
63                p_fiibind3       IN Varchar2 Default null,
64                p_fiibind4       IN Varchar2 Default null,
65                p_fiibind5       IN Varchar2 Default null,
66                p_fiibind6       IN Varchar2 Default null
67               );
68 PROCEDURE get_invoice_id(p_page_parameter_tbl   IN BIS_PMV_PAGE_PARAMETER_TBL,
69                             p_invoice_id OUT NOCOPY Number) ;
70 PROCEDURE get_period_start(p_page_parameter_tbl   IN BIS_PMV_PAGE_PARAMETER_TBL,
71                            p_period_start OUT NOCOPY Date,
72                            p_days_into_period OUT NOCOPY Number,
73                            p_cur_period OUT NOCOPY Number,
74                            p_id_column OUT NOCOPY Varchar2);
75 PROCEDURE get_period_strt(p_page_parameter_tbl   IN BIS_PMV_PAGE_PARAMETER_TBL,
76                             p_period_start OUT NOCOPY Date,
77                            p_days_into_period OUT NOCOPY Number,
78                            p_cur_period OUT NOCOPY Number,
79                            p_id_column OUT NOCOPY Varchar2);
80 PROCEDURE get_report_source(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
81                            p_report_source OUT NOCOPY Varchar2);
82 PROCEDURE get_check_id(p_page_parameter_tbl   IN BIS_PMV_PAGE_PARAMETER_TBL,
83                             p_check_id OUT NOCOPY Number) ;
84 FUNCTION get_base_curr_colname(p_currency IN Varchar2, p_column_name IN Varchar2) return Varchar2;
85 FUNCTION get_period_type_suffix (p_period_type IN Varchar2) return Varchar2;
86 PROCEDURE get_yes_no_msg(p_yes OUT NOCOPY Varchar2, p_no OUT NOCOPY Varchar2);
87 PROCEDURE get_format_mask(p_date_format_mask OUT NOCOPY Varchar2);
88 FUNCTION determine_OU_LOV RETURN NUMBER;
89 FUNCTION get_business_group RETURN NUMBER;
90 
91 
92 END FII_PMV_Util;