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 507: FROM ben_ext_rslt rslt

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

Line 512: FROM ben_ext_rcd rcd, ben_ext_rslt_dtl rdtl

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

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

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

Line 584: 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' ;

580: || ' AND ext_rcd_id = ' || to_char(rcd_rec.ext_rcd_id);
581:
582: */
583:
584: 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' ;
585:
586: DBMS_SQL.PARSE(l_cursor_id, l_tot_string, dbms_sql.v7);
587:
588:

Line 717: from ben_ext_rslt_dtl xrd

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

Line 727: from ben_ext_rslt_dtl xrd ,

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

Line 743: from ben_ext_rslt_dtl xrd ,

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

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

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

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

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

Line 1250: from ben_Ext_rslt_dtl xrd,

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

Line 1539: ben_ext_rslt_dtl_api.create_ext_rslt_dtl

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

Line 1918: from ben_Ext_rslt_dtl xrd,

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

Line 2038: from ben_Ext_rslt_dtl xrd,

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

Line 2053: from ben_ext_rslt_dtl xrd , ben_ext_rcd_in_file erf

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

Line 2062: -- from ben_ext_rslt_dtl xrd

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

Line 2067: from ben_ext_rslt_dtl xrd

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

Line 2073: from ben_ext_rslt_err err

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

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

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

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

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

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

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

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

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

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

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

Line 5492: l_output_name ben_ext_rslt.output_name%type ;

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

Line 5493: l_drctry_name ben_ext_rslt.drctry_name%type ;

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

Line 5513: from ben_ext_rslt

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

Line 5528: ben_Ext_rslt_err

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

Line 5795: ben_ext_rslt_api.create_ext_rslt

5791: close c_rslt ;
5792:
5793:
5794: if l_xrs_object_version_number is null then
5795: ben_ext_rslt_api.create_ext_rslt
5796: (p_validate => FALSE
5797: ,p_ext_rslt_id => l_ext_rslt_id
5798: ,p_run_strt_dt => sysdate
5799: ,p_run_end_dt => null

Line 5820: ben_ext_rslt_api.create_ext_rslt

5816:
5817: commit;
5818: end if ;
5819: else
5820: ben_ext_rslt_api.create_ext_rslt
5821: (p_validate => FALSE
5822: ,p_ext_rslt_id => l_ext_rslt_id
5823: ,p_run_strt_dt => sysdate
5824: ,p_run_end_dt => null

Line 6313: ben_ext_rslt_api.update_ext_rslt

6309: end if ;
6310: close c_Ext_err_only ;
6311:
6312:
6313: ben_ext_rslt_api.update_ext_rslt
6314: (p_validate => false
6315: ,p_ext_rslt_id => l_ext_rslt_id
6316: ,p_run_end_dt => sysdate
6317: ,p_ext_stat_cd => l_ext_stat_cd

Line 6334: ben_ext_rslt_api.update_ext_rslt

6330: else
6331: --
6332: if l_ext_rslt_id is not null then
6333: --
6334: ben_ext_rslt_api.update_ext_rslt
6335: (p_validate => false
6336: ,p_ext_rslt_id => l_ext_rslt_id
6337: ,p_run_end_dt => sysdate
6338: ,p_ext_stat_cd => 'S'

Line 6486: ben_ext_rslt_api.update_ext_rslt

6482: end if;
6483: --
6484: if l_ext_rslt_id is not null then
6485: --
6486: ben_ext_rslt_api.update_ext_rslt
6487: (p_validate => false
6488: ,p_ext_rslt_id => l_ext_rslt_id
6489: ,p_run_end_dt => sysdate
6490: ,p_ext_stat_cd => 'F'

Line 6546: ben_ext_rslt_api.update_ext_rslt

6542: end if;
6543: --
6544: if l_ext_rslt_id is not null then
6545: --
6546: ben_ext_rslt_api.update_ext_rslt
6547: (p_validate => false
6548: ,p_ext_rslt_id => l_ext_rslt_id
6549: ,p_run_end_dt => sysdate
6550: ,p_ext_stat_cd => 'F'

Line 6614: from ben_ext_rslt_dtl

6610:
6611: cursor c_xrdt (c_person_id number) is
6612: select ext_rslt_dtl_id,
6613: object_version_number
6614: from ben_ext_rslt_dtl
6615: where person_id = c_person_id
6616: and ext_rslt_id = p_ext_rslt_id ;
6617:
6618:

Line 6622: from ben_ext_rslt_err

6618:
6619: cursor c_xrer (c_person_id number) is
6620: select ext_rslt_err_id,
6621: object_version_number
6622: from ben_ext_rslt_err
6623: where person_id = c_person_id
6624: and ext_rslt_id = p_ext_rslt_id ;
6625:
6626: ---

Line 6653: ben_EXT_RSLT_DTL_api.delete_EXT_RSLT_DTL

6649: hr_utility.set_location ('deleting '|| pact.person_id, 177);
6650: end if;
6651:
6652: l_object_version_number := xrdt.object_version_number ;
6653: ben_EXT_RSLT_DTL_api.delete_EXT_RSLT_DTL
6654: (p_ext_rslt_dtl_id => xrdt.ext_rslt_dtl_id
6655: ,p_object_version_number => l_object_version_number
6656: );
6657: end loop ;

Line 6668: ben_EXT_RSLT_ERR_api.delete_EXT_RSLT_ERR

6664: hr_utility.set_location ('deleting error'||pact.person_id, 177);
6665: end if;
6666:
6667: l_object_version_number := xrer.object_version_number ;
6668: ben_EXT_RSLT_ERR_api.delete_EXT_RSLT_ERR
6669: (p_ext_rslt_err_id => xrer.ext_rslt_err_id
6670: ,p_object_version_number => l_object_version_number
6671: ,p_effective_date => p_effective_date
6672: );