APPS.PO_AUTOCREATE_DOC dependencies on PO_DOCUMENT_TYPES

Line 5055: l_doc_type po_document_types_all_b.document_type_code%TYPE;

5051: x_progress varchar2(300);
5052:
5053: --
5054: l_doc_type_to_create po_headers_all.type_lookup_code%TYPE;
5055: l_doc_type po_document_types_all_b.document_type_code%TYPE;
5056: l_doc_subtype po_document_types_all_b.document_subtype%TYPE;
5057: l_po_header_id po_headers_all.po_header_id%TYPE;
5058: l_po_release_id po_releases_all.po_release_id%TYPE;
5059: l_return_status VARCHAR2(1);

Line 5056: l_doc_subtype po_document_types_all_b.document_subtype%TYPE;

5052:
5053: --
5054: l_doc_type_to_create po_headers_all.type_lookup_code%TYPE;
5055: l_doc_type po_document_types_all_b.document_type_code%TYPE;
5056: l_doc_subtype po_document_types_all_b.document_subtype%TYPE;
5057: l_po_header_id po_headers_all.po_header_id%TYPE;
5058: l_po_release_id po_releases_all.po_release_id%TYPE;
5059: l_return_status VARCHAR2(1);
5060: --

Line 5255: /* Need to get item_type and workflow process from po_document_types.

5251: x_doc_type := 'PO';
5252: x_doc_subtype := 'STANDARD';
5253: end if;
5254:
5255: /* Need to get item_type and workflow process from po_document_types.
5256: * They may be different based on the doc/org.
5257: */
5258:
5259:

Line 5289: * po_document_types as this is done now in start_wf_process.

5285: * this is null. Also deleted the code which gets the default supplier
5286: * communication method from po_vendor_site and now call
5287: * PO_VENDOR_SITES_SV.Get_Transmission_Defaults which does this now.
5288: * Also deleted the code which defaults item_type, item_key from
5289: * po_document_types as this is done now in start_wf_process.
5290: */
5291:
5292: /* Bug 1845764 :
5293: Check if the supplier site on the PO/Release has email as the default notification method.

Line 5960: ** po document types for correct translation.

5956: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 001';
5957:
5958: /* Bug# 2681512: kagarwal
5959: ** We will get the document type display value from
5960: ** po document types for correct translation.
5961: */
5962: /*
5963: select st.DISPLAYED_FIELD,
5964: ty.DISPLAYED_FIELD,

Line 6002: po_document_types ty

5998: l_preparer_id,
5999: doc_subtype,
6000: ItemType
6001: from po_requisition_headers hd,
6002: po_document_types ty
6003: where hd.requisition_header_id = p_req_header_id
6004: and ty.document_type_code = 'REQUISITION'
6005: and ty.document_subtype = hd.TYPE_LOOKUP_CODE;
6006:

Line 6018: from PO_DOCUMENT_TYPES

6014: begin
6015:
6016: select wf_approval_itemtype
6017: into ItemType
6018: from PO_DOCUMENT_TYPES
6019: where DOCUMENT_TYPE_CODE = 'REQUISITION'
6020: and DOCUMENT_SUBTYPE = doc_subtype;
6021:
6022: exception

Line 6119: ** document_type_code and document_subtype from po_document_types, because

6115: ** Need to call PO_REQAPPROVAL_INIT1.Get_Req_Attributes after start in
6116: ** NOTIFY_RETURN_REQ process, since the notification needs to be similar to
6117: ** other Req Approval Notifications.
6118: ** Setting the item attributes for DOCUMENT_TYPE and DOCUMENT_SUBTYPE with
6119: ** document_type_code and document_subtype from po_document_types, because
6120: ** these are used in PO_REQAPPROVAL_INIT1.SetReqHdrAttributes to set the item
6121: ** attribute for DOCUMENT_TYPE_DISP.
6122: */
6123: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,