335:
336:
337: BEGIN
338: d_position := 0;
339: IF (PO_LOG.d_proc) THEN
340: PO_LOG.proc_begin(d_module);
341: END IF;
342:
343: SELECT FND_API.G_TRUE
336:
337: BEGIN
338: d_position := 0;
339: IF (PO_LOG.d_proc) THEN
340: PO_LOG.proc_begin(d_module);
341: END IF;
342:
343: SELECT FND_API.G_TRUE
344: INTO l_crosslinked_option_exist
352: AND child_line.group_line_id =p_req_line_id
353: );
354:
355:
356: IF (PO_LOG.d_proc) THEN
357: PO_LOG.proc_end(d_module, 'l_crosslinked_option_exist', l_crosslinked_option_exist);
358: END IF;
359:
360: RETURN l_crosslinked_option_exist;
353: );
354:
355:
356: IF (PO_LOG.d_proc) THEN
357: PO_LOG.proc_end(d_module, 'l_crosslinked_option_exist', l_crosslinked_option_exist);
358: END IF;
359:
360: RETURN l_crosslinked_option_exist;
361:
361:
362: EXCEPTION
363: WHEN NO_DATA_FOUND THEN
364: l_crosslinked_option_exist:= FND_API.G_FALSE;
365: IF (PO_LOG.d_proc) THEN
366: PO_LOG.proc_end(d_module, 'NO_DATA_FOUND: l_crosslinked_option_exist', l_crosslinked_option_exist);
367: END IF;
368: RETURN l_crosslinked_option_exist;
369:
362: EXCEPTION
363: WHEN NO_DATA_FOUND THEN
364: l_crosslinked_option_exist:= FND_API.G_FALSE;
365: IF (PO_LOG.d_proc) THEN
366: PO_LOG.proc_end(d_module, 'NO_DATA_FOUND: l_crosslinked_option_exist', l_crosslinked_option_exist);
367: END IF;
368: RETURN l_crosslinked_option_exist;
369:
370: END crosslinked_option_exist;
393:
394:
395: BEGIN
396: d_position := 0;
397: IF (PO_LOG.d_proc) THEN
398: PO_LOG.proc_begin(d_module);
399: END IF;
400:
401: Select FND_API.G_TRUE
394:
395: BEGIN
396: d_position := 0;
397: IF (PO_LOG.d_proc) THEN
398: PO_LOG.proc_begin(d_module);
399: END IF;
400:
401: Select FND_API.G_TRUE
402: INTO l_is_par_option_line_editable
410: EXISTS (select 1 from po_lines_draft_all plda where po_line_id = prla.clm_base_line_num and plda.draft_id = prla.par_draft_id
411: and plda.change_status = 'UPDATE'))));
412:
413:
414: IF (PO_LOG.d_proc) THEN
415: PO_LOG.proc_end(d_module, 'l_is_par_option_line_editable', l_is_par_option_line_editable);
416: END IF;
417:
418: RETURN l_is_par_option_line_editable;
411: and plda.change_status = 'UPDATE'))));
412:
413:
414: IF (PO_LOG.d_proc) THEN
415: PO_LOG.proc_end(d_module, 'l_is_par_option_line_editable', l_is_par_option_line_editable);
416: END IF;
417:
418: RETURN l_is_par_option_line_editable;
419:
419:
420: EXCEPTION
421: WHEN NO_DATA_FOUND THEN
422: l_is_par_option_line_editable:= FND_API.G_FALSE;
423: IF (PO_LOG.d_proc) THEN
424: PO_LOG.proc_end(d_module, 'NO_DATA_FOUND: l_is_par_option_line_editable', l_is_par_option_line_editable);
425: END IF;
426: RETURN l_is_par_option_line_editable;
427:
420: EXCEPTION
421: WHEN NO_DATA_FOUND THEN
422: l_is_par_option_line_editable:= FND_API.G_FALSE;
423: IF (PO_LOG.d_proc) THEN
424: PO_LOG.proc_end(d_module, 'NO_DATA_FOUND: l_is_par_option_line_editable', l_is_par_option_line_editable);
425: END IF;
426: RETURN l_is_par_option_line_editable;
427:
428: END is_par_option_line_editable;
499: IF(to_NUMBER(c_req_line_id) = To_Number(p_req_line_id)) THEN
500: RETURN l_crosslinked_child;
501: END IF;
502:
503: IF (PO_LOG.d_proc) THEN
504: PO_LOG.proc_begin(d_module);
505: END IF;
506:
507: FOR cur_req_lines IN C_lines(c_req_line_id) LOOP
500: RETURN l_crosslinked_child;
501: END IF;
502:
503: IF (PO_LOG.d_proc) THEN
504: PO_LOG.proc_begin(d_module);
505: END IF;
506:
507: FOR cur_req_lines IN C_lines(c_req_line_id) LOOP
508: EXIT WHEN C_lines%NOTFOUND;
521:
522: END LOOP;
523:
524:
525: IF (PO_LOG.d_proc) THEN
526: PO_LOG.proc_end(d_module, 'l_crosslinked_child', l_crosslinked_child);
527: END IF;
528:
529: RETURN l_crosslinked_child;
522: END LOOP;
523:
524:
525: IF (PO_LOG.d_proc) THEN
526: PO_LOG.proc_end(d_module, 'l_crosslinked_child', l_crosslinked_child);
527: END IF;
528:
529: RETURN l_crosslinked_child;
530:
531: EXCEPTION
532: WHEN NO_DATA_FOUND THEN
533: l_crosslinked_child:= FND_API.G_FALSE;
534:
535: IF (PO_LOG.d_proc) THEN
536: PO_LOG.proc_end(d_module, 'NO_DATA_FOUND: l_crosslinked_child', l_crosslinked_child);
537: END IF;
538:
539: RETURN l_crosslinked_child;
532: WHEN NO_DATA_FOUND THEN
533: l_crosslinked_child:= FND_API.G_FALSE;
534:
535: IF (PO_LOG.d_proc) THEN
536: PO_LOG.proc_end(d_module, 'NO_DATA_FOUND: l_crosslinked_child', l_crosslinked_child);
537: END IF;
538:
539: RETURN l_crosslinked_child;
540: