[Home] [Help]
99: pay_wc_funds to delete_org_detail.
100: Added new procedure delete_location.
101: 70.25 15-oct-95 akelly Removed delete_location.
102: 70.26 17-OCT-95 nbristow Added delete_bal_load_struct to delete
103: from pay_balance_batch_headers and
104: pay_balance_batch_lines.
105: 70.27 31-OCT-95 Kev Koh Enhanced delete_secure_objects with
106: delete cursor
107: 70.28 31-OCT-95 Kev Koh Enhanced delete_secure_objects and
150: a. delete_secure_objects :
151: Re-enabled use of business group index
152: in person_list cursor
153: b. delete_bal_load_struct :
154: Split PAY_BALANCE_BATCH_HEADERS cursor
155: into two separate statements.
156: 70.39 18-SEP-96 GPerry Added per_estab_attendances to per
157: misc delete block.
158: 70.40 18-SEP-96 M.J.Hoyes a Removed all code which suppressed
180:
181: 70.43 06-OCT-96 D.Kerr Temporarily removed delete_competence_detail
182: during 10.7/Prod15 release phase
183: 70.44 11-NOV-96 N.Bristow Uncommented the deletion from
184: pay_balance_batch_headers and
185: pay_balance_batch_lines.
186: 70.45 18-NOV-96 Tmathers Added p_rt_running parameter to allow
187: Rt's once again to be re-runnable.
188: 70.46 12-MAR-97 DLo 1 Added delete statements to
398: --
399: CURSOR pbh IS
400: SELECT bh.batch_id,
401: bh.batch_status
402: FROM pay_balance_batch_headers bh
403: WHERE ( (bh.business_group_id = p_business_group_id)
404: OR ( upper(bh.business_group_name) = upper(l_business_group_name)) );
405: --
406: CURSOR pbl (p_batch in number) IS
433: end if;
434: DELETE FROM pay_balance_batch_lines bl
435: WHERE bl.batch_id = pbhrec.batch_id;
436: --
437: DELETE FROM pay_balance_batch_headers bh
438: WHERE bh.batch_id = pbhrec.batch_id;
439: END LOOP;
440: --
441: hr_utility.set_location('hr_delete.delete_bal_load_struct',99);