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 273: (p_ext_rslt_id => ben_extract.g_ext_rslt_id,

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

Line 535: ben_extract.g_business_group_name,

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

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

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

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

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

Line 2369: ben_extract.g_proc_business_group_name,

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

Line 2370: to_char( ben_extract.g_proc_business_group_id));

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

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

3303: l_rslt_elmt := ben_ext_person.g_enrt_attr_10;
3304: end if;
3305: elsif p_two_char_substr = 'RU' then
3306: IF p_short_name = 'RUNDT' THEN
3307: l_rslt_elmt := apply_format_mask(ben_extract.g_run_date,
3308: p_frmt_mask_cd);
3309: ELSIF p_short_name = 'RUNPPEDT' then
3310: l_rslt_elmt := apply_format_mask(ben_ext_person.g_runrslt_last_pay_date,
3311: p_frmt_mask_cd);

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

3393: l_rslt_elmt := ben_ext_person.g_sex;
3394: ELSIF p_short_name = 'STDNT' THEN
3395: l_rslt_elmt := ben_ext_person.g_student_status;
3396: ELSIF p_short_name = 'STRTDT' THEN
3397: l_rslt_elmt := apply_format_mask(ben_extract.g_ext_strt_dt,
3398: p_frmt_mask_cd);
3399: end if;
3400: elsif p_one_char_substr = 'T' then
3401: IF p_short_name = 'TITLE' THEN

Line 3879: ,p_request_id => ben_extract.g_request_id

3875: (p_err_num => 92065
3876: ,p_err_name => l_err_message
3877: ,p_typ_cd => 'W'
3878: ,p_person_id => g_person_id
3879: ,p_request_id => ben_extract.g_request_id
3880: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
3881: ,p_business_group_id => ben_ext_person.g_business_group_id
3882: );
3883: --

Line 3880: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id

3876: ,p_err_name => l_err_message
3877: ,p_typ_cd => 'W'
3878: ,p_person_id => g_person_id
3879: ,p_request_id => ben_extract.g_request_id
3880: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
3881: ,p_business_group_id => ben_ext_person.g_business_group_id
3882: );
3883: --
3884:

Line 4204: ben_extract.gtt_rcd_rqd_vals.FIRST .. ben_extract.gtt_rcd_rqd_vals.LAST

4200: /*
4201: -- Check for required record
4202:
4203: FOR i IN
4204: ben_extract.gtt_rcd_rqd_vals.FIRST .. ben_extract.gtt_rcd_rqd_vals.LAST
4205: LOOP
4206: --
4207: IF ben_extract.gtt_rcd_rqd_vals(i).low_lvl_cd = p_low_lvl_cd
4208: OR ben_extract.gtt_rcd_rqd_vals(i).low_lvl_cd = 'NOREQDRCD'

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

4203: FOR i IN
4204: ben_extract.gtt_rcd_rqd_vals.FIRST .. ben_extract.gtt_rcd_rqd_vals.LAST
4205: LOOP
4206: --
4207: IF ben_extract.gtt_rcd_rqd_vals(i).low_lvl_cd = p_low_lvl_cd
4208: OR ben_extract.gtt_rcd_rqd_vals(i).low_lvl_cd = 'NOREQDRCD'
4209: THEN
4210: ben_extract.gtt_rcd_rqd_vals(i).rcd_found := TRUE;
4211: END IF;

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

4204: ben_extract.gtt_rcd_rqd_vals.FIRST .. ben_extract.gtt_rcd_rqd_vals.LAST
4205: LOOP
4206: --
4207: IF ben_extract.gtt_rcd_rqd_vals(i).low_lvl_cd = p_low_lvl_cd
4208: OR ben_extract.gtt_rcd_rqd_vals(i).low_lvl_cd = 'NOREQDRCD'
4209: THEN
4210: ben_extract.gtt_rcd_rqd_vals(i).rcd_found := TRUE;
4211: END IF;
4212: --

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

4206: --
4207: IF ben_extract.gtt_rcd_rqd_vals(i).low_lvl_cd = p_low_lvl_cd
4208: OR ben_extract.gtt_rcd_rqd_vals(i).low_lvl_cd = 'NOREQDRCD'
4209: THEN
4210: ben_extract.gtt_rcd_rqd_vals(i).rcd_found := TRUE;
4211: END IF;
4212: --
4213: END LOOP;
4214: */

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

4229: -- of a given record type (Detail) and of a given level
4230: -- (Personal, Enrollment, Dependent), if applicable.
4231: --
4232: --
4233: --hr_utility.set_location(' format max ' || ben_extract.gtt_rcd_typ_vals.last,99);
4234:
4235: FOR i IN ben_extract.gtt_rcd_typ_vals.first .. ben_extract.gtt_rcd_typ_vals.last LOOP
4236: --
4237: --

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

4231: --
4232: --
4233: --hr_utility.set_location(' format max ' || ben_extract.gtt_rcd_typ_vals.last,99);
4234:
4235: FOR i IN ben_extract.gtt_rcd_typ_vals.first .. ben_extract.gtt_rcd_typ_vals.last LOOP
4236: --
4237: --
4238: --hr_utility.set_location(' low level ' ||ben_extract.gtt_rcd_typ_vals(i).low_lvl_cd,99);
4239: IF ben_extract.gtt_rcd_typ_vals(i).rcd_type_cd = p_rcd_typ_cd

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

4234:
4235: FOR i IN ben_extract.gtt_rcd_typ_vals.first .. ben_extract.gtt_rcd_typ_vals.last LOOP
4236: --
4237: --
4238: --hr_utility.set_location(' low level ' ||ben_extract.gtt_rcd_typ_vals(i).low_lvl_cd,99);
4239: IF ben_extract.gtt_rcd_typ_vals(i).rcd_type_cd = p_rcd_typ_cd
4240: AND nvl(ben_extract.gtt_rcd_typ_vals(i).low_lvl_cd,' ') = nvl(p_low_lvl_cd, ' ')
4241: THEN
4242:

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

4235: FOR i IN ben_extract.gtt_rcd_typ_vals.first .. ben_extract.gtt_rcd_typ_vals.last LOOP
4236: --
4237: --
4238: --hr_utility.set_location(' low level ' ||ben_extract.gtt_rcd_typ_vals(i).low_lvl_cd,99);
4239: IF ben_extract.gtt_rcd_typ_vals(i).rcd_type_cd = p_rcd_typ_cd
4240: AND nvl(ben_extract.gtt_rcd_typ_vals(i).low_lvl_cd,' ') = nvl(p_low_lvl_cd, ' ')
4241: THEN
4242:
4243: l_write_rcd := 'Y';

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

4236: --
4237: --
4238: --hr_utility.set_location(' low level ' ||ben_extract.gtt_rcd_typ_vals(i).low_lvl_cd,99);
4239: IF ben_extract.gtt_rcd_typ_vals(i).rcd_type_cd = p_rcd_typ_cd
4240: AND nvl(ben_extract.gtt_rcd_typ_vals(i).low_lvl_cd,' ') = nvl(p_low_lvl_cd, ' ')
4241: THEN
4242:
4243: l_write_rcd := 'Y';
4244: g_rqd_elmt_is_present := 'Y';

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

4244: g_rqd_elmt_is_present := 'Y';
4245: --
4246: -- check record include/suppress condition
4247: --
4248: l_ext_rcd_id := ben_extract.gtt_rcd_typ_vals(i).ext_rcd_id;
4249: l_ext_rcd_in_file_id := ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id ;
4250: -- get the rqd flag in record level
4251: -- if the element is rquire and null skip the record
4252: -- if the record is rqd and null skipp the person

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

