APPS.EAM_ASSET_ATTR_PVT dependencies on MTL_EAM_ASSET_ATTR_VALUES

Line 147: CURSOR C IS SELECT rowid FROM MTL_EAM_ASSET_ATTR_VALUES

143: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
144: l_serial_number varchar2(30);
145: l_inventory_item_id number;
146:
147: CURSOR C IS SELECT rowid FROM MTL_EAM_ASSET_ATTR_VALUES
148: WHERE attribute_category = p_attribute_category
149: AND maintenance_object_type = P_maintenance_object_type
150: AND maintenance_object_id = P_maintenance_object_id
151: ;

Line 183: INSERT INTO MTL_EAM_ASSET_ATTR_VALUES(

179: l_inventory_item_id := p_inventory_item_id;
180: l_serial_number := p_serial_number;
181: end if;
182:
183: INSERT INTO MTL_EAM_ASSET_ATTR_VALUES(
184: association_id,
185: application_id,
186: descriptive_flexfield_name,
187: inventory_item_id,

Line 422: FROM MTL_EAM_ASSET_ATTR_VALUES

418: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
419:
420: CURSOR C IS
421: SELECT *
422: FROM MTL_EAM_ASSET_ATTR_VALUES
423: WHERE rowid = P_Rowid
424: FOR UPDATE of ATTRIBUTE_CATEGORY NOWAIT;
425: Recinfo C%ROWTYPE;
426:

Line 724: UPDATE MTL_EAM_ASSET_ATTR_VALUES

720: x_return_status := fnd_api.g_ret_sts_success;
721:
722: -- API body
723: /* Bug 3371507: used 'decode' function*/
724: UPDATE MTL_EAM_ASSET_ATTR_VALUES
725: set
726: c_attribute1 = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE1, DECODE(p_c_attribute1,NULL,c_attribute1,FND_API.G_MISS_CHAR,NULL,p_c_attribute1)),
727: c_attribute2 = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE2, DECODE(p_c_attribute2,NULL,c_attribute2,FND_API.G_MISS_CHAR,NULL,p_c_attribute2)),
728: c_attribute3 = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE3, DECODE(p_c_attribute3,NULL,c_attribute3,FND_API.G_MISS_CHAR,NULL,p_c_attribute3)),

Line 858: FROM mtl_eam_asset_attr_values

854:
855: -- API body
856: BEGIN
857: SELECT maintenance_object_id into l_object_id
858: FROM mtl_eam_asset_attr_values
859: WHERE rowid = p_rowid;
860:
861: Delete from mtl_eam_asset_attr_values
862: where rowid = p_rowid;

Line 861: Delete from mtl_eam_asset_attr_values

857: SELECT maintenance_object_id into l_object_id
858: FROM mtl_eam_asset_attr_values
859: WHERE rowid = p_rowid;
860:
861: Delete from mtl_eam_asset_attr_values
862: where rowid = p_rowid;
863:
864:
865: eam_text_util.process_asset_update_event

Line 963: insert into mtl_eam_asset_attr_values

959: and inventory_item_id = p_inventory_item_id;
960:
961:
962:
963: insert into mtl_eam_asset_attr_values
964: (
965: association_id,
966: application_id,
967: descriptive_flexfield_name,

Line 1085: from mtl_eam_asset_attr_values

1081: request_id,
1082: l_object_id,
1083: maintenance_object_type,
1084: organization_id
1085: from mtl_eam_asset_attr_values
1086: where descriptive_flexfield_name = 'MTL_EAM_ASSET_ATTR_VALUES'
1087: and inventory_item_id = p_inventory_item_id
1088: and serial_number = p_serial_number_from
1089: and attribute_category not in (

Line 1086: where descriptive_flexfield_name = 'MTL_EAM_ASSET_ATTR_VALUES'

1082: l_object_id,
1083: maintenance_object_type,
1084: organization_id
1085: from mtl_eam_asset_attr_values
1086: where descriptive_flexfield_name = 'MTL_EAM_ASSET_ATTR_VALUES'
1087: and inventory_item_id = p_inventory_item_id
1088: and serial_number = p_serial_number_from
1089: and attribute_category not in (
1090: select attribute_category

Line 1091: from mtl_eam_asset_attr_values

1087: and inventory_item_id = p_inventory_item_id
1088: and serial_number = p_serial_number_from
1089: and attribute_category not in (
1090: select attribute_category
1091: from mtl_eam_asset_attr_values
1092: where descriptive_flexfield_name = 'MTL_EAM_ASSET_ATTR_VALUES'
1093: and inventory_item_id = p_inventory_item_id
1094: and serial_number = p_serial_number_to
1095: );

Line 1092: where descriptive_flexfield_name = 'MTL_EAM_ASSET_ATTR_VALUES'

1088: and serial_number = p_serial_number_from
1089: and attribute_category not in (
1090: select attribute_category
1091: from mtl_eam_asset_attr_values
1092: where descriptive_flexfield_name = 'MTL_EAM_ASSET_ATTR_VALUES'
1093: and inventory_item_id = p_inventory_item_id
1094: and serial_number = p_serial_number_to
1095: );
1096: