[Home] [Help]
PACKAGE: APPS.FII_AR_UTIL_PKG
Source
1 PACKAGE fii_ar_util_pkg AUTHID CURRENT_USER AS
2 /* $Header: FIIARUTILS.pls 120.15.12000000.1 2007/02/23 02:29:37 applrt ship $ */
3
4 g_as_of_date DATE;
5 g_page_period_type VARCHAR2(100);
6 g_currency VARCHAR2(50);
7 g_view_by VARCHAR2(100);
8 g_time_comp VARCHAR2(30);
9 g_region_code VARCHAR2(100);
10 g_session_id NUMBER;
11 g_party_id VARCHAR2(500) := 'All';
12 g_parent_party_id VARCHAR2(30) := 'All';
13 g_cust_account_id VARCHAR2(30) := 'All';
14 g_org_id VARCHAR2(30) := 'All';
15 g_collector_id VARCHAR2(30) := 'All';
16 g_industry_id VARCHAR2(30) := 'All';
17 g_curr_suffix VARCHAR2(4);
18 g_cust_suffix VARCHAR2(6);
19 g_cust_view_by VARCHAR2(15);
20 g_curr_per_start DATE;
21 g_curr_per_end DATE;
22 g_prior_per_start DATE;
23 g_prior_per_end DATE;
24 g_curr_month_start DATE;
25 g_bitand NUMBER;
26 g_dso_bitand NUMBER;
27 g_bitand_inc_todate NUMBER;
28 g_bitand_rolling_30_days NUMBER;
29 g_self_msg VARCHAR2(240);
30 g_previous_asof_date DATE;
31 g_is_hierarchical_flag VARCHAR2(1);
32 g_count_parent_party_id NUMBER;
33 g_dso_period NUMBER;
34 g_industry_class_type VARCHAR2(100);
35 g_security_profile_id NUMBER;
36 g_security_org_id NUMBER;
37 g_operating_unit VARCHAR2(240);
38 g_functional_currency_code VARCHAR2(3);
39 g_prim_global_currency_code VARCHAR2(15);
40 g_sec_global_currency_code VARCHAR2(15);
41 g_common_functional_currency VARCHAR2(3);
42 g_det_ou_lov NUMBER;
43 g_business_group_id NUMBER;
44 g_all_operating_unit VARCHAR2(240);
45 g_order_by VARCHAR2(500);
46 g_sd_prior DATE;
47 g_sd_prior_prior DATE;
48 g_sd_curr_sdate DATE;
49 g_function_name VARCHAR2(100);
50 g_col_curr_suffix VARCHAR2(10);
51 g_cash_receipt_id NUMBER;
52 g_cust_trx_id VARCHAR2(30);
53 g_tran_num VARCHAR2(30);
54 g_tran_class VARCHAR2(30);
55 g_cust_account VARCHAR2(30);
56 g_account_num VARCHAR2(30);
57 g_app_cust_trx_id NUMBER;
58 g_bucket_num NUMBER;
59 g_page_refresh_date DATE;
60
61 TYPE dso_setup is RECORD (dso_type VARCHAR2(15), dso_value VARCHAR2(15));
62 TYPE dso_setup_tbl is table of dso_setup index by binary_integer;
63 g_dso_table dso_setup_tbl;
64
65 -- This package will provide central utilities for Receivables PMV content
66
67 -- -----------------------------------------------------------------------
68 -- Name: reset_globals
69 -- Desc: This procedure is used to reset all the global variables to null.
70 -- Output: N/A.
71 -- -----------------------------------------------------------------------
72
73 PROCEDURE reset_globals;
74
75 -- -----------------------------------------------------------------------
76 -- Name: get_parameters
77 -- Desc: This procedure is consumed by all the reports to set the global
78 -- variables.
79 -- Output: N/A.
80 -- -----------------------------------------------------------------------
81 PROCEDURE get_parameters (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL);
82
83 -- -----------------------------------------------------------------------
84 -- Name: get_viewby_id
85 -- Desc: This procedure is used to obtain the viewby columns for aggregated
86 -- and nonaggregated nodes.
87 -- -----------------------------------------------------------------------
88 --PROCEDURE get_viewby_id (p_viewby_id OUT NOCOPY VARCHAR2);
89
90 -- -----------------------------------------------------------------------
91 -- Name: get_viewby
92 -- Desc: This procedure is used to obtain the label of the first column
93 -- in trend reports
94 -- -----------------------------------------------------------------------
95 FUNCTION get_trend_viewby return VARCHAR2;
96
97 -- -----------------------------------------------------------------------
98 -- Name: bind_variable
99 -- Desc: This procedure is used to bind all the bind variables, no literal
100 -- shall be used in any report
101 -- Output: N/A.
102 -- -----------------------------------------------------------------------
103
104 PROCEDURE bind_variable (p_sqlstmt IN Varchar2,
105 p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
106 p_sql_output OUT NOCOPY Varchar2,
107 p_bind_output_table OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
108
109 -- -----------------------------------------------------------------------
110 -- Name: populate_summary_gt_tables
111 -- Desc: This procedure is used to populate the global tables
112 -- -----------------------------------------------------------------------
113 PROCEDURE populate_summary_gt_tables;
114
115 PROCEDURE insert_into_debug_table;
116
117 PROCEDURE populate_party_id;
118
119 FUNCTION get_sec_profile RETURN NUMBER;
120
121 FUNCTION get_dso_period_profile RETURN NUMBER;
122
123 FUNCTION get_curr RETURN VARCHAR2;
124
125 FUNCTION get_dso_setup_value(p_category IN VARCHAR2) RETURN VARCHAR2;
126
127 PROCEDURE get_dso_table_values;
128
129 FUNCTION get_prim_global_currency_code RETURN VARCHAR2;
130
131 FUNCTION get_sec_global_currency_code RETURN VARCHAR2;
132
133 FUNCTION determine_OU_LOV RETURN NUMBER;
134
135 FUNCTION get_business_group RETURN NUMBER;
136
137 FUNCTION get_display_currency(p_selected_operating_unit IN VARCHAR2) RETURN VARCHAR2;
138
139 FUNCTION get_from_statement RETURN VARCHAR2;
140
141 FUNCTION get_where_statement RETURN VARCHAR2;
142
143 FUNCTION get_mv_where_statement RETURN VARCHAR2;
144
145 FUNCTION get_rct_mv_where_statement RETURN VARCHAR2;
146
147 PROCEDURE get_page_refresh_date;
148
149 END fii_ar_util_pkg;