DBA Data[Home] [Help]

APPS.ZX_VALID_INIT_PARAMS_PKG dependencies on ZX_EVNT_CLS_MAPPINGS

Line 25: P_ENTITY_CODE IN ZX_EVNT_CLS_MAPPINGS.entity_code%TYPE,

21: | PRIVATE FUNCTIONS/PROCEDURES |
22: *----------------------------------------------------------------------------*/
23:
24: PROCEDURE get_event_class_info(
25: P_ENTITY_CODE IN ZX_EVNT_CLS_MAPPINGS.entity_code%TYPE,
26: P_EVENT_CLASS_CODE IN ZX_EVNT_CLS_MAPPINGS.event_class_code%TYPE,
27: P_APPLICATION_ID IN ZX_EVNT_CLS_MAPPINGS.application_id%TYPE,
28: X_TBL_INDEX OUT NOCOPY BINARY_INTEGER,
29: X_RETURN_STATUS OUT NOCOPY VARCHAR2);

Line 26: P_EVENT_CLASS_CODE IN ZX_EVNT_CLS_MAPPINGS.event_class_code%TYPE,

22: *----------------------------------------------------------------------------*/
23:
24: PROCEDURE get_event_class_info(
25: P_ENTITY_CODE IN ZX_EVNT_CLS_MAPPINGS.entity_code%TYPE,
26: P_EVENT_CLASS_CODE IN ZX_EVNT_CLS_MAPPINGS.event_class_code%TYPE,
27: P_APPLICATION_ID IN ZX_EVNT_CLS_MAPPINGS.application_id%TYPE,
28: X_TBL_INDEX OUT NOCOPY BINARY_INTEGER,
29: X_RETURN_STATUS OUT NOCOPY VARCHAR2);
30:

Line 27: P_APPLICATION_ID IN ZX_EVNT_CLS_MAPPINGS.application_id%TYPE,

23:
24: PROCEDURE get_event_class_info(
25: P_ENTITY_CODE IN ZX_EVNT_CLS_MAPPINGS.entity_code%TYPE,
26: P_EVENT_CLASS_CODE IN ZX_EVNT_CLS_MAPPINGS.event_class_code%TYPE,
27: P_APPLICATION_ID IN ZX_EVNT_CLS_MAPPINGS.application_id%TYPE,
28: X_TBL_INDEX OUT NOCOPY BINARY_INTEGER,
29: X_RETURN_STATUS OUT NOCOPY VARCHAR2);
30:
31: PROCEDURE get_event_typ_mappings_info(

Line 916: FROM ZX_EVNT_CLS_MAPPINGS

912: x_record_for_partners_flag, -- Bug 5200373
913: x_prod_family_grp_code, -- Bug 5200373
914: x_event_class_mapping_id, -- Bug 5200373
915: x_summarization_flag
916: FROM ZX_EVNT_CLS_MAPPINGS
917: WHERE event_class_code = p_evnt_cls_code
918: AND application_id = p_appln_id
919: AND entity_code = p_entity_code;
920: */

Line 970: -- Fetch the relevant events information from zx_evnt_cls_mappings

966: -- PRIVATE PROCEDURE
967: -- Get_Tax_Event_Class
968: --
969: -- DESCRIPTION
970: -- Fetch the relevant events information from zx_evnt_cls_mappings
971: --
972: -- CALLED BY
973: -- calculate_tax
974: -- import_document_with_tax

Line 1092: FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap,

1088: p_event_class_rec.intrcmp_tx_evnt_cls_code,
1089: p_event_class_rec.intrcmp_src_appln_id,
1090: p_event_class_rec.intrcmp_src_entity_code,
1091: p_event_class_rec.intrcmp_src_evnt_cls_code
1092: FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap,
1093: ZX_EVENT_CLASSES_B zxcls
1094: WHERE zxevntclsmap.event_class_code = 'INVOICE'
1095: AND zxevntclsmap.application_id = 222
1096: AND zxevntclsmap.entity_code = 'TRANSACTIONS'

Line 1197: FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap,

1193: p_event_class_rec.intrcmp_tx_evnt_cls_code,
1194: p_event_class_rec.intrcmp_src_appln_id,
1195: p_event_class_rec.intrcmp_src_entity_code,
1196: p_event_class_rec.intrcmp_src_evnt_cls_code
1197: FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap,
1198: ZX_EVENT_CLASSES_B zxcls
1199: WHERE zxevntclsmap.entity_code = 'AP_INVOICES'
1200: AND zxevntclsmap.application_id = 200
1201: AND zxevntclsmap.event_class_code = 'STANDARD INVOICES'

Line 1445: FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap,

1441: p_event_class_rec.intrcmp_tx_evnt_cls_code,
1442: p_event_class_rec.intrcmp_src_appln_id,
1443: p_event_class_rec.intrcmp_src_entity_code,
1444: p_event_class_rec.intrcmp_src_evnt_cls_code
1445: FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap,
1446: ZX_EVENT_CLASSES_B zxcls
1447: WHERE zxevntclsmap.event_class_code = p_event_class_rec.event_class_code
1448: AND zxevntclsmap.application_id = p_event_class_rec.application_id
1449: AND zxevntclsmap.entity_code = p_event_class_rec.entity_code

Line 1467: FROM zx_evnt_cls_mappings mapp,

1463: mapp.process_for_applicability_flag
1464: INTO p_event_class_rec.source_event_class_mapping_id,
1465: p_event_class_rec.source_tax_event_class_code,
1466: p_event_class_rec.source_process_for_appl_flag
1467: FROM zx_evnt_cls_mappings mapp,
1468: zx_lines_det_factors det
1469: WHERE mapp.application_id = det.source_application_id
1470: AND mapp.entity_code = det.source_entity_code
1471: AND mapp.event_class_code = det.source_event_class_code

Line 1484: FROM zx_evnt_cls_mappings mapp

1480: mapp.process_for_applicability_flag
1481: INTO p_event_class_rec.source_event_class_mapping_id,
1482: p_event_class_rec.source_tax_event_class_code,
1483: p_event_class_rec.source_process_for_appl_flag
1484: FROM zx_evnt_cls_mappings mapp
1485: WHERE mapp.application_id = zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_APPLICATION_ID(1)
1486: AND mapp.entity_code = zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_ENTITY_CODE(1)
1487: AND mapp.event_class_code = zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_EVENT_CLASS_CODE(1);
1488:

Line 2200: FROM ZX_EVNT_CLS_MAPPINGS

2196: x_return_status := FND_API.G_RET_STS_SUCCESS;
2197:
2198: SELECT record_flag
2199: INTO l_record_flag
2200: FROM ZX_EVNT_CLS_MAPPINGS
2201: WHERE application_id = p_application_id
2202: AND entity_code = p_entity_code
2203: AND event_class_code = p_event_class_code;
2204:

Line 3158: l_record_flag zx_evnt_cls_mappings.record_flag%type;

3154: l_evnt_cls_code VARCHAR2(30);
3155: l_tx_evnt_cls_code VARCHAR2(30);
3156: l_ref_appln_id NUMBER;
3157: l_trx_id NUMBER;
3158: l_record_flag zx_evnt_cls_mappings.record_flag%type;
3159: l_record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%type;
3160: l_prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%type;
3161: l_event_class_mapping_id zx_evnt_cls_mappings.event_class_mapping_id%type;
3162: l_summarization_flag zx_evnt_cls_mappings.summarization_flag%TYPE;

Line 3159: l_record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%type;

3155: l_tx_evnt_cls_code VARCHAR2(30);
3156: l_ref_appln_id NUMBER;
3157: l_trx_id NUMBER;
3158: l_record_flag zx_evnt_cls_mappings.record_flag%type;
3159: l_record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%type;
3160: l_prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%type;
3161: l_event_class_mapping_id zx_evnt_cls_mappings.event_class_mapping_id%type;
3162: l_summarization_flag zx_evnt_cls_mappings.summarization_flag%TYPE;
3163:

Line 3160: l_prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%type;

3156: l_ref_appln_id NUMBER;
3157: l_trx_id NUMBER;
3158: l_record_flag zx_evnt_cls_mappings.record_flag%type;
3159: l_record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%type;
3160: l_prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%type;
3161: l_event_class_mapping_id zx_evnt_cls_mappings.event_class_mapping_id%type;
3162: l_summarization_flag zx_evnt_cls_mappings.summarization_flag%TYPE;
3163:
3164: BEGIN

Line 3161: l_event_class_mapping_id zx_evnt_cls_mappings.event_class_mapping_id%type;

3157: l_trx_id NUMBER;
3158: l_record_flag zx_evnt_cls_mappings.record_flag%type;
3159: l_record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%type;
3160: l_prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%type;
3161: l_event_class_mapping_id zx_evnt_cls_mappings.event_class_mapping_id%type;
3162: l_summarization_flag zx_evnt_cls_mappings.summarization_flag%TYPE;
3163:
3164: BEGIN
3165:

Line 3162: l_summarization_flag zx_evnt_cls_mappings.summarization_flag%TYPE;

3158: l_record_flag zx_evnt_cls_mappings.record_flag%type;
3159: l_record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%type;
3160: l_prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%type;
3161: l_event_class_mapping_id zx_evnt_cls_mappings.event_class_mapping_id%type;
3162: l_summarization_flag zx_evnt_cls_mappings.summarization_flag%TYPE;
3163:
3164: BEGIN
3165:
3166: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4336: P_ENTITY_CODE IN ZX_EVNT_CLS_MAPPINGS.entity_code%TYPE,

4332: END IF;
4333: END get_default_tax_det_attrs;
4334:
4335: PROCEDURE get_event_class_info(
4336: P_ENTITY_CODE IN ZX_EVNT_CLS_MAPPINGS.entity_code%TYPE,
4337: P_EVENT_CLASS_CODE IN ZX_EVNT_CLS_MAPPINGS.event_class_code%TYPE,
4338: P_APPLICATION_ID IN ZX_EVNT_CLS_MAPPINGS.application_id%TYPE,
4339: X_TBL_INDEX OUT NOCOPY BINARY_INTEGER,
4340: X_RETURN_STATUS OUT NOCOPY VARCHAR2)

Line 4337: P_EVENT_CLASS_CODE IN ZX_EVNT_CLS_MAPPINGS.event_class_code%TYPE,

4333: END get_default_tax_det_attrs;
4334:
4335: PROCEDURE get_event_class_info(
4336: P_ENTITY_CODE IN ZX_EVNT_CLS_MAPPINGS.entity_code%TYPE,
4337: P_EVENT_CLASS_CODE IN ZX_EVNT_CLS_MAPPINGS.event_class_code%TYPE,
4338: P_APPLICATION_ID IN ZX_EVNT_CLS_MAPPINGS.application_id%TYPE,
4339: X_TBL_INDEX OUT NOCOPY BINARY_INTEGER,
4340: X_RETURN_STATUS OUT NOCOPY VARCHAR2)
4341: is

Line 4338: P_APPLICATION_ID IN ZX_EVNT_CLS_MAPPINGS.application_id%TYPE,

4334:
4335: PROCEDURE get_event_class_info(
4336: P_ENTITY_CODE IN ZX_EVNT_CLS_MAPPINGS.entity_code%TYPE,
4337: P_EVENT_CLASS_CODE IN ZX_EVNT_CLS_MAPPINGS.event_class_code%TYPE,
4338: P_APPLICATION_ID IN ZX_EVNT_CLS_MAPPINGS.application_id%TYPE,
4339: X_TBL_INDEX OUT NOCOPY BINARY_INTEGER,
4340: X_RETURN_STATUS OUT NOCOPY VARCHAR2)
4341: is
4342: cursor c_evnt_class_info is

Line 4417: ZX_EVNT_CLS_MAPPINGS

4413: ,INTRCMP_SRC_APPLN_ID
4414: ,ALLOW_EXEMPTIONS_FLAG
4415: ,ENABLE_MRC_FLAG
4416: from
4417: ZX_EVNT_CLS_MAPPINGS
4418: WHERE
4419: application_id = p_application_id
4420: AND entity_code = p_entity_code
4421: AND event_class_Code = p_event_class_code;