APPS.BEN_BENBATCH_PERSONS dependencies on BEN_PERSON_ACTIONS

Line 922: INSERT INTO ben_person_actions

918: IF l_person_id_process.COUNT > 0 THEN
919: -- bulk insert all person action(s)
920: FORALL l_count IN l_person_id_process.FIRST .. l_person_id_process.LAST
921: --
922: INSERT INTO ben_person_actions
923: (
924: person_action_id
925: ,person_id
926: ,ler_id

Line 931: ben_person_actions_s.nextval

927: ,benefit_action_id
928: ,action_status_cd
929: ,object_version_number)
930: VALUES(
931: ben_person_actions_s.nextval
932: ,l_person_id_process(l_count)
933: ,p_ler_override_id
934: ,p_benefit_action_id
935: ,'U'

Line 939: -- 99999 Delete the duplicates from the ben_person_actions

935: ,'U'
936: ,1)
937: RETURNING person_action_id BULK COLLECT INTO l_person_action_id_table;
938: --
939: -- 99999 Delete the duplicates from the ben_person_actions
940: -- here.
941:
942:
943: IF MOD(l_person_action_id_table.COUNT

Line 2064: INSERT INTO ben_person_actions

2060: CLOSE c_person_life;
2061: IF l_person_id_process.COUNT > 0 THEN
2062: -- bulk insert all person action(s)
2063: FORALL l_count IN l_person_id_process.FIRST .. l_person_id_process.LAST
2064: INSERT INTO ben_person_actions
2065: (
2066: person_action_id
2067: ,person_id
2068: ,ler_id

Line 2073: ben_person_actions_s.nextval

2069: ,benefit_action_id
2070: ,action_status_cd
2071: ,object_version_number)
2072: VALUES(
2073: ben_person_actions_s.nextval
2074: ,l_person_id_process(l_count)
2075: ,NULL
2076: ,p_benefit_action_id
2077: ,'U'

Line 2141: FROM ben_person_actions act

2137: ,p_commit_data IN VARCHAR2) IS
2138: --
2139: CURSOR c_person_actions IS
2140: SELECT act.person_action_id, act.person_id, act.benefit_action_id
2141: FROM ben_person_actions act
2142: WHERE act.action_status_cd = 'E'
2143: AND act.benefit_action_id = p_benefit_action_id
2144: FOR UPDATE;
2145: --

Line 2152: FROM ben_person_actions act

2148: FROM ben_batch_ranges brng
2149: WHERE brng.benefit_action_id = p_benefit_action_id
2150: AND brng.range_status_cd <> 'U'
2151: AND EXISTS (SELECT null
2152: FROM ben_person_actions act
2153: WHERE act.person_action_id between brng.starting_person_action_id and brng.ending_person_action_id
2154: AND act.benefit_action_id = brng.benefit_action_id
2155: AND act.action_status_cd <> 'P')
2156: FOR UPDATE;

Line 2181: -- Updating person actions from ben_person_actions table

2177: end loop;
2178: --
2179: p_num_ranges := l_to_chunk_loop;
2180: --
2181: -- Updating person actions from ben_person_actions table
2182: -- Rolling back erred person_actions
2183: --
2184: for r_person_actions in c_person_actions loop
2185: update ben_person_actions

Line 2185: update ben_person_actions

2181: -- Updating person actions from ben_person_actions table
2182: -- Rolling back erred person_actions
2183: --
2184: for r_person_actions in c_person_actions loop
2185: update ben_person_actions
2186: set action_status_cd = 'U'
2187: where person_action_id = r_person_actions.person_action_id;
2188: --
2189: delete from ben_reporting

Line 2196: from ben_person_actions

2192: end loop;
2193: --
2194: select count(*)
2195: into p_num_persons
2196: from ben_person_actions
2197: where benefit_action_id = p_benefit_action_id
2198: and action_status_cd = 'U';
2199: --
2200: if p_commit_data = 'Y' then