[Home] [Help]
422: --
423: -- Local variable declaration
424: --
425: l_proc varchar2(80) := g_package||'.do_multithread';
426: l_person_id ben_person_actions.person_id%type;
427: l_person_action_id ben_person_actions.person_action_id%type;
428: l_object_version_number ben_person_actions.object_version_number%type;
429: l_ler_id ben_person_actions.ler_id%type;
430: l_range_id ben_batch_ranges.range_id%type;
423: -- Local variable declaration
424: --
425: l_proc varchar2(80) := g_package||'.do_multithread';
426: l_person_id ben_person_actions.person_id%type;
427: l_person_action_id ben_person_actions.person_action_id%type;
428: l_object_version_number ben_person_actions.object_version_number%type;
429: l_ler_id ben_person_actions.ler_id%type;
430: l_range_id ben_batch_ranges.range_id%type;
431: l_record_number number := 0;
424: --
425: l_proc varchar2(80) := g_package||'.do_multithread';
426: l_person_id ben_person_actions.person_id%type;
427: l_person_action_id ben_person_actions.person_action_id%type;
428: l_object_version_number ben_person_actions.object_version_number%type;
429: l_ler_id ben_person_actions.ler_id%type;
430: l_range_id ben_batch_ranges.range_id%type;
431: l_record_number number := 0;
432: l_start_person_action_id number := 0;
425: l_proc varchar2(80) := g_package||'.do_multithread';
426: l_person_id ben_person_actions.person_id%type;
427: l_person_action_id ben_person_actions.person_action_id%type;
428: l_object_version_number ben_person_actions.object_version_number%type;
429: l_ler_id ben_person_actions.ler_id%type;
430: l_range_id ben_batch_ranges.range_id%type;
431: l_record_number number := 0;
432: l_start_person_action_id number := 0;
433: l_end_person_action_id number := 0;
453: Select ben.person_id
454: ,ben.person_action_id
455: ,ben.object_version_number
456: ,ben.ler_id
457: From ben_person_actions ben
458: Where ben.benefit_action_id = p_benefit_action_id
459: And ben.action_status_cd <> 'P'
460: And ben.person_action_id between
461: l_start_person_action_id and l_end_person_action_id
1036: l_person_action_id.extend(1);
1037: --
1038: -- Get Primary Key value
1039: --
1040: select ben_person_actions_s.nextval
1041: into l_person_action_id(l_num_rows)
1042: from sys.dual;
1043: --
1044: -- Extend person_id type
1051: -- Bulk bind in person actions
1052: --
1053: forall l_count in 1..l_num_rows
1054: --
1055: insert into ben_person_actions
1056: (person_action_id,
1057: person_id,
1058: ler_id,
1059: benefit_action_id,
1117: forall l_count in 1..l_num_rows
1118: --
1119: -- Bulk bind in person actions
1120: --
1121: insert into ben_person_actions
1122: (person_action_id,
1123: person_id,
1124: ler_id,
1125: benefit_action_id,
2173: );
2174: --
2175: If p_person_action_id is not null then
2176: --
2177: l_actn := 'Calling ben_person_actions_api.update_person_actions...';
2178: --
2179: update ben_person_actions
2180: set action_status_cd = 'P'
2181: where person_action_id = p_person_action_id;
2175: If p_person_action_id is not null then
2176: --
2177: l_actn := 'Calling ben_person_actions_api.update_person_actions...';
2178: --
2179: update ben_person_actions
2180: set action_status_cd = 'P'
2181: where person_action_id = p_person_action_id;
2182: --
2183: End if;
2219: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
2220: ,p_effective_date => p_effective_date
2221: );
2222: If p_person_action_id is not null then
2223: ben_person_actions_api.update_person_actions
2224: (p_person_action_id => p_person_action_id
2225: ,p_action_status_cd => 'E'
2226: ,p_object_version_number => p_object_version_number
2227: ,p_effective_date => p_effective_date