[Home] [Help]
PACKAGE: APPS.PQH_RBC_LOAD_OBJECTS
Source
1 Package pqh_rbc_load_objects as
2 /* $Header: pqhrbcld.pkh 120.3.12000000.2 2007/04/19 12:52:04 brsinha noship $ */
3 /* $Header: pqhrbcld.pkh 120.3.12000000.2 2007/04/19 12:52:04 brsinha noship $ */
4 --
5 Procedure load_rate_matrix_row
6 (p_pl_short_code in varchar2
7 ,p_name in varchar2
8 ,p_short_name in varchar2
9 ,p_pl_stat_cd in varchar2
10 ,p_pl_cd in varchar2
11 ,p_legislation_code in varchar2
12 ,p_effective_start_date in varchar2
13 ,p_owner in varchar2
14 );
15 --
16 function get_plan_id(p_short_code in varchar2,
17 p_effective_date in date,
18 p_business_group_id in number)
19 return varchar2;
20
21 Procedure load_rmn_row
22 (p_pl_short_code in varchar2
23 ,p_node_short_code in varchar2
24 ,p_node_name in varchar2
25 ,p_level_number in varchar2
26 ,p_criteria_short_code in varchar2
27 ,p_parent_node_short_code in varchar2
28 ,p_eligy_prfl_name in varchar2
29 ,p_legislation_code in varchar2
30 ,p_effective_date in varchar2
31 ,p_owner in varchar2
32 );
33 --
34 Procedure load_rmv_row
35 (p_short_code in varchar2
36 ,p_node_short_code in varchar2
37 ,p_char_value1 in varchar2
38 ,p_char_value2 in varchar2
39 ,p_char_value3 in varchar2
40 ,p_char_value4 in varchar2
41 ,p_number_value1 in varchar2
42 ,p_number_value2 in varchar2
43 ,p_number_value3 in varchar2
44 ,p_number_value4 in varchar2
45 ,p_date_value1 in varchar2
46 ,p_date_value2 in varchar2
47 ,p_date_value3 in varchar2
48 ,p_date_value4 in varchar2
49 ,p_legislation_code in varchar2
50 ,p_effective_date in varchar2
51 ,p_owner in varchar2
52 );
53 --
54 Procedure load_rmr_row
55 (p_node_short_code in varchar2
56 ,p_crit_rt_defn_short_code in varchar2
57 ,p_min_rate_value in varchar2
58 ,p_max_rate_value in varchar2
59 ,p_mid_rate_value in varchar2
60 ,p_rate_value in varchar2
61 ,p_legislation_code in varchar2
62 ,p_effective_start_date in varchar2
63 ,p_owner in varchar2
64 );
65 --
66 Procedure load_crd_seed_row
67 (p_upload_mode in varchar2
68 ,p_name in varchar2
69 ,p_short_name in varchar2
70 ,p_uom in varchar2
71 ,p_currency_code in varchar2 default null
72 ,p_reference_period_cd in varchar2 default null
73 ,p_define_max_rate_flag in varchar2 default null
74 ,p_define_min_rate_flag in varchar2 default null
75 ,p_define_mid_rate_flag in varchar2 default null
76 ,p_define_std_rate_flag in varchar2 default null
77 ,p_rate_calc_cd in varchar2
78 ,p_preferential_rate_cd in varchar2
79 ,p_rounding_cd in varchar2 default null
80 ,p_legislation_code in varchar2 default null
81 ,p_owner in varchar2 default null
82 );
83 --
84 Procedure load_crd_row
85 (p_name in varchar2
86 ,p_short_name in varchar2
87 ,p_uom in varchar2
88 ,p_currency_code in varchar2 default null
89 ,p_reference_period_cd in varchar2 default null
90 ,p_define_max_rate_flag in varchar2 default null
91 ,p_define_min_rate_flag in varchar2 default null
92 ,p_define_mid_rate_flag in varchar2 default null
93 ,p_define_std_rate_flag in varchar2 default null
94 ,p_rate_calc_cd in varchar2
95 --,p_rate_calc_rule in varchar2 default null
96 ,p_preferential_rate_cd in varchar2
97 --,p_preferential_rate_rule in varchar2 default null
98 ,p_rounding_cd in varchar2 default null
99 --,p_rounding_rule in varchar2
100 ,p_legislation_code in varchar2 default null
101 ,p_owner in varchar2 default null
102 );
103
104 Procedure download_rbc(
105 errbuf out nocopy varchar2
106 ,retcode out nocopy number
107 ,p_loader_file in varchar2
108 ,p_data_file in varchar2
109 ,p_entity in varchar2
110 ,p_crit_rate_defn_code in varchar2 default null
111 ,p_rate_matrix_code in varchar2 default null
112 ,p_effective_date in varchar2
113 ,p_business_group_id in number
114 ,p_validate in varchar2 default 'N'
115 );
116 --
117 Procedure upload_rbc(
118 errbuf out nocopy varchar2
119 ,retcode out nocopy number
120 ,p_loader_file in varchar2
121 ,p_data_file in varchar2
122 ,p_entity in varchar2
123 ,p_crit_rate_defn_code in varchar2 default null
124 ,p_rate_matrix_code in varchar2 default null
125 ,p_validate in varchar2 default 'N'
126 );
127 --
128 Procedure load_crf_row
129 (
130 p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
131 ,p_parent_crit_rt_def_name in VARCHAR2 default hr_api.g_varchar2
132 ,p_owner in VARCHAR2 default hr_api.g_varchar2
133 ,p_parent_rate_matrix_code in VARCHAR2 default hr_api.g_varchar2
134 ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
135 ,p_effective_start_date in varchar2 default hr_api.g_varchar2
136 );
137
138 Procedure load_cre_row
139 (
140 p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
141 ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
142 ,p_input_value_name in VARCHAR2 default hr_api.g_varchar2
143 ,p_owner in VARCHAR2 default hr_api.g_varchar2
144 ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
145 ,p_effective_start_date in varchar2 default hr_api.g_varchar2
146 );
147
148 Procedure load_rer_row
149 (
150 p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
151 ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
152 -- ,p_input_value_name in VARCHAR2 default hr_api.g_varchar2
153 ,p_owner in VARCHAR2 default hr_api.g_varchar2
154 ,p_relation_type_code in VARCHAR2 default hr_api.g_varchar2
155 ,p_rel_element_name in VARCHAR2 default hr_api.g_varchar2
156 ,p_rel_input_val_name in VARCHAR2 default hr_api.g_varchar2
157 ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
158 ,p_effective_start_date in varchar2 default hr_api.g_varchar2
159 );
160
161 Procedure load_rfe_row
162 (p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
163 ,p_parent_crit_rt_def_name in VARCHAR2 default hr_api.g_varchar2
164 ,p_owner in VARCHAR2 default hr_api.g_varchar2
165 ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
166 ,p_rate_factor_val_record_tbl in VARCHAR2 default hr_api.g_varchar2
167 ,p_rate_factor_val_record_col in VARCHAR2 default hr_api.g_varchar2
168 ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
169 ,p_effective_start_date in VARCHAR2 default hr_api.g_varchar2
170 );
171
172
173 --
174 procedure add_language; -- Added as a fix for bug 5484366
175 --
176
177 End pqh_rbc_load_objects;