[Home] [Help]
3371: WHERE REQUISITION_HEADER_ID = l_req_document_id;
3372:
3373: ELSIF p_doc_level='DISTRIBUTION' THEN
3374: SELECT requisition_header_id into l_req_document_id
3375: FROM PO_REQUISITION_LINES_ALL POL, PO_REQ_DISTRIBUTIONS_ALL POD
3376: WHERE POL.REQUISITION_LINE_ID = POD.REQUISITION_LINE_ID
3377: AND POD.DISTRIBUTION_ID =p_doc_level_id;
3378:
3379:
3633: UPDATE po_distributions_all
3634: SET nonrecoverable_tax = nvl(l_nonrecoverable_tax_tbl(indx),0)
3635: WHERE po_distribution_id = l_distribution_id_tbl(indx);
3636: ELSIF l_distribution_type_tbl(indx) IN ('REQUISITION') THEN
3637: UPDATE po_req_distributions_all
3638: SET nonrecoverable_tax = nvl(l_nonrecoverable_tax_tbl(indx),0)
3639: WHERE distribution_id = l_distribution_id_tbl(indx);
3640: END IF;
3641: END LOOP;
4484: -- PO_HEADERS_ALL
4485: -- PO_RELEASES_ALL
4486: -- PO_DISTRIBUTIONS_ALL
4487: -- PO_REQUISITION_HEADERS_ALL
4488: -- PO_REQ_DISTRIBUTIONS_ALL
4489: --Function:
4490: -- Flattens the PO transaction tables to retrieve all of the
4491: -- data needed by the encumbrance code and put it in the
4492: -- encumbrance table. Also locks the document headers and
4737: , PRD.AMOUNT_FUNDED
4738: , PRD.CHANGE_IN_FUNDED_VALUE
4739: /* <
4740: FROM
4741: PO_REQ_DISTRIBUTIONS_ALL PRD
4742: , PO_REQUISITION_LINES_ALL PRL
4743: , PO_REQUISITION_HEADERS_ALL PRH
4744: , PO_SESSION_GT DIST_IDS
4745: WHERE PRH.requisition_header_id = PRL.requisition_header_id --JOIN
5467:
5468: BEGIN
5469: select nvl(pod.encumbered_flag, 'N')
5470: into l_found
5471: from po_req_distributions_all prd,
5472: po_requisition_lines_all prl,
5473: po_distributions_all pod
5474: where prd.distribution_id = p_req_dist_id
5475: and prl.requisition_line_id = prd.requisition_line_id