APPS.OE_AUDIT_HISTORY_PVT dependencies on OE_SETS

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 242: FROM OE_SETS

238: Exception
239: when no_data_found then
240: SELECT set_name
241: INTO l_attribute_display_value
242: FROM OE_SETS
243: WHERE set_id = attribute_value;
244: End;
245: END IF;
246: else

Line 2082: from oe_sets

2078: l_set_name varchar2(30);
2079: l_set_type varchar2(30);
2080: begin
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,

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