APPS.OE_AUDIT_HISTORY_PVT dependencies on OE_SETS

Line 308: FROM OE_SETS_HISTORY

304: IF attribute_value IS NOT NULL THEN
305: begin
306: SELECT set_name
307: INTO l_attribute_display_value
308: FROM OE_SETS_HISTORY
309: WHERE set_id = attribute_value
310: and rownum<2;
311: Exception
312: when no_data_found then

Line 315: FROM OE_SETS

311: Exception
312: when no_data_found then
313: SELECT set_name
314: INTO l_attribute_display_value
315: FROM OE_SETS
316: WHERE set_id = attribute_value;
317: End;
318: END IF;
319: -- sol_ord_er #16014165 start

Line 2453: from oe_sets

2449: l_set_name varchar2(30);
2450: l_set_type varchar2(30);
2451: begin
2452: select set_name,set_type into l_set_name,l_set_type
2453: from oe_sets
2454: where set_id=p_set_id;
2455:
2456: insert into OE_SETS_HISTORY
2457: (set_id,

Line 2456: insert into OE_SETS_HISTORY

2452: select set_name,set_type into l_set_name,l_set_type
2453: from oe_sets
2454: where set_id=p_set_id;
2455:
2456: insert into OE_SETS_HISTORY
2457: (set_id,
2458: set_name,
2459: set_type,
2460: line_id,

Line 2490: delete from OE_SETS_HISTORY

2486: PROCEDURE DELETE_SET_HISTORY(
2487: p_line_id IN number,
2488: x_return_status OUT NOCOPY varchar2 ) is
2489: begin
2490: delete from OE_SETS_HISTORY
2491: where line_id=p_line_id;
2492:
2493: x_return_status := FND_API.G_RET_STS_SUCCESS;
2494: exception