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_TL

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 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*/