APPS.BEN_CLS_UNRESOLVED_ACTN_ITEM dependencies on BEN_PERSON_ACTIONS

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

1285: ,p_effective_date => p_effective_date);
1286: --
1287: If p_person_action_id is not null then
1288: --
1289: l_actn := 'Calling ben_person_actions_api.update_person_actions...';
1290: --
1291: ben_person_actions_api.update_person_actions
1292: (p_person_action_id => p_person_action_id
1293: ,p_action_status_cd => 'P'

Line 1291: ben_person_actions_api.update_person_actions

1287: If p_person_action_id is not null then
1288: --
1289: l_actn := 'Calling ben_person_actions_api.update_person_actions...';
1290: --
1291: ben_person_actions_api.update_person_actions
1292: (p_person_action_id => p_person_action_id
1293: ,p_action_status_cd => 'P'
1294: ,p_object_version_number => l_object_version_number
1295: ,p_effective_date => p_effective_date);

Line 1330: ben_person_actions_api.update_person_actions

1326: Ben_batch_utils.write(p_text => ' << Transactions Rollbacked >> ');
1327: --
1328: If p_person_action_id is not null then
1329: --
1330: ben_person_actions_api.update_person_actions
1331: (p_person_action_id => p_person_action_id
1332: ,p_action_status_cd => 'E'
1333: ,p_object_version_number => l_object_version_number
1334: ,p_effective_date => p_effective_date);

Line 1374: l_person_id ben_person_actions.person_id%type;

1370: --
1371: l_proc varchar2(80) := g_package||'.do_multithread';
1372: --
1373: l_effective_date date;
1374: l_person_id ben_person_actions.person_id%type;
1375: l_person_action_id ben_person_actions.person_action_id%type;
1376: l_object_version_number ben_person_actions.object_version_number%type;
1377: l_ler_id ben_person_actions.ler_id%type;
1378: l_range_id ben_batch_ranges.range_id%type;

Line 1375: l_person_action_id ben_person_actions.person_action_id%type;

1371: l_proc varchar2(80) := g_package||'.do_multithread';
1372: --
1373: l_effective_date date;
1374: l_person_id ben_person_actions.person_id%type;
1375: l_person_action_id ben_person_actions.person_action_id%type;
1376: l_object_version_number ben_person_actions.object_version_number%type;
1377: l_ler_id ben_person_actions.ler_id%type;
1378: l_range_id ben_batch_ranges.range_id%type;
1379: l_record_number number := 0;

Line 1376: l_object_version_number ben_person_actions.object_version_number%type;

1372: --
1373: l_effective_date date;
1374: l_person_id ben_person_actions.person_id%type;
1375: l_person_action_id ben_person_actions.person_action_id%type;
1376: l_object_version_number ben_person_actions.object_version_number%type;
1377: l_ler_id ben_person_actions.ler_id%type;
1378: l_range_id ben_batch_ranges.range_id%type;
1379: l_record_number number := 0;
1380: l_start_person_action_id number := 0;

Line 1377: l_ler_id ben_person_actions.ler_id%type;

1373: l_effective_date date;
1374: l_person_id ben_person_actions.person_id%type;
1375: l_person_action_id ben_person_actions.person_action_id%type;
1376: l_object_version_number ben_person_actions.object_version_number%type;
1377: l_ler_id ben_person_actions.ler_id%type;
1378: l_range_id ben_batch_ranges.range_id%type;
1379: l_record_number number := 0;
1380: l_start_person_action_id number := 0;
1381: l_end_person_action_id number := 0;

Line 1407: from ben_person_actions ben

1403: select ben.person_id
1404: ,ben.person_action_id
1405: ,ben.object_version_number
1406: ,ben.ler_id
1407: from ben_person_actions ben
1408: where ben.benefit_action_id = p_benefit_action_id
1409: and ben.action_status_cd <> 'P'
1410: and ben.person_action_id between l_start_person_action_id
1411: and l_end_person_action_id

Line 1894: ben_person_actions_api.create_person_actions

1890: --
1891: -- Either no person sel rule or person selection rule passed. Create a
1892: -- person action row.
1893: --
1894: ben_person_actions_api.create_person_actions
1895: (p_validate => FALSE
1896: ,p_person_action_id => l_person_action_id
1897: ,p_person_id => l_rec.person_id
1898: ,p_benefit_action_id => l_benefit_action_id