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.

APPS.GMI_VALID_GRP dependencies on IC_ITEM_MST

Line 34: ( p_item_no IN ic_item_mst.item_no%TYPE

30: -- Initial Vers : 1.0
31: -- Notes
32: --
33: FUNCTION Validate_Item_Existance
34: ( p_item_no IN ic_item_mst.item_no%TYPE
35: )
36: RETURN NUMBER;
37: --
38: FUNCTION Validate_Dualum_Ind

Line 39: ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE

35: )
36: RETURN NUMBER;
37: --
38: FUNCTION Validate_Dualum_Ind
39: ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE
40: )
41: RETURN BOOLEAN;
42: --
43: FUNCTION Validate_Item_Um2

Line 44: ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE

40: )
41: RETURN BOOLEAN;
42: --
43: FUNCTION Validate_Item_Um2
44: ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE
45: , p_item_um2 IN ic_item_mst.item_um2%TYPE
46: )
47: RETURN BOOLEAN;
48: --

Line 45: , p_item_um2 IN ic_item_mst.item_um2%TYPE

41: RETURN BOOLEAN;
42: --
43: FUNCTION Validate_Item_Um2
44: ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE
45: , p_item_um2 IN ic_item_mst.item_um2%TYPE
46: )
47: RETURN BOOLEAN;
48: --
49: FUNCTION Validate_Deviation

Line 50: ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE

46: )
47: RETURN BOOLEAN;
48: --
49: FUNCTION Validate_Deviation
50: ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE
51: , p_deviation IN ic_item_mst.deviation_hi%TYPE
52: )
53: RETURN BOOLEAN;
54: --

Line 51: , p_deviation IN ic_item_mst.deviation_hi%TYPE

47: RETURN BOOLEAN;
48: --
49: FUNCTION Validate_Deviation
50: ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE
51: , p_deviation IN ic_item_mst.deviation_hi%TYPE
52: )
53: RETURN BOOLEAN;
54: --
55: FUNCTION Validate_Lot_Ctl

Line 56: ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE

52: )
53: RETURN BOOLEAN;
54: --
55: FUNCTION Validate_Lot_Ctl
56: ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
57: )
58: RETURN BOOLEAN;
59: --
60: FUNCTION Validate_Lot_Indivisible

Line 61: ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE

57: )
58: RETURN BOOLEAN;
59: --
60: FUNCTION Validate_Lot_Indivisible
61: ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
62: , p_lot_indivisible IN ic_item_mst.lot_indivisible%TYPE
63: )
64: RETURN BOOLEAN;
65: --

Line 62: , p_lot_indivisible IN ic_item_mst.lot_indivisible%TYPE

58: RETURN BOOLEAN;
59: --
60: FUNCTION Validate_Lot_Indivisible
61: ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
62: , p_lot_indivisible IN ic_item_mst.lot_indivisible%TYPE
63: )
64: RETURN BOOLEAN;
65: --
66: FUNCTION Validate_Sublot_Ctl

Line 67: ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE

63: )
64: RETURN BOOLEAN;
65: --
66: FUNCTION Validate_Sublot_Ctl
67: ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
68: , p_sublot_ctl IN ic_item_mst.sublot_ctl%TYPE
69: )
70: RETURN BOOLEAN;
71: --

Line 68: , p_sublot_ctl IN ic_item_mst.sublot_ctl%TYPE

64: RETURN BOOLEAN;
65: --
66: FUNCTION Validate_Sublot_Ctl
67: ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
68: , p_sublot_ctl IN ic_item_mst.sublot_ctl%TYPE
69: )
70: RETURN BOOLEAN;
71: --
72: FUNCTION Validate_Loct_Ctl

Line 73: ( p_loct_ctl IN ic_item_mst.loct_ctl%TYPE

69: )
70: RETURN BOOLEAN;
71: --
72: FUNCTION Validate_Loct_Ctl
73: ( p_loct_ctl IN ic_item_mst.loct_ctl%TYPE
74: )
75: RETURN BOOLEAN;
76: --
77: FUNCTION Validate_Noninv_Ind

Line 78: ( p_noninv_ind IN ic_item_mst.noninv_ind%TYPE

74: )
75: RETURN BOOLEAN;
76: --
77: FUNCTION Validate_Noninv_Ind
78: ( p_noninv_ind IN ic_item_mst.noninv_ind%TYPE
79: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
80: )
81: RETURN BOOLEAN;
82: --

Line 79: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE

75: RETURN BOOLEAN;
76: --
77: FUNCTION Validate_Noninv_Ind
78: ( p_noninv_ind IN ic_item_mst.noninv_ind%TYPE
79: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
80: )
81: RETURN BOOLEAN;
82: --
83: FUNCTION Validate_Match_Type

Line 84: ( p_match_type IN ic_item_mst.match_type%TYPE

80: )
81: RETURN BOOLEAN;
82: --
83: FUNCTION Validate_Match_Type
84: ( p_match_type IN ic_item_mst.match_type%TYPE
85: )
86: RETURN BOOLEAN;
87: --
88: FUNCTION Validate_Inactive_Ind

Line 89: ( p_inactive_ind IN ic_item_mst.inactive_ind%TYPE

85: )
86: RETURN BOOLEAN;
87: --
88: FUNCTION Validate_Inactive_Ind
89: ( p_inactive_ind IN ic_item_mst.inactive_ind%TYPE
90: )
91: RETURN BOOLEAN;
92: --
93: FUNCTION Validate_Inv_Type

Line 94: ( p_inv_type IN ic_item_mst.inv_type%TYPE

90: )
91: RETURN BOOLEAN;
92: --
93: FUNCTION Validate_Inv_Type
94: ( p_inv_type IN ic_item_mst.inv_type%TYPE
95: )
96: RETURN BOOLEAN;
97: --
98: FUNCTION Validate_Shelf_Life

Line 99: ( p_shelf_life IN ic_item_mst.shelf_life%TYPE

95: )
96: RETURN BOOLEAN;
97: --
98: FUNCTION Validate_Shelf_Life
99: ( p_shelf_life IN ic_item_mst.shelf_life%TYPE
100: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
101: )
102: RETURN BOOLEAN;
103: --

Line 100: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE

96: RETURN BOOLEAN;
97: --
98: FUNCTION Validate_Shelf_Life
99: ( p_shelf_life IN ic_item_mst.shelf_life%TYPE
100: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
101: )
102: RETURN BOOLEAN;
103: --
104: FUNCTION Validate_Retest_Interval

Line 105: ( p_retest_interval IN ic_item_mst.retest_interval%TYPE

101: )
102: RETURN BOOLEAN;
103: --
104: FUNCTION Validate_Retest_Interval
105: ( p_retest_interval IN ic_item_mst.retest_interval%TYPE
106: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
107: )
108: RETURN BOOLEAN;
109: --

Line 106: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE

102: RETURN BOOLEAN;
103: --
104: FUNCTION Validate_Retest_Interval
105: ( p_retest_interval IN ic_item_mst.retest_interval%TYPE
106: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
107: )
108: RETURN BOOLEAN;
109: --
110: FUNCTION Validate_Item_Abccode

Line 111: ( p_item_abccode IN ic_item_mst.item_abccode%TYPE

107: )
108: RETURN BOOLEAN;
109: --
110: FUNCTION Validate_Item_Abccode
111: ( p_item_abccode IN ic_item_mst.item_abccode%TYPE
112: )
113: RETURN BOOLEAN;
114: --
115: FUNCTION Validate_Gl_Class

Line 116: ( p_gl_class IN ic_item_mst.gl_class%TYPE

112: )
113: RETURN BOOLEAN;
114: --
115: FUNCTION Validate_Gl_Class
116: ( p_gl_class IN ic_item_mst.gl_class%TYPE
117: )
118: RETURN BOOLEAN;
119: --
120: FUNCTION Validate_Inv_Class

Line 121: ( p_inv_class IN ic_item_mst.inv_class%TYPE

117: )
118: RETURN BOOLEAN;
119: --
120: FUNCTION Validate_Inv_Class
121: ( p_inv_class IN ic_item_mst.inv_class%TYPE
122: )
123: RETURN BOOLEAN;
124: --
125: FUNCTION Validate_Sales_Class

Line 126: ( p_sales_class IN ic_item_mst.sales_class%TYPE

122: )
123: RETURN BOOLEAN;
124: --
125: FUNCTION Validate_Sales_Class
126: ( p_sales_class IN ic_item_mst.sales_class%TYPE
127: )
128: RETURN BOOLEAN;
129: --
130: FUNCTION Validate_Ship_Class

Line 131: ( p_ship_class IN ic_item_mst.ship_class%TYPE

127: )
128: RETURN BOOLEAN;
129: --
130: FUNCTION Validate_Ship_Class
131: ( p_ship_class IN ic_item_mst.ship_class%TYPE
132: )
133: RETURN BOOLEAN;
134: --
135: FUNCTION Validate_Frt_Class

Line 136: ( p_frt_class IN ic_item_mst.frt_class%TYPE

132: )
133: RETURN BOOLEAN;
134: --
135: FUNCTION Validate_Frt_Class
136: ( p_frt_class IN ic_item_mst.frt_class%TYPE
137: )
138: RETURN BOOLEAN;
139: --
140: FUNCTION Validate_Price_Class

Line 141: ( p_price_class IN ic_item_mst.price_class%TYPE

137: )
138: RETURN BOOLEAN;
139: --
140: FUNCTION Validate_Price_Class
141: ( p_price_class IN ic_item_mst.price_class%TYPE
142: )
143: RETURN BOOLEAN;
144: --
145: FUNCTION Validate_Storage_Class

Line 146: ( p_storage_class IN ic_item_mst.storage_class%TYPE

142: )
143: RETURN BOOLEAN;
144: --
145: FUNCTION Validate_Storage_Class
146: ( p_storage_class IN ic_item_mst.storage_class%TYPE
147: )
148: RETURN BOOLEAN;
149: --
150: FUNCTION Validate_Purch_Class

Line 151: ( p_purch_class IN ic_item_mst.purch_class%TYPE

147: )
148: RETURN BOOLEAN;
149: --
150: FUNCTION Validate_Purch_Class
151: ( p_purch_class IN ic_item_mst.purch_class%TYPE
152: )
153: RETURN BOOLEAN;
154: --
155: FUNCTION Validate_Tax_Class

Line 156: ( p_tax_class IN ic_item_mst.tax_class%TYPE

152: )
153: RETURN BOOLEAN;
154: --
155: FUNCTION Validate_Tax_Class
156: ( p_tax_class IN ic_item_mst.tax_class%TYPE
157: )
158: RETURN BOOLEAN;
159: --
160: FUNCTION Validate_Customs_Class

Line 161: ( p_customs_class IN ic_item_mst.customs_class%TYPE

157: )
158: RETURN BOOLEAN;
159: --
160: FUNCTION Validate_Customs_Class
161: ( p_customs_class IN ic_item_mst.customs_class%TYPE
162: )
163: RETURN BOOLEAN;
164: --
165: FUNCTION Validate_Alloc_Class

Line 166: ( p_alloc_class IN ic_item_mst.alloc_class%TYPE

162: )
163: RETURN BOOLEAN;
164: --
165: FUNCTION Validate_Alloc_Class
166: ( p_alloc_class IN ic_item_mst.alloc_class%TYPE
167: )
168: RETURN BOOLEAN;
169: --
170: FUNCTION Validate_Planning_Class

Line 171: ( p_planning_class IN ic_item_mst.planning_class%TYPE

167: )
168: RETURN BOOLEAN;
169: --
170: FUNCTION Validate_Planning_Class
171: ( p_planning_class IN ic_item_mst.planning_class%TYPE
172: )
173: RETURN BOOLEAN;
174: --
175: FUNCTION Validate_Itemcost_Class

Line 176: ( p_itemcost_class IN ic_item_mst.itemcost_class%TYPE

172: )
173: RETURN BOOLEAN;
174: --
175: FUNCTION Validate_Itemcost_Class
176: ( p_itemcost_class IN ic_item_mst.itemcost_class%TYPE
177: )
178: RETURN BOOLEAN;
179: --
180: FUNCTION Validate_Cost_Mthd_Code

Line 181: ( p_cost_mthd_code IN ic_item_mst.cost_mthd_code%TYPE

177: )
178: RETURN BOOLEAN;
179: --
180: FUNCTION Validate_Cost_Mthd_Code
181: ( p_cost_mthd_code IN ic_item_mst.cost_mthd_code%TYPE
182: )
183: RETURN BOOLEAN;
184: --
185: FUNCTION Validate_Grade_Ctl

Line 186: ( p_grade_ctl IN ic_item_mst.grade_ctl%TYPE

182: )
183: RETURN BOOLEAN;
184: --
185: FUNCTION Validate_Grade_Ctl
186: ( p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
187: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
188: )
189: RETURN BOOLEAN;
190: --

Line 187: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE

183: RETURN BOOLEAN;
184: --
185: FUNCTION Validate_Grade_Ctl
186: ( p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
187: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
188: )
189: RETURN BOOLEAN;
190: --
191: FUNCTION Validate_Status_Ctl

Line 192: ( p_status_ctl IN ic_item_mst.status_ctl%TYPE

188: )
189: RETURN BOOLEAN;
190: --
191: FUNCTION Validate_Status_Ctl
192: ( p_status_ctl IN ic_item_mst.status_ctl%TYPE
193: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
194: )
195: RETURN BOOLEAN;
196: --

Line 193: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE

189: RETURN BOOLEAN;
190: --
191: FUNCTION Validate_Status_Ctl
192: ( p_status_ctl IN ic_item_mst.status_ctl%TYPE
193: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
194: )
195: RETURN BOOLEAN;
196: --
197: FUNCTION Validate_Qc_Grade

Line 198: ( p_qc_grade IN ic_item_mst.qc_grade%TYPE

194: )
195: RETURN BOOLEAN;
196: --
197: FUNCTION Validate_Qc_Grade
198: ( p_qc_grade IN ic_item_mst.qc_grade%TYPE
199: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
200: )
201: RETURN BOOLEAN;
202: --

Line 199: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE

195: RETURN BOOLEAN;
196: --
197: FUNCTION Validate_Qc_Grade
198: ( p_qc_grade IN ic_item_mst.qc_grade%TYPE
199: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
200: )
201: RETURN BOOLEAN;
202: --
203: FUNCTION Validate_Lot_Status

Line 204: ( p_lot_status IN ic_item_mst.lot_status%TYPE

200: )
201: RETURN BOOLEAN;
202: --
203: FUNCTION Validate_Lot_Status
204: ( p_lot_status IN ic_item_mst.lot_status%TYPE
205: , p_status_ctl IN ic_item_mst.status_ctl%TYPE
206: )
207: RETURN BOOLEAN;
208: --

Line 205: , p_status_ctl IN ic_item_mst.status_ctl%TYPE

201: RETURN BOOLEAN;
202: --
203: FUNCTION Validate_Lot_Status
204: ( p_lot_status IN ic_item_mst.lot_status%TYPE
205: , p_status_ctl IN ic_item_mst.status_ctl%TYPE
206: )
207: RETURN BOOLEAN;
208: --
209: FUNCTION Validate_Qchold_Res_Code

Line 210: ( p_qchold_res_code IN ic_item_mst.qchold_res_code%TYPE

206: )
207: RETURN BOOLEAN;
208: --
209: FUNCTION Validate_Qchold_Res_Code
210: ( p_qchold_res_code IN ic_item_mst.qchold_res_code%TYPE
211: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
212: )
213: RETURN BOOLEAN;
214: --

Line 211: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE

207: RETURN BOOLEAN;
208: --
209: FUNCTION Validate_Qchold_Res_Code
210: ( p_qchold_res_code IN ic_item_mst.qchold_res_code%TYPE
211: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
212: )
213: RETURN BOOLEAN;
214: --
215: FUNCTION Validate_Expaction_Code

