APPS.AR_BPA_BFPRI_CONC dependencies on AR_BPA_PRINT_REQUESTS

Line 625: -- and insert into the ar_bpa_print_requests table

621: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_request_id: '|| p_request_id );
622: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_template_id: '|| p_template_id );
623:
624: -- fetch a list of billing document id based on the inputted parameters
625: -- and insert into the ar_bpa_print_requests table
626:
627: insert_stmt := ' insert into ar_bpa_print_requests (request_id, payment_schedule_id,
628: worker_id, created_by, creation_date,last_updated_by, last_update_date)';
629: select_stmt := ' select ' || m_request_id || ', to_number(cons_billing_number), rownum, 1, sysdate, 1, sysdate from '

Line 627: insert_stmt := ' insert into ar_bpa_print_requests (request_id, payment_schedule_id,

623:
624: -- fetch a list of billing document id based on the inputted parameters
625: -- and insert into the ar_bpa_print_requests table
626:
627: insert_stmt := ' insert into ar_bpa_print_requests (request_id, payment_schedule_id,
628: worker_id, created_by, creation_date,last_updated_by, last_update_date)';
629: select_stmt := ' select ' || m_request_id || ', to_number(cons_billing_number), rownum, 1, sysdate, 1, sysdate from '
630: || cr ||' ( select cons.cons_billing_number '|| cr || build_from_clause ||
631: ' AND nvl(a_bill.language,' || '''' || base_lang || ''') = ' || '''' || userenv_lang || '''' ;

Line 679: (select cons.trx_number from ar_cons_inv_trx_all cons, ar_bpa_print_requests pri

675:
676: -- update the last printed date for all the transactions that are being printed.
677: -- bug 6955957
678: update ra_customer_trx_all trx set trx.printing_last_printed = sysdate where trx.trx_number in
679: (select cons.trx_number from ar_cons_inv_trx_all cons, ar_bpa_print_requests pri
680: where pri.request_id = m_request_id
681: and pri.payment_schedule_id = cons.cons_inv_id
682: );
683:

Line 695: UPDATE ar_bpa_print_requests

691: l_low_range := 1 ;
692: l_high_range := row_counts_perworker ;
693:
694: LOOP
695: UPDATE ar_bpa_print_requests
696: SET worker_id = l_worker_id
697: WHERE request_id = m_request_id
698: AND worker_id BETWEEN l_low_range AND l_high_range;
699:

Line 784: DELETE FROM ar_bpa_print_requests

780: END IF;
781: END;
782: END IF;
783:
784: DELETE FROM ar_bpa_print_requests
785: WHERE request_id = m_request_id;
786:
787: COMMIT;
788:

Line 914: INSERT INTO ar_bpa_print_requests (

910: x_req_id_list := x_req_id_list ||','|| l_request_id;
911: END IF;
912:
913: FORALL i in l_low_range .. l_high_range
914: INSERT INTO ar_bpa_print_requests (
915: request_id,
916: payment_schedule_id,
917: worker_id,
918: created_by,