APPS.PO_AUTOCREATE_UTIL_PVT dependencies on FND_API

Line 334: l_crosslinked_option_exist VARCHAR2(1) := FND_API.G_FALSE;

330: d_api_name CONSTANT VARCHAR2(30) := 'has_CrossLinked_Options';
331: d_module CONSTANT VARCHAR2(2000) := G_PKG_NAME || d_api_name || '.';
332: d_position NUMBER;
333:
334: l_crosslinked_option_exist VARCHAR2(1) := FND_API.G_FALSE;
335:
336:
337: BEGIN
338: d_position := 0;

Line 343: SELECT FND_API.G_TRUE

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
345: FROM dual
346: WHERE EXISTS(
347: SELECT 'Cross Linked Child Exists'

Line 364: l_crosslinked_option_exist:= FND_API.G_FALSE;

360: RETURN l_crosslinked_option_exist;
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;

Line 392: l_is_par_option_line_editable VARCHAR2(1) := FND_API.G_FALSE;

388: d_api_name CONSTANT VARCHAR2(30) := 'par_option_line_editable';
389: d_module CONSTANT VARCHAR2(2000) := G_PKG_NAME || d_api_name || '.';
390: d_position NUMBER;
391:
392: l_is_par_option_line_editable VARCHAR2(1) := FND_API.G_FALSE;
393:
394:
395: BEGIN
396: d_position := 0;

Line 401: Select FND_API.G_TRUE

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
403: from dual
404: where EXISTS
405: ( select 1 from po_requisition_lines_all prla where requisition_line_id = p_req_line_id

Line 422: l_is_par_option_line_editable:= FND_API.G_FALSE;

418: RETURN l_is_par_option_line_editable;
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;

Line 455: l_crosslinked_child VARCHAR2(1) := FND_API.G_FALSE;

451:
452: d_api_name CONSTANT VARCHAR2(30) := 'is_crosslinked_child';
453: d_module CONSTANT VARCHAR2(2000) := G_PKG_NAME || d_api_name || '.';
454:
455: l_crosslinked_child VARCHAR2(1) := FND_API.G_FALSE;
456:
457: /* Editted these two sequels under the bug 16798807
458: During selection of dependent lines in Demand work bench.
459: For PAR requisitions, Lines with Clm_base_line_num or group_line_id

Line 515: l_crosslinked_child := FND_API.G_TRUE;

511: FOR base_req_lines IN P_lines(p_req_line_id) LOOP
512: EXIT WHEN P_lines%NOTFOUND;
513:
514: IF cur_req_lines.clm_base_line_num = base_req_lines.requisition_line_id THEN
515: l_crosslinked_child := FND_API.G_TRUE;
516: EXIT;
517: END IF;
518:
519: END LOOP;

Line 533: l_crosslinked_child:= FND_API.G_FALSE;

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;