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_FMT dependencies on BEN_EXTRACT

Line 272: (p_ext_rslt_id => ben_extract.g_ext_rslt_id,

268: else
269: if ben_ext_person.g_business_group_id is not null then
270: l_err_message := get_error_msg(91888,'BEN_91888_EXT_INVALID_DCD',g_elmt_name );
271: ben_ext_util.write_err
272: (p_ext_rslt_id => ben_extract.g_ext_rslt_id,
273: p_err_num => 91888,
274: p_err_name => l_err_message,
275: p_typ_cd => 'W',
276: p_person_id => ben_ext_person.g_person_id,

Line 534: ben_extract.g_business_group_name,

530: IF p_short_name = 'BRLSHP' THEN
531: l_rslt_elmt := ben_ext_person.g_bnf_rlshp;
532: ELSIF p_short_name = 'BSGRP' THEN
533: l_rslt_elmt := decode_setup(p_data_elmt_typ_cd,
534: ben_extract.g_business_group_name,
535: to_char(ben_ext_person.g_business_group_id));
536: --
537: ELSIF p_short_name = 'BSHRFL' THEN
538: l_rslt_elmt := ben_ext_person.g_bnf_shared_resd_flag;

Line 1504: apply_format_mask(ben_extract.g_effective_date,p_frmt_mask_cd);

1500: END IF;
1501: elsif p_two_char_substr = 'EF' then
1502: IF p_short_name = 'EFFDT' THEN
1503: l_rslt_elmt :=
1504: apply_format_mask(ben_extract.g_effective_date,p_frmt_mask_cd);
1505: ELSIF p_short_name = 'EFLX01' THEN
1506: l_rslt_elmt := ben_ext_person.g_elig_flex_01;
1507: ELSIF p_short_name = 'EFLX02' THEN
1508: l_rslt_elmt := ben_ext_person.g_elig_flex_02;

Line 1744: l_rslt_elmt := apply_format_mask(ben_extract.g_ext_end_dt,p_frmt_mask_cd);

1740: l_rslt_elmt := ben_ext_person.g_asg_type;
1741: end if;
1742: elsif p_two_char_substr = 'EN' then
1743: IF p_short_name = 'ENDDT' THEN
1744: l_rslt_elmt := apply_format_mask(ben_extract.g_ext_end_dt,p_frmt_mask_cd);
1745: end if;
1746: elsif p_two_char_substr = 'EO' then
1747: IF p_short_name = 'EOIPFLX01' THEN
1748: l_rslt_elmt := ben_ext_person.g_elig_opt_in_pl_flex_01;

Line 2366: ben_extract.g_proc_business_group_name,

2362: ELSIF p_short_name = 'PBASSAL' then
2363: l_rslt_elmt := apply_format_mask(ben_ext_person.g_base_salary, p_frmt_mask_cd);
2364: ELSIF p_short_name = 'PBSGRP' THEN
2365: l_rslt_elmt := decode_setup(p_data_elmt_typ_cd,
2366: ben_extract.g_proc_business_group_name,
2367: to_char( ben_extract.g_proc_business_group_id));
2368: --
2369:
2370: end if;

Line 2367: to_char( ben_extract.g_proc_business_group_id));

2363: l_rslt_elmt := apply_format_mask(ben_ext_person.g_base_salary, p_frmt_mask_cd);
2364: ELSIF p_short_name = 'PBSGRP' THEN
2365: l_rslt_elmt := decode_setup(p_data_elmt_typ_cd,
2366: ben_extract.g_proc_business_group_name,
2367: to_char( ben_extract.g_proc_business_group_id));
2368: --
2369:
2370: end if;
2371: elsif p_two_char_substr = 'PC' then

Line 3301: l_rslt_elmt := apply_format_mask(ben_extract.g_run_date,

3297: l_rslt_elmt := ben_ext_person.g_enrt_attr_10;
3298: end if;
3299: elsif p_two_char_substr = 'RU' then
3300: IF p_short_name = 'RUNDT' THEN
3301: l_rslt_elmt := apply_format_mask(ben_extract.g_run_date,
3302: p_frmt_mask_cd);
3303: ELSIF p_short_name = 'RUNPPEDT' then
3304: l_rslt_elmt := apply_format_mask(ben_ext_person.g_runrslt_last_pay_date,
3305: p_frmt_mask_cd);

Line 3391: l_rslt_elmt := apply_format_mask(ben_extract.g_ext_strt_dt,

3387: l_rslt_elmt := ben_ext_person.g_sex;
3388: ELSIF p_short_name = 'STDNT' THEN
3389: l_rslt_elmt := ben_ext_person.g_student_status;
3390: ELSIF p_short_name = 'STRTDT' THEN
3391: l_rslt_elmt := apply_format_mask(ben_extract.g_ext_strt_dt,
3392: p_frmt_mask_cd);
3393: end if;
3394: elsif p_one_char_substr = 'T' then
3395: IF p_short_name = 'TITLE' THEN

Line 3873: ,p_request_id => ben_extract.g_request_id

3869: (p_err_num => 92065
3870: ,p_err_name => l_err_message
3871: ,p_typ_cd => 'W'
3872: ,p_person_id => g_person_id
3873: ,p_request_id => ben_extract.g_request_id
3874: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
3875: ,p_business_group_id => ben_ext_person.g_business_group_id
3876: );
3877: --

Line 3874: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id

3870: ,p_err_name => l_err_message
3871: ,p_typ_cd => 'W'
3872: ,p_person_id => g_person_id
3873: ,p_request_id => ben_extract.g_request_id
3874: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
3875: ,p_business_group_id => ben_ext_person.g_business_group_id
3876: );
3877: --
3878:

Line 4198: ben_extract.gtt_rcd_rqd_vals.FIRST .. ben_extract.gtt_rcd_rqd_vals.LAST

4194: /*
4195: -- Check for required record
4196:
4197: FOR i IN
4198: ben_extract.gtt_rcd_rqd_vals.FIRST .. ben_extract.gtt_rcd_rqd_vals.LAST
4199: LOOP
4200: --
4201: IF ben_extract.gtt_rcd_rqd_vals(i).low_lvl_cd = p_low_lvl_cd
4202: OR ben_extract.gtt_rcd_rqd_vals(i).low_lvl_cd = 'NOREQDRCD'

Line 4201: IF ben_extract.gtt_rcd_rqd_vals(i).low_lvl_cd = p_low_lvl_cd

4197: FOR i IN
4198: ben_extract.gtt_rcd_rqd_vals.FIRST .. ben_extract.gtt_rcd_rqd_vals.LAST
4199: LOOP
4200: --
4201: IF ben_extract.gtt_rcd_rqd_vals(i).low_lvl_cd = p_low_lvl_cd
4202: OR ben_extract.gtt_rcd_rqd_vals(i).low_lvl_cd = 'NOREQDRCD'
4203: THEN
4204: ben_extract.gtt_rcd_rqd_vals(i).rcd_found := TRUE;
4205: END IF;

Line 4202: OR ben_extract.gtt_rcd_rqd_vals(i).low_lvl_cd = 'NOREQDRCD'

4198: ben_extract.gtt_rcd_rqd_vals.FIRST .. ben_extract.gtt_rcd_rqd_vals.LAST
4199: LOOP
4200: --
4201: IF ben_extract.gtt_rcd_rqd_vals(i).low_lvl_cd = p_low_lvl_cd
4202: OR ben_extract.gtt_rcd_rqd_vals(i).low_lvl_cd = 'NOREQDRCD'
4203: THEN
4204: ben_extract.gtt_rcd_rqd_vals(i).rcd_found := TRUE;
4205: END IF;
4206: --

Line 4204: ben_extract.gtt_rcd_rqd_vals(i).rcd_found := TRUE;

4200: --
4201: IF ben_extract.gtt_rcd_rqd_vals(i).low_lvl_cd = p_low_lvl_cd
4202: OR ben_extract.gtt_rcd_rqd_vals(i).low_lvl_cd = 'NOREQDRCD'
4203: THEN
4204: ben_extract.gtt_rcd_rqd_vals(i).rcd_found := TRUE;
4205: END IF;
4206: --
4207: END LOOP;
4208: */

Line 4227: --hr_utility.set_location(' format max ' || ben_extract.gtt_rcd_typ_vals.last,99);

4223: -- of a given record type (Detail) and of a given level
4224: -- (Personal, Enrollment, Dependent), if applicable.
4225: --
4226: --
4227: --hr_utility.set_location(' format max ' || ben_extract.gtt_rcd_typ_vals.last,99);
4228:
4229: FOR i IN ben_extract.gtt_rcd_typ_vals.first .. ben_extract.gtt_rcd_typ_vals.last LOOP
4230: --
4231: --

Line 4229: FOR i IN ben_extract.gtt_rcd_typ_vals.first .. ben_extract.gtt_rcd_typ_vals.last LOOP

4225: --
4226: --
4227: --hr_utility.set_location(' format max ' || ben_extract.gtt_rcd_typ_vals.last,99);
4228:
4229: FOR i IN ben_extract.gtt_rcd_typ_vals.first .. ben_extract.gtt_rcd_typ_vals.last LOOP
4230: --
4231: --
4232: --hr_utility.set_location(' low level ' ||ben_extract.gtt_rcd_typ_vals(i).low_lvl_cd,99);
4233: IF ben_extract.gtt_rcd_typ_vals(i).rcd_type_cd = p_rcd_typ_cd

Line 4232: --hr_utility.set_location(' low level ' ||ben_extract.gtt_rcd_typ_vals(i).low_lvl_cd,99);

4228:
4229: FOR i IN ben_extract.gtt_rcd_typ_vals.first .. ben_extract.gtt_rcd_typ_vals.last LOOP
4230: --
4231: --
4232: --hr_utility.set_location(' low level ' ||ben_extract.gtt_rcd_typ_vals(i).low_lvl_cd,99);
4233: IF ben_extract.gtt_rcd_typ_vals(i).rcd_type_cd = p_rcd_typ_cd
4234: AND nvl(ben_extract.gtt_rcd_typ_vals(i).low_lvl_cd,' ') = nvl(p_low_lvl_cd, ' ')
4235: THEN
4236:

Line 4233: IF ben_extract.gtt_rcd_typ_vals(i).rcd_type_cd = p_rcd_typ_cd

4229: FOR i IN ben_extract.gtt_rcd_typ_vals.first .. ben_extract.gtt_rcd_typ_vals.last LOOP
4230: --
4231: --
4232: --hr_utility.set_location(' low level ' ||ben_extract.gtt_rcd_typ_vals(i).low_lvl_cd,99);
4233: IF ben_extract.gtt_rcd_typ_vals(i).rcd_type_cd = p_rcd_typ_cd
4234: AND nvl(ben_extract.gtt_rcd_typ_vals(i).low_lvl_cd,' ') = nvl(p_low_lvl_cd, ' ')
4235: THEN
4236:
4237: l_write_rcd := 'Y';

Line 4234: AND nvl(ben_extract.gtt_rcd_typ_vals(i).low_lvl_cd,' ') = nvl(p_low_lvl_cd, ' ')

4230: --
4231: --
4232: --hr_utility.set_location(' low level ' ||ben_extract.gtt_rcd_typ_vals(i).low_lvl_cd,99);
4233: IF ben_extract.gtt_rcd_typ_vals(i).rcd_type_cd = p_rcd_typ_cd
4234: AND nvl(ben_extract.gtt_rcd_typ_vals(i).low_lvl_cd,' ') = nvl(p_low_lvl_cd, ' ')
4235: THEN
4236:
4237: l_write_rcd := 'Y';
4238: g_rqd_elmt_is_present := 'Y';

Line 4242: l_ext_rcd_id := ben_extract.gtt_rcd_typ_vals(i).ext_rcd_id;

4238: g_rqd_elmt_is_present := 'Y';
4239: --
4240: -- check record include/suppress condition
4241: --
4242: l_ext_rcd_id := ben_extract.gtt_rcd_typ_vals(i).ext_rcd_id;
4243: l_ext_rcd_in_file_id := ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id ;
4244: -- get the rqd flag in record level
4245: -- if the element is rquire and null skip the record
4246: -- if the record is rqd and null skipp the person

Line 4243: l_ext_rcd_in_file_id := ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id ;

4239: --
4240: -- check record include/suppress condition
4241: --
4242: l_ext_rcd_id := ben_extract.gtt_rcd_typ_vals(i).ext_rcd_id;
4243: l_ext_rcd_in_file_id := ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id ;
4244: -- get the rqd flag in record level
4245: -- if the element is rquire and null skip the record
4246: -- if the record is rqd and null skipp the person
4247: open c_rcd_in_file_flag(ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id) ;

Line 4247: open c_rcd_in_file_flag(ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id) ;

4243: l_ext_rcd_in_file_id := ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id ;
4244: -- get the rqd flag in record level
4245: -- if the element is rquire and null skip the record
4246: -- if the record is rqd and null skipp the person
4247: open c_rcd_in_file_flag(ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id) ;
4248: fetch c_rcd_in_file_flag into l_rcd_rqd_flag ,l_chg_rcd_upd_flag ;
4249: close c_rcd_in_file_flag ;
4250: -- Initialize array
4251: --

Line 4559: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,

4555: end if;
4556: --
4557: if l_write_rcd = 'Y' then
4558: ben_ext_adv_conditions.rcd_in_file
4559: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4560: p_sprs_cd => ben_extract.gtt_rcd_typ_vals(i).sprs_cd,
4561: p_exclude_this_rcd_flag => l_exclude_this_rcd_flag);
4562: --
4563: if l_exclude_this_rcd_flag = true then

Line 4560: p_sprs_cd => ben_extract.gtt_rcd_typ_vals(i).sprs_cd,

4556: --
4557: if l_write_rcd = 'Y' then
4558: ben_ext_adv_conditions.rcd_in_file
4559: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4560: p_sprs_cd => ben_extract.gtt_rcd_typ_vals(i).sprs_cd,
4561: p_exclude_this_rcd_flag => l_exclude_this_rcd_flag);
4562: --
4563: if l_exclude_this_rcd_flag = true then
4564: l_write_rcd := 'N';

