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

Line 17: x_classification_rec OUT NOCOPY ZX_GLOBAL_STRUCTURES_PKG.fc_country_def_val_rec_type,

13:
14: PROCEDURE get_fc_country_def_cache_info (
15: p_country_code IN fnd_territories.territory_code%TYPE,
16: p_classification_type IN varchar2,
17: x_classification_rec OUT NOCOPY ZX_GLOBAL_STRUCTURES_PKG.fc_country_def_val_rec_type,
18: x_found_in_cache OUT NOCOPY BOOLEAN,
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_error_buffer OUT NOCOPY VARCHAR2);
21:

Line 299: zx_event_cls_options. These are cached in zx_global_Structures_pkg.g_event_class_rec

295: WHERE country_code = p_country_code;
296: */
297:
298: /* Bug 5102996 no need to issue query against zx_evnt_cls_mappings or
299: zx_event_cls_options. These are cached in zx_global_Structures_pkg.g_event_class_rec
300: -- get default Transaction Business Category
301: CURSOR c_trx_biz_cat IS
302: SELECT tax_event_class_code, intrcmp_tx_evnt_cls_code
303: FROM zx_evnt_cls_mappings

Line 368: l_fc_country_def_val_rec ZX_GLOBAL_STRUCTURES_PKG.fc_country_def_val_rec_type;

364: SELECT delimiter
365: FROM zx_fc_types_b
366: WHERE classification_type_code ='TRX_BUSINESS_CATEGORY';
367:
368: l_fc_country_def_val_rec ZX_GLOBAL_STRUCTURES_PKG.fc_country_def_val_rec_type;
369: l_found_in_cache boolean;
370: l_tbl_index binary_integer;
371: l_return_status VARCHAR2(80);
372: l_error_buffer VARCHAR2(200);

Line 458: IF ZX_GLOBAL_STRUCTURES_PKG.g_intended_use_owner_tbl_info.owner_table_code is not NULL then

454: IF l_found_in_cache then
455: p_default_code := l_fc_country_def_val_rec.fc_default_value;
456: ELSE
457:
458: IF ZX_GLOBAL_STRUCTURES_PKG.g_intended_use_owner_tbl_info.owner_table_code is not NULL then
459: -- model intended use found in cache
460:
461: l_owner_table := ZX_GLOBAL_STRUCTURES_PKG.g_intended_use_owner_tbl_info.owner_table_code;
462: l_owner_id_num := ZX_GLOBAL_STRUCTURES_PKG.g_intended_use_owner_tbl_info.owner_id_num;

Line 461: l_owner_table := ZX_GLOBAL_STRUCTURES_PKG.g_intended_use_owner_tbl_info.owner_table_code;

457:
458: IF ZX_GLOBAL_STRUCTURES_PKG.g_intended_use_owner_tbl_info.owner_table_code is not NULL then
459: -- model intended use found in cache
460:
461: l_owner_table := ZX_GLOBAL_STRUCTURES_PKG.g_intended_use_owner_tbl_info.owner_table_code;
462: l_owner_id_num := ZX_GLOBAL_STRUCTURES_PKG.g_intended_use_owner_tbl_info.owner_id_num;
463:
464: ELSE
465: OPEN c_model_intended_use;

Line 462: l_owner_id_num := ZX_GLOBAL_STRUCTURES_PKG.g_intended_use_owner_tbl_info.owner_id_num;

458: IF ZX_GLOBAL_STRUCTURES_PKG.g_intended_use_owner_tbl_info.owner_table_code is not NULL then
459: -- model intended use found in cache
460:
461: l_owner_table := ZX_GLOBAL_STRUCTURES_PKG.g_intended_use_owner_tbl_info.owner_table_code;
462: l_owner_id_num := ZX_GLOBAL_STRUCTURES_PKG.g_intended_use_owner_tbl_info.owner_id_num;
463:
464: ELSE
465: OPEN c_model_intended_use;
466: FETCH c_model_intended_use into l_owner_table, l_owner_id_num;

Line 468: ZX_GLOBAL_STRUCTURES_PKG.g_intended_use_owner_tbl_info.owner_table_code := l_owner_table ;

464: ELSE
465: OPEN c_model_intended_use;
466: FETCH c_model_intended_use into l_owner_table, l_owner_id_num;
467:
468: ZX_GLOBAL_STRUCTURES_PKG.g_intended_use_owner_tbl_info.owner_table_code := l_owner_table ;
469: ZX_GLOBAL_STRUCTURES_PKG.g_intended_use_owner_tbl_info.owner_id_num := l_owner_id_num;
470:
471: -- Logging Infra: YK: 3/10: Break point
472: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 469: ZX_GLOBAL_STRUCTURES_PKG.g_intended_use_owner_tbl_info.owner_id_num := l_owner_id_num;

465: OPEN c_model_intended_use;
466: FETCH c_model_intended_use into l_owner_table, l_owner_id_num;
467:
468: ZX_GLOBAL_STRUCTURES_PKG.g_intended_use_owner_tbl_info.owner_table_code := l_owner_table ;
469: ZX_GLOBAL_STRUCTURES_PKG.g_intended_use_owner_tbl_info.owner_id_num := l_owner_id_num;
470:
471: -- Logging Infra: YK: 3/10: Break point
472: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
473: l_log_msg := 'B: CUR: c_model_intended_use: fetched: l_owner_table=' || l_owner_table ||

Line 820: l_tax_event_class_code := ZX_GLOBAL_STRUCTURES_PKG.g_event_class_Rec.tax_event_class_code;

816: END IF; -- found in cache
817:
818: ELSIF p_fiscal_type_code ='TRX_BUSINESS_CATEGORY' then
819:
820: l_tax_event_class_code := ZX_GLOBAL_STRUCTURES_PKG.g_event_class_Rec.tax_event_class_code;
821: l_intrcmp_code := ZX_GLOBAL_STRUCTURES_PKG.g_event_class_Rec.intrcmp_tx_evnt_cls_code;
822:
823: -- Logging Infra: YK: 3/11: Break point
824: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 821: l_intrcmp_code := ZX_GLOBAL_STRUCTURES_PKG.g_event_class_Rec.intrcmp_tx_evnt_cls_code;

817:
818: ELSIF p_fiscal_type_code ='TRX_BUSINESS_CATEGORY' then
819:
820: l_tax_event_class_code := ZX_GLOBAL_STRUCTURES_PKG.g_event_class_Rec.tax_event_class_code;
821: l_intrcmp_code := ZX_GLOBAL_STRUCTURES_PKG.g_event_class_Rec.intrcmp_tx_evnt_cls_code;
822:
823: -- Logging Infra: YK: 3/11: Break point
824: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
825: l_log_msg := 'B: CUR: c_trx_biz_cat: fetched: l_tax_event_class_code=' || l_tax_event_class_code;

Line 838: l_def_intrcmp_code := ZX_GLOBAL_STRUCTURES_PKG.g_event_class_Rec.DEF_INTRCMP_TRX_BIZ_CATEGORY;

834: RETURN;
835: END IF;
836:
837: IF l_intrcmp_code IS NOT NULL THEN
838: l_def_intrcmp_code := ZX_GLOBAL_STRUCTURES_PKG.g_event_class_Rec.DEF_INTRCMP_TRX_BIZ_CATEGORY;
839: p_default_code := l_def_intrcmp_code;
840: ELSE
841: p_default_code := l_tax_event_class_code;
842: END IF;

Line 1523: x_classification_rec OUT NOCOPY ZX_GLOBAL_STRUCTURES_PKG.fc_country_def_val_rec_type,

1519:
1520: PROCEDURE get_fc_country_def_cache_info (
1521: p_country_code IN fnd_territories.territory_code%TYPE,
1522: p_classification_type IN varchar2,
1523: x_classification_rec OUT NOCOPY ZX_GLOBAL_STRUCTURES_PKG.fc_country_def_val_rec_type,
1524: x_found_in_cache OUT NOCOPY BOOLEAN,
1525: x_return_status OUT NOCOPY VARCHAR2,
1526: x_error_buffer OUT NOCOPY VARCHAR2) is
1527:

Line 1550: IF ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL.EXISTS(l_index)

1546: --
1547: -- first check if the status info is available from the cache
1548: --
1549:
1550: IF ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL.EXISTS(l_index)
1551: THEN
1552: IF (g_level_statement >= g_current_runtime_level ) THEN
1553: FND_LOG.STRING(g_level_statement,
1554: 'ZX.PLSQL.LSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info',

Line 1559: x_classification_rec := ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL(l_index);

1555: 'Default Classification type '||p_classification_type||
1556: ' for country code '||p_country_code||' from cache, at index = ' || to_char(l_index));
1557: END IF;
1558: x_found_in_cache := TRUE;
1559: x_classification_rec := ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL(l_index);
1560:
1561: ELSE
1562: IF (g_level_statement >= g_current_runtime_level ) THEN
1563: FND_LOG.STRING(g_level_statement,

Line 1592: ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL(l_tbl_index).country_code := p_country_code;

1588: p_country_code||p_classification_type,
1589: 1,
1590: 8192);
1591:
1592: ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL(l_tbl_index).country_code := p_country_code;
1593: ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL(l_tbl_index).fc_type := p_classification_type;
1594: ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL(l_tbl_index).fc_default_value := p_classification_code;
1595:
1596: END set_fc_country_def_cache_info;

Line 1593: ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL(l_tbl_index).fc_type := p_classification_type;

1589: 1,
1590: 8192);
1591:
1592: ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL(l_tbl_index).country_code := p_country_code;
1593: ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL(l_tbl_index).fc_type := p_classification_type;
1594: ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL(l_tbl_index).fc_default_value := p_classification_code;
1595:
1596: END set_fc_country_def_cache_info;
1597:

Line 1594: ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL(l_tbl_index).fc_default_value := p_classification_code;

1590: 8192);
1591:
1592: ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL(l_tbl_index).country_code := p_country_code;
1593: ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL(l_tbl_index).fc_type := p_classification_type;
1594: ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL(l_tbl_index).fc_default_value := p_classification_code;
1595:
1596: END set_fc_country_def_cache_info;
1597:
1598: FUNCTION is_territory_code_valid(p_country_code IN VARCHAR2)

Line 1604: IF ZX_GLOBAL_STRUCTURES_PKG.G_TERRITORY_TBL.exists(l_country_index) then

1600: l_country_index binary_integer;
1601: l_territory_code fnd_territories.territory_code%type;
1602: BEGIN
1603: l_country_index := dbms_utility.get_hash_value(P_COUNTRY_CODE, 1, 8192);
1604: IF ZX_GLOBAL_STRUCTURES_PKG.G_TERRITORY_TBL.exists(l_country_index) then
1605: RETURN TRUE;
1606: ELSE
1607: BEGIN
1608: select TERRITORY_CODE into l_territory_code

Line 1612: ZX_GLOBAL_STRUCTURES_PKG.G_TERRITORY_TBL(l_country_index) := l_territory_code;

1608: select TERRITORY_CODE into l_territory_code
1609: FROM FND_TERRITORIES
1610: WHERE TERRITORY_CODE = p_country_code;
1611:
1612: ZX_GLOBAL_STRUCTURES_PKG.G_TERRITORY_TBL(l_country_index) := l_territory_code;
1613: return TRUE;
1614:
1615: EXCEPTION
1616: WHEN NO_DATA_FOUND then