APPS.AR_BPA_PRINT_CONC dependencies on AR_BPA_PRINT_REQUESTS

Line 1055: -- and insert into the ar_bpa_print_requests table

1051: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_locale: '|| p_locale);
1052: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_index_flag: '|| p_index_flag);
1053:
1054: -- fetch a list of payment schedule id based on the inputted parameters
1055: -- and insert into the ar_bpa_print_requests table
1056:
1057: insert_stmt := ' insert into ar_bpa_print_requests (request_id, payment_schedule_id,
1058: worker_id, created_by, creation_date,last_updated_by, last_update_date, customer_trx_id)';
1059: select_stmt := ' select ' || m_request_id || ', payment_schedule_id, rownum, 1, sysdate, 1, sysdate, customer_trx_id from '

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

1053:
1054: -- fetch a list of payment schedule id based on the inputted parameters
1055: -- and insert into the ar_bpa_print_requests table
1056:
1057: insert_stmt := ' insert into ar_bpa_print_requests (request_id, payment_schedule_id,
1058: worker_id, created_by, creation_date,last_updated_by, last_update_date, customer_trx_id)';
1059: select_stmt := ' select ' || m_request_id || ', payment_schedule_id, rownum, 1, sysdate, 1, sysdate, customer_trx_id from '
1060: || cr ||' ( select ps.payment_schedule_id, trx.customer_trx_id '|| cr || build_from_clause ||
1061: ' AND nvl(a_bill_loc.language,' || '''' || base_lang || ''') = ' || '''' || userenv_lang || '''' ;

Line 1189: UPDATE ar_bpa_print_requests

1185: l_low_range := 1 ;
1186: l_high_range := row_counts_perworker ;
1187:
1188: LOOP
1189: UPDATE ar_bpa_print_requests
1190: SET worker_id = l_worker_id
1191: WHERE request_id = m_request_id
1192: AND worker_id BETWEEN l_low_range AND l_high_range;
1193:

Line 1281: DELETE FROM ar_bpa_print_requests

1277: END IF;
1278: END;
1279: END IF;
1280:
1281: DELETE FROM ar_bpa_print_requests
1282: WHERE request_id = m_request_id;
1283:
1284: COMMIT;
1285:

Line 1451: INSERT INTO ar_bpa_print_requests ( request_id,

1447: x_req_id_list := x_req_id_list ||','|| l_request_id;
1448: END IF;
1449:
1450: FORALL i in l_low_range .. l_high_range
1451: INSERT INTO ar_bpa_print_requests ( request_id,
1452: payment_schedule_id,
1453: worker_id,
1454: created_by,
1455: creation_date,

Line 1537: INSERT INTO ar_bpa_print_requests (request_id,

1533: BEGIN
1534: IF NVL( p_list_type , 'TRX') = 'TRX'
1535: THEN
1536: FORALL i IN 1..l_iter
1537: INSERT INTO ar_bpa_print_requests (request_id,
1538: payment_schedule_id,
1539: worker_id,
1540: created_by,
1541: creation_date,

Line 1559: INSERT INTO ar_bpa_print_requests (request_id,

1555:
1556: rows := SQL%ROWCOUNT;
1557: ELSE
1558: FORALL i IN 1..l_iter
1559: INSERT INTO ar_bpa_print_requests (request_id,
1560: payment_schedule_id,
1561: worker_id,
1562: created_by,
1563: creation_date,