eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_ENTY_ATTR_VALUE_PVT dependencies on PV_ENTY_ATTR_VALUES

Line 51: SELECT PV_ENTY_ATTR_VALUES_s.NEXTVAL

47: l_dummy NUMBER;
48: l_enty_attr_val_rec enty_attr_val_rec_type := p_enty_attr_val_rec;
49:
50: CURSOR c_id IS
51: SELECT PV_ENTY_ATTR_VALUES_s.NEXTVAL
52: FROM dual;
53:
54: CURSOR c_id_exists (l_id IN NUMBER) IS
55: SELECT 1

Line 56: FROM PV_ENTY_ATTR_VALUES

52: FROM dual;
53:
54: CURSOR c_id_exists (l_id IN NUMBER) IS
55: SELECT 1
56: FROM PV_ENTY_ATTR_VALUES
57: WHERE ENTY_ATTR_VAL_ID = l_id;
58:
59: CURSOR c_get_enty_attr_value(cv_attribute_id NUMBER,cv_entity_id NUMBER, cv_entity VARCHAR2) IS
60: SELECT *

Line 61: FROM PV_ENTY_ATTR_VALUES

57: WHERE ENTY_ATTR_VAL_ID = l_id;
58:
59: CURSOR c_get_enty_attr_value(cv_attribute_id NUMBER,cv_entity_id NUMBER, cv_entity VARCHAR2) IS
60: SELECT *
61: FROM PV_ENTY_ATTR_VALUES
62: WHERE attribute_id = cv_attribute_id and
63: entity_id = cv_entity_id and
64: entity = cv_entity and
65: latest_flag = 'Y';

Line 242: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Insert_Row)

238:
239: -- Debug Message
240: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling create table handler');
241:
242: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Insert_Row)
243: PV_ENTY_ATTR_VALUES_PKG.Insert_Row(
244: px_enty_attr_val_id => l_enty_attr_val_rec.enty_attr_val_id
245: ,p_last_update_date => l_enty_attr_val_rec.last_update_date
246: ,p_last_updated_by => l_enty_attr_val_rec.last_updated_by

Line 243: PV_ENTY_ATTR_VALUES_PKG.Insert_Row(

239: -- Debug Message
240: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling create table handler');
241:
242: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Insert_Row)
243: PV_ENTY_ATTR_VALUES_PKG.Insert_Row(
244: px_enty_attr_val_id => l_enty_attr_val_rec.enty_attr_val_id
245: ,p_last_update_date => l_enty_attr_val_rec.last_update_date
246: ,p_last_updated_by => l_enty_attr_val_rec.last_updated_by
247: ,p_creation_date => l_enty_attr_val_rec.creation_date

Line 354: FROM PV_ENTY_ATTR_VALUES

350: IS
351:
352: CURSOR c_get_enty_attr_value(cv_enty_attr_val_id NUMBER) IS
353: SELECT *
354: FROM PV_ENTY_ATTR_VALUES
355: WHERE enty_attr_val_id = cv_enty_attr_val_id;
356:
357: l_api_name CONSTANT VARCHAR2(30) := 'Update_Attr_Value';
358: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 478: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Update_Row)

474: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
475: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
476: END IF;
477:
478: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Update_Row)
479: PV_ENTY_ATTR_VALUES_PKG.Update_Row(
480: p_enty_attr_val_id => p_enty_attr_val_rec.enty_attr_val_id
481: ,p_last_update_date => SYSDATE
482: ,p_last_updated_by => G_USER_ID

Line 479: PV_ENTY_ATTR_VALUES_PKG.Update_Row(

475: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
476: END IF;
477:
478: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Update_Row)
479: PV_ENTY_ATTR_VALUES_PKG.Update_Row(
480: p_enty_attr_val_id => p_enty_attr_val_rec.enty_attr_val_id
481: ,p_last_update_date => SYSDATE
482: ,p_last_updated_by => G_USER_ID
483: -- p_creation_date => SYSDATE

Line 618: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Delete_Row)

614: -- Debug Message
615: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
616: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling delete table handler');
617: END IF;
618: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Delete_Row)
619: PV_ENTY_ATTR_VALUES_PKG.Delete_Row(
620: p_ENTY_ATTR_VAL_ID => p_ENTY_ATTR_VAL_ID);
621: --
622: -- End of API body

Line 619: PV_ENTY_ATTR_VALUES_PKG.Delete_Row(

615: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
616: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling delete table handler');
617: END IF;
618: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Delete_Row)
619: PV_ENTY_ATTR_VALUES_PKG.Delete_Row(
620: p_ENTY_ATTR_VAL_ID => p_ENTY_ATTR_VAL_ID);
621: --
622: -- End of API body
623: --

Line 704: FROM PV_ENTY_ATTR_VALUES

700: l_ENTY_ATTR_VAL_ID NUMBER;
701:
702: CURSOR c_Enty_Attr_Value IS
703: SELECT ENTY_ATTR_VAL_ID
704: FROM PV_ENTY_ATTR_VALUES
705: WHERE ENTY_ATTR_VAL_ID = p_ENTY_ATTR_VAL_ID
706: AND object_version_number = p_object_version
707: FOR UPDATE NOWAIT;
708:

Line 820: 'PV_ENTY_ATTR_VALUES'

816:
817: x_return_status := FND_API.g_ret_sts_success;
818: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
819: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
820: 'PV_ENTY_ATTR_VALUES'
821: ,'ENTY_ATTR_VAL_ID = ''' || p_enty_attr_val_rec.ENTY_ATTR_VAL_ID ||''''
822: );
823: ELSE
824: l_valid_flag := PVX_Utility_PVT.check_uniqueness(

Line 825: 'PV_ENTY_ATTR_VALUES'

821: ,'ENTY_ATTR_VAL_ID = ''' || p_enty_attr_val_rec.ENTY_ATTR_VAL_ID ||''''
822: );
823: ELSE
824: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
825: 'PV_ENTY_ATTR_VALUES'
826: ,'ENTY_ATTR_VAL_ID = ''' || p_enty_attr_val_rec.ENTY_ATTR_VAL_ID ||
827: ''' AND ENTY_ATTR_VAL_ID <> ' || p_enty_attr_val_rec.ENTY_ATTR_VAL_ID
828: );
829: END IF;

Line 1280: FROM pv_enty_attr_values

1276: l_return_status VARCHAR2(1);
1277:
1278: CURSOR c_complete IS
1279: SELECT *
1280: FROM pv_enty_attr_values
1281: WHERE enty_attr_val_id = p_enty_attr_val_rec.enty_attr_val_id;
1282: l_pv_enty_attr_val_rec c_complete%ROWTYPE;
1283: BEGIN
1284: x_complete_rec := p_enty_attr_val_rec;