Line 4571: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,

4567: end if;
4568: --
4569: if l_write_rcd = 'Y' and p_data_typ_cd = 'C' then -- changes only extract
4570: ben_ext_adv_conditions.chg_evt_incl
4571: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4572: p_rcd_seq_num => ben_extract.gtt_rcd_typ_vals(i).seq_num,
4573: p_chg_evt_cd => p_chg_evt_cd,
4574: p_exclude_flag => l_exclude_flag);
4575: --

Line 4572: p_rcd_seq_num => ben_extract.gtt_rcd_typ_vals(i).seq_num,

4568: --
4569: if l_write_rcd = 'Y' and p_data_typ_cd = 'C' then -- changes only extract
4570: ben_ext_adv_conditions.chg_evt_incl
4571: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4572: p_rcd_seq_num => ben_extract.gtt_rcd_typ_vals(i).seq_num,
4573: p_chg_evt_cd => p_chg_evt_cd,
4574: p_exclude_flag => l_exclude_flag);
4575: --
4576: if l_exclude_flag = true then

Line 4587: ben_extract.gtt_rcd_rqd_vals_seq.FIRST .. ben_extract.gtt_rcd_rqd_vals_seq.LAST

4583: -- prevent duplication should not have any effect on
4584: -- required flag validation prevent is valdiated because the record is found
4585:
4586: FOR rci IN
4587: ben_extract.gtt_rcd_rqd_vals_seq.FIRST .. ben_extract.gtt_rcd_rqd_vals_seq.LAST
4588: LOOP
4589: --
4590: IF ( ben_extract.gtt_rcd_rqd_vals_seq(rci).low_lvl_cd = p_low_lvl_cd
4591: and ben_extract.gtt_rcd_rqd_vals_seq(rci).seq_num = ben_extract.gtt_rcd_typ_vals(i).seq_num

Line 4590: IF ( ben_extract.gtt_rcd_rqd_vals_seq(rci).low_lvl_cd = p_low_lvl_cd

4586: FOR rci IN
4587: ben_extract.gtt_rcd_rqd_vals_seq.FIRST .. ben_extract.gtt_rcd_rqd_vals_seq.LAST
4588: LOOP
4589: --
4590: IF ( ben_extract.gtt_rcd_rqd_vals_seq(rci).low_lvl_cd = p_low_lvl_cd
4591: and ben_extract.gtt_rcd_rqd_vals_seq(rci).seq_num = ben_extract.gtt_rcd_typ_vals(i).seq_num
4592: )
4593: OR ben_extract.gtt_rcd_rqd_vals_seq(rci).low_lvl_cd = 'NOREQDRCD'
4594: THEN

Line 4591: and ben_extract.gtt_rcd_rqd_vals_seq(rci).seq_num = ben_extract.gtt_rcd_typ_vals(i).seq_num

4587: ben_extract.gtt_rcd_rqd_vals_seq.FIRST .. ben_extract.gtt_rcd_rqd_vals_seq.LAST
4588: LOOP
4589: --
4590: IF ( ben_extract.gtt_rcd_rqd_vals_seq(rci).low_lvl_cd = p_low_lvl_cd
4591: and ben_extract.gtt_rcd_rqd_vals_seq(rci).seq_num = ben_extract.gtt_rcd_typ_vals(i).seq_num
4592: )
4593: OR ben_extract.gtt_rcd_rqd_vals_seq(rci).low_lvl_cd = 'NOREQDRCD'
4594: THEN
4595: hr_utility.set_location('mandatory found' || p_low_lvl_cd , 99 );

Line 4593: OR ben_extract.gtt_rcd_rqd_vals_seq(rci).low_lvl_cd = 'NOREQDRCD'

4589: --
4590: IF ( ben_extract.gtt_rcd_rqd_vals_seq(rci).low_lvl_cd = p_low_lvl_cd
4591: and ben_extract.gtt_rcd_rqd_vals_seq(rci).seq_num = ben_extract.gtt_rcd_typ_vals(i).seq_num
4592: )
4593: OR ben_extract.gtt_rcd_rqd_vals_seq(rci).low_lvl_cd = 'NOREQDRCD'
4594: THEN
4595: hr_utility.set_location('mandatory found' || p_low_lvl_cd , 99 );
4596: hr_utility.set_location('mandatory found' || ben_extract.gtt_rcd_typ_vals(i).seq_num , 99 );
4597: ben_extract.gtt_rcd_rqd_vals_seq(rci).rcd_found := TRUE;

Line 4596: hr_utility.set_location('mandatory found' || ben_extract.gtt_rcd_typ_vals(i).seq_num , 99 );

4592: )
4593: OR ben_extract.gtt_rcd_rqd_vals_seq(rci).low_lvl_cd = 'NOREQDRCD'
4594: THEN
4595: hr_utility.set_location('mandatory found' || p_low_lvl_cd , 99 );
4596: hr_utility.set_location('mandatory found' || ben_extract.gtt_rcd_typ_vals(i).seq_num , 99 );
4597: ben_extract.gtt_rcd_rqd_vals_seq(rci).rcd_found := TRUE;
4598: END IF;
4599: END LOOP ;
4600:

Line 4597: ben_extract.gtt_rcd_rqd_vals_seq(rci).rcd_found := TRUE;

4593: OR ben_extract.gtt_rcd_rqd_vals_seq(rci).low_lvl_cd = 'NOREQDRCD'
4594: THEN
4595: hr_utility.set_location('mandatory found' || p_low_lvl_cd , 99 );
4596: hr_utility.set_location('mandatory found' || ben_extract.gtt_rcd_typ_vals(i).seq_num , 99 );
4597: ben_extract.gtt_rcd_rqd_vals_seq(rci).rcd_found := TRUE;
4598: END IF;
4599: END LOOP ;
4600:
4601: end if ;

Line 4608: p_any_or_all_cd => ben_extract.gtt_rcd_typ_vals(i).any_or_all_cd,

4604: if l_write_rcd = 'Y' then
4605: ben_ext_adv_conditions.prevent_duplicates
4606: (p_ext_rslt_id => p_ext_rslt_id,
4607: p_person_id => p_person_id,
4608: p_any_or_all_cd => ben_extract.gtt_rcd_typ_vals(i).any_or_all_cd,
4609: p_ext_rcd_id => l_ext_rcd_id,
4610: p_exclude_this_rcd_flag => l_exclude_this_rcd_flag);
4611: --
4612: if l_exclude_this_rcd_flag = true then

Line 4625: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,

4621: --
4622: -- the following sort routine populates the l_..._sort_val fields
4623: --
4624: ben_ext_sort.main
4625: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4626: p_sort1_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort1,
4627: p_sort2_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort2,
4628: p_sort3_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort3,
4629: p_sort4_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort4,

Line 4626: p_sort1_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort1,

4622: -- the following sort routine populates the l_..._sort_val fields
4623: --
4624: ben_ext_sort.main
4625: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4626: p_sort1_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort1,
4627: p_sort2_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort2,
4628: p_sort3_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort3,
4629: p_sort4_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort4,
4630: p_rcd_seq_num => ben_extract.gtt_rcd_typ_vals(i).seq_num,

Line 4627: p_sort2_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort2,

4623: --
4624: ben_ext_sort.main
4625: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4626: p_sort1_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort1,
4627: p_sort2_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort2,
4628: p_sort3_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort3,
4629: p_sort4_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort4,
4630: p_rcd_seq_num => ben_extract.gtt_rcd_typ_vals(i).seq_num,
4631: p_low_lvl_cd => p_low_lvl_cd,

Line 4628: p_sort3_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort3,

4624: ben_ext_sort.main
4625: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4626: p_sort1_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort1,
4627: p_sort2_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort2,
4628: p_sort3_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort3,
4629: p_sort4_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort4,
4630: p_rcd_seq_num => ben_extract.gtt_rcd_typ_vals(i).seq_num,
4631: p_low_lvl_cd => p_low_lvl_cd,
4632: p_prmy_sort_val => l_prmy_sort_val,

Line 4629: p_sort4_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort4,

4625: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4626: p_sort1_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort1,
4627: p_sort2_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort2,
4628: p_sort3_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort3,
4629: p_sort4_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort4,
4630: p_rcd_seq_num => ben_extract.gtt_rcd_typ_vals(i).seq_num,
4631: p_low_lvl_cd => p_low_lvl_cd,
4632: p_prmy_sort_val => l_prmy_sort_val,
4633: p_scnd_sort_val => l_scnd_sort_val,

Line 4630: p_rcd_seq_num => ben_extract.gtt_rcd_typ_vals(i).seq_num,

4626: p_sort1_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort1,
4627: p_sort2_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort2,
4628: p_sort3_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort3,
4629: p_sort4_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort4,
4630: p_rcd_seq_num => ben_extract.gtt_rcd_typ_vals(i).seq_num,
4631: p_low_lvl_cd => p_low_lvl_cd,
4632: p_prmy_sort_val => l_prmy_sort_val,
4633: p_scnd_sort_val => l_scnd_sort_val,
4634: p_thrd_sort_val => l_thrd_sort_val);

Line 5596: ,p_request_id => nvl(ben_extract.g_request_id,fnd_global.conc_request_id)

5592: ,p_group_val_01 => ben_ext_person.g_group_elmt_value1
5593: ,p_group_val_02 => ben_ext_person.g_group_elmt_value2
5594: ,p_program_id => fnd_global.conc_program_id
5595: ,p_program_update_date => sysdate
5596: ,p_request_id => nvl(ben_extract.g_request_id,fnd_global.conc_request_id)
5597: ,p_object_version_number => l_object_version_number
5598: ,p_ext_per_bg_id => l_ext_per_bg_id
5599: ,p_ext_rcd_in_file_id => l_ext_rcd_in_file_id
5600: );

Line 5823: ,p_request_id => ben_extract.g_request_id

5819: (p_err_num => 92065
5820: ,p_err_name => l_err_message
5821: ,p_typ_cd => 'W'
5822: ,p_person_id => g_person_id
5823: ,p_request_id => ben_extract.g_request_id
5824: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5825: ,p_business_group_id => ben_ext_person.g_business_group_id
5826: );
5827: --

Line 5824: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id

5820: ,p_err_name => l_err_message
5821: ,p_typ_cd => 'W'
5822: ,p_person_id => g_person_id
5823: ,p_request_id => ben_extract.g_request_id
5824: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5825: ,p_business_group_id => ben_ext_person.g_business_group_id
5826: );
5827: --
5828: else

