APPS.AR_BPA_PRINT_CONC dependencies on AR_BPA_PRINT_REQUESTS

Line 1040: -- and insert into the ar_bpa_print_requests table

1036: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_locale: '|| p_locale);
1037: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_index_flag: '|| p_index_flag);
1038:
1039: -- fetch a list of payment schedule id based on the inputted parameters
1040: -- and insert into the ar_bpa_print_requests table
1041:
1042: insert_stmt := ' insert into ar_bpa_print_requests (request_id, payment_schedule_id,
1043: worker_id, created_by, creation_date,last_updated_by, last_update_date)';
1044: select_stmt := ' select ' || m_request_id || ', payment_schedule_id, rownum, 1, sysdate, 1, sysdate from '

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

1038:
1039: -- fetch a list of payment schedule id based on the inputted parameters
1040: -- and insert into the ar_bpa_print_requests table
1041:
1042: insert_stmt := ' insert into ar_bpa_print_requests (request_id, payment_schedule_id,
1043: worker_id, created_by, creation_date,last_updated_by, last_update_date)';
1044: select_stmt := ' select ' || m_request_id || ', payment_schedule_id, rownum, 1, sysdate, 1, sysdate from '
1045: || cr ||' ( select ps.payment_schedule_id '|| cr || build_from_clause ||
1046: ' AND nvl(a_bill.language,' || '''' || base_lang || ''') = ' || '''' || userenv_lang || '''' ;

Line 1174: UPDATE ar_bpa_print_requests

1170: l_low_range := 1 ;
1171: l_high_range := row_counts_perworker ;
1172:
1173: LOOP
1174: UPDATE ar_bpa_print_requests
1175: SET worker_id = l_worker_id
1176: WHERE request_id = m_request_id
1177: AND worker_id BETWEEN l_low_range AND l_high_range;
1178:

Line 1266: DELETE FROM ar_bpa_print_requests

1262: END IF;
1263: END;
1264: END IF;
1265:
1266: DELETE FROM ar_bpa_print_requests
1267: WHERE request_id = m_request_id;
1268:
1269: COMMIT;
1270:

Line 1432: INSERT INTO ar_bpa_print_requests ( request_id,

1428: x_req_id_list := x_req_id_list ||','|| l_request_id;
1429: END IF;
1430:
1431: FORALL i in l_low_range .. l_high_range
1432: INSERT INTO ar_bpa_print_requests ( request_id,
1433: payment_schedule_id,
1434: worker_id,
1435: created_by,
1436: creation_date,

Line 1518: INSERT INTO ar_bpa_print_requests (request_id,

1514: BEGIN
1515: IF NVL( p_list_type , 'TRX') = 'TRX'
1516: THEN
1517: FORALL i IN 1..l_iter
1518: INSERT INTO ar_bpa_print_requests (request_id,
1519: payment_schedule_id,
1520: worker_id,
1521: created_by,
1522: creation_date,

Line 1540: INSERT INTO ar_bpa_print_requests (request_id,

1536:
1537: rows := SQL%ROWCOUNT;
1538: ELSE
1539: FORALL i IN 1..l_iter
1540: INSERT INTO ar_bpa_print_requests (request_id,
1541: payment_schedule_id,
1542: worker_id,
1543: created_by,
1544: creation_date,