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.GHR_NFC_POSITION_EXTRACTS dependencies on BEN_EXT_RSLT_DTL

Line 117: FROM ben_ext_rslt_dtl dtl

113: CURSOR csr_rslt_dtl(c_position_id IN NUMBER
114: ,c_ext_rslt_id IN Number
115: ,c_ext_dtl_rcd_id IN Number ) IS
116: SELECT *
117: FROM ben_ext_rslt_dtl dtl
118: WHERE dtl.ext_rslt_id = c_ext_rslt_id
119: AND dtl.VAL_71 = c_position_id
120: AND dtl.ext_rcd_id = c_ext_dtl_rcd_id;
121:

Line 129: FROM ben_ext_rslt_dtl dtl

125: CURSOR csr_err_rslt_dtl(c_position_id IN NUMBER
126: ,c_ext_rslt_id IN Number
127: ,c_ext_rslt_dtl_id IN Number ) IS
128: SELECT *
129: FROM ben_ext_rslt_dtl dtl
130: WHERE dtl.ext_rslt_id = c_ext_rslt_id
131: AND dtl.VAL_71 = c_position_id
132: AND dtl.ext_rslt_dtl_id = c_ext_rslt_dtl_id;
133:

Line 141: FROM ben_ext_rslt_dtl dtl

137: CURSOR csr_rcd_position_ids
138: (c_ext_rslt_id IN Number
139: ,c_ext_dtl_rcd_id IN Number ) IS
140: SELECT dtl.val_71 --Position_id
141: FROM ben_ext_rslt_dtl dtl
142: WHERE dtl.ext_rslt_id = c_ext_rslt_id
143: AND dtl.VAL_45 = 'A' --Function Code
144: AND dtl.ext_rcd_id = c_ext_dtl_rcd_id
145: AND dtl.VAL_49 is not null; --Incumbent SSN

Line 161: ,ben_ext_rslt_dtl rslt

