DBA Data[Home] [Help]

APPS.OZF_RESALE_LINES_INT_PKG dependencies on OZF_RESALE_LINES_INT_ALL

Line 299: INSERT INTO OZF_RESALE_LINES_INT_ALL(

295:
296: px_object_version_number := 1;
297:
298:
299: INSERT INTO OZF_RESALE_LINES_INT_ALL(
300: resale_line_int_id,
301: object_version_number,
302: last_update_date,
303: last_updated_by,

Line 1019: Update OZF_RESALE_LINES_INT_ALL

1015: )
1016:
1017: IS
1018: BEGIN
1019: Update OZF_RESALE_LINES_INT_ALL
1020: SET
1021: resale_line_int_id = p_resale_line_int_id,
1022: object_version_number = p_object_version_number,
1023: last_update_date = p_last_update_date,

Line 1282: DELETE FROM OZF_RESALE_LINES_INT_ALL

1278: PROCEDURE Delete_Row(
1279: p_RESALE_LINE_INT_ID NUMBER)
1280: IS
1281: BEGIN
1282: DELETE FROM OZF_RESALE_LINES_INT_ALL
1283: WHERE RESALE_LINE_INT_ID = p_RESALE_LINE_INT_ID;
1284: If (SQL%NOTFOUND) then
1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1286: End If;

Line 1545: FROM OZF_RESALE_LINES_INT_ALL

1541:
1542: IS
1543: CURSOR C IS
1544: SELECT *
1545: FROM OZF_RESALE_LINES_INT_ALL
1546: WHERE RESALE_LINE_INT_ID = p_RESALE_LINE_INT_ID
1547: FOR UPDATE of RESALE_LINE_INT_ID NOWAIT;
1548: Recinfo C%ROWTYPE;
1549: BEGIN