APPS.OZF_CLAIM_LINE_HIST_PVT dependencies on OZF_CLAIM_LINES_HIST_ALL

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 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 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 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;