774: -- Create new consolidation set
775: --
776: l_sc_consoset_name := 'Separate Check Consolidation';
777: --
778: SELECT pay_consolidation_sets_s.nextval
779: INTO l_sc_consoset_id
780: FROM sys.dual;
781: --
782: INSERT INTO pay_consolidation_sets (
778: SELECT pay_consolidation_sets_s.nextval
779: INTO l_sc_consoset_id
780: FROM sys.dual;
781: --
782: INSERT INTO pay_consolidation_sets (
783: CONSOLIDATION_SET_ID,
784: BUSINESS_GROUP_ID,
785: CONSOLIDATION_SET_NAME)
786: VALUES ( l_sc_consoset_id,
858: commit;
859: --
860: end loop;
861: --
862: DELETE from pay_consolidation_sets
863: WHERE consolidation_set_id = l_sc_preact_id;
864: --
865: delete_sepcheck_asg_set;
866: --