DBA Data[Home] [Help]

APPS.OZF_CLAIMS_PKG dependencies on OZF_CLAIMS_ALL

Line 207: INSERT INTO OZF_CLAIMS_ALL(

203:
204: px_object_version_number := 1;
205:
206:
207: INSERT INTO OZF_CLAIMS_ALL(
208: claim_id,
209: object_version_number,
210: last_update_date,
211: last_updated_by,

Line 677: Update OZF_CLAIMS_ALL

673: p_approval_in_prog VARCHAR2
674: )
675: IS
676: BEGIN
677: Update OZF_CLAIMS_ALL
678: SET
679: claim_id = p_claim_id,
680: object_version_number = p_object_version_number,
681: last_update_date = p_last_update_date,

Line 855: DELETE FROM OZF_CLAIMS_ALL

851: PROCEDURE Delete_Row(
852: p_CLAIM_ID NUMBER)
853: IS
854: BEGIN
855: DELETE FROM OZF_CLAIMS_ALL
856: WHERE CLAIM_ID = p_CLAIM_ID;
857: If (SQL%NOTFOUND) then
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: End If;

Line 1029: FROM OZF_CLAIMS_ALL

1025:
1026: IS
1027: CURSOR C IS
1028: SELECT *
1029: FROM OZF_CLAIMS_ALL
1030: WHERE CLAIM_ID = p_CLAIM_ID
1031: FOR UPDATE of CLAIM_ID NOWAIT;
1032: Recinfo C%ROWTYPE;
1033: BEGIN