523:
524: PROCEDURE get_document_ids(
525: p_doc_type IN VARCHAR2
526: , p_doc_level IN VARCHAR2
527: , p_doc_level_id_tbl IN po_tbl_number
528: , x_doc_id_tbl OUT NOCOPY po_tbl_number
529: );
530:
531:
524: PROCEDURE get_document_ids(
525: p_doc_type IN VARCHAR2
526: , p_doc_level IN VARCHAR2
527: , p_doc_level_id_tbl IN po_tbl_number
528: , x_doc_id_tbl OUT NOCOPY po_tbl_number
529: );
530:
531:
532: PROCEDURE get_line_ids(
531:
532: PROCEDURE get_line_ids(
533: p_doc_type IN VARCHAR2
534: , p_doc_level IN VARCHAR2
535: , p_doc_level_id_tbl IN po_tbl_number
536: , x_line_id_tbl OUT NOCOPY po_tbl_number
537: );
538:
539:
532: PROCEDURE get_line_ids(
533: p_doc_type IN VARCHAR2
534: , p_doc_level IN VARCHAR2
535: , p_doc_level_id_tbl IN po_tbl_number
536: , x_line_id_tbl OUT NOCOPY po_tbl_number
537: );
538:
539:
540: PROCEDURE get_line_location_ids(
539:
540: PROCEDURE get_line_location_ids(
541: p_doc_type IN VARCHAR2
542: , p_doc_level IN VARCHAR2
543: , p_doc_level_id_tbl IN po_tbl_number
544: , x_line_location_id_tbl OUT NOCOPY po_tbl_number
545: );
546:
547:
540: PROCEDURE get_line_location_ids(
541: p_doc_type IN VARCHAR2
542: , p_doc_level IN VARCHAR2
543: , p_doc_level_id_tbl IN po_tbl_number
544: , x_line_location_id_tbl OUT NOCOPY po_tbl_number
545: );
546:
547:
548: PROCEDURE get_distribution_ids(
547:
548: PROCEDURE get_distribution_ids(
549: p_doc_type IN VARCHAR2
550: , p_doc_level IN VARCHAR2
551: , p_doc_level_id_tbl IN po_tbl_number
552: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
553: );
554:
555: --
548: PROCEDURE get_distribution_ids(
549: p_doc_type IN VARCHAR2
550: , p_doc_level IN VARCHAR2
551: , p_doc_level_id_tbl IN po_tbl_number
552: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
553: );
554:
555: --
556: PROCEDURE get_dist_ids_from_archive(
555: --
556: PROCEDURE get_dist_ids_from_archive(
557: p_doc_type IN VARCHAR2
558: , p_doc_level IN VARCHAR2
559: , p_doc_level_id_tbl IN po_tbl_number
560: , p_doc_revision_num IN NUMBER
561: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
562: , x_distribution_rev_num_tbl OUT NOCOPY po_tbl_number
563: );
557: p_doc_type IN VARCHAR2
558: , p_doc_level IN VARCHAR2
559: , p_doc_level_id_tbl IN po_tbl_number
560: , p_doc_revision_num IN NUMBER
561: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
562: , x_distribution_rev_num_tbl OUT NOCOPY po_tbl_number
563: );
564: --
565:
558: , p_doc_level IN VARCHAR2
559: , p_doc_level_id_tbl IN po_tbl_number
560: , p_doc_revision_num IN NUMBER
561: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
562: , x_distribution_rev_num_tbl OUT NOCOPY po_tbl_number
563: );
564: --
565:
566: FUNCTION is_encumbrance_on(