2334: for cssr in csr_batch_lines loop
2335: --
2336: -- Deletes all messages
2337: --
2338: delete from pay_message_lines
2339: where SOURCE_TYPE = 'L'
2340: and SOURCE_ID = cssr.batch_line_id;
2341: --
2342: pay_btl_del.del
2352: for cssr in csr_batch_ctl_totals loop
2353: --
2354: -- Deletes all messages
2355: --
2356: delete from pay_message_lines
2357: where SOURCE_TYPE = 'C'
2358: and SOURCE_ID = cssr.batch_control_id;
2359: --
2360: pay_bct_del.del
2366: hr_utility.set_location(l_proc, 15);
2367: --
2368: -- Deletes all messages
2369: --
2370: delete from pay_message_lines
2371: where SOURCE_TYPE = 'H'
2372: and SOURCE_ID = p_batch_id;
2373: --
2374: -- Deletes the batch header
2466: --
2467: --
2468: -- Deletes all messages
2469: --
2470: delete from pay_message_lines
2471: where SOURCE_TYPE = 'L'
2472: and SOURCE_ID = p_batch_line_id;
2473: --
2474: -- Deletes the batch line
2566: --
2567: --
2568: -- Deletes all messages
2569: --
2570: delete from pay_message_lines
2571: where SOURCE_TYPE = 'C'
2572: and SOURCE_ID = p_batch_control_id;
2573: --
2574: -- Deletes the batch header