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 BEN_EXT_RSLT

Line 10: (p_val_tab in out NOCOPY ben_ext_rslt_dtl%rowtype

6: --=================================================================
7: --upd_Rslt_Dtl
8: --================================================================
9: procedure upd_Rslt_Dtl
10: (p_val_tab in out NOCOPY ben_ext_rslt_dtl%rowtype
11: ,p_dat_tab in ben_ext_rslt_dtl%rowtype
12: ) is
13:
14: l_proc_name Varchar2(150) := g_proc_name ||'.upd_Rslt_Dtl';

Line 11: ,p_dat_tab in ben_ext_rslt_dtl%rowtype

7: --upd_Rslt_Dtl
8: --================================================================
9: procedure upd_Rslt_Dtl
10: (p_val_tab in out NOCOPY ben_ext_rslt_dtl%rowtype
11: ,p_dat_tab in ben_ext_rslt_dtl%rowtype
12: ) is
13:
14: l_proc_name Varchar2(150) := g_proc_name ||'.upd_Rslt_Dtl';
15: BEGIN

Line 486: (p_val_tab in out NOCOPY ben_ext_rslt_dtl%rowtype

482: --=================================================================
483: --Ins_Rslt_Dtl
484: --================================================================
485: procedure Ins_Rslt_Dtl
486: (p_val_tab in out NOCOPY ben_ext_rslt_dtl%rowtype
487: ,p_rslt_dtl_id out NOCOPY number
488: ) is
489:
490: l_proc_name varchar2(150) := g_proc_name||'Ins_Rslt_Dtl';

Line 491: l_dtl_rec_nc ben_ext_rslt_dtl%rowtype;

487: ,p_rslt_dtl_id out NOCOPY number
488: ) is
489:
490: l_proc_name varchar2(150) := g_proc_name||'Ins_Rslt_Dtl';
491: l_dtl_rec_nc ben_ext_rslt_dtl%rowtype;
492:
493: begin -- ins_rslt_dtl
494: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
495: -- nocopy changes

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 499: insert into ben_ext_rslt_dtl

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
503: ,ext_rcd_id

Line 865: FROM ben_ext_rslt_dtl berd

861: ,cp_rslt_id NUMBER
862: )
863: IS
864: SELECT COUNT (person_id) cnt
865: FROM ben_ext_rslt_dtl berd
866: WHERE berd.request_id =cp_request_id
867: AND berd.ext_rslt_id =cp_rslt_id
868: AND berd.val_29 ='352'
869: AND berd.val_30 ='825'

Line 872: l_rslt_dtl ben_ext_rslt_dtl%ROWTYPE;

868: AND berd.val_29 ='352'
869: AND berd.val_30 ='825'
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);

Line 885: UPDATE ben_ext_rslt_dtl berd

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
886: SET berd.val_30 = NULL
887: WHERE berd.request_id =p_request_id
888: AND berd.ext_rslt_id =p_rslt_id
889: AND berd.val_29 ='352'

Line 914: FROM ben_ext_rslt_dtl berd

910: ,cp_rslt_id NUMBER
911: )
912: IS
913: SELECT berd.*
914: FROM ben_ext_rslt_dtl berd
915: ,ben_ext_rslt_dtl berd1
916: WHERE berd.request_id =cp_request_id
917: AND berd.request_id =berd1.request_id
918: AND berd.ext_rslt_id =cp_rslt_id

Line 915: ,ben_ext_rslt_dtl berd1

911: )
912: IS
913: SELECT berd.*
914: FROM ben_ext_rslt_dtl berd
915: ,ben_ext_rslt_dtl berd1
916: WHERE berd.request_id =cp_request_id
917: AND berd.request_id =berd1.request_id
918: AND berd.ext_rslt_id =cp_rslt_id
919: AND berd.ext_rslt_id =berd1.ext_rslt_id

Line 947: FROM ben_ext_rslt_dtl berd

943: ,cp_rslt_id NUMBER
944: )
945: IS
946: SELECT berd.*
947: FROM ben_ext_rslt_dtl berd
948: ,ben_ext_rslt_dtl berd1
949: WHERE berd.request_id =cp_request_id
950: AND berd.request_id =berd1.request_id
951: AND berd.ext_rslt_id =cp_rslt_id

Line 948: ,ben_ext_rslt_dtl berd1

944: )
945: IS
946: SELECT berd.*
947: FROM ben_ext_rslt_dtl berd
948: ,ben_ext_rslt_dtl berd1
949: WHERE berd.request_id =cp_request_id
950: AND berd.request_id =berd1.request_id
951: AND berd.ext_rslt_id =cp_rslt_id
952: AND berd.ext_rslt_id =berd1.ext_rslt_id

Line 974: FROM ben_ext_rslt_dtl berd

970: ,cp_pa_request_id VARCHAR2
971: )
972: IS
973: SELECT *
974: FROM ben_ext_rslt_dtl berd
975: WHERE berd.request_id =cp_request_id
976: AND berd.ext_rslt_id =cp_rslt_id
977: AND berd.val_03 ='063'
978: AND berd.person_id=cp_person_id

Line 990: FROM ben_ext_rslt_dtl berd

986: ,cp_pa_request_id VARCHAR2
987: )
988: IS
989: SELECT *
990: FROM ben_ext_rslt_dtl berd
991: WHERE berd.request_id =cp_request_id
992: AND berd.ext_rslt_id =cp_rslt_id
993: AND berd.val_03 ='110'
994: AND berd.person_id=cp_person_id

Line 1005: l_rslt_dtl ben_ext_rslt_dtl%ROWTYPE;

1001: l_get_orig_action_aw c_get_orig_action_aw%ROWTYPE;
1002: l_flg VARCHAR2(1);
1003: l_chk_same_action c_chk_same_action%ROWTYPE;
1004: l_person_id NUMBER;
1005: l_rslt_dtl ben_ext_rslt_dtl%ROWTYPE;
1006: l_rslt NUMBER;
1007: TYPE t_rslt_dtl IS TABLE OF ben_ext_rslt_dtl%ROWTYPE
1008: INDEX BY BINARY_INTEGER;
1009: l_rslt_dtl_pa t_rslt_dtl;

Line 1007: TYPE t_rslt_dtl IS TABLE OF ben_ext_rslt_dtl%ROWTYPE

1003: l_chk_same_action c_chk_same_action%ROWTYPE;
1004: l_person_id NUMBER;
1005: l_rslt_dtl ben_ext_rslt_dtl%ROWTYPE;
1006: l_rslt NUMBER;
1007: TYPE t_rslt_dtl IS TABLE OF ben_ext_rslt_dtl%ROWTYPE
1008: INDEX BY BINARY_INTEGER;
1009: l_rslt_dtl_pa t_rslt_dtl;
1010: l_rslt_dtl_aw t_rslt_dtl;
1011: l_rslt_dtl_tmp t_rslt_dtl;

Line 1043: DELETE from ben_ext_rslt_dtl berd

1039: Caveat is there could be an approval date for future action and
1040: this may happen in a very rare case.
1041: */
1042: IF TRUNC(l_get_dup_act.approval_date) < ghr_us_nfc_extracts.g_ext_start_dt THEN
1043: DELETE from ben_ext_rslt_dtl berd
1044: WHERE berd.request_id=p_request_id
1045: AND berd.ext_rslt_id=p_rslt_id
1046: AND berd.person_id=l_chk_dup_action.person_id
1047: AND berd.Val_01 = l_chk_dup_action.val_150;

Line 1079: DELETE from ben_ext_rslt_dtl berd

