APPS.OZF_RESALE_BATCHES_PKG dependencies on OZF_RESALE_BATCHES_ALL

Line 129: INSERT INTO OZF_RESALE_BATCHES_ALL(

125:
126: px_object_version_number := 1;
127:
128:
129: INSERT INTO OZF_RESALE_BATCHES_ALL(
130: resale_batch_id,
131: object_version_number,
132: last_update_date,
133: last_updated_by,

Line 368: UPDATE OZF_RESALE_BATCHES_ALL

364: p_org_id NUMBER)
365:
366: IS
367: BEGIN
368: UPDATE OZF_RESALE_BATCHES_ALL
369: SET
370: resale_batch_id = p_resale_batch_id,
371: object_version_number = p_object_version_number,
372: last_update_date = p_last_update_date,

Line 468: DELETE FROM OZF_RESALE_BATCHES_ALL

464: PROCEDURE Delete_Row(
465: p_RESALE_BATCH_ID NUMBER)
466: IS
467: BEGIN
468: DELETE FROM OZF_RESALE_BATCHES_ALL
469: WHERE RESALE_BATCH_ID = p_RESALE_BATCH_ID;
470: If (SQL%NOTFOUND) then
471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472: End If;

Line 570: FROM OZF_RESALE_BATCHES_ALL

566:
567: IS
568: CURSOR C IS
569: SELECT *
570: FROM OZF_RESALE_BATCHES_ALL
571: WHERE RESALE_BATCH_ID = p_RESALE_BATCH_ID
572: FOR UPDATE of RESALE_BATCH_ID NOWAIT;
573: Recinfo C%ROWTYPE;
574: BEGIN