APPS.ZX_TCM_EXT_SERVICES_PUB dependencies on FND_TERRITORIES

Line 15: p_country_code IN fnd_territories.territory_code%TYPE,

11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.';
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,

Line 23: p_country_code IN fnd_territories.territory_code%TYPE,

19: x_return_status OUT NOCOPY VARCHAR2,
20: x_error_buffer OUT NOCOPY VARCHAR2);
21:
22: PROCEDURE set_fc_country_def_cache_info(
23: p_country_code IN fnd_territories.territory_code%TYPE,
24: p_classification_type IN varchar2,
25: p_classification_code IN varchar2);
26:
27: FUNCTION is_territory_code_valid(p_country_code IN VARCHAR2)

Line 240: p_country_code IN FND_TERRITORIES.TERRITORY_CODE%TYPE,

236:
237:
238: Procedure GET_DEFAULT_CLASSIF_CODE(
239: p_fiscal_type_code IN ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE,
240: p_country_code IN FND_TERRITORIES.TERRITORY_CODE%TYPE,
241: p_application_id IN ZX_EVNT_CLS_MAPPINGS.APPLICATION_ID%TYPE,
242: p_entity_code IN ZX_EVNT_CLS_MAPPINGS.ENTITY_CODE%TYPE,
243: p_event_class_code IN ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_CODE%TYPE,
244: p_source_event_class_code IN ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_CODE%TYPE,

Line 257: l_country_code FND_TERRITORIES.TERRITORY_CODE%TYPE;

253: given a Country Code
254:
255: */
256:
257: l_country_code FND_TERRITORIES.TERRITORY_CODE%TYPE;
258: l_intended_use ZX_FC_COUNTRY_DEFAULTS.INTENDED_USE_DEFAULT%TYPE;
259: l_product_category_code VARCHAR2(240);
260: l_tax_event_class_code ZX_EVNT_CLS_MAPPINGS.TAX_EVENT_CLASS_CODE%TYPE;
261: l_owner_table ZX_FC_TYPES_B.OWNER_TABLE_CODE%TYPE;

Line 948: p_country_code IN FND_TERRITORIES.TERRITORY_CODE%TYPE,

944: END GET_DEFAULT_CLASSIF_CODE;
945:
946:
947: Procedure GET_DEFAULT_PRODUCT_CLASSIF(
948: p_country_code IN FND_TERRITORIES.TERRITORY_CODE%TYPE,
949: p_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
950: p_org_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE,
951: p_default_code OUT NOCOPY VARCHAR2,
952: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS

Line 961: l_country_code FND_TERRITORIES.TERRITORY_CODE%TYPE;

957: given a Country Code
958:
959: */
960:
961: l_country_code FND_TERRITORIES.TERRITORY_CODE%TYPE;
962: l_category_set ZX_FC_COUNTRY_DEFAULTS.PRIMARY_INVENTORY_CATEGORY_SET%TYPE;
963: l_category_id MTL_ITEM_CATEGORIES.CATEGORY_ID%TYPE;
964: l_intended_use ZX_FC_COUNTRY_DEFAULTS.INTENDED_USE_DEFAULT%TYPE;
965: l_product_category_code VARCHAR2(240);

Line 1570: p_country_code IN fnd_territories.territory_code%TYPE,

1566: --
1567: END get_le_from_tax_registration;
1568:
1569: PROCEDURE get_fc_country_def_cache_info (
1570: p_country_code IN fnd_territories.territory_code%TYPE,
1571: p_classification_type IN varchar2,
1572: x_classification_rec OUT NOCOPY ZX_GLOBAL_STRUCTURES_PKG.fc_country_def_val_rec_type,
1573: x_found_in_cache OUT NOCOPY BOOLEAN,
1574: x_return_status OUT NOCOPY VARCHAR2,

Line 1628: p_country_code IN fnd_territories.territory_code%TYPE,

1624:
1625: END get_fc_country_def_cache_info;
1626:
1627: PROCEDURE set_fc_country_def_cache_info(
1628: p_country_code IN fnd_territories.territory_code%TYPE,
1629: p_classification_type IN varchar2,
1630: p_classification_code IN varchar2)
1631: is
1632: l_tbl_index binary_integer;

Line 1650: l_territory_code fnd_territories.territory_code%type;

1646:
1647: FUNCTION is_territory_code_valid(p_country_code IN VARCHAR2)
1648: RETURN BOOLEAN is
1649: l_country_index binary_integer;
1650: l_territory_code fnd_territories.territory_code%type;
1651: BEGIN
1652: l_country_index := dbms_utility.get_hash_value(P_COUNTRY_CODE, 1, 8192);
1653: IF ZX_GLOBAL_STRUCTURES_PKG.G_TERRITORY_TBL.exists(l_country_index) then
1654: RETURN TRUE;

Line 1658: FROM FND_TERRITORIES

1654: RETURN TRUE;
1655: ELSE
1656: BEGIN
1657: select TERRITORY_CODE into l_territory_code
1658: FROM FND_TERRITORIES
1659: WHERE TERRITORY_CODE = p_country_code;
1660:
1661: ZX_GLOBAL_STRUCTURES_PKG.G_TERRITORY_TBL(l_country_index) := l_territory_code;
1662: return TRUE;