APPS.EAM_ASSETATTR_VALUE_PUB dependencies on MTL_EAM_ASSET_ATTR_VALUES

Line 216: if P_DESCRIPTIVE_FLEXFIELD_NAME <> 'MTL_EAM_ASSET_ATTR_VALUES' then

212: -- Bug # 3518888.
213: if (P_DESCRIPTIVE_FLEXFIELD_NAME IS NULL) then
214: RAISE_ERROR('EAM_INVALID_DFF_NAME');
215: end if;
216: if P_DESCRIPTIVE_FLEXFIELD_NAME <> 'MTL_EAM_ASSET_ATTR_VALUES' then
217: RAISE_ERROR('EAM_INVALID_DFF_NAME');
218: end if;
219: END ;
220:

Line 229: WHERE DESCRIPTIVE_FLEXFIELD_NAME = 'MTL_EAM_ASSET_ATTR_VALUES'

225:
226:
227: SELECT COUNT(*) INTO l_count
228: FROM FND_DESCR_FLEX_CONTEXTS_VL
229: WHERE DESCRIPTIVE_FLEXFIELD_NAME = 'MTL_EAM_ASSET_ATTR_VALUES'
230: AND ENABLED_FLAG = 'Y'
231: AND APPLICATION_ID = p_application_id
232: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attribute_category;
233:

Line 340: 'MTL_EAM_ASSET_ATTR_VALUES',

336: fnd_flex_descval.set_column_value('D_ATTRIBUTE10', p_d_ATTRIBUTE10);
337:
338: l_validated:= FND_FLEX_DESCVAL.validate_desccols(
339: 'INV',
340: 'MTL_EAM_ASSET_ATTR_VALUES',
341: 'I',
342: sysdate ) ;
343:
344: if (not l_validated) then

Line 366: FROM MTL_EAM_ASSET_ATTR_VALUES

362: is
363: l_count number;
364: BEGIN
365: SELECT COUNT(*) INTO l_count
366: FROM MTL_EAM_ASSET_ATTR_VALUES
367: WHERE association_id = p_association_id and
368: inventory_item_id = p_inventory_item_id and
369: serial_number = p_serial_number and
370: /* removing this as creation_organization_id is not used */

Line 405: P_DESCRIPTIVE_FLEXFIELD_NAME IN VARCHAR2 default 'MTL_EAM_ASSET_ATTR_VALUES' ,

401: x_msg_count OUT NOCOPY NUMBER ,
402: x_msg_data OUT NOCOPY VARCHAR2 ,
403: P_ASSOCIATION_ID IN NUMBER ,
404: P_APPLICATION_ID IN NUMBER default 401,
405: P_DESCRIPTIVE_FLEXFIELD_NAME IN VARCHAR2 default 'MTL_EAM_ASSET_ATTR_VALUES' ,
406: P_INVENTORY_ITEM_ID IN NUMBER default null,
407: P_SERIAL_NUMBER IN VARCHAR2 default null,
408: P_ORGANIZATION_ID IN NUMBER ,
409: P_ATTRIBUTE_CATEGORY IN VARCHAR2 ,

Line 765: INSERT INTO MTL_EAM_ASSET_ATTR_VALUES

761: TRUE,
762: l_item_type);
763:
764:
765: INSERT INTO MTL_EAM_ASSET_ATTR_VALUES
766: (
767: ASSOCIATION_ID ,
768: INVENTORY_ITEM_ID ,
769: SERIAL_NUMBER ,

Line 944: P_DESCRIPTIVE_FLEXFIELD_NAME IN VARCHAR2 default 'MTL_EAM_ASSET_ATTR_VALUES' ,

940: x_msg_count OUT NOCOPY NUMBER ,
941: x_msg_data OUT NOCOPY VARCHAR2 ,
942: P_ASSOCIATION_ID IN NUMBER ,
943: P_APPLICATION_ID IN NUMBER default 401,
944: P_DESCRIPTIVE_FLEXFIELD_NAME IN VARCHAR2 default 'MTL_EAM_ASSET_ATTR_VALUES' ,
945: P_INVENTORY_ITEM_ID IN NUMBER default null,
946: P_SERIAL_NUMBER IN VARCHAR2 default null ,
947: P_ORGANIZATION_ID IN NUMBER ,
948: P_ATTRIBUTE_CATEGORY IN VARCHAR2 ,

Line 1278: update MTL_EAM_ASSET_ATTR_VALUES

1274: p_d_ATTRIBUTE10
1275: );
1276:
1277:
1278: update MTL_EAM_ASSET_ATTR_VALUES
1279: set
1280: --ASSOCIATION_ID = P_ASSOCIATION_ID ,
1281: --INVENTORY_ITEM_ID= l_asset_group_id,/*P_INVENTORY_ITEM_ID ,*/
1282: --SERIAL_NUMBER = l_serial_number,/*P_SERIAL_NUMBER ,*/