DBA Data[Home] [Help]

APPS.ZX_TCM_EXT_SERVICES_PUB dependencies on ZX_EVNT_CLS_MAPPINGS

Line 241: p_application_id IN ZX_EVNT_CLS_MAPPINGS.APPLICATION_ID%TYPE,

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,
245: p_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,

Line 242: p_entity_code IN ZX_EVNT_CLS_MAPPINGS.ENTITY_CODE%TYPE,

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,
245: p_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
246: p_org_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE,

Line 243: p_event_class_code IN ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_CODE%TYPE,

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,
245: p_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
246: p_org_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE,
247: p_default_code OUT NOCOPY VARCHAR2,

Line 244: p_source_event_class_code IN ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_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,
245: p_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
246: p_org_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE,
247: p_default_code OUT NOCOPY VARCHAR2,
248: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS

Line 260: l_tax_event_class_code ZX_EVNT_CLS_MAPPINGS.TAX_EVENT_CLASS_CODE%TYPE;

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

Line 270: l_intrcmp_code zx_evnt_cls_mappings.intrcmp_tx_evnt_cls_code%TYPE;

266: l_status varchar2(1);
267: l_db_status varchar2(1);
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:

Line 298: /* Bug 5102996 no need to issue query against zx_evnt_cls_mappings or

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
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

Line 303: FROM zx_evnt_cls_mappings

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
304: WHERE application_id = p_application_id
305: AND entity_code = p_entity_code
306: AND event_class_code = p_event_class_code;
307: