eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_API_PUB dependencies on ZX_IMPORT_TAX_LINES_GT

Line 2382: | ZX_IMPORT_TAX_LINES_GT and ZX_TRX_TAX_LINK_GT |

2378: /* ======================================================================*
2379: | PROCEDURE import_document_with_tax : Imports document with tax |
2380: | This API also supports processing for multiple event classes |
2381: | GTT involved : ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT , |
2382: | ZX_IMPORT_TAX_LINES_GT and ZX_TRX_TAX_LINK_GT |
2383: * ======================================================================*/
2384: PROCEDURE Import_document_with_tax
2385: ( p_api_version IN NUMBER,
2386: p_init_msg_list IN VARCHAR2,

Line 2426: FROM ZX_IMPORT_TAX_LINES_GT t, zx_regimes_b r

2422: t.tax_regime_code,
2423: t.tax_provider_id,
2424: r.effective_from,
2425: r.effective_to
2426: FROM ZX_IMPORT_TAX_LINES_GT t, zx_regimes_b r
2427: WHERE t.tax_provider_id is not null
2428: AND r.tax_regime_code = t.tax_regime_code
2429: AND r.effective_to is null;
2430:

Line 2770: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;

2766: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2767: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2768: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2769: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2770: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2771: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2772: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2773: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2774: END IF;

Line 2771: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);

2767: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2768: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2769: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2770: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2771: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2772: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2773: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2774: END IF;
2775:

Line 2790: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;

2786: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2787: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2788: FND_FILE.put_line(which => FND_FILE.LOG
2789: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2790: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2791: FND_FILE.put_line(which => FND_FILE.Log
2792: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2793: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2794: FND_FILE.put_line(which => FND_FILE.LOG

Line 2792: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);

2788: FND_FILE.put_line(which => FND_FILE.LOG
2789: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2790: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2791: FND_FILE.put_line(which => FND_FILE.Log
2792: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2793: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2794: FND_FILE.put_line(which => FND_FILE.LOG
2795: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2796: END IF;

Line 2822: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;

2818: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2819: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2820: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2821: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2822: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2823: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2824: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2825: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2826: END IF;

Line 2823: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);

2819: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2820: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2821: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2822: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2823: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2824: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2825: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2826: END IF;
2827:

Line 2844: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;

2840: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2841: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2842: FND_FILE.put_line(which => FND_FILE.LOG
2843: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2844: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2845: FND_FILE.put_line(which => FND_FILE.Log
2846: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2847: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2848: FND_FILE.put_line(which => FND_FILE.LOG

Line 2846: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);

2842: FND_FILE.put_line(which => FND_FILE.LOG
2843: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2844: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2845: FND_FILE.put_line(which => FND_FILE.Log
2846: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2847: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2848: FND_FILE.put_line(which => FND_FILE.LOG
2849: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2850: END IF;

Line 2886: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;

2882: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2883: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2884: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2885: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2886: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2887: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2888: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2889: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2890: END IF;

Line 2887: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);

2883: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2884: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2885: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2886: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2887: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2888: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2889: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2890: END IF;
2891:

Line 2908: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;

2904: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2905: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2906: FND_FILE.put_line(which => FND_FILE.LOG
2907: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2908: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2909: FND_FILE.put_line(which => FND_FILE.Log
2910: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2911: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2912: FND_FILE.put_line(which => FND_FILE.LOG

Line 2910: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);

2906: FND_FILE.put_line(which => FND_FILE.LOG
2907: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2908: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2909: FND_FILE.put_line(which => FND_FILE.Log
2910: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2911: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2912: FND_FILE.put_line(which => FND_FILE.LOG
2913: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2914: END IF;

Line 2945: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;

2941: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2942: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2943: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2944: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2945: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2946: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2947: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2948: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2949: END IF;

Line 2946: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);

2942: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2943: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2944: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2945: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2946: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2947: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2948: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2949: END IF;
2950:

Line 2967: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;

2963: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2964: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2965: FND_FILE.put_line(which => FND_FILE.LOG
2966: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2967: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2968: FND_FILE.put_line(which => FND_FILE.Log
2969: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2970: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2971: FND_FILE.put_line(which => FND_FILE.LOG

Line 2969: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);

2965: FND_FILE.put_line(which => FND_FILE.LOG
2966: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2967: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2968: FND_FILE.put_line(which => FND_FILE.Log
2969: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2970: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2971: FND_FILE.put_line(which => FND_FILE.LOG
2972: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2973: END IF;