[Home] [Help]
PACKAGE: APPS.QRM_PA_AGGREGATION_P
Source
1 PACKAGE QRM_PA_AGGREGATION_P AUTHID CURRENT_USER AS
2 /* $Header: qrmpaggs.pls 115.19 2003/11/22 00:36:15 prafiuly ship $ */
3
4 e_pagg_no_fxrate_found EXCEPTION;
5 e_pagg_no_timebuckets_found EXCEPTION;
6 e_pagg_update_total_fail EXCEPTION;
7 e_pagg_update_percent_fail EXCEPTION;
8 e_pagg_update_label_fail EXCEPTION;
9 e_pagg_update_agg_curr_fail EXCEPTION;
10 e_pagg_no_setting_found EXCEPTION;
11 e_pagg_update_tb_label_fail EXCEPTION;
12
13 --bug 3236479
14 g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
15 g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
16 g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
17 g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
18 g_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
19 G_ERROR_LEVEL NUMBER :=FND_LOG.LEVEL_EXCEPTION;
20
21 FUNCTION transform_and_save (p_name VARCHAR2,
22 p_ref_date DATE,
23 p_caller_flag VARCHAR2)
24 --'OA' if called from OA
25 --'CONC' if called from Concurrent Program
26 RETURN VARCHAR2; --'T' for success or 'F' for unsuccessful
27
28
29 FUNCTION calculate_relative_date(p_ref_date DATE,
30 p_date_type VARCHAR2,
31 p_as_of_date DATE,
32 p_start_date_ref VARCHAR2,
33 p_start_date_offset NUMBER,
34 p_start_offset_type VARCHAR2,
35 p_calendar_id NUMBER,
36 p_business_week VARCHAR2)
37 RETURN DATE;
38
39
40 PROCEDURE update_timebuckets (p_name VARCHAR2,
41 p_ref_date DATE,
42 p_tb_name VARCHAR2,
43 p_tb_label VARCHAR2,
44 p_as_of_date DATE,
45 p_start_date_ref VARCHAR2,
46 p_start_date_offset NUMBER,
47 p_start_offset_type VARCHAR2,
48 p_row_agg_no NUMBER,
49 p_max_col_no OUT NOCOPY NUMBER,
50 p_date_type VARCHAR2,
51 p_calendar_id NUMBER,
52 p_business_week VARCHAR2,
53 p_col_seq_no IN OUT NOCOPY XTR_MD_NUM_TABLE,
54 p_col_seq_no_key IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
55 p_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
56 p_percent_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
57 p_a1 IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
58 p_col_type IN OUT NOCOPY XTR_MD_NUM_TABLE,
59 p_col_hidden IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
60 p_start_date IN OUT NOCOPY SYSTEM.QRM_DATE_TABLE,
61 p_end_date IN OUT NOCOPY SYSTEM.QRM_DATE_TABLE,
62 p_tb_label_arr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE);
63
64
65 FUNCTION update_total (p_name VARCHAR2,
66 p_ref_date DATE)
67 RETURN BOOLEAN;
68
69
70 FUNCTION update_percent (p_name VARCHAR2,
71 p_ref_date DATE)
72 RETURN BOOLEAN;
73
74
75 FUNCTION update_percent (p_name VARCHAR2,
76 p_style VARCHAR2,
77 p_row_agg_no NUMBER,
78 p_max_col_no NUMBER,
79 p_ref_date DATE,
80 p_md_set_code VARCHAR2)
81 RETURN BOOLEAN;
82
83
84 FUNCTION update_label(p_name VARCHAR2,
85 p_agg IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
86 p_col_order IN OUT NOCOPY XTR_MD_NUM_TABLE,
87 p_att_type IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
88 p_ref_date DATE)
89 RETURN BOOLEAN;
90
91
92 PROCEDURE calc_table_total_and_fxrate(p_name VARCHAR2,
93 p_calc_total_ind VARCHAR2,--'Y'es or 'N'o
94 p_curr_reporting VARCHAR2,
95 p_currency_source VARCHAR2,
96 p_last_run_date DATE,
97 p_md_set_code VARCHAR2,
98 p_dirty VARCHAR2,
99 p_end_date_fix DATE,
100 p_tot_avg SYSTEM.QRM_VARCHAR_TABLE,
101 p_ccy_multiplier OUT NOCOPY NUMBER,
102 p_att_name IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
103 p_total OUT NOCOPY XTR_MD_NUM_TABLE,
104 p_table_col_curr OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
105 p_sensitivity SYSTEM.QRM_VARCHAR_TABLE,
106 p_analysis_type VARCHAR2,
107 p_business_week VARCHAR2,
108 p_amount SYSTEM.QRM_VARCHAR_TABLE);--17
109
110
111 FUNCTION update_aggregate_curr(p_name VARCHAR2,
112 p_ref_date DATE,
113 p_ccy_case_flag NUMBER,
114 p_ccy_agg_flag NUMBER,
115 p_ccy_agg_level NUMBER,
116 p_row_agg_no NUMBER,
117 p_max_col_no NUMBER,
118 p_underlying_ccy VARCHAR2,
119 p_currency_source VARCHAR2,
120 p_curr_reporting VARCHAR2,
121 p_agg_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE)
122 RETURN BOOLEAN;
123
124 FUNCTION update_timebuckets_label(p_name VARCHAR2)
125 RETURN BOOLEAN;
126
127 FUNCTION update_semidirty(p_name VARCHAR2, p_ref_date DATE)
128 RETURN VARCHAR2;
129
130 FUNCTION get_fx_rate(p_md_set_code VARCHAR2,
131 p_spot_date DATE,
132 p_base_ccy VARCHAR2,
133 p_contra_ccy VARCHAR2,
134 p_side VARCHAR2)
135 RETURN NUMBER;
136
137 PROCEDURE calc_tb_start_end_dates (p_name VARCHAR2,
138 p_ref_date DATE,
139 p_tb_name VARCHAR2,
140 p_tb_label VARCHAR2,
141 p_end_date IN OUT NOCOPY DATE,
142 p_end_date_ref IN OUT NOCOPY VARCHAR2,
143 p_end_date_offset IN OUT NOCOPY NUMBER,
144 p_end_offset_type IN OUT NOCOPY VARCHAR2,
145 p_date_type VARCHAR2,
146 p_calendar_id NUMBER,
147 p_business_week VARCHAR2,
148 p_start_date IN OUT NOCOPY DATE,
149 p_start_date_ref IN OUT NOCOPY VARCHAR2,
150 p_start_date_offset IN OUT NOCOPY NUMBER,
151 p_start_offset_type IN OUT NOCOPY VARCHAR2,
152 p_analysis_type VARCHAR2);
153
154 --FUNCTION translate_to_usd (p_name VARCHAR2,
155 -- p_ref_date DATE,
156 -- p_md_set_code VARCHAR2)
157 -- RETURN BOOLEAN;
158
159
160 END QRM_PA_AGGREGATION_P;