DBA Data[Home] [Help]

APPS.PAY_BATCH_ELEMENT_ENTRY_API dependencies on PAY_MESSAGE_LINES

Line 2338: delete from pay_message_lines

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

Line 2356: delete from pay_message_lines

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

Line 2370: delete from pay_message_lines

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

Line 2470: delete from pay_message_lines

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

Line 2570: delete from pay_message_lines

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