1 PACKAGE PFT_AR_ENGINE_PVT AS
2 /* $Header: PFTVARES.pls 120.0 2005/06/06 19:03:45 appldev noship $ */
3
4 ---------------------------------------------
5 -- Package Constants
6 ---------------------------------------------
7 G_BLOCK constant varchar2(80) := 'PFT.PLSQL.PFT_AR_ENGINE_PVT';
8 G_PFT constant varchar2(3) := 'PFT';
9 G_FEM constant varchar2(3) := 'FEM';
10 G_PFT_SOURCE_SYSTEM_DC constant varchar2(3) := 'PFT';
11
12
13 ---------------------------------------------
14 -- Variable Types
15 ---------------------------------------------
16 id_t number(9);
17 pct_t number(3,2);
18 flag_t varchar2(1);
19 currency_code_t varchar2(15);
20 varchar2_std_t varchar2(30);
21 varchar2_150_t varchar2(150);
22 varchar2_240_t varchar2(240);
23
24 ---------------------------------------------
25 -- Package Types
26 ---------------------------------------------
27
28 type dynamic_cursor is ref cursor;
29
30 type dimension_record is record (
31 dimension_id number
32 ,dimension_varchar_label varchar2_std_t%type
33 ,composite_dimension_flag flag_t%type
34 ,member_col varchar2_std_t%type
35 ,member_b_table varchar2_std_t%type
36 ,attr_table varchar2_std_t%type
37 ,hier_table varchar2_std_t%type
38 ,hier_versioning_type_code varchar2_std_t%type
39 );
40
41 type request_record is record (
42 continue_process_on_err_flg flag_t%type
43 ,act_rate_obj_type_code varchar2_std_t%type
44 ,dataset_grp_obj_def_id id_t%type
45 ,dataset_grp_obj_id id_t%type
46 ,dimension_rec dimension_record
47 ,effective_date date
48 ,effective_date_varchar varchar2_240_t%type
49 ,entered_currency_flag flag_t%type
50 ,entered_exch_rate_date date
51 ,functional_currency_code currency_code_t%type
52 ,ledger_id number
53 ,local_vs_combo_id id_t%type
54 ,login_id number
55 ,output_cal_period_id number
56 ,output_dataset_code number
57 ,pgm_app_id number
58 ,pgm_id number
59 ,resp_id number
60 ,request_id number
61 ,ruleset_obj_def_id id_t%type
62 ,ruleset_obj_id id_t%type
63 ,ruleset_obj_name varchar2_150_t%type
64 ,source_system_code number
65 ,source_system_display_code varchar2_150_t%type
66 ,submit_obj_id id_t%type
67 ,submit_obj_type_code varchar2_std_t%type
68 ,user_id number
69 );
70
71 type rule_record is record (
72 act_rate_obj_id id_t%type
73 ,act_rate_obj_def_id id_t%type
74 ,act_rate_obj_type_code varchar2_std_t%type
75 ,act_rate_sequence number
76 ,cond_exists boolean
77 ,cond_obj_def_id id_t%type
78 ,cond_obj_id id_t%type
79 ,entered_currency_code currency_code_t%type
80 ,entered_exch_rate number
81 ,entered_exch_rate_den number
82 ,entered_exch_rate_num number
83 ,hier_obj_def_id id_t%type
84 ,hier_obj_id id_t%type
85 ,local_vs_combo_id id_t%type
86 ,rate_sequence_name varchar2_std_t%type
87 ,drv_sequence_name varchar2_std_t%type
88 ,top_node_flag flag_t%type
89 ,output_to_rate_stat_flag flag_t%type
90 ,act_rate_obj_name varchar2_150_t%type
91 );
92
93 type rowid_type is table of rowid
94 index by binary_integer;
95
96 type number_type is table of number
97 index by binary_integer;
98
99 type pct_type is table of number(3,2)
100 index by binary_integer;
101
102 type date_type is table of date
103 index by binary_integer;
104
105 type flag_type is table of varchar2(1)
106 index by binary_integer;
107
108 type lang_type is table of varchar2(4)
109 index by binary_integer;
110
111 type varchar2_std_type is table of varchar2(30)
112 index by binary_integer;
113
114 type varchar2_150_type is table of varchar2(150)
115 index by binary_integer;
116
117 type varchar2_1000_type is table of varchar2(1000)
118 index by binary_integer;
119
120
121
122 /*===========================================================================+
123 | PROCEDURE
124 | Act_Rate_Request
125 |
126 | DESCRIPTION
127 | This procedure is called by Concurrent Manager to run the activity rate
128 | engine
129 |
130 | SCOPE - PUBLIC
131 |
132 +===========================================================================*/
133
134 PROCEDURE Act_Rate_Request (
135 errbuf out nocopy varchar2
136 ,retcode out nocopy varchar2
137 ,p_obj_id in number
138 ,p_effective_date in varchar2
139 ,p_ledger_id in number
140 ,p_output_cal_period_id in number
141 ,p_dataset_grp_obj_def_id in number
142 ,p_continue_process_on_err_flg in varchar2
143 ,p_source_system_code in number
144 );
145
146 /*===========================================================================+
147 | PROCEDURE
148 | Calc_Driver_Values
149 |
150 | DESCRIPTION
151 | This procedure is called by the Multi-Processing Engine so that driver
152 | calculation can be done in parallel through multiple subrequests.
153 |
154 | SCOPE - PUBLIC
155 |
156 +===========================================================================*/
157
158 PROCEDURE Calc_Driver_Values (
159 p_eng_sql in varchar2
160 ,p_slc_pred in varchar2
161 ,p_proc_num in number
162 ,p_part_code in number
163 ,p_fetch_limit in number
164 ,p_request_id in number
165 ,p_dataset_grp_obj_def_id in number
166 ,p_effective_date_varchar in varchar2
167 ,p_output_cal_period_id in number
168 ,p_ledger_id in number
169 ,p_local_vs_combo_id in number
170 ,p_user_id in number
171 ,p_login_id in number
172 ,p_act_rate_obj_id in number
173 ,p_act_rate_obj_def_id in number
174 ,p_hier_obj_def_id in number
175 ,p_act_hier_where_clause in long
176 ,p_act_cond_where_clause in long
177 );
178
179
180
181
182 END PFT_AR_ENGINE_PVT;