DBA Data[Home] [Help]

APPS.GHR_US_NFC_EXTRACTS dependencies on BEN_EXTRACT

Line 2310: p_ext_rslt_id => Ben_Extract.g_ext_rslt_id);

2306: p_err_name => l_err_name,
2307: p_typ_cd => 'W',
2308: p_person_id => g_person_id,
2309: p_business_group_id => g_business_group_id,
2310: p_ext_rslt_id => Ben_Extract.g_ext_rslt_id);
2311: end if;
2312: --
2313: Hr_Utility.set_location('Exiting'||l_proc, 15);
2314: --

Line 2333: where ext_rslt_id = ben_extract.g_ext_rslt_id

2329: l_err_num number(15);
2330: --
2331: cursor err_cnt_c is
2332: select count(*) from ben_ext_rslt_err
2333: where ext_rslt_id = ben_extract.g_ext_rslt_id
2334: and typ_cd <> 'W';
2335: --
2336: begin
2337: --

Line 2368: p_ext_rslt_id => Ben_Extract.g_ext_rslt_id);

2364: p_err_name => l_err_name,
2365: p_typ_cd => 'E',
2366: p_person_id => g_person_id,
2367: p_business_group_id => g_business_group_id,
2368: p_ext_rslt_id => Ben_Extract.g_ext_rslt_id);
2369: end if;
2370: Hr_Utility.set_location('Exiting'||l_proc, 15);
2371: end Write_Error;
2372:

Line 2393: l_ext_rslt_id:= ben_extract.g_ext_rslt_id;

2389: l_error_text varchar2(2000);
2390: l_return_value varchar2(50);
2391:
2392: begin
2393: l_ext_rslt_id:= ben_extract.g_ext_rslt_id;
2394: l_return_value := '0';
2395: if g_debug then
2396: Hr_Utility.set_location('Entering : '||l_proc, 5);
2397: Hr_Utility.set_location(' l_ext_rslt_id : '||l_ext_rslt_id, 5);