372:
373: d_module VARCHAR2(70) := 'po.plsql.PO_COMPLEX_WORK_PVT.is_complex_work_po';
374: d_progress NUMBER;
375:
376: l_style_id PO_HEADERS_ALL.style_id%TYPE;
377: l_is_complex_po BOOLEAN;
378:
379: BEGIN
380:
387: d_progress := 10;
388:
389: SELECT poh.style_id
390: INTO l_style_id
391: FROM po_headers_all poh
392: WHERE poh.po_header_id = p_po_header_id;
393:
394: d_progress := 20;
395:
453:
454: d_module VARCHAR2(70) := 'po.plsql.PO_COMPLEX_WORK_PVT.is_financing_po';
455: d_progress NUMBER;
456:
457: l_style_id PO_HEADERS_ALL.style_id%TYPE;
458: l_is_financing_po BOOLEAN;
459:
460: BEGIN
461:
468: d_progress := 10;
469:
470: SELECT poh.style_id
471: INTO l_style_id
472: FROM po_headers_all poh
473: WHERE poh.po_header_id = p_po_header_id;
474:
475: d_progress := 20;
476:
594: d_progress := 10;
595:
596: SELECT poh.style_id
597: INTO l_style_id
598: FROM po_headers_all poh
599: WHERE poh.po_header_id = p_po_header_id;
600:
601: d_progress := 20;
602: