APPS.PAY_MIX_ROLLBACK_PKG dependencies on PAY_BATCH_CONTROL_TOTALS

Line 195: from pay_batch_control_totals pct

191: and l_batch_line.element_type_id is null;
192:
193: cursor csr_control_lines (p_batch_id number) is
194: select pct.batch_control_id
195: from pay_batch_control_totals pct
196: where pct.batch_id = p_batch_id;
197:
198: l_ctl_rec csr_control_lines%ROWTYPE;
199:

Line 513: update pay_batch_control_totals

509: update pay_batch_headers
510: set batch_status = 'U'
511: where batch_id = p_batch_header_id;
512: --
513: update pay_batch_control_totals
514: set control_status = 'U'
515: where batch_id = p_batch_header_id;
516: --
517: for l_ctl_rec in csr_control_lines(p_batch_header_id) loop

Line 545: update pay_batch_control_totals

541: else
542: --
543: if (p_asg_action_id is null and p_commit_all_or_nothing='N') then
544: --
545: update pay_batch_control_totals
546: set control_status = 'U'
547: where batch_id = p_batch_header_id;
548: --
549: for l_ctl_rec in csr_control_lines(p_batch_header_id) loop

Line 641: from pay_batch_control_totals pct

637: select 'Y'
638: from dual
639: where exists
640: (select null
641: from pay_batch_control_totals pct
642: where pct.batch_id = p_batch_id
643: and pct.control_status <> 'U')
644: and exists
645: (select null

Line 657: from pay_batch_control_totals pct

653: and pbh.batch_status = 'T');
654: --
655: cursor csr_control_lines (p_batch_id number) is
656: select pct.batch_control_id
657: from pay_batch_control_totals pct
658: where pct.batch_id = p_batch_id;
659: -- For bug 8971846
660: /*Bug 10152705 Added join of concurrent_program_name = 'UNDO_MIX' to avoid picking for normal ROLLBACK process */
661: cursor csr_parent_req_id (p_request_id NUMBER) is

Line 735: update pay_batch_control_totals

731: end loop;
732: --
733: payplnk.g_payplnk_call := true;
734: --
735: update pay_batch_control_totals
736: set control_status = 'U'
737: where batch_id = l_rec.batch_id;
738: --
739: payplnk.g_payplnk_call := false;