APPS.OE_SET_UTIL dependencies on OE_LINE_SETS

Line 74: from oe_line_sets

70: select 1
71: into lcount
72: from dual
73: where exists (select 1
74: from oe_line_sets
75: where set_id = p_set_id
76: and line_id = p_line_id);
77:
78: -- 4236316 end

Line 285: (select line_id from oe_line_sets where

281: --item_type_code = 'INCLUDED' and
282: nvl(cancelled_flag,'N') <> 'Y' and
283: nvl(model_remnant_flag,'N') <> 'Y' and
284: line_id not in
285: (select line_id from oe_line_sets where
286: set_id = p_set_id );
287: --
288: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
289:

Line 334: Insert into oe_line_sets(

330: oe_msg_pub.add;
331: RAISE FND_API.G_EXC_ERROR ;
332: END IF;
333:
334: Insert into oe_line_sets(
335: Line_id,
336: Set_id,
337: SYSTEM_REQUIRED_FLAG )
338: Values

Line 348: Insert into oe_line_sets(Line_id,

344: IF p_top_model_line_id IS NOT NULL THEN
345: FOR c1rec in C1
346: loop
347:
348: Insert into oe_line_sets(Line_id,
349: Set_id,
350: SYSTEM_REQUIRED_FLAG )
351: Values (c1rec.line_id,
352: p_set_id,

Line 464: /*Delete oe_line_sets

460: RAISE FND_API.G_EXC_ERROR ;
461: END IF;
462: 2525203 */
463:
464: /*Delete oe_line_sets
465: Where line_id = p_line_id
466: and set_id = p_set_id;*/
467:
468: -- Call this fulfillment api for removal of sets

Line 488: Delete oe_line_sets

484: -- 2695403
485: g_set_rec := OE_ORDER_CACHE.Load_Set(p_set_id); -- refresh the cache record
486: ---
487:
488: Delete oe_line_sets
489: Where line_id = p_line_id
490: and set_id = p_set_id;
491:
492: END IF;

Line 6110: oe_line_sets ls

6106: IS
6107: Cursor FULLIST IS
6108: Select os.set_name from
6109: oe_sets os,
6110: oe_line_sets ls
6111: where
6112: ls.line_id = p_line_id and
6113: os.set_id = ls.set_id;
6114: lfullist varchar2(2000);

Line 6143: Delete oe_line_sets

6139: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6140: --
6141: Begin
6142:
6143: Delete oe_line_sets
6144: where line_id = p_line_id;
6145:
6146: Exception
6147: when no_data_found then