[Home] [Help]
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
271: --item_type_code = 'INCLUDED' and
272: nvl(cancelled_flag,'N') <> 'Y' and
273: nvl(model_remnant_flag,'N') <> 'Y' and
274: line_id not in
275: (select line_id from oe_line_sets where
276: set_id = p_set_id );
277: --
278: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
279: --
294: oe_msg_pub.add;
295: RAISE FND_API.G_EXC_ERROR ;
296: END IF;
297:
298: Insert into oe_line_sets(
299: Line_id,
300: Set_id,
301: SYSTEM_REQUIRED_FLAG )
302: Values
308: IF p_top_model_line_id IS NOT NULL THEN
309: FOR c1rec in C1
310: loop
311:
312: Insert into oe_line_sets(Line_id,
313: Set_id,
314: SYSTEM_REQUIRED_FLAG )
315: Values (c1rec.line_id,
316: p_set_id,
424: RAISE FND_API.G_EXC_ERROR ;
425: END IF;
426: 2525203 */
427:
428: /*Delete oe_line_sets
429: Where line_id = p_line_id
430: and set_id = p_set_id;*/
431:
432: -- Call this fulfillment api for removal of sets
448: -- 2695403
449: g_set_rec := OE_ORDER_CACHE.Load_Set(p_set_id); -- refresh the cache record
450: ---
451:
452: Delete oe_line_sets
453: Where line_id = p_line_id
454: and set_id = p_set_id;
455:
456: END IF;
6049: IS
6050: Cursor FULLIST IS
6051: Select os.set_name from
6052: oe_sets os,
6053: oe_line_sets ls
6054: where
6055: ls.line_id = p_line_id and
6056: os.set_id = ls.set_id;
6057: lfullist varchar2(2000);
6082: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6083: --
6084: Begin
6085:
6086: Delete oe_line_sets
6087: where line_id = p_line_id;
6088:
6089: Exception
6090: when no_data_found then