[Home] [Help]
PACKAGE: APPS.WSH_DOCUMENT_SETS
Source
1 PACKAGE WSH_DOCUMENT_SETS as
2 /* $Header: WSHDSPRS.pls 120.0.12000000.1 2007/01/16 05:45:00 appldev ship $ */
3
4
5 TYPE document_set_rec_type IS RECORD(
6 p_report_set_id NUMBER,
7 p_request_id NUMBER,
8 p_customer_id NUMBER,
9 p_item_id NUMBER,
10 p_item_cate_set_id NUMBER,
11 p_item_category_id NUMBER,
12 p_transaction_type_id NUMBER,
13 p_header_id_low NUMBER,
14 p_header_id_high NUMBER,
15 p_salesrep_id NUMBER,
16 p_user_id NUMBER,
17 p_territory_name VARCHAR2(80),
18 p_item_display VARCHAR2(30),
19 p_item_flex_code VARCHAR2(30),
20 p_organization_id NUMBER,
21 p_sort_by NUMBER,
22 p_show_functional_currency VARCHAR2(20),
23 p_ledger_id NUMBER, -- LE Uptake
24 p_order_date_low DATE,
25 p_order_date_high DATE,
26 p_delivery_date_low DATE,
27 p_delivery_date_high DATE,
28 p_freight_code VARCHAR2(30),
29 p_delivery_id NUMBER,
30 p_delivery_id_high number,
31 p_delivery_id_low number,
32 p_trip_id NUMBER,
33 p_trip_id_high NUMBER,
34 p_trip_id_low NUMBER,
35 p_delivery_leg_id NUMBER,
36 p_bill_of_lading_number NUMBER,
37 p_trip_stop_id NUMBER,
38 p_departure_date_low DATE,
39 p_departure_date_high DATE,
40 p_container_id NUMBER,
41 p_print_cust_item VARCHAR2(20),
42 p_print_mode VARCHAR2(20),
43 p_print_all VARCHAR2(20),
44 p_sort VARCHAR2(20),
45 p_delivery_date_lo DATE,
46 p_delivery_date_hi DATE,
47 p_freight_carrier VARCHAR2(30),
48 p_quantity_precision VARCHAR2(20),
49 p_locator_flex_code VARCHAR2(20),
50 p_warehouse_id NUMBER,
51 pick_slip_num_l NUMBER,
52 pick_slip_num_h NUMBER,
53 p_order_type_id NUMBER, --Bugfix 3604021
54 p_order_num_l NUMBER,
55 p_order_num_h NUMBER,
56 p_order_num_low NUMBER,
57 p_order_num_high NUMBER,
58 --p_move_order_l NUMBER,
59 --p_move_order_h NUMBER,
60 p_move_order_l VARCHAR2(30),
61 p_move_order_h VARCHAR2(30),
62 p_ship_method_code VARCHAR2(30),
63 p_customer_name VARCHAR2(80),
64 p_pick_status VARCHAR2(20),
65 p_detail_date_l DATE,
66 p_detail_date_h DATE,
67 p_exception_name VARCHAR2(60),
68 p_exception_location_id NUMBER,
69 p_logging_entity VARCHAR2(60),
70 p_logging_location_id NUMBER,
71 p_location_id NUMBER,
72 p_creation_date_from DATE,
73 p_creation_date_to DATE,
74 p_last_update_date_from DATE,
75 p_last_update_date_to DATE,
76 p_severity VARCHAR2(10),
77 p_status VARCHAR2(30),
78 p_text1 VARCHAR2(240),
79 p_text2 VARCHAR2(240),
80 p_text3 VARCHAR2(240),
81 p_text4 VARCHAR2(240),
82 p_currency_code VARCHAR2(15),
83 p_printer_name VARCHAR2(30),
84 bol_error_flag VARCHAR2(1)
85 );
86
87 TYPE document_set_tab_type IS TABLE OF document_set_rec_type INDEX BY BINARY_INTEGER;
88
89 --
90 -- Name
91 -- Print_Document_Sets
92 -- Purpose
93 -- Execute any Delivery-based Document Set by submitting each document
94 -- to the transaction manager
95 -- Arguments
96 -- many
97
98
99 PROCEDURE print_document_sets(
100 p_report_set_id IN NUMBER,
101 p_organization_id IN NUMBER,
102 p_trip_ids IN WSH_UTIL_CORE.Id_Tab_Type,
103 p_stop_ids IN WSH_UTIL_CORE.Id_Tab_Type,
104 p_delivery_ids IN WSH_UTIL_CORE.Id_Tab_Type,
105 p_document_param_info IN WSH_DOCUMENT_SETS.DOCUMENT_SET_TAB_TYPE,
106 x_return_status IN OUT NOCOPY VARCHAR2);
107
108
109 END WSH_DOCUMENT_SETS;