DBA Data[Home] [Help]

APPS.PO_COMPLEX_WORK_PVT dependencies on PO_HEADERS

Line 419: l_style_id PO_HEADERS_ALL.style_id%TYPE;

415:
416: d_module VARCHAR2(70) := 'po.plsql.PO_COMPLEX_WORK_PVT.is_complex_work_po';
417: d_progress NUMBER;
418:
419: l_style_id PO_HEADERS_ALL.style_id%TYPE;
420: l_is_complex_po BOOLEAN;
421:
422: BEGIN
423:

Line 434: FROM po_headers_merge_v poh

430: d_progress := 10;
431:
432: SELECT poh.style_id
433: INTO l_style_id
434: FROM po_headers_merge_v poh
435: WHERE poh.po_header_id = p_po_header_id
436: AND poh.draft_id = p_draft_id;
437:
438: d_progress := 20;

Line 545: l_style_id PO_HEADERS_ALL.style_id%TYPE;

541:
542: d_module VARCHAR2(70) := 'po.plsql.PO_COMPLEX_WORK_PVT.is_financing_po';
543: d_progress NUMBER;
544:
545: l_style_id PO_HEADERS_ALL.style_id%TYPE;
546: l_is_financing_po BOOLEAN;
547:
548: BEGIN
549:

Line 560: FROM po_headers_merge_v poh

556: d_progress := 10;
557:
558: SELECT poh.style_id
559: INTO l_style_id
560: FROM po_headers_merge_v poh
561: WHERE poh.po_header_id = p_po_header_id
562: AND poh.draft_id = p_draft_id;
563:
564: d_progress := 20;

Line 750: l_style_id PO_HEADERS.style_id%TYPE;

746:
747: d_module VARCHAR2(70) := 'po.plsql.PO_COMPLEX_WORK_PVT.get_default_payitem_info';
748: d_progress NUMBER;
749:
750: l_style_id PO_HEADERS.style_id%TYPE;
751: l_is_complex_flag VARCHAR2(1);
752: l_is_financing_flag VARCHAR2(1);
753: l_retainage_flag VARCHAR2(1);
754: l_advance_flag VARCHAR2(1);

Line 778: FROM po_headers_merge_v poh

774: d_progress := 10;
775:
776: SELECT poh.style_id
777: INTO l_style_id
778: FROM po_headers_merge_v poh
779: WHERE poh.po_header_id = p_po_header_id
780: AND poh.draft_id = p_draft_id;
781:
782: d_progress := 20;