APPS.AP_APPROVAL_PKG dependencies on AP_ERRORS_GT

Line 9303: l_sql_tax_err varchar2(1000) := 'SELECT trx_id FROM zx_errors_gt UNION SELECT invoice_id from ap_errors_gt'; --bug10140354

9299: TYPE selc_inv_cursor_blk_err is table of selc_inv_cursor_bulk_error%rowtype;
9300:
9301: --bug9738293
9302:
9303: l_sql_tax_err varchar2(1000) := 'SELECT trx_id FROM zx_errors_gt UNION SELECT invoice_id from ap_errors_gt'; --bug10140354
9304:
9305:
9306:
9307: TYPE c_inv_err IS REF CURSOR;

Line 9319: FROM ap_errors_gt;

9315: SELECT trx_id, trx_line_id, message_text
9316: FROM zx_errors_gt
9317: UNION
9318: SELECT invoice_id , reference_key2 , message_text
9319: FROM ap_errors_gt;
9320:
9321: TYPE r_tx_err is table of c_tx_err%rowtype;
9322: l_r_tx_err r_tx_err;
9323:

Line 10081: delete from ap_errors_gt; --Flusing the AP GT table --bug10140354

10077:
10078: LOOP
10079:
10080: delete from zx_errors_gt; --Flusing the GT Table
10081: delete from ap_errors_gt; --Flusing the AP GT table --bug10140354
10082:
10083: --Moved Logging inside loop
10084: FND_FILE.PUT_LINE(FND_FILE.LOG,'(Bulk CALCULATE) START SYSDATE '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')); --Bug16390854
10085:

Line 10580: delete from ap_errors_gt; --Flusing the AP GT table --bug10140354

10576: -- error in ZX error table or they return success.
10577:
10578: LOOP
10579: delete from zx_errors_gt; --Flusing GT table
10580: delete from ap_errors_gt; --Flusing the AP GT table --bug10140354
10581:
10582: -- Moved logging inside loop
10583: FND_FILE.PUT_LINE(FND_FILE.LOG,'(Bulk DISTRIBUTE) START SYSDATE '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')); --Bug16390854
10584: