DBA Data[Home] [Help]

APPS.ZX_API_PUB dependencies on ZX_EVNT_CLS_MAPPINGS

Line 783: FROM ZX_EVNT_CLS_MAPPINGS evntmap,

779: header.application_id,
780: header.entity_code,
781: header.internal_organization_id,
782: evntmap.processing_precedence
783: FROM ZX_EVNT_CLS_MAPPINGS evntmap,
784: ZX_TRX_HEADERS_GT header
785: WHERE header.application_id = evntmap.application_id
786: AND header.entity_code = evntmap.entity_code
787: AND header.event_class_code = evntmap.event_class_code

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

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

Line 2154: FROM ZX_EVNT_CLS_MAPPINGS evntmap,

2150: header.application_id,
2151: header.entity_code,
2152: header.internal_organization_id,
2153: evntmap.processing_precedence
2154: FROM ZX_EVNT_CLS_MAPPINGS evntmap,
2155: ZX_TRX_HEADERS_GT header
2156: WHERE header.application_id = evntmap.application_id
2157: AND header.entity_code = evntmap.entity_code
2158: AND header.event_class_code = evntmap.event_class_code

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

2241: END LOOP;
2242: CLOSE event_classes;
2243:
2244: --Event classes such as SALES_TRANSACTION_TAX_QUOTE/PURCHASE_TRANSACTION_TAX_QUOTE
2245: --are not seeded in zx_evnt_cls_mappings so cursor event classes will not
2246: --return any rows for such event classes passed.
2247: IF l_evnt_cls.event_class_code.LAST is null THEN
2248: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2249: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 2593: zx_evnt_cls_mappings

2589: BEGIN
2590:
2591: SELECT prod_family_grp_code into l_event_class_rec.prod_family_grp_code
2592: FROM
2593: zx_evnt_cls_mappings
2594: WHERE
2595: application_id = p_sync_trx_rec.application_id
2596: AND entity_code = p_sync_trx_rec.entity_code
2597: AND event_class_code = p_sync_trx_rec.event_class_code;

Line 4434: FROM ZX_EVNT_CLS_MAPPINGS evntmap,

4430: header.application_id,
4431: header.entity_code,
4432: header.internal_organization_id,
4433: evntmap.processing_precedence
4434: FROM ZX_EVNT_CLS_MAPPINGS evntmap,
4435: ZX_TRX_HEADERS_GT header
4436: WHERE header.application_id = evntmap.application_id
4437: AND header.entity_code = evntmap.entity_code
4438: AND header.event_class_code = evntmap.event_class_code

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

4630: END LOOP;
4631: CLOSE event_classes;
4632:
4633: --Event classes such as SALES_TRANSACTION_TAX_QUOTE/PURCHASE_TRANSACTION_TAX_QUOTE
4634: --are not seeded in zx_evnt_cls_mappings so cursor event classes will not
4635: --return any rows for such event classes passed. This flag to keep track of this
4636: IF l_evnt_cls.event_class_code.LAST is null THEN
4637: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4638: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 5347: zx_evnt_cls_mappings evntcls,

5343: 'UPDATED' doc_status_code,
5344: evntcls.summarization_flag,
5345: evntcls.retain_summ_tax_line_id_flag
5346: FROM zx_rec_nrec_dist dist,
5347: zx_evnt_cls_mappings evntcls,
5348: zx_evnt_typ_mappings evnttyp,
5349: zx_tax_dist_id_gt distgt
5350: WHERE dist.application_id = evntcls.application_id
5351: AND dist.entity_code = evntcls.entity_code

Line 6278: FROM zx_evnt_cls_mappings

6274:
6275: CURSOR get_event_class_info IS
6276: SELECT summarization_flag,
6277: retain_summ_tax_line_id_flag
6278: FROM zx_evnt_cls_mappings
6279: WHERE application_id = p_transaction_rec.application_id
6280: AND entity_code = p_transaction_rec.entity_code
6281: AND event_class_code = p_transaction_rec.event_class_code;
6282:

Line 7075: l_entity_code zx_evnt_cls_mappings.entity_code%TYPE;

