APPS.AR_BPA_PRINT_TRX dependencies on AR_BPA_PRINT_REQUESTS

Line 609: -- AND insert into the ar_bpa_print_requests table

605: ld_print_date_low := FND_DATE.canonical_to_date(p_print_date_low_in);
606:
607: -- print out the input parameters;
608: -- fetch a list of payment schedule id based on the inputted parameters
609: -- AND insert into the ar_bpa_print_requests table
610:
611: lc_insert_stmt := ' INSERT INTO ar_bpa_print_requests (request_id, payment_schedule_id,
612: worker_id, created_by, creation_date,last_updated_by, last_update_date, customer_trx_id)';
613: lc_select_stmt := ' SELECT ' || ln_m_request_id || ', payment_schedule_id, ROWNUM, 1, SYSDATE, 1, SYSDATE, customer_trx_id FROM '

Line 611: lc_insert_stmt := ' INSERT INTO ar_bpa_print_requests (request_id, payment_schedule_id,

607: -- print out the input parameters;
608: -- fetch a list of payment schedule id based on the inputted parameters
609: -- AND insert into the ar_bpa_print_requests table
610:
611: lc_insert_stmt := ' INSERT INTO ar_bpa_print_requests (request_id, payment_schedule_id,
612: worker_id, created_by, creation_date,last_updated_by, last_update_date, customer_trx_id)';
613: lc_select_stmt := ' SELECT ' || ln_m_request_id || ', payment_schedule_id, ROWNUM, 1, SYSDATE, 1, SYSDATE, customer_trx_id FROM '
614: ||' ( SELECT apsa.payment_schedule_id, rct.customer_trx_id '|| build_from_clause ||
615: ' AND NVL(hcasa.language,' || '''' || lc_base_lang || ''') = ' || '''' || lc_userenv_lang || '''' ;

Line 711: UPDATE ar_bpa_print_requests

707: ln_low_range := 1 ;
708: ln_high_range := ln_row_counts_perworker ;
709:
710: LOOP
711: UPDATE ar_bpa_print_requests
712: SET worker_id = ln_worker_id
713: WHERE request_id = ln_m_request_id
714: AND worker_id BETWEEN ln_low_range AND ln_high_range;
715:

Line 788: DELETE FROM ar_bpa_print_requests

784: END IF;
785: END;
786: END IF;
787:
788: DELETE FROM ar_bpa_print_requests
789: WHERE request_id = ln_m_request_id;
790:
791: COMMIT;
792: END IF;