[Home] [Help]
PACKAGE: APPS.WSH_MAPPING_DATA
Source
1 PACKAGE WSH_MAPPING_DATA AS
2 /* $Header: WSHMAPDS.pls 120.1 2005/07/11 14:33:59 bsadri noship $ */
3
4 C_SDEBUG CONSTANT NUMBER := wsh_debug_sv.C_LEVEL1;
5 C_DEBUG CONSTANT NUMBER := wsh_debug_sv.C_LEVEL2;
6
7
8 PROCEDURE Get_Delivery_Info ( p_delivery_id IN NUMBER,
9 p_document_type IN VARCHAR2,
10 x_name OUT NOCOPY VARCHAR2,
11 x_arrival_date OUT NOCOPY DATE,
12 x_departure_date OUT NOCOPY DATE,
13 x_vehicle_num_prefix OUT NOCOPY VARCHAR2,
14 x_vehicle_number OUT NOCOPY VARCHAR2,
15 x_route_id OUT NOCOPY VARCHAR2,
16 x_routing_instructions OUT NOCOPY VARCHAR2,
17 x_departure_seal_code OUT NOCOPY VARCHAR2,
18 x_customer_name OUT NOCOPY VARCHAR2,
19 x_customer_number OUT NOCOPY VARCHAR2,
20 x_warehouse_type OUT NOCOPY VARCHAR2,
21 --Bug 3458160
22 x_operator OUT NOCOPY VARCHAR2,
23 x_ship_to_loc_code OUT NOCOPY VARCHAR2,
24 x_cnsgn_cont_per_name OUT NOCOPY VARCHAR2, --4227777
25 x_cnsgn_cont_per_ph OUT NOCOPY VARCHAR2, --4227777
26 x_return_status OUT NOCOPY VARCHAR2
27 );
28
29 PROCEDURE get_part_addr_info(
30 p_partner_type IN VARCHAR2,
31 p_delivery_id IN NUMBER,
32 x_party_name OUT NOCOPY VARCHAR2,
33 x_partner_location OUT NOCOPY VARCHAR2,
34 x_currency OUT NOCOPY VARCHAR2,
35 x_duns_number OUT NOCOPY VARCHAR2,
36 x_intmed_ship_to_location OUT NOCOPY VARCHAR2,
37 x_pooled_ship_to_location OUT NOCOPY VARCHAR2,
38 x_address1 OUT NOCOPY VARCHAR2,
39 x_address2 OUT NOCOPY VARCHAR2,
40 x_address3 OUT NOCOPY VARCHAR2,
41 x_address4 OUT NOCOPY VARCHAR2,
42 x_city OUT NOCOPY VARCHAR2,
43 x_country OUT NOCOPY VARCHAR2,
44 x_county OUT NOCOPY VARCHAR2,
45 x_postal_code OUT NOCOPY VARCHAR2,
46 x_region OUT NOCOPY VARCHAR2,
47 x_state OUT NOCOPY VARCHAR2,
48 x_fax_number OUT NOCOPY VARCHAR2,
49 x_telephone OUT NOCOPY VARCHAR2,
50 x_url OUT NOCOPY VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2);
52
53 PROCEDURE get_ship_method_code(
54 p_carrier_name IN VARCHAR2,
55 p_service_level IN VARCHAR2 DEFAULT NULL,
56 p_mode_of_transport IN VARCHAR2 DEFAULT NULL,
57 p_doc_type IN VARCHAR2,
58 p_delivery_name IN VARCHAR2 DEFAULT NULL,
59 x_ship_method_code OUT NOCOPY VARCHAR2,
60 x_return_status OUT NOCOPY VARCHAR2);
61
62
63 -- ---------------------------------------------------------------------
64 -- Procedure: Get_Locn_Cust_Info
65 --
66 -- Parameters:
67 --
68 -- Description: This procedure gets the location, party_name, party_number
69 -- that are required for SHIPITEM and SHIPUNIT during
70 -- 940/945 outbound
71 -- Created: Locations Project. Patchset I. KVENKATE
72 -- -----------------------------------------------------------------------
73 PROCEDURE get_locn_cust_info(
74 p_location_id IN NUMBER,
75 p_org_id IN NUMBER,
76 p_customer_id IN NUMBER,
77 x_location OUT NOCOPY VARCHAR2,
78 x_party_name OUT NOCOPY VARCHAR2,
79 x_party_number OUT NOCOPY VARCHAR2,
80 x_return_status OUT NOCOPY VARCHAR2,
81 p_delivery_detail_id IN NUMBER,
82 p_wsn_rowid IN VARCHAR2,
83 p_requested_quantity IN NUMBER,
84 p_fm_serial_number IN VARCHAR2,
85 p_to_serial_number IN VARCHAR2,
86 x_requested_quantity OUT NOCOPY NUMBER,
87 x_shipped_quantity OUT NOCOPY NUMBER,
88 p_site_use_id IN NUMBER,
89 --bug 4227777
90 p_entity_type IN VARCHAR2,
91 x_cnsgn_cont_per_name OUT NOCOPY VARCHAR2,
92 x_cnsgn_cont_per_ph OUT NOCOPY VARCHAR2
93 );
94
95 END WSH_MAPPING_DATA;