341: end if;
342:
343: select max(REVISION_NUM)
344: into l_max_rev
345: from po_headers_archive_all
346: where PO_HEADER_ID = l_po_header_id;
347:
348: if (upper(p_po_type) = 'STANDARD') then
349: l_po_type := 'PO';
682:
683: /* Ignore the revision number sent as requested by CLN team. */
684: select max(REVISION_NUM)
685: into l_max_rev
686: from po_headers_archive_all
687: where PO_HEADER_ID = l_po_header_id;
688:
689: if (upper(p_po_type) = 'STANDARD') then
690: l_po_type := 'PO';
1300: end if;
1301:
1302: select max(REVISION_NUM)
1303: into l_max_rev
1304: from po_headers_archive_all
1305: where PO_HEADER_ID = l_po_header_id;
1306:
1307: if (upper(p_po_type) = 'STANDARD') then
1308: l_po_type := 'PO';