549:
550: PROCEDURE get_document_ids(
551: p_doc_type IN VARCHAR2
552: , p_doc_level IN VARCHAR2
553: , p_doc_level_id_tbl IN po_tbl_number
554: , x_doc_id_tbl OUT NOCOPY po_tbl_number
555: );
556:
557:
550: PROCEDURE get_document_ids(
551: p_doc_type IN VARCHAR2
552: , p_doc_level IN VARCHAR2
553: , p_doc_level_id_tbl IN po_tbl_number
554: , x_doc_id_tbl OUT NOCOPY po_tbl_number
555: );
556:
557:
558: PROCEDURE get_line_ids(
557:
558: PROCEDURE get_line_ids(
559: p_doc_type IN VARCHAR2
560: , p_doc_level IN VARCHAR2
561: , p_doc_level_id_tbl IN po_tbl_number
562: , x_line_id_tbl OUT NOCOPY po_tbl_number
563: );
564:
565: --
558: PROCEDURE get_line_ids(
559: p_doc_type IN VARCHAR2
560: , p_doc_level IN VARCHAR2
561: , p_doc_level_id_tbl IN po_tbl_number
562: , x_line_id_tbl OUT NOCOPY po_tbl_number
563: );
564:
565: --
566: PROCEDURE get_line_ids(
565: --
566: PROCEDURE get_line_ids(
567: p_doc_type IN VARCHAR2
568: , p_doc_level IN VARCHAR2
569: , p_doc_level_id_tbl IN po_tbl_number
570: , p_draft_id IN NUMBER
571: , x_line_id_tbl OUT NOCOPY po_tbl_number
572: );
573:
567: p_doc_type IN VARCHAR2
568: , p_doc_level IN VARCHAR2
569: , p_doc_level_id_tbl IN po_tbl_number
570: , p_draft_id IN NUMBER
571: , x_line_id_tbl OUT NOCOPY po_tbl_number
572: );
573:
574: PROCEDURE get_line_location_ids(
575: p_doc_type IN VARCHAR2
573:
574: PROCEDURE get_line_location_ids(
575: p_doc_type IN VARCHAR2
576: , p_doc_level IN VARCHAR2
577: , p_doc_level_id_tbl IN po_tbl_number
578: , x_line_location_id_tbl OUT NOCOPY po_tbl_number
579: );
580:
581: --
574: PROCEDURE get_line_location_ids(
575: p_doc_type IN VARCHAR2
576: , p_doc_level IN VARCHAR2
577: , p_doc_level_id_tbl IN po_tbl_number
578: , x_line_location_id_tbl OUT NOCOPY po_tbl_number
579: );
580:
581: --
582: PROCEDURE get_line_location_ids(
581: --
582: PROCEDURE get_line_location_ids(
583: p_doc_type IN VARCHAR2
584: , p_doc_level IN VARCHAR2
585: , p_doc_level_id_tbl IN po_tbl_number
586: , p_draft_id IN NUMBER
587: , x_line_location_id_tbl OUT NOCOPY po_tbl_number
588: );
589:
583: p_doc_type IN VARCHAR2
584: , p_doc_level IN VARCHAR2
585: , p_doc_level_id_tbl IN po_tbl_number
586: , p_draft_id IN NUMBER
587: , x_line_location_id_tbl OUT NOCOPY po_tbl_number
588: );
589:
590: PROCEDURE get_distribution_ids(
591: p_doc_type IN VARCHAR2
589:
590: PROCEDURE get_distribution_ids(
591: p_doc_type IN VARCHAR2
592: , p_doc_level IN VARCHAR2
593: , p_doc_level_id_tbl IN po_tbl_number
594: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
595: );
596:
597: --
590: PROCEDURE get_distribution_ids(
591: p_doc_type IN VARCHAR2
592: , p_doc_level IN VARCHAR2
593: , p_doc_level_id_tbl IN po_tbl_number
594: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
595: );
596:
597: --
598: PROCEDURE get_distribution_ids(
597: --
598: PROCEDURE get_distribution_ids(
599: p_doc_type IN VARCHAR2
600: , p_doc_level IN VARCHAR2
601: , p_doc_level_id_tbl IN po_tbl_number
602: , p_draft_id IN NUMBER
603: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
604: );
605:
599: p_doc_type IN VARCHAR2
600: , p_doc_level IN VARCHAR2
601: , p_doc_level_id_tbl IN po_tbl_number
602: , p_draft_id IN NUMBER
603: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
604: );
605:
606: --
607: PROCEDURE get_dist_ids_from_archive(
606: --
607: PROCEDURE get_dist_ids_from_archive(
608: p_doc_type IN VARCHAR2
609: , p_doc_level IN VARCHAR2
610: , p_doc_level_id_tbl IN po_tbl_number
611: , p_doc_revision_num IN NUMBER
612: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
613: , x_distribution_rev_num_tbl OUT NOCOPY po_tbl_number
614: );
608: p_doc_type IN VARCHAR2
609: , p_doc_level IN VARCHAR2
610: , p_doc_level_id_tbl IN po_tbl_number
611: , p_doc_revision_num IN NUMBER
612: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
613: , x_distribution_rev_num_tbl OUT NOCOPY po_tbl_number
614: );
615: --
616:
609: , p_doc_level IN VARCHAR2
610: , p_doc_level_id_tbl IN po_tbl_number
611: , p_doc_revision_num IN NUMBER
612: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
613: , x_distribution_rev_num_tbl OUT NOCOPY po_tbl_number
614: );
615: --
616:
617: FUNCTION is_encumbrance_on(