1 PACKAGE GR_REG_PRINT_DOC AS
2 /* $Header: GROMPRTS.pls 120.1 2005/07/05 15:26:53 methomas noship $ */
3
4
5
6 /*===========================================================================
7 -- PROCEDURE:
8 -- print_shipping_doc
9 --
10 -- DESCRIPTION:
11 -- This procedure is used to print the documents attached to an object - Regulatory Item,
12 -- Linked Inventory Item, Sales Order, etc. It is meant to be called from the
13 -- Order Management Ship Confirm.
14 --
15 -- PARAMETERS:
16 -- p_delivery_id IN NUMBER - Delivery ID key to the workflow record
17 --
18 -- RETURNS:
19 -- errbuf OUT VARCHAR2 - Returns error message only when this procedure is submitted from a concurrent program.
20 -- retcode OUT VARCHAR2 - Returns error code only when this procedure is submitted from a concurrent program.
21 --
22 -- SYNOPSIS:
23 -- GR_REG_DOC_PRINT.printing_shipping_doc(p_delivery_id);
24 --
25 -- HISTORY
26 --=========================================================================== */
27
28
29 PROCEDURE print_shipping_doc (errbuf OUT NOCOPY VARCHAR2,
30 retcode OUT NOCOPY VARCHAR2,
31 p_delivery_id IN NUMBER);
32
33
34 /*===========================================================================
35 -- PROCEDURE:
36 -- attach_shipping_document
37 --
38 -- DESCRIPTION:
39 -- This procedure is used to attach a Regulatory document to a Shipment line if the
40 -- item on the line is a Regulatory item and no other Regulatory documents have been
41 -- attached to that line.
42 --
43 -- PARAMETERS:
44 -- p_delivery_id IN NUMBER - Delivery ID key of Shipment
45 -- x_return_status OUT NOCOPY VARCHAR2 - Status of procedure execution
46 -- x_msg_data OUT NOCOPY VARCHAR2 - Error message, if error has occurred
47 --
48 -- SYNOPSIS:
49 -- GR_REG_DOC_PRINT.attach_shipping_document(p_delivery_id, l_return_status, l_msg_data);
50 --
51 -- HISTORY
52 --=========================================================================== */
53 PROCEDURE ATTACH_SHIPPING_DOCUMENT(
54 p_delivery_id IN NUMBER,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_data OUT NOCOPY VARCHAR2);
57
58
59
60 /*===========================================================================
61 -- PROCEDURE:
62 -- print_reg_docs
63 --
64 -- DESCRIPTION:
65 -- This procedure is used to print the current version of approved documents
66 -- that fall within the specified ranges.
67 --
68 -- PARAMETERS:
69 -- errbuf OUT NOCOPY VARCHAR2 - Error message, when submitted from concurrent program
70 -- retcode OUT NOCOPY VARCHAR2 - Error code, when submitted from concurrent program
71 -- p_orgn_id IN NUMBER - Organization_id to search items in
72 -- p_from_item IN VARCHAR2 - First item in range
73 -- p_to_item IN VARCHAR2 - Last item in range
74 - p_from_language IN VARCHAR2 - First language in range
75 -- p_to_language IN VARCHAR2 - Last language in range
76 -- p_document_category IN VARCHAR2 - Document category to retrict documents to
77 -- p_update_dispatch_history IN VARCHAR2 - Update Dispatch History - 'Y'es or 'N'o
78 -- p_recipent_site IN NUMBER - ID of site receiving the dispatch
79 --
80 -- SYNOPSIS:
81 -- GR_REG_DOC_PRINT.print_reg_item_docs(errbuf,retcode,p_from_item,p_to_item,p_from_lang,
82 -- p_to_lang,p_doc_category,p_upd_disp_hist,p_recipient_site);
83 --
84 -- HISTORY
85 --=========================================================================== */
86 PROCEDURE PRINT_REG_DOCS(
87 errbuf OUT NOCOPY VARCHAR2
88 ,retcode OUT NOCOPY VARCHAR2
89 ,p_orgn_id IN NUMBER
90 ,p_from_item IN VARCHAR2
91 ,p_to_item IN VARCHAR2
92 ,p_from_language IN VARCHAR2
93 ,p_to_language IN VARCHAR2
94 ,p_document_category IN VARCHAR2
95 ,p_update_dispatch_history IN VARCHAR2
96 ,p_recipient_site IN VARCHAR2
97 );
98
99 END GR_REG_PRINT_DOC;
100