eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.WSH_SHIPPING_CONSTRAINTS_PKG

Source


1 PACKAGE WSH_SHIPPING_CONSTRAINTS_PKG as
2 /* $Header: WSHCSCPS.pls 120.0 2005/05/26 18:09:14 appldev noship $ */
3 
4 TYPE ChangedAttributeRecType IS RECORD
5 		(original_source_line_id			NUMBER  ,
6 		source_header_id				NUMBER  ,
7 		source_line_id					NUMBER  ,
8           hold_code						VARCHAR2(1)  ,
9 		sold_to_org_id					NUMBER  ,
10 		sold_to_contact_id				NUMBER  ,
11           item_type_code					VARCHAR2(30)  ,
12 		ship_from_org_id				NUMBER  ,
13 		ship_to_org_id					NUMBER  ,
14 		ship_to_contact_id				NUMBER  ,
15 		deliver_to_org_id				NUMBER  ,
16 		deliver_to_contact_id			NUMBER  ,
17 		intmed_ship_to_org_id			NUMBER  ,
18 		intmed_ship_to_contact_id		NUMBER  ,
19 		ship_tolerance_above			NUMBER  ,
20 		ship_tolerance_below			NUMBER  ,
21 		ordered_quantity				NUMBER  ,
22 		order_quantity_uom				VARCHAR2(3)  ,
23 		subinventory					VARCHAR2(10)  ,
24 		revision						VARCHAR2(3)  ,
25 -- HW OPMCONV - Expand length of lot_number to 80
26 		lot_number					VARCHAR2(80)  ,
27 		customer_requested_lot_flag		VARCHAR2(1)  ,
28 		serial_number					VARCHAR2(30)  ,
29 		locator_id					NUMBER  ,
30 		date_requested					DATE ,
31 		date_scheduled					DATE ,
32 		master_container_item_id			NUMBER  ,
33 		detail_container_item_id			NUMBER  ,
34 		shipping_method_code			VARCHAR2(30)  ,
35 		carrier_id					NUMBER  ,
36 		freight_terms_code				VARCHAR2(30)  ,
37 		freight_carrier_code			VARCHAR2(30)  ,
38 		shipment_priority_code			VARCHAR2(30)  ,
39 		fob_code						VARCHAR2(30)  ,
40 		dep_plan_required_flag			VARCHAR2(1)  ,
41 		customer_prod_seq				VARCHAR2(50)  ,
42 		customer_dock_code				VARCHAR2(50)  ,
43 		cust_model_serial_number			VARCHAR2(50)  ,
44 		customer_job					VARCHAR2(50)  ,
45 		customer_production_line			VARCHAR2(50)  ,
46 		gross_weight					NUMBER  ,
47 		net_weight					NUMBER  ,
48 		weight_uom_code				VARCHAR2(3)  ,
49 		volume						NUMBER  ,
50 		volume_uom_code				VARCHAR2(3)  ,
51 		top_model_line_id				NUMBER  ,
52 		ship_set_id					NUMBER  ,
53 		ato_line_id					NUMBER  ,
54 	     arrival_set_id					NUMBER  ,
55 		ship_model_complete_flag			VARCHAR2(1)  ,
56 	     cust_po_number					VARCHAR2(50)  ,
57 		released_status				VARCHAR2(1)  ,
58 		action_flag					VARCHAR2(1)  ,
59 		shipped_flag            VARCHAR2(1)  ,
60 		packing_instructions			VARCHAR2(2000)  ,
61 		shipping_instructions			VARCHAR2(2000)  ,
62 		delivery_detail_id				NUMBER  ,
63  -- hverddin 26-jun-2000 start of OPM changes
64 -- HW OPMCONV - No need for sublot_number
65 --        sublot_number                      VARCHAR2(32)  ,
66           ordered_quantity2                  NUMBER  ,
67           ordered_quantity_uom2              VARCHAR2(3)  ,
68 -- HW OPMCONV - Increage size of grade
69           preferred_grade                    VARCHAR2(150)  ,
70           lot_id                             NUMBER   ,
71 	  currency_code                      VARCHAR2(15)  ,
72 -- hverddin 26-jun-2000 end of OPM changes
73           cycle_count_quantity               NUMBER    ,    -- added for Backordering
74           cycle_count_quantity2              NUMBER    ,
75 	  transfer_lpn_id                    NUMBER    ,    -- added for cross-docking
76 		inspection_flag                    VARCHAR2(1)  ,   -- added for Contracts
77 		shipped_quantity                 NUMBER  ,
78 		shipped_quantity2                NUMBER  ,
79 	tracking_number               VARCHAR2(30)  ,
80                 customer_item_id                NUMBER         ,
81 -- modified per bug 1535895 - added code to handle the flexfields.
82 		attribute_category		VARCHAR2(150)  ,
83 		attribute1			VARCHAR2(150)  ,
84 		attribute2			VARCHAR2(150)  ,
85 		attribute3			VARCHAR2(150)  ,
86 		attribute4			VARCHAR2(150)  ,
87 		attribute5			VARCHAR2(150)  ,
88 		attribute6			VARCHAR2(150)  ,
89 		attribute7			VARCHAR2(150)  ,
90 		attribute8			VARCHAR2(150)  ,
91 		attribute9			VARCHAR2(150)  ,
92 		attribute10			VARCHAR2(150)  ,
93 		attribute11			VARCHAR2(150)  ,
94 		attribute12			VARCHAR2(150)  ,
95 		attribute13			VARCHAR2(150)  ,
96 		attribute14			VARCHAR2(150)  ,
97 		attribute15			VARCHAR2(150)  ,
98 		pickable_flag            VARCHAR2(1)  ,
99 		original_subinventory    VARCHAR2(10) ,
100                 line_number 		 VARCHAR2(150) , -- Bug 1610845
101 		picked_quantity		NUMBER ,	 -- overpicking bug 1848530
102 		picked_quantity2	NUMBER ,	 -- overpicking bug 1848530
103 		pending_quantity	NUMBER ,	 -- overpicking bug 1848530
104 		pending_quantity2	NUMBER , 	 -- overpicking bug 1848530
105 		trans_id                 NUMBER -- NC OPM changes BUG #1636578
106 
107 );
108 
109 TYPE ChangedAttributeTabType IS TABLE OF ChangedAttributeRecType
110         INDEX BY BINARY_INTEGER;
111 
112 
113 PROCEDURE check_shipping_constraints
114 	(
115 	p_source_code            IN     VARCHAR2,
116 	p_changed_attributes      IN     ChangedAttributeRecType,
117 	x_return_status            OUT NOCOPY     VARCHAR2,
118 	x_action_allowed       OUT NOCOPY  VARCHAR2,
119 	x_action_message       OUT NOCOPY  VARCHAR2,
120 	x_ord_qty_allowed	       OUT NOCOPY  NUMBER,
121 	p_log_level              IN     NUMBER DEFAULT 0
122 	);
123 
124 END  WSH_SHIPPING_CONSTRAINTS_PKG;