eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_COMMUNICATION_PVT dependencies on PO_DOCUMENT_TYPES

Line 83: g_documentType PO_DOCUMENT_TYPES_TL.TYPE_NAME%type;

79: --Bug 4504228 END
80: g_buyer_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null; --Bug5671523 Adding g_buyer_fax
81: g_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
82: g_location_name HR_LOCATIONS.LOCATION_CODE%type := null;
83: g_documentType PO_DOCUMENT_TYPES_TL.TYPE_NAME%type;
84: g_currency_code PO_HEADERS_ALL.CURRENCY_CODE%type := null;
85: g_current_currency_code PO_HEADERS_ALL.CURRENCY_CODE%type := null;
86: g_format_mask varchar2(100) := null;
87: g_buyer_org HR_ALL_ORGANIZATION_UNITS.NAME%type := NULL;

Line 127: g_documentTypeCode PO_DOCUMENT_TYPES_TL.DOCUMENT_TYPE_CODE%type;

123:
124: g_documentName varchar2(200) := null; --bug#3630737:Holds concatinated value of DocumentType, po number and revision number
125:
126: --Start Bug#3771735
127: g_documentTypeCode PO_DOCUMENT_TYPES_TL.DOCUMENT_TYPE_CODE%type;
128: --End Bug#3771735
129:
130: -- Bug 4026592
131: g_is_contract_attached_doc varchar2(1);

Line 711: l_itemtype po_document_types.wf_approval_itemtype%type;

707:
708: l_progress varchar2(100);
709: l_seq_for_item_key varchar2(25); --Bug14305923
710: l_itemkey varchar2(60);
711: l_itemtype po_document_types.wf_approval_itemtype%type;
712: l_workflow_process po_document_types.wf_approval_process%type;
713: l_vendor_site_code varchar2(15);
714: l_vendor_site_id number;
715: l_vendor_site_lang PO_VENDOR_SITES.LANGUAGE%TYPE;

Line 712: l_workflow_process po_document_types.wf_approval_process%type;

708: l_progress varchar2(100);
709: l_seq_for_item_key varchar2(25); --Bug14305923
710: l_itemkey varchar2(60);
711: l_itemtype po_document_types.wf_approval_itemtype%type;
712: l_workflow_process po_document_types.wf_approval_process%type;
713: l_vendor_site_code varchar2(15);
714: l_vendor_site_id number;
715: l_vendor_site_lang PO_VENDOR_SITES.LANGUAGE%TYPE;
716: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;

Line 2641: l_doctype po_document_types_all.document_type_code%type;

2637: l_supp_lang fnd_languages.nls_language%type;
2638: l_territory fnd_languages.nls_territory%type;
2639: l_revision_num number;
2640: l_set_lang boolean;
2641: l_doctype po_document_types_all.document_type_code%type;
2642: l_document_subtype po_document_types_all.document_subtype%type;
2643: l_language_code fnd_languages.language_code%type;
2644: l_api_name CONSTANT VARCHAR2(25) := 'Communicate';
2645:

Line 2642: l_document_subtype po_document_types_all.document_subtype%type;

2638: l_territory fnd_languages.nls_territory%type;
2639: l_revision_num number;
2640: l_set_lang boolean;
2641: l_doctype po_document_types_all.document_type_code%type;
2642: l_document_subtype po_document_types_all.document_subtype%type;
2643: l_language_code fnd_languages.language_code%type;
2644: l_api_name CONSTANT VARCHAR2(25) := 'Communicate';
2645:
2646: l_pdf_tc_buyer_exists number(1); -- Whether PDF with Terms in buyers language already exists in Contracts Repository

Line 3522: l_itemtype po_document_types.wf_approval_itemtype%type;

3518: l_org_id number;
3519: l_revision_number number;
3520: l_language fnd_languages.language_code%type;
3521: l_entity_name varchar2(30);
3522: l_itemtype po_document_types.wf_approval_itemtype%type;
3523: l_itemkey varchar2(60);
3524: l_document blob;
3525: l_withTerms varchar2(1);
3526: l_document_length number;

Line 3691: l_itemtype po_document_types.wf_approval_itemtype%type;

3687: l_org_id number;
3688: l_revision_number number;
3689: l_language fnd_languages.language_code%type;
3690: l_entity_name varchar2(30);
3691: l_itemtype po_document_types.wf_approval_itemtype%type;
3692: l_itemkey varchar2(60);
3693: l_document blob;
3694: l_withTerms varchar2(1);
3695: l_document_length number;

Line 3806: l_itemtype po_document_types.wf_approval_itemtype%type;

3802: l_org_id number;
3803: l_revision_number number;
3804: l_language fnd_languages.language_code%type;
3805: l_entity_name varchar2(30);
3806: l_itemtype po_document_types.wf_approval_itemtype%type;
3807: l_itemkey varchar2(60);
3808: l_document blob;
3809: l_withTerms varchar2(1);
3810: l_document_length number;

Line 4055: l_itemtype po_document_types.wf_approval_itemtype%type;

4051: l_po_revision_number number;
4052: l_language fnd_languages.language_code%type;
4053: l_withTerms varchar2(1);
4054:
4055: l_itemtype po_document_types.wf_approval_itemtype%type;
4056: l_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;
4057: l_message FND_NEW_MESSAGES.message_text%TYPE;
4058:
4059: l_okc_doc_length number; -- Bug 4173198

Line 4943: --Bug 9391634 org_id was not set because of which fetching data from PO_DOCUMENT_TYPES_TL give error

4939: -- SQL Join:
4940:
4941: PO_COMMUNICATION_PVT.g_documentType := null;
4942: --Bug#3279968 Added the language column to the below sql statement to fetch onlyone record.
4943: --Bug 9391634 org_id was not set because of which fetching data from PO_DOCUMENT_TYPES_TL give error
4944: l_org_id := po_moac_utils_pvt.get_current_org_id;
4945:
4946: IF(l_org_id IS null) Then
4947:

Line 4952: --Bug 9391634 org_id was not set because of which fetching data from PO_DOCUMENT_TYPES_TL give error

4948: SELECT org_id INTO l_org_id FROM po_headers_all WHERE po_header_id = p_document_id;
4949: po_moac_utils_pvt.SET_POLICY_CONTEXT('S', l_org_id );
4950:
4951: END IF;
4952: --Bug 9391634 org_id was not set because of which fetching data from PO_DOCUMENT_TYPES_TL give error
4953:
4954: SELECT TYPE_NAME into PO_COMMUNICATION_PVT.g_documentType FROM PO_DOCUMENT_TYPES_TL
4955: WHERE document_type_code = p_document_type and document_subtype = p_document_subtype and language = USERENV('LANG');
4956:

Line 4954: SELECT TYPE_NAME into PO_COMMUNICATION_PVT.g_documentType FROM PO_DOCUMENT_TYPES_TL

4950:
4951: END IF;
4952: --Bug 9391634 org_id was not set because of which fetching data from PO_DOCUMENT_TYPES_TL give error
4953:
4954: SELECT TYPE_NAME into PO_COMMUNICATION_PVT.g_documentType FROM PO_DOCUMENT_TYPES_TL
4955: WHERE document_type_code = p_document_type and document_subtype = p_document_subtype and language = USERENV('LANG');
4956:
4957: /* For balnket documents eventtype is 'BLANKET LINE' and
4958: for other documents 'PO LINE' is event type, to get the price differentials*/