eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_CLAIM_LINE_HIST_PVT dependencies on OZF_CLAIM_LINES_HIST

Line 48: SELECT OZF_CLAIM_LINES_HIST_ALL_s.NEXTVAL

44: l_dummy NUMBER;
45: l_claim_line_hist_rec claim_line_hist_rec_type := p_claim_line_hist_rec;
46:
47: CURSOR c_id IS
48: SELECT OZF_CLAIM_LINES_HIST_ALL_s.NEXTVAL
49: FROM dual;
50:
51: CURSOR c_id_exists (l_id IN NUMBER) IS
52: SELECT 1

Line 53: FROM OZF_CLAIM_LINES_HIST_ALL

49: FROM dual;
50:
51: CURSOR c_id_exists (l_id IN NUMBER) IS
52: SELECT 1
53: FROM OZF_CLAIM_LINES_HIST_ALL
54: WHERE CLAIM_LINE_HISTORY_ID = l_id;
55:
56: BEGIN
57: -- Standard Start of API savepoint

Line 151: -- Invoke table handler(OZF_CLAIM_LINES_HIST_PKG.Insert_Row)

147: END IF;
148:
149: l_org_id := l_claim_line_hist_rec.org_id;
150: BEGIN
151: -- Invoke table handler(OZF_CLAIM_LINES_HIST_PKG.Insert_Row)
152: OZF_CLAIM_LINES_HIST_PKG.Insert_Row(
153: px_claim_line_history_id => l_claim_line_history_id,
154: px_object_version_number => l_object_version_number,
155: p_last_update_date => SYSDATE,

Line 152: OZF_CLAIM_LINES_HIST_PKG.Insert_Row(

148:
149: l_org_id := l_claim_line_hist_rec.org_id;
150: BEGIN
151: -- Invoke table handler(OZF_CLAIM_LINES_HIST_PKG.Insert_Row)
152: OZF_CLAIM_LINES_HIST_PKG.Insert_Row(
153: px_claim_line_history_id => l_claim_line_history_id,
154: px_object_version_number => l_object_version_number,
155: p_last_update_date => SYSDATE,
156: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 326: FROM OZF_CLAIM_LINES_HIST_ALL

322: IS
323: /*
324: CURSOR c_get_claim_line_hist(claim_line_history_id NUMBER) IS
325: SELECT *
326: FROM OZF_CLAIM_LINES_HIST_ALL
327: -- Hint: Developer need to provide Where clause
328: */
329: l_api_name CONSTANT VARCHAR2(30) := 'Update_Claim_Line_Hist';
330: l_api_version_number CONSTANT NUMBER := 1.0;

Line 341: FROM ozf_claim_lines_hist_all

337:
338:
339: CURSOR csr_line_hist_obj_ver(cv_claim_line_hist_id IN NUMBER) IS
340: SELECT object_version_number
341: FROM ozf_claim_lines_hist_all
342: WHERE claim_line_history_id = cv_claim_line_hist_id;
343:
344: BEGIN
345: -- Standard Start of API savepoint

Line 423: -- Invoke table handler(OZF_CLAIM_LINES_HIST_PKG.Update_Row)

419: OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
420: END IF;
421:
422: BEGIN
423: -- Invoke table handler(OZF_CLAIM_LINES_HIST_PKG.Update_Row)
424: OZF_CLAIM_LINES_HIST_PKG.Update_Row(
425: p_claim_line_history_id => p_claim_line_hist_rec.claim_line_history_id,
426: p_object_version_number => p_claim_line_hist_rec.object_version_number,
427: p_last_update_date => SYSDATE,

Line 424: OZF_CLAIM_LINES_HIST_PKG.Update_Row(

420: END IF;
421:
422: BEGIN
423: -- Invoke table handler(OZF_CLAIM_LINES_HIST_PKG.Update_Row)
424: OZF_CLAIM_LINES_HIST_PKG.Update_Row(
425: p_claim_line_history_id => p_claim_line_hist_rec.claim_line_history_id,
426: p_object_version_number => p_claim_line_hist_rec.object_version_number,
427: p_last_update_date => SYSDATE,
428: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 595: FROM ozf_claim_lines_hist_all

591: l_object_version_number NUMBER;
592:
593: CURSOR csr_line_hist_obj_ver(cv_line_hist_id IN NUMBER) IS
594: SELECT object_version_number
595: FROM ozf_claim_lines_hist_all
596: WHERE claim_line_history_id = cv_line_hist_id;
597:
598: BEGIN
599: -- Standard Start of API savepoint

Line 637: -- Invoke table handler(OZF_CLAIM_LINES_HIST_PKG.Delete_Row)

633: IF g_debug THEN
634: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
635: END IF;
636:
637: -- Invoke table handler(OZF_CLAIM_LINES_HIST_PKG.Delete_Row)
638: OZF_CLAIM_LINES_HIST_PKG.Delete_Row(
639: p_claim_line_history_id => p_claim_line_history_id
640: );
641: EXCEPTION

Line 638: OZF_CLAIM_LINES_HIST_PKG.Delete_Row(

634: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
635: END IF;
636:
637: -- Invoke table handler(OZF_CLAIM_LINES_HIST_PKG.Delete_Row)
638: OZF_CLAIM_LINES_HIST_PKG.Delete_Row(
639: p_claim_line_history_id => p_claim_line_history_id
640: );
641: EXCEPTION
642: WHEN OTHERS THEN

Line 733: FROM ozf_claim_lines_hist_all

729: l_claim_line_history_id NUMBER;
730:
731: CURSOR c_Claim_Line_Hist IS
732: SELECT claim_line_history_id
733: FROM ozf_claim_lines_hist_all
734: WHERE claim_line_history_id = p_claim_line_history_id
735: AND object_version_number = p_object_version
736: FOR UPDATE NOWAIT;
737:

Line 842: 'OZF_CLAIM_LINES_HIST_ALL',

838: x_return_status := FND_API.g_ret_sts_success;
839:
840: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
841: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
842: 'OZF_CLAIM_LINES_HIST_ALL',
843: 'CLAIM_LINE_HISTORY_ID = ''' || p_claim_line_hist_rec.CLAIM_LINE_HISTORY_ID ||''''
844: );
845: ELSE
846: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

Line 847: 'OZF_CLAIM_LINES_HIST_ALL',

843: 'CLAIM_LINE_HISTORY_ID = ''' || p_claim_line_hist_rec.CLAIM_LINE_HISTORY_ID ||''''
844: );
845: ELSE
846: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
847: 'OZF_CLAIM_LINES_HIST_ALL',
848: 'CLAIM_LINE_HISTORY_ID = ''' || p_claim_line_hist_rec.CLAIM_LINE_HISTORY_ID ||
849: ''' AND CLAIM_LINE_HISTORY_ID <> ' || p_claim_line_hist_rec.CLAIM_LINE_HISTORY_ID
850: );
851: END IF;

Line 1115: FROM ozf_claim_lines_hist

1111: l_return_status VARCHAR2(1);
1112:
1113: CURSOR c_complete IS
1114: SELECT *
1115: FROM ozf_claim_lines_hist
1116: WHERE claim_line_history_id = p_claim_line_hist_rec.claim_line_history_id;
1117:
1118: l_claim_line_hist_rec c_complete%ROWTYPE;
1119: