763: end if;
764:
765: if (x_po_release_id is NOT NULL) then
766: x_total_level := 'R';
767: x_total := po_core_s.get_total(x_total_level, x_po_release_id);
768:
769: else
770: x_total := po_core_s.get_total(x_total_level, x_po_header_id);
771:
766: x_total_level := 'R';
767: x_total := po_core_s.get_total(x_total_level, x_po_release_id);
768:
769: else
770: x_total := po_core_s.get_total(x_total_level, x_po_header_id);
771:
772: end if;
773:
774: return x_total;
821: IF x_closed_by IS NOT NULL THEN
822: x_closed_by_name := get_person_name(x_closed_by);
823: END IF;
824:
825: x_base_currency := po_core_s2.get_base_currency;
826:
827: IF x_po_line_id IS NOT NULL THEN
828:
829: -- Bug 2954456 : The amount released has to be calculated in a different way for GA lines
853:
854: ELSE
855:
856: if PO_GA_PVT.is_global_agreement(l_po_header_id) then
857: PO_CORE_S.get_ga_line_amount_released( x_po_line_id, -- IN
858: l_po_header_id, -- OUT
859: l_quantity_released, -- OUT
860: x_amount ); -- OUT
861: else
858: l_po_header_id, -- OUT
859: l_quantity_released, -- OUT
860: x_amount ); -- OUT
861: else
862: x_amount := PO_CORE_S.GET_TOTAL('L', x_po_line_id);
863: end if;
864:
865: END IF;
866:
864:
865: END IF;
866:
867: ELSIF x_line_location_id IS NOT NULL THEN
868: x_amount := PO_CORE_S.GET_TOTAL('S', x_line_location_id);
869: ELSIF x_po_release_id IS NOT NULL THEN
870: x_amount := get_po_total(x_type_lookup_code, null, x_po_release_id);
871: ELSIF x_po_header_id IS NOT NULL THEN
872: x_amount := GET_PO_TOTAL(x_type_lookup_code, x_po_header_id, NULL);
923: IF x_closed_by IS NOT NULL THEN
924: x_closed_by_name := get_person_name(x_closed_by);
925: END IF;
926:
927: x_base_currency := po_core_s2.get_base_currency;
928:
929: IF x_wip_entity_id IS NOT NULL THEN
930: x_assembly_quantity := PO_INQ_SV.GET_ASSEMBLY_QUANTITY(
931: x_item_id,