APPS.ZX_TCM_EXT_SERVICES_PUB dependencies on ZX_FC_COUNTRY_DEFAULTS

Line 258: l_intended_use ZX_FC_COUNTRY_DEFAULTS.INTENDED_USE_DEFAULT%TYPE;

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;
262: l_owner_id_num ZX_FC_TYPES_B.OWNER_ID_NUM%TYPE;

Line 272: l_category_set ZX_FC_COUNTRY_DEFAULTS.PRIMARY_INVENTORY_CATEGORY_SET%TYPE;

268: l_classif_code ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE;
269: l_classif_code_1 ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE;
270: l_intrcmp_code zx_evnt_cls_mappings.intrcmp_tx_evnt_cls_code%TYPE;
271: l_def_intrcmp_code ZX_EVNT_CLS_OPTIONS.DEF_INTRCMP_TRX_BIZ_CATEGORY%TYPE;
272: l_category_set ZX_FC_COUNTRY_DEFAULTS.PRIMARY_INVENTORY_CATEGORY_SET%TYPE;
273:
274: -- Logging Infra:
275: l_procedure_name CONSTANT VARCHAR2(30) := 'get_default_classif_code';
276: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 281: FROM zx_fc_country_defaults

277:
278: -- get country defaults
279: CURSOR c_country_default IS
280: SELECT intended_use_default, product_categ_default, primary_inventory_category_set
281: FROM zx_fc_country_defaults
282: WHERE country_code = p_country_code;
283:
284: /*
285: -- get default Intended Use

Line 288: FROM zx_fc_country_defaults

284: /*
285: -- get default Intended Use
286: CURSOR c_default_Intended_Use IS
287: SELECT intended_use_default
288: FROM zx_fc_country_defaults
289: WHERE country_code = p_country_code;
290:
291: -- get default Product Category
292: CURSOR c_default_Product_Category IS

Line 294: FROM zx_fc_country_defaults

290:
291: -- get default Product Category
292: CURSOR c_default_Product_Category IS
293: SELECT product_categ_default
294: FROM zx_fc_country_defaults
295: WHERE country_code = p_country_code;
296: */
297:
298: /* Bug 5102996 no need to issue query against zx_evnt_cls_mappings or

Line 924: l_category_set ZX_FC_COUNTRY_DEFAULTS.PRIMARY_INVENTORY_CATEGORY_SET%TYPE;

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);
928: l_category_code varchar2(200);

Line 926: l_intended_use ZX_FC_COUNTRY_DEFAULTS.INTENDED_USE_DEFAULT%TYPE;

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);
928: l_category_code varchar2(200);
929:
930: l_status varchar2(1);

Line 942: FROM zx_fc_country_defaults

938: -- Get default Product Fiscal Classification
939:
940: CURSOR c_country_default IS
941: SELECT intended_use_default, product_categ_default, primary_inventory_category_set
942: FROM zx_fc_country_defaults
943: WHERE country_code = p_country_code;
944:
945: CURSOR c_item_category IS
946: SELECT category_id

Line 1257: From ZX_FC_COUNTRY_DEFAULTS

1253: p_country_code IN VARCHAR2) RETURN VARCHAR2 IS
1254:
1255: Cursor c_prod_category is
1256: Select product_categ_default
1257: From ZX_FC_COUNTRY_DEFAULTS
1258: Where country_code = p_country_code;
1259:
1260: l_product_categ_default zx_fc_country_defaults.product_categ_default%TYPE;
1261: BEGIN

Line 1260: l_product_categ_default zx_fc_country_defaults.product_categ_default%TYPE;

1256: Select product_categ_default
1257: From ZX_FC_COUNTRY_DEFAULTS
1258: Where country_code = p_country_code;
1259:
1260: l_product_categ_default zx_fc_country_defaults.product_categ_default%TYPE;
1261: BEGIN
1262:
1263: arp_util_tax.debug(' ZX_GET_PROD_CATEG .. (+) ' );
1264: