DBA Data[Home] [Help]

APPS.OZF_CLAIMS_INT_PKG dependencies on OZF_CLAIMS_INT_ALL

Line 183: INSERT INTO OZF_CLAIMS_INT_ALL(

179:
180: px_object_version_number := 1;
181:
182:
183: INSERT INTO OZF_CLAIMS_INT_ALL(
184: interface_claim_id,
185: object_version_number,
186: last_update_date,
187: last_updated_by,

Line 589: Update OZF_CLAIMS_INT_ALL

585: p_ship_to_cust_account_id NUMBER)
586:
587: IS
588: BEGIN
589: Update OZF_CLAIMS_INT_ALL
590: SET
591: interface_claim_id = p_interface_claim_id,
592: object_version_number = p_object_version_number,
593: last_update_date = p_last_update_date,

Line 745: DELETE FROM OZF_CLAIMS_INT_ALL

741: PROCEDURE Delete_Row(
742: p_INTERFACE_CLAIM_ID NUMBER)
743: IS
744: BEGIN
745: DELETE FROM OZF_CLAIMS_INT_ALL
746: WHERE INTERFACE_CLAIM_ID = p_INTERFACE_CLAIM_ID;
747: If (SQL%NOTFOUND) then
748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
749: End If;

Line 902: FROM OZF_CLAIMS_INT_ALL

898:
899: IS
900: CURSOR C IS
901: SELECT *
902: FROM OZF_CLAIMS_INT_ALL
903: WHERE INTERFACE_CLAIM_ID = p_INTERFACE_CLAIM_ID
904: FOR UPDATE of INTERFACE_CLAIM_ID NOWAIT;
905: Recinfo C%ROWTYPE;
906: BEGIN