eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_ANSI dependencies on BEN_EXT_PERSON

Line 175: ben_ext_person.g_part_type := 'P'; -- Participant (aka Subscriber)

171: --
172: end loop;
173: --
174: if l_include = 'Y' then
175: ben_ext_person.g_part_type := 'P'; -- Participant (aka Subscriber)
176: ben_ext_person.g_per_rlshp_type := '18'; -- 18 is 'Self'
177: ben_ext_person.g_part_ssn :=
178: ben_ext_person.g_national_identifier; --this is the reference ssn
179: ben_ext_person.g_part_first_name :=

Line 176: ben_ext_person.g_per_rlshp_type := '18'; -- 18 is 'Self'

172: end loop;
173: --
174: if l_include = 'Y' then
175: ben_ext_person.g_part_type := 'P'; -- Participant (aka Subscriber)
176: ben_ext_person.g_per_rlshp_type := '18'; -- 18 is 'Self'
177: ben_ext_person.g_part_ssn :=
178: ben_ext_person.g_national_identifier; --this is the reference ssn
179: ben_ext_person.g_part_first_name :=
180: ben_ext_person.g_first_name; --this is the reference first name

Line 177: ben_ext_person.g_part_ssn :=

173: --
174: if l_include = 'Y' then
175: ben_ext_person.g_part_type := 'P'; -- Participant (aka Subscriber)
176: ben_ext_person.g_per_rlshp_type := '18'; -- 18 is 'Self'
177: ben_ext_person.g_part_ssn :=
178: ben_ext_person.g_national_identifier; --this is the reference ssn
179: ben_ext_person.g_part_first_name :=
180: ben_ext_person.g_first_name; --this is the reference first name
181: ben_ext_person.g_part_last_name :=

Line 178: ben_ext_person.g_national_identifier; --this is the reference ssn

174: if l_include = 'Y' then
175: ben_ext_person.g_part_type := 'P'; -- Participant (aka Subscriber)
176: ben_ext_person.g_per_rlshp_type := '18'; -- 18 is 'Self'
177: ben_ext_person.g_part_ssn :=
178: ben_ext_person.g_national_identifier; --this is the reference ssn
179: ben_ext_person.g_part_first_name :=
180: ben_ext_person.g_first_name; --this is the reference first name
181: ben_ext_person.g_part_last_name :=
182: ben_ext_person.g_last_name; --this is the reference last name

Line 179: ben_ext_person.g_part_first_name :=

175: ben_ext_person.g_part_type := 'P'; -- Participant (aka Subscriber)
176: ben_ext_person.g_per_rlshp_type := '18'; -- 18 is 'Self'
177: ben_ext_person.g_part_ssn :=
178: ben_ext_person.g_national_identifier; --this is the reference ssn
179: ben_ext_person.g_part_first_name :=
180: ben_ext_person.g_first_name; --this is the reference first name
181: ben_ext_person.g_part_last_name :=
182: ben_ext_person.g_last_name; --this is the reference last name
183: --

Line 180: ben_ext_person.g_first_name; --this is the reference first name

176: ben_ext_person.g_per_rlshp_type := '18'; -- 18 is 'Self'
177: ben_ext_person.g_part_ssn :=
178: ben_ext_person.g_national_identifier; --this is the reference ssn
179: ben_ext_person.g_part_first_name :=
180: ben_ext_person.g_first_name; --this is the reference first name
181: ben_ext_person.g_part_last_name :=
182: ben_ext_person.g_last_name; --this is the reference last name
183: --
184: if ben_extract.g_per_lvl = 'Y' THEN

Line 181: ben_ext_person.g_part_last_name :=

177: ben_ext_person.g_part_ssn :=
178: ben_ext_person.g_national_identifier; --this is the reference ssn
179: ben_ext_person.g_part_first_name :=
180: ben_ext_person.g_first_name; --this is the reference first name
181: ben_ext_person.g_part_last_name :=
182: ben_ext_person.g_last_name; --this is the reference last name
183: --
184: if ben_extract.g_per_lvl = 'Y' THEN
185: --

Line 182: ben_ext_person.g_last_name; --this is the reference last name

178: ben_ext_person.g_national_identifier; --this is the reference ssn
179: ben_ext_person.g_part_first_name :=
180: ben_ext_person.g_first_name; --this is the reference first name
181: ben_ext_person.g_part_last_name :=
182: ben_ext_person.g_last_name; --this is the reference last name
183: --
184: if ben_extract.g_per_lvl = 'Y' THEN
185: --
186: -- Process Person Level Records

Line 195: p_chg_evt_cd => ben_ext_person.g_chg_evt_cd,

191: p_ext_typ_cd => p_ext_typ_cd,
192: p_rcd_typ_cd => 'D',
193: p_low_lvl_cd => 'P',
194: p_person_id => p_person_id,
195: p_chg_evt_cd => ben_ext_person.g_chg_evt_cd,
196: p_business_group_id => p_business_group_id,
197: p_effective_date => p_effective_date
198: );
199: --

Line 204: IF ben_ext_person.g_part_type = 'P' AND ben_extract.g_enrt_lvl = 'Y' then

200: end if;
201: --
202: -- Process Enrollment Level Records
203: --
204: IF ben_ext_person.g_part_type = 'P' AND ben_extract.g_enrt_lvl = 'Y' then
205: --
206: -- create enrollment extract rows
207: -- =========================================
208: ben_ext_enrt.main(

Line 214: p_chg_evt_cd => ben_ext_person.g_chg_evt_cd,

210: p_ext_rslt_id => p_ext_rslt_id,
211: p_ext_file_id => p_ext_file_id,
212: p_data_typ_cd => p_data_typ_cd,
213: p_ext_typ_cd => p_ext_typ_cd,
214: p_chg_evt_cd => ben_ext_person.g_chg_evt_cd,
215: p_business_group_id => p_business_group_id,
216: p_effective_date => p_effective_date);
217: --
218: end if;

Line 228: -- p_per_in_ler_id => ben_ext_person.g_per_in_ler_id,

224: if ben_extract.g_elig_lvl = 'Y' then
225: --
226: ben_ext_elig.main(
227: p_person_id => p_person_id,
228: -- p_per_in_ler_id => ben_ext_person.g_per_in_ler_id,
229: p_ext_rslt_id => p_ext_rslt_id,
230: p_ext_file_id => p_ext_file_id,
231: p_data_typ_cd => p_data_typ_cd,
232: p_ext_typ_cd => p_ext_typ_cd,

Line 233: p_chg_evt_cd => ben_ext_person.g_chg_evt_cd,

229: p_ext_rslt_id => p_ext_rslt_id,
230: p_ext_file_id => p_ext_file_id,
231: p_data_typ_cd => p_data_typ_cd,
232: p_ext_typ_cd => p_ext_typ_cd,
233: p_chg_evt_cd => ben_ext_person.g_chg_evt_cd,
234: p_business_group_id => p_business_group_id,
235: p_effective_date => p_effective_date
236: );
237: --

Line 245: ben_ext_person.g_part_type := 'D'; -- Dependent

241: --
242: -- remember a person can be both a subsciber of one plan and a dependent of another!
243: --
244: hr_utility.set_location (' try as dpnt ' , 99 ) ;
245: ben_ext_person.g_part_type := 'D'; -- Dependent
246: -- remember a person can be a dpnt for two diff subscribers.
247: for i in c_dpnt_of_distinct_participant loop
248: --
249: hr_utility.set_location (' dpnt loop ' , 99 ) ;

Line 289: fetch c_get_contact_info into ben_ext_person.g_per_rlshp_type,

285: --
286: if l_include = 'Y' then
287: --
288: open c_get_contact_info(i.person_id, p_person_id, p_effective_date);
289: fetch c_get_contact_info into ben_ext_person.g_per_rlshp_type,
290: ben_ext_person.g_part_ssn,
291: ben_ext_person.g_part_first_name,
292: ben_ext_person.g_part_last_name,
293: ben_ext_person.g_dpnt_contact_seq_num;

Line 290: ben_ext_person.g_part_ssn,

286: if l_include = 'Y' then
287: --
288: open c_get_contact_info(i.person_id, p_person_id, p_effective_date);
289: fetch c_get_contact_info into ben_ext_person.g_per_rlshp_type,
290: ben_ext_person.g_part_ssn,
291: ben_ext_person.g_part_first_name,
292: ben_ext_person.g_part_last_name,
293: ben_ext_person.g_dpnt_contact_seq_num;
294:

Line 291: ben_ext_person.g_part_first_name,

287: --
288: open c_get_contact_info(i.person_id, p_person_id, p_effective_date);
289: fetch c_get_contact_info into ben_ext_person.g_per_rlshp_type,
290: ben_ext_person.g_part_ssn,
291: ben_ext_person.g_part_first_name,
292: ben_ext_person.g_part_last_name,
293: ben_ext_person.g_dpnt_contact_seq_num;
294:
295: --- 5264053 if the contact relationship end dated then

Line 292: ben_ext_person.g_part_last_name,

288: open c_get_contact_info(i.person_id, p_person_id, p_effective_date);
289: fetch c_get_contact_info into ben_ext_person.g_per_rlshp_type,
290: ben_ext_person.g_part_ssn,
291: ben_ext_person.g_part_first_name,
292: ben_ext_person.g_part_last_name,
293: ben_ext_person.g_dpnt_contact_seq_num;
294:
295: --- 5264053 if the contact relationship end dated then
296: --- get the contact latest information

Line 293: ben_ext_person.g_dpnt_contact_seq_num;

289: fetch c_get_contact_info into ben_ext_person.g_per_rlshp_type,
290: ben_ext_person.g_part_ssn,
291: ben_ext_person.g_part_first_name,
292: ben_ext_person.g_part_last_name,
293: ben_ext_person.g_dpnt_contact_seq_num;
294:
295: --- 5264053 if the contact relationship end dated then
296: --- get the contact latest information
297: if c_get_contact_info%notfound then

Line 300: fetch c_get_contact_info2 into ben_ext_person.g_per_rlshp_type,

296: --- get the contact latest information
297: if c_get_contact_info%notfound then
298: --if l_dpnt_cvg_thru_dt is not null and l_dpnt_cvg_thru_dt <> hr_api.g_eot then
299: open c_get_contact_info2(i.person_id, p_person_id,p_effective_date);
300: fetch c_get_contact_info2 into ben_ext_person.g_per_rlshp_type,
301: ben_ext_person.g_part_ssn,
302: ben_ext_person.g_part_first_name,
303: ben_ext_person.g_part_last_name,
304: ben_ext_person.g_dpnt_contact_seq_num;

Line 301: ben_ext_person.g_part_ssn,

297: if c_get_contact_info%notfound then
298: --if l_dpnt_cvg_thru_dt is not null and l_dpnt_cvg_thru_dt <> hr_api.g_eot then
299: open c_get_contact_info2(i.person_id, p_person_id,p_effective_date);
300: fetch c_get_contact_info2 into ben_ext_person.g_per_rlshp_type,
301: ben_ext_person.g_part_ssn,
302: ben_ext_person.g_part_first_name,
303: ben_ext_person.g_part_last_name,
304: ben_ext_person.g_dpnt_contact_seq_num;
305: close c_get_contact_info2;

Line 302: ben_ext_person.g_part_first_name,

298: --if l_dpnt_cvg_thru_dt is not null and l_dpnt_cvg_thru_dt <> hr_api.g_eot then
299: open c_get_contact_info2(i.person_id, p_person_id,p_effective_date);
300: fetch c_get_contact_info2 into ben_ext_person.g_per_rlshp_type,
301: ben_ext_person.g_part_ssn,
302: ben_ext_person.g_part_first_name,
303: ben_ext_person.g_part_last_name,
304: ben_ext_person.g_dpnt_contact_seq_num;
305: close c_get_contact_info2;
306: --end if ;

Line 303: ben_ext_person.g_part_last_name,

299: open c_get_contact_info2(i.person_id, p_person_id,p_effective_date);
300: fetch c_get_contact_info2 into ben_ext_person.g_per_rlshp_type,
301: ben_ext_person.g_part_ssn,
302: ben_ext_person.g_part_first_name,
303: ben_ext_person.g_part_last_name,
304: ben_ext_person.g_dpnt_contact_seq_num;
305: close c_get_contact_info2;
306: --end if ;
307: end if ;

Line 304: ben_ext_person.g_dpnt_contact_seq_num;

300: fetch c_get_contact_info2 into ben_ext_person.g_per_rlshp_type,
301: ben_ext_person.g_part_ssn,
302: ben_ext_person.g_part_first_name,
303: ben_ext_person.g_part_last_name,
304: ben_ext_person.g_dpnt_contact_seq_num;
305: close c_get_contact_info2;
306: --end if ;
307: end if ;
308:

Line 323: p_chg_evt_cd => ben_ext_person.g_chg_evt_cd,

319: p_ext_typ_cd => p_ext_typ_cd,
320: p_rcd_typ_cd => 'D',
321: p_low_lvl_cd => 'P',
322: p_person_id => p_person_id,
323: p_chg_evt_cd => ben_ext_person.g_chg_evt_cd,
324: p_business_group_id => p_business_group_id,
325: p_effective_date => p_effective_date
326: );
327: --

Line 332: if ben_ext_person.g_part_type = 'D' and ben_extract.g_enrt_lvl = 'Y' then

328: end if;
329: --
330: -- Process Enrollment Level Records
331: --
332: if ben_ext_person.g_part_type = 'D' and ben_extract.g_enrt_lvl = 'Y' then
333: --
334: ben_ext_enrt_spcl.main(
335: p_dpnt_person_id => p_person_id,
336: p_prtt_person_id => i.person_id,

Line 341: p_chg_evt_cd => ben_ext_person.g_chg_evt_cd,

337: p_ext_rslt_id => p_ext_rslt_id,
338: p_ext_file_id => p_ext_file_id,
339: p_data_typ_cd => p_data_typ_cd,
340: p_ext_typ_cd => p_ext_typ_cd,
341: p_chg_evt_cd => ben_ext_person.g_chg_evt_cd,
342: p_business_group_id => p_business_group_id,
343: p_effective_date => p_effective_date
344: );
345: --

Line 370: raise ben_ext_person.required_error ;

366: --
367:
368: if l_rollback then
369: hr_utility.set_location(' record not found ' || l_proc, 15) ;
370: raise ben_ext_person.required_error ;
371: end if ;
372:
373: --
374: hr_utility.set_location('Exiting'||l_proc, 15);