APPS.PO_AUTOCREATE_DOC dependencies on PO_DOCUMENT_TYPES

Line 5393: l_doc_type po_document_types_all_b.document_type_code%TYPE;

5389: x_progress varchar2(300);
5390:
5391: --
5392: l_doc_type_to_create po_headers_all.type_lookup_code%TYPE;
5393: l_doc_type po_document_types_all_b.document_type_code%TYPE;
5394: l_doc_subtype po_document_types_all_b.document_subtype%TYPE;
5395: l_po_header_id po_headers_all.po_header_id%TYPE;
5396: l_po_release_id po_releases_all.po_release_id%TYPE;
5397: l_return_status VARCHAR2(1);

Line 5394: l_doc_subtype po_document_types_all_b.document_subtype%TYPE;

5390:
5391: --
5392: l_doc_type_to_create po_headers_all.type_lookup_code%TYPE;
5393: l_doc_type po_document_types_all_b.document_type_code%TYPE;
5394: l_doc_subtype po_document_types_all_b.document_subtype%TYPE;
5395: l_po_header_id po_headers_all.po_header_id%TYPE;
5396: l_po_release_id po_releases_all.po_release_id%TYPE;
5397: l_return_status VARCHAR2(1);
5398: --

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

5632: x_doc_type := 'PO';
5633: x_doc_subtype := 'STANDARD';
5634: end if;
5635:
5636: /* Need to get item_type and workflow process from po_document_types.
5637: * They may be different based on the doc/org.
5638: */
5639:
5640:

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

5666: * this is null. Also deleted the code which gets the default supplier
5667: * communication method from po_vendor_site and now call
5668: * PO_VENDOR_SITES_SV.Get_Transmission_Defaults which does this now.
5669: * Also deleted the code which defaults item_type, item_key from
5670: * po_document_types as this is done now in start_wf_process.
5671: */
5672:
5673: /* Bug 1845764 :
5674: Check if the supplier site on the PO/Release has email as the default notification method.

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

6378: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 001';
6379:
6380: /* Bug# 2681512: kagarwal
6381: ** We will get the document type display value from
6382: ** po document types for correct translation.
6383: */
6384: /*
6385: select st.DISPLAYED_FIELD,
6386: ty.DISPLAYED_FIELD,

Line 6426: po_document_types ty ,

6422: l_preparer_id,
6423: doc_subtype,
6424: ItemType
6425: from po_requisition_headers hd,
6426: po_document_types ty ,
6427: po_drafts pod
6428: where hd.requisition_header_id = p_req_header_id
6429: and ty.document_type_code = 'REQUISITION'
6430: and ty.document_subtype = hd.TYPE_LOOKUP_CODE

Line 6445: from PO_DOCUMENT_TYPES

6441: begin
6442:
6443: select wf_approval_itemtype
6444: into ItemType
6445: from PO_DOCUMENT_TYPES
6446: where DOCUMENT_TYPE_CODE = 'REQUISITION'
6447: and DOCUMENT_SUBTYPE = doc_subtype;
6448:
6449: exception

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

6542: ** Need to call PO_REQAPPROVAL_INIT1.Get_Req_Attributes after start in
6543: ** NOTIFY_RETURN_REQ process, since the notification needs to be similar to
6544: ** other Req Approval Notifications.
6545: ** Setting the item attributes for DOCUMENT_TYPE and DOCUMENT_SUBTYPE with
6546: ** document_type_code and document_subtype from po_document_types, because
6547: ** these are used in PO_REQAPPROVAL_INIT1.SetReqHdrAttributes to set the item
6548: ** attribute for DOCUMENT_TYPE_DISP.
6549: */
6550: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,