APPS.PO_COPYDOC_S1 dependencies on PO_AME_APPROVALS_S

Line 483: --SELECT po_ame_approvals_s.NEXTVAL into l_ame_approval_id FROM dual;

479: p_message => 'header ID: '||x_po_header_record.po_header_id||
480: ' online_report ID: '||x_online_report_id);
481: END IF;
482:
483: --SELECT po_ame_approvals_s.NEXTVAL into l_ame_approval_id FROM dual;
484: /* PO AME Approval workflow change : Fetch next sequence value of ame_approval_id
485: in case AME transaction type is populated in Style Headers page*/
486: -- Start : PO AME Approval workflow
487: l_ame_approval_id := null;

Line 493: SELECT po_ame_approvals_s.NEXTVAL, ame_transaction_type

489: IF (x_po_header_record.type_lookup_code = 'STANDARD'
490: OR (x_po_header_record.type_lookup_code in ('BLANKET','CONTRACT')
491: AND nvl(x_po_header_record.global_agreement_flag,'N') = 'Y')) THEN
492: BEGIN
493: SELECT po_ame_approvals_s.NEXTVAL, ame_transaction_type
494: INTO l_ame_approval_id, l_ame_transaction_type
495: FROM po_doc_style_headers podsh
496: WHERE podsh.style_id= x_po_header_record.style_id
497: AND podsh.ame_transaction_type IS NOT NULL;