157: SELECT rslt.ext_rslt_dtl_id
158: FROM ben_ext_rcd rcd
159: ,ben_ext_rcd_in_file rin
160: ,ben_ext_dfn dfn
161: ,ben_ext_rslt_dtl rslt
162: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
163: AND rin.ext_file_id = dfn.ext_file_id
164: AND rin.hide_flag = c_ext_hide_flag -- Y=Hidden, N=Not Hidden
165: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 447: (p_rslt_rec IN ben_ext_rslt_dtl%ROWTYPE

443: -- =============================================================================
444: -- Copy_Rec_Values :
445: -- =============================================================================
446: PROCEDURE Copy_Rec_Values
447: (p_rslt_rec IN ben_ext_rslt_dtl%ROWTYPE
448: ,p_val_tab IN OUT NOCOPY ValTabTyp) IS
449:
450: l_proc_name Varchar2(150) := g_proc_name ||'Copy_Rec_Values ';
451: BEGIN

Line 545: (p_dtl_rec in ben_ext_rslt_dtl%rowtype

541: -- =============================================================================
542: -- ~Upd_Rslt_Dtl : Updates the primary assignment record in results detail table
543: -- =============================================================================
544: procedure Upd_Rslt_Dtl
545: (p_dtl_rec in ben_ext_rslt_dtl%rowtype
546: ,p_val_tab in ValTabTyp ) is
547:
548: l_proc_name varchar2(150):= g_proc_name||'upd_rslt_dtl';
549:

Line 554: update ben_ext_rslt_dtl

550: begin -- Upd_Rslt_Dtl
551:
552: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
553:
554: update ben_ext_rslt_dtl
555: set val_01 = p_val_tab(1)
556: ,val_02 = p_val_tab(2)
557: ,val_03 = p_val_tab(3)
558: ,val_04 = p_val_tab(4)

Line 647: (p_dtl_rec in out NOCOPY ben_ext_rslt_dtl%rowtype

643: -- =============================================================================
644: -- ~ Ins_Rslt_Dtl : Inserts a record into the results detail record.
645: -- =============================================================================
646: procedure Ins_Rslt_Dtl
647: (p_dtl_rec in out NOCOPY ben_ext_rslt_dtl%rowtype
648: ,p_val_tab in ValTabTyp
649: ,p_rslt_dtl_id out NOCOPY number
650: ) is
651:

Line 653: l_dtl_rec_nc ben_ext_rslt_dtl%rowtype;

649: ,p_rslt_dtl_id out NOCOPY number
650: ) is
651:
652: l_proc_name varchar2(150) := g_proc_name||'Ins_Rslt_Dtl';
653: l_dtl_rec_nc ben_ext_rslt_dtl%rowtype;
654:
655: begin -- ins_rslt_dtl
656: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
657: -- nocopy changes

Line 660: select ben_ext_rslt_dtl_s.nextval into p_dtl_rec.ext_rslt_dtl_id from dual;

656: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
657: -- nocopy changes
658: l_dtl_rec_nc := p_dtl_rec;
659: -- Get the next sequence NUMBER to insert a record into the table
660: select ben_ext_rslt_dtl_s.nextval into p_dtl_rec.ext_rslt_dtl_id from dual;
661: insert into ben_ext_rslt_dtl
662: (ext_rslt_dtl_id
663: ,ext_rslt_id
664: ,business_group_id

Line 661: insert into ben_ext_rslt_dtl

657: -- nocopy changes
658: l_dtl_rec_nc := p_dtl_rec;
659: -- Get the next sequence NUMBER to insert a record into the table
660: select ben_ext_rslt_dtl_s.nextval into p_dtl_rec.ext_rslt_dtl_id from dual;
661: insert into ben_ext_rslt_dtl
662: (ext_rslt_dtl_id
663: ,ext_rslt_id
664: ,business_group_id
665: ,ext_rcd_id

Line 3419: (p_business_group_id ben_ext_rslt_dtl.business_group_id%TYPE

3415: -- ~ Del_Post_Process_Recs : Delete all the records created as part
3416: -- ~ of hidden record as they are not required.
3417: -- ====================================================================
3418: FUNCTION Del_Post_Process_Recs
3419: (p_business_group_id ben_ext_rslt_dtl.business_group_id%TYPE
3420: )RETURN NUMBER IS
3421:
3422: CURSOR csr_error_poi_id IS
3423: SELECT POSITION_ID,

Line 3437: FROM ben_ext_rslt_dtl dtl

3433: ,c_ext_dtl_rcd_id IN Number) IS
3434: SELECT dtl.ext_rslt_dtl_id
3435: ,dtl.val_45 --Detail function code
3436: ,dtl.val_26 --Open Position function code
3437: FROM ben_ext_rslt_dtl dtl
3438: WHERE dtl.ext_rslt_id = c_ext_rslt_id
3439: AND dtl.VAL_71 = c_position_id
3440: AND dtl.ext_rcd_id = c_ext_dtl_rcd_id;
3441:

Line 3444: FROM ben_ext_rslt_dtl dtl

3440: AND dtl.ext_rcd_id = c_ext_dtl_rcd_id;
3441:
3442: CURSOR csr_get_record_count(c_ext_rcd_id IN NUMBER) IS
3443: SELECT Count(dtl.ext_rslt_dtl_id)
3444: FROM ben_ext_rslt_dtl dtl
3445: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
3446: AND dtl.ext_rcd_id NOT IN(c_ext_rcd_id);
3447:
3448:

Line 3455: ,ben_ext_rslt_dtl dtl

3451: ,c_business_group_id IN VARCHAR2
3452: ,c_effective_date IN VARCHAR2 ) IS
3453: select distinct paf.position_id
3454: from per_all_assignments_f paf
3455: ,ben_ext_rslt_dtl dtl
3456: where dtl.val_71 = paf.position_id
3457: and paf.business_group_id = c_business_group_id
3458: and paf.business_group_id = dtl.business_group_id
3459: and paf.person_id = dtl.person_id

Line 3472: ,ben_ext_rslt_dtl dtl

3468: SELECT dtl.*
3469: FROM ben_ext_rcd rcd
3470: ,ben_ext_rcd_in_file rin
3471: ,ben_ext_dfn dfn
3472: ,ben_ext_rslt_dtl dtl
3473: WHERE dfn.ext_dfn_id = c_ext_dfn_id
3474: AND rin.ext_file_id = dfn.ext_file_id
3475: AND rin.hide_flag = 'N' -- Y=Hidden, N=Not Hidden
3476: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 3493: l_ext_rslt_dtl_id ben_ext_rslt_dtl.ext_rslt_dtl_id%TYPE;

3489: i_count NUMBER;
3490: l_main_rec csr_rslt_dtl%ROWTYPE;
3491: l_val_tab ValTabTyp;
3492: l_ext_position_id NUMBER;
3493: l_ext_rslt_dtl_id ben_ext_rslt_dtl.ext_rslt_dtl_id%TYPE;
3494: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
3495: l_err_position_id ghr_pos_interface_err_dtls.POSITION_ID%TYPE;
3496: l_err_fuction_code ghr_pos_interface_err_dtls.susp_function_cd%TYPE;
3497: l_rcd_function_code varchar(2);

Line 3499: l_result_dtl_id ben_ext_rslt_dtl.ext_rslt_dtl_id%TYPE;

3495: l_err_position_id ghr_pos_interface_err_dtls.POSITION_ID%TYPE;
3496: l_err_fuction_code ghr_pos_interface_err_dtls.susp_function_cd%TYPE;
3497: l_rcd_function_code varchar(2);
3498: l_sh_function_code varchar(2);
3499: l_result_dtl_id ben_ext_rslt_dtl.ext_rslt_dtl_id%TYPE;
3500: l_rslt_dtl_id NUMBER;
3501: l_record_count Number := 0;
3502: l_rc VARCHAR2(8);
3503: sort_val Number :=1;

Line 3553: FROM ben_ext_rslt_dtl

3549: Upd_Rslt_Dtl(p_dtl_rec => l_main_rec
3550: ,p_val_tab => l_val_tab);
3551: -- then delete it from detail record
3552: DELETE
3553: FROM ben_ext_rslt_dtl
3554: WHERE ext_rcd_id = g_ext_dtl_rcd_id
3555: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
3556: AND business_group_id = p_business_group_id
3557: AND val_71 = l_ext_position_id;

Line 3597: FROM ben_ext_rslt_dtl

3593: Upd_Rslt_Dtl(p_dtl_rec => l_main_rec
3594: ,p_val_tab => l_val_tab);
3595: -- then delete it from detail record
3596: DELETE
3597: FROM ben_ext_rslt_dtl
3598: WHERE ext_rcd_id = g_ext_dtl_rcd_id
3599: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
3600: AND business_group_id = p_business_group_id
3601: AND val_71 = l_ext_position_id;

Line 3613: FROM ben_ext_rslt_dtl

3609: -- Loop through each detail record for the extract
3610: LOOP
3611: -- Delete all rows where the val_52 hidden field value is Found.
3612: DELETE
3613: FROM ben_ext_rslt_dtl
3614: WHERE ext_rcd_id = csr_rcd_rec_t.ext_rcd_id
3615: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
3616: AND business_group_id = p_business_group_id
3617: AND val_52 = 'FOUND';

Line 3632: UPDATE ben_ext_rslt_dtl set val_06 = LPAD(l_rc,8,'0')

3628: CLOSE csr_get_record_count;
3629:
3630: Hr_Utility.set_location('Handling Total Record count ' ||csr_header_rcd_id.ext_rcd_id, 5);
3631: l_rc :=l_record_count;
3632: UPDATE ben_ext_rslt_dtl set val_06 = LPAD(l_rc,8,'0')
3633: WHERE ext_rcd_id = csr_header_rcd_id.ext_rcd_id
3634: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
3635: AND business_group_id= p_business_group_id;
3636:

Line 3674: UPDATE ben_ext_rslt_dtl set PRMY_SORT_VAL = l_new_rec.prmy_sort_val

3670: sort_val :=sort_val+1;
3671:
3672:
3673: IF l_main_rec.val_02 = '2055' THEN
3674: UPDATE ben_ext_rslt_dtl set PRMY_SORT_VAL = l_new_rec.prmy_sort_val
3675: ,group_val_01 = ' '
3676: WHERE ext_rcd_id = l_main_rec.ext_rcd_id
3677: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
3678: AND ext_rslt_dtl_id = l_main_rec.ext_rslt_dtl_id

Line 3681: UPDATE ben_ext_rslt_dtl set PRMY_SORT_VAL = l_new_rec.prmy_sort_val

3677: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
3678: AND ext_rslt_dtl_id = l_main_rec.ext_rslt_dtl_id
3679: AND business_group_id= p_business_group_id;
3680: ELSE
3681: UPDATE ben_ext_rslt_dtl set PRMY_SORT_VAL = l_new_rec.prmy_sort_val
3682: WHERE ext_rcd_id = l_main_rec.ext_rcd_id
3683: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
3684: AND ext_rslt_dtl_id = l_main_rec.ext_rslt_dtl_id
3685: AND business_group_id= p_business_group_id;