DBA Data[Home] [Help]

APPS.OZF_CLAIM_LINES_HIST_PKG dependencies on OZF_CLAIM_LINES_HIST_ALL

Line 134: INSERT INTO OZF_CLAIM_LINES_HIST_ALL(

130: END IF;
131:
132: px_object_version_number := 1;
133:
134: INSERT INTO OZF_CLAIM_LINES_HIST_ALL(
135: claim_line_history_id,
136: object_version_number,
137: last_update_date,
138: last_updated_by,

Line 416: UPDATE OZF_CLAIM_LINES_HIST_ALL

412: p_earnings_end_date DATE
413: )
414: IS
415: BEGIN
416: UPDATE OZF_CLAIM_LINES_HIST_ALL
417: SET claim_line_history_id = p_claim_line_history_id,
418: object_version_number = p_object_version_number,
419: last_update_date = p_last_update_date,
420: last_updated_by = p_last_updated_by,

Line 529: DELETE FROM OZF_CLAIM_LINES_HIST_ALL

525: p_claim_line_history_id NUMBER
526: )
527: IS
528: BEGIN
529: DELETE FROM OZF_CLAIM_LINES_HIST_ALL
530: WHERE CLAIM_LINE_HISTORY_ID = p_CLAIM_LINE_HISTORY_ID;
531: If (SQL%NOTFOUND) then
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: End If;

Line 641: FROM OZF_CLAIM_LINES_HIST_ALL

637: )
638: IS
639: CURSOR C IS
640: SELECT *
641: FROM OZF_CLAIM_LINES_HIST_ALL
642: WHERE CLAIM_LINE_HISTORY_ID = p_CLAIM_LINE_HISTORY_ID
643: FOR UPDATE of CLAIM_LINE_HISTORY_ID NOWAIT;
644: Recinfo C%ROWTYPE;
645: BEGIN