APPS.OZF_AE_HEADER_PVT dependencies on OZF_AE_HEADERS_ALL

Line 47: SELECT OZF_AE_HEADERS_ALL_s.NEXTVAL

43: l_AE_HEADER_ID NUMBER;
44: l_dummy NUMBER;
45:
46: CURSOR c_id IS
47: SELECT OZF_AE_HEADERS_ALL_s.NEXTVAL
48: FROM dual;
49:
50: CURSOR c_id_exists (l_id IN NUMBER) IS
51: SELECT count(ae_header_id) FROM OZF_AE_HEADERS_ALL

Line 51: SELECT count(ae_header_id) FROM OZF_AE_HEADERS_ALL

47: SELECT OZF_AE_HEADERS_ALL_s.NEXTVAL
48: FROM dual;
49:
50: CURSOR c_id_exists (l_id IN NUMBER) IS
51: SELECT count(ae_header_id) FROM OZF_AE_HEADERS_ALL
52: WHERE AE_HEADER_ID = l_id;
53:
54: BEGIN
55: -- Standard Start of API savepoint

Line 265: FROM OZF_AE_HEADERS_ALL

261: IS
262:
263: CURSOR c_get_ae_header(p_ae_header_id NUMBER) IS
264: SELECT *
265: FROM OZF_AE_HEADERS_ALL
266: WHERE ae_header_id = p_ae_header_id;
267:
268: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Ae_Header';
269: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 611: FROM OZF_AE_HEADERS_ALL

607: l_AE_HEADER_ID NUMBER;
608:
609: CURSOR c_Ae_Header IS
610: SELECT AE_HEADER_ID
611: FROM OZF_AE_HEADERS_ALL
612: WHERE AE_HEADER_ID = p_AE_HEADER_ID
613: AND object_version_number = p_object_version
614: FOR UPDATE NOWAIT;
615:

Line 724: 'OZF_AE_HEADERS_ALL',

720: BEGIN
721: x_return_status := FND_API.g_ret_sts_success;
722: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
723: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
724: 'OZF_AE_HEADERS_ALL',
725: 'AE_HEADER_ID = ''' || p_ae_header_rec.AE_HEADER_ID ||''''
726: );
727: ELSE
728: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

Line 729: 'OZF_AE_HEADERS_ALL',

725: 'AE_HEADER_ID = ''' || p_ae_header_rec.AE_HEADER_ID ||''''
726: );
727: ELSE
728: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
729: 'OZF_AE_HEADERS_ALL',
730: 'AE_HEADER_ID = ''' || p_ae_header_rec.AE_HEADER_ID ||
731: ''' AND AE_HEADER_ID <> ' || p_ae_header_rec.AE_HEADER_ID
732: );
733: END IF;

Line 1032: FROM ozf_ae_headers_all

1028: l_return_status VARCHAR2(1);
1029:
1030: CURSOR c_complete IS
1031: SELECT *
1032: FROM ozf_ae_headers_all
1033: WHERE ae_header_id = p_ae_header_rec.ae_header_id;
1034: l_ae_header_rec c_complete%ROWTYPE;
1035: BEGIN
1036: x_complete_rec := p_ae_header_rec;