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_PERSON_ACTIONS

Line 158: FROM ben_person_actions

154: CURSOR c27 (
155: p_person_id NUMBER
156: ) IS
157: SELECT 1
158: FROM ben_person_actions
159: WHERE person_id = p_person_id;
160: CURSOR c4 (
161: p_person_id NUMBER
162: ) IS

Line 225: ben_person_actions pat

221: p_person_id NUMBER
222: ) IS
223: SELECT 1
224: FROM ben_reporting rep,
225: ben_person_actions pat
226: WHERE pat.person_id = p_person_id
227: AND rep.benefit_action_id = pat.benefit_action_id; /* Bug 4882374 : Perf */
228: CURSOR c29 (
229: p_person_id NUMBER

Line 676: -- Testing for values in BEN_PERSON_ACTIONS

672: --
673: CLOSE c11;
674:
675: --
676: -- Testing for values in BEN_PERSON_ACTIONS
677: --
678: OPEN c27 (
679: p_person_id
680: );

Line 692: 'BEN_PERSON_ACTIONS'

688: 'BEN_94121_DT_CHILD_EXISTS'
689: );
690: fnd_message.set_token (
691: 'TABLE_NAME',
692: 'BEN_PERSON_ACTIONS'
693: );
694: fnd_message.raise_error;
695: END IF;
696:

Line 2219: FROM ben_person_actions

2215: CURSOR c3 (
2216: p_benefit_action_id NUMBER
2217: ) IS
2218: SELECT person_action_id
2219: FROM ben_person_actions
2220: WHERE benefit_action_id = p_benefit_action_id
2221: FOR UPDATE OF person_action_id;
2222: CURSOR c4 (
2223: p_benefit_action_id NUMBER

Line 2249: <>

2245: CLOSE c2;
2246: OPEN c3 (
2247: r1.benefit_action_id
2248: );
2249: <>
2250: LOOP
2251: FETCH c3 INTO l_id;
2252: EXIT WHEN c3%NOTFOUND;
2253: DELETE FROM ben_person_actions

Line 2253: DELETE FROM ben_person_actions

2249: <>
2250: LOOP
2251: FETCH c3 INTO l_id;
2252: EXIT WHEN c3%NOTFOUND;
2253: DELETE FROM ben_person_actions
2254: WHERE CURRENT OF c3;
2255: END LOOP ben_person_actions;
2256: CLOSE c3;
2257: OPEN c4 (

Line 2255: END LOOP ben_person_actions;

2251: FETCH c3 INTO l_id;
2252: EXIT WHEN c3%NOTFOUND;
2253: DELETE FROM ben_person_actions
2254: WHERE CURRENT OF c3;
2255: END LOOP ben_person_actions;
2256: CLOSE c3;
2257: OPEN c4 (
2258: r1.benefit_action_id
2259: );

Line 2450: ben_person_actions pat,

2446: p_person_id NUMBER
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) )

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 2839: <>

2835: CLOSE c28;
2836: OPEN c29 (
2837: p_person_id
2838: );
2839: <>
2840: LOOP
2841: FETCH c29 INTO l_id;
2842: EXIT WHEN c29%NOTFOUND;
2843: DELETE FROM ben_person_actions

Line 2843: DELETE FROM ben_person_actions

2839: <>
2840: LOOP
2841: FETCH c29 INTO l_id;
2842: EXIT WHEN c29%NOTFOUND;
2843: DELETE FROM ben_person_actions
2844: WHERE CURRENT OF c29;
2845: END LOOP ben_person_actions;
2846: CLOSE c29;
2847: OPEN c30 (

Line 2845: END LOOP ben_person_actions;

2841: FETCH c29 INTO l_id;
2842: EXIT WHEN c29%NOTFOUND;
2843: DELETE FROM ben_person_actions
2844: WHERE CURRENT OF c29;
2845: END LOOP ben_person_actions;
2846: CLOSE c29;
2847: OPEN c30 (
2848: p_person_id
2849: );

Line 3519: --hr_utility.set_location('ben_person_actions_api.create_person_actions',104);

3515: benutils.g_benefit_action_id := l_benefit_action_id;
3516:
3517: -- Create a person action row.
3518: --
3519: --hr_utility.set_location('ben_person_actions_api.create_person_actions',104);
3520: ben_person_actions_api.create_person_actions
3521: (p_validate => FALSE
3522: ,p_person_action_id => l_person_action_id
3523: ,p_person_id => p_person_id

Line 3520: ben_person_actions_api.create_person_actions

3516:
3517: -- Create a person action row.
3518: --
3519: --hr_utility.set_location('ben_person_actions_api.create_person_actions',104);
3520: ben_person_actions_api.create_person_actions
3521: (p_validate => FALSE
3522: ,p_person_action_id => l_person_action_id
3523: ,p_person_id => p_person_id
3524: ,p_benefit_action_id => l_benefit_action_id

Line 3611: update ben_person_actions

3607: ben_batch_utils.write(p_text => ' No Unrestricted LE exists for the employee (or) ');
3608: ben_batch_utils.write(p_text => ' Payroll is run for the employee (or) ');
3609: ben_batch_utils.write(p_text => ' Error while deleting element entries (or) ');
3610: ben_batch_utils.write(p_text => ' Error while deleting Benefits enrollments ');
3611: update ben_person_actions
3612: set action_status_cd = 'E'
3613: where person_action_id = l_person_action_id;
3614: commit;
3615: hr_utility.set_location('Unhandled exception',100);