eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PLAN_DESIGN_WIZARD_API dependencies on BEN_COPY_ENTITY_RESULTS

Line 13: l_static varchar2(200):='select copy_entity_result_id,table_alias, information1 pk_id,dml_operation from ben_copy_entity_results where copy_entity_txn_id = ' || p_copy_entity_txn_id || ' and ' ||

9: ,p_copy_entity_txn_id in Number
10: ,p_pk_id in varchar2
11: ,p_delete_clause in varchar2
12: ,l_query out nocopy varchar2) is
13: l_static varchar2(200):='select copy_entity_result_id,table_alias, information1 pk_id,dml_operation from ben_copy_entity_results where copy_entity_txn_id = ' || p_copy_entity_txn_id || ' and ' ||
14: 'table_alias in (';
15:
16: l_dynamic varchar2(2000):= null;
17: l_proc varchar2(72) := g_package||'get_query';

Line 170: cursor l_template is select copy_entity_result_id,table_alias,information1 pk_id, dml_operation from ben_copy_entity_results;

166: ,p_top_level_result_id in varchar2) is
167: type c_dpnts is REF CURSOR;
168: l_dpnts c_dpnts;
169: l_query varchar2(4000);
170: cursor l_template is select copy_entity_result_id,table_alias,information1 pk_id, dml_operation from ben_copy_entity_results;
171: l_dpnt_rows l_template%rowtype;
172: l_proc varchar2(72) := g_package||'delete_dpnts';
173: l_delete_clause varchar2(100) := ' AND( DML_OPERATION <> ''DELETE'' OR pd_parent_entity_result_id IS NULL )';
174: begin

Line 189: delete from ben_copy_entity_results where copy_entity_result_id = l_dpnt_rows.copy_entity_result_id ;

185: -- delete the parent row after deleting the child
186: hr_utility.set_location('Deleting Entity :'|| l_dpnt_rows.table_alias ||' copy_entity_result_id :'||to_char(l_dpnt_rows.copy_entity_result_id) ,30);
187: IF(g_top_level_entity = g_EXISTING) THEN
188: IF(l_dpnt_rows.dml_operation = 'INSERT') THEN
189: delete from ben_copy_entity_results where copy_entity_result_id = l_dpnt_rows.copy_entity_result_id ;
190: ELSE
191: -- call the delete
192: update ben_copy_entity_results set dml_operation = 'DELETE',datetrack_mode ='DELETE',pd_parent_entity_result_id= p_top_level_result_id where copy_entity_result_id = l_dpnt_rows.copy_entity_result_id ;
193: END IF;

Line 192: update ben_copy_entity_results set dml_operation = 'DELETE',datetrack_mode ='DELETE',pd_parent_entity_result_id= p_top_level_result_id where copy_entity_result_id = l_dpnt_rows.copy_entity_result_id ;

188: IF(l_dpnt_rows.dml_operation = 'INSERT') THEN
189: delete from ben_copy_entity_results where copy_entity_result_id = l_dpnt_rows.copy_entity_result_id ;
190: ELSE
191: -- call the delete
192: update ben_copy_entity_results set dml_operation = 'DELETE',datetrack_mode ='DELETE',pd_parent_entity_result_id= p_top_level_result_id where copy_entity_result_id = l_dpnt_rows.copy_entity_result_id ;
193: END IF;
194: ELSE
195: IF(l_dpnt_rows.dml_operation = 'REUSE' OR l_dpnt_rows.dml_operation = 'UPDATE') THEN
196: null;

Line 198: delete from ben_copy_entity_results where copy_entity_result_id = l_dpnt_rows.copy_entity_result_id ;

194: ELSE
195: IF(l_dpnt_rows.dml_operation = 'REUSE' OR l_dpnt_rows.dml_operation = 'UPDATE') THEN
196: null;
197: ELSE
198: delete from ben_copy_entity_results where copy_entity_result_id = l_dpnt_rows.copy_entity_result_id ;
199: END IF;
200: END IF;
201: end loop;
202: close l_dpnts ;

Line 213: UPDATE ben_copy_entity_results cer

209: --pragma AUTONOMOUS_TRANSACTION;
210: l_proc varchar2(72) := g_package||'write_route_and_hierarchy';
211: begin
212: hr_utility.set_location('Entering: '||l_proc,10);
213: UPDATE ben_copy_entity_results cer
214: set (table_route_id, order_in_hierarchy) =
215: (select table_route_id,display_order
216: from pqh_table_route
217: where from_clause ='OAB'

Line 241: UPDATE ben_copy_entity_results cer

237: --pragma AUTONOMOUS_TRANSACTION;
238: l_proc varchar2(72) := g_package||'write_route_and_hierarchy';
239: begin
240: hr_utility.set_location('Entering: '||l_proc,10);
241: UPDATE ben_copy_entity_results cer
242: set (table_route_id, order_in_hierarchy) =
243: (select table_route_id,display_order
244: from pqh_table_route
245: where from_clause ='OAB'

Line 264: -- Update ben_copy_entity_results with number_of_copy = 0, if copied rows

260: end write_route_and_hierarchy;
261:
262:
263: --
264: -- Update ben_copy_entity_results with number_of_copy = 0, if copied rows
265: -- effective date not between effective_start_date and effective_end date
266: --
267: procedure update_result_rows(p_copy_entity_txn_id in number)
268: is

Line 280: UPDATE ben_copy_entity_results cer

276: where copy_entity_txn_id = p_copy_entity_txn_id;
277:
278: hr_utility.set_location('l_effectve_date: '||l_effectve_date,10);
279:
280: UPDATE ben_copy_entity_results cer
281: set number_of_copies = 0
282: where cer.copy_entity_txn_id = p_copy_entity_txn_id
283: and l_effectve_date not between information2 and information3;
284:

Line 307: update ben_copy_entity_results set dml_operation = 'DELETE',datetrack_mode ='DELETE' where copy_entity_result_id = p_parent_entity_result_id ;

303: -- we need to rollback all this after the validation
304: savepoint VALIDATE_DELETE_API_CALLS;
305: -- make sure that parent is marked for delete
306: -- since the delete_entity does not mark the parent for delete as it is done in the java layer
307: update ben_copy_entity_results set dml_operation = 'DELETE',datetrack_mode ='DELETE' where copy_entity_result_id = p_parent_entity_result_id ;
308: ben_plan_design_delete_api.call_delete_apis_for_hierarchy
309: ( p_process_validate => l_validate
310: ,p_copy_entity_txn_id => p_copy_entity_txn_id
311: ,p_parent_entity_result_id => p_parent_entity_result_id

Line 335: select information1 from ben_copy_entity_results where

331: l_pk_id Number;
332: l_proc varchar2(72) := g_package||'delete_entity';
333:
334: cursor getId is
335: select information1 from ben_copy_entity_results where
336: copy_entity_result_id = p_copy_entity_result_id;
337: begin
338:
339: hr_utility.set_location('Entering: '||l_proc,10);

Line 348: -- delete from ben_copy_entity_results where copy_entity_result_id = p_copy_entity_result_id ;

344: if(getId%found) then
345: delete_dpnts(p_table_alias,p_copy_entity_txn_id,l_pk_id,p_copy_entity_result_id);
346: -- finally delete the parent
347: -- this is commented since we delete the parent in EO's remove method.
348: -- delete from ben_copy_entity_results where copy_entity_result_id = p_copy_entity_result_id ;
349: end if;
350: close getId;
351:
352: hr_utility.set_location('Leaving: '||l_proc,20);

Line 367: select information1 from ben_copy_entity_results where

363: l_pk_id Number;
364: p_delete_failed varchar2(1) := 'N';
365: l_proc varchar2(72) := g_package||'delete_entity';
366: cursor getId is
367: select information1 from ben_copy_entity_results where
368: copy_entity_result_id = p_copy_entity_result_id;
369: begin
370:
371: hr_utility.set_location('Entering: '||l_proc,10);

Line 380: -- delete from ben_copy_entity_results where copy_entity_result_id = p_copy_entity_result_id ;

376: if(getId%found) then
377: delete_dpnts(p_table_alias,p_copy_entity_txn_id,l_pk_id,p_copy_entity_result_id);
378: -- finally delete the parent
379: -- this is commented since we delete the parent in EO's remove method.
380: -- delete from ben_copy_entity_results where copy_entity_result_id = p_copy_entity_result_id ;
381: end if;
382: close getId;
383: -- now call the delete apis for this hierarchy.
384: IF(g_top_level_entity = g_EXISTING) THEN

Line 442: UPDATE ben_copy_entity_results cer

438: open c_effective_date;
439: fetch c_effective_date into l_effective_date;
440: close c_effective_date;
441: -- submit api is failing if it picks up the end-dated ben entities.
442: UPDATE ben_copy_entity_results cer
443: set number_of_copies = 0
444: where cer.copy_entity_txn_id = p_copy_entity_txn_id
445: and l_effective_date between information2 and information3
446: and cer.dml_operation = 'DELETE';

Line 531: update ben_copy_entity_results

527: procedure reuse_deleted_hierarchy
528: (p_copy_entity_txn_id in number
529: ,p_copy_entity_result_id in number)is
530: begin
531: update ben_copy_entity_results
532: set dml_operation = 'REUSE'
533: ,datetrack_mode= 'INSERT'
534: ,pd_parent_entity_result_id = null
535: where