DBA Data[Home] [Help]

APPS.OZF_CLAIMS_HISTORY_PKG dependencies on OZF_CLAIMS_HISTORY_ALL

Line 199: INSERT INTO OZF_CLAIMS_HISTORY_ALL(

195:
196: px_object_version_number := 1;
197:
198:
199: INSERT INTO OZF_CLAIMS_HISTORY_ALL(
200: claim_history_id,
201: object_version_number,
202: last_update_date,
203: last_updated_by,

Line 657: Update OZF_CLAIMS_HISTORY_ALL

653: )
654:
655: IS
656: BEGIN
657: Update OZF_CLAIMS_HISTORY_ALL
658: SET
659: claim_history_id = p_claim_history_id,
660: object_version_number = p_object_version_number,
661: last_update_date = p_last_update_date,

Line 830: DELETE FROM OZF_CLAIMS_HISTORY_ALL

826: PROCEDURE Delete_Row(
827: p_CLAIM_HISTORY_ID NUMBER)
828: IS
829: BEGIN
830: DELETE FROM OZF_CLAIMS_HISTORY_ALL
831: WHERE CLAIM_HISTORY_ID = p_CLAIM_HISTORY_ID;
832: If (SQL%NOTFOUND) then
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: End If;

Line 1005: FROM OZF_CLAIMS_HISTORY_ALL

1001:
1002: IS
1003: CURSOR C IS
1004: SELECT *
1005: FROM OZF_CLAIMS_HISTORY_ALL
1006: WHERE CLAIM_HISTORY_ID = p_CLAIM_HISTORY_ID
1007: FOR UPDATE of CLAIM_HISTORY_ID NOWAIT;
1008: Recinfo C%ROWTYPE;
1009: BEGIN