APPS.BEN_COPY_EXTRACT dependencies on BEN_EXT_RCD

Line 250: FROM ben_ext_rcd_in_file

246: CURSOR c_new_data_elmt_in_rcd_id IS
247: SELECT ext_data_elmt_in_rcd_id
248: FROM ben_ext_data_elmt_in_rcd
249: WHERE ext_rcd_id = (SELECT ext_rcd_id
250: FROM ben_ext_rcd_in_file
251: WHERE ext_rcd_in_file_id = p_new_rcd_in_file_id
252: )
253: AND ext_data_elmt_id = (SELECT ext_data_elmt_id
254: FROM ben_ext_data_elmt

Line 293: FROM ben_ext_rcd

289: ) RETURN NUMBER IS
290:
291: CURSOR c_new_rcd_id IS
292: SELECT ext_rcd_id
293: FROM ben_ext_rcd
294: WHERE (p_business_group_id is null
295: or p_business_group_id = business_group_id)
296: and name = (SELECT fix_name_length(p_new_extract_name||' '||name
297: ,c_ExtName_Maxlen)

Line 298: FROM ben_ext_rcd

294: WHERE (p_business_group_id is null
295: or p_business_group_id = business_group_id)
296: and name = (SELECT fix_name_length(p_new_extract_name||' '||name
297: ,c_ExtName_Maxlen)
298: FROM ben_ext_rcd
299: WHERE ext_rcd_id = p_curr_rcd_id);
300:
301: l_new_rcd_id NUMBER(15) := NULL;
302: l_proc VARCHAR2(72) := g_package||'get_new_rcd_id';

Line 689: FROM ben_ext_rcd_in_file RinF, ben_ext_rcd Rcd

685: );
686:
687: CURSOR c_ext_rcd_in_file(p_ext_file_id IN NUMBER) IS
688: SELECT RinF.*
689: FROM ben_ext_rcd_in_file RinF, ben_ext_rcd Rcd
690: WHERE RinF.ext_file_id = p_ext_file_id
691: AND RinF.ext_rcd_id = Rcd.ext_rcd_id
692: AND ((RinF.business_group_id IS NULL AND RinF.legislation_code IS NULL)
693: OR (RinF.legislation_code IS NOT NULL

Line 703: FROM ben_ext_rcd

699: ,RinF.seq_num;
700:
701: CURSOR c_ext_rcd(p_ext_rcd_id IN NUMBER) IS
702: SELECT *
703: FROM ben_ext_rcd
704: WHERE ext_rcd_id = p_ext_rcd_id
705: AND ((business_group_id IS NULL AND legislation_code IS NULL)
706: OR (legislation_code IS NOT NULL
707: AND legislation_code = p_legislation_code)

Line 902: BEGIN -- Insert into BEN_EXT_RCD using Row Handler

898: order by Record Type(Detail, then Header, then Trailer) */
899: FOR r_curr_ext_rcd IN c_ext_rcd(r_curr_ext_rcd_in_file.ext_rcd_id)
900: LOOP -- 8 Get Record data for current EXT_RCD_ID
901:
902: BEGIN -- Insert into BEN_EXT_RCD using Row Handler
903: l_rcd_present := FALSE;
904: ben_xrc_ins.ins
905: (
906: p_ext_rcd_id => l_new_ext_rcd_id -- OUT

Line 963: END; -- Insert into BEN_EXT_RCD using Row Handler

959: ,p_business_group_id
960: );
961: END IF;
962:
963: END; -- Insert into BEN_EXT_RCD using Row Handler
964:
965: -- Insert into BEN_EXT_RCD_IN_FILE using Row Handler
966: ben_xrf_ins.ins
967: (

Line 965: -- Insert into BEN_EXT_RCD_IN_FILE using Row Handler

961: END IF;
962:
963: END; -- Insert into BEN_EXT_RCD using Row Handler
964:
965: -- Insert into BEN_EXT_RCD_IN_FILE using Row Handler
966: ben_xrf_ins.ins
967: (
968: p_ext_rcd_in_file_id => l_new_ext_rcd_in_file_id -- OUT
969: ,p_seq_num => r_curr_ext_rcd_in_file.seq_num