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_PERSON_DELETE dependencies on BEN_BENEFIT_ACTIONS

Line 108: FROM ben_benefit_actions

104: CURSOR c26 (
105: p_person_id NUMBER
106: ) IS
107: SELECT 1
108: FROM ben_benefit_actions
109: WHERE person_id = p_person_id;
110: CURSOR c15 (
111: p_person_id NUMBER
112: ) IS

Line 476: -- Testing for values in BEN_BENEFIT_ACTIONS

472: --
473: CLOSE c25;
474:
475: --
476: -- Testing for values in BEN_BENEFIT_ACTIONS
477: --
478: OPEN c26 (
479: p_person_id
480: );

Line 492: 'BEN_BENEFIT_ACTIONS'

488: 'BEN_94121_DT_CHILD_EXISTS'
489: );
490: fnd_message.set_token (
491: 'TABLE_NAME',
492: 'BEN_BENEFIT_ACTIONS'
493: );
494: fnd_message.raise_error;
495: END IF;
496:

Line 2195: --** CN|c1|Fetch the benefit_action_id from ben_benefit_actions associated with a person_id for a particular business group.

2191: ) IS
2192:
2193: l_proc varchar2(100):= g_package||'delete_benefit_action_children';
2194: --** C|c1
2195: --** CN|c1|Fetch the benefit_action_id from ben_benefit_actions associated with a person_id for a particular business group.
2196: CURSOR c1 IS
2197: SELECT DISTINCT benefit_action_id
2198: FROM ben_benefit_actions bba
2199: --,ben_ler_f ler

Line 2198: FROM ben_benefit_actions bba

2194: --** C|c1
2195: --** CN|c1|Fetch the benefit_action_id from ben_benefit_actions associated with a person_id for a particular business group.
2196: CURSOR c1 IS
2197: SELECT DISTINCT benefit_action_id
2198: FROM ben_benefit_actions bba
2199: --,ben_ler_f ler
2200: WHERE person_id = p_person_id
2201: and ( (p_per_in_ler_id is not NULL and MODE_CD = 'U') or (p_per_in_ler_id is NULL) );
2202: /* bba.ler_id = ler.ler_id

Line 2353: FROM ben_batch_actn_item_info a,ben_benefit_actions b

2349: CURSOR c20 (
2350: p_person_id NUMBER
2351: ) IS
2352: SELECT batch_actn_item_id
2353: FROM ben_batch_actn_item_info a,ben_benefit_actions b
2354: WHERE a.person_id = p_person_id
2355: and a.BENEFIT_ACTION_ID = b.BENEFIT_ACTION_ID
2356: and b.person_id = p_person_id--Bug 14505730
2357: and ( (p_per_in_ler_id is not NULL and b.MODE_CD = 'U') or (p_per_in_ler_id is NULL) )

Line 2365: FROM ben_batch_bnft_cert_info a,ben_benefit_actions b

2361: CURSOR c21 (
2362: p_person_id NUMBER
2363: ) IS
2364: SELECT batch_benft_cert_id
2365: FROM ben_batch_bnft_cert_info a,ben_benefit_actions b
2366: WHERE a.person_id = p_person_id
2367: and a.BENEFIT_ACTION_ID = b.BENEFIT_ACTION_ID
2368: and b.person_id = p_person_id--Bug 14505730
2369: and ( (p_per_in_ler_id is not NULL and b.MODE_CD = 'U') or (p_per_in_ler_id is NULL) )

Line 2377: FROM ben_batch_commu_info a,ben_benefit_actions b

2373: CURSOR c22 (
2374: p_person_id NUMBER
2375: ) IS
2376: SELECT batch_commu_id
2377: FROM ben_batch_commu_info a,ben_benefit_actions b
2378: WHERE a.person_id = p_person_id
2379: and a.BENEFIT_ACTION_ID = b.BENEFIT_ACTION_ID
2380: and b.person_id = p_person_id--Bug 14505730
2381: and ( (p_per_in_ler_id is not NULL and b.MODE_CD = 'U') or (p_per_in_ler_id is NULL) )

Line 2389: FROM ben_batch_dpnt_info a,ben_benefit_actions b

2385: CURSOR c23 (
2386: p_person_id NUMBER
2387: ) IS
2388: SELECT batch_dpnt_id
2389: FROM ben_batch_dpnt_info a,ben_benefit_actions b
2390: WHERE a.person_id = p_person_id
2391: and a.BENEFIT_ACTION_ID = b.BENEFIT_ACTION_ID
2392: and b.person_id = p_person_id--Bug 14505730
2393: and ( (p_per_in_ler_id is not NULL and b.MODE_CD = 'U') or (p_per_in_ler_id is NULL) )

Line 2401: FROM ben_batch_elctbl_chc_info a,ben_benefit_actions b

2397: CURSOR c24 (
2398: p_person_id NUMBER
2399: ) IS
2400: SELECT batch_elctbl_id
2401: FROM ben_batch_elctbl_chc_info a,ben_benefit_actions b
2402: WHERE a.person_id = p_person_id
2403: and a.BENEFIT_ACTION_ID = b.BENEFIT_ACTION_ID
2404: and b.person_id = p_person_id--Bug 14505730
2405: and ( (p_per_in_ler_id is not NULL and b.MODE_CD = 'U') or (p_per_in_ler_id is NULL) )

Line 2413: FROM ben_batch_elig_info a,ben_benefit_actions b

2409: CURSOR c25 (
2410: p_person_id NUMBER
2411: ) IS
2412: SELECT batch_elig_id
2413: FROM ben_batch_elig_info a,ben_benefit_actions b
2414: WHERE a.person_id = p_person_id
2415: and a.BENEFIT_ACTION_ID = b.BENEFIT_ACTION_ID
2416: and b.person_id = p_person_id--Bug 14505730
2417: and ( (p_per_in_ler_id is not NULL and b.MODE_CD = 'U') or (p_per_in_ler_id is NULL) )

Line 2425: FROM ben_batch_ler_info a,ben_benefit_actions b

2421: CURSOR c26 (
2422: p_person_id NUMBER
2423: ) IS
2424: SELECT batch_ler_id
2425: FROM ben_batch_ler_info a,ben_benefit_actions b
2426: WHERE a.person_id = p_person_id
2427: and a.BENEFIT_ACTION_ID = b.BENEFIT_ACTION_ID
2428: and b.person_id = p_person_id--Bug 14505730
2429: and ( (p_per_in_ler_id is not NULL and b.MODE_CD = 'U') or (p_per_in_ler_id is NULL) )

Line 2437: FROM ben_batch_rate_info a,ben_benefit_actions b

2433: CURSOR c27 (
2434: p_person_id NUMBER
2435: ) IS
2436: SELECT batch_rt_id
2437: FROM ben_batch_rate_info a,ben_benefit_actions b
2438: WHERE a.person_id = p_person_id
2439: and a.BENEFIT_ACTION_ID = b.BENEFIT_ACTION_ID
2440: and b.person_id = p_person_id--Bug 14505730
2441: and ( (p_per_in_ler_id is not NULL and b.MODE_CD = 'U') or (p_per_in_ler_id is NULL) )

Line 2451: ben_benefit_actions b

2447: ) IS
2448: SELECT reporting_id
2449: FROM ben_reporting rep,
2450: ben_person_actions pat,
2451: ben_benefit_actions b
2452: WHERE pat.person_id = p_person_id
2453: and pat.BENEFIT_ACTION_ID = b.BENEFIT_ACTION_ID
2454: and ( (p_per_in_ler_id is not NULL and b.MODE_CD = 'U') or (p_per_in_ler_id is NULL) )
2455: AND rep.benefit_action_id = pat.benefit_action_id /* Bug 4882374 : Perf */

Line 2465: FROM ben_person_actions a,ben_benefit_actions b

2461: CURSOR c29 (
2462: p_person_id NUMBER
2463: ) IS
2464: SELECT person_action_id
2465: FROM ben_person_actions a,ben_benefit_actions b
2466: WHERE a.person_id = p_person_id
2467: and a.BENEFIT_ACTION_ID = b.BENEFIT_ACTION_ID
2468: and b.person_id = p_person_id--Bug 14505730
2469: and ( (p_per_in_ler_id is not NULL and b.MODE_CD = 'U') or (p_per_in_ler_id is NULL) )

Line 2477: FROM ben_benefit_actions b

2473: CURSOR c30 (
2474: p_person_id NUMBER
2475: ) IS
2476: SELECT benefit_action_id
2477: FROM ben_benefit_actions b
2478: WHERE person_id = p_person_id
2479: and ( (p_per_in_ler_id is not NULL and b.MODE_CD = 'U') or (p_per_in_ler_id is NULL) )
2480: FOR UPDATE OF benefit_action_id;
2481:

Line 2850: <>

2846: CLOSE c29;
2847: OPEN c30 (
2848: p_person_id
2849: );
2850: <>
2851: LOOP
2852: FETCH c30 INTO l_id;
2853: EXIT WHEN c30%NOTFOUND;
2854: DELETE FROM ben_benefit_actions

Line 2854: DELETE FROM ben_benefit_actions

2850: <>
2851: LOOP
2852: FETCH c30 INTO l_id;
2853: EXIT WHEN c30%NOTFOUND;
2854: DELETE FROM ben_benefit_actions
2855: WHERE CURRENT OF c30;
2856: END LOOP ben_benefit_actions;
2857: CLOSE c30;
2858: if(p_per_in_ler_id is NULL) then

Line 2856: END LOOP ben_benefit_actions;

2852: FETCH c30 INTO l_id;
2853: EXIT WHEN c30%NOTFOUND;
2854: DELETE FROM ben_benefit_actions
2855: WHERE CURRENT OF c30;
2856: END LOOP ben_benefit_actions;
2857: CLOSE c30;
2858: if(p_per_in_ler_id is NULL) then
2859: OPEN c31 (
2860: p_person_id

Line 3492: --hr_utility.set_location ('ben_benefit_actions_api.create_benefit_actions',102);

3488: ,p_threads => l_threads
3489: ,p_chunk_size => l_chunk_size
3490: ,p_max_errors => l_max_person_err);
3491:
3492: --hr_utility.set_location ('ben_benefit_actions_api.create_benefit_actions',102);
3493: ben_benefit_actions_api.create_benefit_actions
3494: (p_validate => FALSE
3495: ,p_benefit_action_id => l_benefit_action_id
3496: ,p_process_date => l_effective_date

Line 3493: ben_benefit_actions_api.create_benefit_actions

3489: ,p_chunk_size => l_chunk_size
3490: ,p_max_errors => l_max_person_err);
3491:
3492: --hr_utility.set_location ('ben_benefit_actions_api.create_benefit_actions',102);
3493: ben_benefit_actions_api.create_benefit_actions
3494: (p_validate => FALSE
3495: ,p_benefit_action_id => l_benefit_action_id
3496: ,p_process_date => l_effective_date
3497: ,p_validate_flag => p_validate

Line 3513: --hr_utility.set_location ('After ben_benefit_actions_api.create_benefit_actions',103);

3509: ,p_program_application_id => fnd_global.prog_appl_id
3510: ,p_program_id => fnd_global.conc_program_id
3511: ,p_program_update_date => sysdate
3512: );
3513: --hr_utility.set_location ('After ben_benefit_actions_api.create_benefit_actions',103);
3514:
3515: benutils.g_benefit_action_id := l_benefit_action_id;
3516:
3517: -- Create a person action row.