DBA Data[Home] [Help]

APPS.OZF_CLAIMS_PKG dependencies on OZF_CLAIMS_ALL

Line 202: INSERT INTO OZF_CLAIMS_ALL(

198:
199: px_object_version_number := 1;
200:
201:
202: INSERT INTO OZF_CLAIMS_ALL(
203: claim_id,
204: object_version_number,
205: last_update_date,
206: last_updated_by,

Line 655: Update OZF_CLAIMS_ALL

651: p_open_status_id NUMBER
652: )
653: IS
654: BEGIN
655: Update OZF_CLAIMS_ALL
656: SET
657: claim_id = p_claim_id,
658: object_version_number = p_object_version_number,
659: last_update_date = p_last_update_date,

Line 827: DELETE FROM OZF_CLAIMS_ALL

823: PROCEDURE Delete_Row(
824: p_CLAIM_ID NUMBER)
825: IS
826: BEGIN
827: DELETE FROM OZF_CLAIMS_ALL
828: WHERE CLAIM_ID = p_CLAIM_ID;
829: If (SQL%NOTFOUND) then
830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
831: End If;

Line 1001: FROM OZF_CLAIMS_ALL

997:
998: IS
999: CURSOR C IS
1000: SELECT *
1001: FROM OZF_CLAIMS_ALL
1002: WHERE CLAIM_ID = p_CLAIM_ID
1003: FOR UPDATE of CLAIM_ID NOWAIT;
1004: Recinfo C%ROWTYPE;
1005: BEGIN