DBA Data[Home] [Help]

APPS.OZF_RESALE_HEADERS_PKG dependencies on OZF_RESALE_HEADERS_ALL

Line 145: INSERT INTO OZF_RESALE_HEADERS_ALL(

141:
142: px_object_version_number := 1;
143:
144:
145: INSERT INTO OZF_RESALE_HEADERS_ALL(
146: resale_header_id,
147: object_version_number,
148: last_update_date,
149: last_updated_by,

Line 438: Update OZF_RESALE_HEADERS_ALL

434: p_org_id NUMBER)
435:
436: IS
437: BEGIN
438: Update OZF_RESALE_HEADERS_ALL
439: SET
440: resale_header_id = p_resale_header_id,
441: object_version_number = p_object_version_number,
442: last_update_date = p_last_update_date,

Line 557: DELETE FROM OZF_RESALE_HEADERS_ALL

553: PROCEDURE Delete_Row(
554: p_RESALE_HEADER_ID NUMBER)
555: IS
556: BEGIN
557: DELETE FROM OZF_RESALE_HEADERS_ALL
558: WHERE RESALE_HEADER_ID = p_RESALE_HEADER_ID;
559: If (SQL%NOTFOUND) then
560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
561: End If;

Line 677: FROM OZF_RESALE_HEADERS_ALL

673:
674: IS
675: CURSOR C IS
676: SELECT *
677: FROM OZF_RESALE_HEADERS_ALL
678: WHERE RESALE_HEADER_ID = p_RESALE_HEADER_ID
679: FOR UPDATE of RESALE_HEADER_ID NOWAIT;
680: Recinfo C%ROWTYPE;
681: BEGIN