APPS.AMS_DM_IMP_ATTRIBUTE_PKG dependencies on AMS_DM_IMP_ATTRIBUTES

Line 61: INSERT INTO ams_dm_imp_attributes(

57:
58: px_object_version_number := nvl(px_object_version_number, 1);
59:
60:
61: INSERT INTO ams_dm_imp_attributes(
62: imp_attribute_id,
63: last_update_date,
64: last_updated_by,
65: creation_date,

Line 116: Update ams_dm_imp_attributes

112: p_value NUMBER
113: )
114: IS
115: BEGIN
116: Update ams_dm_imp_attributes
117: SET
118: imp_attribute_id = DECODE( p_Dm_Imp_Attribute_id, null, imp_attribute_id, FND_API.G_MISS_NUM, null, p_Dm_Imp_Attribute_id),
119: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
120: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 159: DELETE FROM ams_dm_imp_attributes

155: p_Dm_Imp_Attribute_id NUMBER,
156: p_object_version_number NUMBER)
157: IS
158: BEGIN
159: DELETE FROM ams_dm_imp_attributes
160: WHERE imp_attribute_id = p_Dm_Imp_Attribute_id
161: AND object_version_number = p_object_version_number;
162: If (SQL%NOTFOUND) then
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 188: FROM ams_dm_imp_attributes

184: p_Dm_Imp_Attribute_id NUMBER)
185: IS
186: CURSOR C IS
187: SELECT *
188: FROM ams_dm_imp_attributes
189: WHERE imp_attribute_id = p_Dm_Imp_Attribute_id
190: FOR UPDATE OF imp_attribute_id NOWAIT;
191: Recinfo C%ROWTYPE;
192: BEGIN