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_THREAD dependencies on BEN_EXT_RSLT

Line 159: 15-Dec-04 tjesumic 115.111 ext_rcd_in_file_id added to ben_Ext_rslt_dtl table

155: 13-aug-04 tjesumic 115.107 chg_actl_ct is truncated to validated the dates
156: 18-Nov-04 rpinjala 115.108 New procedure chk_pqp_extract added
157: 19-Nov-04 rpinjala 115.109 Changed chk_pqp_extract procedure.
158: 05-Dec-04 rpinjala 115.110 Changed chk_pqp_extract procedure.
159: 15-Dec-04 tjesumic 115.111 ext_rcd_in_file_id added to ben_Ext_rslt_dtl table
160: 01-Feb-05 tjesumic 115.112 300 elements allowed in a record
161: 08-Mar-05 tjesumic 115.113 check_asg_security changed for performance
162: 09-Mar-05 tjesumic 115.114 check_asg_security changed for performance
163: 22-Mar-05 tjesumic 115.115 CWB (CW) , subheader codes changes

Line 509: FROM ben_ext_rslt rslt

505: l_temp_dt date := null;
506: --
507: cursor c_ext_rslt is
508: SELECT rslt.run_strt_dt , rslt.run_end_dt
509: FROM ben_ext_rslt rslt
510: WHERE rslt.ext_rslt_id = p_ext_rslt_id;
511: --
512: cursor c_ext_rcd is
513: SELECT distinct rdtl.ext_rcd_id ext_rcd_id

Line 514: FROM ben_ext_rcd rcd, ben_ext_rslt_dtl rdtl

510: WHERE rslt.ext_rslt_id = p_ext_rslt_id;
511: --
512: cursor c_ext_rcd is
513: SELECT distinct rdtl.ext_rcd_id ext_rcd_id
514: FROM ben_ext_rcd rcd, ben_ext_rslt_dtl rdtl
515: WHERE rdtl.ext_rslt_id = p_ext_rslt_id
516: and rdtl.ext_rcd_id = rcd.ext_rcd_id
517: and rcd.rcd_type_cd in ('H','T');
518: --

Line 580: l_tot_string := 'UPDATE BEN_EXT_RSLT_DTL ' || l_tot_string

576: if l_tot_string is not null then
577: */
578: --
579: /*
580: l_tot_string := 'UPDATE BEN_EXT_RSLT_DTL ' || l_tot_string
581: || ' WHERE ext_rslt_id = ' || to_char(p_ext_rslt_id)
582: || ' AND ext_rcd_id = ' || to_char(rcd_rec.ext_rcd_id);
583:
584: */

Line 586: l_tot_string := 'UPDATE BEN_EXT_RSLT_DTL SET ' || l_col_name || ' = :VAL where ext_rslt_id = :RSLT_ID and ext_rcd_id = :RCD_ID' ;

582: || ' AND ext_rcd_id = ' || to_char(rcd_rec.ext_rcd_id);
583:
584: */
585:
586: l_tot_string := 'UPDATE BEN_EXT_RSLT_DTL SET ' || l_col_name || ' = :VAL where ext_rslt_id = :RSLT_ID and ext_rcd_id = :RCD_ID' ;
587:
588: DBMS_SQL.PARSE(l_cursor_id, l_tot_string, dbms_sql.v7);
589:
590:

Line 719: from ben_ext_rslt_dtl xrd

715:
716: cursor get_per_cnt (p_group_val_01 varchar2 ,
717: p_group_val_02 varchar2) is
718: select count(distinct person_id)
719: from ben_ext_rslt_dtl xrd
720: where xrd.ext_rslt_id = p_ext_rslt_id
721: and person_id not in (0, 999999999999)
722: and xrd.group_val_01 = p_group_val_01
723: and nvl(xrd.group_val_02,'-1') = nvl(p_group_val_02,'-1') ;

Line 729: from ben_ext_rslt_dtl xrd ,

725:
726: cursor get_dtl_cnt(p_group_val_01 varchar2 ,
727: p_group_val_02 varchar2) is
728: select count(*)
729: from ben_ext_rslt_dtl xrd ,
730: ben_ext_rcd_in_file erf
731: where xrd.ext_rslt_id = p_ext_rslt_id
732: and xrd.ext_rcd_id = erf.ext_rcd_id
733: and xrd.ext_rcd_in_file_id = erf.ext_rcd_in_file_id

Line 745: from ben_ext_rslt_dtl xrd ,

741:
742: cursor get_ttl_cnt(p_group_val_01 varchar2 ,
743: p_group_val_02 varchar2) is
744: select count(*)
745: from ben_ext_rslt_dtl xrd ,
746: ben_ext_rcd_in_file erf
747: where xrd.ext_rslt_id = p_ext_rslt_id
748: and xrd.ext_rcd_id = erf.ext_rcd_id
749: and xrd.ext_rcd_in_file_id = erf.ext_rcd_in_file_id

Line 1186: l_prmy_sort_val ben_ext_rslt_dtl.prmy_sort_val%TYPE; -- UTF8 varchar2(30);

1182: l_object_version_number number(15);
1183: --
1184: l_trans_num number(15);
1185: l_person_id number(15);
1186: l_prmy_sort_val ben_ext_rslt_dtl.prmy_sort_val%TYPE; -- UTF8 varchar2(30);
1187: l_scnd_sort_val ben_ext_rslt_dtl.scnd_sort_val%TYPE; -- UTF8 varchar2(30);
1188: l_exclude_this_rcd_flag boolean;
1189: l_write_rcd varchar2(1);
1190: l_elmt_name varchar2(2000) ;

Line 1187: l_scnd_sort_val ben_ext_rslt_dtl.scnd_sort_val%TYPE; -- UTF8 varchar2(30);

1183: --
1184: l_trans_num number(15);
1185: l_person_id number(15);
1186: l_prmy_sort_val ben_ext_rslt_dtl.prmy_sort_val%TYPE; -- UTF8 varchar2(30);
1187: l_scnd_sort_val ben_ext_rslt_dtl.scnd_sort_val%TYPE; -- UTF8 varchar2(30);
1188: l_exclude_this_rcd_flag boolean;
1189: l_write_rcd varchar2(1);
1190: l_elmt_name varchar2(2000) ;
1191: l_error_message varchar2(2000) ;

Line 1252: from ben_Ext_rslt_dtl xrd,

1248:
1249:
1250: cursor get_subtrl_cnt is
1251: select count(*)
1252: from ben_Ext_rslt_dtl xrd,
1253: ben_ext_rcd rcd,
1254: ben_ext_rcd_in_file erf
1255: where xrd.ext_rslt_id = p_ext_rslt_id
1256: and xrd.ext_rcd_id = erf.ext_rcd_id

Line 1541: ben_ext_rslt_dtl_api.create_ext_rslt_dtl

1537: if l_write_rcd = 'Y' then
1538: --
1539: -- call 'create ext detail api' here
1540: --
1541: ben_ext_rslt_dtl_api.create_ext_rslt_dtl
1542: (p_validate => false
1543: ,p_ext_rslt_dtl_id => l_ext_rslt_dtl_id
1544: ,p_prmy_sort_val => l_prmy_sort_val
1545: ,p_scnd_sort_val => l_scnd_sort_val

Line 1920: from ben_Ext_rslt_dtl xrd,

1916: select distinct
1917: xrd.group_val_01,
1918: xrd.group_val_02,
1919: nvl(xrd.ext_per_bg_id,-1) ext_per_bg_id
1920: from ben_Ext_rslt_dtl xrd,
1921: ben_ext_rcd rcd,
1922: ben_ext_rcd_in_file erf
1923: where xrd.ext_rslt_id = p_ext_rslt_id
1924: and xrd.ext_rcd_id = erf.ext_rcd_id

Line 2040: from ben_Ext_rslt_dtl xrd,

2036: --
2037:
2038: cursor get_subhdr_cnt is
2039: select count(*)
2040: from ben_Ext_rslt_dtl xrd,
2041: ben_ext_rcd rcd,
2042: ben_ext_rcd_in_file erf
2043: where xrd.ext_rslt_id = p_ext_rslt_id
2044: and xrd.ext_rcd_id = erf.ext_rcd_id

Line 2055: from ben_ext_rslt_dtl xrd , ben_ext_rcd_in_file erf

2051: --
2052:
2053: cursor get_dtl_cnt is
2054: select count(*)
2055: from ben_ext_rslt_dtl xrd , ben_ext_rcd_in_file erf
2056: where xrd.ext_rslt_id = p_ext_rslt_id
2057: and xrd.ext_rcd_id = erf.ext_rcd_id
2058: and xrd.ext_rcd_in_file_id = erf.ext_rcd_in_file_id
2059: and erf.ext_file_id = p_ext_file_id

Line 2064: -- from ben_ext_rslt_dtl xrd

2060: and erf.hide_flag = 'N'
2061: and person_id not in (0, 999999999999) ;
2062:
2063: -- select count(*)
2064: -- from ben_ext_rslt_dtl xrd
2065: -- where xrd.ext_rslt_id = p_ext_rslt_id;
2066: --
2067: cursor get_per_cnt is
2068: select count(distinct person_id)

Line 2069: from ben_ext_rslt_dtl xrd

2065: -- where xrd.ext_rslt_id = p_ext_rslt_id;
2066: --
2067: cursor get_per_cnt is
2068: select count(distinct person_id)
2069: from ben_ext_rslt_dtl xrd
2070: where xrd.ext_rslt_id = p_ext_rslt_id
2071: and person_id not in (0, 999999999999);
2072: --
2073: cursor get_err_cnt is

Line 2075: from ben_ext_rslt_err err

2071: and person_id not in (0, 999999999999);
2072: --
2073: cursor get_err_cnt is
2074: select count(*)
2075: from ben_ext_rslt_err err
2076: where err.ext_rslt_id = p_ext_rslt_id;
2077: --
2078: begin
2079: --

Line 4587: ' exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||

4583: end if ;
4584: if l_pdl_val1 = 'PDLJOB' then
4585: l_dynamic_sql := l_dynamic_sql ||
4586: ' (select 1 from per_jobs job where job.job_id = ben_asg.job_id and ' ||
4587: ' exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||
4588: ' erd.ext_rslt_id = ' || p_ext_rslt_id ||
4589: ' and group_val_01 is not null and group_val_01 = job.name ) ) ' ;
4590: elsif l_pdl_val1 = 'PDLPOS' then
4591: l_dynamic_sql := l_dynamic_sql ||

Line 4595: ' exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||

4591: l_dynamic_sql := l_dynamic_sql ||
4592: ' (select 1 from HR_ALL_POSITIONS_F pos where pos.position_id = ben_asg.position_id and '||
4593: ' to_date(''' || to_char(p_effective_date,'DD-MM-RRRR') ||
4594: ''',''DD-MM-RRRR'') between pos.effective_start_date and pos.effective_end_date and ' ||
4595: ' exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||
4596: ' erd.ext_rslt_id = ' || p_ext_rslt_id ||
4597: ' and group_val_01 is not null and group_val_01 = pos.name )) ' ;
4598:
4599: elsif l_pdl_val1 = 'PDLPAY' then

Line 4602: ' exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||

4598:
4599: elsif l_pdl_val1 = 'PDLPAY' then
4600: l_dynamic_sql := l_dynamic_sql ||
4601: ' (select 1 from pay_payrolls pay where pay.payroll_id = ben_asg.payroll_id and ' ||
4602: ' exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||
4603: ' erd.ext_rslt_id = ' || p_ext_rslt_id ||
4604: ' and group_val_01 is not null and group_val_01 = pay.payroll_name )) ' ;
4605: elsif l_pdl_val1 = 'PDLLOC' then
4606: l_dynamic_sql := l_dynamic_sql ||

Line 4610: ' and exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||

4606: l_dynamic_sql := l_dynamic_sql ||
4607: ' (select 1 from hr_locations_all loc where loc.location_id = ben_asg.location_id ' ||
4608: ' and to_date(''' || to_char(p_effective_date,'DD-MM-RRRR') ||
4609: ''',''DD-MM-RRRR'') between loc.effective_start_date and loc.effective_end_date ' ||
4610: ' and exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||
4611: ' erd.ext_rslt_id = ' || p_ext_rslt_id ||
4612: ' and group_val_01 is not null and group_val_01 = loc.location_code )) ' ;
4613: elsif l_pdl_val1 = 'PDLEAPP' then
4614: l_dynamic_sql := l_dynamic_sql ||

Line 4624: ' and exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||

4620:
4621: elsif l_pdl_val1 = 'PDLGRD' then
4622: l_dynamic_sql := l_dynamic_sql ||
4623: ' (select 1 from per_grades grd where grd.grade_id = ben_asg.grade_id ' ||
4624: ' and exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||
4625: ' erd.ext_rslt_id = ' || p_ext_rslt_id ||
4626: ' and group_val_01 is not null and group_val_01 = grd.name )) ' ;
4627:
4628: end if;

Line 5495: l_output_name ben_ext_rslt.output_name%type ;

5491: l_ext_strt_dt date;
5492: l_ext_end_dt date;
5493: l_prmy_sort_cd hr_lookups.lookup_code%TYPE ; -- UTF8 varchar2(30);
5494: l_scnd_sort_cd hr_lookups.lookup_code%TYPE ; -- UTF8 varchar2(30);
5495: l_output_name ben_ext_rslt.output_name%type ;
5496: l_drctry_name ben_ext_rslt.drctry_name%type ;
5497: l_apnd_rqst_id_flag ben_ext_dfn.apnd_rqst_id_flag%TYPE; -- UTF8 varchar2(40);
5498: l_kickoff_wrt_prc_flag ben_ext_dfn.kickoff_wrt_prc_flag%TYPE; -- UTF8 varchar2(40);
5499: l_use_eff_dt_for_chgs_flag ben_ext_dfn.use_eff_dt_for_chgs_flag%TYPE ; -- UTF8 varchar2(40);

Line 5496: l_drctry_name ben_ext_rslt.drctry_name%type ;

5492: l_ext_end_dt date;
5493: l_prmy_sort_cd hr_lookups.lookup_code%TYPE ; -- UTF8 varchar2(30);
5494: l_scnd_sort_cd hr_lookups.lookup_code%TYPE ; -- UTF8 varchar2(30);
5495: l_output_name ben_ext_rslt.output_name%type ;
5496: l_drctry_name ben_ext_rslt.drctry_name%type ;
5497: l_apnd_rqst_id_flag ben_ext_dfn.apnd_rqst_id_flag%TYPE; -- UTF8 varchar2(40);
5498: l_kickoff_wrt_prc_flag ben_ext_dfn.kickoff_wrt_prc_flag%TYPE; -- UTF8 varchar2(40);
5499: l_use_eff_dt_for_chgs_flag ben_ext_dfn.use_eff_dt_for_chgs_flag%TYPE ; -- UTF8 varchar2(40);
5500: l_ext_post_prcs_rl number;

Line 5516: from ben_ext_rslt

5512: --
5513:
5514: cursor c_rslt is
5515: select object_version_number
5516: from ben_ext_rslt
5517: where ext_rslt_id = p_ext_rslt_id ;
5518:
5519: -- check the defintion of detail levle
5520: cursor chk_D_lvl(p_ext_file_id number) is

Line 5531: ben_Ext_rslt_err

5527: ;
5528: --
5529: cursor c_Ext_err_only (c_ext_rslt_id number) is
5530: select 'x' from
5531: ben_Ext_rslt_err
5532: where typ_cd = 'E'
5533: and ext_rslt_id = c_ext_rslt_id
5534: ;
5535: --

Line 5801: ben_ext_rslt_api.create_ext_rslt

5797: close c_rslt ;
5798:
5799:
5800: if l_xrs_object_version_number is null then
5801: ben_ext_rslt_api.create_ext_rslt
5802: (p_validate => FALSE
5803: ,p_ext_rslt_id => l_ext_rslt_id
5804: ,p_run_strt_dt => sysdate
5805: ,p_run_end_dt => null

Line 5826: ben_ext_rslt_api.create_ext_rslt

5822:
5823: commit;
5824: end if ;
5825: else
5826: ben_ext_rslt_api.create_ext_rslt
5827: (p_validate => FALSE
5828: ,p_ext_rslt_id => l_ext_rslt_id
5829: ,p_run_strt_dt => sysdate
5830: ,p_run_end_dt => null

Line 6354: ben_ext_rslt_api.update_ext_rslt

6350: end if ;
6351: close c_Ext_err_only ;
6352:
6353:
6354: ben_ext_rslt_api.update_ext_rslt
6355: (p_validate => false
6356: ,p_ext_rslt_id => l_ext_rslt_id
6357: ,p_run_end_dt => sysdate
6358: ,p_ext_stat_cd => l_ext_stat_cd

Line 6375: ben_ext_rslt_api.update_ext_rslt

6371: else
6372: --
6373: if l_ext_rslt_id is not null then
6374: --
6375: ben_ext_rslt_api.update_ext_rslt
6376: (p_validate => false
6377: ,p_ext_rslt_id => l_ext_rslt_id
6378: ,p_run_end_dt => sysdate
6379: ,p_ext_stat_cd => 'S'

Line 6527: ben_ext_rslt_api.update_ext_rslt

6523: end if;
6524: --
6525: if l_ext_rslt_id is not null then
6526: --
6527: ben_ext_rslt_api.update_ext_rslt
6528: (p_validate => false
6529: ,p_ext_rslt_id => l_ext_rslt_id
6530: ,p_run_end_dt => sysdate
6531: ,p_ext_stat_cd => 'F'

Line 6587: ben_ext_rslt_api.update_ext_rslt

6583: end if;
6584: --
6585: if l_ext_rslt_id is not null then
6586: --
6587: ben_ext_rslt_api.update_ext_rslt
6588: (p_validate => false
6589: ,p_ext_rslt_id => l_ext_rslt_id
6590: ,p_run_end_dt => sysdate
6591: ,p_ext_stat_cd => 'F'

Line 6655: from ben_ext_rslt_dtl

6651:
6652: cursor c_xrdt (c_person_id number) is
6653: select ext_rslt_dtl_id,
6654: object_version_number
6655: from ben_ext_rslt_dtl
6656: where person_id = c_person_id
6657: and ext_rslt_id = p_ext_rslt_id ;
6658:
6659:

Line 6663: from ben_ext_rslt_err

6659:
6660: cursor c_xrer (c_person_id number) is
6661: select ext_rslt_err_id,
6662: object_version_number
6663: from ben_ext_rslt_err
6664: where person_id = c_person_id
6665: and ext_rslt_id = p_ext_rslt_id ;
6666:
6667: ---

Line 6694: ben_EXT_RSLT_DTL_api.delete_EXT_RSLT_DTL

6690: hr_utility.set_location ('deleting '|| pact.person_id, 177);
6691: end if;
6692:
6693: l_object_version_number := xrdt.object_version_number ;
6694: ben_EXT_RSLT_DTL_api.delete_EXT_RSLT_DTL
6695: (p_ext_rslt_dtl_id => xrdt.ext_rslt_dtl_id
6696: ,p_object_version_number => l_object_version_number
6697: );
6698: end loop ;

Line 6709: ben_EXT_RSLT_ERR_api.delete_EXT_RSLT_ERR

6705: hr_utility.set_location ('deleting error'||pact.person_id, 177);
6706: end if;
6707:
6708: l_object_version_number := xrer.object_version_number ;
6709: ben_EXT_RSLT_ERR_api.delete_EXT_RSLT_ERR
6710: (p_ext_rslt_err_id => xrer.ext_rslt_err_id
6711: ,p_object_version_number => l_object_version_number
6712: ,p_effective_date => p_effective_date
6713: );