107: ,DECODE(p_assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18)
108: ,DECODE(p_assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19)
109: ,DECODE(p_assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20)
110: ,DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
111: ,XLE_UTILITY_PUB.LAST_UPDATE_DATE
112: ,XLE_UTILITY_PUB.LAST_UPDATED_BY
113: ,XLE_UTILITY_PUB.CREATION_DATE
114: ,XLE_UTILITY_PUB.CREATED_BY
115: ,XLE_UTILITY_PUB.LAST_UPDATE_LOGIN
108: ,DECODE(p_assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19)
109: ,DECODE(p_assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20)
110: ,DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
111: ,XLE_UTILITY_PUB.LAST_UPDATE_DATE
112: ,XLE_UTILITY_PUB.LAST_UPDATED_BY
113: ,XLE_UTILITY_PUB.CREATION_DATE
114: ,XLE_UTILITY_PUB.CREATED_BY
115: ,XLE_UTILITY_PUB.LAST_UPDATE_LOGIN
116: )
109: ,DECODE(p_assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20)
110: ,DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
111: ,XLE_UTILITY_PUB.LAST_UPDATE_DATE
112: ,XLE_UTILITY_PUB.LAST_UPDATED_BY
113: ,XLE_UTILITY_PUB.CREATION_DATE
114: ,XLE_UTILITY_PUB.CREATED_BY
115: ,XLE_UTILITY_PUB.LAST_UPDATE_LOGIN
116: )
117: RETURNING
110: ,DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
111: ,XLE_UTILITY_PUB.LAST_UPDATE_DATE
112: ,XLE_UTILITY_PUB.LAST_UPDATED_BY
113: ,XLE_UTILITY_PUB.CREATION_DATE
114: ,XLE_UTILITY_PUB.CREATED_BY
115: ,XLE_UTILITY_PUB.LAST_UPDATE_LOGIN
116: )
117: RETURNING
118: association_id
111: ,XLE_UTILITY_PUB.LAST_UPDATE_DATE
112: ,XLE_UTILITY_PUB.LAST_UPDATED_BY
113: ,XLE_UTILITY_PUB.CREATION_DATE
114: ,XLE_UTILITY_PUB.CREATED_BY
115: ,XLE_UTILITY_PUB.LAST_UPDATE_LOGIN
116: )
117: RETURNING
118: association_id
119: INTO
184: assoc_information18 = DECODE (p_assoc_information18, NULL, assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18),
185: assoc_information19 = DECODE (p_assoc_information19, NULL, assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19),
186: assoc_information20 = DECODE (p_assoc_information20, NULL, assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20),
187: object_version_number = DECODE(p_object_version_number, NULL, object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number),
188: last_update_date = NVL(p_last_update_date, XLE_UTILITY_PUB.LAST_UPDATE_DATE),
189: last_updated_by = NVL(p_last_updated_by, XLE_UTILITY_PUB.LAST_UPDATED_BY),
190: last_update_login = NVL(p_last_update_login, XLE_UTILITY_PUB.LAST_UPDATE_LOGIN)
191:
192: WHERE association_id = p_association_id;
185: assoc_information19 = DECODE (p_assoc_information19, NULL, assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19),
186: assoc_information20 = DECODE (p_assoc_information20, NULL, assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20),
187: object_version_number = DECODE(p_object_version_number, NULL, object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number),
188: last_update_date = NVL(p_last_update_date, XLE_UTILITY_PUB.LAST_UPDATE_DATE),
189: last_updated_by = NVL(p_last_updated_by, XLE_UTILITY_PUB.LAST_UPDATED_BY),
190: last_update_login = NVL(p_last_update_login, XLE_UTILITY_PUB.LAST_UPDATE_LOGIN)
191:
192: WHERE association_id = p_association_id;
193:
186: assoc_information20 = DECODE (p_assoc_information20, NULL, assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20),
187: object_version_number = DECODE(p_object_version_number, NULL, object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number),
188: last_update_date = NVL(p_last_update_date, XLE_UTILITY_PUB.LAST_UPDATE_DATE),
189: last_updated_by = NVL(p_last_updated_by, XLE_UTILITY_PUB.LAST_UPDATED_BY),
190: last_update_login = NVL(p_last_update_login, XLE_UTILITY_PUB.LAST_UPDATE_LOGIN)
191:
192: WHERE association_id = p_association_id;
193:
194: IF (sql%notfound) THEN