APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_PERSON_ACTIONS

Line 1371: ben_person_actions_api.update_person_actions

1367: if p_person_action_id is not null then
1368: --
1369: -- update the person action status to processed.
1370: --
1371: ben_person_actions_api.update_person_actions
1372: (p_person_action_id => p_person_action_id
1373: ,p_action_status_cd => 'P'
1374: ,p_object_version_number => l_pers_ovn
1375: ,p_effective_date => p_effective_date);

Line 1423: ben_person_actions_api.update_person_actions

1419: -- Update the person action status code to errored.
1420: --
1421: if p_person_action_id is not null then
1422: --
1423: ben_person_actions_api.update_person_actions
1424: (p_person_action_id => p_person_action_id
1425: ,p_action_status_cd => 'E'
1426: ,p_object_version_number => l_pers_ovn
1427: ,p_effective_date => p_effective_date);

Line 1470: l_person_id ben_person_actions.person_id%type;

1466: -- Local variable declaration
1467: --
1468: l_effective_date date;
1469: l_proc varchar2(80) := g_package || '.do_multithread';
1470: l_person_id ben_person_actions.person_id%type;
1471: l_person_action_id ben_person_actions.person_action_id%type;
1472: l_object_version_number ben_person_actions.object_version_number%type;
1473: l_ler_id ben_person_actions.ler_id%type;
1474: l_range_id ben_batch_ranges.range_id%type;

Line 1471: l_person_action_id ben_person_actions.person_action_id%type;

1467: --
1468: l_effective_date date;
1469: l_proc varchar2(80) := g_package || '.do_multithread';
1470: l_person_id ben_person_actions.person_id%type;
1471: l_person_action_id ben_person_actions.person_action_id%type;
1472: l_object_version_number ben_person_actions.object_version_number%type;
1473: l_ler_id ben_person_actions.ler_id%type;
1474: l_range_id ben_batch_ranges.range_id%type;
1475: l_record_number number := 0;

Line 1472: l_object_version_number ben_person_actions.object_version_number%type;

1468: l_effective_date date;
1469: l_proc varchar2(80) := g_package || '.do_multithread';
1470: l_person_id ben_person_actions.person_id%type;
1471: l_person_action_id ben_person_actions.person_action_id%type;
1472: l_object_version_number ben_person_actions.object_version_number%type;
1473: l_ler_id ben_person_actions.ler_id%type;
1474: l_range_id ben_batch_ranges.range_id%type;
1475: l_record_number number := 0;
1476: l_start_person_action_id number := 0;

Line 1473: l_ler_id ben_person_actions.ler_id%type;

1469: l_proc varchar2(80) := g_package || '.do_multithread';
1470: l_person_id ben_person_actions.person_id%type;
1471: l_person_action_id ben_person_actions.person_action_id%type;
1472: l_object_version_number ben_person_actions.object_version_number%type;
1473: l_ler_id ben_person_actions.ler_id%type;
1474: l_range_id ben_batch_ranges.range_id%type;
1475: l_record_number number := 0;
1476: l_start_person_action_id number := 0;
1477: l_end_person_action_id number := 0;

Line 1503: from ben_person_actions ben

1499: select ben.person_id
1500: ,ben.person_action_id
1501: ,ben.object_version_number
1502: ,ben.ler_id
1503: from ben_person_actions ben
1504: where ben.benefit_action_id = p_benefit_action_id
1505: and ben.action_status_cd <> 'P'
1506: and ben.person_action_id between l_start_person_action_id
1507: and l_end_person_action_id

Line 1645: update ben_person_actions

1641: l_record_number := l_record_number + 1;
1642: --
1643: l_actn := 'Updating person_ations.';
1644: --
1645: update ben_person_actions
1646: set action_status_cd = 'T'
1647: where person_action_id = l_person_action_id;
1648: --
1649: end loop;

Line 1710: update ben_person_actions

1706: g_rec.national_identifier := l_per_rec.national_identifier;
1707: benutils.write(p_text => g_rec.text);
1708: benutils.write(p_rec => g_rec);
1709: --
1710: update ben_person_actions
1711: set action_status_cd = 'E'
1712: where person_action_id = g_cache_per_proc(l_cnt).person_action_id;
1713: --
1714: -- end bug 3079317

Line 2190: ben_person_actions_api.create_person_actions

2186: --
2187: -- Either no person sel rule or person selection rule passed. Create a
2188: -- person action row.
2189: --
2190: ben_person_actions_api.create_person_actions
2191: (p_validate => FALSE
2192: ,p_person_action_id => l_person_action_id
2193: ,p_person_id => l_perid_va(i)
2194: ,p_ler_id => l_pilid_va(i)