DBA Data[Home] [Help]

APPS.OE_AUDIT_HISTORY_PVT dependencies on OE_SETS_HISTORY

Line 235: FROM OE_SETS_HISTORY

231: IF attribute_value IS NOT NULL THEN
232: begin
233: SELECT set_name
234: INTO l_attribute_display_value
235: FROM OE_SETS_HISTORY
236: WHERE set_id = attribute_value
237: and rownum<2;
238: Exception
239: when no_data_found then

Line 2085: insert into OE_SETS_HISTORY

2081: select set_name,set_type into l_set_name,l_set_type
2082: from oe_sets
2083: where set_id=p_set_id;
2084:
2085: insert into OE_SETS_HISTORY
2086: (set_id,
2087: set_name,
2088: set_type,
2089: line_id,

Line 2119: delete from OE_SETS_HISTORY

2115: PROCEDURE DELETE_SET_HISTORY(
2116: p_line_id IN number,
2117: x_return_status OUT NOCOPY varchar2 ) is
2118: begin
2119: delete from OE_SETS_HISTORY
2120: where line_id=p_line_id;
2121:
2122: x_return_status := FND_API.G_RET_STS_SUCCESS;
2123: exception