DBA Data[Home] [Help]

APPS.OZF_CODE_CONVERSION_PKG dependencies on OZF_CODE_CONVERSIONS_ALL

Line 89: INSERT INTO ozf_code_conversions_all(

85:
86: px_object_version_number := nvl(px_object_version_number, 1);
87:
88:
89: INSERT INTO ozf_code_conversions_all(
90: code_conversion_id,
91: object_version_number,
92: last_update_date,
93: last_updated_by,

Line 207: Update ozf_code_conversions_all

203: p_attribute15 VARCHAR2)
204:
205: IS
206: BEGIN
207: Update ozf_code_conversions_all
208: SET
209: code_conversion_id = DECODE( p_code_conversion_id, null, code_conversion_id, FND_API.G_MISS_NUM, null, p_code_conversion_id),
210: object_version_number = nvl(p_object_version_number,0) + 1 ,
211: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

Line 270: DELETE FROM ozf_code_conversions_all

266: p_code_conversion_id NUMBER,
267: p_object_version_number NUMBER)
268: IS
269: BEGIN
270: DELETE FROM ozf_code_conversions_all
271: WHERE code_conversion_id = p_code_conversion_id
272: AND object_version_number = p_object_version_number;
273: If (SQL%NOTFOUND) then
274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;