1 PACKAGE WSH_DOC_SETS AUTHID CURRENT_USER as
2 /* $Header: WSHUSDSS.pls 115.1 99/07/16 08:23:57 porting ship $ */
3
4 --
5 -- Name
6 -- Print_Document_Sets
7 -- Purpose
8 -- Execute any Delivery-based Document Set by submitting each document
9 -- to the transaction manager
10 -- Arguments
11 -- many
12 -- Notes
13 -- all the paramters for every possible report in any document set
14 -- must be included as the paramters to this package. To reduce the
15 -- number of them we introduced naming standards for Delivery Based
16 -- shipping. However we must still support oexski and oexobr.
17
18 /* Included P_PROG_REQUEST_ID as a fix for bug 859003 */
19
20 PROCEDURE Print_Document_Sets (X_report_set_id IN number,
21 P_BATCH_NAME in varchar2 DEFAULT NULL,
22 P_BATCH_ID in varchar2 DEFAULT NULL,
23 P_PROG_REQUEST_ID in varchar2 DEFAULT NULL,
24 P_CATEGORY_HIGH in varchar2 DEFAULT NULL, /* oexshski only */
25 P_CATEGORY_LOW in varchar2 DEFAULT NULL, /* oexshski only */
26 P_CUSTOMER_ITEMS in varchar2 DEFAULT NULL,
27 P_DELIVERY_ID in varchar2 DEFAULT NULL,
28 P_DEPARTURE_DATE_HI in varchar2 DEFAULT NULL,
29 P_DEPARTURE_DATE_LO in varchar2 DEFAULT NULL,
30 P_DEPARTURE_ID in varchar2 DEFAULT NULL,
31 P_FREIGHT_CARRIER in varchar2 DEFAULT NULL,
32 P_ITEM in varchar2 DEFAULT NULL,
33 P_ITEM_DISPLAY in varchar2 DEFAULT NULL,
34 P_ITEM_FLEX_CODE in varchar2 DEFAULT NULL,
35 P_LINE_FLAG in varchar2 DEFAULT NULL, /* oexshski only */
36 P_LOCATOR_FLEX_CODE in varchar2 DEFAULT NULL,
37 P_ORDER_CATEGORY in varchar2 DEFAULT NULL, /* oexshobr only */
38 P_ORDER_TYPE_HIGH in varchar2 DEFAULT NULL, /* oexshski only */
39 P_ORDER_TYPE_LOW in varchar2 DEFAULT NULL, /* oexshski only */
40 P_ORGANIZATION_ID in varchar2 DEFAULT NULL, /* oexshobr only */
41 P_PICK_SLIP_NUMBER_HIGH in varchar2 DEFAULT NULL, /* oexshobr only */
42 P_PICK_SLIP_NUMBER_LOW in varchar2 DEFAULT NULL, /* oexshobr only */
43 P_PRINT_DESCRIPTION in varchar2 DEFAULT NULL, /* oexshobr only */
44 P_RELEASE_DATE_HIGH in varchar2 DEFAULT NULL, /* oexshobr only */
45 P_RELEASE_DATE_LOW in varchar2 DEFAULT NULL, /* oexshobr only */
46 P_RESERVATIONS in varchar2 DEFAULT NULL, /* oexshobr only */
47 P_SHIP_DATE_HIGH in varchar2 DEFAULT NULL, /* oexshski only */
48 P_SHIP_DATE_LOW in varchar2 DEFAULT NULL, /* oexshski only */
49 P_SOB_ID in varchar2 DEFAULT NULL,
50 P_USE_FUNCTIONAL_CURRENCY in varchar2 DEFAULT NULL,
51 P_WAREHOUSE in varchar2 DEFAULT NULL, /* oexshobr only */
52 P_WAREHOUSE_HIGH in varchar2 DEFAULT NULL, /* oexshski only */
53 P_WAREHOUSE_ID in varchar2 DEFAULT NULL,
54 P_WAREHOUSE_LOW in varchar2 DEFAULT NULL, /* oexshski only */
55 P_TEXT1 in varchar2 default null,
56 P_TEXT2 in varchar2 default null,
57 P_TEXT3 in varchar2 default null,
58 P_TEXT4 in varchar2 default null,
59 message_string in out varchar2,
60 status in out boolean);
61
62
63
64
65 END WSH_DOC_SETS;