Line 216: ( p_expaction_code IN ic_item_mst.expaction_code%TYPE

212: )
213: RETURN BOOLEAN;
214: --
215: FUNCTION Validate_Expaction_Code
216: ( p_expaction_code IN ic_item_mst.expaction_code%TYPE
217: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
218: )
219: RETURN BOOLEAN;
220: --

Line 217: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE

213: RETURN BOOLEAN;
214: --
215: FUNCTION Validate_Expaction_Code
216: ( p_expaction_code IN ic_item_mst.expaction_code%TYPE
217: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
218: )
219: RETURN BOOLEAN;
220: --
221: FUNCTION Validate_Expaction_Interval

Line 222: ( p_expaction_interval IN ic_item_mst.expaction_interval%TYPE

218: )
219: RETURN BOOLEAN;
220: --
221: FUNCTION Validate_Expaction_Interval
222: ( p_expaction_interval IN ic_item_mst.expaction_interval%TYPE
223: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
224: )
225: RETURN BOOLEAN;
226: --

Line 223: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE

219: RETURN BOOLEAN;
220: --
221: FUNCTION Validate_Expaction_Interval
222: ( p_expaction_interval IN ic_item_mst.expaction_interval%TYPE
223: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
224: )
225: RETURN BOOLEAN;
226: --
227: FUNCTION Validate_Experimental_Ind

Line 228: ( p_experimental_ind IN ic_item_mst.experimental_ind%TYPE

224: )
225: RETURN BOOLEAN;
226: --
227: FUNCTION Validate_Experimental_Ind
228: ( p_experimental_ind IN ic_item_mst.experimental_ind%TYPE
229: )
230: RETURN BOOLEAN;
231: --
232: FUNCTION Validate_Seq_Dpnd_Class

Line 233: ( p_seq_dpnd_class IN ic_item_mst.seq_dpnd_class%TYPE

229: )
230: RETURN BOOLEAN;
231: --
232: FUNCTION Validate_Seq_Dpnd_Class
233: ( p_seq_dpnd_class IN ic_item_mst.seq_dpnd_class%TYPE
234: )
235: RETURN BOOLEAN;
236: --
237: FUNCTION Validate_Commodity_Code

Line 238: ( p_commodity_code IN ic_item_mst.commodity_code%TYPE

234: )
235: RETURN BOOLEAN;
236: --
237: FUNCTION Validate_Commodity_Code
238: ( p_commodity_code IN ic_item_mst.commodity_code%TYPE
239: , p_sy$intrastat IN VARCHAR2
240: )
241: RETURN BOOLEAN;
242: --

Line 269: ( p_item_no IN ic_item_mst.item_no%TYPE

265: )
266: RETURN NUMBER;
267: --
268: FUNCTION Validate_Lot_No
269: ( p_item_no IN ic_item_mst.item_no%TYPE
270: , p_lot_no IN ic_lots_mst.lot_no%TYPE
271: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
272: )
273: RETURN BOOLEAN;

Line 276: ( p_item_loct_ctl IN ic_item_mst.loct_ctl%TYPE

272: )
273: RETURN BOOLEAN;
274: --
275: FUNCTION Validate_Location
276: ( p_item_loct_ctl IN ic_item_mst.loct_ctl%TYPE
277: , p_whse_loct_ctl IN ic_whse_mst.loct_ctl%TYPE
278: , p_whse_code IN ic_whse_mst.whse_code%TYPE
279: , p_location IN ic_loct_mst.location%TYPE
280: )

Line 284: ( p_item_no IN ic_item_mst.item_no%TYPE

280: )
281: RETURN BOOLEAN;
282: --
283: FUNCTION Validate_Item_Cnv
284: ( p_item_no IN ic_item_mst.item_no%TYPE
285: , p_lot_no IN ic_lots_mst.lot_no%TYPE
286: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
287: , p_um_type IN ic_item_cnv.um_type%TYPE
288: )