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_THREAD

Line 104: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id

100: SELECT rcd.ext_rcd_id
101: FROM ben_ext_rcd rcd
102: ,ben_ext_rcd_in_file rin
103: ,ben_ext_dfn dfn
104: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
105: AND rin.ext_file_id = dfn.ext_file_id
106: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden
107: AND rin.ext_rcd_id = rcd.ext_rcd_id
108: AND rcd.rcd_type_cd = c_rcd_type_cd; --S- Sub Header D=Detail,H=Header,F=Footer

Line 162: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_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
166: AND rslt.EXT_RCD_ID = rcd.ext_rcd_id

Line 358: ben_ext_thread.process

354: hr_utility.set_location('..Calling Benefit Ext Process'||l_proc_name, 6);
355: IF p_transmission_type = 'FULL' THEN
356: hr_utility.set_location('In side Full', 5);
357:
358: ben_ext_thread.process
359: (errbuf => l_errbuff,
360: retcode => l_retcode,
361: p_benefit_action_id => NULL,
362: p_ext_dfn_id => p_ext_dfn_id,

Line 367: ben_ext_thread.process

363: p_effective_date => p_to_date,
364: p_business_group_id => p_business_group_id);
365: ELSE
366: --This defined at position level based on GHR history table
367: ben_ext_thread.process
368: (errbuf => l_errbuff,
369: retcode => l_retcode,
370: p_benefit_action_id => NULL,
371: p_ext_dfn_id => p_ext_dfn_id,

Line 427: ben_ext_thread.process

423: --
424: OPEN csr_ext_dfn_id( c_extract_name => p_extract_name);
425: FETCH csr_ext_dfn_id INTO l_ext_dfn_id;
426: IF csr_ext_dfn_id%FOUND THEN
427: ben_ext_thread.process
428: (errbuf => l_errbuff,
429: retcode => l_retcode,
430: p_benefit_action_id => NULL,
431: p_ext_dfn_id => l_ext_dfn_id,

Line 2968: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;

2964: BEGIN
2965: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2966: g_person_exist := 'N';
2967: i := p_business_group_id;
2968: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;
2969: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;
2970: g_position_id := p_position_id;
2971: g_business_group_id :=p_business_group_id;
2972:

Line 2969: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;

2965: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2966: g_person_exist := 'N';
2967: i := p_business_group_id;
2968: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;
2969: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;
2970: g_position_id := p_position_id;
2971: g_business_group_id :=p_business_group_id;
2972:
2973: Hr_Utility.set_location('l_ext_rslt_id: '||l_ext_rslt_id, 5);

Line 3357: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;

3353: BEGIN
3354: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
3355:
3356: i := g_business_group_id;
3357: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;
3358: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;
3359:
3360: IF NOT g_extract_params.EXISTS(i) THEN
3361: -- Get the Conc. request id to get the params

Line 3358: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;

3354: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
3355:
3356: i := g_business_group_id;
3357: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;
3358: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;
3359:
3360: IF NOT g_extract_params.EXISTS(i) THEN
3361: -- Get the Conc. request id to get the params
3362: OPEN csr_jcl_org_req(c_ext_rslt_id => l_ext_rslt_id

Line 3445: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_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:
3449: CURSOR csr_get_correction_pos(c_ext_rcd_id IN NUMBER

Line 3509: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;

3505: l_new_rec csr_rslt_dtl%ROWTYPE;
3506:
3507: BEGIN
3508: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
3509: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;
3510: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;
3511: --Getting the detail record id
3512: FOR csr_rcd_rec IN csr_ext_rcd_id(c_hide_flag => 'N' -- N=No Y=Yes
3513: ,c_rcd_type_cd => 'D')-- D=Detail, T=Total, H-Header

Line 3510: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;

3506:
3507: BEGIN
3508: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
3509: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;
3510: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;
3511: --Getting the detail record id
3512: FOR csr_rcd_rec IN csr_ext_rcd_id(c_hide_flag => 'N' -- N=No Y=Yes
3513: ,c_rcd_type_cd => 'D')-- D=Detail, T=Total, H-Header
3514: LOOP

Line 3521: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

3517:
3518: --Get all position Id's whose FuntionCode is "A" and the Incumbent SSN is not Null
3519: --Then update this entire row into the second subheader and make Incumbent SSN as NULL
3520: FOR csr_rcd_position_id IN csr_rcd_position_ids
3521: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
3522: ,c_ext_dtl_rcd_id => g_ext_dtl_rcd_id)
3523: LOOP
3524: l_ext_position_id := csr_rcd_position_id.val_71;
3525: Hr_Utility.set_location('Detail Position ID whose SSN is null :'||l_ext_position_id, 5);

Line 3528: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

3524: l_ext_position_id := csr_rcd_position_id.val_71;
3525: Hr_Utility.set_location('Detail Position ID whose SSN is null :'||l_ext_position_id, 5);
3526: OPEN csr_rslt_dtl
3527: (c_position_id => l_ext_position_id
3528: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
3529: ,c_ext_dtl_rcd_id => g_ext_dtl_rcd_id);
3530: FETCH csr_rslt_dtl INTO l_main_rec;
3531: CLOSE csr_rslt_dtl;
3532: l_main_rec.object_version_NUMBER := Nvl(l_main_rec.object_version_NUMBER,0) + 1;

Line 3536: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

3532: l_main_rec.object_version_NUMBER := Nvl(l_main_rec.object_version_NUMBER,0) + 1;
3533: --Get the sub header ext_rslt_dtl_id for this position
3534: --Because this position record already exist in SH with all null values
3535: OPEN csr_rslt_dtl_id
3536: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
3537: ,c_ext_hide_flag => 'N'
3538: ,c_rcd_type_cd => 'S'
3539: ,c_position_id => l_ext_position_id
3540: ,c_business_group_id => p_business_group_id);

Line 3555: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

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;
3558: END LOOP;
3559: --Get all position Id's whose FuntionCode is "C" and the Incumbent SSN is not Null

Line 3564: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

3560: --and position is allocated in same date
3561: --Then update this entire row into the second subheader and make Incumbent SSN as NULL
3562: FOR csr_get_correction_pos_id IN csr_get_correction_pos
3563: (c_ext_rcd_id => g_ext_dtl_rcd_id
3564: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
3565: ,c_business_group_id => p_business_group_id
3566: ,c_effective_date => g_extract_params(p_business_group_id).to_date)
3567: LOOP
3568: l_ext_position_id := csr_get_correction_pos_id.position_id;

Line 3572: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

3568: l_ext_position_id := csr_get_correction_pos_id.position_id;
3569: Hr_Utility.set_location('Detail Position ID whose SSN is null :'||l_ext_position_id, 5);
3570: OPEN csr_rslt_dtl
3571: (c_position_id => l_ext_position_id
3572: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
3573: ,c_ext_dtl_rcd_id => g_ext_dtl_rcd_id);
3574: FETCH csr_rslt_dtl INTO l_main_rec;
3575: CLOSE csr_rslt_dtl;
3576: l_main_rec.object_version_NUMBER := Nvl(l_main_rec.object_version_NUMBER,0) + 1;

Line 3580: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

3576: l_main_rec.object_version_NUMBER := Nvl(l_main_rec.object_version_NUMBER,0) + 1;
3577: --Get the sub header ext_rslt_dtl_id for this position
3578: --Because this position record already exist in SH with all null values
3579: OPEN csr_rslt_dtl_id
3580: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
3581: ,c_ext_hide_flag => 'N'
3582: ,c_rcd_type_cd => 'S'
3583: ,c_position_id => l_ext_position_id
3584: ,c_business_group_id => p_business_group_id);

Line 3599: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

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;
3602: END LOOP;
3603:

Line 3615: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

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';
3618:
3619: END LOOP;

Line 3634: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

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:
3637: END LOOP;
3638:

Line 3649: ,p_result_id =>Ben_Ext_Thread.g_ext_rslt_id

3645: FETCH csr_org_req INTO l_conc_reqest_id;
3646: CLOSE csr_org_req;
3647:
3648: GHR_WF.initiate_notification (p_request_id =>l_conc_reqest_id
3649: ,p_result_id =>Ben_Ext_Thread.g_ext_rslt_id
3650: ,p_role =>g_extract_params(p_business_group_id).notify
3651: );
3652: ghr_nfc_error_proc.chk_for_err_data_pos (p_request_id =>l_conc_reqest_id
3653: ,p_rslt_id =>Ben_Ext_Thread.g_ext_rslt_id);

Line 3653: ,p_rslt_id =>Ben_Ext_Thread.g_ext_rslt_id);

3649: ,p_result_id =>Ben_Ext_Thread.g_ext_rslt_id
3650: ,p_role =>g_extract_params(p_business_group_id).notify
3651: );
3652: ghr_nfc_error_proc.chk_for_err_data_pos (p_request_id =>l_conc_reqest_id
3653: ,p_rslt_id =>Ben_Ext_Thread.g_ext_rslt_id);
3654:
3655: --Get all subheader and details record ids
3656: --then update the record id
3657: Hr_Utility.set_location('Sort value Logic starts here', 5);

Line 3658: Hr_Utility.set_location('Sort Result ID'||Ben_Ext_Thread.g_ext_rslt_id, 5);

3654:
3655: --Get all subheader and details record ids
3656: --then update the record id
3657: Hr_Utility.set_location('Sort value Logic starts here', 5);
3658: Hr_Utility.set_location('Sort Result ID'||Ben_Ext_Thread.g_ext_rslt_id, 5);
3659: FOR ind_dtl IN csr_rslt_dtl_sort
3660: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
3661: ,c_ext_dfn_id => l_ext_dfn_id )
3662: LOOP

Line 3660: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

3656: --then update the record id
3657: Hr_Utility.set_location('Sort value Logic starts here', 5);
3658: Hr_Utility.set_location('Sort Result ID'||Ben_Ext_Thread.g_ext_rslt_id, 5);
3659: FOR ind_dtl IN csr_rslt_dtl_sort
3660: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
3661: ,c_ext_dfn_id => l_ext_dfn_id )
3662: LOOP
3663: l_main_rec := ind_dtl;
3664: l_main_rec.object_version_NUMBER := Nvl(l_main_rec.object_version_NUMBER,0) + 1;

Line 3677: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

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
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

Line 3683: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_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;
3686: END IF;
3687: