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 924: FROM ZX_EVNT_CLS_MAPPINGS

920: x_record_for_partners_flag, -- Bug 5200373
921: x_prod_family_grp_code, -- Bug 5200373
922: x_event_class_mapping_id, -- Bug 5200373
923: x_summarization_flag
924: FROM ZX_EVNT_CLS_MAPPINGS
925: WHERE event_class_code = p_evnt_cls_code
926: AND application_id = p_appln_id
927: AND entity_code = p_entity_code;
928: */

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

974: -- PRIVATE PROCEDURE
975: -- Get_Tax_Event_Class
976: --
977: -- DESCRIPTION
978: -- Fetch the relevant events information from zx_evnt_cls_mappings
979: --
980: -- CALLED BY
981: -- calculate_tax
982: -- import_document_with_tax

Line 1106: FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap,

1102: p_event_class_rec.intrcmp_tx_evnt_cls_code,
1103: p_event_class_rec.intrcmp_src_appln_id,
1104: p_event_class_rec.intrcmp_src_entity_code,
1105: p_event_class_rec.intrcmp_src_evnt_cls_code
1106: FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap,
1107: ZX_EVENT_CLASSES_B zxcls
1108: WHERE zxevntclsmap.event_class_code = 'INVOICE'
1109: AND zxevntclsmap.application_id = 222
1110: AND zxevntclsmap.entity_code = 'TRANSACTIONS'

Line 1219: FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap,

1215: p_event_class_rec.intrcmp_tx_evnt_cls_code,
1216: p_event_class_rec.intrcmp_src_appln_id,
1217: p_event_class_rec.intrcmp_src_entity_code,
1218: p_event_class_rec.intrcmp_src_evnt_cls_code
1219: FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap,
1220: ZX_EVENT_CLASSES_B zxcls
1221: WHERE zxevntclsmap.entity_code = 'AP_INVOICES'
1222: AND zxevntclsmap.application_id = 200
1223: AND zxevntclsmap.event_class_code = 'STANDARD INVOICES'

Line 1467: FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap,

1463: p_event_class_rec.intrcmp_tx_evnt_cls_code,
1464: p_event_class_rec.intrcmp_src_appln_id,
1465: p_event_class_rec.intrcmp_src_entity_code,
1466: p_event_class_rec.intrcmp_src_evnt_cls_code
1467: FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap,
1468: ZX_EVENT_CLASSES_B zxcls
1469: WHERE zxevntclsmap.event_class_code = p_event_class_rec.event_class_code
1470: AND zxevntclsmap.application_id = p_event_class_rec.application_id
1471: AND zxevntclsmap.entity_code = p_event_class_rec.entity_code

Line 1489: FROM zx_evnt_cls_mappings mapp,

1485: mapp.process_for_applicability_flag
1486: INTO p_event_class_rec.source_event_class_mapping_id,
1487: p_event_class_rec.source_tax_event_class_code,
1488: p_event_class_rec.source_process_for_appl_flag
1489: FROM zx_evnt_cls_mappings mapp,
1490: zx_lines_det_factors det
1491: WHERE mapp.application_id = det.source_application_id
1492: AND mapp.entity_code = det.source_entity_code
1493: AND mapp.event_class_code = det.source_event_class_code

Line 1506: FROM zx_evnt_cls_mappings mapp

1502: mapp.process_for_applicability_flag
1503: INTO p_event_class_rec.source_event_class_mapping_id,
1504: p_event_class_rec.source_tax_event_class_code,
1505: p_event_class_rec.source_process_for_appl_flag
1506: FROM zx_evnt_cls_mappings mapp
1507: WHERE mapp.application_id = zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_APPLICATION_ID(1)
1508: AND mapp.entity_code = zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_ENTITY_CODE(1)
1509: AND mapp.event_class_code = zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_EVENT_CLASS_CODE(1);
1510:

Line 2227: FROM ZX_EVNT_CLS_MAPPINGS

2223: x_return_status := FND_API.G_RET_STS_SUCCESS;
2224:
2225: SELECT record_flag
2226: INTO l_record_flag
2227: FROM ZX_EVNT_CLS_MAPPINGS
2228: WHERE application_id = p_application_id
2229: AND entity_code = p_entity_code
2230: AND event_class_code = p_event_class_code;
2231:

Line 3185: l_record_flag zx_evnt_cls_mappings.record_flag%type;

3181: l_evnt_cls_code VARCHAR2(30);
3182: l_tx_evnt_cls_code VARCHAR2(30);
3183: l_ref_appln_id NUMBER;
3184: l_trx_id NUMBER;
3185: l_record_flag zx_evnt_cls_mappings.record_flag%type;
3186: l_record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%type;
3187: l_prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%type;
3188: l_event_class_mapping_id zx_evnt_cls_mappings.event_class_mapping_id%type;
3189: l_summarization_flag zx_evnt_cls_mappings.summarization_flag%TYPE;

Line 3186: l_record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%type;

3182: l_tx_evnt_cls_code VARCHAR2(30);
3183: l_ref_appln_id NUMBER;
3184: l_trx_id NUMBER;
3185: l_record_flag zx_evnt_cls_mappings.record_flag%type;
3186: l_record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%type;
3187: l_prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%type;
3188: l_event_class_mapping_id zx_evnt_cls_mappings.event_class_mapping_id%type;
3189: l_summarization_flag zx_evnt_cls_mappings.summarization_flag%TYPE;
3190:

Line 3187: l_prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%type;

3183: l_ref_appln_id NUMBER;
3184: l_trx_id NUMBER;
3185: l_record_flag zx_evnt_cls_mappings.record_flag%type;
3186: l_record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%type;
3187: l_prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%type;
3188: l_event_class_mapping_id zx_evnt_cls_mappings.event_class_mapping_id%type;
3189: l_summarization_flag zx_evnt_cls_mappings.summarization_flag%TYPE;
3190:
3191: BEGIN

Line 3188: l_event_class_mapping_id zx_evnt_cls_mappings.event_class_mapping_id%type;

3184: l_trx_id NUMBER;
3185: l_record_flag zx_evnt_cls_mappings.record_flag%type;
3186: l_record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%type;
3187: l_prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%type;
3188: l_event_class_mapping_id zx_evnt_cls_mappings.event_class_mapping_id%type;
3189: l_summarization_flag zx_evnt_cls_mappings.summarization_flag%TYPE;
3190:
3191: BEGIN
3192:

Line 3189: l_summarization_flag zx_evnt_cls_mappings.summarization_flag%TYPE;

3185: l_record_flag zx_evnt_cls_mappings.record_flag%type;
3186: l_record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%type;
3187: l_prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%type;
3188: l_event_class_mapping_id zx_evnt_cls_mappings.event_class_mapping_id%type;
3189: l_summarization_flag zx_evnt_cls_mappings.summarization_flag%TYPE;
3190:
3191: BEGIN
3192:
3193: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4363: P_ENTITY_CODE IN ZX_EVNT_CLS_MAPPINGS.entity_code%TYPE,

4359: END IF;
4360: END get_default_tax_det_attrs;
4361:
4362: PROCEDURE get_event_class_info(
4363: P_ENTITY_CODE IN ZX_EVNT_CLS_MAPPINGS.entity_code%TYPE,
4364: P_EVENT_CLASS_CODE IN ZX_EVNT_CLS_MAPPINGS.event_class_code%TYPE,
4365: P_APPLICATION_ID IN ZX_EVNT_CLS_MAPPINGS.application_id%TYPE,
4366: X_TBL_INDEX OUT NOCOPY BINARY_INTEGER,
4367: X_RETURN_STATUS OUT NOCOPY VARCHAR2)

Line 4364: P_EVENT_CLASS_CODE IN ZX_EVNT_CLS_MAPPINGS.event_class_code%TYPE,

4360: END get_default_tax_det_attrs;
4361:
4362: PROCEDURE get_event_class_info(
4363: P_ENTITY_CODE IN ZX_EVNT_CLS_MAPPINGS.entity_code%TYPE,
4364: P_EVENT_CLASS_CODE IN ZX_EVNT_CLS_MAPPINGS.event_class_code%TYPE,
4365: P_APPLICATION_ID IN ZX_EVNT_CLS_MAPPINGS.application_id%TYPE,
4366: X_TBL_INDEX OUT NOCOPY BINARY_INTEGER,
4367: X_RETURN_STATUS OUT NOCOPY VARCHAR2)
4368: is

Line 4365: P_APPLICATION_ID IN ZX_EVNT_CLS_MAPPINGS.application_id%TYPE,

4361:
4362: PROCEDURE get_event_class_info(
4363: P_ENTITY_CODE IN ZX_EVNT_CLS_MAPPINGS.entity_code%TYPE,
4364: P_EVENT_CLASS_CODE IN ZX_EVNT_CLS_MAPPINGS.event_class_code%TYPE,
4365: P_APPLICATION_ID IN ZX_EVNT_CLS_MAPPINGS.application_id%TYPE,
4366: X_TBL_INDEX OUT NOCOPY BINARY_INTEGER,
4367: X_RETURN_STATUS OUT NOCOPY VARCHAR2)
4368: is
4369: cursor c_evnt_class_info is

Line 4444: ZX_EVNT_CLS_MAPPINGS

4440: ,INTRCMP_SRC_APPLN_ID
4441: ,ALLOW_EXEMPTIONS_FLAG
4442: ,ENABLE_MRC_FLAG
4443: from
4444: ZX_EVNT_CLS_MAPPINGS
4445: WHERE
4446: application_id = p_application_id
4447: AND entity_code = p_entity_code
4448: AND event_class_Code = p_event_class_code;