APPS.BEN_BENBATCH_PERSONS dependencies on BEN_PERSON_ACTIONS

Line 919: INSERT INTO ben_person_actions

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

Line 928: ben_person_actions_s.nextval

924: ,benefit_action_id
925: ,action_status_cd
926: ,object_version_number)
927: VALUES(
928: ben_person_actions_s.nextval
929: ,l_person_id_process(l_count)
930: ,p_ler_override_id
931: ,p_benefit_action_id
932: ,'U'

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

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

Line 2059: INSERT INTO ben_person_actions

2055: CLOSE c_person_life;
2056: IF l_person_id_process.COUNT > 0 THEN
2057: -- bulk insert all person action(s)
2058: FORALL l_count IN l_person_id_process.FIRST .. l_person_id_process.LAST
2059: INSERT INTO ben_person_actions
2060: (
2061: person_action_id
2062: ,person_id
2063: ,ler_id

Line 2068: ben_person_actions_s.nextval

2064: ,benefit_action_id
2065: ,action_status_cd
2066: ,object_version_number)
2067: VALUES(
2068: ben_person_actions_s.nextval
2069: ,l_person_id_process(l_count)
2070: ,NULL
2071: ,p_benefit_action_id
2072: ,'U'

Line 2136: FROM ben_person_actions act

2132: ,p_commit_data IN VARCHAR2) IS
2133: --
2134: CURSOR c_person_actions IS
2135: SELECT act.person_action_id, act.person_id, act.benefit_action_id
2136: FROM ben_person_actions act
2137: WHERE act.action_status_cd = 'E'
2138: AND act.benefit_action_id = p_benefit_action_id
2139: FOR UPDATE;
2140: --

Line 2147: FROM ben_person_actions act

2143: FROM ben_batch_ranges brng
2144: WHERE brng.benefit_action_id = p_benefit_action_id
2145: AND brng.range_status_cd <> 'U'
2146: AND EXISTS (SELECT null
2147: FROM ben_person_actions act
2148: WHERE act.person_action_id between brng.starting_person_action_id and brng.ending_person_action_id
2149: AND act.benefit_action_id = brng.benefit_action_id
2150: AND act.action_status_cd <> 'P')
2151: FOR UPDATE;

Line 2176: -- Updating person actions from ben_person_actions table

2172: end loop;
2173: --
2174: p_num_ranges := l_to_chunk_loop;
2175: --
2176: -- Updating person actions from ben_person_actions table
2177: -- Rolling back erred person_actions
2178: --
2179: for r_person_actions in c_person_actions loop
2180: update ben_person_actions

Line 2180: update ben_person_actions

2176: -- Updating person actions from ben_person_actions table
2177: -- Rolling back erred person_actions
2178: --
2179: for r_person_actions in c_person_actions loop
2180: update ben_person_actions
2181: set action_status_cd = 'U'
2182: where person_action_id = r_person_actions.person_action_id;
2183: --
2184: delete from ben_reporting

Line 2191: from ben_person_actions

2187: end loop;
2188: --
2189: select count(*)
2190: into p_num_persons
2191: from ben_person_actions
2192: where benefit_action_id = p_benefit_action_id
2193: and action_status_cd = 'U';
2194: --
2195: if p_commit_data = 'Y' then