DBA Data[Home] [Help]

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.27.12020000.7 2013/04/25 11:53:20 sujithku ship $ */
3:
4: -- START 8547934
5:

Line 347: l_attribute_display_value := OE_AUDIT_HISTORY_PVT.Get_Translated_Value(

343: end if;
344: -- sol_ord_er #16014165 end
345: else
346: IF (p_attribute_id between 1078 and 1092 ) OR (p_attribute_id between 4218 and 4222) THEN
347: l_attribute_display_value := OE_AUDIT_HISTORY_PVT.Get_Translated_Value(
348: 'OE_HEADER_ATTRIBUTES',
349: UPPER(l_display_name),
350: attribute_value, p_context_value );
351: ELSIF (p_attribute_id between 1018 and 1032) OR (p_attribute_id between 4223 and 4227) THEN

Line 352: l_attribute_display_value := OE_AUDIT_HISTORY_PVT.Get_Translated_Value(

348: 'OE_HEADER_ATTRIBUTES',
349: UPPER(l_display_name),
350: attribute_value, p_context_value );
351: ELSIF (p_attribute_id between 1018 and 1032) OR (p_attribute_id between 4223 and 4227) THEN
352: l_attribute_display_value := OE_AUDIT_HISTORY_PVT.Get_Translated_Value(
353: 'OE_LINE_ATTRIBUTES',
354: UPPER(l_display_name),
355: attribute_value,
356: p_context_value);

Line 1915: OE_AUDIT_HISTORY_PVT.get_valueset_id_r(p_FlexField_Name

1911: l_value VARCHAR2(240);
1912:
1913: BEGIN
1914:
1915: OE_AUDIT_HISTORY_PVT.get_valueset_id_r(p_FlexField_Name
1916: ,p_Context_Name
1917: ,p_Segment_Name
1918: ,x_Vsid
1919: ,x_Format_Type

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

1954: End If; ---end of Fmt.Has_Id
1955: FND_VSET.get_value_end(Vset);
1956: ELSIF X_Validation_type = 'F' THEN
1957: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
1958: IF (OE_AUDIT_HISTORY_PVT.value_exists_in_table(Vset.table_info,l_attr_value,l_id,l_value)) THEN
1959: IF Fmt.Has_Id Then --id is defined.Hence compare for id
1960: If l_attr_value = l_id Then
1961: x_attr_value_code := l_value;
1962: Value_Valid_In_Valueset := TRUE;

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

1997: p_display_name:=NULL;
1998: END;
1999:
2000: IF (p_attribute_id between 1078 and 1092 ) OR (p_attribute_id between 4218 and 4222) THEN
2001: p_display_name := OE_AUDIT_HISTORY_PVT.Get_column_label('OE_HEADER_ATTRIBUTES',UPPER(p_column_name), p_context_value,p_old_context_value);
2002: ELSIF (p_attribute_id between 1018 and 1032) OR (p_attribute_id between 4223 and 4227) THEN
2003: p_display_name := OE_AUDIT_HISTORY_PVT.Get_column_label('OE_LINE_ATTRIBUTES',UPPER(p_column_name),p_context_value,p_old_context_value);
2004: END IF;
2005:

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

1999:
2000: IF (p_attribute_id between 1078 and 1092 ) OR (p_attribute_id between 4218 and 4222) THEN
2001: p_display_name := OE_AUDIT_HISTORY_PVT.Get_column_label('OE_HEADER_ATTRIBUTES',UPPER(p_column_name), p_context_value,p_old_context_value);
2002: ELSIF (p_attribute_id between 1018 and 1032) OR (p_attribute_id between 4223 and 4227) THEN
2003: p_display_name := OE_AUDIT_HISTORY_PVT.Get_column_label('OE_LINE_ATTRIBUTES',UPPER(p_column_name),p_context_value,p_old_context_value);
2004: END IF;
2005:
2006: RETURN p_display_name;
2007:

Line 2063: p_column_translated_value := OE_AUDIT_HISTORY_PVT.Get_Attribute_value(p_flexfield_name

2059: AND APPLICATION_COLUMN_NAME=p_appl_column_name
2060: AND DESCRIPTIVE_FLEXFIELD_NAME=p_flexfield_name
2061: AND DESCRIPTIVE_FLEX_CONTEXT_CODE IN ('Global Data Elements',p_context_value);
2062:
2063: p_column_translated_value := OE_AUDIT_HISTORY_PVT.Get_Attribute_value(p_flexfield_name
2064: ,v_context
2065: ,p_appl_column_name
2066: ,p_column_value
2067: ,'=');

Line 2501: END OE_AUDIT_HISTORY_PVT;

2497: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
2498: end;
2499:
2500:
2501: END OE_AUDIT_HISTORY_PVT;