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_US_NFC_EXTRACTS dependencies on BEN_EXT_THREAD

Line 64: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id

60: SELECT rcd.ext_rcd_id
61: FROM ben_ext_rcd rcd
62: ,ben_ext_rcd_in_file rin
63: ,ben_ext_dfn dfn
64: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
65: AND rin.ext_file_id = dfn.ext_file_id
66: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden
67: AND rin.ext_rcd_id = rcd.ext_rcd_id
68: AND rcd.rcd_type_cd = c_rcd_type_cd; --S- Sub Header D=Detail,H=Header,F=Footer

Line 178: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently

174: SELECT rcd.ext_rcd_id
175: FROM ben_ext_rcd rcd
176: ,ben_ext_rcd_in_file rin
177: ,ben_ext_dfn dfn
178: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently
179: AND rin.ext_file_id = dfn.ext_file_id
180: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden
181: AND rin.ext_rcd_id = rcd.ext_rcd_id
182: AND rcd.rcd_type_cd = c_rcd_type_cd; -- D=Detail,H=Header,F=Footer

Line 2355: if l_err_num >= ben_ext_thread.g_max_errors_allowed then

2351: end if ;
2352: open err_cnt_c;
2353: fetch err_cnt_c into l_err_num;
2354: close err_cnt_c;
2355: if l_err_num >= ben_ext_thread.g_max_errors_allowed then
2356: ben_ext_thread.g_err_num := 91947;
2357: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';
2358: raise ben_ext_thread.g_job_failure_error;
2359: end if;

Line 2356: ben_ext_thread.g_err_num := 91947;

2352: open err_cnt_c;
2353: fetch err_cnt_c into l_err_num;
2354: close err_cnt_c;
2355: if l_err_num >= ben_ext_thread.g_max_errors_allowed then
2356: ben_ext_thread.g_err_num := 91947;
2357: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';
2358: raise ben_ext_thread.g_job_failure_error;
2359: end if;
2360:

Line 2357: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';

2353: fetch err_cnt_c into l_err_num;
2354: close err_cnt_c;
2355: if l_err_num >= ben_ext_thread.g_max_errors_allowed then
2356: ben_ext_thread.g_err_num := 91947;
2357: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';
2358: raise ben_ext_thread.g_job_failure_error;
2359: end if;
2360:
2361: if g_business_group_id is not null then

Line 2358: raise ben_ext_thread.g_job_failure_error;

2354: close err_cnt_c;
2355: if l_err_num >= ben_ext_thread.g_max_errors_allowed then
2356: ben_ext_thread.g_err_num := 91947;
2357: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';
2358: raise ben_ext_thread.g_job_failure_error;
2359: end if;
2360:
2361: if g_business_group_id is not null then
2362: Ben_Ext_Util.write_err

Line 2505: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

2501: --Added by Gattu
2502: CURSOR csr_get_record_count(c_ext_rcd_id IN NUMBER) IS
2503: SELECT Count(dtl.ext_rslt_dtl_id)
2504: FROM ben_ext_rslt_dtl dtl
2505: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
2506: AND dtl.ext_rcd_id NOT IN(c_ext_rcd_id);
2507:
2508: l_record_count Number := 0;
2509: l_rc VARCHAr2(8);

Line 2529: and ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

2525: -- Delete all hidden detail records for the all persons
2526: delete
2527: from ben_ext_rslt_dtl
2528: where ext_rcd_id = csr_rcd_rec.ext_rcd_id
2529: and ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
2530: and business_group_id = p_business_group_id;
2531: end loop;
2532: -- Get the benefit action id for the extract
2533: open csr_ben (c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id

Line 2533: open csr_ben (c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id

2529: and ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
2530: and business_group_id = p_business_group_id;
2531: end loop;
2532: -- Get the benefit action id for the extract
2533: open csr_ben (c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id
2534: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
2535: ,c_business_group_id => p_business_group_id);
2536: fetch csr_ben into l_ben_params;
2537: close csr_ben;

Line 2534: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

2530: and business_group_id = p_business_group_id;
2531: end loop;
2532: -- Get the benefit action id for the extract
2533: open csr_ben (c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id
2534: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
2535: ,c_business_group_id => p_business_group_id);
2536: fetch csr_ben into l_ben_params;
2537: close csr_ben;
2538: -- Flag the person in ben_person_actions and ben_batch_ranges

Line 2541: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id)

2537: close csr_ben;
2538: -- Flag the person in ben_person_actions and ben_batch_ranges
2539: -- as Unporcessed and errored.
2540: for err_rec in csr_err(c_bg_id => p_business_group_id
2541: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id)
2542: loop
2543: Exclude_Person
2544: (p_person_id => err_rec.person_id
2545: ,p_business_group_id => p_business_group_id

Line 2551: where dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

2547: ,p_flag_thread => 'Y');
2548:
2549: delete
2550: from ben_ext_rslt_dtl dtl
2551: where dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
2552: and dtl.person_id = err_rec.person_id
2553: and dtl.business_group_id = p_business_group_id;
2554: end loop;
2555:

Line 2559: OPEN csr_org_req(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

2555:
2556:
2557:
2558:
2559: OPEN csr_org_req(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
2560: ,c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id
2561: ,c_business_group_id => p_business_group_id);
2562: FETCH csr_org_req INTO l_conc_reqest_id;
2563: CLOSE csr_org_req;

Line 2560: ,c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id

2556:
2557:
2558:
2559: OPEN csr_org_req(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
2560: ,c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id
2561: ,c_business_group_id => p_business_group_id);
2562: FETCH csr_org_req INTO l_conc_reqest_id;
2563: CLOSE csr_org_req;
2564:

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

2564:
2565:
2566:
2567: ghr_nfc_error_proc.chk_same_day_act(p_request_id =>l_conc_reqest_id
2568: ,p_rslt_id =>Ben_Ext_Thread.g_ext_rslt_id);
2569:
2570:
2571: --Error handling call
2572: ghr_nfc_error_proc.chk_for_err_data_pa (p_request_id =>l_conc_reqest_id

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

2569:
2570:
2571: --Error handling call
2572: ghr_nfc_error_proc.chk_for_err_data_pa (p_request_id =>l_conc_reqest_id
2573: ,p_rslt_id =>Ben_Ext_Thread.g_ext_rslt_id);
2574:
2575: --Handling Total Record Count,removing the header count from total
2576: FOR csr_header_rcd_id IN csr_ext_rcd_id(c_hide_flag => 'N' -- Y=Record is hidden one
2577: ,c_rcd_type_cd => 'H') --Header

Line 2587: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

2583: Hr_Utility.set_location('Header Record ID ' ||csr_header_rcd_id.ext_rcd_id, 5);
2584: l_rc :=l_record_count;
2585: UPDATE ben_ext_rslt_dtl set val_06 = LPAD(l_rc,8,'0')
2586: WHERE ext_rcd_id = csr_header_rcd_id.ext_rcd_id
2587: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
2588: AND business_group_id= p_business_group_id;
2589:
2590: END LOOP;
2591:

Line 2594: ,p_result_id =>Ben_Ext_Thread.g_ext_rslt_id

2590: END LOOP;
2591:
2592: -- Notifications call
2593: GHR_WF.initiate_notification (p_request_id =>l_conc_reqest_id
2594: ,p_result_id =>Ben_Ext_Thread.g_ext_rslt_id
2595: ,p_role =>g_extract_params(p_business_group_id).notify);
2596:
2597: Hr_Utility.set_location('Leaving :'||l_proc_name, 25);
2598:

Line 2647: ben_ext_thread.process

2643:
2644: BEGIN
2645: hr_utility.set_location('Entering: '||l_proc_name, 5);
2646:
2647: ben_ext_thread.process
2648: (errbuf => l_errbuff,
2649: retcode => l_retcode,
2650: p_benefit_action_id => NULL,
2651: p_ext_dfn_id => p_ext_dfn_id,

Line 4389: raise; -- such that the error processing in ben_ext_thread occurs.

4385: -- this needs replaced with a message for translation.
4386: Fnd_File.put_line(Fnd_File.Log,
4387: 'Error in Advanced Conditions while processing this dynamic sql statement: ');
4388: Fnd_File.put_line(Fnd_File.Log, l_dynamic_condition);
4389: raise; -- such that the error processing in ben_ext_thread occurs.
4390: end;
4391: --
4392: if l_condition = 'T' then
4393: if xer.sprs_cd = 'A' then

Line 4571: raise; -- such that the error processing in ben_ext_thread occurs.

4567: when Others then
4568: Fnd_File.put_line(Fnd_File.Log,
4569: 'Error in Advanced Conditions while processing this dynamic sql statement: ');
4570: Fnd_File.put_line(Fnd_File.Log, l_dynamic_condition);
4571: raise; -- such that the error processing in ben_ext_thread occurs.
4572: end;
4573: --
4574: if l_condition = 'T' then
4575: if p_sprs_cd = 'A' then

Line 5289: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

5285: ,p_organization_id => p_organization_id
5286: ,p_business_group_id => g_business_group_id
5287: ,p_jurisdiction_code => null
5288: ,p_param1 => 'EXT_DFN_ID'
5289: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
5290: ,p_param2 => 'EXT_RSLT_ID'
5291: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
5292: ,p_param3 => 'EXT_PERSON_ID'
5293: ,p_param3_value => to_char(nvl(ben_ext_person.g_person_id, -1))

Line 5291: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

5287: ,p_jurisdiction_code => null
5288: ,p_param1 => 'EXT_DFN_ID'
5289: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
5290: ,p_param2 => 'EXT_RSLT_ID'
5291: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
5292: ,p_param3 => 'EXT_PERSON_ID'
5293: ,p_param3_value => to_char(nvl(ben_ext_person.g_person_id, -1))
5294: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
5295: ,p_param4_value => to_char(g_business_group_id)

Line 5366: ,c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id )

5362: end if;
5363: -- Check the Adv. Conditions for records in file
5364: for rif in csr_xrif
5365: (c_rcd_id => p_rslt_rec.ext_rcd_id
5366: ,c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id )
5367: loop
5368: Rcd_In_File
5369: (p_ext_rcd_in_file_id => rif.ext_rcd_in_file_id
5370: ,p_sprs_cd => rif.sprs_cd

Line 5396: open csr_ben (c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id

5392: ,p_val_tab => l_val_tab);
5393: end if; --IF g_total_dtl_lines
5394: elsif l_exclude_this_rcd_flag then
5395:
5396: open csr_ben (c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id
5397: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
5398: ,c_business_group_id => g_business_group_id);
5399: fetch csr_ben into l_ben_params;
5400: close csr_ben;

Line 5397: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

5393: end if; --IF g_total_dtl_lines
5394: elsif l_exclude_this_rcd_flag then
5395:
5396: open csr_ben (c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id
5397: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
5398: ,c_business_group_id => g_business_group_id);
5399: fetch csr_ben into l_ben_params;
5400: close csr_ben;
5401:

Line 5441: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

5437: begin
5438: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
5439: open csr_rslt_dtl
5440: (c_person_id => p_person_id
5441: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
5442: ,c_ext_dtl_rcd_id => p_ext_rcd_id);
5443: fetch csr_rslt_dtl into l_rslt_dtl_rec;
5444: close csr_rslt_dtl;
5445: l_no_per_rpas := g_rpa_rec.count;

Line 5521: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

5517:
5518: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
5519: open csr_rslt_dtl
5520: (c_person_id => p_person_id
5521: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
5522: ,c_ext_dtl_rcd_id => p_ext_rcd_id);
5523: fetch csr_rslt_dtl into l_rslt_dtl_rec;
5524: close csr_rslt_dtl;
5525: l_no_add_rpas := g_address_rec.count;

Line 5571: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

5567: begin
5568: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
5569: open csr_rslt_dtl
5570: (c_person_id => p_person_id
5571: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
5572: ,c_ext_dtl_rcd_id => p_ext_rcd_id);
5573: fetch csr_rslt_dtl into l_rslt_dtl_rec;
5574: close csr_rslt_dtl;
5575: l_no_per_awds := g_awd_rec.count;

Line 5659: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

5655: begin
5656: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
5657: open csr_rslt_dtl
5658: (c_person_id => p_person_id
5659: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
5660: ,c_ext_dtl_rcd_id => p_ext_rcd_id);
5661: fetch csr_rslt_dtl into l_rslt_dtl_rec;
5662: close csr_rslt_dtl;
5663: l_no_per_rpas := g_rpa_rec.COUNT;

Line 5948: where dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

5944: ,c_rcd_type_cd => 'D')
5945: loop
5946: delete
5947: from ben_ext_rslt_dtl dtl
5948: where dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
5949: and dtl.ext_rcd_id = rcd_rec.ext_rcd_id
5950: and dtl.business_group_id = g_business_group_id;
5951: end loop;
5952: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

Line 6172: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;

6168: l_Has_RPA_actions := false; l_Asg_has_Rem := false;
6169: l_Has_Award_Actions := false;
6170: l_Has_Add_chgs := false;
6171:
6172: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;
6173: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;
6174: j := p_business_group_id;
6175: g_business_group_id := p_business_group_id;
6176: g_assignment_id := p_assignment_id; -- Sundar changes.

Line 6173: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;

6169: l_Has_Award_Actions := false;
6170: l_Has_Add_chgs := false;
6171:
6172: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;
6173: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;
6174: j := p_business_group_id;
6175: g_business_group_id := p_business_group_id;
6176: g_assignment_id := p_assignment_id; -- Sundar changes.
6177: