APPS.PO_PARTIAL_FUNDING_PKG dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 253: FROM po_req_distributions_all d,

249: GLSOB.CURRENCY_CODE
250: BULK COLLECT INTO l_dist_id_tbl,l_price_tbl,l_match_basis_tbl,l_qty_ordered_tbl,
251: l_amt_ordered_tbl,l_partial_flag_tbl,l_fund_value_tbl,l_nr_tax_tbl,
252: l_rate_tbl,l_qty_funded_tbl,l_amt_funded_tbl,l_func_currency_tbl
253: FROM po_req_distributions_all d,
254: po_requisition_lines_all l,
255: GL_SETS_OF_BOOKS GLSOB
256: WHERE l.requisition_header_id = p_doc_header_id
257: AND l.requisition_line_id = d.requisition_line_id

Line 335: UPDATE po_req_distributions_all d

331:
332: IF p_document_type = 'REQUISITION' THEN
333: d_progress := 70;
334: FORALL i IN 1..l_dist_id_tbl.COUNT
335: UPDATE po_req_distributions_all d
336: SET d.funded_value = L_fund_value_tbl(i),
337: d.quantity_funded = L_qty_funded_tbl(i),
338: d.amount_funded = L_amt_funded_tbl(i)
339: WHERE d.distribution_id = L_dist_id_tbl(i);

Line 404: FROM po_req_distributions_all d

400: AND p_conf_dist_id IS NOT NULL THEN
401: d_progress := 20;
402: SELECT Nvl(d.funded_value,0) - p_funded_value
403: INTO x_chng_in_funded_value
404: FROM po_req_distributions_all d
405: WHERE d.distribution_id = p_conf_dist_id;
406: ELSIF p_document_type = 'PO'
407: AND p_draft_id <> -1 THEN
408: d_progress := 30;

Line 487: from po_Req_Distributions_all

483: is
484: select
485: funded_value,
486: Req_Line_Quantity
487: from po_Req_Distributions_all
488: Where Distribution_Id = p_Distribution_Id;
489:
490:
491: cursor New_Req_line_Info is

Line 499: FROM po_requisition_lines_all prl, po_req_distributions_all prd

495: req_line_quantity,
496: prl.Unit_Price,
497: Nvl(prd.nonrecoverable_tax,0),
498: source_req_distribution_id
499: FROM po_requisition_lines_all prl, po_req_distributions_all prd
500: WHERE prl.Requisition_Line_Id =p_new_Req_line_id
501: and prd.Requisition_Line_Id = prl.Requisition_Line_Id;
502:
503:

Line 562: Update po_Req_Distributions_all

558: End If;
559: l_Chg_Fund_Value_Tbl(i) := l_funded_Value_tbl(i);
560: End Loop;
561: forall i in 1..l_Distribution_id_tbl.count
562: Update po_Req_Distributions_all
563: Set funded_value = l_funded_Value_tbl(i),
564: Quantity_Funded = l_Qty_Funded_Tbl(i),
565: Change_In_Funded_Value = l_Chg_Fund_Value_Tbl(i)
566: Where Distribution_Id = l_Distribution_id_tbl(i);

Line 610: FROM po_req_distributions_all

606: END IF;
607:
608: SELECT Nvl(funded_value,0)
609: INTO l_funded_value
610: FROM po_req_distributions_all
611: WHERE distribution_id = l_distribution_id;
612: ELSIF l_line_id IS NOT NULL THEN
613: d_progress := 25;
614:

Line 622: FROM po_req_distributions_all d,

618: END IF;
619:
620: SELECT Sum(Nvl(funded_value,0))
621: INTO l_funded_value
622: FROM po_req_distributions_all d,
623: po_requisition_lines_all l
624: WHERE d.requisition_line_id = l.requisition_line_id
625: AND l.requisition_line_id = l_line_id;
626: ELSIF l_header_id IS NOT NULL THEN

Line 636: FROM po_req_distributions_all d,

632: END IF;
633:
634: SELECT Sum(Nvl(funded_value,0))
635: INTO l_funded_value
636: FROM po_req_distributions_all d,
637: po_requisition_lines_all l
638: WHERE d.requisition_line_id = l.requisition_line_id
639: AND l.requisition_header_id = l_header_id;
640: END IF;