APPS.BEN_BENBATCH_PERSONS dependencies on BEN_BATCH_RANGES

Line 964: INSERT INTO ben_batch_ranges

960: l_end_person_action_id :=
961: l_person_action_id_table(l_person_action_id_table.COUNT);
962: END IF;
963: --
964: INSERT INTO ben_batch_ranges
965: (
966: range_id
967: ,benefit_action_id
968: ,range_status_cd

Line 973: ben_batch_ranges_s.nextval

969: ,starting_person_action_id
970: ,ending_person_action_id
971: ,object_version_number)
972: VALUES(
973: ben_batch_ranges_s.nextval
974: ,p_benefit_action_id
975: ,'U'
976: ,l_start_person_action_id
977: ,l_end_person_action_id

Line 2102: INSERT INTO ben_batch_ranges

2098: l_end_person_action_id :=
2099: l_person_action_id_table(l_person_action_id_table.COUNT);
2100: END IF;
2101: --
2102: INSERT INTO ben_batch_ranges
2103: (
2104: range_id
2105: ,benefit_action_id
2106: ,range_status_cd

Line 2111: ben_batch_ranges_s.nextval

2107: ,starting_person_action_id
2108: ,ending_person_action_id
2109: ,object_version_number)
2110: VALUES(
2111: ben_batch_ranges_s.nextval
2112: ,p_benefit_action_id
2113: ,'U'
2114: ,l_start_person_action_id
2115: ,l_end_person_action_id

Line 2148: FROM ben_batch_ranges brng

2144: FOR UPDATE;
2145: --
2146: CURSOR c_batch_ranges IS
2147: SELECT brng.range_id
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

Line 2165: -- Updating ranges from ben_batch_ranges table

2161: BEGIN
2162: --
2163: -- hr_utility.set_location('Entering '||l_package,10);
2164: --
2165: -- Updating ranges from ben_batch_ranges table
2166: -- Rolling back ranges with erred or partially unfinished person actions
2167: --
2168: update ben_benefit_actions
2169: set request_id = fnd_global.conc_request_id

Line 2173: update ben_batch_ranges

2169: set request_id = fnd_global.conc_request_id
2170: where benefit_action_id = p_benefit_action_id;
2171: --
2172: for r_batch_ranges in c_batch_ranges loop
2173: update ben_batch_ranges
2174: set range_status_cd = 'U'
2175: where range_id = r_batch_ranges.range_id;
2176: l_to_chunk_loop:=l_to_chunk_loop+1;
2177: end loop;