DBA Data[Home] [Help]

APPS.BEN_CLS_UNRESOLVED_ACTN_ITEM dependencies on BEN_PERSON_ACTIONS

Line 1429: l_actn := 'Calling ben_person_actions_api.update_person_actions...';

1425: ,p_effective_date => p_effective_date);
1426: --
1427: If p_person_action_id is not null then
1428: --
1429: l_actn := 'Calling ben_person_actions_api.update_person_actions...';
1430: --
1431: ben_person_actions_api.update_person_actions
1432: (p_person_action_id => p_person_action_id
1433: ,p_action_status_cd => 'P'

Line 1431: ben_person_actions_api.update_person_actions

1427: If p_person_action_id is not null then
1428: --
1429: l_actn := 'Calling ben_person_actions_api.update_person_actions...';
1430: --
1431: ben_person_actions_api.update_person_actions
1432: (p_person_action_id => p_person_action_id
1433: ,p_action_status_cd => 'P'
1434: ,p_object_version_number => l_object_version_number
1435: ,p_effective_date => p_effective_date);

Line 1470: ben_person_actions_api.update_person_actions

1466: Ben_batch_utils.write(p_text => ' << Transactions Rollbacked >> ');
1467: --
1468: If p_person_action_id is not null then
1469: --
1470: ben_person_actions_api.update_person_actions
1471: (p_person_action_id => p_person_action_id
1472: ,p_action_status_cd => 'E'
1473: ,p_object_version_number => l_object_version_number
1474: ,p_effective_date => p_effective_date);

Line 1514: l_person_id ben_person_actions.person_id%type;

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

Line 1515: l_person_action_id ben_person_actions.person_action_id%type;

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

Line 1516: l_object_version_number ben_person_actions.object_version_number%type;

1512: --
1513: l_effective_date date;
1514: l_person_id ben_person_actions.person_id%type;
1515: l_person_action_id ben_person_actions.person_action_id%type;
1516: l_object_version_number ben_person_actions.object_version_number%type;
1517: l_ler_id ben_person_actions.ler_id%type;
1518: l_range_id ben_batch_ranges.range_id%type;
1519: l_record_number number := 0;
1520: l_start_person_action_id number := 0;

Line 1517: l_ler_id ben_person_actions.ler_id%type;

1513: l_effective_date date;
1514: l_person_id ben_person_actions.person_id%type;
1515: l_person_action_id ben_person_actions.person_action_id%type;
1516: l_object_version_number ben_person_actions.object_version_number%type;
1517: l_ler_id ben_person_actions.ler_id%type;
1518: l_range_id ben_batch_ranges.range_id%type;
1519: l_record_number number := 0;
1520: l_start_person_action_id number := 0;
1521: l_end_person_action_id number := 0;

Line 1547: from ben_person_actions ben

1543: select ben.person_id
1544: ,ben.person_action_id
1545: ,ben.object_version_number
1546: ,ben.ler_id
1547: from ben_person_actions ben
1548: where ben.benefit_action_id = p_benefit_action_id
1549: and ben.action_status_cd <> 'P'
1550: and ben.person_action_id between l_start_person_action_id
1551: and l_end_person_action_id

Line 2034: ben_person_actions_api.create_person_actions

2030: --
2031: -- Either no person sel rule or person selection rule passed. Create a
2032: -- person action row.
2033: --
2034: ben_person_actions_api.create_person_actions
2035: (p_validate => FALSE
2036: ,p_person_action_id => l_person_action_id
2037: ,p_person_id => l_rec.person_id
2038: ,p_benefit_action_id => l_benefit_action_id