APPS.OZF_CLAIM_LINES_INT_PVT dependencies on OZF_CLAIM_LINES_INT_ALL

Line 47: SELECT OZF_CLAIM_LINES_INT_ALL_s.NEXTVAL

43: l_INTERFACE_CLAIM_LINE_ID NUMBER;
44: l_dummy NUMBER;
45:
46: CURSOR c_id IS
47: SELECT OZF_CLAIM_LINES_INT_ALL_s.NEXTVAL
48: FROM dual;
49:
50: CURSOR c_id_exists (l_id IN NUMBER) IS
51: SELECT 1 FROM dual

Line 52: WHERE EXISTS (SELECT 1 FROM OZF_CLAIM_LINES_INT_ALL

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

Line 285: FROM OZF_CLAIM_LINES_INT_ALL

281: IS
282:
283: CURSOR c_get_claim_lines_int(p_interface_claim_line_id NUMBER) IS
284: SELECT *
285: FROM OZF_CLAIM_LINES_INT_ALL
286: WHERE interface_claim_line_id = p_interface_claim_line_id;
287:
288: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Claim_Lines_Int';
289: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 651: FROM OZF_CLAIM_LINES_INT_ALL

647: l_INTERFACE_CLAIM_LINE_ID NUMBER;
648:
649: CURSOR c_Claim_Lines_Int IS
650: SELECT INTERFACE_CLAIM_LINE_ID
651: FROM OZF_CLAIM_LINES_INT_ALL
652: WHERE INTERFACE_CLAIM_LINE_ID = p_INTERFACE_CLAIM_LINE_ID
653: AND object_version_number = p_object_version
654: FOR UPDATE NOWAIT;
655:

Line 764: 'OZF_CLAIM_LINES_INT_ALL',

760: BEGIN
761: x_return_status := FND_API.g_ret_sts_success;
762: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
763: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
764: 'OZF_CLAIM_LINES_INT_ALL',
765: 'INTERFACE_CLAIM_LINE_ID = ''' || p_claim_lines_int_rec.INTERFACE_CLAIM_LINE_ID ||''''
766: );
767: ELSE
768: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

Line 769: 'OZF_CLAIM_LINES_INT_ALL',

765: 'INTERFACE_CLAIM_LINE_ID = ''' || p_claim_lines_int_rec.INTERFACE_CLAIM_LINE_ID ||''''
766: );
767: ELSE
768: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
769: 'OZF_CLAIM_LINES_INT_ALL',
770: 'INTERFACE_CLAIM_LINE_ID = ''' || p_claim_lines_int_rec.INTERFACE_CLAIM_LINE_ID ||
771: ''' AND INTERFACE_CLAIM_LINE_ID <> ' || p_claim_lines_int_rec.INTERFACE_CLAIM_LINE_ID
772: );
773: END IF;

Line 1016: FROM ozf_claim_lines_int_all

1012: l_return_status VARCHAR2(1);
1013:
1014: CURSOR c_complete IS
1015: SELECT *
1016: FROM ozf_claim_lines_int_all
1017: WHERE interface_claim_line_id = p_claim_lines_int_rec.interface_claim_line_id;
1018: l_claim_lines_int_rec c_complete%ROWTYPE;
1019: BEGIN
1020: x_complete_rec := p_claim_lines_int_rec;