APPS.OZF_RESALE_LINES_INT_PKG dependencies on OZF_RESALE_LINES_INT_ALL

Line 291: INSERT INTO OZF_RESALE_LINES_INT_ALL(

287:
288: px_object_version_number := 1;
289:
290:
291: INSERT INTO OZF_RESALE_LINES_INT_ALL(
292: resale_line_int_id,
293: object_version_number,
294: last_update_date,
295: last_updated_by,

Line 989: Update OZF_RESALE_LINES_INT_ALL

985: p_org_id NUMBER)
986:
987: IS
988: BEGIN
989: Update OZF_RESALE_LINES_INT_ALL
990: SET
991: resale_line_int_id = p_resale_line_int_id,
992: object_version_number = p_object_version_number,
993: last_update_date = p_last_update_date,

Line 1243: DELETE FROM OZF_RESALE_LINES_INT_ALL

1239: PROCEDURE Delete_Row(
1240: p_RESALE_LINE_INT_ID NUMBER)
1241: IS
1242: BEGIN
1243: DELETE FROM OZF_RESALE_LINES_INT_ALL
1244: WHERE RESALE_LINE_INT_ID = p_RESALE_LINE_INT_ID;
1245: If (SQL%NOTFOUND) then
1246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1247: End If;

Line 1498: FROM OZF_RESALE_LINES_INT_ALL

1494:
1495: IS
1496: CURSOR C IS
1497: SELECT *
1498: FROM OZF_RESALE_LINES_INT_ALL
1499: WHERE RESALE_LINE_INT_ID = p_RESALE_LINE_INT_ID
1500: FOR UPDATE of RESALE_LINE_INT_ID NOWAIT;
1501: Recinfo C%ROWTYPE;
1502: BEGIN