84: ;
85:
86: l_proc varchar2(72) := g_package||'populate_retro_comp_usages';
87: begin
88: hr_utility.set_location('Entering:'|| l_proc, 10);
89:
90: --
91: -- Validation in addition to Row Handlers
92: --
103: -- from the element type as well.
104:
105: for l_rcu_rec in csr_base_rcu loop
106:
107: hr_utility.set_location(l_proc, 20);
108:
109: l_rcu_id := null;
110: l_rcu_ovn := null;
111:
129: -- Create the Element Span Usages
130: --
131: for l_esu_rec in csr_base_esu(l_rcu_rec.retro_component_usage_id) loop
132:
133: hr_utility.set_location(l_proc, 30);
134:
135: l_esu_id := null;
136: l_esu_ovn := null;
137:
150: end loop;
151:
152: end loop;
153:
154: hr_utility.set_location(l_proc, 40);
155:
156: --
157: -- Set all output arguments
158: --
156: --
157: -- Set all output arguments
158: --
159:
160: hr_utility.set_location('Leaving:'||l_proc, 50);
161:
162: end populate_retro_comp_usages;
163:
164:
210: l_business_group_id pay_element_types_f.business_group_id%type;
211: l_legislation_code pay_element_types_f.legislation_code%type;
212: --
213: begin
214: hr_utility.set_location('Entering:'|| l_proc, 10);
215: --
216: -- Validation in addition to Row Handlers
217: --
218:
235: -- Delete Element Span Usages
236: --
237: for l_esu_rec in csr_esu(l_rcu_rec.retro_component_usage_id) loop
238:
239: hr_utility.set_location(l_proc, 15);
240: pay_esu_del.del
241: (p_element_span_usage_id => l_esu_rec.element_span_usage_id
242: ,p_object_version_number => l_esu_rec.object_version_number
243: );
246:
247: --
248: -- Delete Retro Component Usages
249: --
250: hr_utility.set_location(l_proc, 20);
251:
252: pay_rcu_del.del
253: (p_retro_component_usage_id => l_rcu_rec.retro_component_usage_id
254: ,p_object_version_number => l_rcu_rec.object_version_number
255: );
256:
257: end loop;
258:
259: hr_utility.set_location('Leaving:'||l_proc, 40);
260:
261: end delete_child_retro_comp_usages;
262:
263: --