7071: l_tax_method VARCHAR2(30);
7072: l_init_msg_list VARCHAR2(1);
7073: l_internal_org_id NUMBER;
7074: l_application_id NUMBER;
7075: l_entity_code zx_evnt_cls_mappings.entity_code%TYPE;
7076: l_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE;
7077: l_zx_product_options_rec ZX_GLOBAL_STRUCTURES_PKG.zx_product_options_rec_type;
7078:
7079: CURSOR c_trx_biz_cat_csr (c_application_id NUMBER,

Line 7076: l_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE;

7072: l_init_msg_list VARCHAR2(1);
7073: l_internal_org_id NUMBER;
7074: l_application_id NUMBER;
7075: l_entity_code zx_evnt_cls_mappings.entity_code%TYPE;
7076: l_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE;
7077: l_zx_product_options_rec ZX_GLOBAL_STRUCTURES_PKG.zx_product_options_rec_type;
7078:
7079: CURSOR c_trx_biz_cat_csr (c_application_id NUMBER,
7080: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,

Line 7080: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,

7076: l_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE;
7077: l_zx_product_options_rec ZX_GLOBAL_STRUCTURES_PKG.zx_product_options_rec_type;
7078:
7079: CURSOR c_trx_biz_cat_csr (c_application_id NUMBER,
7080: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,
7081: c_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE) IS
7082: SELECT tax_event_class_code, intrcmp_tx_evnt_cls_code
7083: FROM zx_evnt_cls_mappings
7084: WHERE application_id = c_application_id

Line 7081: c_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE) IS

7077: l_zx_product_options_rec ZX_GLOBAL_STRUCTURES_PKG.zx_product_options_rec_type;
7078:
7079: CURSOR c_trx_biz_cat_csr (c_application_id NUMBER,
7080: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,
7081: c_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE) IS
7082: SELECT tax_event_class_code, intrcmp_tx_evnt_cls_code
7083: FROM zx_evnt_cls_mappings
7084: WHERE application_id = c_application_id
7085: AND entity_code = c_entity_code

Line 7083: FROM zx_evnt_cls_mappings

7079: CURSOR c_trx_biz_cat_csr (c_application_id NUMBER,
7080: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,
7081: c_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE) IS
7082: SELECT tax_event_class_code, intrcmp_tx_evnt_cls_code
7083: FROM zx_evnt_cls_mappings
7084: WHERE application_id = c_application_id
7085: AND entity_code = c_entity_code
7086: AND event_class_code = c_event_class_code;
7087:

Line 7089: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,

7085: AND entity_code = c_entity_code
7086: AND event_class_code = c_event_class_code;
7087:
7088: CURSOR c_intrcmp_code (c_application_id NUMBER,
7089: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,
7090: c_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE) IS
7091: SELECT DEF_INTRCMP_TRX_BIZ_CATEGORY
7092: FROM ZX_EVNT_CLS_OPTIONS
7093: WHERE application_id = c_application_id

Line 7090: c_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE) IS

7086: AND event_class_code = c_event_class_code;
7087:
7088: CURSOR c_intrcmp_code (c_application_id NUMBER,
7089: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,
7090: c_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE) IS
7091: SELECT DEF_INTRCMP_TRX_BIZ_CATEGORY
7092: FROM ZX_EVNT_CLS_OPTIONS
7093: WHERE application_id = c_application_id
7094: AND entity_code = c_entity_code

Line 13429: FROM ZX_EVNT_CLS_MAPPINGS

13425: tax_recovery_flag
13426: INTO l_summarization_flag,
13427: l_tax_reporting_flag,
13428: l_tax_recovery_flag
13429: FROM ZX_EVNT_CLS_MAPPINGS
13430: WHERE APPLICATION_ID = 222
13431: AND ENTITY_CODE = 'TRANSACTIONS'
13432: AND EVENT_CLASS_CODE = 'INVOICE';
13433: ELSIF l_event_class_code = 'PURCHASE_TRANSACTION_TAX_QUOTE' THEN

Line 13440: FROM ZX_EVNT_CLS_MAPPINGS

13436: tax_recovery_flag
13437: INTO l_summarization_flag,
13438: l_tax_reporting_flag,
13439: l_tax_recovery_flag
13440: FROM ZX_EVNT_CLS_MAPPINGS
13441: WHERE APPLICATION_ID = 200
13442: AND ENTITY_CODE = 'AP_INVOICES'
13443: AND EVENT_CLASS_CODE = 'STANDARD INVOICE';
13444: ELSE

Line 13451: FROM ZX_EVNT_CLS_MAPPINGS

13447: tax_recovery_flag
13448: INTO l_summarization_flag,
13449: l_tax_reporting_flag,
13450: l_tax_recovery_flag
13451: FROM ZX_EVNT_CLS_MAPPINGS
13452: WHERE APPLICATION_ID = l_application_id
13453: AND ENTITY_CODE = l_entity_code
13454: AND EVENT_CLASS_CODE = l_event_class_code;
13455: END IF;