APPS.AP_APPROVAL_PKG dependencies on ZX_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 9310: TYPE inv_err_ids IS TABLE OF zx_errors_gt.trx_id%Type INDEX BY BINARY_INTEGER;

9306:
9307: TYPE c_inv_err IS REF CURSOR;
9308: r_inv_err c_inv_err ;
9309:
9310: TYPE inv_err_ids IS TABLE OF zx_errors_gt.trx_id%Type INDEX BY BINARY_INTEGER;
9311: l_r_inv_err inv_err_ids;
9312:
9313: --bug10140354 changed the below cursor
9314: CURSOR c_tx_err is

Line 9316: FROM zx_errors_gt

9312:
9313: --bug10140354 changed the below cursor
9314: CURSOR c_tx_err is
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:

Line 10080: delete from zx_errors_gt; --Flusing the GT Table

10076: -- error in ZX error table or they return success.
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

Line 10487: FROM zx_errors_gt;

10483:
10484: /* DECLARE
10485: CURSOR c_tx_err is
10486: SELECT trx_id, trx_line_id, message_text
10487: FROM zx_errors_gt;
10488: r_tx_err c_tx_err%rowtype;
10489: BEGIN
10490: FOR r_tx_err IN c_tx_err LOOP
10491: fnd_file.put_line (fnd_file.log, l_approval_error

Line 10579: delete from zx_errors_gt; --Flusing GT table

10575: --Changed the calling method for Bulk tax distributions . ETAX API will be called till there is no
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

Line 10931: FROM zx_errors_gt;

10927:
10928: /* DECLARE
10929: CURSOR c_tx_err is
10930: SELECT trx_id, trx_line_id, message_text
10931: FROM zx_errors_gt;
10932: r_tx_err c_tx_err%rowtype;
10933: BEGIN
10934: FOR r_tx_err IN c_tx_err LOOP
10935: fnd_file.put_line (fnd_file.log, l_approval_error