APPS.PO_INTG_DOCUMENT_FUNDS_GRP dependencies on PO_DISTRIBUTIONS_ALL

Line 198: -- po_distributions_all table, depending on p_doc_type

194: -- g_doc_type_RELEASE (optional: behaves same as g_doc_type_PO)
195: -- NOTE: API does not current support Internal Requisitions
196: --p_distribution_id
197: -- Unique id of row from either po_req_distributions_all or
198: -- po_distributions_all table, depending on p_doc_type
199: --OUT:
200: --x_return_status
201: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
202: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

Line 227: l_accrue_on_receipt_flag PO_DISTRIBUTIONS_ALL.accrue_on_receipt_flag%TYPE;

223: l_progress VARCHAR2(3) := '000';
224:
225: l_encumbered_amount NUMBER;
226: l_document_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;
227: l_accrue_on_receipt_flag PO_DISTRIBUTIONS_ALL.accrue_on_receipt_flag%TYPE;
228: l_amount_moved_to_actual NUMBER;
229: l_return_status VARCHAR2(1); --Bug#5058165
230: l_msg_count NUMBER; --Bug#5058165
231: l_msg_data VARCHAR2(2000); --Bug#5058165

Line 344: FROM PO_DISTRIBUTIONS_ALL POD

340:
341: -- Bug 3446983: For encumbered PA, active enc = encumbered amt
342: SELECT nvl(POD.encumbered_amount, 0)
343: INTO x_active_enc_amount
344: FROM PO_DISTRIBUTIONS_ALL POD
345: WHERE POD.po_distribution_id = p_distribution_id
346: ;
347:
348: l_progress := '090';

Line 368: FROM PO_DISTRIBUTIONS_ALL POD

364: INTO
365: l_encumbered_amount
366: , l_accrue_on_receipt_flag
367: , l_document_subtype
368: FROM PO_DISTRIBUTIONS_ALL POD
369: , PO_LINE_LOCATIONS_ALL POLL
370: WHERE POD.po_distribution_id = p_distribution_id
371: AND POD.line_location_id = POLL.line_location_id
372: ;