DBA Data[Home] [Help]

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 124: g_documentTypeCode PO_DOCUMENT_TYPES_TL.DOCUMENT_TYPE_CODE%type;

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

Line 4196: SELECT TYPE_NAME into PO_COMMUNICATION_PVT.g_documentType FROM PO_DOCUMENT_TYPES_TL

4192:
4193: PO_COMMUNICATION_PVT.g_documentType := null;
4194: --Bug#3279968 Added the language column to the below sql statement to fetch onlyone record.
4195:
4196: SELECT TYPE_NAME into PO_COMMUNICATION_PVT.g_documentType FROM PO_DOCUMENT_TYPES_TL
4197: WHERE document_type_code = p_document_type and document_subtype = p_document_subtype and language = USERENV('LANG');
4198:
4199: /* For balnket documents eventtype is 'BLANKET LINE' and
4200: for other documents 'PO LINE' is event type, to get the price differentials*/