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_ENTITY_ATTRIBUTE_PVT dependencies on PV_ENTITY_ATTRS

Line 57: SELECT PV_ENTITY_ATTRS_s.NEXTVAL

53: l_lov_string varchar2(2000);
54:
55:
56: CURSOR c_id IS
57: SELECT PV_ENTITY_ATTRS_s.NEXTVAL
58: FROM dual;
59:
60: CURSOR c_id_exists (l_id IN NUMBER) IS
61: SELECT 1

Line 62: FROM PV_ENTITY_ATTRS

58: FROM dual;
59:
60: CURSOR c_id_exists (l_id IN NUMBER) IS
61: SELECT 1
62: FROM PV_ENTITY_ATTRS
63: WHERE ENTITY_ATTR_ID = l_id;
64:
65: CURSOR c_get_attr_details(cv_attribute_id NUMBER) IS
66: SELECT attribute_type, display_style

Line 277: -- Invoke table handler(PV_ENTITY_ATTRS_PKG.Insert_Row)

273:
274:
275:
276:
277: -- Invoke table handler(PV_ENTITY_ATTRS_PKG.Insert_Row)
278: Pv_Entity_Attrs_Pkg.Insert_Row(
279: px_entity_attr_id => l_entity_attr_rec.entity_attr_id
280: ,px_object_version_number => l_object_version_number
281: ,p_batch_sql_text => l_entity_attr_rec.batch_sql_text

Line 278: Pv_Entity_Attrs_Pkg.Insert_Row(

274:
275:
276:
277: -- Invoke table handler(PV_ENTITY_ATTRS_PKG.Insert_Row)
278: Pv_Entity_Attrs_Pkg.Insert_Row(
279: px_entity_attr_id => l_entity_attr_rec.entity_attr_id
280: ,px_object_version_number => l_object_version_number
281: ,p_batch_sql_text => l_entity_attr_rec.batch_sql_text
282: ,p_refresh_frequency => l_entity_attr_rec.refresh_frequency

Line 385: FROM PV_ENTITY_ATTRS

381: IS
382:
383: CURSOR c_get_entity_attribute(cv_entity_attr_id NUMBER) IS
384: SELECT *
385: FROM PV_ENTITY_ATTRS
386: WHERE ENTITY_ATTR_ID = cv_entity_attr_id;
387:
388: CURSOR c_get_attr_details(cv_attribute_id NUMBER) IS
389: SELECT attribute_type,display_style

Line 568: -- Invoke table handler(PV_ENTITY_ATTRS_PKG.Update_Row)

564:
565:
566: l_lov_string := p_entity_attr_rec.lov_string;
567:
568: -- Invoke table handler(PV_ENTITY_ATTRS_PKG.Update_Row)
569: Pv_Entity_Attrs_Pkg.Update_Row(
570: p_entity_attr_id => p_entity_attr_rec.entity_attr_id
571: ,p_last_update_date => SYSDATE
572: ,p_last_updated_by => G_USER_ID

Line 569: Pv_Entity_Attrs_Pkg.Update_Row(

565:
566: l_lov_string := p_entity_attr_rec.lov_string;
567:
568: -- Invoke table handler(PV_ENTITY_ATTRS_PKG.Update_Row)
569: Pv_Entity_Attrs_Pkg.Update_Row(
570: p_entity_attr_id => p_entity_attr_rec.entity_attr_id
571: ,p_last_update_date => SYSDATE
572: ,p_last_updated_by => G_USER_ID
573: ,p_last_update_login => G_LOGIN_ID

Line 1174: from pv_attributes_vl attr, pv_entity_attrs enty

1170: l_entity VARCHAR2(60);
1171:
1172: cursor lc_entity_attribute_details (pc_entity_attr_id number) is
1173: select attr.name, enty.entity
1174: from pv_attributes_vl attr, pv_entity_attrs enty
1175: where enty.entity_attr_id=pc_entity_attr_id and
1176: enty.attribute_id=attr.attribute_id
1177: ;
1178:

Line 1187: from pv_enty_attr_values val, pv_entity_attrs enty

1183: entity_attr_id = pc_entity_attr_id
1184: ;
1185: cursor lc_check_attr_enty_vals (pc_entity_attr_id number) is
1186: select distinct val.entity
1187: from pv_enty_attr_values val, pv_entity_attrs enty
1188: where enty.entity_attr_id =pc_entity_attr_id and
1189: enty.attribute_id = val.attribute_id and
1190: enty.entity = val.entity
1191: ;

Line 1282: -- Invoke table handler(PV_ENTITY_ATTRS_PKG.Delete_Row)

1278: -- Debug Message
1279: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1280: Pvx_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');
1281: END IF;
1282: -- Invoke table handler(PV_ENTITY_ATTRS_PKG.Delete_Row)
1283: Pv_Entity_Attrs_Pkg.Delete_Row(
1284: p_ENTITY_ATTR_ID => p_ENTITY_ATTR_ID);
1285: --
1286: -- End of API body

Line 1283: Pv_Entity_Attrs_Pkg.Delete_Row(

1279: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1280: Pvx_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');
1281: END IF;
1282: -- Invoke table handler(PV_ENTITY_ATTRS_PKG.Delete_Row)
1283: Pv_Entity_Attrs_Pkg.Delete_Row(
1284: p_ENTITY_ATTR_ID => p_ENTITY_ATTR_ID);
1285: --
1286: -- End of API body
1287: --

Line 1358: FROM PV_ENTITY_ATTRS

1354: L_FULL_NAME CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1355: l_ENTITY_ATTR_ID NUMBER;
1356: CURSOR c_Entity_Attribute IS
1357: SELECT ENTITY_ATTR_ID
1358: FROM PV_ENTITY_ATTRS
1359: WHERE ENTITY_ATTR_ID = p_ENTITY_ATTR_ID
1360: AND object_version_number = p_object_version
1361: FOR UPDATE NOWAIT;
1362: BEGIN

Line 1456: 'PV_ENTITY_ATTRS',

1452: BEGIN
1453: x_return_status := Fnd_Api.g_ret_sts_success;
1454: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
1455: l_valid_flag := Pvx_Utility_Pvt.check_uniqueness(
1456: 'PV_ENTITY_ATTRS',
1457: 'ENTITY_ATTR_ID = ''' || p_entity_attr_rec.ENTITY_ATTR_ID ||''''
1458: );
1459: ELSE
1460: l_valid_flag := Pvx_Utility_Pvt.check_uniqueness(

Line 1461: 'PV_ENTITY_ATTRS',

1457: 'ENTITY_ATTR_ID = ''' || p_entity_attr_rec.ENTITY_ATTR_ID ||''''
1458: );
1459: ELSE
1460: l_valid_flag := Pvx_Utility_Pvt.check_uniqueness(
1461: 'PV_ENTITY_ATTRS',
1462: 'ENTITY_ATTR_ID = ''' || p_entity_attr_rec.ENTITY_ATTR_ID ||
1463: ''' AND ENTITY_ATTR_ID <> ' || p_entity_attr_rec.ENTITY_ATTR_ID
1464: );
1465: END IF;

Line 1820: FROM pv_entity_attrs

1816: IS
1817: l_return_status VARCHAR2(1);
1818: CURSOR c_complete IS
1819: SELECT *
1820: FROM pv_entity_attrs
1821: WHERE entity_attr_id = p_entity_attr_rec.entity_attr_id;
1822: l_entity_attr_rec c_complete%ROWTYPE;
1823: BEGIN
1824: x_complete_rec := p_entity_attr_rec;