DBA Data[Home] [Help]

APPS.OZF_RESALE_LINES_PKG dependencies on OZF_RESALE_LINES_ALL

Line 264: INSERT INTO OZF_RESALE_LINES_ALL(

260:
261: px_object_version_number := 1;
262:
263:
264: INSERT INTO OZF_RESALE_LINES_ALL(
265: resale_line_id,
266: resale_header_id,
267: resale_transfer_type,
268: object_version_number,

Line 877: Update OZF_RESALE_LINES_ALL

873: )
874:
875: IS
876: BEGIN
877: Update OZF_RESALE_LINES_ALL
878: SET
879: resale_line_id = p_resale_line_id,
880: resale_header_id = p_resale_header_id,
881: resale_transfer_type = p_resale_transfer_type,

Line 1102: DELETE FROM OZF_RESALE_LINES_ALL

1098: PROCEDURE Delete_Row(
1099: p_RESALE_LINE_ID NUMBER)
1100: IS
1101: BEGIN
1102: DELETE FROM OZF_RESALE_LINES_ALL
1103: WHERE RESALE_LINE_ID = p_RESALE_LINE_ID;
1104: If (SQL%NOTFOUND) then
1105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1106: End If;

Line 1329: FROM OZF_RESALE_LINES_ALL

1325:
1326: IS
1327: CURSOR C IS
1328: SELECT *
1329: FROM OZF_RESALE_LINES_ALL
1330: WHERE RESALE_LINE_ID = p_RESALE_LINE_ID
1331: FOR UPDATE of RESALE_LINE_ID NOWAIT;
1332: Recinfo C%ROWTYPE;
1333: BEGIN