APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_DOC_STYLE_HEADERS

Line 748: l_ame_transaction_type PO_DOC_STYLE_HEADERS.ame_transaction_type%TYPE;

744: /* Mod Project */
745: l_is_mod VARCHAR2(1) := 'N';
746: l_ame_approval_id NUMBER;
747: l_document_id_temp NUMBER;
748: l_ame_transaction_type PO_DOC_STYLE_HEADERS.ame_transaction_type%TYPE;
749: /* The new workflow with AME will be used for PO and PA */
750: /* Mod Project */
751: -- CLM CO signature ER
752: l_clm_contract_officer po_headers_all.clm_contract_officer%TYPE;

Line 5358: l_transaction_type po_doc_style_headers.ame_transaction_type%TYPE;

5354: l_approval_path_id NUMBER;
5355: l_draft_id NUMBER := p_draft_id; --Mod Project
5356: l_doc_id NUMBER := p_doc_id; --Mod Project
5357: l_doc_subtype VARCHAR2(25) := p_doc_subtype;--Mod Project
5358: l_transaction_type po_doc_style_headers.ame_transaction_type%TYPE;
5359: l_draft_type PO_DRAFTS.DRAFT_TYPE%TYPE; -- PAR Approval
5360: CURSOR action_hist_cursor(doc_id NUMBER , doc_type VARCHAR2)
5361: IS
5362: SELECT MAX(sequence_num)

Line 8955: FROM po_doc_style_headers ds,

8951: ds.ame_transaction_type)
8952: INTO l_itemtype,
8953: l_workflow_process,
8954: l_ame_transaction_type
8955: FROM po_doc_style_headers ds,
8956: po_headers_merge_v phm
8957: WHERE phm.po_header_id = DocumentId
8958: AND NVL(phm.draft_id, -1) = DraftId
8959: AND phm.style_id = ds.style_id