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_EXTRACT_SEED dependencies on BEN_EXT_RCD

Line 10: select '1' from ben_ext_rcd r,

6: procedure Change5010(p_file_name IN VARCHAR2) is
7: cursor c_rcd_exists is
8: select '1' from dual where
9: exists (
10: select '1' from ben_ext_rcd r,
11: ben_ext_rcd_in_file rif,
12: ben_ext_file f
13: WHERE f.business_group_id is NULL
14: and f.ext_file_id =rif.ext_file_id

Line 11: ben_ext_rcd_in_file rif,

7: cursor c_rcd_exists is
8: select '1' from dual where
9: exists (
10: select '1' from ben_ext_rcd r,
11: ben_ext_rcd_in_file rif,
12: ben_ext_file f
13: WHERE f.business_group_id is NULL
14: and f.ext_file_id =rif.ext_file_id
15: and r.ext_rcd_id = rif.ext_rcd_id

Line 28: update ben_ext_rcd_in_file

24: open c_rcd_exists;
25: fetch c_rcd_exists into l_var;
26: if(c_rcd_exists%notfound) then
27: hr_utility.set_location(' Incrementing sequence' , 10);
28: update ben_ext_rcd_in_file
29: set seq_num = seq_num * 10
30: where ext_FILE_ID = (select ext_FILE_ID from
31: ben_ext_file f
32: where f.business_group_id is NULL

Line 40: ,ben_ext_rcd rcd

36: update ben_EXT_DATA_ELMT_IN_RCD
37: set seq_num = seq_num * 10
38: where ext_rcd_id = (select rcd.ext_rcd_id from
39: ben_ext_file f
40: ,ben_ext_rcd rcd
41: ,BEN_EXT_RCD_IN_FILE rif
42: where f.business_group_id is NULL
43: and f.name = p_file_name
44: and rcd.EXT_RCD_ID =rif.ext_rcd_id

Line 41: ,BEN_EXT_RCD_IN_FILE rif

37: set seq_num = seq_num * 10
38: where ext_rcd_id = (select rcd.ext_rcd_id from
39: ben_ext_file f
40: ,ben_ext_rcd rcd
41: ,BEN_EXT_RCD_IN_FILE rif
42: where f.business_group_id is NULL
43: and f.name = p_file_name
44: and rcd.EXT_RCD_ID =rif.ext_rcd_id
45: and f.EXT_FILE_ID =rif.EXT_FILE_ID

Line 2006: from ben_Ext_rcd_in_file erf,

2002: select erf.ext_rcd_in_file_id,
2003: rcd.ext_rcd_id
2004: into l_ext_rcd_in_file_id ,
2005: l_ext_rcd_id
2006: from ben_Ext_rcd_in_file erf,
2007: ben_Ext_rcd rcd
2008: where rcd.name = p_ext_group_record
2009: and rcd.ext_rcd_id = erf.ext_rcd_id
2010: and erf.ext_file_id = l_ext_file_id

Line 2007: ben_Ext_rcd rcd

2003: rcd.ext_rcd_id
2004: into l_ext_rcd_in_file_id ,
2005: l_ext_rcd_id
2006: from ben_Ext_rcd_in_file erf,
2007: ben_Ext_rcd rcd
2008: where rcd.name = p_ext_group_record
2009: and rcd.ext_rcd_id = erf.ext_rcd_id
2010: and erf.ext_file_id = l_ext_file_id
2011: ;

Line 2197: l_xml_tag_name ben_ext_rcd.xml_tag_name%type ;

2193: l_last_update_date DATE;
2194: l_last_updated_by NUMBER;
2195: l_new_business_group_id number ;
2196: l_ovn number ;
2197: l_xml_tag_name ben_ext_rcd.xml_tag_name%type ;
2198: l_rcd_type_cd ben_ext_rcd.RCD_TYPE_CD%type ;
2199: l_low_lvl_cd ben_ext_rcd.LOW_LVL_CD%type ;
2200: l_proc varchar2(100) := 'BEN_EXT_SEED.load_record' ;
2201: BEGIN

Line 2198: l_rcd_type_cd ben_ext_rcd.RCD_TYPE_CD%type ;

2194: l_last_updated_by NUMBER;
2195: l_new_business_group_id number ;
2196: l_ovn number ;
2197: l_xml_tag_name ben_ext_rcd.xml_tag_name%type ;
2198: l_rcd_type_cd ben_ext_rcd.RCD_TYPE_CD%type ;
2199: l_low_lvl_cd ben_ext_rcd.LOW_LVL_CD%type ;
2200: l_proc varchar2(100) := 'BEN_EXT_SEED.load_record' ;
2201: BEGIN
2202: hr_utility.set_location(' Entering ' || l_proc, 10);

Line 2199: l_low_lvl_cd ben_ext_rcd.LOW_LVL_CD%type ;

2195: l_new_business_group_id number ;
2196: l_ovn number ;
2197: l_xml_tag_name ben_ext_rcd.xml_tag_name%type ;
2198: l_rcd_type_cd ben_ext_rcd.RCD_TYPE_CD%type ;
2199: l_low_lvl_cd ben_ext_rcd.LOW_LVL_CD%type ;
2200: l_proc varchar2(100) := 'BEN_EXT_SEED.load_record' ;
2201: BEGIN
2202: hr_utility.set_location(' Entering ' || l_proc, 10);
2203: get_who_values(p_owner => p_owner

Line 2222: FROM ben_ext_rcd

2218: l_ovn,
2219: l_xml_tag_name,
2220: l_RCD_TYPE_CD,
2221: l_LOW_LVL_CD
2222: FROM ben_ext_rcd
2223: WHERE name = p_record_name
2224: AND nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)
2225: AND nvl(legislation_code,'~NULL~') = nvl(l_legislation_code,'~NULL~');
2226:

Line 2353: FROM ben_ext_rcd

2349:
2350: BEGIN
2351: SELECT ext_rcd_id
2352: INTO l_ext_rcd_id
2353: FROM ben_ext_rcd
2354: WHERE name = p_parent_record_name
2355: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~')
2356: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1);
2357:

Line 2426: FROM ben_ext_rcd_in_file

2422: BEGIN
2423: --rpinjala
2424: SELECT ext_rcd_in_file_id, object_version_number
2425: INTO l_ext_rcd_in_file_id,l_object_version_number
2426: FROM ben_ext_rcd_in_file
2427: WHERE ext_file_id = l_ext_file_id
2428: AND ext_rcd_id = l_ext_rcd_id
2429: AND seq_num = p_seq_num
2430: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~')

Line 2477: from ben_ext_rcd_in_file

2473: l_tmp varchar2(1) ;
2474: Begin
2475: select object_version_number,ext_rcd_in_file_id
2476: into l_object_version_number,l_rcd_in_file_id
2477: from ben_ext_rcd_in_file
2478: where ext_file_id = l_ext_file_id
2479: and ext_rcd_id <> nvl(l_ext_rcd_id,-1)
2480: and seq_num = p_seq_num
2481: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1) ;

Line 2778: FROM ben_ext_rcd

2774: --- there is possible element creatd for forward reason
2775: if p_parent_record_name is not null then
2776: SELECT ext_rcd_id
2777: INTO l_ext_rcd_id
2778: FROM ben_ext_rcd
2779: WHERE name = p_parent_record_name
2780: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
2781: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~');
2782: end if ;

Line 3119: FROM ben_ext_rcd

3115: BEGIN
3116:
3117: SELECT ext_rcd_id
3118: INTO l_ext_rcd_id
3119: FROM ben_ext_rcd
3120: WHERE name = p_record_name
3121: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~')
3122: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1) ;
3123: EXCEPTION

Line 3346: FROM ben_ext_rcd

3342: if p_record_name is not null then
3343: BEGIN
3344: SELECT ext_rcd_id
3345: INTO l_ext_rcd_id
3346: FROM ben_ext_rcd
3347: WHERE name = p_record_name
3348: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~')
3349: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
3350: ;

Line 3374: FROM ben_ext_rcd_in_file

3370: END;
3371: BEGIN
3372: SELECT ext_rcd_in_file_id
3373: INTO l_ext_rcd_in_file_id
3374: FROM ben_ext_rcd_in_file
3375: WHERE ext_file_id = l_ext_file_id
3376: AND ext_rcd_id = l_ext_rcd_id
3377: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
3378: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~');

Line 3628: FROM ben_ext_rcd

3624: ,p_business_group_id => l_new_business_group_id );
3625: BEGIN
3626: SELECT ext_rcd_id
3627: INTO l_ext_rcd_id
3628: FROM ben_ext_rcd
3629: WHERE name = p_record_name
3630: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~')
3631: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1) ;
3632: EXCEPTION

Line 3652: FROM ben_ext_rcd_in_file

3648: END;
3649: BEGIN
3650: SELECT ext_rcd_in_file_id
3651: INTO l_ext_rcd_in_file_id
3652: FROM ben_ext_rcd_in_file
3653: WHERE ext_file_id = l_ext_file_id
3654: AND ext_rcd_id = l_ext_rcd_id
3655: AND NVL(legislation_code,'~NULL~')= NVL(l_legislation_code,'~NULL~')
3656: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1) ;