APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_PERSON_ACTIONS

Line 1411: ben_person_actions_api.update_person_actions

1407: if p_person_action_id is not null then
1408: --
1409: -- update the person action status to processed.
1410: --
1411: ben_person_actions_api.update_person_actions
1412: (p_person_action_id => p_person_action_id
1413: ,p_action_status_cd => 'P'
1414: ,p_object_version_number => l_pers_ovn
1415: ,p_effective_date => p_effective_date);

Line 1463: ben_person_actions_api.update_person_actions

1459: -- Update the person action status code to errored.
1460: --
1461: if p_person_action_id is not null then
1462: --
1463: ben_person_actions_api.update_person_actions
1464: (p_person_action_id => p_person_action_id
1465: ,p_action_status_cd => 'E'
1466: ,p_object_version_number => l_pers_ovn
1467: ,p_effective_date => p_effective_date);

Line 1510: l_person_id ben_person_actions.person_id%type;

1506: -- Local variable declaration
1507: --
1508: l_effective_date date;
1509: l_proc varchar2(80) := g_package || '.do_multithread';
1510: l_person_id ben_person_actions.person_id%type;
1511: l_person_action_id ben_person_actions.person_action_id%type;
1512: l_object_version_number ben_person_actions.object_version_number%type;
1513: l_ler_id ben_person_actions.ler_id%type;
1514: l_range_id ben_batch_ranges.range_id%type;

Line 1511: l_person_action_id ben_person_actions.person_action_id%type;

1507: --
1508: l_effective_date date;
1509: l_proc varchar2(80) := g_package || '.do_multithread';
1510: l_person_id ben_person_actions.person_id%type;
1511: l_person_action_id ben_person_actions.person_action_id%type;
1512: l_object_version_number ben_person_actions.object_version_number%type;
1513: l_ler_id ben_person_actions.ler_id%type;
1514: l_range_id ben_batch_ranges.range_id%type;
1515: l_record_number number := 0;

Line 1512: l_object_version_number ben_person_actions.object_version_number%type;

1508: l_effective_date date;
1509: l_proc varchar2(80) := g_package || '.do_multithread';
1510: l_person_id ben_person_actions.person_id%type;
1511: l_person_action_id ben_person_actions.person_action_id%type;
1512: l_object_version_number ben_person_actions.object_version_number%type;
1513: l_ler_id ben_person_actions.ler_id%type;
1514: l_range_id ben_batch_ranges.range_id%type;
1515: l_record_number number := 0;
1516: l_start_person_action_id number := 0;

Line 1513: l_ler_id ben_person_actions.ler_id%type;

1509: l_proc varchar2(80) := g_package || '.do_multithread';
1510: l_person_id ben_person_actions.person_id%type;
1511: l_person_action_id ben_person_actions.person_action_id%type;
1512: l_object_version_number ben_person_actions.object_version_number%type;
1513: l_ler_id ben_person_actions.ler_id%type;
1514: l_range_id ben_batch_ranges.range_id%type;
1515: l_record_number number := 0;
1516: l_start_person_action_id number := 0;
1517: l_end_person_action_id number := 0;

Line 1543: from ben_person_actions ben

1539: select ben.person_id
1540: ,ben.person_action_id
1541: ,ben.object_version_number
1542: ,ben.ler_id
1543: from ben_person_actions ben
1544: where ben.benefit_action_id = p_benefit_action_id
1545: and ben.action_status_cd <> 'P'
1546: and ben.person_action_id between l_start_person_action_id
1547: and l_end_person_action_id

Line 1685: update ben_person_actions

1681: l_record_number := l_record_number + 1;
1682: --
1683: l_actn := 'Updating person_ations.';
1684: --
1685: update ben_person_actions
1686: set action_status_cd = 'T'
1687: where person_action_id = l_person_action_id;
1688: --
1689: end loop;

Line 1750: update ben_person_actions

1746: g_rec.national_identifier := l_per_rec.national_identifier;
1747: benutils.write(p_text => g_rec.text);
1748: benutils.write(p_rec => g_rec);
1749: --
1750: update ben_person_actions
1751: set action_status_cd = 'E'
1752: where person_action_id = g_cache_per_proc(l_cnt).person_action_id;
1753: --
1754: -- end bug 3079317

Line 2230: ben_person_actions_api.create_person_actions

2226: --
2227: -- Either no person sel rule or person selection rule passed. Create a
2228: -- person action row.
2229: --
2230: ben_person_actions_api.create_person_actions
2231: (p_validate => FALSE
2232: ,p_person_action_id => l_person_action_id
2233: ,p_person_id => l_perid_va(i)
2234: ,p_ler_id => l_pilid_va(i)