DBA Data[Home] [Help]

APPS.OZF_CLAIM_LINES_INT_PKG dependencies on OZF_CLAIM_LINES_INT_ALL

Line 118: INSERT INTO OZF_CLAIM_LINES_INT_ALL(

114:
115: px_object_version_number := 1;
116:
117:
118: INSERT INTO OZF_CLAIM_LINES_INT_ALL(
119: interface_claim_line_id,
120: object_version_number,
121: last_update_date,
122: last_updated_by,

Line 327: Update OZF_CLAIM_LINES_INT_ALL

323: p_org_id NUMBER)
324:
325: IS
326: BEGIN
327: Update OZF_CLAIM_LINES_INT_ALL
328: SET
329: interface_claim_line_id = p_interface_claim_line_id,
330: object_version_number = p_object_version_number,
331: last_update_date = p_last_update_date,

Line 418: DELETE FROM OZF_CLAIM_LINES_INT_ALL

414: PROCEDURE Delete_Row(
415: p_INTERFACE_CLAIM_LINE_ID NUMBER)
416: IS
417: BEGIN
418: DELETE FROM OZF_CLAIM_LINES_INT_ALL
419: WHERE INTERFACE_CLAIM_LINE_ID = p_INTERFACE_CLAIM_LINE_ID;
420: If (SQL%NOTFOUND) then
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: End If;

Line 510: FROM OZF_CLAIM_LINES_INT_ALL

506:
507: IS
508: CURSOR C IS
509: SELECT *
510: FROM OZF_CLAIM_LINES_INT_ALL
511: WHERE INTERFACE_CLAIM_LINE_ID = p_INTERFACE_CLAIM_LINE_ID
512: FOR UPDATE of INTERFACE_CLAIM_LINE_ID NOWAIT;
513: Recinfo C%ROWTYPE;
514: BEGIN