1 PACKAGE INV_LOT_ATTR_PUB AS
2 /* $Header: INVVLOTS.pls 120.0 2005/05/25 05:26:48 appldev noship $ */
3
4 -----------------------------------------------------------------------
5 -- Name : validate_grade_code
6 -- Desc :
7 -- Generic routine to validates a grade code , item
8 -- must be grade controlled and grade must exist in
9 -- mtl_grades table
10 -- I/P params :
11 -- grade code, item ID and Org ID
12 -----------------------------------------------------------------------
13
14 FUNCTION validate_grade_code( p_grade_code IN VARCHAR
15 , p_org_id IN NUMBER
16 , p_inventory_item_id IN NUMBER
17 , p_grade_control_flag IN VARCHAR2
18 , x_return_status OUT NOCOPY VARCHAR2
19 , x_msg_count OUT NOCOPY NUMBER
20 , x_msg_data OUT NOCOPY VARCHAR2)
21 RETURN BOOLEAN;
22
23 -----------------------------------------------------------------------
24 -- Name : validate_maturity_date
25 -- Desc :
26 -- Generic routine to validates maturity date.
27 -- Maturity Date must be greater than the Origination Date
28 --
29 -- This function assumes that validation for origination date
30 -- have already taken place
31 -- I/P params :
32 -- p_maturity_date, p_origination_date (Mandatory)
33 -----------------------------------------------------------------------
34
35 FUNCTION validate_maturity_date(
36 p_maturity_date IN DATE
37 , p_origination_date IN DATE
38 , x_return_status OUT NOCOPY VARCHAR2
39 , x_msg_count OUT NOCOPY NUMBER
40 , x_msg_data OUT NOCOPY VARCHAR2)
41 RETURN BOOLEAN ;
42
43 -----------------------------------------------------------------------
44 -- Name : validate_hold_date
45 -- Desc :
46 -- Generic routine to validates maturity date.
47 -- Hold Date must be greater than the Origination Date
48 --
49 -- This function assumes that validation for origination date
50 -- have already taken place
51 -- I/P params :
52 -- p_maturity_date, p_origination_date (Mandatory)
53 -----------------------------------------------------------------------
54
55 FUNCTION validate_hold_date(
56 p_hold_date IN DATE
57 , p_origination_date IN DATE
58 , x_return_status OUT NOCOPY VARCHAR2
59 , x_msg_count OUT NOCOPY NUMBER
60 , x_msg_data OUT NOCOPY VARCHAR2)
61 RETURN BOOLEAN ;
62
63 -----------------------------------------------------------------------
64 -- Name : validate_expiration_action_date
65 -- Desc :
66 -- Generic routine to validate expiration_action_date
67 -- Must be >= expiration date
68 --
69 -- This function assumes that validation for expiration date
70 -- have already taken place
71 -- I/P params :
72 -- p_expiration_action_date, p_expiration_date (Mandatory)
73 -----------------------------------------------------------------------
74
75 FUNCTION validate_exp_action_date(
76 p_expiration_action_date IN DATE
77 , p_expiration_date IN DATE
78 , x_return_status OUT NOCOPY VARCHAR2
79 , x_msg_count OUT NOCOPY NUMBER
80 , x_msg_data OUT NOCOPY VARCHAR2)
81 RETURN BOOLEAN ;
82
83 -----------------------------------------------------------------------
84 -- Name : validate_retest_date
85 -- Desc :
86 -- Generic routine to validates retest date.
87 -- Hold Date must be greater than the Origination Date
88 --
89 -- This function assumes that validation for origination date
90 -- have already taken place
91 -- I/P params :
92 -- p_retest_date, p_origination_date (Mandatory)
93 -----------------------------------------------------------------------
94
95 FUNCTION validate_retest_date(
96 p_retest_date IN DATE
97 , p_origination_date IN DATE
98 , x_return_status OUT NOCOPY VARCHAR2
99 , x_msg_count OUT NOCOPY NUMBER
100 , x_msg_data OUT NOCOPY VARCHAR2)
101 RETURN BOOLEAN ;
102
103 -----------------------------------------------------------------------
104 -- Name : validate_exp_action_code
105 -- Desc :
106 -- Generic routine to validates Expiration Action Code , item
107 -- must be shlef life controlled, and Action Code must exist in
108 -- mtl_actions table
109 -- I/P params :
110 -- p_expiration_action_code , item ID and Org ID (Mandatory)
111 -- p_shelf_life_code (optional..)
112 -----------------------------------------------------------------------
113
114 FUNCTION validate_exp_action_code( p_expiration_action_code IN VARCHAR
115 , p_org_id IN NUMBER
116 , p_inventory_item_id IN NUMBER
117 , p_shelf_life_code IN VARCHAR2
118 , x_return_status OUT NOCOPY VARCHAR2
119 , x_msg_count OUT NOCOPY NUMBER
120 , x_msg_data OUT NOCOPY VARCHAR2)
121 RETURN BOOLEAN;
122 -----------------------------------------------------------------------
123 -- Name : validate_reason_code
124 -- Desc :
125 -- Generic routine to validate reason code/ reason id
126 -- Must exist in MTL_TRANSACTION_REASONS
127 --
128 -- I/P params :
129 -- p_reason_code OR p_resson_id (Mandatory)
130 -----------------------------------------------------------------------
131
132 FUNCTION validate_reason_code (
133 p_reason_code IN VARCHAR2
134 , p_reason_id IN NUMBER
135 , x_return_status OUT NOCOPY VARCHAR2
136 , x_msg_count OUT NOCOPY NUMBER
137 , x_msg_data OUT NOCOPY VARCHAR2)
138 RETURN BOOLEAN ;
139
140 -----------------------------------------------------------------------
141 -- Name : validate_origination_type
142 -- Desc :
143 -- Generic routine to validate origination type
144 -- Must exist in mfg_lookups (lookup_type = 'ORIGINATION_TYPE')
145 --
146 -- I/P params :
147 -- p_origination_id (Mandatory)
148 -----------------------------------------------------------------------
149
150 FUNCTION validate_origination_type (
151 p_origination_type IN NUMBER
152 , x_return_status OUT NOCOPY VARCHAR2
153 , x_msg_count OUT NOCOPY NUMBER
154 , x_msg_data OUT NOCOPY VARCHAR2)
155 RETURN BOOLEAN ;
156
157 -----------------------------------------------------------------------
158 -- Name : validate_child_lot
159 -- Desc :
160 -- Generic routine to validate lot number
161 -- Validation conditions
162 -- # child lot is new
163 -- # Item must be child lot enable
164 -- # Validate naming conventions if child Lot has an associated parent lot
165 -- # relations ship between parent/child lot is valid
166 --
167 -- I/P params :
168 -- p_parent_lot_number, p_lot_number , itemid, orgid --> (Mandatory)
169 -- p_child_lot_flag (optional)
170 -----------------------------------------------------------------------
171
172 FUNCTION validate_child_lot (
173 p_parent_lot_number IN VARCHAR2
174 , p_lot_number IN VARCHAR2
175 , p_org_id IN NUMBER
176 , p_inventory_item_id IN NUMBER
177 , p_child_lot_flag IN VARCHAR2
178 , x_return_status OUT NOCOPY VARCHAR2
179 , x_msg_count OUT NOCOPY NUMBER
180 , x_msg_data OUT NOCOPY VARCHAR2)
181 RETURN BOOLEAN ;
182
183 -----------------------------------------------------------------------
184 -- Name : create_lot_uom_conv_wrapper
185 -- Desc : Uses by Transaction Manager Java code to create
186 -- lot specific conversion
187 --
188 -- I/P params :
189
190 -----------------------------------------------------------------------
191
192 PROCEDURE create_lot_uom_conv_wrapper
193 ( p_commit IN VARCHAR2
194 , p_action_type IN VARCHAR2
195 , p_reason_id IN NUMBER
196 , p_lot_number IN VARCHAR2
197 , p_organization_id IN NUMBER
198 , p_inventory_item_id IN NUMBER
199 , p_from_unit_of_measure IN VARCHAR2
200 , p_from_uom_code IN VARCHAR2
201 , p_from_uom_class IN VARCHAR2
202 , p_to_unit_of_measure IN VARCHAR2
203 , p_to_uom_code IN VARCHAR2
204 , p_to_uom_class IN VARCHAR2
205 , p_conversion_rate IN NUMBER
206 , p_disable_date IN DATE
207 , p_event_spec_disp_id IN NUMBER
208 , p_created_by IN NUMBER
209 , p_creation_date IN DATE
210 , p_last_updated_by IN NUMBER
211 , p_last_update_date IN DATE
212 , p_last_update_login IN NUMBER
213 , p_request_id IN NUMBER
214 , p_program_application_id IN NUMBER
215 , p_program_id IN NUMBER
216 , p_program_update_date IN DATE
217 , x_return_status OUT NOCOPY VARCHAR2
218 , x_msg_count OUT NOCOPY NUMBER
219 , x_msg_data OUT NOCOPY VARCHAR2
220 );
221
222 END INV_LOT_ATTR_PUB;
223
224