[Home] [Help]
4391: /* Get the release number as the next release in sequence */
4392:
4393: select nvl(max(release_num),0)+1
4394: into x_release_num
4395: from po_releases_all por, --
4397: where poh.po_header_id = x_source_doc_id
4398: and poh.po_header_id = por.po_header_id;
4399:
4397: where poh.po_header_id = x_source_doc_id
4398: and poh.po_header_id = por.po_header_id;
4399:
4400: /* Bug565530. gtummala. 10/23/97.
4401: * Even if the po_releases table gives us the next one in sequence,
4402: * this could conflict with a release_num that we have inserted into
4403: * the po_headers_interface table previously that has yet to converted
4404: * into a release eg. when we have two req lines that will be created
4405: * onto two diff. releases.
5293: por.release_num
5294: into x_segment1,
5295: x_release_num
5296: from po_headers_all poh, --
5297: po_releases por
5298: where por.po_release_id = x_autocreated_doc_id
5299: and por.po_header_id = poh.po_header_id;
5300:
5301: /* Append the release num to blanket po num */
5392: l_doc_type_to_create po_headers_all.type_lookup_code%TYPE;
5393: l_doc_type po_document_types_all_b.document_type_code%TYPE;
5394: l_doc_subtype po_document_types_all_b.document_subtype%TYPE;
5395: l_po_header_id po_headers_all.po_header_id%TYPE;
5396: l_po_release_id po_releases_all.po_release_id%TYPE;
5397: l_return_status VARCHAR2(1);
5398: --
5399:
5400: --start of code changes for the bug 14243104 fix
5728: from ece_tp_details etd,
5729: po_vendor_sites pvs,
5730: po_vendors pv,
5731: po_headers ph ,
5732: po_releases pr
5733: where pv.vendor_id = pvs.vendor_id
5734: and pvs.tp_header_id = etd.tp_header_id
5735: and etd.document_id = l_transaction_subtype
5736: and ph.vendor_id = pv.vendor_id