1 PACKAGE WSH_SC_TRX_INTERFACE AUTHID CURRENT_USER as
2 /* $Header: WSHSDOIS.pls 115.10 99/07/16 08:21:28 porting ship $ */
3
4
5 -- WSH_SC_TRX_INTERFACE
6 -- Purpose
7 -- Validate and Upload Ship Confirm Open Interface
8 -- History
9 -- 20-MAY-96 troveda Created
10 --
11
12 --
13 -- Name
14 -- Check_Serial_Number
15 -- Purpose
16 -- ensure any SN in SN range does not already exist with any one
17 -- of the following conditions
18 -- 1. current status not in (1,3) (ie allow 'instore' or
19 -- 'defined but not used' to permit RMAs that have been returned/reshelved)
20 -- 2. not yet interfaced to inventory
21 -- 3. also exists in inventory interface tables: MTL_SN
22 --
23 -- Arguments
24 -- X_Mode : either post-change or commit.
25 -- Post-change checking does not include the picking line itself
26 -- Commit checking is tighter/more granular by excluding pl_detail_line only
27 --
28 -- X_Serial_number_control : either N, Y or D
29 -- N = No serial checking, procedure returns success
30 -- Y = either predefined serial numbers or dynamic at inv receipt.
31 -- D = dynamic entry at sales issue
32 --
33 --
34 -- Notes
35 -- dynamic sql is built according to x_mode and whether to check for
36 -- uniqueness at item level, org level, neither (ie across orgs) or
37 -- both (ie for dynamic entry at sales issue).
38 PROCEDURE Check_Serial_Number(
39 X_SERIAL_NUMBER_CONTROL_CODE IN VARCHAR2,
40 X_WAREHOUSE_ID IN NUMBER,
41 X_ITEM_ID IN NUMBER,
42 X_LINE_ID IN NUMBER,
43 X_LINE_DETAIL_ID IN NUMBER,
44 X_SN IN VARCHAR2,
45 X_ERROR_CODE IN OUT NUMBER);
46
47
48 function DUPLICATE_SN_IN_INTERFACE
49 (X_serial_number_control_code in varchar2,
50 X_warehouse_id in number,
51 X_item_id in number,
52 X_rowid in varchar2,
53 X_sn in varchar2) return BOOLEAN;
54
55
56 procedure UPDATE_SOPLD_ROW
57 (X_picking_line_id in number,
58 X_picking_line_detail_id in number,
59 X_requested_quantity in number,
60 X_shipped_quantity in number,
61 X_warehouse in number,
62 X_sn in varchar2,
63 x_lot in varchar2,
64 x_revision in varchar2,
65 x_subinventory in varchar2,
66 x_locator_id in number,
67 x_departure_id in number,
68 x_delivery_id in number,
69 x_container_id in number,
70 x_context in varchar2,
71 x_dpw_assigned_flag in varchar2,
72 x_att1 in varchar2, x_att2 in varchar2, x_att3 in varchar2, x_att4 in varchar2,
73 x_att5 in varchar2, x_att6 in varchar2, x_att7 in varchar2, x_att8 in varchar2,
74 x_att9 in varchar2, x_att10 in varchar2, x_att11 in varchar2, x_att12 in varchar2,
75 x_att13 in varchar2, x_att14 in varchar2, x_att15 in varchar2,
76 error_code in out varchar2);
77
78 -- 905046. Added pick_slip_number as input to INSERT_SOPLD_ROW.
79
80 procedure INSERT_SOPLD_ROW
81 (X_parent_detail_id in number,
82 new_pld_id in out number,
83 X_pick_slip_number in number,
84 X_requested_quantity in number,
85 X_shipped_quantity in number,
86 X_warehouse_id in number,
87 X_sn in varchar2,
88 x_lot in varchar2,
89 x_revision in varchar2,
90 x_subinventory in varchar2,
91 x_locator_id in number,
92 x_departure_id in number,
93 x_delivery_id in number,
94 x_container_id in number,
95 x_context in varchar2,
96 x_att1 in varchar2, x_att2 in varchar2, x_att3 in varchar2, x_att4 in varchar2,
97 x_att5 in varchar2, x_att6 in varchar2, x_att7 in varchar2, x_att8 in varchar2,
98 x_att9 in varchar2, x_att10 in varchar2, x_att11 in varchar2, x_att12 in varchar2,
99 x_att13 in varchar2, x_att14 in varchar2, x_att15 in varchar2);
100
101 -- 905046. Added pick_slip_number as input to SPLIT_SOPLD_ROW.
102
103 procedure SPLIT_SOPLD_ROW
104 (X_picking_line_id in number,
105 X_picking_line_detail_id in number,
106 X_pick_slip_number in number,
107 new_pld_id in out number,
108 X_shipped_quantity in number,
109 X_warehouse_id in number,
110 X_sn in varchar2,
111 X_lot_number in varchar2,
112 X_revision in varchar2,
113 X_sub in varchar2,
114 X_loc in varchar2,
115 x_departure_id in number,
116 x_delivery_id in number,
117 x_container_id in number,
118 X_backorder_flag in boolean,
119 x_context in varchar2,
120 x_att1 in varchar2, x_att2 in varchar2, x_att3 in varchar2, x_att4 in varchar2,
121 x_att5 in varchar2, x_att6 in varchar2, x_att7 in varchar2, x_att8 in varchar2,
122 x_att9 in varchar2, x_att10 in varchar2, x_att11 in varchar2, x_att12 in varchar2,
123 x_att13 in varchar2, x_att14 in varchar2, x_att15 in varchar2,
124 error_code in out varchar);
125
126 procedure PROCESS_PICKING_DETAILS_INTER
127 (X_TRANSACTION_ID in number,
128 X_departure_id in number,
129 X_delivery_id in number,
130 X_warehouse_id in number,
131 X_rowid in out varchar2,
132 X_backorder_flag in boolean ,
133 x_error_code in out varchar2);
134
135 procedure PROCESS_FREIGHT_CHARGES_INTER
136 (X_transaction_id in number,
137 X_delivery_id in number,
138 X_del_currency in out varchar2,
139 x_rowid out char,
140 x_error_code in out varchar2);
141
142 END WSH_SC_TRX_INTERFACE;