APPS.PV_ATTRIBUTE_PVT dependencies on PV_ATTRIBUTES_B

Line 51: SELECT PV_ATTRIBUTES_B_s.NEXTVAL

47: l_attribute_rec attribute_rec_type := p_attribute_rec;
48: l_meaning VARCHAR2(80);
49:
50: CURSOR c_id IS
51: SELECT PV_ATTRIBUTES_B_s.NEXTVAL
52: FROM dual;
53:
54: CURSOR c_id_exists (l_id IN NUMBER) IS
55: SELECT 1

Line 56: FROM PV_ATTRIBUTES_B

52: FROM dual;
53:
54: CURSOR c_id_exists (l_id IN NUMBER) IS
55: SELECT 1
56: FROM PV_ATTRIBUTES_B
57: WHERE ATTRIBUTE_ID = l_id;
58:
59: BEGIN
60: -- Standard Start of API savepoint

Line 317: FROM PV_ATTRIBUTES_B

313: IS
314:
315: CURSOR c_get_attribute(cv_attribute_id NUMBER) IS
316: SELECT *
317: FROM PV_ATTRIBUTES_B
318: where attribute_id = cv_attribute_id;
319:
320: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Attribute';
321: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;

Line 1238: FROM PV_ATTRIBUTES_B

1234: l_ATTRIBUTE_ID NUMBER;
1235:
1236: CURSOR c_Attribute IS
1237: SELECT ATTRIBUTE_ID
1238: FROM PV_ATTRIBUTES_B
1239: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID
1240: AND object_version_number = p_object_version
1241: FOR UPDATE NOWAIT;
1242:

Line 1353: 'PV_ATTRIBUTES_B',

1349:
1350: x_return_status := FND_API.g_ret_sts_success;
1351: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1352: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
1353: 'PV_ATTRIBUTES_B',
1354: 'ATTRIBUTE_ID = ''' || p_attribute_rec.ATTRIBUTE_ID ||''''
1355: );
1356: ELSE
1357: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

Line 1358: 'PV_ATTRIBUTES_B',

1354: 'ATTRIBUTE_ID = ''' || p_attribute_rec.ATTRIBUTE_ID ||''''
1355: );
1356: ELSE
1357: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
1358: 'PV_ATTRIBUTES_B',
1359: 'ATTRIBUTE_ID = ''' || p_attribute_rec.ATTRIBUTE_ID ||
1360: ''' AND ATTRIBUTE_ID <> ' || p_attribute_rec.ATTRIBUTE_ID
1361: );
1362: END IF;