DBA Data[Home] [Help]

APPS.OZF_CODE_CONVERSION_PKG dependencies on OZF_SUPP_CODE_CONVERSIONS_ALL

Line 342: INSERT INTO ozf_supp_code_conversions_all(

338:
339: px_object_version_number := nvl(px_object_version_number, 1);
340:
341:
342: INSERT INTO ozf_supp_code_conversions_all(
343: code_conversion_id,
344: object_version_number,
345: last_update_date,
346: last_updated_by,

Line 457: Update ozf_supp_code_conversions_all

453: p_attribute15 VARCHAR2)
454:
455: IS
456: BEGIN
457: Update ozf_supp_code_conversions_all
458: SET
459: code_conversion_id = DECODE( p_code_conversion_id, null, code_conversion_id, FND_API.G_MISS_NUM, null, p_code_conversion_id),
460: object_version_number = nvl(p_object_version_number,0) + 1 ,
461: 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 519: DELETE FROM ozf_supp_code_conversions_all

515: p_code_conversion_id NUMBER,
516: p_object_version_number NUMBER)
517: IS
518: BEGIN
519: DELETE FROM ozf_supp_code_conversions_all
520: WHERE code_conversion_id = p_code_conversion_id
521: AND object_version_number = p_object_version_number;
522: If (SQL%NOTFOUND) then
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;