1075: IF l_chk_same_action.person_id <> l_person_id THEN
1076: FOR i in 1..l_rslt_dtl_pa.count
1077: LOOP
1078: IF l_rslt_dtl_pa(i).val_29='001' THEN
1079: DELETE from ben_ext_rslt_dtl berd
1080: WHERE berd.request_id=p_request_id
1081: AND berd.ext_rslt_id=p_rslt_id
1082: AND berd.person_id=l_person_id
1083: AND (berd.Val_150 = l_rslt_dtl_pa(i).val_150

Line 1126: DELETE from ben_ext_rslt_dtl berd

1122: (p_val_tab =>l_rslt_dtl_tmp(k)
1123: ,p_rslt_dtl_id =>l_rslt
1124: ) ;
1125: CLOSE c_get_orig_action_pa;
1126: DELETE from ben_ext_rslt_dtl berd
1127: WHERE berd.ext_rslt_dtl_id IN (l_rslt_dtl.ext_rslt_dtl_id
1128: ,l_rslt_dtl_tmp(k).ext_rslt_dtl_id);
1129: END LOOP;
1130:

Line 1145: DELETE from ben_ext_rslt_dtl berd

1141: ---Check for award duplicate row
1142: FOR i in 1..l_rslt_dtl_aw.count
1143: LOOP
1144: IF l_rslt_dtl_aw(i).val_38='001' THEN
1145: DELETE from ben_ext_rslt_dtl berd
1146: WHERE berd.request_id=p_request_id
1147: AND berd.ext_rslt_id=p_rslt_id
1148: AND berd.person_id=l_person_id
1149: AND (berd.Val_55 = l_rslt_dtl_aw(i).val_55

Line 1192: DELETE from ben_ext_rslt_dtl berd

1188: ,p_rslt_dtl_id =>l_rslt
1189: ) ;
1190:
1191: CLOSE c_get_orig_action_pa;
1192: DELETE from ben_ext_rslt_dtl berd
1193: WHERE berd.ext_rslt_dtl_id IN (l_rslt_dtl.ext_rslt_dtl_id
1194: ,l_rslt_dtl_tmp(k).ext_rslt_dtl_id);
1195:
1196: END LOOP;

Line 1218: DELETE from ben_ext_rslt_dtl berd

1214: IF l_rslt_dtl_pa.count > 0 THEN
1215: FOR i in 1..l_rslt_dtl_pa.count
1216: LOOP
1217: IF l_rslt_dtl_pa(i).val_29='001' THEN
1218: DELETE from ben_ext_rslt_dtl berd
1219: WHERE berd.request_id=p_request_id
1220: AND berd.ext_rslt_id=p_rslt_id
1221: AND berd.person_id=l_person_id
1222: AND (berd.Val_150 = l_rslt_dtl_pa(i).val_150

Line 1266: DELETE from ben_ext_rslt_dtl berd

1262: (p_val_tab =>l_rslt_dtl_tmp(k)
1263: ,p_rslt_dtl_id =>l_rslt
1264: ) ;
1265: CLOSE c_get_orig_action_pa;
1266: DELETE from ben_ext_rslt_dtl berd
1267: WHERE (berd.ext_rslt_dtl_id IN (l_rslt_dtl.ext_rslt_dtl_id)
1268: OR berd.val_150 =l_rslt_dtl.val_01)
1269: AND berd.ext_rslt_dtl_id NOT IN (
1270: l_rslt_dtl_tmp(k).ext_rslt_dtl_id);

Line 1284: DELETE from ben_ext_rslt_dtl berd

1280: IF l_rslt_dtl_aw.count > 0 THEN
1281: FOR i in 1..l_rslt_dtl_aw.count
1282: LOOP
1283: IF l_rslt_dtl_aw(i).val_38='001' THEN
1284: DELETE from ben_ext_rslt_dtl berd
1285: WHERE berd.request_id=p_request_id
1286: AND berd.ext_rslt_id=p_rslt_id
1287: AND berd.person_id=l_person_id
1288: AND (berd.Val_55 = l_rslt_dtl_aw(i).val_55

Line 1330: DELETE from ben_ext_rslt_dtl berd

1326: ,p_rslt_dtl_id =>l_rslt
1327: ) ;
1328:
1329: CLOSE c_get_orig_action_pa;
1330: DELETE from ben_ext_rslt_dtl berd
1331: WHERE berd.ext_rslt_dtl_id IN (l_rslt_dtl.ext_rslt_dtl_id
1332: ,l_rslt_dtl_tmp(k).ext_rslt_dtl_id);
1333:
1334: END LOOP;

Line 1384: FROM ben_ext_rslt_dtl berd

1380: FROM ghr_pa_interface_err_dtls gpid
1381: WHERE gpid.err_doc_type='347'
1382: AND NOT EXISTS
1383: (SELECT 'Xl'
1384: FROM ben_ext_rslt_dtl berd
1385: WHERE berd.person_id=gpid.person_id
1386: AND berd.val_03=gpid.err_doc_type
1387: AND berd.request_id=p_request_id
1388: AND berd.ext_rslt_id=p_rslt_id);

Line 1400: FROM ben_ext_rslt_dtl berd

1396: ,cp_rslt_id NUMBER
1397: )
1398: IS
1399: SELECT *
1400: FROM ben_ext_rslt_dtl berd
1401: WHERE berd.person_id=cp_person_id
1402: AND berd.ext_rslt_dtl_id = cp_result_dtl_id
1403: AND berd.val_03='347'
1404: AND berd.request_id=cp_request_id

Line 1443: FROM ben_ext_rslt_dtl berd

1439: FROM ghr_pa_interface_err_dtls gpid
1440: WHERE gpid.err_doc_type=cp_doc_typ
1441: AND NOT EXISTS
1442: (SELECT 'X'
1443: FROM ben_ext_rslt_dtl berd
1444: WHERE gpid.person_id=berd.person_id
1445: AND gpid.err_doc_type=berd.val_03
1446: AND (gpid.nat_act_1st_3_pos = berd.val_29
1447: OR gpid.nat_act_1st_3_pos=berd.val_30 )

Line 1484: ,ben_ext_rslt_dtl berd

1480: ,berd.business_group_id
1481: ,DECODE(berd.val_29,'001','D','002','C') identifier
1482: ,gpid.pa_interface_err_dtl_id
1483: FROM ghr_pa_interface_err_dtls gpid
1484: ,ben_ext_rslt_dtl berd
1485: WHERE gpid.err_doc_type=cp_doc_typ
1486: AND gpid.person_id=berd.person_id
1487: AND gpid.err_doc_type=berd.val_03
1488: AND berd.val_29 IN ( '001','002')

Line 1531: FROM ben_ext_rslt_dtl berd

1527: FROM ghr_pa_interface_err_dtls gpid
1528: WHERE gpid.err_doc_type='110'
1529: AND NOT EXISTS
1530: (SELECT 'X'
1531: FROM ben_ext_rslt_dtl berd
1532: WHERE gpid.person_id=berd.person_id
1533: AND gpid.err_doc_type=berd.val_03
1534: AND (gpid.nat_act_1st_3_pos = berd.val_38
1535: OR gpid.nat_act_1st_3_pos=berd.val_30 )

Line 1572: ,ben_ext_rslt_dtl berd

1568: ,berd.business_group_id
1569: ,DECODE(berd.val_38,'001','D','002','C') identifier
1570: ,gpid.pa_interface_err_dtl_id
1571: FROM ghr_pa_interface_err_dtls gpid
1572: ,ben_ext_rslt_dtl berd
1573: WHERE gpid.err_doc_type='110'
1574: AND gpid.person_id=berd.person_id
1575: AND gpid.err_doc_type=berd.val_03
1576: AND berd.val_38 IN ( '001','002')

Line 1590: FROM ben_ext_rslt_dtl berd

1586: ,cp_rslt_id NUMBER
1587: )
1588: IS
1589: SELECT *
1590: FROM ben_ext_rslt_dtl berd
1591: WHERE berd.request_id = cp_request_id
1592: AND berd.ext_rslt_dtl_id = cp_rslt_dtl_id
1593: AND berd.ext_rslt_id =cp_rslt_id
1594: AND berd.ext_rcd_id =cp_rcd_id

Line 1603: FROM ben_ext_rslt_dtl berd

1599: ,cp_person_id NUMBER
1600: )
1601: IS
1602: SELECT *
1603: FROM ben_ext_rslt_dtl berd
1604: WHERE berd.request_id = cp_request_id
1605: AND berd.val_02='RMK'
1606: AND berd.val_01=cp_pa_req
1607: AND berd.person_id=cp_person_id

Line 1611: l_rslt_dtl ben_ext_rslt_dtl%ROWTYPE;

1607: AND berd.person_id=cp_person_id
1608: ;
1609:
1610: l_chk_data_in_file_aw c_chk_data_in_file_aw%ROWTYPE;
1611: l_rslt_dtl ben_ext_rslt_dtl%ROWTYPE;
1612: l_get_prev_data c_get_prev_data%ROWTYPE;
1613: l_chk_err_exist c_chk_err_exist%ROWTYPE;
1614: l_chk_data_in_file c_chk_data_in_file%ROWTYPE;
1615: l_get_prev_rmk_data c_get_prev_rmk_data%ROWTYPE;

Line 1618: l_rslt_dtl_temp ben_ext_rslt_dtl%ROWTYPE;

1614: l_chk_data_in_file c_chk_data_in_file%ROWTYPE;
1615: l_get_prev_rmk_data c_get_prev_rmk_data%ROWTYPE;
1616: l_rslt_dtl_id NUMBER;
1617: l_chk_add_in_file c_chk_add_in_file%ROWTYPE;
1618: l_rslt_dtl_temp ben_ext_rslt_dtl%ROWTYPE;
1619: l_proc_name Varchar2(150) := g_proc_name ||'.c_get_prev_val_add';
1620:
1621: BEGIN
1622: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 1675: UPDATE ben_ext_rslt_dtl berd

1671: DELETE FROM ghr_pa_interface_err_dtls perr
1672: WHERE pa_interface_err_dtl_id = l_chk_data_in_file.pa_interface_err_dtl_id;
1673: --
1674: ELSIF l_chk_data_in_file.identifier='C' THEN
1675: UPDATE ben_ext_rslt_dtl berd
1676: SET berd.val_29 = l_chk_data_in_file.nat_act_1st_3_pos
1677: ,berd.val_30=NULL
1678: ,berd.val_150=null
1679: WHERE berd.request_id=p_request_id

Line 1686: DELETE FROM ben_ext_rslt_dtl berd

1682: AND berd.ext_rslt_dtl_id=l_chk_data_in_file.ext_rslt_dtl_id;
1683:
1684:
1685: ELSIF l_chk_data_in_file.identifier='D' THEN
1686: DELETE FROM ben_ext_rslt_dtl berd
1687: WHERE berd.ext_rslt_dtl_id=l_chk_data_in_file.ext_rslt_dtl_id;
1688:
1689: END IF;
1690: END LOOP;

Line 1721: UPDATE ben_ext_rslt_dtl berd

1717: DELETE FROM ghr_pa_interface_err_dtls perr
1718: WHERE pa_interface_err_dtl_id = l_chk_data_in_file_aw.pa_interface_err_dtl_id;
1719: --
1720: ELSIF l_chk_data_in_file_aw.identifier='C' THEN
1721: UPDATE ben_ext_rslt_dtl berd
1722: SET berd.val_38=NULL
1723: --, berd.val_38 = l_chk_data_in_file.nat_act_1st_3_pos
1724: --,berd.val_30=NULL
1725: ,berd.val_55=NULL

Line 1733: DELETE FROM ben_ext_rslt_dtl berd

1729: AND berd.ext_rslt_dtl_id=l_chk_data_in_file_aw.ext_rslt_dtl_id;
1730:
1731:
1732: ELSIF l_chk_data_in_file_aw.identifier='D' THEN
1733: DELETE FROM ben_ext_rslt_dtl berd
1734: WHERE berd.ext_rslt_dtl_id=l_chk_data_in_file_aw.ext_rslt_dtl_id;
1735:
1736: END IF;
1737: END LOOP;

Line 1792: FROM ben_ext_rslt_dtl berd

1788: ,cp_record_id NUMBER
1789: )
1790: IS
1791: SELECT *
1792: FROM ben_ext_rslt_dtl berd
1793: WHERE berd.request_id = cp_request_id
1794: AND berd.ext_rslt_dtl_id=cp_result_dtl_id
1795: AND berd.ext_rcd_id =cp_record_id;
1796:

Line 1810: FROM ben_ext_rslt_dtl berd

1806: SELECT berd.val_71 position_id,
1807: berd.val_26 f_function_cd,
1808: gpid.susp_function_cd e_function_cd,
1809: gpid.pos_interface_err_dtl_id
1810: FROM ben_ext_rslt_dtl berd
1811: ,ghr_pos_interface_err_dtls gpid
1812: WHERE TO_CHAR(gpid.position_id) = berd.val_71
1813: AND gpid.susp_mast_indv ='2055'
1814: AND gpid.susp_mast_indv=berd.val_02

Line 1825: FROM ben_ext_rslt_dtl berd

1821: SELECT *
1822: FROM ghr_pos_interface_err_dtls gpid
1823: WHERE NOT EXISTS (
1824: SELECT 'X'
1825: FROM ben_ext_rslt_dtl berd
1826: WHERE to_char(gpid.position_id) = berd.val_71
1827: AND gpid.susp_mast_indv ='2055'
1828: AND gpid.susp_mast_indv=berd.val_02
1829: AND berd.request_id=p_request_id

Line 1847: FROM ben_ext_rslt_dtl berd

1843: SELECT berd.val_71 position_id,
1844: berd.val_45 f_function_cd,
1845: gpid.susp_function_cd e_function_cd,
1846: gpid.pos_interface_err_dtl_id
1847: FROM ben_ext_rslt_dtl berd
1848: ,ghr_pos_interface_err_dtls gpid
1849: WHERE to_char(gpid.position_id) = berd.val_71
1850: AND gpid.susp_mast_indv ='2056'
1851: AND gpid.susp_mast_indv=berd.val_02

Line 1863: FROM ben_ext_rslt_dtl berd

1859: SELECT *
1860: FROM ghr_pos_interface_err_dtls gpid
1861: WHERE NOT EXISTS (
1862: SELECT 'X'
1863: FROM ben_ext_rslt_dtl berd
1864: WHERE to_char(gpid.position_id) = berd.val_71
1865: AND gpid.susp_mast_indv ='2056'
1866: AND gpid.susp_mast_indv=berd.val_02
1867: AND berd.request_id=p_request_id

Line 1877: l_rslt_dtl ben_ext_rslt_dtl%ROWTYPE;

1873: l_chk_mast_exist c_chk_mast_exist%ROWTYPE;
1874: l_chk_ind_exist c_chk_ind_exist%ROWTYPE;
1875: l_chk_ind_err c_chk_ind_err%ROWTYPE;
1876: l_chk_mast_err c_chk_mast_err%ROWTYPE;
1877: l_rslt_dtl ben_ext_rslt_dtl%ROWTYPE;
1878: l_prev_ext_rslt c_prev_ext_rslt%ROWTYPE;
1879: l_rslt_dtl_id NUMBER;
1880: l_chk_unpick_ind c_chk_unpick_ind%ROWTYPE;
1881: l_proc_name Varchar2(150) := g_proc_name ||'.chk_for_err_data_pos';

Line 1895: UPDATE ben_ext_rslt_dtl berd

1891: FETCH c_chk_mast_err INTO l_chk_mast_err;
1892: EXIT WHEN c_chk_mast_err%NOTFOUND;
1893: IF l_chk_mast_err.e_function_cd <> l_chk_mast_err.f_function_cd THEN
1894:
1895: UPDATE ben_ext_rslt_dtl berd
1896: SET berd.val_26=l_chk_mast_err.e_function_cd
1897: WHERE berd.val_71 = to_char(l_chk_mast_err.position_id)
1898: AND berd.request_id=p_request_id
1899: AND berd.val_02='2055';

Line 1945: UPDATE ben_ext_rslt_dtl berd

1941: FETCH c_chk_ind_err INTO l_chk_ind_err;
1942: EXIT WHEN c_chk_ind_err%NOTFOUND;
1943: IF l_chk_ind_err.e_function_cd <> l_chk_ind_err.f_function_cd THEN
1944:
1945: UPDATE ben_ext_rslt_dtl berd
1946: SET berd.val_45=l_chk_ind_err.e_function_cd
1947: WHERE berd.val_71 =TO_CHAR( l_chk_ind_err.position_id)
1948: AND berd.request_id=p_request_id
1949: AND berd.val_02='2056';

Line 2044: ' from ben_ext_rslt_dtl

2040: ||p_pay_per_num||','
2041: ||p_auth_dt||','
2042: ||p_doc_typ||','
2043: ||p_eff_dt||
2044: ' from ben_ext_rslt_dtl
2045: where request_id = :1
2046: and ext_rcd_id = :2
2047: and '||p_status||' = '||'''E''' ;
2048:

Line 2196: ' from ben_ext_rslt_dtl

2192: ||p_mrn||','
2193: ||p_grade||','
2194: ||p_pos_num||','
2195: ||p_incumbant_ssn||
2196: ' from ben_ext_rslt_dtl
2197: where request_id = :1
2198: and ext_rcd_id = :2
2199: and '||p_status||' = '||'''E''' ;
2200: open l_cur for l_stmt

Line 2306: from ben_ext_rslt bes

2302: IS
2303: select beder.seq_num
2304: ,bede.string_val
2305: ,ber.ext_rcd_id record_id
2306: from ben_ext_rslt bes
2307: ,ben_ext_dfn bed
2308: ,ben_ext_file bef
2309: ,ben_ext_rcd_in_file berf
2310: ,ben_ext_rcd ber

Line 2336: from ben_ext_rslt bes

2332: IS
2333: select beder.seq_num
2334: ,bede.string_val
2335: ,ber.ext_rcd_id record_id
2336: from ben_ext_rslt bes
2337: ,ben_ext_dfn bed
2338: ,ben_ext_file bef
2339: ,ben_ext_rcd_in_file berf
2340: ,ben_ext_rcd ber

Line 2367: from ben_ext_rslt bes

2363: IS
2364: select beder.seq_num
2365: ,bede.string_val
2366: ,ber.ext_rcd_id record_id
2367: from ben_ext_rslt bes
2368: ,ben_ext_dfn bed
2369: ,ben_ext_file bef
2370: ,ben_ext_rcd_in_file berf
2371: ,ben_ext_rcd ber

Line 2712: FROM ben_ext_rslt_dtl berd

2708: ,cp_rslt_id NUMBER
2709: )
2710: IS
2711: SELECT berd.*
2712: FROM ben_ext_rslt_dtl berd
2713: WHERE berd.request_id =cp_request_id
2714: AND berd.ext_rslt_id =cp_rslt_id
2715: AND ( (berd.val_03 ='063'
2716: AND berd.val_29 IN ('001','002')

Line 2728: FROM ben_ext_rslt_dtl berd

2724: CURSOR c_berd_values(cp_request_id NUMBER,
2725: cp_rslt_id NUMBER,
2726: cp_val_01 VARCHAR2) IS
2727: SELECT berd.*
2728: FROM ben_ext_rslt_dtl berd
2729: WHERE berd.request_id =cp_request_id
2730: AND berd.ext_rslt_id =cp_rslt_id
2731: AND berd.val_01 = cp_val_01;
2732:

Line 2773: l_berd_original ben_ext_rslt_dtl%rowtype;

2769: l_canc_pa_request_id ghr_pa_requests.pa_request_id%type;
2770: l_first_noa_code ghr_pa_requests.first_noa_code%type;
2771: l_second_noa_code ghr_pa_requests.second_noa_code%type;
2772: l_person_id ghr_pa_requests.person_id%type;
2773: l_berd_original ben_ext_rslt_dtl%rowtype;
2774: l_berd_corrected ben_ext_rslt_dtl%rowtype;
2775: TYPE t_correct_records IS TABLE OF ben_ext_rslt_dtl%rowtype INDEX BY PLS_INTEGER;
2776: l_correct_records t_correct_records;
2777: l_result NUMBER;

Line 2774: l_berd_corrected ben_ext_rslt_dtl%rowtype;

2770: l_first_noa_code ghr_pa_requests.first_noa_code%type;
2771: l_second_noa_code ghr_pa_requests.second_noa_code%type;
2772: l_person_id ghr_pa_requests.person_id%type;
2773: l_berd_original ben_ext_rslt_dtl%rowtype;
2774: l_berd_corrected ben_ext_rslt_dtl%rowtype;
2775: TYPE t_correct_records IS TABLE OF ben_ext_rslt_dtl%rowtype INDEX BY PLS_INTEGER;
2776: l_correct_records t_correct_records;
2777: l_result NUMBER;
2778: TYPE t_skip_records IS TABLE OF NUMBER INDEX BY PLS_INTEGER;

Line 2775: TYPE t_correct_records IS TABLE OF ben_ext_rslt_dtl%rowtype INDEX BY PLS_INTEGER;

2771: l_second_noa_code ghr_pa_requests.second_noa_code%type;
2772: l_person_id ghr_pa_requests.person_id%type;
2773: l_berd_original ben_ext_rslt_dtl%rowtype;
2774: l_berd_corrected ben_ext_rslt_dtl%rowtype;
2775: TYPE t_correct_records IS TABLE OF ben_ext_rslt_dtl%rowtype INDEX BY PLS_INTEGER;
2776: l_correct_records t_correct_records;
2777: l_result NUMBER;
2778: TYPE t_skip_records IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
2779: l_skip_records t_skip_records;

Line 2950: FROM ben_ext_rslt_dtl berd

2946: FOR l_recs IN l_del_rec.FIRST..l_del_rec.LAST LOOP
2947: debug_prg('RPA Id: ' || l_del_rec(l_recs));
2948: -- Deletion code here
2949: DELETE
2950: FROM ben_ext_rslt_dtl berd
2951: WHERE berd.request_id= p_request_id
2952: AND berd.ext_rslt_id = p_rslt_id
2953: AND val_01 = TO_CHAR(l_del_rec(l_recs));
2954: -- -- Bug 4937846