1 PACKAGE GMI_XFER_MST_PKG AUTHID CURRENT_USER AS
2 /*$Header: GMIXFERS.pls 115.2 2002/10/25 14:53:52 jdiiorio noship $*/
3
4 PROCEDURE insert_row (p_commit IN VARCHAR2,
5 p_called_by_form IN VARCHAR2,
6 p_transfer_id IN NUMBER,
7 p_transfer_no IN VARCHAR2,
8 p_transfer_batch IN VARCHAR2,
9 p_orgn_code IN VARCHAR2,
10 p_transfer_status IN VARCHAR2,
11 p_item_id IN NUMBER,
12 p_lot_id IN NUMBER,
13 p_lot_status IN VARCHAR2,
14 p_release_reason_code IN VARCHAR2,
15 p_receive_reason_code IN VARCHAR2,
16 p_cancel_reason_code IN VARCHAR2,
17 p_from_warehouse IN VARCHAR2,
18 p_from_location IN VARCHAR2,
19 p_to_warehouse IN VARCHAR2,
20 p_to_location IN VARCHAR2,
21 p_release_quantity1 IN NUMBER,
22 p_release_quantity2 IN NUMBER,
23 p_release_uom1 IN VARCHAR2,
24 p_release_uom2 IN VARCHAR2,
25 p_receive_quantity1 IN NUMBER,
26 p_receive_quantity2 IN NUMBER,
27 p_scheduled_release_date IN DATE,
28 p_actual_release_date IN DATE,
29 p_scheduled_receive_date IN DATE,
30 p_actual_receive_date IN DATE,
31 p_cancel_date IN DATE,
32 p_delete_mark IN NUMBER,
33 p_received_by IN NUMBER,
34 p_released_by IN NUMBER,
35 p_canceled_by IN NUMBER,
36 p_text_code IN NUMBER,
37 p_comments IN VARCHAR2,
38 p_attribute_category IN VARCHAR2,
39 p_attribute1 IN VARCHAR2,
40 p_attribute2 IN VARCHAR2,
41 p_attribute3 IN VARCHAR2,
42 p_attribute4 IN VARCHAR2,
43 p_attribute5 IN VARCHAR2,
44 p_attribute6 IN VARCHAR2,
45 p_attribute7 IN VARCHAR2,
46 p_attribute8 IN VARCHAR2,
47 p_attribute9 IN VARCHAR2,
48 p_attribute10 IN VARCHAR2,
49 p_attribute11 IN VARCHAR2,
50 p_attribute12 IN VARCHAR2,
51 p_attribute13 IN VARCHAR2,
52 p_attribute14 IN VARCHAR2,
53 p_attribute15 IN VARCHAR2,
54 p_attribute16 IN VARCHAR2,
55 p_attribute17 IN VARCHAR2,
56 p_attribute18 IN VARCHAR2,
57 p_attribute19 IN VARCHAR2,
58 p_attribute20 IN VARCHAR2,
59 p_attribute21 IN VARCHAR2,
60 p_attribute22 IN VARCHAR2,
61 p_attribute23 IN VARCHAR2,
62 p_attribute24 IN VARCHAR2,
63 p_attribute25 IN VARCHAR2,
64 p_attribute26 IN VARCHAR2,
65 p_attribute27 IN VARCHAR2,
66 p_attribute28 IN VARCHAR2,
67 p_attribute29 IN VARCHAR2,
68 p_attribute30 IN VARCHAR2,
69 p_created_by IN NUMBER,
70 p_creation_date IN DATE,
71 p_last_updated_by IN NUMBER,
72 p_last_update_date IN DATE,
73 p_last_update_login IN NUMBER,
74 x_rowid OUT NOCOPY VARCHAR2,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_oracle_error OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2);
78
79 PROCEDURE update_row (p_commit IN VARCHAR2,
80 p_called_by_form IN VARCHAR2,
81 p_rowid IN VARCHAR2,
82 p_transfer_id IN NUMBER,
83 p_transfer_no IN VARCHAR2,
84 p_transfer_batch IN VARCHAR2,
85 p_orgn_code IN VARCHAR2,
86 p_transfer_status IN VARCHAR2,
87 p_item_id IN NUMBER,
88 p_lot_id IN NUMBER,
89 p_lot_status IN VARCHAR2,
90 p_release_reason_code IN VARCHAR2,
91 p_receive_reason_code IN VARCHAR2,
92 p_cancel_reason_code IN VARCHAR2,
93 p_from_warehouse IN VARCHAR2,
94 p_from_location IN VARCHAR2,
95 p_to_warehouse IN VARCHAR2,
96 p_to_location IN VARCHAR2,
97 p_release_quantity1 IN NUMBER,
98 p_release_quantity2 IN NUMBER,
99 p_release_uom1 IN VARCHAR2,
100 p_release_uom2 IN VARCHAR2,
101 p_receive_quantity1 IN NUMBER,
102 p_receive_quantity2 IN NUMBER,
103 p_scheduled_release_date IN DATE,
104 p_actual_release_date IN DATE,
105 p_scheduled_receive_date IN DATE,
106 p_actual_receive_date IN DATE,
107 p_cancel_date IN DATE,
108 p_delete_mark IN NUMBER,
109 p_received_by IN NUMBER,
110 p_released_by IN NUMBER,
111 p_canceled_by IN NUMBER,
112 p_text_code IN NUMBER,
113 p_comments IN VARCHAR2,
114 p_attribute_category IN VARCHAR2,
115 p_attribute1 IN VARCHAR2,
116 p_attribute2 IN VARCHAR2,
117 p_attribute3 IN VARCHAR2,
118 p_attribute4 IN VARCHAR2,
119 p_attribute5 IN VARCHAR2,
120 p_attribute6 IN VARCHAR2,
121 p_attribute7 IN VARCHAR2,
122 p_attribute8 IN VARCHAR2,
123 p_attribute9 IN VARCHAR2,
124 p_attribute10 IN VARCHAR2,
125 p_attribute11 IN VARCHAR2,
126 p_attribute12 IN VARCHAR2,
127 p_attribute13 IN VARCHAR2,
128 p_attribute14 IN VARCHAR2,
129 p_attribute15 IN VARCHAR2,
130 p_attribute16 IN VARCHAR2,
131 p_attribute17 IN VARCHAR2,
132 p_attribute18 IN VARCHAR2,
133 p_attribute19 IN VARCHAR2,
134 p_attribute20 IN VARCHAR2,
135 p_attribute21 IN VARCHAR2,
136 p_attribute22 IN VARCHAR2,
137 p_attribute23 IN VARCHAR2,
138 p_attribute24 IN VARCHAR2,
139 p_attribute25 IN VARCHAR2,
140 p_attribute26 IN VARCHAR2,
141 p_attribute27 IN VARCHAR2,
142 p_attribute28 IN VARCHAR2,
143 p_attribute29 IN VARCHAR2,
144 p_attribute30 IN VARCHAR2,
145 p_created_by IN NUMBER,
146 p_creation_date IN DATE,
147 p_last_updated_by IN NUMBER,
148 p_last_update_date IN DATE,
149 p_last_update_login IN NUMBER,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_oracle_error OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2);
153
154 PROCEDURE check_foreign_keys
155 (p_orgn_code IN VARCHAR2,
156 p_item_id IN NUMBER,
157 p_lot_id IN NUMBER,
158 p_lot_status IN VARCHAR2,
159 p_release_reason_code IN VARCHAR2,
160 p_receive_reason_code IN VARCHAR2,
161 p_cancel_reason_code IN VARCHAR2,
162 p_from_warehouse IN VARCHAR2,
163 p_from_location IN VARCHAR2,
164 p_to_warehouse IN VARCHAR2,
165 p_to_location IN VARCHAR2,
166 p_received_by IN NUMBER,
167 p_released_by IN NUMBER,
168 p_canceled_by IN NUMBER,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_oracle_error OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2);
172
173 PROCEDURE check_primary_key
174 (p_orgn_code IN VARCHAR2,
175 p_transfer_no IN VARCHAR2,
176 p_called_by_form IN VARCHAR2,
177 x_rowid OUT NOCOPY VARCHAR2,
178 x_key_exists OUT NOCOPY VARCHAR2);
179
180 PROCEDURE Lock_Row (p_called_by_form IN VARCHAR2,
181 p_rowid IN VARCHAR2,
182 p_last_update_date IN DATE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_oracle_error OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2);
186
187 END GMI_XFER_MST_PKG;