APPS.AR_BPA_PRINT_TRX dependencies on AR_BPA_PRINT_REQUESTS

Line 578: -- AND insert into the ar_bpa_print_requests table

574: ld_print_date_low := FND_DATE.canonical_to_date(p_print_date_low_in);
575:
576: -- print out the input parameters;
577: -- fetch a list of payment schedule id based on the inputted parameters
578: -- AND insert into the ar_bpa_print_requests table
579:
580: lc_insert_stmt := ' INSERT INTO ar_bpa_print_requests (request_id, payment_schedule_id,
581: worker_id, created_by, creation_date,last_updated_by, last_update_date)';
582: lc_select_stmt := ' SELECT ' || ln_m_request_id || ', payment_schedule_id, ROWNUM, 1, SYSDATE, 1, SYSDATE FROM '

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

576: -- print out the input parameters;
577: -- fetch a list of payment schedule id based on the inputted parameters
578: -- AND insert into the ar_bpa_print_requests table
579:
580: lc_insert_stmt := ' INSERT INTO ar_bpa_print_requests (request_id, payment_schedule_id,
581: worker_id, created_by, creation_date,last_updated_by, last_update_date)';
582: lc_select_stmt := ' SELECT ' || ln_m_request_id || ', payment_schedule_id, ROWNUM, 1, SYSDATE, 1, SYSDATE FROM '
583: ||' ( SELECT apsa.payment_schedule_id '|| build_from_clause ||
584: ' AND NVL(hcasa.language,' || '''' || lc_base_lang || ''') = ' || '''' || lc_userenv_lang || '''' ;

Line 680: UPDATE ar_bpa_print_requests

676: ln_low_range := 1 ;
677: ln_high_range := ln_row_counts_perworker ;
678:
679: LOOP
680: UPDATE ar_bpa_print_requests
681: SET worker_id = ln_worker_id
682: WHERE request_id = ln_m_request_id
683: AND worker_id BETWEEN ln_low_range AND ln_high_range;
684:

Line 756: DELETE FROM ar_bpa_print_requests

752: END IF;
753: END;
754: END IF;
755:
756: DELETE FROM ar_bpa_print_requests
757: WHERE request_id = ln_m_request_id;
758:
759: COMMIT;
760: END IF;