[Home] [Help]
PACKAGE: APPS.FEM_RU_ENGINE_PVT
Source
1 PACKAGE FEM_RU_ENGINE_PVT AS
2 /* $Header: FEMVRUES.pls 120.0 2005/06/06 21:31:14 appldev noship $ */
3
4 ---------------------------------------------
5 -- Package Constants
6 ---------------------------------------------
7 G_BLOCK constant varchar2(80) := 'FEM.PLSQL.FEM_RU_ENGINE_PVT';
8 G_FEM constant varchar2(3) := 'FEM';
9 G_PFT_SOURCE_SYSTEM_DC constant varchar2(3) := 'PFT';
10
11
12 ---------------------------------------------
13 -- Variable Types
14 ---------------------------------------------
15 id_t number(9);
16 pct_t number(3,2);
17 flag_t varchar2(1);
18 currency_code_t varchar2(15);
19 varchar2_std_t varchar2(30);
20 varchar2_150_t varchar2(150);
21 varchar2_240_t varchar2(240);
22
23 ---------------------------------------------
24 -- Package Types
25 ---------------------------------------------
26
27 type dynamic_cursor is ref cursor;
28
29 type dimension_record is record (
30 dimension_id number
31 ,dimension_varchar_label varchar2_std_t%type
32 ,composite_dimension_flag flag_t%type
33 ,member_col varchar2_std_t%type
34 ,member_b_table varchar2_std_t%type
35 ,attr_table varchar2_std_t%type
36 ,hier_table varchar2_std_t%type
37 ,hier_rollup_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 ,dataset_grp_obj_def_id id_t%type
44 ,dataset_grp_obj_id id_t%type
45 ,dimension_rec dimension_record
46 ,effective_date date
47 ,effective_date_varchar varchar2_240_t%type
48 ,entered_currency_flag flag_t%type
49 ,exch_rate_date date
50 ,functional_currency_code currency_code_t%type
51 ,ledger_id number
52 ,local_vs_combo_id id_t%type
53 ,login_id number
54 ,output_cal_period_id number
55 ,output_dataset_code number
56 ,pgm_app_id number
57 ,pgm_id number
58 ,resp_id number
59 ,request_id number
60 ,rollup_obj_type_code varchar2_std_t%type
61 ,rollup_rule_def_table varchar2_std_t%type
62 ,rollup_type_code varchar2_std_t%type
63 ,ruleset_obj_def_id id_t%type
64 ,ruleset_obj_id id_t%type
65 ,ruleset_obj_name varchar2_150_t%type
66 ,source_system_code number
67 ,submit_obj_id id_t%type
68 ,submit_obj_type_code varchar2_std_t%type
69 ,user_id number
70 );
71
72 type rule_record is record (
73 cond_exists boolean
74 ,cond_obj_def_id id_t%type
75 ,cond_obj_id id_t%type
76 ,entered_currency_code currency_code_t%type
77 ,entered_exch_rate number
78 ,entered_exch_rate_den number
79 ,entered_exch_rate_num number
80 ,hier_obj_def_id id_t%type
81 ,hier_obj_id id_t%type
82 ,hier_rollup_table varchar2_std_t%type
83 ,local_vs_combo_id id_t%type
84 ,rollup_obj_def_id id_t%type
85 ,rollup_obj_id id_t%type
86 ,rollup_obj_name varchar2_150_t%type
87 ,rollup_obj_type_code varchar2_std_t%type
88 ,rollup_sequence number
89 ,sequence_name varchar2_std_t%type
90 ,statistic_basis_id number
91 );
92
93 type sql_record is record (
94 comp_dim_comp_cols_using long
95 ,comp_dim_data_cols_using long
96 ,comp_dim_data_cols_on long
97 ,comp_dim_comp_cols_insert long
98 ,comp_dim_data_cols_insert long
99 ,comp_dim_comp_cols_values long
100 ,comp_dim_data_cols_values long
101 );
102
103 type ledger_record is record (
104 currency_code currency_code_t%type
105 ,exch_rate number
106 ,exch_rate_den number
107 ,exch_rate_num number
108 );
109
110 type number_table is table of number
111 index by binary_integer;
112
113 type ledger_table is table of ledger_record
114 index by binary_integer;
115
116
117 /*===========================================================================+
118 | PROCEDURE
119 | Rollup_Request
120 |
121 | DESCRIPTION
122 | todo
123 |
124 | SCOPE - PUBLIC
125 |
126 +===========================================================================*/
127
128
129 PROCEDURE Rollup_Request (
130 errbuf out nocopy varchar2
131 ,retcode out nocopy varchar2
132 ,p_obj_id in number
133 ,p_effective_date in varchar2
134 ,p_ledger_id in number
135 ,p_output_cal_period_id in number
136 ,p_dataset_grp_obj_def_id in number
137 ,p_continue_process_on_err_flg in varchar2
138 ,p_source_system_code in number
139 );
140
141
142
143 END FEM_RU_ENGINE_PVT;