APPS.ZX_API_PUB dependencies on ZX_PURGE_TRANSACTIONS_GT

Line 14519: | GTT : ZX_PURGE_TRANSACTIONS_GT |

14515: END redef_tax_classification_code;
14516:
14517: /* =========================================================================*
14518: | PROCEDURE purge_tax_repository: Purges the transaction lines and tax data|
14519: | GTT : ZX_PURGE_TRANSACTIONS_GT |
14520: * ========================================================================*/
14521: PROCEDURE purge_tax_repository(
14522: p_api_version IN NUMBER,
14523: p_init_msg_list IN VARCHAR2,

Line 14594: FROM ZX_PURGE_TRANSACTIONS_GT

14590: event_class_code
14591: INTO l_application_id,
14592: l_entity_code,
14593: l_event_class_code
14594: FROM ZX_PURGE_TRANSACTIONS_GT
14595: WHERE rownum=1;
14596:
14597: IF l_event_class_code = 'SALES_TRANSACTION_TAX_QUOTE' THEN
14598: SELECT summarization_flag,

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

14633: IF l_tax_reporting_flag = 'N' THEN
14634: DELETE
14635: FROM ZX_LINES tax
14636: WHERE (APPLICATION_ID, ENTITY_CODE,EVENT_CLASS_CODE, TRX_ID)
14637: IN (SELECT /*+ INDEX (ZX_PURGE_TRANSACTIONS_GT ZX_PURGE_TRANSACTIONS_GT_U1)*/
14638: APPLICATION_ID,
14639: ENTITY_CODE,
14640: EVENT_CLASS_CODE,
14641: TRX_ID

Line 14642: FROM ZX_PURGE_TRANSACTIONS_GT purge);

14638: APPLICATION_ID,
14639: ENTITY_CODE,
14640: EVENT_CLASS_CODE,
14641: TRX_ID
14642: FROM ZX_PURGE_TRANSACTIONS_GT purge);
14643:
14644: IF SQL%FOUND THEN
14645: l_row_count := SQL%ROWCOUNT;
14646: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

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

14652: IF l_summarization_flag = 'Y' THEN
14653: DELETE
14654: FROM ZX_LINES_SUMMARY summ
14655: WHERE (APPLICATION_ID, ENTITY_CODE,EVENT_CLASS_CODE,TRX_ID)
14656: IN (SELECT /*+ INDEX (ZX_PURGE_TRANSACTIONS_GT ZX_PURGE_TRANSACTIONS_GT_U1)*/
14657: APPLICATION_ID,
14658: ENTITY_CODE,
14659: EVENT_CLASS_CODE,
14660: TRX_ID

Line 14661: FROM ZX_PURGE_TRANSACTIONS_GT purge);

14657: APPLICATION_ID,
14658: ENTITY_CODE,
14659: EVENT_CLASS_CODE,
14660: TRX_ID
14661: FROM ZX_PURGE_TRANSACTIONS_GT purge);
14662:
14663: IF SQL%FOUND THEN
14664: l_row_count := SQL%ROWCOUNT;
14665: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

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

14672: IF l_tax_recovery_flag ='Y' THEN
14673: DELETE
14674: FROM ZX_REC_NREC_DIST dist
14675: WHERE (APPLICATION_ID, ENTITY_CODE,EVENT_CLASS_CODE,TRX_ID)
14676: IN (SELECT /*+ INDEX (ZX_PURGE_TRANSACTIONS_GT ZX_PURGE_TRANSACTIONS_GT_U1)*/
14677: APPLICATION_ID,
14678: ENTITY_CODE,
14679: EVENT_CLASS_CODE,
14680: TRX_ID

Line 14681: FROM ZX_PURGE_TRANSACTIONS_GT purge);

14677: APPLICATION_ID,
14678: ENTITY_CODE,
14679: EVENT_CLASS_CODE,
14680: TRX_ID
14681: FROM ZX_PURGE_TRANSACTIONS_GT purge);
14682:
14683:
14684: IF SQL%FOUND THEN
14685: l_row_count := SQL%ROWCOUNT;

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

14692:
14693: DELETE
14694: FROM ZX_LINES_DET_FACTORS lines
14695: WHERE (APPLICATION_ID, ENTITY_CODE,EVENT_CLASS_CODE, TRX_ID)
14696: IN (SELECT /*+ INDEX (ZX_PURGE_TRANSACTIONS_GT ZX_PURGE_TRANSACTIONS_GT_U1)*/
14697: APPLICATION_ID,
14698: ENTITY_CODE,
14699: EVENT_CLASS_CODE,
14700: TRX_ID

Line 14701: FROM ZX_PURGE_TRANSACTIONS_GT purge);

14697: APPLICATION_ID,
14698: ENTITY_CODE,
14699: EVENT_CLASS_CODE,
14700: TRX_ID
14701: FROM ZX_PURGE_TRANSACTIONS_GT purge);
14702:
14703: IF SQL%FOUND THEN
14704: l_row_count := SQL%ROWCOUNT;
14705: IF (G_LEVEL_PROCEDURE >= g_current_runtime_level ) THEN