APPS.PO_PARTIAL_FUNDING_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 353: UPDATE po_distributions_all d

349: AND d.draft_id = p_draft_id;
350: ELSE
351: d_progress := 80;
352: FORALL i IN 1..l_dist_id_tbl.COUNT
353: UPDATE po_distributions_all d
354: SET d.funded_value = L_fund_value_tbl(i),
355: d.quantity_funded = L_qty_funded_tbl(i),
356: d.amount_funded = L_amt_funded_tbl(i),
357: d.change_in_funded_value = L_fund_value_tbl(i) -- <>

Line 411: FROM po_distributions_all d

407: AND p_draft_id <> -1 THEN
408: d_progress := 30;
409: SELECT Nvl(d.funded_value,0) - p_funded_value
410: INTO x_chng_in_funded_value
411: FROM po_distributions_all d
412: WHERE d.po_distribution_id = p_distribution_id;
413: ELSE
414: d_progress := 40;
415: x_chng_in_funded_value := p_funded_value;

Line 659: FROM po_distributions_all

655: END IF;
656:
657: SELECT Nvl(funded_value,0)
658: INTO l_funded_value
659: FROM po_distributions_all
660: WHERE po_distribution_id = l_distribution_id;
661: ELSIF l_shipment_id IS NOT NULL THEN
662: d_progress := 45;
663:

Line 671: FROM po_distributions_all d

667: END IF;
668:
669: SELECT Sum(Nvl(funded_value,0))
670: INTO l_funded_value
671: FROM po_distributions_all d
672: WHERE d.line_location_id = l_shipment_id;
673: ELSIF l_line_id IS NOT NULL THEN
674: d_progress := 50;
675:

Line 683: FROM po_distributions_all d

679: END IF;
680:
681: SELECT Sum(Nvl(funded_value,0))
682: INTO l_funded_value
683: FROM po_distributions_all d
684: WHERE d.po_line_id = l_line_id;
685: ELSIF l_header_id IS NOT NULL THEN
686: d_progress := 55;
687:

Line 695: FROM po_distributions_all d

691: END IF;
692:
693: SELECT Sum(Nvl(funded_value,0))
694: INTO l_funded_value
695: FROM po_distributions_all d
696: WHERE d.po_header_id = l_header_id;
697: END IF;
698: END IF;
699: