530: END IF;
531:
532: SELECT mod_ame_transaction_type
533: INTO l_ame_transaction_type
534: FROM po_doc_style_headers pdsh, po_headers_all pha
535: WHERE pha.po_header_id = l_doc_row.po_header_id
536: AND pha.style_id = pdsh.style_id;
537:
538: --
843:
844:
845: SELECT pdsh.ame_transaction_type
846: INTO l_ame_transaction_type
847: FROM po_doc_style_headers pdsh, po_headers_all pha
848: WHERE pha.po_header_id = l_doc_row.po_header_id
849: AND pha.style_id = pdsh.style_id;
850:
851: UPDATE po_headers_draft_all
1710: END IF;
1711:
1712: SELECT 'N'
1713: INTO x_create_doc_flag
1714: FROM po_headers_all poh, po_doc_style_headers pdsh
1715: WHERE poh.po_header_id = p_po_header_id
1716: AND poh.style_id = pdsh.style_id
1717: AND poh.approved_flag = 'Y'
1718: AND pdsh.change_process_type = 'MODIFICATION';