APPS.OZF_SETTLEMENT_DOCS_PKG dependencies on OZF_SETTLEMENT_DOCS_ALL

Line 105: INSERT INTO OZF_SETTLEMENT_DOCS_ALL(

101:
102: px_object_version_number := 1;
103:
104:
105: INSERT INTO OZF_SETTLEMENT_DOCS_ALL(
106: settlement_doc_id,
107: object_version_number,
108: last_update_date,
109: last_updated_by,

Line 268: Update OZF_SETTLEMENT_DOCS_ALL

264: )
265:
266: IS
267: BEGIN
268: Update OZF_SETTLEMENT_DOCS_ALL
269: SET
270: settlement_doc_id = p_settlement_doc_id,
271: object_version_number = p_object_version_number,
272: last_update_date = p_last_update_date,

Line 342: DELETE FROM OZF_SETTLEMENT_DOCS_ALL

338: PROCEDURE Delete_Row(
339: p_SETTLEMENT_DOC_ID NUMBER)
340: IS
341: BEGIN
342: DELETE FROM OZF_SETTLEMENT_DOCS_ALL
343: WHERE SETTLEMENT_DOC_ID = p_SETTLEMENT_DOC_ID;
344: If (SQL%NOTFOUND) then
345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
346: End If;

Line 413: FROM OZF_SETTLEMENT_DOCS_ALL

409:
410: IS
411: CURSOR C IS
412: SELECT *
413: FROM OZF_SETTLEMENT_DOCS_ALL
414: WHERE SETTLEMENT_DOC_ID = p_SETTLEMENT_DOC_ID
415: FOR UPDATE of SETTLEMENT_DOC_ID NOWAIT;
416: Recinfo C%ROWTYPE;
417: BEGIN