DBA Data[Home] [Help]

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 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 609: l_itemtype po_document_types.wf_approval_itemtype%type;

605:
606: l_progress varchar2(100);
607: l_seq_for_item_key varchar2(6);
608: l_itemkey varchar2(60);
609: l_itemtype po_document_types.wf_approval_itemtype%type;
610: l_workflow_process po_document_types.wf_approval_process%type;
611: l_vendor_site_code varchar2(15);
612: l_vendor_site_id number;
613: l_vendor_site_lang PO_VENDOR_SITES.LANGUAGE%TYPE;

Line 610: l_workflow_process po_document_types.wf_approval_process%type;

606: l_progress varchar2(100);
607: l_seq_for_item_key varchar2(6);
608: l_itemkey varchar2(60);
609: l_itemtype po_document_types.wf_approval_itemtype%type;
610: l_workflow_process po_document_types.wf_approval_process%type;
611: l_vendor_site_code varchar2(15);
612: l_vendor_site_id number;
613: l_vendor_site_lang PO_VENDOR_SITES.LANGUAGE%TYPE;
614: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;

Line 2253: l_doctype po_document_types_all.document_type_code%type;

2249: l_supp_lang fnd_languages.nls_language%type;
2250: l_territory fnd_languages.nls_territory%type;
2251: l_revision_num number;
2252: l_set_lang boolean;
2253: l_doctype po_document_types_all.document_type_code%type;
2254: l_document_subtype po_document_types_all.document_subtype%type;
2255: l_language_code fnd_languages.language_code%type;
2256: l_api_name CONSTANT VARCHAR2(25):= 'Communicate';
2257:

Line 2254: l_document_subtype po_document_types_all.document_subtype%type;

2250: l_territory fnd_languages.nls_territory%type;
2251: l_revision_num number;
2252: l_set_lang boolean;
2253: l_doctype po_document_types_all.document_type_code%type;
2254: l_document_subtype po_document_types_all.document_subtype%type;
2255: l_language_code fnd_languages.language_code%type;
2256: l_api_name CONSTANT VARCHAR2(25):= 'Communicate';
2257:
2258: l_pdf_tc_buyer_exists number(1); -- Whether PDF with Terms in buyers language already exists in Contracts Repository

Line 3097: l_itemtype po_document_types.wf_approval_itemtype%type;

3093: l_org_id number;
3094: l_revision_number number;
3095: l_language fnd_languages.language_code%type;
3096: l_entity_name varchar2(30);
3097: l_itemtype po_document_types.wf_approval_itemtype%type;
3098: l_itemkey varchar2(60);
3099: l_document blob;
3100: l_withTerms varchar2(1);
3101: l_document_length number;

Line 3214: l_itemtype po_document_types.wf_approval_itemtype%type;

3210: l_org_id number;
3211: l_revision_number number;
3212: l_language fnd_languages.language_code%type;
3213: l_entity_name varchar2(30);
3214: l_itemtype po_document_types.wf_approval_itemtype%type;
3215: l_itemkey varchar2(60);
3216: l_document blob;
3217: l_withTerms varchar2(1);
3218: l_document_length number;

Line 3327: l_itemtype po_document_types.wf_approval_itemtype%type;

3323: l_org_id number;
3324: l_revision_number number;
3325: l_language fnd_languages.language_code%type;
3326: l_entity_name varchar2(30);
3327: l_itemtype po_document_types.wf_approval_itemtype%type;
3328: l_itemkey varchar2(60);
3329: l_document blob;
3330: l_withTerms varchar2(1);
3331: l_document_length number;

Line 3520: l_itemtype po_document_types.wf_approval_itemtype%type;

3516: l_po_revision_number number;
3517: l_language fnd_languages.language_code%type;
3518: l_withTerms varchar2(1);
3519:
3520: l_itemtype po_document_types.wf_approval_itemtype%type;
3521: l_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;
3522: l_message FND_NEW_MESSAGES.message_text%TYPE;
3523:
3524: l_okc_doc_length number; -- Bug 4173198

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