124:
125: px_object_version_number := 1;
126:
127:
128: INSERT INTO OZF_AE_LINES_ALL(
129: ae_line_id,
130: object_version_number,
131: last_update_date,
132: last_updated_by,
366: p_attribute15 VARCHAR2)
367:
368: IS
369: BEGIN
370: Update OZF_AE_LINES_ALL
371: SET
372: ae_line_id = p_ae_line_id,
373: object_version_number = p_object_version_number,
374: last_update_date = p_last_update_date,
468: PROCEDURE Delete_Row(
469: p_AE_LINE_ID NUMBER)
470: IS
471: BEGIN
472: DELETE FROM OZF_AE_LINES_ALL
473: WHERE AE_LINE_ID = p_AE_LINE_ID;
474: If (SQL%NOTFOUND) then
475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476: End If;
571:
572: IS
573: CURSOR C IS
574: SELECT *
575: FROM OZF_AE_LINES_ALL
576: WHERE AE_LINE_ID = p_AE_LINE_ID
577: FOR UPDATE of AE_LINE_ID NOWAIT;
578: Recinfo C%ROWTYPE;
579: BEGIN