APPS.ZX_API_PUB dependencies on ZX_PURGE_TRANSACTIONS_GT

Line 13344: | GTT : ZX_PURGE_TRANSACTIONS_GT |

13340: END redef_tax_classification_code;
13341:
13342: /* =========================================================================*
13343: | PROCEDURE purge_tax_repository: Purges the transaction lines and tax data|
13344: | GTT : ZX_PURGE_TRANSACTIONS_GT |
13345: * ========================================================================*/
13346: PROCEDURE purge_tax_repository(
13347: p_api_version IN NUMBER,
13348: p_init_msg_list IN VARCHAR2,

Line 13419: FROM ZX_PURGE_TRANSACTIONS_GT

13415: event_class_code
13416: INTO l_application_id,
13417: l_entity_code,
13418: l_event_class_code
13419: FROM ZX_PURGE_TRANSACTIONS_GT
13420: WHERE rownum=1;
13421:
13422: IF l_event_class_code = 'SALES_TRANSACTION_TAX_QUOTE' THEN
13423: SELECT summarization_flag,

Line 13462: IN (SELECT /*+ INDEX (ZX_PURGE_TRANSACTIONS_GT ZX_PURGE_TRANSACTIONS_GT_U1)*/

13458: IF l_tax_reporting_flag = 'N' THEN
13459: DELETE
13460: FROM ZX_LINES tax
13461: WHERE (APPLICATION_ID, ENTITY_CODE,EVENT_CLASS_CODE, TRX_ID)
13462: IN (SELECT /*+ INDEX (ZX_PURGE_TRANSACTIONS_GT ZX_PURGE_TRANSACTIONS_GT_U1)*/
13463: APPLICATION_ID,
13464: ENTITY_CODE,
13465: EVENT_CLASS_CODE,
13466: TRX_ID

Line 13467: FROM ZX_PURGE_TRANSACTIONS_GT purge);

13463: APPLICATION_ID,
13464: ENTITY_CODE,
13465: EVENT_CLASS_CODE,
13466: TRX_ID
13467: FROM ZX_PURGE_TRANSACTIONS_GT purge);
13468:
13469: IF SQL%FOUND THEN
13470: l_row_count := SQL%ROWCOUNT;
13471: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 13481: IN (SELECT /*+ INDEX (ZX_PURGE_TRANSACTIONS_GT ZX_PURGE_TRANSACTIONS_GT_U1)*/

13477: IF l_summarization_flag = 'Y' THEN
13478: DELETE
13479: FROM ZX_LINES_SUMMARY summ
13480: WHERE (APPLICATION_ID, ENTITY_CODE,EVENT_CLASS_CODE,TRX_ID)
13481: IN (SELECT /*+ INDEX (ZX_PURGE_TRANSACTIONS_GT ZX_PURGE_TRANSACTIONS_GT_U1)*/
13482: APPLICATION_ID,
13483: ENTITY_CODE,
13484: EVENT_CLASS_CODE,
13485: TRX_ID

Line 13486: FROM ZX_PURGE_TRANSACTIONS_GT purge);

13482: APPLICATION_ID,
13483: ENTITY_CODE,
13484: EVENT_CLASS_CODE,
13485: TRX_ID
13486: FROM ZX_PURGE_TRANSACTIONS_GT purge);
13487:
13488: IF SQL%FOUND THEN
13489: l_row_count := SQL%ROWCOUNT;
13490: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 13501: IN (SELECT /*+ INDEX (ZX_PURGE_TRANSACTIONS_GT ZX_PURGE_TRANSACTIONS_GT_U1)*/

13497: IF l_tax_recovery_flag ='Y' THEN
13498: DELETE
13499: FROM ZX_REC_NREC_DIST dist
13500: WHERE (APPLICATION_ID, ENTITY_CODE,EVENT_CLASS_CODE,TRX_ID)
13501: IN (SELECT /*+ INDEX (ZX_PURGE_TRANSACTIONS_GT ZX_PURGE_TRANSACTIONS_GT_U1)*/
13502: APPLICATION_ID,
13503: ENTITY_CODE,
13504: EVENT_CLASS_CODE,
13505: TRX_ID

Line 13506: FROM ZX_PURGE_TRANSACTIONS_GT purge);

13502: APPLICATION_ID,
13503: ENTITY_CODE,
13504: EVENT_CLASS_CODE,
13505: TRX_ID
13506: FROM ZX_PURGE_TRANSACTIONS_GT purge);
13507:
13508:
13509: IF SQL%FOUND THEN
13510: l_row_count := SQL%ROWCOUNT;

Line 13521: IN (SELECT /*+ INDEX (ZX_PURGE_TRANSACTIONS_GT ZX_PURGE_TRANSACTIONS_GT_U1)*/

13517:
13518: DELETE
13519: FROM ZX_LINES_DET_FACTORS lines
13520: WHERE (APPLICATION_ID, ENTITY_CODE,EVENT_CLASS_CODE, TRX_ID)
13521: IN (SELECT /*+ INDEX (ZX_PURGE_TRANSACTIONS_GT ZX_PURGE_TRANSACTIONS_GT_U1)*/
13522: APPLICATION_ID,
13523: ENTITY_CODE,
13524: EVENT_CLASS_CODE,
13525: TRX_ID

Line 13526: FROM ZX_PURGE_TRANSACTIONS_GT purge);

13522: APPLICATION_ID,
13523: ENTITY_CODE,
13524: EVENT_CLASS_CODE,
13525: TRX_ID
13526: FROM ZX_PURGE_TRANSACTIONS_GT purge);
13527:
13528: IF SQL%FOUND THEN
13529: l_row_count := SQL%ROWCOUNT;
13530: IF (G_LEVEL_PROCEDURE >= g_current_runtime_level ) THEN