APPS.PV_ATTRIBUTE_CODE_PVT dependencies on PV_ATTRIBUTE_CODES_B

Line 55: FROM PV_ATTRIBUTE_CODES_B

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

Line 264: FROM PV_ATTRIBUTE_CODES_B

260: IS
261:
262: CURSOR c_get_attribute_code(cv_ATTR_CODE_ID NUMBER) IS
263: SELECT *
264: FROM PV_ATTRIBUTE_CODES_B
265: WHERE ATTR_CODE_ID = cv_ATTR_CODE_ID;
266:
267: l_api_name CONSTANT VARCHAR2(30) := 'Update_Attribute_Code';
268: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 931: FROM PV_ATTRIBUTE_CODES_B

927: l_ATTR_CODE_ID NUMBER;
928:
929: CURSOR c_Attribute_Code IS
930: SELECT ATTR_CODE_ID
931: FROM PV_ATTRIBUTE_CODES_B
932: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
933: AND object_version_number = p_object_version
934: FOR UPDATE NOWAIT;
935:

Line 1041: select attr_code from pv_attribute_codes_b

1037: IS
1038: l_valid_flag VARCHAR2(1);
1039:
1040: cursor lc_get_attr_code (pc_attribute_id number) is
1041: select attr_code from pv_attribute_codes_b
1042: where attribute_id = pc_attribute_id;
1043:
1044:
1045:

Line 1050: 'PV_ATTRIBUTE_CODES_B',

1046: BEGIN
1047: x_return_status := FND_API.g_ret_sts_success;
1048: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1049: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
1050: 'PV_ATTRIBUTE_CODES_B',
1051: 'ATTR_CODE_ID = ''' || p_attribute_code_rec.ATTR_CODE_ID ||''''
1052: );
1053: ELSE
1054: l_valid_flag := PVX_Utility_PVT.check_uniqueness(

Line 1055: 'PV_ATTRIBUTE_CODES_B',

1051: 'ATTR_CODE_ID = ''' || p_attribute_code_rec.ATTR_CODE_ID ||''''
1052: );
1053: ELSE
1054: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
1055: 'PV_ATTRIBUTE_CODES_B',
1056: 'ATTR_CODE_ID = ''' || p_attribute_code_rec.ATTR_CODE_ID ||
1057: ''' AND ATTR_CODE_ID <> ' || p_attribute_code_rec.ATTR_CODE_ID
1058: );
1059: END IF;

Line 1431: FROM pv_attribute_codes_b

1427: l_return_status VARCHAR2(1);
1428:
1429: CURSOR c_complete IS
1430: SELECT *
1431: FROM pv_attribute_codes_b
1432: WHERE attr_code_id = p_attribute_code_rec.attr_code_id;
1433: l_attribute_code_rec c_complete%ROWTYPE;
1434: BEGIN
1435: x_complete_rec := p_attribute_code_rec;