[Home] [Help]
119: --
120: CURSOR csr_get_ext_rslt_id
121: IS
122: SELECT ext_rslt_id
123: FROM ben_ext_rslt
124: WHERE request_id = p_request_id
125: AND ext_dfn_id = p_ext_dfn_id;
126:
127: l_ext_rslt_id NUMBER;
210: --
211: CURSOR csr_get_dtl_cnt
212: IS
213: SELECT COUNT(*)
214: FROM ben_ext_rslt_dtl xrd
215: WHERE xrd.ext_rslt_id = p_ext_rslt_id;
216: --
217: -- Cursor to get person record count
218: --
218: --
219: CURSOR csr_get_per_cnt
220: IS
221: SELECT COUNT(DISTINCT person_id)
222: FROM ben_ext_rslt_dtl xrd
223: WHERE xrd.ext_rslt_id = p_ext_rslt_id
224: AND person_id not in (0, 999999999999);
225: --
226: -- Cursor to get error record count
227: --
228: CURSOR csr_get_err_cnt
229: IS
230: SELECT COUNT(*)
231: FROM ben_ext_rslt_err err
232: WHERE err.ext_rslt_id = p_ext_rslt_id;
233:
234: l_hdr_count NUMBER;
235: l_dtl_count NUMBER;
493: val_73,
494: val_74,
495: val_75,
496: business_group_id
497: FROM ben_ext_rslt_dtl
498: WHERE ext_rslt_id = c_ext_rslt_id;
499:
500: l_ext_rslt_dtl_rec csr_get_ext_rslt_dtl%ROWTYPE;
501:
527: program_application_id,
528: program_id,
529: program_update_date,
530: ext_rslt_id
531: FROM ben_ext_rslt_err
532: WHERE ext_rslt_id = c_ext_rslt_id;
533:
534: l_ext_rslt_err_rec csr_get_ext_rslt_err%ROWTYPE;
535:
617: DEBUG (l_proc_name, l_proc_step);
618: END IF;
619:
620: -- Create a copy
621: ben_ext_rslt_dtl_api.create_ext_rslt_dtl
622: (p_validate => FALSE
623: ,p_ext_rslt_dtl_id => l_ext_rslt_dtl_id
624: ,p_prmy_sort_val => l_ext_rslt_dtl_rec.prmy_sort_val
625: ,p_scnd_sort_val => l_ext_rslt_dtl_rec.scnd_sort_val
742: l_proc_step := 60;
743: DEBUG (l_proc_name, l_proc_step);
744: END IF;
745:
746: ben_ext_rslt_err_api.create_ext_rslt_err
747: (p_validate => FALSE
748: ,p_ext_rslt_err_id => l_ext_rslt_err_id
749: ,p_err_num => l_ext_rslt_err_rec.err_num
750: ,p_err_txt => l_ext_rslt_err_rec.err_txt
813: ,ext_strt_dt
814: ,ext_end_dt
815: ,drctry_name
816: ,output_name
817: FROM ben_ext_rslt
818: WHERE request_id = c_request_id
819: AND ext_dfn_id = p_ext_dfn_id
820: AND business_group_id = p_master_business_group;
821:
850: l_err_count NUMBER := 0;
851: l_tot_count NUMBER := 0;
852: l_output_name VARCHAR2(200); -- Do not use type
853: l_request_id NUMBER;
854: l_val_02 ben_ext_rslt_dtl.val_02%TYPE;
855: l_val_03 ben_ext_rslt_dtl.val_03%TYPE;
856: l_proc_name VARCHAR2 (80) := g_proc_name
857: || 'copy_extract_results';
858: l_proc_step NUMBER;
851: l_tot_count NUMBER := 0;
852: l_output_name VARCHAR2(200); -- Do not use type
853: l_request_id NUMBER;
854: l_val_02 ben_ext_rslt_dtl.val_02%TYPE;
855: l_val_03 ben_ext_rslt_dtl.val_03%TYPE;
856: l_proc_name VARCHAR2 (80) := g_proc_name
857: || 'copy_extract_results';
858: l_proc_step NUMBER;
859:
962: fnd_file.put_line(fnd_file.log, 'Master Request ID: '
963: || TO_CHAR(l_master_request_id));
964: fnd_file.put_line(fnd_file.log, ' ');
965:
966: ben_ext_rslt_api.create_ext_rslt
967: (p_validate => FALSE
968: ,p_ext_rslt_id => l_master_ext_rslt_id
969: ,p_run_strt_dt => SYSDATE
970: ,p_run_end_dt => NULL
1065: l_proc_step := 90;
1066: DEBUG (l_proc_name, l_proc_step);
1067: END IF;
1068:
1069: UPDATE ben_ext_rslt_dtl rslt
1070: SET val_02 = l_val_02
1071: ,val_03 = l_val_03
1072: WHERE ext_rslt_id = l_master_ext_rslt_id
1073: AND EXISTS ( SELECT 1 FROM ben_ext_rcd rcd
1088: l_proc_step := 100;
1089: DEBUG (l_proc_name, l_proc_step);
1090: END IF;
1091:
1092: ben_ext_rslt_api.update_ext_rslt
1093: (p_validate => FALSE
1094: ,p_ext_rslt_id => l_master_ext_rslt_id
1095: ,p_run_end_dt => SYSDATE
1096: ,p_ext_stat_cd => 'E'
1112: l_proc_step := 110;
1113: DEBUG (l_proc_name, l_proc_step);
1114: END IF;
1115:
1116: ben_ext_rslt_api.update_ext_rslt
1117: (p_validate => FALSE
1118: ,p_ext_rslt_id => l_master_ext_rslt_id
1119: ,p_run_end_dt => SYSDATE
1120: ,p_ext_stat_cd => 'S'