APPS.OZF_RESALE_ADJUSTMENTS_PKG dependencies on OZF_RESALE_ADJUSTMENTS_ALL

Line 118: INSERT INTO OZF_RESALE_ADJUSTMENTS_ALL(

114:
115: px_object_version_number := 1;
116:
117:
118: INSERT INTO OZF_RESALE_ADJUSTMENTS_ALL(
119: resale_adjustment_id,
120: object_version_number,
121: last_update_date,
122: last_updated_by,

Line 294: Update OZF_RESALE_ADJUSTMENTS_ALL

290: p_org_id NUMBER)
291:
292: IS
293: BEGIN
294: Update OZF_RESALE_ADJUSTMENTS_ALL
295: SET
296: resale_adjustment_id = p_resale_adjustment_id,
297: object_version_number = p_object_version_number,
298: last_update_date = p_last_update_date,

Line 374: DELETE FROM OZF_RESALE_ADJUSTMENTS_ALL

370: PROCEDURE Delete_Row(
371: p_RESALE_ADJUSTMENT_ID NUMBER)
372: IS
373: BEGIN
374: DELETE FROM OZF_RESALE_ADJUSTMENTS_ALL
375: WHERE RESALE_ADJUSTMENT_ID = p_RESALE_ADJUSTMENT_ID;
376: If (SQL%NOTFOUND) then
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: End If;

Line 455: FROM OZF_RESALE_ADJUSTMENTS_ALL

451:
452: IS
453: CURSOR C IS
454: SELECT *
455: FROM OZF_RESALE_ADJUSTMENTS_ALL
456: WHERE RESALE_ADJUSTMENT_ID = p_RESALE_ADJUSTMENT_ID
457: FOR UPDATE of RESALE_ADJUSTMENT_ID NOWAIT;
458: Recinfo C%ROWTYPE;
459: BEGIN