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_ERROR_PROC dependencies on DUAL

Line 498: select ben_ext_rslt_dtl_s.nextval into p_val_tab.ext_rslt_dtl_id from dual;

494: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
495: -- nocopy changes
496: --l_dtl_rec_nc := p_dtl_rec;
497: -- Get the next sequence NUMBER to insert a record into the table
498: select ben_ext_rslt_dtl_s.nextval into p_val_tab.ext_rslt_dtl_id from dual;
499: insert into ben_ext_rslt_dtl
500: (ext_rslt_dtl_id
501: ,ext_rslt_id
502: ,business_group_id

Line 853: --PROCEDURE chk_dual_action

849: --p_dtl_rec := l_dtl_rec_nc;
850: raise;
851: end Ins_Rslt_Dtl;
852: ---============================================================================
853: --PROCEDURE chk_dual_action
854: ---===========================================================================
855: PROCEDURE chk_dual_action (p_request_id IN NUMBER
856: ,p_rslt_id IN NUMBER
857: )

Line 855: PROCEDURE chk_dual_action (p_request_id IN NUMBER

851: end Ins_Rslt_Dtl;
852: ---============================================================================
853: --PROCEDURE chk_dual_action
854: ---===========================================================================
855: PROCEDURE chk_dual_action (p_request_id IN NUMBER
856: ,p_rslt_id IN NUMBER
857: )
858: IS
859:

Line 860: CURSOR c_get_dual_action (cp_request_id NUMBER

856: ,p_rslt_id IN NUMBER
857: )
858: IS
859:
860: CURSOR c_get_dual_action (cp_request_id NUMBER
861: ,cp_rslt_id NUMBER
862: )
863: IS
864: SELECT COUNT (person_id) cnt

Line 874: l_proc_name Varchar2(150) := g_proc_name ||'.chk_dual_action';

870: AND berd.val_03 ='063';
871:
872: l_rslt_dtl ben_ext_rslt_dtl%ROWTYPE;
873: l_count NUMBER;
874: l_proc_name Varchar2(150) := g_proc_name ||'.chk_dual_action';
875: BEGIN
876: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
877: OPEN c_get_dual_action (p_request_id
878: ,p_rslt_id

Line 877: OPEN c_get_dual_action (p_request_id

873: l_count NUMBER;
874: l_proc_name Varchar2(150) := g_proc_name ||'.chk_dual_action';
875: BEGIN
876: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
877: OPEN c_get_dual_action (p_request_id
878: ,p_rslt_id
879: );
880: FETCH c_get_dual_action INTO l_count;
881: CLOSE c_get_dual_action;

Line 880: FETCH c_get_dual_action INTO l_count;

876: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
877: OPEN c_get_dual_action (p_request_id
878: ,p_rslt_id
879: );
880: FETCH c_get_dual_action INTO l_count;
881: CLOSE c_get_dual_action;
882: Hr_Utility.set_location('l_count: '||l_count, 5);
883:
884: IF l_count > 0 THEN

Line 881: CLOSE c_get_dual_action;

877: OPEN c_get_dual_action (p_request_id
878: ,p_rslt_id
879: );
880: FETCH c_get_dual_action INTO l_count;
881: CLOSE c_get_dual_action;
882: Hr_Utility.set_location('l_count: '||l_count, 5);
883:
884: IF l_count > 0 THEN
885: UPDATE ben_ext_rslt_dtl berd

Line 1933: --Check for individual record.

1929: CLOSE c_chk_unpick_mast;
1930:
1931:
1932: END IF;
1933: --Check for individual record.
1934: OPEN c_chk_ind_exist;
1935: FETCH c_chk_ind_exist INTO l_chk_ind_exist;
1936: CLOSE c_chk_ind_exist;
1937:

Line 2320: OR ber.name like 'DRL Individual Data Element Record - (NFC PO)')*/

2316: and bef.ext_file_id=berf.ext_file_id
2317: and ber.ext_rcd_id = berf.ext_rcd_id
2318: /* and (ber.name like '%SHRL Master Position Data Element Record - (NFC PO)'
2319: OR ber.name like '%SHRL Detail Position Data Element Record - (NFC PO)'
2320: OR ber.name like 'DRL Individual Data Element Record - (NFC PO)')*/
2321: and ber.ext_rcd_id=beder.ext_rcd_id
2322: and bede.ext_data_elmt_id = beder.ext_data_elmt_id
2323: and bede.string_val in ('S','Master Record Number06','2055'
2324: ,'Function Code26','Function Code46','Department Code03'

Line 2380: OR ber.name like 'DRL Individual Data Element Record - (NFC PO)'

2376: and bed.ext_file_id =bef.ext_file_id
2377: and bef.ext_file_id=berf.ext_file_id
2378: and ber.ext_rcd_id = berf.ext_rcd_id
2379: and ( ber.name like '%SHRL Detail Position Data Element Record - (NFC PO)'
2380: OR ber.name like 'DRL Individual Data Element Record - (NFC PO)'
2381: and ber.ext_rcd_id=beder.ext_rcd_id
2382: and bede.ext_data_elmt_id = beder.ext_data_elmt_id
2383: and bede.string_val in ('S','Master Record Number06','2056'
2384: ,'Function Code26','Department Code03'