DBA Data[Home] [Help]

APPS.XLE_ASSOCIATION_PKG dependencies on XLE_UTILITY_PUB

Line 111: ,XLE_UTILITY_PUB.LAST_UPDATE_DATE

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

Line 112: ,XLE_UTILITY_PUB.LAST_UPDATED_BY

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: )

Line 113: ,XLE_UTILITY_PUB.CREATION_DATE

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

Line 114: ,XLE_UTILITY_PUB.CREATED_BY

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

Line 115: ,XLE_UTILITY_PUB.LAST_UPDATE_LOGIN

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

Line 188: last_update_date = NVL(p_last_update_date, XLE_UTILITY_PUB.LAST_UPDATE_DATE),

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;

Line 189: last_updated_by = NVL(p_last_updated_by, XLE_UTILITY_PUB.LAST_UPDATED_BY),

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:

Line 190: last_update_login = NVL(p_last_update_login, XLE_UTILITY_PUB.LAST_UPDATE_LOGIN)

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