4245: --
4246: -- check record include/suppress condition
4247: --
4248: l_ext_rcd_id := ben_extract.gtt_rcd_typ_vals(i).ext_rcd_id;
4249: l_ext_rcd_in_file_id := ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id ;
4250: -- get the rqd flag in record level
4251: -- if the element is rquire and null skip the record
4252: -- if the record is rqd and null skipp the person
4253: open c_rcd_in_file_flag(ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id) ;

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

4249: l_ext_rcd_in_file_id := ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id ;
4250: -- get the rqd flag in record level
4251: -- if the element is rquire and null skip the record
4252: -- if the record is rqd and null skipp the person
4253: open c_rcd_in_file_flag(ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id) ;
4254: fetch c_rcd_in_file_flag into l_rcd_rqd_flag ,l_chg_rcd_upd_flag ;
4255: close c_rcd_in_file_flag ;
4256: -- Initialize array
4257: --

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

4561: end if;
4562: --
4563: if l_write_rcd = 'Y' then
4564: ben_ext_adv_conditions.rcd_in_file
4565: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4566: p_sprs_cd => ben_extract.gtt_rcd_typ_vals(i).sprs_cd,
4567: p_exclude_this_rcd_flag => l_exclude_this_rcd_flag);
4568: --
4569: if l_exclude_this_rcd_flag = true then

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

4562: --
4563: if l_write_rcd = 'Y' then
4564: ben_ext_adv_conditions.rcd_in_file
4565: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4566: p_sprs_cd => ben_extract.gtt_rcd_typ_vals(i).sprs_cd,
4567: p_exclude_this_rcd_flag => l_exclude_this_rcd_flag);
4568: --
4569: if l_exclude_this_rcd_flag = true then
4570: l_write_rcd := 'N';

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

4573: end if;
4574: --
4575: if l_write_rcd = 'Y' and p_data_typ_cd = 'C' then -- changes only extract
4576: ben_ext_adv_conditions.chg_evt_incl
4577: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4578: p_rcd_seq_num => ben_extract.gtt_rcd_typ_vals(i).seq_num,
4579: p_chg_evt_cd => p_chg_evt_cd,
4580: p_exclude_flag => l_exclude_flag);
4581: --

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

4574: --
4575: if l_write_rcd = 'Y' and p_data_typ_cd = 'C' then -- changes only extract
4576: ben_ext_adv_conditions.chg_evt_incl
4577: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4578: p_rcd_seq_num => ben_extract.gtt_rcd_typ_vals(i).seq_num,
4579: p_chg_evt_cd => p_chg_evt_cd,
4580: p_exclude_flag => l_exclude_flag);
4581: --
4582: if l_exclude_flag = true then

Line 4593: ben_extract.gtt_rcd_rqd_vals_seq.FIRST .. ben_extract.gtt_rcd_rqd_vals_seq.LAST

4589: -- prevent duplication should not have any effect on
4590: -- required flag validation prevent is valdiated because the record is found
4591:
4592: FOR rci IN
4593: ben_extract.gtt_rcd_rqd_vals_seq.FIRST .. ben_extract.gtt_rcd_rqd_vals_seq.LAST
4594: LOOP
4595: --
4596: IF ( ben_extract.gtt_rcd_rqd_vals_seq(rci).low_lvl_cd = p_low_lvl_cd
4597: and ben_extract.gtt_rcd_rqd_vals_seq(rci).seq_num = ben_extract.gtt_rcd_typ_vals(i).seq_num

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

4592: FOR rci IN
4593: ben_extract.gtt_rcd_rqd_vals_seq.FIRST .. ben_extract.gtt_rcd_rqd_vals_seq.LAST
4594: LOOP
4595: --
4596: IF ( ben_extract.gtt_rcd_rqd_vals_seq(rci).low_lvl_cd = p_low_lvl_cd
4597: and ben_extract.gtt_rcd_rqd_vals_seq(rci).seq_num = ben_extract.gtt_rcd_typ_vals(i).seq_num
4598: )
4599: OR ben_extract.gtt_rcd_rqd_vals_seq(rci).low_lvl_cd = 'NOREQDRCD'
4600: THEN

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

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

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

4595: --
4596: IF ( ben_extract.gtt_rcd_rqd_vals_seq(rci).low_lvl_cd = p_low_lvl_cd
4597: and ben_extract.gtt_rcd_rqd_vals_seq(rci).seq_num = ben_extract.gtt_rcd_typ_vals(i).seq_num
4598: )
4599: OR ben_extract.gtt_rcd_rqd_vals_seq(rci).low_lvl_cd = 'NOREQDRCD'
4600: THEN
4601: hr_utility.set_location('mandatory found' || p_low_lvl_cd , 99 );
4602: hr_utility.set_location('mandatory found' || ben_extract.gtt_rcd_typ_vals(i).seq_num , 99 );
4603: ben_extract.gtt_rcd_rqd_vals_seq(rci).rcd_found := TRUE;

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

4598: )
4599: OR ben_extract.gtt_rcd_rqd_vals_seq(rci).low_lvl_cd = 'NOREQDRCD'
4600: THEN
4601: hr_utility.set_location('mandatory found' || p_low_lvl_cd , 99 );
4602: hr_utility.set_location('mandatory found' || ben_extract.gtt_rcd_typ_vals(i).seq_num , 99 );
4603: ben_extract.gtt_rcd_rqd_vals_seq(rci).rcd_found := TRUE;
4604: END IF;
4605: END LOOP ;
4606:

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

4599: OR ben_extract.gtt_rcd_rqd_vals_seq(rci).low_lvl_cd = 'NOREQDRCD'
4600: THEN
4601: hr_utility.set_location('mandatory found' || p_low_lvl_cd , 99 );
4602: hr_utility.set_location('mandatory found' || ben_extract.gtt_rcd_typ_vals(i).seq_num , 99 );
4603: ben_extract.gtt_rcd_rqd_vals_seq(rci).rcd_found := TRUE;
4604: END IF;
4605: END LOOP ;
4606:
4607: end if ;

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

4610: if l_write_rcd = 'Y' then
4611: ben_ext_adv_conditions.prevent_duplicates
4612: (p_ext_rslt_id => p_ext_rslt_id,
4613: p_person_id => p_person_id,
4614: p_any_or_all_cd => ben_extract.gtt_rcd_typ_vals(i).any_or_all_cd,
4615: p_ext_rcd_id => l_ext_rcd_id,
4616: p_exclude_this_rcd_flag => l_exclude_this_rcd_flag);
4617: --
4618: if l_exclude_this_rcd_flag = true then

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

4627: --
4628: -- the following sort routine populates the l_..._sort_val fields
4629: --
4630: ben_ext_sort.main
4631: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4632: p_sort1_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort1,
4633: p_sort2_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort2,
4634: p_sort3_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort3,
4635: p_sort4_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort4,

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

4628: -- the following sort routine populates the l_..._sort_val fields
4629: --
4630: ben_ext_sort.main
4631: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4632: p_sort1_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort1,
4633: p_sort2_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort2,
4634: p_sort3_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort3,
4635: p_sort4_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort4,
4636: p_rcd_seq_num => ben_extract.gtt_rcd_typ_vals(i).seq_num,

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

4629: --
4630: ben_ext_sort.main
4631: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4632: p_sort1_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort1,
4633: p_sort2_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort2,
4634: p_sort3_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort3,
4635: p_sort4_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort4,
4636: p_rcd_seq_num => ben_extract.gtt_rcd_typ_vals(i).seq_num,
4637: p_low_lvl_cd => p_low_lvl_cd,

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

4630: ben_ext_sort.main
4631: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4632: p_sort1_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort1,
4633: p_sort2_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort2,
4634: p_sort3_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort3,
4635: p_sort4_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort4,
4636: p_rcd_seq_num => ben_extract.gtt_rcd_typ_vals(i).seq_num,
4637: p_low_lvl_cd => p_low_lvl_cd,
4638: p_prmy_sort_val => l_prmy_sort_val,

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

4631: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4632: p_sort1_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort1,
4633: p_sort2_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort2,
4634: p_sort3_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort3,
4635: p_sort4_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort4,
4636: p_rcd_seq_num => ben_extract.gtt_rcd_typ_vals(i).seq_num,
4637: p_low_lvl_cd => p_low_lvl_cd,
4638: p_prmy_sort_val => l_prmy_sort_val,
4639: p_scnd_sort_val => l_scnd_sort_val,

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

4632: p_sort1_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort1,
4633: p_sort2_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort2,
4634: p_sort3_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort3,
4635: p_sort4_data_elmt_in_rcd_id => ben_extract.gtt_rcd_typ_vals(i).sort4,
4636: p_rcd_seq_num => ben_extract.gtt_rcd_typ_vals(i).seq_num,
4637: p_low_lvl_cd => p_low_lvl_cd,
4638: p_prmy_sort_val => l_prmy_sort_val,
4639: p_scnd_sort_val => l_scnd_sort_val,
4640: p_thrd_sort_val => l_thrd_sort_val);

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

5598: ,p_group_val_01 => ben_ext_person.g_group_elmt_value1
5599: ,p_group_val_02 => ben_ext_person.g_group_elmt_value2
5600: ,p_program_id => fnd_global.conc_program_id
5601: ,p_program_update_date => sysdate
5602: ,p_request_id => nvl(ben_extract.g_request_id,fnd_global.conc_request_id)
5603: ,p_object_version_number => l_object_version_number
5604: ,p_ext_per_bg_id => l_ext_per_bg_id
5605: ,p_ext_rcd_in_file_id => l_ext_rcd_in_file_id
5606: );

Line 5829: ,p_request_id => ben_extract.g_request_id

5825: (p_err_num => 92065
5826: ,p_err_name => l_err_message
5827: ,p_typ_cd => 'W'
5828: ,p_person_id => g_person_id
5829: ,p_request_id => ben_extract.g_request_id
5830: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5831: ,p_business_group_id => ben_ext_person.g_business_group_id
5832: );
5833: --

Line 5830: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id

5826: ,p_err_name => l_err_message
5827: ,p_typ_cd => 'W'
5828: ,p_person_id => g_person_id
5829: ,p_request_id => ben_extract.g_request_id
5830: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5831: ,p_business_group_id => ben_ext_person.g_business_group_id
5832: );
5833: --
5834: else

Line 5857: ,p_request_id => ben_extract.g_request_id

5853: (p_err_num => 92065
5854: ,p_err_name => l_err_message
5855: ,p_typ_cd => 'W'
5856: ,p_person_id => g_person_id
5857: ,p_request_id => ben_extract.g_request_id
5858: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5859: ,p_business_group_id => ben_ext_person.g_business_group_id
5860: );
5861: --

Line 5858: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id

5854: ,p_err_name => l_err_message
5855: ,p_typ_cd => 'W'
5856: ,p_person_id => g_person_id
5857: ,p_request_id => ben_extract.g_request_id
5858: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5859: ,p_business_group_id => ben_ext_person.g_business_group_id
5860: );
5861: --
5862: end if;

Line 5877: ,p_request_id => ben_extract.g_request_id

5873: (p_err_num => 92065
5874: ,p_err_name =>l_err_message
5875: ,p_typ_cd => 'W'
5876: ,p_person_id => g_person_id
5877: ,p_request_id => ben_extract.g_request_id
5878: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5879: ,p_business_group_id => ben_ext_person.g_business_group_id
5880: );
5881: --

Line 5878: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id

5874: ,p_err_name =>l_err_message
5875: ,p_typ_cd => 'W'
5876: ,p_person_id => g_person_id
5877: ,p_request_id => ben_extract.g_request_id
5878: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5879: ,p_business_group_id => ben_ext_person.g_business_group_id
5880: );
5881: --
5882: else

Line 5899: ,p_request_id => ben_extract.g_request_id

5895: (p_err_num => 92065
5896: ,p_err_name => l_err_message
5897: ,p_typ_cd => 'W'
5898: ,p_person_id => g_person_id
5899: ,p_request_id => ben_extract.g_request_id
5900: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5901: ,p_business_group_id => ben_ext_person.g_business_group_id
5902: );
5903: --

Line 5900: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id

5896: ,p_err_name => l_err_message
5897: ,p_typ_cd => 'W'
5898: ,p_person_id => g_person_id
5899: ,p_request_id => ben_extract.g_request_id
5900: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5901: ,p_business_group_id => ben_ext_person.g_business_group_id
5902: );
5903: --
5904: else

Line 5926: ,p_request_id => ben_extract.g_request_id

5922: (p_err_num => 92065
5923: ,p_err_name => l_err_message
5924: ,p_typ_cd => 'W'
5925: ,p_person_id => g_person_id
5926: ,p_request_id => ben_extract.g_request_id
5927: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5928: ,p_business_group_id => ben_ext_person.g_business_group_id
5929: );
5930: --

Line 5927: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id

5923: ,p_err_name => l_err_message
5924: ,p_typ_cd => 'W'
5925: ,p_person_id => g_person_id
5926: ,p_request_id => ben_extract.g_request_id
5927: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5928: ,p_business_group_id => ben_ext_person.g_business_group_id
5929: );
5930: --
5931: end if;

Line 5950: ,p_request_id => ben_extract.g_request_id

5946: (p_err_num => 92065
5947: ,p_err_name => l_err_message
5948: ,p_typ_cd => 'W'
5949: ,p_person_id => g_person_id
5950: ,p_request_id => ben_extract.g_request_id
5951: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5952: ,p_business_group_id => ben_ext_person.g_business_group_id
5953: );
5954: --

Line 5951: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id

5947: ,p_err_name => l_err_message
5948: ,p_typ_cd => 'W'
5949: ,p_person_id => g_person_id
5950: ,p_request_id => ben_extract.g_request_id
5951: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5952: ,p_business_group_id => ben_ext_person.g_business_group_id
5953: );
5954: --
5955: end if;

Line 5971: ,p_request_id => ben_extract.g_request_id

5967: (p_err_num => 92065
5968: ,p_err_name => l_err_message
5969: ,p_typ_cd => 'W'
5970: ,p_person_id => g_person_id
5971: ,p_request_id => ben_extract.g_request_id
5972: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5973: ,p_business_group_id => ben_ext_person.g_business_group_id
5974: );
5975: --

Line 5972: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id

5968: ,p_err_name => l_err_message
5969: ,p_typ_cd => 'W'
5970: ,p_person_id => g_person_id
5971: ,p_request_id => ben_extract.g_request_id
5972: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
5973: ,p_business_group_id => ben_ext_person.g_business_group_id
5974: );
5975: --
5976: end if;

Line 6041: ,p_request_id => ben_extract.g_request_id

6037: (p_err_num => 92065
6038: ,p_err_name => l_err_message
6039: ,p_typ_cd => 'W'
6040: ,p_person_id => g_person_id
6041: ,p_request_id => ben_extract.g_request_id
6042: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
6043: ,p_business_group_id => ben_ext_person.g_business_group_id
6044: );
6045: --

Line 6042: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id

6038: ,p_err_name => l_err_message
6039: ,p_typ_cd => 'W'
6040: ,p_person_id => g_person_id
6041: ,p_request_id => ben_extract.g_request_id
6042: ,p_ext_rslt_id => ben_extract.g_ext_rslt_id
6043: ,p_business_group_id => ben_ext_person.g_business_group_id
6044: );
6045: --
6046: end if;