APPS.OZF_RESALE_LINES_PKG dependencies on OZF_RESALE_LINES_ALL

Line 255: INSERT INTO OZF_RESALE_LINES_ALL(

251:
252: px_object_version_number := 1;
253:
254:
255: INSERT INTO OZF_RESALE_LINES_ALL(
256: resale_line_id,
257: resale_header_id,
258: resale_transfer_type,
259: object_version_number,

Line 842: Update OZF_RESALE_LINES_ALL

838: p_org_id NUMBER)
839:
840: IS
841: BEGIN
842: Update OZF_RESALE_LINES_ALL
843: SET
844: resale_line_id = p_resale_line_id,
845: resale_header_id = p_resale_header_id,
846: resale_transfer_type = p_resale_transfer_type,

Line 1059: DELETE FROM OZF_RESALE_LINES_ALL

1055: PROCEDURE Delete_Row(
1056: p_RESALE_LINE_ID NUMBER)
1057: IS
1058: BEGIN
1059: DELETE FROM OZF_RESALE_LINES_ALL
1060: WHERE RESALE_LINE_ID = p_RESALE_LINE_ID;
1061: If (SQL%NOTFOUND) then
1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1063: End If;

Line 1277: FROM OZF_RESALE_LINES_ALL

1273:
1274: IS
1275: CURSOR C IS
1276: SELECT *
1277: FROM OZF_RESALE_LINES_ALL
1278: WHERE RESALE_LINE_ID = p_RESALE_LINE_ID
1279: FOR UPDATE of RESALE_LINE_ID NOWAIT;
1280: Recinfo C%ROWTYPE;
1281: BEGIN