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 910: p_country_code IN FND_TERRITORIES.TERRITORY_CODE%TYPE,

906: END GET_DEFAULT_CLASSIF_CODE;
907:
908:
909: Procedure GET_DEFAULT_PRODUCT_CLASSIF(
910: p_country_code IN FND_TERRITORIES.TERRITORY_CODE%TYPE,
911: p_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
912: p_org_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE,
913: p_default_code OUT NOCOPY VARCHAR2,
914: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS

Line 923: l_country_code FND_TERRITORIES.TERRITORY_CODE%TYPE;

919: given a Country Code
920:
921: */
922:
923: l_country_code FND_TERRITORIES.TERRITORY_CODE%TYPE;
924: l_category_set ZX_FC_COUNTRY_DEFAULTS.PRIMARY_INVENTORY_CATEGORY_SET%TYPE;
925: l_category_id MTL_ITEM_CATEGORIES.CATEGORY_ID%TYPE;
926: l_intended_use ZX_FC_COUNTRY_DEFAULTS.INTENDED_USE_DEFAULT%TYPE;
927: l_product_category_code VARCHAR2(240);

Line 1521: p_country_code IN fnd_territories.territory_code%TYPE,

1517: --
1518: END get_le_from_tax_registration;
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,

Line 1579: p_country_code IN fnd_territories.territory_code%TYPE,

1575:
1576: END get_fc_country_def_cache_info;
1577:
1578: PROCEDURE set_fc_country_def_cache_info(
1579: p_country_code IN fnd_territories.territory_code%TYPE,
1580: p_classification_type IN varchar2,
1581: p_classification_code IN varchar2)
1582: is
1583: l_tbl_index binary_integer;

Line 1601: l_territory_code fnd_territories.territory_code%type;

1597:
1598: FUNCTION is_territory_code_valid(p_country_code IN VARCHAR2)
1599: RETURN BOOLEAN is
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;

Line 1609: FROM FND_TERRITORIES

1605: RETURN TRUE;
1606: ELSE
1607: BEGIN
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;