Line 5851: ,p_request_id => ben_extract.g_request_id

5847: (p_err_num => 92065
5848: ,p_err_name => l_err_message
5849: ,p_typ_cd => 'W'
5850: ,p_person_id => g_person_id
5851: ,p_request_id => ben_extract.g_request_id
5852: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5853: ,p_business_group_id => ben_ext_person.g_business_group_id
5854: );
5855: --

Line 5852: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id

5848: ,p_err_name => l_err_message
5849: ,p_typ_cd => 'W'
5850: ,p_person_id => g_person_id
5851: ,p_request_id => ben_extract.g_request_id
5852: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5853: ,p_business_group_id => ben_ext_person.g_business_group_id
5854: );
5855: --
5856: end if;

Line 5871: ,p_request_id => ben_extract.g_request_id

5867: (p_err_num => 92065
5868: ,p_err_name =>l_err_message
5869: ,p_typ_cd => 'W'
5870: ,p_person_id => g_person_id
5871: ,p_request_id => ben_extract.g_request_id
5872: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5873: ,p_business_group_id => ben_ext_person.g_business_group_id
5874: );
5875: --

Line 5872: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id

5868: ,p_err_name =>l_err_message
5869: ,p_typ_cd => 'W'
5870: ,p_person_id => g_person_id
5871: ,p_request_id => ben_extract.g_request_id
5872: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5873: ,p_business_group_id => ben_ext_person.g_business_group_id
5874: );
5875: --
5876: else

Line 5893: ,p_request_id => ben_extract.g_request_id

5889: (p_err_num => 92065
5890: ,p_err_name => l_err_message
5891: ,p_typ_cd => 'W'
5892: ,p_person_id => g_person_id
5893: ,p_request_id => ben_extract.g_request_id
5894: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5895: ,p_business_group_id => ben_ext_person.g_business_group_id
5896: );
5897: --

Line 5894: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id

5890: ,p_err_name => l_err_message
5891: ,p_typ_cd => 'W'
5892: ,p_person_id => g_person_id
5893: ,p_request_id => ben_extract.g_request_id
5894: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5895: ,p_business_group_id => ben_ext_person.g_business_group_id
5896: );
5897: --
5898: else

Line 5920: ,p_request_id => ben_extract.g_request_id

5916: (p_err_num => 92065
5917: ,p_err_name => l_err_message
5918: ,p_typ_cd => 'W'
5919: ,p_person_id => g_person_id
5920: ,p_request_id => ben_extract.g_request_id
5921: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5922: ,p_business_group_id => ben_ext_person.g_business_group_id
5923: );
5924: --

Line 5921: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id

5917: ,p_err_name => l_err_message
5918: ,p_typ_cd => 'W'
5919: ,p_person_id => g_person_id
5920: ,p_request_id => ben_extract.g_request_id
5921: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5922: ,p_business_group_id => ben_ext_person.g_business_group_id
5923: );
5924: --
5925: end if;

Line 5944: ,p_request_id => ben_extract.g_request_id

5940: (p_err_num => 92065
5941: ,p_err_name => l_err_message
5942: ,p_typ_cd => 'W'
5943: ,p_person_id => g_person_id
5944: ,p_request_id => ben_extract.g_request_id
5945: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5946: ,p_business_group_id => ben_ext_person.g_business_group_id
5947: );
5948: --

Line 5945: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id

5941: ,p_err_name => l_err_message
5942: ,p_typ_cd => 'W'
5943: ,p_person_id => g_person_id
5944: ,p_request_id => ben_extract.g_request_id
5945: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5946: ,p_business_group_id => ben_ext_person.g_business_group_id
5947: );
5948: --
5949: end if;

Line 5965: ,p_request_id => ben_extract.g_request_id

5961: (p_err_num => 92065
5962: ,p_err_name => l_err_message
5963: ,p_typ_cd => 'W'
5964: ,p_person_id => g_person_id
5965: ,p_request_id => ben_extract.g_request_id
5966: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5967: ,p_business_group_id => ben_ext_person.g_business_group_id
5968: );
5969: --

Line 5966: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id

5962: ,p_err_name => l_err_message
5963: ,p_typ_cd => 'W'
5964: ,p_person_id => g_person_id
5965: ,p_request_id => ben_extract.g_request_id
5966: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5967: ,p_business_group_id => ben_ext_person.g_business_group_id
5968: );
5969: --
5970: end if;

Line 6035: ,p_request_id => ben_extract.g_request_id

6031: (p_err_num => 92065
6032: ,p_err_name => l_err_message
6033: ,p_typ_cd => 'W'
6034: ,p_person_id => g_person_id
6035: ,p_request_id => ben_extract.g_request_id
6036: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
6037: ,p_business_group_id => ben_ext_person.g_business_group_id
6038: );
6039: --

Line 6036: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id

6032: ,p_err_name => l_err_message
6033: ,p_typ_cd => 'W'
6034: ,p_person_id => g_person_id
6035: ,p_request_id => ben_extract.g_request_id
6036: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
6037: ,p_business_group_id => ben_ext_person.g_business_group_id
6038: );
6039: --
6040: end if;