APPS.EAM_ASSETATTR_VALUE_PUB dependencies on MTL_EAM_ASSET_ATTR_VALUES

Line 225: if P_DESCRIPTIVE_FLEXFIELD_NAME <> 'MTL_EAM_ASSET_ATTR_VALUES' then

221: -- Bug # 3518888.
222: if (P_DESCRIPTIVE_FLEXFIELD_NAME IS NULL) then
223: RAISE_ERROR('EAM_INVALID_DFF_NAME');
224: end if;
225: if P_DESCRIPTIVE_FLEXFIELD_NAME <> 'MTL_EAM_ASSET_ATTR_VALUES' then
226: RAISE_ERROR('EAM_INVALID_DFF_NAME');
227: end if;
228: END ;
229:

Line 238: WHERE DESCRIPTIVE_FLEXFIELD_NAME = 'MTL_EAM_ASSET_ATTR_VALUES'

234:
235:
236: SELECT COUNT(*) INTO l_count
237: FROM FND_DESCR_FLEX_CONTEXTS_VL
238: WHERE DESCRIPTIVE_FLEXFIELD_NAME = 'MTL_EAM_ASSET_ATTR_VALUES'
239: AND ENABLED_FLAG = 'Y'
240: AND APPLICATION_ID = p_application_id
241: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attribute_category;
242:

Line 349: 'MTL_EAM_ASSET_ATTR_VALUES',

345: fnd_flex_descval.set_column_value('D_ATTRIBUTE10', p_d_ATTRIBUTE10);
346:
347: l_validated:= FND_FLEX_DESCVAL.validate_desccols(
348: 'INV',
349: 'MTL_EAM_ASSET_ATTR_VALUES',
350: 'I',
351: sysdate ) ;
352:
353: if (not l_validated) then

Line 375: FROM MTL_EAM_ASSET_ATTR_VALUES

371: is
372: l_count number;
373: BEGIN
374: SELECT COUNT(*) INTO l_count
375: FROM MTL_EAM_ASSET_ATTR_VALUES
376: WHERE association_id = p_association_id and
377: inventory_item_id = p_inventory_item_id and
378: serial_number = p_serial_number and
379: /* removing this as creation_organization_id is not used */

Line 414: P_DESCRIPTIVE_FLEXFIELD_NAME IN VARCHAR2 default 'MTL_EAM_ASSET_ATTR_VALUES' ,

410: x_msg_count OUT NOCOPY NUMBER ,
411: x_msg_data OUT NOCOPY VARCHAR2 ,
412: P_ASSOCIATION_ID IN NUMBER ,
413: P_APPLICATION_ID IN NUMBER default 401,
414: P_DESCRIPTIVE_FLEXFIELD_NAME IN VARCHAR2 default 'MTL_EAM_ASSET_ATTR_VALUES' ,
415: P_INVENTORY_ITEM_ID IN NUMBER default null,
416: P_SERIAL_NUMBER IN VARCHAR2 default null,
417: P_ORGANIZATION_ID IN NUMBER ,
418: P_ATTRIBUTE_CATEGORY IN VARCHAR2 ,

Line 774: INSERT INTO MTL_EAM_ASSET_ATTR_VALUES

770: TRUE,
771: l_item_type);
772:
773:
774: INSERT INTO MTL_EAM_ASSET_ATTR_VALUES
775: (
776: ASSOCIATION_ID ,
777: INVENTORY_ITEM_ID ,
778: SERIAL_NUMBER ,

Line 953: P_DESCRIPTIVE_FLEXFIELD_NAME IN VARCHAR2 default 'MTL_EAM_ASSET_ATTR_VALUES' ,

949: x_msg_count OUT NOCOPY NUMBER ,
950: x_msg_data OUT NOCOPY VARCHAR2 ,
951: P_ASSOCIATION_ID IN NUMBER ,
952: P_APPLICATION_ID IN NUMBER default 401,
953: P_DESCRIPTIVE_FLEXFIELD_NAME IN VARCHAR2 default 'MTL_EAM_ASSET_ATTR_VALUES' ,
954: P_INVENTORY_ITEM_ID IN NUMBER default null,
955: P_SERIAL_NUMBER IN VARCHAR2 default null ,
956: P_ORGANIZATION_ID IN NUMBER ,
957: P_ATTRIBUTE_CATEGORY IN VARCHAR2 ,

Line 1287: update MTL_EAM_ASSET_ATTR_VALUES

1283: p_d_ATTRIBUTE10
1284: );
1285:
1286:
1287: update MTL_EAM_ASSET_ATTR_VALUES
1288: set
1289: --ASSOCIATION_ID = P_ASSOCIATION_ID ,
1290: --INVENTORY_ITEM_ID= l_asset_group_id,/*P_INVENTORY_ITEM_ID ,*/
1291: --SERIAL_NUMBER = l_serial_number,/*P_SERIAL_NUMBER ,*/