APPS.PV_ENTY_ATTR_VALUE_PUB dependencies on PV_ENTY_ATTR_VALUES

Line 87: FROM PV_ENTY_ATTR_VALUES

83: l_date DATE;
84:
85: CURSOR c_get_previous_version(cv_attribute_id NUMBER,cv_entity_id NUMBER, cv_entity VARCHAR2) IS
86: SELECT distinct version
87: FROM PV_ENTY_ATTR_VALUES
88: WHERE attribute_id = cv_attribute_id and
89: entity_id = cv_entity_id and
90: entity = cv_entity and
91: latest_flag = 'Y';

Line 95: FROM PV_ENTY_ATTR_VALUES

91: latest_flag = 'Y';
92:
93: CURSOR c_get_enty_attr_value(cv_attribute_id NUMBER,cv_entity_id NUMBER, cv_entity VARCHAR2) IS
94: SELECT *
95: FROM PV_ENTY_ATTR_VALUES
96: WHERE attribute_id = cv_attribute_id and
97: entity_id = cv_entity_id and
98: entity = cv_entity and
99: latest_flag = 'Y';

Line 428: -- In all other cases insert in to pv_enty_attr_values.

424: -- if entity is not LEAD, we just simply maintain all versioning and all.
425: else
426: -- If attribute type is EXTERNAL and EXT_INT, look for external_update_text and
427: -- see if it is not null. if it is not null, execute it .
428: -- In all other cases insert in to pv_enty_attr_values.
429:
430: IF(l_attr_data_type in ('EXTERNAL','EXT_INT') AND
431: l_external_update_text is not null
432: ) THEN

Line 1009: -- Invoke Private API(PV_ENTY_ATTR_VALUES_PVT.Create_Attr_Value

1005: l_enty_attr_val_rec.attr_value_extn :=null;
1006:
1007:
1008:
1009: -- Invoke Private API(PV_ENTY_ATTR_VALUES_PVT.Create_Attr_Value
1010: PV_Enty_Attr_Value_PVT.Create_Attr_Value(
1011: p_api_version_number => p_api_version_number
1012: ,p_init_msg_list => p_init_msg_list
1013: ,p_commit => p_commit

Line 1111: -- Invoke Private API(PV_ENTY_ATTR_VALUES_PVT.Create_Attr_Value

1107: l_enty_attr_val_rec.attr_value_extn :=l_attr_val_rec.attr_value_extn;
1108:
1109: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - after ');
1110:
1111: -- Invoke Private API(PV_ENTY_ATTR_VALUES_PVT.Create_Attr_Value
1112: PV_Enty_Attr_Value_PVT.Create_Attr_Value(
1113: p_api_version_number => p_api_version_number
1114: ,p_init_msg_list => p_init_msg_list
1115: ,p_commit => p_commit

Line 1379: FROM PV_ATTRIBUTES_VL ATTR, PV_ENTITY_ATTRS ENTY, PV_ENTY_ATTR_VALUES VAL

1375: lc_ext_cursor cur_type;
1376:
1377: CURSOR c_attr_data_type(cv_attribute_id NUMBER, cv_entity_id NUMBER) IS
1378: SELECT distinct enty.attr_data_type, ENTY.SQL_TEXT -- VAL.version,
1379: FROM PV_ATTRIBUTES_VL ATTR, PV_ENTITY_ATTRS ENTY, PV_ENTY_ATTR_VALUES VAL
1380: WHERE ATTR.attribute_id = cv_attribute_id AND
1381: ENTY.ATTRIBUTE_ID = ATTR.attribute_id AND
1382: ENTY.ENTITY = 'PARTNER' AND
1383: VAL.ATTRIBUTE_ID (+) = ENTY.ATTRIBUTE_ID AND

Line 1391: from pv_enty_attr_values enty

1387:
1388: CURSOR c_enty_attr_int_values(cv_attribute_id NUMBER, cv_entity_id NUMBER) IS
1389:
1390: select enty.attr_value, enty.Attr_Value_Extn
1391: from pv_enty_attr_values enty
1392: where enty.attribute_id = cv_attribute_id
1393: and enty.entity = 'PARTNER' and
1394: enty.entity_id = cv_entity_id AND
1395: enty.LATEST_FLAG = 'Y' AND

Line 1401: FROM PV_ENTY_ATTR_VALUES

1397: ;
1398:
1399: CURSOR c_get_previous_version(cv_attribute_id NUMBER,cv_entity_id NUMBER, cv_entity VARCHAR2) IS
1400: SELECT distinct version
1401: FROM PV_ENTY_ATTR_VALUES
1402: WHERE attribute_id = cv_attribute_id and
1403: entity_id = cv_entity_id and
1404: entity = cv_entity and
1405: latest_flag = 'Y';