APPS.BEN_BENBATCH_PERSONS dependencies on BEN_BATCH_RANGES

Line 961: INSERT INTO ben_batch_ranges

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

Line 970: ben_batch_ranges_s.nextval

966: ,starting_person_action_id
967: ,ending_person_action_id
968: ,object_version_number)
969: VALUES(
970: ben_batch_ranges_s.nextval
971: ,p_benefit_action_id
972: ,'U'
973: ,l_start_person_action_id
974: ,l_end_person_action_id

Line 2097: INSERT INTO ben_batch_ranges

2093: l_end_person_action_id :=
2094: l_person_action_id_table(l_person_action_id_table.COUNT);
2095: END IF;
2096: --
2097: INSERT INTO ben_batch_ranges
2098: (
2099: range_id
2100: ,benefit_action_id
2101: ,range_status_cd

Line 2106: ben_batch_ranges_s.nextval

2102: ,starting_person_action_id
2103: ,ending_person_action_id
2104: ,object_version_number)
2105: VALUES(
2106: ben_batch_ranges_s.nextval
2107: ,p_benefit_action_id
2108: ,'U'
2109: ,l_start_person_action_id
2110: ,l_end_person_action_id

Line 2143: FROM ben_batch_ranges brng

2139: FOR UPDATE;
2140: --
2141: CURSOR c_batch_ranges IS
2142: SELECT brng.range_id
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

Line 2160: -- Updating ranges from ben_batch_ranges table

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

Line 2168: update ben_batch_ranges

2164: set request_id = fnd_global.conc_request_id
2165: where benefit_action_id = p_benefit_action_id;
2166: --
2167: for r_batch_ranges in c_batch_ranges loop
2168: update ben_batch_ranges
2169: set range_status_cd = 'U'
2170: where range_id = r_batch_ranges.range_id;
2171: l_to_chunk_loop:=l_to_chunk_loop+1;
2172: end loop;