[Home] [Help]
710: );
711:
712: CURSOR c_RinF_where_clause(p_ext_rcd_in_file_id IN NUMBER) IS
713: SELECT *
714: FROM ben_ext_where_clause
715: WHERE ext_rcd_in_file_id = p_ext_rcd_in_file_id
716: AND ((business_group_id IS NULL AND legislation_code IS NULL)
717: OR (legislation_code IS NOT NULL
718: AND legislation_code = p_legislation_code)
766: );
767:
768: CURSOR c_DElmt_where_clause(p_ext_data_elmt_id IN NUMBER) IS
769: SELECT *
770: FROM ben_ext_where_clause
771: WHERE ext_data_elmt_id = p_ext_data_elmt_id
772: AND ((business_group_id IS NULL AND legislation_code IS NULL)
773: OR (legislation_code IS NOT NULL
774: AND legislation_code = p_legislation_code)
777: );
778:
779: CURSOR c_DinR_where_clause(p_ext_data_elmt_in_rcd_id IN NUMBER) IS
780: SELECT *
781: FROM ben_ext_where_clause
782: WHERE ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id
783: AND ((business_group_id IS NULL AND legislation_code IS NULL)
784: OR (legislation_code IS NOT NULL
785: AND legislation_code = p_legislation_code)
1169: ,p_new_extract_name
1170: ,p_business_group_id
1171: );
1172:
1173: -- Insert new record in BEN_EXT_WHERE_CLAUSE using Row Handler
1174: ben_xwc_ins.ins
1175: (
1176: p_ext_where_clause_id => l_new_DElmt_where_clause_id -- OUT
1177: ,p_seq_num => r_curr_DElmt_where_clause.seq_num
1254: );
1255: end if ;
1256:
1257:
1258: -- Insert into BEN_EXT_WHERE_CLAUSE using Row Handler
1259: ben_xwc_ins.ins
1260: (
1261: p_ext_where_clause_id => l_new_DinR_where_clause_id -- OUT
1262: ,p_seq_num => r_curr_DinR_where_clause.seq_num
1343: );
1344: end if ;
1345:
1346:
1347: -- Insert into BEN_EXT_WHERE_CLAUSE using Row Handler
1348: ben_xwc_ins.ins
1349: (
1350: p_ext_where_clause_id => l_new_RinF_where_clause_id -- OUT
1351: ,p_seq_num => r_curr_RinF_where_clause.seq_num