APPS.OZF_RESALE_BATCHES_PKG dependencies on OZF_RESALE_BATCHES_ALL

Line 131: INSERT INTO OZF_RESALE_BATCHES_ALL(

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

Line 373: UPDATE OZF_RESALE_BATCHES_ALL

369: p_direct_order_flag VARCHAR2) -- For Bug#9447673 SSD IDSM ER
370:
371: IS
372: BEGIN
373: UPDATE OZF_RESALE_BATCHES_ALL
374: SET
375: resale_batch_id = p_resale_batch_id,
376: object_version_number = p_object_version_number,
377: last_update_date = p_last_update_date,

Line 474: DELETE FROM OZF_RESALE_BATCHES_ALL

470: PROCEDURE Delete_Row(
471: p_RESALE_BATCH_ID NUMBER)
472: IS
473: BEGIN
474: DELETE FROM OZF_RESALE_BATCHES_ALL
475: WHERE RESALE_BATCH_ID = p_RESALE_BATCH_ID;
476: If (SQL%NOTFOUND) then
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: End If;

Line 577: FROM OZF_RESALE_BATCHES_ALL

573:
574: IS
575: CURSOR C IS
576: SELECT *
577: FROM OZF_RESALE_BATCHES_ALL
578: WHERE RESALE_BATCH_ID = p_RESALE_BATCH_ID
579: FOR UPDATE of RESALE_BATCH_ID NOWAIT;
580: Recinfo C%ROWTYPE;
581: BEGIN