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_TDS_RULE_BASE_DETM_PVT dependencies on ZX_GLOBAL_STRUCTURES_PKG

Line 4342: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_CCID(p_structure_index)) THEN

4338: 8192);
4339:
4340: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(l_table_index) THEN
4341: IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index) =
4342: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_CCID(p_structure_index)) THEN
4343: p_trx_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index);
4344: l_in_cache_flg := TRUE;
4345: END IF;
4346: END IF;

Line 4428: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_STRING(p_structure_index)) THEN

4424: 8192);
4425:
4426: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN
4427: IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) =
4428: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_STRING(p_structure_index)) THEN
4429: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);
4430: l_in_cache_flg := TRUE;
4431: END IF;
4432: END IF;

Line 4603: WHERE inventory_item_id = ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PRODUCT_ID(p_structure_index)

4599: BEGIN
4600: SELECT item_type
4601: INTO l_trx_alphanumeric_value
4602: FROM MTL_SYSTEM_ITEMS
4603: WHERE inventory_item_id = ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PRODUCT_ID(p_structure_index)
4604: AND organization_id = nvl(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PRODUCT_ORG_ID(p_structure_index),
4605: p_event_class_rec.internal_organization_id);
4606: EXCEPTION
4607: WHEN NO_DATA_FOUND then

Line 4604: AND organization_id = nvl(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PRODUCT_ORG_ID(p_structure_index),

4600: SELECT item_type
4601: INTO l_trx_alphanumeric_value
4602: FROM MTL_SYSTEM_ITEMS
4603: WHERE inventory_item_id = ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PRODUCT_ID(p_structure_index)
4604: AND organization_id = nvl(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PRODUCT_ORG_ID(p_structure_index),
4605: p_event_class_rec.internal_organization_id);
4606: EXCEPTION
4607: WHEN NO_DATA_FOUND then
4608: p_trx_alphanumeric_value := NULL;

Line 5998: IF zx_global_structures_pkg.g_ccid_acct_string_info_tbl.exists(l_ccid) then

5994: p_error_buffer );
5995: IF (p_return_status = FND_API.G_RET_STS_SUCCESS AND
5996: l_ccid IS NOT NULL ) THEN
5997: IF l_ccid > 0 THEN
5998: IF zx_global_structures_pkg.g_ccid_acct_string_info_tbl.exists(l_ccid) then
5999:
6000: l_account_string :=
6001: zx_global_structures_pkg.g_ccid_acct_string_info_tbl(l_ccid).ACCOUNT_STRING;
6002:

Line 6001: zx_global_structures_pkg.g_ccid_acct_string_info_tbl(l_ccid).ACCOUNT_STRING;

5997: IF l_ccid > 0 THEN
5998: IF zx_global_structures_pkg.g_ccid_acct_string_info_tbl.exists(l_ccid) then
5999:
6000: l_account_string :=
6001: zx_global_structures_pkg.g_ccid_acct_string_info_tbl(l_ccid).ACCOUNT_STRING;
6002:
6003: IF (g_level_statement >= g_current_runtime_level ) THEN
6004: FND_LOG.STRING(g_level_statement,
6005: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_account_flexfield_info',

Line 6022: zx_global_structures_pkg.g_ccid_acct_string_info_tbl(l_ccid).CCID := l_ccid;

6018: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_account_flexfield_info',
6019: 'acct string derived by calling flexfield API: ' || l_account_string);
6020: END IF;
6021:
6022: zx_global_structures_pkg.g_ccid_acct_string_info_tbl(l_ccid).CCID := l_ccid;
6023: zx_global_structures_pkg.g_ccid_acct_string_info_tbl(l_ccid).ACCOUNT_STRING := l_account_string;
6024: zx_global_structures_pkg.g_ccid_acct_string_info_tbl(l_ccid).CHART_OF_ACCOUNTS_ID := p_chart_of_accounts_id;
6025:
6026:

Line 6023: zx_global_structures_pkg.g_ccid_acct_string_info_tbl(l_ccid).ACCOUNT_STRING := l_account_string;

6019: 'acct string derived by calling flexfield API: ' || l_account_string);
6020: END IF;
6021:
6022: zx_global_structures_pkg.g_ccid_acct_string_info_tbl(l_ccid).CCID := l_ccid;
6023: zx_global_structures_pkg.g_ccid_acct_string_info_tbl(l_ccid).ACCOUNT_STRING := l_account_string;
6024: zx_global_structures_pkg.g_ccid_acct_string_info_tbl(l_ccid).CHART_OF_ACCOUNTS_ID := p_chart_of_accounts_id;
6025:
6026:
6027: END IF;

Line 6024: zx_global_structures_pkg.g_ccid_acct_string_info_tbl(l_ccid).CHART_OF_ACCOUNTS_ID := p_chart_of_accounts_id;

6020: END IF;
6021:
6022: zx_global_structures_pkg.g_ccid_acct_string_info_tbl(l_ccid).CCID := l_ccid;
6023: zx_global_structures_pkg.g_ccid_acct_string_info_tbl(l_ccid).ACCOUNT_STRING := l_account_string;
6024: zx_global_structures_pkg.g_ccid_acct_string_info_tbl(l_ccid).CHART_OF_ACCOUNTS_ID := p_chart_of_accounts_id;
6025:
6026:
6027: END IF;
6028:

Line 7267: IF ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl.exists(l_tbl_index) THEN

7263: END IF;
7264:
7265: l_tbl_index := dbms_utility.get_hash_value(p_det_factor_templ_code||to_char(p_event_class_rec.event_class_mapping_id), 1, 8192);
7266:
7267: IF ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl.exists(l_tbl_index) THEN
7268:
7269: p_valid := ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).VALID;
7270:
7271: ELSE

Line 7269: p_valid := ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).VALID;

7265: l_tbl_index := dbms_utility.get_hash_value(p_det_factor_templ_code||to_char(p_event_class_rec.event_class_mapping_id), 1, 8192);
7266:
7267: IF ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl.exists(l_tbl_index) THEN
7268:
7269: p_valid := ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).VALID;
7270:
7271: ELSE
7272: -- get tax parameter codes for all determining factors from ZX_DET_FACTOR_TEMPL_DTL table.
7273:

Line 7294: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).DET_FACTOR_TEMPL_CODE :=

7290: ||p_det_factor_templ_code);
7291: END IF;
7292: p_valid := FALSE;
7293:
7294: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).DET_FACTOR_TEMPL_CODE :=
7295: p_det_factor_templ_code;
7296: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).EVENT_CLASS_MAPPING_ID :=
7297: p_event_class_rec.event_class_mapping_id;
7298: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).VALID := FALSE;

Line 7296: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).EVENT_CLASS_MAPPING_ID :=

7292: p_valid := FALSE;
7293:
7294: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).DET_FACTOR_TEMPL_CODE :=
7295: p_det_factor_templ_code;
7296: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).EVENT_CLASS_MAPPING_ID :=
7297: p_event_class_rec.event_class_mapping_id;
7298: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).VALID := FALSE;
7299:
7300: ELSE

Line 7298: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).VALID := FALSE;

7294: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).DET_FACTOR_TEMPL_CODE :=
7295: p_det_factor_templ_code;
7296: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).EVENT_CLASS_MAPPING_ID :=
7297: p_event_class_rec.event_class_mapping_id;
7298: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).VALID := FALSE;
7299:
7300: ELSE
7301:
7302: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).DET_FACTOR_TEMPL_CODE :=

Line 7302: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).DET_FACTOR_TEMPL_CODE :=

7298: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).VALID := FALSE;
7299:
7300: ELSE
7301:
7302: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).DET_FACTOR_TEMPL_CODE :=
7303: p_det_factor_templ_code;
7304: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).EVENT_CLASS_MAPPING_ID :=
7305: p_event_class_rec.event_class_mapping_id;
7306: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).VALID := TRUE;

Line 7304: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).EVENT_CLASS_MAPPING_ID :=

7300: ELSE
7301:
7302: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).DET_FACTOR_TEMPL_CODE :=
7303: p_det_factor_templ_code;
7304: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).EVENT_CLASS_MAPPING_ID :=
7305: p_event_class_rec.event_class_mapping_id;
7306: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).VALID := TRUE;
7307:
7308: END IF;

Line 7306: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).VALID := TRUE;

7302: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).DET_FACTOR_TEMPL_CODE :=
7303: p_det_factor_templ_code;
7304: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).EVENT_CLASS_MAPPING_ID :=
7305: p_event_class_rec.event_class_mapping_id;
7306: ZX_GLOBAL_STRUCTURES_PKG.g_template_valid_info_tbl(l_tbl_index).VALID := TRUE;
7307:
7308: END IF;
7309:
7310: CLOSE chk_taxevnt_parameter_code_csr;

Line 7382: --l_count := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.COUNT;

7378:
7379: --Initialize the return status , p_valid as FALSE
7380: p_valid := FALSE;
7381: p_return_status := FND_API.G_RET_STS_SUCCESS;
7382: --l_count := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.COUNT;
7383:
7384:
7385: IF (g_level_procedure >= g_current_runtime_level ) THEN
7386: FND_LOG.STRING(g_level_procedure,

Line 7439: FOR i IN 1..ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.event_class_mapping_id.LAST LOOP

7435: ', l_geography_name=' || l_geography_name );
7436: END IF; --g_level_statement if
7437:
7438: /*
7439: FOR i IN 1..ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.event_class_mapping_id.LAST LOOP
7440:
7441: --l_cache_evt_cls_map_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.event_class_mapping_id(i);
7442: --l_cache_trx_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.trx_id(i);
7443: l_cache_loc_type := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.location_type(i);

Line 7441: --l_cache_evt_cls_map_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.event_class_mapping_id(i);

7437:
7438: /*
7439: FOR i IN 1..ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.event_class_mapping_id.LAST LOOP
7440:
7441: --l_cache_evt_cls_map_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.event_class_mapping_id(i);
7442: --l_cache_trx_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.trx_id(i);
7443: l_cache_loc_type := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.location_type(i);
7444: l_cache_geo_type := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_type(i);
7445: l_cache_geo_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_id(i);

Line 7442: --l_cache_trx_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.trx_id(i);

7438: /*
7439: FOR i IN 1..ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.event_class_mapping_id.LAST LOOP
7440:
7441: --l_cache_evt_cls_map_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.event_class_mapping_id(i);
7442: --l_cache_trx_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.trx_id(i);
7443: l_cache_loc_type := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.location_type(i);
7444: l_cache_geo_type := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_type(i);
7445: l_cache_geo_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_id(i);
7446:

Line 7443: l_cache_loc_type := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.location_type(i);

7439: FOR i IN 1..ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.event_class_mapping_id.LAST LOOP
7440:
7441: --l_cache_evt_cls_map_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.event_class_mapping_id(i);
7442: --l_cache_trx_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.trx_id(i);
7443: l_cache_loc_type := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.location_type(i);
7444: l_cache_geo_type := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_type(i);
7445: l_cache_geo_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_id(i);
7446:
7447: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 7444: l_cache_geo_type := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_type(i);

7440:
7441: --l_cache_evt_cls_map_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.event_class_mapping_id(i);
7442: --l_cache_trx_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.trx_id(i);
7443: l_cache_loc_type := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.location_type(i);
7444: l_cache_geo_type := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_type(i);
7445: l_cache_geo_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_id(i);
7446:
7447: IF (g_level_statement >= g_current_runtime_level ) THEN
7448: FND_LOG.STRING(g_level_statement,

Line 7445: l_cache_geo_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_id(i);

7441: --l_cache_evt_cls_map_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.event_class_mapping_id(i);
7442: --l_cache_trx_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.trx_id(i);
7443: l_cache_loc_type := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.location_type(i);
7444: l_cache_geo_type := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_type(i);
7445: l_cache_geo_id := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_id(i);
7446:
7447: IF (g_level_statement >= g_current_runtime_level ) THEN
7448: FND_LOG.STRING(g_level_statement,
7449: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.check_rule_geography',