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_EVNT_CLS_MAPPINGS

Line 777: FROM ZX_EVNT_CLS_MAPPINGS evntmap,

773: header.event_class_code,
774: header.application_id,
775: header.entity_code,
776: evntmap.processing_precedence
777: FROM ZX_EVNT_CLS_MAPPINGS evntmap,
778: ZX_TRX_HEADERS_GT header
779: WHERE header.application_id = evntmap.application_id
780: AND header.entity_code = evntmap.entity_code
781: AND header.event_class_code = evntmap.event_class_code

Line 907: --are not seeded in zx_evnt_cls_mappings so cursor event classes will not

903: END LOOP;
904: CLOSE event_classes;
905:
906: --Event classes such as SALES_TRANSACTION_TAX_QUOTE/PURCHASE_TRANSACTION_TAX_QUOTE
907: --are not seeded in zx_evnt_cls_mappings so cursor event classes will not
908: --return any rows for such event classes passed.
909: IF l_evnt_cls.event_class_code.LAST is null THEN
910: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
911: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 2411: FROM ZX_EVNT_CLS_MAPPINGS evntmap,

2407: header.application_id,
2408: header.entity_code,
2409: header.internal_organization_id,
2410: evntmap.processing_precedence
2411: FROM ZX_EVNT_CLS_MAPPINGS evntmap,
2412: ZX_TRX_HEADERS_GT header
2413: WHERE header.application_id = evntmap.application_id
2414: AND header.entity_code = evntmap.entity_code
2415: AND header.event_class_code = evntmap.event_class_code

Line 2510: --are not seeded in zx_evnt_cls_mappings so cursor event classes will not

2506: END LOOP;
2507: CLOSE event_classes;
2508:
2509: --Event classes such as SALES_TRANSACTION_TAX_QUOTE/PURCHASE_TRANSACTION_TAX_QUOTE
2510: --are not seeded in zx_evnt_cls_mappings so cursor event classes will not
2511: --return any rows for such event classes passed.
2512: IF l_evnt_cls.event_class_code.LAST is null THEN
2513: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2514: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 3071: zx_evnt_cls_mappings

3067: BEGIN
3068:
3069: SELECT prod_family_grp_code into l_event_class_rec.prod_family_grp_code
3070: FROM
3071: zx_evnt_cls_mappings
3072: WHERE
3073: application_id = p_sync_trx_rec.application_id
3074: AND entity_code = p_sync_trx_rec.entity_code
3075: AND event_class_code = p_sync_trx_rec.event_class_code;

Line 5086: FROM ZX_EVNT_CLS_MAPPINGS evntmap,

5082: header.application_id,
5083: header.entity_code,
5084: header.internal_organization_id,
5085: evntmap.processing_precedence
5086: FROM ZX_EVNT_CLS_MAPPINGS evntmap,
5087: ZX_TRX_HEADERS_GT header
5088: WHERE header.application_id = evntmap.application_id
5089: AND header.entity_code = evntmap.entity_code
5090: AND header.event_class_code = evntmap.event_class_code

Line 5300: --are not seeded in zx_evnt_cls_mappings so cursor event classes will not

5296: END LOOP;
5297: CLOSE event_classes;
5298:
5299: --Event classes such as SALES_TRANSACTION_TAX_QUOTE/PURCHASE_TRANSACTION_TAX_QUOTE
5300: --are not seeded in zx_evnt_cls_mappings so cursor event classes will not
5301: --return any rows for such event classes passed. This flag to keep track of this
5302: IF l_evnt_cls.event_class_code.LAST is null THEN
5303: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5304: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 6305: zx_evnt_cls_mappings evntcls,

6301: 'UPDATED' doc_status_code,
6302: evntcls.summarization_flag,
6303: evntcls.retain_summ_tax_line_id_flag
6304: FROM zx_rec_nrec_dist dist,
6305: zx_evnt_cls_mappings evntcls,
6306: zx_evnt_typ_mappings evnttyp,
6307: zx_tax_dist_id_gt distgt
6308: WHERE dist.application_id = evntcls.application_id
6309: AND dist.entity_code = evntcls.entity_code

Line 7127: FROM zx_evnt_cls_mappings

7123:
7124: BEGIN
7125: SELECT prod_family_grp_code
7126: INTO l_event_class_rec.prod_family_grp_code
7127: FROM zx_evnt_cls_mappings
7128: WHERE application_id = p_transaction_rec.application_id
7129: AND entity_code = p_transaction_rec.entity_code
7130: AND event_class_code = p_transaction_rec.event_class_code;
7131: EXCEPTION

Line 7285: FROM zx_evnt_cls_mappings

7281:
7282: CURSOR get_event_class_info IS
7283: SELECT summarization_flag,
7284: retain_summ_tax_line_id_flag
7285: FROM zx_evnt_cls_mappings
7286: WHERE application_id = p_transaction_rec.application_id
7287: AND entity_code = p_transaction_rec.entity_code
7288: AND event_class_code = p_transaction_rec.event_class_code;
7289:

Line 8139: l_entity_code zx_evnt_cls_mappings.entity_code%TYPE;

