APPS.ZX_TCM_EXT_SERVICES_PUB dependencies on ZX_FC_TYPES_B

Line 239: p_fiscal_type_code IN ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE,

235: END GET_DEFAULT_STATUS_RATES;
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,

Line 261: l_owner_table ZX_FC_TYPES_B.OWNER_TABLE_CODE%TYPE;

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;
263: l_category_id MTL_ITEM_CATEGORIES.CATEGORY_ID%TYPE;
264: l_category_code varchar2(200);
265: l_product_type varchar2(200);

Line 262: l_owner_id_num ZX_FC_TYPES_B.OWNER_ID_NUM%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;
263: l_category_id MTL_ITEM_CATEGORIES.CATEGORY_ID%TYPE;
264: l_category_code varchar2(200);
265: l_product_type varchar2(200);
266: l_status varchar2(1);

Line 318: FROM zx_fc_types_b

314:
315: -- Get the Model use for Intended Use
316: CURSOR c_model_Intended_use IS
317: SELECT owner_table_code,owner_id_num
318: FROM zx_fc_types_b
319: WHERE classification_type_code ='INTENDED_USE';
320:
321: CURSOR c_item_category IS
322: SELECT category_id

Line 365: FROM zx_fc_types_b

361: AND LANGUAGE = userenv('LANG');
362:
363: CURSOR c_delimiter IS
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;

Line 373: g_delimiter zx_fc_types_b.delimiter%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);
373: g_delimiter zx_fc_types_b.delimiter%type;
374:
375:
376: BEGIN
377: -- Logging Infra: Setting up runtime level

Line 500: IF l_owner_table = 'ZX_FC_TYPES_B' then

496:
497: CLOSE c_model_intended_use;
498: END IF; -- model intended use found in cache
499:
500: IF l_owner_table = 'ZX_FC_TYPES_B' then
501:
502: OPEN c_country_default;
503: FETCH c_country_default into l_Intended_Use, l_product_category_code, l_category_set;
504: