APPS.OE_AUDIT_HISTORY_PVT dependencies on OE_AUDIT_HISTORY_PVT

Line 1: PACKAGE BODY OE_AUDIT_HISTORY_PVT AS

1: PACKAGE BODY OE_AUDIT_HISTORY_PVT AS
2: /* $Header: OEXPPCHB.pls 120.20.12010000.2 2008/08/11 06:25:45 amallik ship $ */
3:
4: FUNCTION id_to_value ( p_attribute_id IN NUMBER,
5: attribute_value IN varchar2,

Line 248: l_attribute_display_value := OE_AUDIT_HISTORY_PVT.Get_Translated_Value(

244: End;
245: END IF;
246: else
247: IF (p_attribute_id between 1078 and 1092 ) OR (p_attribute_id between 4218 and 4222) THEN
248: l_attribute_display_value := OE_AUDIT_HISTORY_PVT.Get_Translated_Value(
249: 'OE_HEADER_ATTRIBUTES',
250: UPPER(l_display_name),
251: attribute_value, p_context_value );
252: ELSIF (p_attribute_id between 1018 and 1032) OR (p_attribute_id between 4223 and 4227) THEN

Line 253: l_attribute_display_value := OE_AUDIT_HISTORY_PVT.Get_Translated_Value(

249: 'OE_HEADER_ATTRIBUTES',
250: UPPER(l_display_name),
251: attribute_value, p_context_value );
252: ELSIF (p_attribute_id between 1018 and 1032) OR (p_attribute_id between 4223 and 4227) THEN
253: l_attribute_display_value := OE_AUDIT_HISTORY_PVT.Get_Translated_Value(
254: 'OE_LINE_ATTRIBUTES',
255: UPPER(l_display_name),
256: attribute_value,
257: p_context_value);

Line 1544: OE_AUDIT_HISTORY_PVT.get_valueset_id_r(p_FlexField_Name

1540: l_value VARCHAR2(240);
1541:
1542: BEGIN
1543:
1544: OE_AUDIT_HISTORY_PVT.get_valueset_id_r(p_FlexField_Name
1545: ,p_Context_Name
1546: ,p_Segment_Name
1547: ,x_Vsid
1548: ,x_Format_Type

Line 1587: IF (OE_AUDIT_HISTORY_PVT.value_exists_in_table(Vset.table_info,l_attr_value,l_id,l_value)) THEN

1583: End If; ---end of Fmt.Has_Id
1584: FND_VSET.get_value_end(Vset);
1585: ELSIF X_Validation_type = 'F' THEN
1586: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
1587: IF (OE_AUDIT_HISTORY_PVT.value_exists_in_table(Vset.table_info,l_attr_value,l_id,l_value)) THEN
1588: IF Fmt.Has_Id Then --id is defined.Hence compare for id
1589: If l_attr_value = l_id Then
1590: x_attr_value_code := l_value;
1591: Value_Valid_In_Valueset := TRUE;

Line 1630: p_display_name := OE_AUDIT_HISTORY_PVT.Get_column_label('OE_HEADER_ATTRIBUTES',UPPER(p_column_name), p_context_value,p_old_context_value);

1626: p_display_name:=NULL;
1627: END;
1628:
1629: IF (p_attribute_id between 1078 and 1092 ) OR (p_attribute_id between 4218 and 4222) THEN
1630: p_display_name := OE_AUDIT_HISTORY_PVT.Get_column_label('OE_HEADER_ATTRIBUTES',UPPER(p_column_name), p_context_value,p_old_context_value);
1631: ELSIF (p_attribute_id between 1018 and 1032) OR (p_attribute_id between 4223 and 4227) THEN
1632: p_display_name := OE_AUDIT_HISTORY_PVT.Get_column_label('OE_LINE_ATTRIBUTES',UPPER(p_column_name),p_context_value,p_old_context_value);
1633: END IF;
1634:

Line 1632: p_display_name := OE_AUDIT_HISTORY_PVT.Get_column_label('OE_LINE_ATTRIBUTES',UPPER(p_column_name),p_context_value,p_old_context_value);

1628:
1629: IF (p_attribute_id between 1078 and 1092 ) OR (p_attribute_id between 4218 and 4222) THEN
1630: p_display_name := OE_AUDIT_HISTORY_PVT.Get_column_label('OE_HEADER_ATTRIBUTES',UPPER(p_column_name), p_context_value,p_old_context_value);
1631: ELSIF (p_attribute_id between 1018 and 1032) OR (p_attribute_id between 4223 and 4227) THEN
1632: p_display_name := OE_AUDIT_HISTORY_PVT.Get_column_label('OE_LINE_ATTRIBUTES',UPPER(p_column_name),p_context_value,p_old_context_value);
1633: END IF;
1634:
1635: RETURN p_display_name;
1636:

Line 1692: p_column_translated_value := OE_AUDIT_HISTORY_PVT.Get_Attribute_value(p_flexfield_name

1688: AND APPLICATION_COLUMN_NAME=p_appl_column_name
1689: AND DESCRIPTIVE_FLEXFIELD_NAME=p_flexfield_name
1690: AND DESCRIPTIVE_FLEX_CONTEXT_CODE IN ('Global Data Elements',p_context_value);
1691:
1692: p_column_translated_value := OE_AUDIT_HISTORY_PVT.Get_Attribute_value(p_flexfield_name
1693: ,v_context
1694: ,p_appl_column_name
1695: ,p_column_value
1696: ,'=');

Line 2130: END OE_AUDIT_HISTORY_PVT;

2126: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
2127: end;
2128:
2129:
2130: END OE_AUDIT_HISTORY_PVT;