1 PACKAGE GR_DISPATCH_HISTORY_PVT AUTHID CURRENT_USER AS
2 /* $Header: GRVDSPHS.pls 120.2 2005/08/24 09:55:30 pbamb noship $ */
3
4 /*--------------------------------------------------------------------------------------
5 Procedure : create_dispatch_history
6 Descrption: The Dispatch History Private API will store details pertaining to the
7 distribution of Regulatory documents. If the document itself has not already been
8 stored in the fnd_documents table, the eSignatures file upload API will be called
9 to do so. The API can be called from within the E-Business Suite by the public API.
10 ----------------------------------------------------------------------------------------*/
11
12 PROCEDURE CREATE_DISPATCH_HISTORY_REC
13 (p_item IN VARCHAR2,
14 p_organization_id IN NUMBER,
15 p_inventory_item_id IN NUMBER,
16 p_cas_number IN VARCHAR2,
17 p_recipient_id IN NUMBER,
18 p_recipient_site_id IN NUMBER,
19 p_date_sent IN DATE,
20 p_dispatch_method_code IN NUMBER,
21 p_document_id IN NUMBER,
22 p_document_location IN VARCHAR2,
23 p_document_name IN VARCHAR2,
24 p_document_version IN VARCHAR2,
25 p_document_category IN VARCHAR2,
26 p_file_format IN VARCHAR2,
27 p_file_description IN VARCHAR2,
28 p_document_code IN VARCHAR2,
29 p_disclosure_code IN VARCHAR2,
30 p_language IN VARCHAR2,
31 p_organization_code IN VARCHAR2,
32 p_user_id IN NUMBER,
33 p_creation_source IN NUMBER,
34 x_return_status OUT NOCOPY VARCHAR2 ,
35 x_msg_count OUT NOCOPY NUMBER ,
36 x_msg_data OUT NOCOPY VARCHAR2
37 );
38
39 /*--------------------------------------------------------------------------------------
40 Procedure : get_cas_no
41 Descrption: This API returns the Cas number for a given item number.
42 ----------------------------------------------------------------------------------------*/
43
44 PROCEDURE GET_CAS_NO(p_item IN varchar2,
45 p_organization_id IN NUMBER,
46 p_cas_no OUT NOCOPY varchar2);
47
48 /*--------------------------------------------------------------------------------------
49 Procedure : get_organization_code
50 Descrption: This API returns organization code based on organization id.
51 ----------------------------------------------------------------------------------------*/
52
53 PROCEDURE GET_ORGANIZATION_CODE( p_orgn_id IN NUMBER,
54 p_orgn_code OUT NOCOPY VARCHAR2);
55
56
57 /*--------------------------------------------------------------------------------------
58 Procedure : get_item_desc
59 Descrption: This API returns Item Description based on item id, organization id.
60 ----------------------------------------------------------------------------------------*/
61
62 PROCEDURE GET_ITEM_DESC( P_item_id IN NUMBER,
63 p_orgn_id IN NUMBER,
64 p_item_desc OUT NOCOPY VARCHAR2);
65
66
67 END GR_DISPATCH_HISTORY_PVT; -- Package spec