8135: l_tax_method VARCHAR2(30);
8136: l_init_msg_list VARCHAR2(1);
8137: l_internal_org_id NUMBER;
8138: l_application_id NUMBER;
8139: l_entity_code zx_evnt_cls_mappings.entity_code%TYPE;
8140: l_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE;
8141: l_zx_product_options_rec ZX_GLOBAL_STRUCTURES_PKG.zx_product_options_rec_type;
8142:
8143: CURSOR c_trx_biz_cat_csr (c_application_id NUMBER,

Line 8140: l_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE;

8136: l_init_msg_list VARCHAR2(1);
8137: l_internal_org_id NUMBER;
8138: l_application_id NUMBER;
8139: l_entity_code zx_evnt_cls_mappings.entity_code%TYPE;
8140: l_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE;
8141: l_zx_product_options_rec ZX_GLOBAL_STRUCTURES_PKG.zx_product_options_rec_type;
8142:
8143: CURSOR c_trx_biz_cat_csr (c_application_id NUMBER,
8144: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,

Line 8144: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,

8140: l_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE;
8141: l_zx_product_options_rec ZX_GLOBAL_STRUCTURES_PKG.zx_product_options_rec_type;
8142:
8143: CURSOR c_trx_biz_cat_csr (c_application_id NUMBER,
8144: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,
8145: c_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE) IS
8146: SELECT tax_event_class_code, intrcmp_tx_evnt_cls_code
8147: FROM zx_evnt_cls_mappings
8148: WHERE application_id = c_application_id

Line 8145: c_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE) IS

8141: l_zx_product_options_rec ZX_GLOBAL_STRUCTURES_PKG.zx_product_options_rec_type;
8142:
8143: CURSOR c_trx_biz_cat_csr (c_application_id NUMBER,
8144: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,
8145: c_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE) IS
8146: SELECT tax_event_class_code, intrcmp_tx_evnt_cls_code
8147: FROM zx_evnt_cls_mappings
8148: WHERE application_id = c_application_id
8149: AND entity_code = c_entity_code

Line 8147: FROM zx_evnt_cls_mappings

8143: CURSOR c_trx_biz_cat_csr (c_application_id NUMBER,
8144: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,
8145: c_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE) IS
8146: SELECT tax_event_class_code, intrcmp_tx_evnt_cls_code
8147: FROM zx_evnt_cls_mappings
8148: WHERE application_id = c_application_id
8149: AND entity_code = c_entity_code
8150: AND event_class_code = c_event_class_code;
8151:

Line 8153: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,

8149: AND entity_code = c_entity_code
8150: AND event_class_code = c_event_class_code;
8151:
8152: CURSOR c_intrcmp_code (c_application_id NUMBER,
8153: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,
8154: c_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE) IS
8155: SELECT DEF_INTRCMP_TRX_BIZ_CATEGORY
8156: FROM ZX_EVNT_CLS_OPTIONS op, zx_party_tax_profile ptp
8157: WHERE op.application_id = c_application_id

Line 8154: c_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE) IS

8150: AND event_class_code = c_event_class_code;
8151:
8152: CURSOR c_intrcmp_code (c_application_id NUMBER,
8153: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,
8154: c_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE) IS
8155: SELECT DEF_INTRCMP_TRX_BIZ_CATEGORY
8156: FROM ZX_EVNT_CLS_OPTIONS op, zx_party_tax_profile ptp
8157: WHERE op.application_id = c_application_id
8158: AND op.entity_code = c_entity_code

Line 14604: FROM ZX_EVNT_CLS_MAPPINGS

14600: tax_recovery_flag
14601: INTO l_summarization_flag,
14602: l_tax_reporting_flag,
14603: l_tax_recovery_flag
14604: FROM ZX_EVNT_CLS_MAPPINGS
14605: WHERE APPLICATION_ID = 222
14606: AND ENTITY_CODE = 'TRANSACTIONS'
14607: AND EVENT_CLASS_CODE = 'INVOICE';
14608: ELSIF l_event_class_code = 'PURCHASE_TRANSACTION_TAX_QUOTE' THEN

Line 14615: FROM ZX_EVNT_CLS_MAPPINGS

14611: tax_recovery_flag
14612: INTO l_summarization_flag,
14613: l_tax_reporting_flag,
14614: l_tax_recovery_flag
14615: FROM ZX_EVNT_CLS_MAPPINGS
14616: WHERE APPLICATION_ID = 200
14617: AND ENTITY_CODE = 'AP_INVOICES'
14618: AND EVENT_CLASS_CODE = 'STANDARD INVOICE';
14619: ELSE

Line 14626: FROM ZX_EVNT_CLS_MAPPINGS

14622: tax_recovery_flag
14623: INTO l_summarization_flag,
14624: l_tax_reporting_flag,
14625: l_tax_recovery_flag
14626: FROM ZX_EVNT_CLS_MAPPINGS
14627: WHERE APPLICATION_ID = l_application_id
14628: AND ENTITY_CODE = l_entity_code
14629: AND EVENT_CLASS_CODE = l_event_class_code;
14630: END IF;