[Home] [Help]
622:
623: -- CLM Aprvl
624: Begin
625: SELECT 'Y' into l_clm_document
626: FROM po_headers_all h,
627: po_doc_style_headers s
628: WHERE h.po_header_id = l_document_id
629: AND h.style_id = s.style_id
630: AND Nvl(s.clm_flag,'N') = 'Y';
1688: l_preserved_ctx VARCHAR2(5);
1689: -- Context setting revamp
1690:
1691: --Added the below variables as part of bug 13951919 fix. Used to log the Delegate action in the PO_ACTION_HISTORY table.
1692: l_po_header_id po_headers_all.po_header_id%TYPE;
1693: l_doc_type po_action_history.OBJECT_TYPE_CODE%TYPE;
1694: l_doc_sub_type po_action_history.OBJECT_SUB_TYPE_CODE%TYPE;
1695: l_action po_action_history.action_code%TYPE;
1696: l_new_recipient_id wf_roles.orig_system_id%TYPE;
2400: l_notification_type varchar2(15); --bug 3668188
2401:
2402: --
2403: l_okc_doc_type varchar2(20);
2404: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
2405: l_document_id NUMBER;
2406: l_document_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2407: --
2408:
2402: --
2403: l_okc_doc_type varchar2(20);
2404: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
2405: l_document_id NUMBER;
2406: l_document_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2407: --
2408:
2409: BEGIN
2410:
2608: from po_document_types
2609: where document_type_code = p_doc_type
2610: and document_subtype = p_doc_subtype;
2611:
2612: l_document_id PO_HEADERS_ALL.po_header_id%TYPE; --
2614: l_draft_type PO_DRAFTS.DRAFT_TYPE%TYPE; -- PAR Approval
2615:
2616: BEGIN
2858: l_api_name VARCHAR2(30) := 'is_open_document_allowed';
2859: l_log_head VARCHAR2(100) := g_pkg_name||'.'||l_api_name;
2860: l_progress VARCHAR2(3);
2861:
2862: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;
2863: l_result BOOLEAN := TRUE;
2864:
2865: BEGIN
2866: