[Home] [Help]
631: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_request_id: '|| p_request_id );
632: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_template_id: '|| p_template_id );
633:
634: -- fetch a list of billing document id based on the inputted parameters
635: -- and insert into the ar_bpa_print_requests table
636:
637: insert_stmt := ' insert into ar_bpa_print_requests (request_id, payment_schedule_id,
638: worker_id, created_by, creation_date,last_updated_by, last_update_date)';
639:
633:
634: -- fetch a list of billing document id based on the inputted parameters
635: -- and insert into the ar_bpa_print_requests table
636:
637: insert_stmt := ' insert into ar_bpa_print_requests (request_id, payment_schedule_id,
638: worker_id, created_by, creation_date,last_updated_by, last_update_date)';
639:
640: /*Bug 8486880*/
641: select_stmt := ' select ' || m_request_id || ', to_number(cons_billing_number), rownum, 1, sysdate, 1, sysdate from '
687:
688: -- update the last printed date for all the transactions that are being printed.
689: -- bug 6955957
690: update ra_customer_trx_all trx set trx.printing_last_printed = sysdate where trx.trx_number in
691: (select cons.trx_number from ar_cons_inv_trx_all cons, ar_bpa_print_requests pri
692: where pri.request_id = m_request_id
693: and pri.payment_schedule_id = cons.cons_inv_id
694: );
695:
703: l_low_range := 1 ;
704: l_high_range := row_counts_perworker ;
705:
706: LOOP
707: UPDATE ar_bpa_print_requests
708: SET worker_id = l_worker_id
709: WHERE request_id = m_request_id
710: AND worker_id BETWEEN l_low_range AND l_high_range;
711:
792: END IF;
793: END;
794: END IF;
795:
796: DELETE FROM ar_bpa_print_requests
797: WHERE request_id = m_request_id;
798:
799: COMMIT;
800:
922: x_req_id_list := x_req_id_list ||','|| l_request_id;
923: END IF;
924:
925: FORALL i in l_low_range .. l_high_range
926: INSERT INTO ar_bpa_print_requests (
927: request_id,
928: payment_schedule_id,
929: worker_id,
930: created_by,