DBA Data[Home] [Help]

APPS.ZX_TCM_EXT_SERVICES_PUB dependencies on MTL_SYSTEM_ITEMS_B

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

Line 246: p_org_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_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
249:
250: /*

Line 344: MTL_SYSTEM_ITEMS_B I

340: -- Get Default Product Type
341: CURSOR c_product_type IS
342: SELECT F.LOOKUP_CODE
343: FROM FND_LOOKUPS F,
344: MTL_SYSTEM_ITEMS_B I
345: WHERE F.LOOKUP_TYPE= 'ZX_PRODUCT_TYPE'
346: AND I.INVENTORY_ITEM_ID = p_item_id
347: AND I.ORGANIZATION_ID = p_org_id
348: AND F.LOOKUP_CODE = DECODE (I.CONTRACT_ITEM_TYPE_CODE,

Line 911: p_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,

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

Line 912: p_org_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE,

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
915:
916: /*