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_ITEM_PUB dependencies on IC_ITEM_MST

Line 28: --| written to ic_item_mst

24: --| 16-AUG-1999 Liz Enstone B965832(1) Several changes to fix |
25: --| problems with status_ctl |
26: --| 20/AUG/1999 H.Verdding Bug 951828 Change GMS package Calls to GMA |
27: --| 02/Mar/2000 Liz Enstone Bug 1222126 qc_grade,lot_status not being |
28: --| written to ic_item_mst
29: --| 13/Mar/2000 Liz Enstone Bug 1231196 Don't write records to ic_item_ |
30: --| cpg as CPG is not supported from 11.5 |
31: --| Fix has also got rid of superfluous debugging messages |
32: --| 23/Oct/2001 Joe DiIorio Bug 1989860 11.5.1H - Removed references to |

Line 89: l_item_id ic_item_mst.item_id%TYPE :=0;

85: l_msg_data VARCHAR2(2000);
86: l_return_status VARCHAR2(1);
87: l_qcitem_no VARCHAR2(32);
88: l_whse_item_no VARCHAR2(32);
89: l_item_id ic_item_mst.item_id%TYPE :=0;
90: l_item_no ic_item_mst.item_no%TYPE;
91: l_item_desc1 ic_item_mst.item_desc1%TYPE;
92: l_item_um ic_item_mst.item_um%TYPE;
93: l_item_um2 ic_item_mst.item_um2%TYPE;

Line 90: l_item_no ic_item_mst.item_no%TYPE;

86: l_return_status VARCHAR2(1);
87: l_qcitem_no VARCHAR2(32);
88: l_whse_item_no VARCHAR2(32);
89: l_item_id ic_item_mst.item_id%TYPE :=0;
90: l_item_no ic_item_mst.item_no%TYPE;
91: l_item_desc1 ic_item_mst.item_desc1%TYPE;
92: l_item_um ic_item_mst.item_um%TYPE;
93: l_item_um2 ic_item_mst.item_um2%TYPE;
94: l_qcitem_id ic_item_mst.qcitem_id%TYPE;

Line 91: l_item_desc1 ic_item_mst.item_desc1%TYPE;

87: l_qcitem_no VARCHAR2(32);
88: l_whse_item_no VARCHAR2(32);
89: l_item_id ic_item_mst.item_id%TYPE :=0;
90: l_item_no ic_item_mst.item_no%TYPE;
91: l_item_desc1 ic_item_mst.item_desc1%TYPE;
92: l_item_um ic_item_mst.item_um%TYPE;
93: l_item_um2 ic_item_mst.item_um2%TYPE;
94: l_qcitem_id ic_item_mst.qcitem_id%TYPE;
95: l_whse_item_id ic_item_mst.whse_item_id%TYPE;

Line 92: l_item_um ic_item_mst.item_um%TYPE;

88: l_whse_item_no VARCHAR2(32);
89: l_item_id ic_item_mst.item_id%TYPE :=0;
90: l_item_no ic_item_mst.item_no%TYPE;
91: l_item_desc1 ic_item_mst.item_desc1%TYPE;
92: l_item_um ic_item_mst.item_um%TYPE;
93: l_item_um2 ic_item_mst.item_um2%TYPE;
94: l_qcitem_id ic_item_mst.qcitem_id%TYPE;
95: l_whse_item_id ic_item_mst.whse_item_id%TYPE;
96: l_user_name fnd_user.user_name%TYPE;

Line 93: l_item_um2 ic_item_mst.item_um2%TYPE;

89: l_item_id ic_item_mst.item_id%TYPE :=0;
90: l_item_no ic_item_mst.item_no%TYPE;
91: l_item_desc1 ic_item_mst.item_desc1%TYPE;
92: l_item_um ic_item_mst.item_um%TYPE;
93: l_item_um2 ic_item_mst.item_um2%TYPE;
94: l_qcitem_id ic_item_mst.qcitem_id%TYPE;
95: l_whse_item_id ic_item_mst.whse_item_id%TYPE;
96: l_user_name fnd_user.user_name%TYPE;
97: l_user_id fnd_user.user_id%TYPE;

Line 94: l_qcitem_id ic_item_mst.qcitem_id%TYPE;

90: l_item_no ic_item_mst.item_no%TYPE;
91: l_item_desc1 ic_item_mst.item_desc1%TYPE;
92: l_item_um ic_item_mst.item_um%TYPE;
93: l_item_um2 ic_item_mst.item_um2%TYPE;
94: l_qcitem_id ic_item_mst.qcitem_id%TYPE;
95: l_whse_item_id ic_item_mst.whse_item_id%TYPE;
96: l_user_name fnd_user.user_name%TYPE;
97: l_user_id fnd_user.user_id%TYPE;
98: l_ic_item_mst_rec ic_item_mst%ROWTYPE;

Line 95: l_whse_item_id ic_item_mst.whse_item_id%TYPE;

91: l_item_desc1 ic_item_mst.item_desc1%TYPE;
92: l_item_um ic_item_mst.item_um%TYPE;
93: l_item_um2 ic_item_mst.item_um2%TYPE;
94: l_qcitem_id ic_item_mst.qcitem_id%TYPE;
95: l_whse_item_id ic_item_mst.whse_item_id%TYPE;
96: l_user_name fnd_user.user_name%TYPE;
97: l_user_id fnd_user.user_id%TYPE;
98: l_ic_item_mst_rec ic_item_mst%ROWTYPE;
99: l_ic_item_cpg_rec ic_item_cpg%ROWTYPE;

Line 98: l_ic_item_mst_rec ic_item_mst%ROWTYPE;

94: l_qcitem_id ic_item_mst.qcitem_id%TYPE;
95: l_whse_item_id ic_item_mst.whse_item_id%TYPE;
96: l_user_name fnd_user.user_name%TYPE;
97: l_user_id fnd_user.user_id%TYPE;
98: l_ic_item_mst_rec ic_item_mst%ROWTYPE;
99: l_ic_item_cpg_rec ic_item_cpg%ROWTYPE;
100: l_lot_rec GMI_LOTS_PUB.lot_rec_typ;
101: --B965832(1) Add the following variables
102: l_lot_status ic_item_mst.lot_status%TYPE;

Line 102: l_lot_status ic_item_mst.lot_status%TYPE;

98: l_ic_item_mst_rec ic_item_mst%ROWTYPE;
99: l_ic_item_cpg_rec ic_item_cpg%ROWTYPE;
100: l_lot_rec GMI_LOTS_PUB.lot_rec_typ;
101: --B965832(1) Add the following variables
102: l_lot_status ic_item_mst.lot_status%TYPE;
103: l_qc_grade ic_item_mst.qc_grade%TYPE;
104:
105: BEGIN
106:

Line 103: l_qc_grade ic_item_mst.qc_grade%TYPE;

99: l_ic_item_cpg_rec ic_item_cpg%ROWTYPE;
100: l_lot_rec GMI_LOTS_PUB.lot_rec_typ;
101: --B965832(1) Add the following variables
102: l_lot_status ic_item_mst.lot_status%TYPE;
103: l_qc_grade ic_item_mst.qc_grade%TYPE;
104:
105: BEGIN
106:
107: -- Standard Start OF API savepoint

Line 202: -- Set up PL/SQL record and insert item into ic_item_mst

198: THEN
199: l_whse_item_id := l_item_id;
200: END IF;
201:
202: -- Set up PL/SQL record and insert item into ic_item_mst
203:
204: l_ic_item_mst_rec.item_id := l_item_id;
205: l_ic_item_mst_rec.item_no := l_item_no;
206: l_ic_item_mst_rec.item_desc1 := p_item_rec.item_desc1;

Line 204: l_ic_item_mst_rec.item_id := l_item_id;

200: END IF;
201:
202: -- Set up PL/SQL record and insert item into ic_item_mst
203:
204: l_ic_item_mst_rec.item_id := l_item_id;
205: l_ic_item_mst_rec.item_no := l_item_no;
206: l_ic_item_mst_rec.item_desc1 := p_item_rec.item_desc1;
207: l_ic_item_mst_rec.item_desc2 := p_item_rec.item_desc2;
208: l_ic_item_mst_rec.alt_itema := UPPER(p_item_rec.alt_itema);

Line 205: l_ic_item_mst_rec.item_no := l_item_no;

201:
202: -- Set up PL/SQL record and insert item into ic_item_mst
203:
204: l_ic_item_mst_rec.item_id := l_item_id;
205: l_ic_item_mst_rec.item_no := l_item_no;
206: l_ic_item_mst_rec.item_desc1 := p_item_rec.item_desc1;
207: l_ic_item_mst_rec.item_desc2 := p_item_rec.item_desc2;
208: l_ic_item_mst_rec.alt_itema := UPPER(p_item_rec.alt_itema);
209: l_ic_item_mst_rec.alt_itemb := UPPER(p_item_rec.alt_itemb);

Line 206: l_ic_item_mst_rec.item_desc1 := p_item_rec.item_desc1;

202: -- Set up PL/SQL record and insert item into ic_item_mst
203:
204: l_ic_item_mst_rec.item_id := l_item_id;
205: l_ic_item_mst_rec.item_no := l_item_no;
206: l_ic_item_mst_rec.item_desc1 := p_item_rec.item_desc1;
207: l_ic_item_mst_rec.item_desc2 := p_item_rec.item_desc2;
208: l_ic_item_mst_rec.alt_itema := UPPER(p_item_rec.alt_itema);
209: l_ic_item_mst_rec.alt_itemb := UPPER(p_item_rec.alt_itemb);
210: l_ic_item_mst_rec.item_um := l_item_um;

Line 207: l_ic_item_mst_rec.item_desc2 := p_item_rec.item_desc2;

203:
204: l_ic_item_mst_rec.item_id := l_item_id;
205: l_ic_item_mst_rec.item_no := l_item_no;
206: l_ic_item_mst_rec.item_desc1 := p_item_rec.item_desc1;
207: l_ic_item_mst_rec.item_desc2 := p_item_rec.item_desc2;
208: l_ic_item_mst_rec.alt_itema := UPPER(p_item_rec.alt_itema);
209: l_ic_item_mst_rec.alt_itemb := UPPER(p_item_rec.alt_itemb);
210: l_ic_item_mst_rec.item_um := l_item_um;
211: l_ic_item_mst_rec.dualum_ind := p_item_rec.dualum_ind;

Line 208: l_ic_item_mst_rec.alt_itema := UPPER(p_item_rec.alt_itema);

204: l_ic_item_mst_rec.item_id := l_item_id;
205: l_ic_item_mst_rec.item_no := l_item_no;
206: l_ic_item_mst_rec.item_desc1 := p_item_rec.item_desc1;
207: l_ic_item_mst_rec.item_desc2 := p_item_rec.item_desc2;
208: l_ic_item_mst_rec.alt_itema := UPPER(p_item_rec.alt_itema);
209: l_ic_item_mst_rec.alt_itemb := UPPER(p_item_rec.alt_itemb);
210: l_ic_item_mst_rec.item_um := l_item_um;
211: l_ic_item_mst_rec.dualum_ind := p_item_rec.dualum_ind;
212: l_ic_item_mst_rec.item_um2 := l_item_um2;

Line 209: l_ic_item_mst_rec.alt_itemb := UPPER(p_item_rec.alt_itemb);

205: l_ic_item_mst_rec.item_no := l_item_no;
206: l_ic_item_mst_rec.item_desc1 := p_item_rec.item_desc1;
207: l_ic_item_mst_rec.item_desc2 := p_item_rec.item_desc2;
208: l_ic_item_mst_rec.alt_itema := UPPER(p_item_rec.alt_itema);
209: l_ic_item_mst_rec.alt_itemb := UPPER(p_item_rec.alt_itemb);
210: l_ic_item_mst_rec.item_um := l_item_um;
211: l_ic_item_mst_rec.dualum_ind := p_item_rec.dualum_ind;
212: l_ic_item_mst_rec.item_um2 := l_item_um2;
213: l_ic_item_mst_rec.deviation_lo := p_item_rec.deviation_lo;

Line 210: l_ic_item_mst_rec.item_um := l_item_um;

206: l_ic_item_mst_rec.item_desc1 := p_item_rec.item_desc1;
207: l_ic_item_mst_rec.item_desc2 := p_item_rec.item_desc2;
208: l_ic_item_mst_rec.alt_itema := UPPER(p_item_rec.alt_itema);
209: l_ic_item_mst_rec.alt_itemb := UPPER(p_item_rec.alt_itemb);
210: l_ic_item_mst_rec.item_um := l_item_um;
211: l_ic_item_mst_rec.dualum_ind := p_item_rec.dualum_ind;
212: l_ic_item_mst_rec.item_um2 := l_item_um2;
213: l_ic_item_mst_rec.deviation_lo := p_item_rec.deviation_lo;
214: l_ic_item_mst_rec.deviation_hi := p_item_rec.deviation_hi;

Line 211: l_ic_item_mst_rec.dualum_ind := p_item_rec.dualum_ind;

207: l_ic_item_mst_rec.item_desc2 := p_item_rec.item_desc2;
208: l_ic_item_mst_rec.alt_itema := UPPER(p_item_rec.alt_itema);
209: l_ic_item_mst_rec.alt_itemb := UPPER(p_item_rec.alt_itemb);
210: l_ic_item_mst_rec.item_um := l_item_um;
211: l_ic_item_mst_rec.dualum_ind := p_item_rec.dualum_ind;
212: l_ic_item_mst_rec.item_um2 := l_item_um2;
213: l_ic_item_mst_rec.deviation_lo := p_item_rec.deviation_lo;
214: l_ic_item_mst_rec.deviation_hi := p_item_rec.deviation_hi;
215: l_ic_item_mst_rec.level_code := p_item_rec.level_code;

Line 212: l_ic_item_mst_rec.item_um2 := l_item_um2;

208: l_ic_item_mst_rec.alt_itema := UPPER(p_item_rec.alt_itema);
209: l_ic_item_mst_rec.alt_itemb := UPPER(p_item_rec.alt_itemb);
210: l_ic_item_mst_rec.item_um := l_item_um;
211: l_ic_item_mst_rec.dualum_ind := p_item_rec.dualum_ind;
212: l_ic_item_mst_rec.item_um2 := l_item_um2;
213: l_ic_item_mst_rec.deviation_lo := p_item_rec.deviation_lo;
214: l_ic_item_mst_rec.deviation_hi := p_item_rec.deviation_hi;
215: l_ic_item_mst_rec.level_code := p_item_rec.level_code;
216: l_ic_item_mst_rec.lot_ctl := p_item_rec.lot_ctl;

Line 213: l_ic_item_mst_rec.deviation_lo := p_item_rec.deviation_lo;

209: l_ic_item_mst_rec.alt_itemb := UPPER(p_item_rec.alt_itemb);
210: l_ic_item_mst_rec.item_um := l_item_um;
211: l_ic_item_mst_rec.dualum_ind := p_item_rec.dualum_ind;
212: l_ic_item_mst_rec.item_um2 := l_item_um2;
213: l_ic_item_mst_rec.deviation_lo := p_item_rec.deviation_lo;
214: l_ic_item_mst_rec.deviation_hi := p_item_rec.deviation_hi;
215: l_ic_item_mst_rec.level_code := p_item_rec.level_code;
216: l_ic_item_mst_rec.lot_ctl := p_item_rec.lot_ctl;
217: l_ic_item_mst_rec.lot_indivisible := p_item_rec.lot_indivisible;

Line 214: l_ic_item_mst_rec.deviation_hi := p_item_rec.deviation_hi;

210: l_ic_item_mst_rec.item_um := l_item_um;
211: l_ic_item_mst_rec.dualum_ind := p_item_rec.dualum_ind;
212: l_ic_item_mst_rec.item_um2 := l_item_um2;
213: l_ic_item_mst_rec.deviation_lo := p_item_rec.deviation_lo;
214: l_ic_item_mst_rec.deviation_hi := p_item_rec.deviation_hi;
215: l_ic_item_mst_rec.level_code := p_item_rec.level_code;
216: l_ic_item_mst_rec.lot_ctl := p_item_rec.lot_ctl;
217: l_ic_item_mst_rec.lot_indivisible := p_item_rec.lot_indivisible;
218: l_ic_item_mst_rec.sublot_ctl := p_item_rec.sublot_ctl;

Line 215: l_ic_item_mst_rec.level_code := p_item_rec.level_code;

211: l_ic_item_mst_rec.dualum_ind := p_item_rec.dualum_ind;
212: l_ic_item_mst_rec.item_um2 := l_item_um2;
213: l_ic_item_mst_rec.deviation_lo := p_item_rec.deviation_lo;
214: l_ic_item_mst_rec.deviation_hi := p_item_rec.deviation_hi;
215: l_ic_item_mst_rec.level_code := p_item_rec.level_code;
216: l_ic_item_mst_rec.lot_ctl := p_item_rec.lot_ctl;
217: l_ic_item_mst_rec.lot_indivisible := p_item_rec.lot_indivisible;
218: l_ic_item_mst_rec.sublot_ctl := p_item_rec.sublot_ctl;
219: l_ic_item_mst_rec.loct_ctl := p_item_rec.loct_ctl;

Line 216: l_ic_item_mst_rec.lot_ctl := p_item_rec.lot_ctl;

212: l_ic_item_mst_rec.item_um2 := l_item_um2;
213: l_ic_item_mst_rec.deviation_lo := p_item_rec.deviation_lo;
214: l_ic_item_mst_rec.deviation_hi := p_item_rec.deviation_hi;
215: l_ic_item_mst_rec.level_code := p_item_rec.level_code;
216: l_ic_item_mst_rec.lot_ctl := p_item_rec.lot_ctl;
217: l_ic_item_mst_rec.lot_indivisible := p_item_rec.lot_indivisible;
218: l_ic_item_mst_rec.sublot_ctl := p_item_rec.sublot_ctl;
219: l_ic_item_mst_rec.loct_ctl := p_item_rec.loct_ctl;
220: l_ic_item_mst_rec.noninv_ind := p_item_rec.noninv_ind;

Line 217: l_ic_item_mst_rec.lot_indivisible := p_item_rec.lot_indivisible;

213: l_ic_item_mst_rec.deviation_lo := p_item_rec.deviation_lo;
214: l_ic_item_mst_rec.deviation_hi := p_item_rec.deviation_hi;
215: l_ic_item_mst_rec.level_code := p_item_rec.level_code;
216: l_ic_item_mst_rec.lot_ctl := p_item_rec.lot_ctl;
217: l_ic_item_mst_rec.lot_indivisible := p_item_rec.lot_indivisible;
218: l_ic_item_mst_rec.sublot_ctl := p_item_rec.sublot_ctl;
219: l_ic_item_mst_rec.loct_ctl := p_item_rec.loct_ctl;
220: l_ic_item_mst_rec.noninv_ind := p_item_rec.noninv_ind;
221: l_ic_item_mst_rec.match_type := p_item_rec.match_type;

Line 218: l_ic_item_mst_rec.sublot_ctl := p_item_rec.sublot_ctl;

214: l_ic_item_mst_rec.deviation_hi := p_item_rec.deviation_hi;
215: l_ic_item_mst_rec.level_code := p_item_rec.level_code;
216: l_ic_item_mst_rec.lot_ctl := p_item_rec.lot_ctl;
217: l_ic_item_mst_rec.lot_indivisible := p_item_rec.lot_indivisible;
218: l_ic_item_mst_rec.sublot_ctl := p_item_rec.sublot_ctl;
219: l_ic_item_mst_rec.loct_ctl := p_item_rec.loct_ctl;
220: l_ic_item_mst_rec.noninv_ind := p_item_rec.noninv_ind;
221: l_ic_item_mst_rec.match_type := p_item_rec.match_type;
222: l_ic_item_mst_rec.inactive_ind := p_item_rec.inactive_ind;

Line 219: l_ic_item_mst_rec.loct_ctl := p_item_rec.loct_ctl;

215: l_ic_item_mst_rec.level_code := p_item_rec.level_code;
216: l_ic_item_mst_rec.lot_ctl := p_item_rec.lot_ctl;
217: l_ic_item_mst_rec.lot_indivisible := p_item_rec.lot_indivisible;
218: l_ic_item_mst_rec.sublot_ctl := p_item_rec.sublot_ctl;
219: l_ic_item_mst_rec.loct_ctl := p_item_rec.loct_ctl;
220: l_ic_item_mst_rec.noninv_ind := p_item_rec.noninv_ind;
221: l_ic_item_mst_rec.match_type := p_item_rec.match_type;
222: l_ic_item_mst_rec.inactive_ind := p_item_rec.inactive_ind;
223: l_ic_item_mst_rec.inv_type := p_item_rec.inv_type;

Line 220: l_ic_item_mst_rec.noninv_ind := p_item_rec.noninv_ind;

216: l_ic_item_mst_rec.lot_ctl := p_item_rec.lot_ctl;
217: l_ic_item_mst_rec.lot_indivisible := p_item_rec.lot_indivisible;
218: l_ic_item_mst_rec.sublot_ctl := p_item_rec.sublot_ctl;
219: l_ic_item_mst_rec.loct_ctl := p_item_rec.loct_ctl;
220: l_ic_item_mst_rec.noninv_ind := p_item_rec.noninv_ind;
221: l_ic_item_mst_rec.match_type := p_item_rec.match_type;
222: l_ic_item_mst_rec.inactive_ind := p_item_rec.inactive_ind;
223: l_ic_item_mst_rec.inv_type := p_item_rec.inv_type;
224: l_ic_item_mst_rec.shelf_life := p_item_rec.shelf_life;

Line 221: l_ic_item_mst_rec.match_type := p_item_rec.match_type;

217: l_ic_item_mst_rec.lot_indivisible := p_item_rec.lot_indivisible;
218: l_ic_item_mst_rec.sublot_ctl := p_item_rec.sublot_ctl;
219: l_ic_item_mst_rec.loct_ctl := p_item_rec.loct_ctl;
220: l_ic_item_mst_rec.noninv_ind := p_item_rec.noninv_ind;
221: l_ic_item_mst_rec.match_type := p_item_rec.match_type;
222: l_ic_item_mst_rec.inactive_ind := p_item_rec.inactive_ind;
223: l_ic_item_mst_rec.inv_type := p_item_rec.inv_type;
224: l_ic_item_mst_rec.shelf_life := p_item_rec.shelf_life;
225: l_ic_item_mst_rec.retest_interval := p_item_rec.retest_interval;

Line 222: l_ic_item_mst_rec.inactive_ind := p_item_rec.inactive_ind;

218: l_ic_item_mst_rec.sublot_ctl := p_item_rec.sublot_ctl;
219: l_ic_item_mst_rec.loct_ctl := p_item_rec.loct_ctl;
220: l_ic_item_mst_rec.noninv_ind := p_item_rec.noninv_ind;
221: l_ic_item_mst_rec.match_type := p_item_rec.match_type;
222: l_ic_item_mst_rec.inactive_ind := p_item_rec.inactive_ind;
223: l_ic_item_mst_rec.inv_type := p_item_rec.inv_type;
224: l_ic_item_mst_rec.shelf_life := p_item_rec.shelf_life;
225: l_ic_item_mst_rec.retest_interval := p_item_rec.retest_interval;
226: l_ic_item_mst_rec.item_abccode := UPPER(p_item_rec.item_abccode);

Line 223: l_ic_item_mst_rec.inv_type := p_item_rec.inv_type;

219: l_ic_item_mst_rec.loct_ctl := p_item_rec.loct_ctl;
220: l_ic_item_mst_rec.noninv_ind := p_item_rec.noninv_ind;
221: l_ic_item_mst_rec.match_type := p_item_rec.match_type;
222: l_ic_item_mst_rec.inactive_ind := p_item_rec.inactive_ind;
223: l_ic_item_mst_rec.inv_type := p_item_rec.inv_type;
224: l_ic_item_mst_rec.shelf_life := p_item_rec.shelf_life;
225: l_ic_item_mst_rec.retest_interval := p_item_rec.retest_interval;
226: l_ic_item_mst_rec.item_abccode := UPPER(p_item_rec.item_abccode);
227: l_ic_item_mst_rec.gl_class := UPPER(p_item_rec.gl_class);

Line 224: l_ic_item_mst_rec.shelf_life := p_item_rec.shelf_life;

220: l_ic_item_mst_rec.noninv_ind := p_item_rec.noninv_ind;
221: l_ic_item_mst_rec.match_type := p_item_rec.match_type;
222: l_ic_item_mst_rec.inactive_ind := p_item_rec.inactive_ind;
223: l_ic_item_mst_rec.inv_type := p_item_rec.inv_type;
224: l_ic_item_mst_rec.shelf_life := p_item_rec.shelf_life;
225: l_ic_item_mst_rec.retest_interval := p_item_rec.retest_interval;
226: l_ic_item_mst_rec.item_abccode := UPPER(p_item_rec.item_abccode);
227: l_ic_item_mst_rec.gl_class := UPPER(p_item_rec.gl_class);
228: l_ic_item_mst_rec.inv_class := UPPER(p_item_rec.inv_class);

Line 225: l_ic_item_mst_rec.retest_interval := p_item_rec.retest_interval;

221: l_ic_item_mst_rec.match_type := p_item_rec.match_type;
222: l_ic_item_mst_rec.inactive_ind := p_item_rec.inactive_ind;
223: l_ic_item_mst_rec.inv_type := p_item_rec.inv_type;
224: l_ic_item_mst_rec.shelf_life := p_item_rec.shelf_life;
225: l_ic_item_mst_rec.retest_interval := p_item_rec.retest_interval;
226: l_ic_item_mst_rec.item_abccode := UPPER(p_item_rec.item_abccode);
227: l_ic_item_mst_rec.gl_class := UPPER(p_item_rec.gl_class);
228: l_ic_item_mst_rec.inv_class := UPPER(p_item_rec.inv_class);
229: l_ic_item_mst_rec.sales_class := UPPER(p_item_rec.sales_class);

Line 226: l_ic_item_mst_rec.item_abccode := UPPER(p_item_rec.item_abccode);

222: l_ic_item_mst_rec.inactive_ind := p_item_rec.inactive_ind;
223: l_ic_item_mst_rec.inv_type := p_item_rec.inv_type;
224: l_ic_item_mst_rec.shelf_life := p_item_rec.shelf_life;
225: l_ic_item_mst_rec.retest_interval := p_item_rec.retest_interval;
226: l_ic_item_mst_rec.item_abccode := UPPER(p_item_rec.item_abccode);
227: l_ic_item_mst_rec.gl_class := UPPER(p_item_rec.gl_class);
228: l_ic_item_mst_rec.inv_class := UPPER(p_item_rec.inv_class);
229: l_ic_item_mst_rec.sales_class := UPPER(p_item_rec.sales_class);
230: l_ic_item_mst_rec.ship_class := UPPER(p_item_rec.ship_class);

Line 227: l_ic_item_mst_rec.gl_class := UPPER(p_item_rec.gl_class);

223: l_ic_item_mst_rec.inv_type := p_item_rec.inv_type;
224: l_ic_item_mst_rec.shelf_life := p_item_rec.shelf_life;
225: l_ic_item_mst_rec.retest_interval := p_item_rec.retest_interval;
226: l_ic_item_mst_rec.item_abccode := UPPER(p_item_rec.item_abccode);
227: l_ic_item_mst_rec.gl_class := UPPER(p_item_rec.gl_class);
228: l_ic_item_mst_rec.inv_class := UPPER(p_item_rec.inv_class);
229: l_ic_item_mst_rec.sales_class := UPPER(p_item_rec.sales_class);
230: l_ic_item_mst_rec.ship_class := UPPER(p_item_rec.ship_class);
231: l_ic_item_mst_rec.frt_class := UPPER(p_item_rec.frt_class);

Line 228: l_ic_item_mst_rec.inv_class := UPPER(p_item_rec.inv_class);

224: l_ic_item_mst_rec.shelf_life := p_item_rec.shelf_life;
225: l_ic_item_mst_rec.retest_interval := p_item_rec.retest_interval;
226: l_ic_item_mst_rec.item_abccode := UPPER(p_item_rec.item_abccode);
227: l_ic_item_mst_rec.gl_class := UPPER(p_item_rec.gl_class);
228: l_ic_item_mst_rec.inv_class := UPPER(p_item_rec.inv_class);
229: l_ic_item_mst_rec.sales_class := UPPER(p_item_rec.sales_class);
230: l_ic_item_mst_rec.ship_class := UPPER(p_item_rec.ship_class);
231: l_ic_item_mst_rec.frt_class := UPPER(p_item_rec.frt_class);
232: l_ic_item_mst_rec.price_class := UPPER(p_item_rec.price_class);

Line 229: l_ic_item_mst_rec.sales_class := UPPER(p_item_rec.sales_class);

225: l_ic_item_mst_rec.retest_interval := p_item_rec.retest_interval;
226: l_ic_item_mst_rec.item_abccode := UPPER(p_item_rec.item_abccode);
227: l_ic_item_mst_rec.gl_class := UPPER(p_item_rec.gl_class);
228: l_ic_item_mst_rec.inv_class := UPPER(p_item_rec.inv_class);
229: l_ic_item_mst_rec.sales_class := UPPER(p_item_rec.sales_class);
230: l_ic_item_mst_rec.ship_class := UPPER(p_item_rec.ship_class);
231: l_ic_item_mst_rec.frt_class := UPPER(p_item_rec.frt_class);
232: l_ic_item_mst_rec.price_class := UPPER(p_item_rec.price_class);
233: l_ic_item_mst_rec.storage_class := UPPER(p_item_rec.storage_class);

Line 230: l_ic_item_mst_rec.ship_class := UPPER(p_item_rec.ship_class);

226: l_ic_item_mst_rec.item_abccode := UPPER(p_item_rec.item_abccode);
227: l_ic_item_mst_rec.gl_class := UPPER(p_item_rec.gl_class);
228: l_ic_item_mst_rec.inv_class := UPPER(p_item_rec.inv_class);
229: l_ic_item_mst_rec.sales_class := UPPER(p_item_rec.sales_class);
230: l_ic_item_mst_rec.ship_class := UPPER(p_item_rec.ship_class);
231: l_ic_item_mst_rec.frt_class := UPPER(p_item_rec.frt_class);
232: l_ic_item_mst_rec.price_class := UPPER(p_item_rec.price_class);
233: l_ic_item_mst_rec.storage_class := UPPER(p_item_rec.storage_class);
234: l_ic_item_mst_rec.purch_class := UPPER(p_item_rec.purch_class);

Line 231: l_ic_item_mst_rec.frt_class := UPPER(p_item_rec.frt_class);

227: l_ic_item_mst_rec.gl_class := UPPER(p_item_rec.gl_class);
228: l_ic_item_mst_rec.inv_class := UPPER(p_item_rec.inv_class);
229: l_ic_item_mst_rec.sales_class := UPPER(p_item_rec.sales_class);
230: l_ic_item_mst_rec.ship_class := UPPER(p_item_rec.ship_class);
231: l_ic_item_mst_rec.frt_class := UPPER(p_item_rec.frt_class);
232: l_ic_item_mst_rec.price_class := UPPER(p_item_rec.price_class);
233: l_ic_item_mst_rec.storage_class := UPPER(p_item_rec.storage_class);
234: l_ic_item_mst_rec.purch_class := UPPER(p_item_rec.purch_class);
235: l_ic_item_mst_rec.tax_class := UPPER(p_item_rec.tax_class);

Line 232: l_ic_item_mst_rec.price_class := UPPER(p_item_rec.price_class);

228: l_ic_item_mst_rec.inv_class := UPPER(p_item_rec.inv_class);
229: l_ic_item_mst_rec.sales_class := UPPER(p_item_rec.sales_class);
230: l_ic_item_mst_rec.ship_class := UPPER(p_item_rec.ship_class);
231: l_ic_item_mst_rec.frt_class := UPPER(p_item_rec.frt_class);
232: l_ic_item_mst_rec.price_class := UPPER(p_item_rec.price_class);
233: l_ic_item_mst_rec.storage_class := UPPER(p_item_rec.storage_class);
234: l_ic_item_mst_rec.purch_class := UPPER(p_item_rec.purch_class);
235: l_ic_item_mst_rec.tax_class := UPPER(p_item_rec.tax_class);
236: l_ic_item_mst_rec.customs_class := UPPER(p_item_rec.customs_class);

Line 233: l_ic_item_mst_rec.storage_class := UPPER(p_item_rec.storage_class);

229: l_ic_item_mst_rec.sales_class := UPPER(p_item_rec.sales_class);
230: l_ic_item_mst_rec.ship_class := UPPER(p_item_rec.ship_class);
231: l_ic_item_mst_rec.frt_class := UPPER(p_item_rec.frt_class);
232: l_ic_item_mst_rec.price_class := UPPER(p_item_rec.price_class);
233: l_ic_item_mst_rec.storage_class := UPPER(p_item_rec.storage_class);
234: l_ic_item_mst_rec.purch_class := UPPER(p_item_rec.purch_class);
235: l_ic_item_mst_rec.tax_class := UPPER(p_item_rec.tax_class);
236: l_ic_item_mst_rec.customs_class := UPPER(p_item_rec.customs_class);
237: l_ic_item_mst_rec.alloc_class := UPPER(p_item_rec.alloc_class);

Line 234: l_ic_item_mst_rec.purch_class := UPPER(p_item_rec.purch_class);

230: l_ic_item_mst_rec.ship_class := UPPER(p_item_rec.ship_class);
231: l_ic_item_mst_rec.frt_class := UPPER(p_item_rec.frt_class);
232: l_ic_item_mst_rec.price_class := UPPER(p_item_rec.price_class);
233: l_ic_item_mst_rec.storage_class := UPPER(p_item_rec.storage_class);
234: l_ic_item_mst_rec.purch_class := UPPER(p_item_rec.purch_class);
235: l_ic_item_mst_rec.tax_class := UPPER(p_item_rec.tax_class);
236: l_ic_item_mst_rec.customs_class := UPPER(p_item_rec.customs_class);
237: l_ic_item_mst_rec.alloc_class := UPPER(p_item_rec.alloc_class);
238: l_ic_item_mst_rec.planning_class := UPPER(p_item_rec.planning_class);

Line 235: l_ic_item_mst_rec.tax_class := UPPER(p_item_rec.tax_class);

231: l_ic_item_mst_rec.frt_class := UPPER(p_item_rec.frt_class);
232: l_ic_item_mst_rec.price_class := UPPER(p_item_rec.price_class);
233: l_ic_item_mst_rec.storage_class := UPPER(p_item_rec.storage_class);
234: l_ic_item_mst_rec.purch_class := UPPER(p_item_rec.purch_class);
235: l_ic_item_mst_rec.tax_class := UPPER(p_item_rec.tax_class);
236: l_ic_item_mst_rec.customs_class := UPPER(p_item_rec.customs_class);
237: l_ic_item_mst_rec.alloc_class := UPPER(p_item_rec.alloc_class);
238: l_ic_item_mst_rec.planning_class := UPPER(p_item_rec.planning_class);
239: l_ic_item_mst_rec.itemcost_class := UPPER(p_item_rec.itemcost_class);

Line 236: l_ic_item_mst_rec.customs_class := UPPER(p_item_rec.customs_class);

232: l_ic_item_mst_rec.price_class := UPPER(p_item_rec.price_class);
233: l_ic_item_mst_rec.storage_class := UPPER(p_item_rec.storage_class);
234: l_ic_item_mst_rec.purch_class := UPPER(p_item_rec.purch_class);
235: l_ic_item_mst_rec.tax_class := UPPER(p_item_rec.tax_class);
236: l_ic_item_mst_rec.customs_class := UPPER(p_item_rec.customs_class);
237: l_ic_item_mst_rec.alloc_class := UPPER(p_item_rec.alloc_class);
238: l_ic_item_mst_rec.planning_class := UPPER(p_item_rec.planning_class);
239: l_ic_item_mst_rec.itemcost_class := UPPER(p_item_rec.itemcost_class);
240: l_ic_item_mst_rec.cost_mthd_code := UPPER(p_item_rec.cost_mthd_code);

Line 237: l_ic_item_mst_rec.alloc_class := UPPER(p_item_rec.alloc_class);

233: l_ic_item_mst_rec.storage_class := UPPER(p_item_rec.storage_class);
234: l_ic_item_mst_rec.purch_class := UPPER(p_item_rec.purch_class);
235: l_ic_item_mst_rec.tax_class := UPPER(p_item_rec.tax_class);
236: l_ic_item_mst_rec.customs_class := UPPER(p_item_rec.customs_class);
237: l_ic_item_mst_rec.alloc_class := UPPER(p_item_rec.alloc_class);
238: l_ic_item_mst_rec.planning_class := UPPER(p_item_rec.planning_class);
239: l_ic_item_mst_rec.itemcost_class := UPPER(p_item_rec.itemcost_class);
240: l_ic_item_mst_rec.cost_mthd_code := UPPER(p_item_rec.cost_mthd_code);
241: l_ic_item_mst_rec.upc_code := p_item_rec.upc_code;

Line 238: l_ic_item_mst_rec.planning_class := UPPER(p_item_rec.planning_class);

234: l_ic_item_mst_rec.purch_class := UPPER(p_item_rec.purch_class);
235: l_ic_item_mst_rec.tax_class := UPPER(p_item_rec.tax_class);
236: l_ic_item_mst_rec.customs_class := UPPER(p_item_rec.customs_class);
237: l_ic_item_mst_rec.alloc_class := UPPER(p_item_rec.alloc_class);
238: l_ic_item_mst_rec.planning_class := UPPER(p_item_rec.planning_class);
239: l_ic_item_mst_rec.itemcost_class := UPPER(p_item_rec.itemcost_class);
240: l_ic_item_mst_rec.cost_mthd_code := UPPER(p_item_rec.cost_mthd_code);
241: l_ic_item_mst_rec.upc_code := p_item_rec.upc_code;
242: l_ic_item_mst_rec.grade_ctl := p_item_rec.grade_ctl;

Line 239: l_ic_item_mst_rec.itemcost_class := UPPER(p_item_rec.itemcost_class);

235: l_ic_item_mst_rec.tax_class := UPPER(p_item_rec.tax_class);
236: l_ic_item_mst_rec.customs_class := UPPER(p_item_rec.customs_class);
237: l_ic_item_mst_rec.alloc_class := UPPER(p_item_rec.alloc_class);
238: l_ic_item_mst_rec.planning_class := UPPER(p_item_rec.planning_class);
239: l_ic_item_mst_rec.itemcost_class := UPPER(p_item_rec.itemcost_class);
240: l_ic_item_mst_rec.cost_mthd_code := UPPER(p_item_rec.cost_mthd_code);
241: l_ic_item_mst_rec.upc_code := p_item_rec.upc_code;
242: l_ic_item_mst_rec.grade_ctl := p_item_rec.grade_ctl;
243: l_ic_item_mst_rec.status_ctl := p_item_rec.status_ctl;

Line 240: l_ic_item_mst_rec.cost_mthd_code := UPPER(p_item_rec.cost_mthd_code);

236: l_ic_item_mst_rec.customs_class := UPPER(p_item_rec.customs_class);
237: l_ic_item_mst_rec.alloc_class := UPPER(p_item_rec.alloc_class);
238: l_ic_item_mst_rec.planning_class := UPPER(p_item_rec.planning_class);
239: l_ic_item_mst_rec.itemcost_class := UPPER(p_item_rec.itemcost_class);
240: l_ic_item_mst_rec.cost_mthd_code := UPPER(p_item_rec.cost_mthd_code);
241: l_ic_item_mst_rec.upc_code := p_item_rec.upc_code;
242: l_ic_item_mst_rec.grade_ctl := p_item_rec.grade_ctl;
243: l_ic_item_mst_rec.status_ctl := p_item_rec.status_ctl;
244: --B965832(1) Comment these 2 variables out here

Line 241: l_ic_item_mst_rec.upc_code := p_item_rec.upc_code;

237: l_ic_item_mst_rec.alloc_class := UPPER(p_item_rec.alloc_class);
238: l_ic_item_mst_rec.planning_class := UPPER(p_item_rec.planning_class);
239: l_ic_item_mst_rec.itemcost_class := UPPER(p_item_rec.itemcost_class);
240: l_ic_item_mst_rec.cost_mthd_code := UPPER(p_item_rec.cost_mthd_code);
241: l_ic_item_mst_rec.upc_code := p_item_rec.upc_code;
242: l_ic_item_mst_rec.grade_ctl := p_item_rec.grade_ctl;
243: l_ic_item_mst_rec.status_ctl := p_item_rec.status_ctl;
244: --B965832(1) Comment these 2 variables out here
245: --B1222126 Restore these 2 lines. qc_grade and lot_status are not being

Line 242: l_ic_item_mst_rec.grade_ctl := p_item_rec.grade_ctl;

238: l_ic_item_mst_rec.planning_class := UPPER(p_item_rec.planning_class);
239: l_ic_item_mst_rec.itemcost_class := UPPER(p_item_rec.itemcost_class);
240: l_ic_item_mst_rec.cost_mthd_code := UPPER(p_item_rec.cost_mthd_code);
241: l_ic_item_mst_rec.upc_code := p_item_rec.upc_code;
242: l_ic_item_mst_rec.grade_ctl := p_item_rec.grade_ctl;
243: l_ic_item_mst_rec.status_ctl := p_item_rec.status_ctl;
244: --B965832(1) Comment these 2 variables out here
245: --B1222126 Restore these 2 lines. qc_grade and lot_status are not being
246: --saved

Line 243: l_ic_item_mst_rec.status_ctl := p_item_rec.status_ctl;

239: l_ic_item_mst_rec.itemcost_class := UPPER(p_item_rec.itemcost_class);
240: l_ic_item_mst_rec.cost_mthd_code := UPPER(p_item_rec.cost_mthd_code);
241: l_ic_item_mst_rec.upc_code := p_item_rec.upc_code;
242: l_ic_item_mst_rec.grade_ctl := p_item_rec.grade_ctl;
243: l_ic_item_mst_rec.status_ctl := p_item_rec.status_ctl;
244: --B965832(1) Comment these 2 variables out here
245: --B1222126 Restore these 2 lines. qc_grade and lot_status are not being
246: --saved
247: l_ic_item_mst_rec.qc_grade := UPPER(p_item_rec.qc_grade);

Line 247: l_ic_item_mst_rec.qc_grade := UPPER(p_item_rec.qc_grade);

243: l_ic_item_mst_rec.status_ctl := p_item_rec.status_ctl;
244: --B965832(1) Comment these 2 variables out here
245: --B1222126 Restore these 2 lines. qc_grade and lot_status are not being
246: --saved
247: l_ic_item_mst_rec.qc_grade := UPPER(p_item_rec.qc_grade);
248: l_ic_item_mst_rec.lot_status := UPPER(p_item_rec.lot_status);
249: l_ic_item_mst_rec.bulk_id := p_item_rec.bulk_id;
250: l_ic_item_mst_rec.pkg_id := p_item_rec.pkg_id;
251: l_ic_item_mst_rec.qcitem_id := l_qcitem_id;

Line 248: l_ic_item_mst_rec.lot_status := UPPER(p_item_rec.lot_status);

244: --B965832(1) Comment these 2 variables out here
245: --B1222126 Restore these 2 lines. qc_grade and lot_status are not being
246: --saved
247: l_ic_item_mst_rec.qc_grade := UPPER(p_item_rec.qc_grade);
248: l_ic_item_mst_rec.lot_status := UPPER(p_item_rec.lot_status);
249: l_ic_item_mst_rec.bulk_id := p_item_rec.bulk_id;
250: l_ic_item_mst_rec.pkg_id := p_item_rec.pkg_id;
251: l_ic_item_mst_rec.qcitem_id := l_qcitem_id;
252: l_ic_item_mst_rec.qchold_res_code := UPPER(p_item_rec.qchold_res_code);

Line 249: l_ic_item_mst_rec.bulk_id := p_item_rec.bulk_id;

245: --B1222126 Restore these 2 lines. qc_grade and lot_status are not being
246: --saved
247: l_ic_item_mst_rec.qc_grade := UPPER(p_item_rec.qc_grade);
248: l_ic_item_mst_rec.lot_status := UPPER(p_item_rec.lot_status);
249: l_ic_item_mst_rec.bulk_id := p_item_rec.bulk_id;
250: l_ic_item_mst_rec.pkg_id := p_item_rec.pkg_id;
251: l_ic_item_mst_rec.qcitem_id := l_qcitem_id;
252: l_ic_item_mst_rec.qchold_res_code := UPPER(p_item_rec.qchold_res_code);
253: l_ic_item_mst_rec.expaction_code := UPPER(p_item_rec.expaction_code);

Line 250: l_ic_item_mst_rec.pkg_id := p_item_rec.pkg_id;

246: --saved
247: l_ic_item_mst_rec.qc_grade := UPPER(p_item_rec.qc_grade);
248: l_ic_item_mst_rec.lot_status := UPPER(p_item_rec.lot_status);
249: l_ic_item_mst_rec.bulk_id := p_item_rec.bulk_id;
250: l_ic_item_mst_rec.pkg_id := p_item_rec.pkg_id;
251: l_ic_item_mst_rec.qcitem_id := l_qcitem_id;
252: l_ic_item_mst_rec.qchold_res_code := UPPER(p_item_rec.qchold_res_code);
253: l_ic_item_mst_rec.expaction_code := UPPER(p_item_rec.expaction_code);
254: l_ic_item_mst_rec.fill_qty := p_item_rec.fill_qty;

Line 251: l_ic_item_mst_rec.qcitem_id := l_qcitem_id;

247: l_ic_item_mst_rec.qc_grade := UPPER(p_item_rec.qc_grade);
248: l_ic_item_mst_rec.lot_status := UPPER(p_item_rec.lot_status);
249: l_ic_item_mst_rec.bulk_id := p_item_rec.bulk_id;
250: l_ic_item_mst_rec.pkg_id := p_item_rec.pkg_id;
251: l_ic_item_mst_rec.qcitem_id := l_qcitem_id;
252: l_ic_item_mst_rec.qchold_res_code := UPPER(p_item_rec.qchold_res_code);
253: l_ic_item_mst_rec.expaction_code := UPPER(p_item_rec.expaction_code);
254: l_ic_item_mst_rec.fill_qty := p_item_rec.fill_qty;
255: l_ic_item_mst_rec.fill_um := p_item_rec.fill_um;

Line 252: l_ic_item_mst_rec.qchold_res_code := UPPER(p_item_rec.qchold_res_code);

248: l_ic_item_mst_rec.lot_status := UPPER(p_item_rec.lot_status);
249: l_ic_item_mst_rec.bulk_id := p_item_rec.bulk_id;
250: l_ic_item_mst_rec.pkg_id := p_item_rec.pkg_id;
251: l_ic_item_mst_rec.qcitem_id := l_qcitem_id;
252: l_ic_item_mst_rec.qchold_res_code := UPPER(p_item_rec.qchold_res_code);
253: l_ic_item_mst_rec.expaction_code := UPPER(p_item_rec.expaction_code);
254: l_ic_item_mst_rec.fill_qty := p_item_rec.fill_qty;
255: l_ic_item_mst_rec.fill_um := p_item_rec.fill_um;
256: l_ic_item_mst_rec.expaction_interval := p_item_rec.expaction_interval;

Line 253: l_ic_item_mst_rec.expaction_code := UPPER(p_item_rec.expaction_code);

249: l_ic_item_mst_rec.bulk_id := p_item_rec.bulk_id;
250: l_ic_item_mst_rec.pkg_id := p_item_rec.pkg_id;
251: l_ic_item_mst_rec.qcitem_id := l_qcitem_id;
252: l_ic_item_mst_rec.qchold_res_code := UPPER(p_item_rec.qchold_res_code);
253: l_ic_item_mst_rec.expaction_code := UPPER(p_item_rec.expaction_code);
254: l_ic_item_mst_rec.fill_qty := p_item_rec.fill_qty;
255: l_ic_item_mst_rec.fill_um := p_item_rec.fill_um;
256: l_ic_item_mst_rec.expaction_interval := p_item_rec.expaction_interval;
257: l_ic_item_mst_rec.phantom_type := p_item_rec.phantom_type;

Line 254: l_ic_item_mst_rec.fill_qty := p_item_rec.fill_qty;

250: l_ic_item_mst_rec.pkg_id := p_item_rec.pkg_id;
251: l_ic_item_mst_rec.qcitem_id := l_qcitem_id;
252: l_ic_item_mst_rec.qchold_res_code := UPPER(p_item_rec.qchold_res_code);
253: l_ic_item_mst_rec.expaction_code := UPPER(p_item_rec.expaction_code);
254: l_ic_item_mst_rec.fill_qty := p_item_rec.fill_qty;
255: l_ic_item_mst_rec.fill_um := p_item_rec.fill_um;
256: l_ic_item_mst_rec.expaction_interval := p_item_rec.expaction_interval;
257: l_ic_item_mst_rec.phantom_type := p_item_rec.phantom_type;
258: l_ic_item_mst_rec.whse_item_id := l_whse_item_id;

Line 255: l_ic_item_mst_rec.fill_um := p_item_rec.fill_um;

251: l_ic_item_mst_rec.qcitem_id := l_qcitem_id;
252: l_ic_item_mst_rec.qchold_res_code := UPPER(p_item_rec.qchold_res_code);
253: l_ic_item_mst_rec.expaction_code := UPPER(p_item_rec.expaction_code);
254: l_ic_item_mst_rec.fill_qty := p_item_rec.fill_qty;
255: l_ic_item_mst_rec.fill_um := p_item_rec.fill_um;
256: l_ic_item_mst_rec.expaction_interval := p_item_rec.expaction_interval;
257: l_ic_item_mst_rec.phantom_type := p_item_rec.phantom_type;
258: l_ic_item_mst_rec.whse_item_id := l_whse_item_id;
259: l_ic_item_mst_rec.experimental_ind := p_item_rec.experimental_ind;

Line 256: l_ic_item_mst_rec.expaction_interval := p_item_rec.expaction_interval;

252: l_ic_item_mst_rec.qchold_res_code := UPPER(p_item_rec.qchold_res_code);
253: l_ic_item_mst_rec.expaction_code := UPPER(p_item_rec.expaction_code);
254: l_ic_item_mst_rec.fill_qty := p_item_rec.fill_qty;
255: l_ic_item_mst_rec.fill_um := p_item_rec.fill_um;
256: l_ic_item_mst_rec.expaction_interval := p_item_rec.expaction_interval;
257: l_ic_item_mst_rec.phantom_type := p_item_rec.phantom_type;
258: l_ic_item_mst_rec.whse_item_id := l_whse_item_id;
259: l_ic_item_mst_rec.experimental_ind := p_item_rec.experimental_ind;
260: l_ic_item_mst_rec.exported_date := GMA_GLOBAL_GRP.SY$MIN_DATE;

Line 257: l_ic_item_mst_rec.phantom_type := p_item_rec.phantom_type;

253: l_ic_item_mst_rec.expaction_code := UPPER(p_item_rec.expaction_code);
254: l_ic_item_mst_rec.fill_qty := p_item_rec.fill_qty;
255: l_ic_item_mst_rec.fill_um := p_item_rec.fill_um;
256: l_ic_item_mst_rec.expaction_interval := p_item_rec.expaction_interval;
257: l_ic_item_mst_rec.phantom_type := p_item_rec.phantom_type;
258: l_ic_item_mst_rec.whse_item_id := l_whse_item_id;
259: l_ic_item_mst_rec.experimental_ind := p_item_rec.experimental_ind;
260: l_ic_item_mst_rec.exported_date := GMA_GLOBAL_GRP.SY$MIN_DATE;
261: l_ic_item_mst_rec.creation_date := SYSDATE;

Line 258: l_ic_item_mst_rec.whse_item_id := l_whse_item_id;

254: l_ic_item_mst_rec.fill_qty := p_item_rec.fill_qty;
255: l_ic_item_mst_rec.fill_um := p_item_rec.fill_um;
256: l_ic_item_mst_rec.expaction_interval := p_item_rec.expaction_interval;
257: l_ic_item_mst_rec.phantom_type := p_item_rec.phantom_type;
258: l_ic_item_mst_rec.whse_item_id := l_whse_item_id;
259: l_ic_item_mst_rec.experimental_ind := p_item_rec.experimental_ind;
260: l_ic_item_mst_rec.exported_date := GMA_GLOBAL_GRP.SY$MIN_DATE;
261: l_ic_item_mst_rec.creation_date := SYSDATE;
262: l_ic_item_mst_rec.last_update_date := SYSDATE;

Line 259: l_ic_item_mst_rec.experimental_ind := p_item_rec.experimental_ind;

255: l_ic_item_mst_rec.fill_um := p_item_rec.fill_um;
256: l_ic_item_mst_rec.expaction_interval := p_item_rec.expaction_interval;
257: l_ic_item_mst_rec.phantom_type := p_item_rec.phantom_type;
258: l_ic_item_mst_rec.whse_item_id := l_whse_item_id;
259: l_ic_item_mst_rec.experimental_ind := p_item_rec.experimental_ind;
260: l_ic_item_mst_rec.exported_date := GMA_GLOBAL_GRP.SY$MIN_DATE;
261: l_ic_item_mst_rec.creation_date := SYSDATE;
262: l_ic_item_mst_rec.last_update_date := SYSDATE;
263: l_ic_item_mst_rec.created_by := l_user_id;

Line 260: l_ic_item_mst_rec.exported_date := GMA_GLOBAL_GRP.SY$MIN_DATE;

256: l_ic_item_mst_rec.expaction_interval := p_item_rec.expaction_interval;
257: l_ic_item_mst_rec.phantom_type := p_item_rec.phantom_type;
258: l_ic_item_mst_rec.whse_item_id := l_whse_item_id;
259: l_ic_item_mst_rec.experimental_ind := p_item_rec.experimental_ind;
260: l_ic_item_mst_rec.exported_date := GMA_GLOBAL_GRP.SY$MIN_DATE;
261: l_ic_item_mst_rec.creation_date := SYSDATE;
262: l_ic_item_mst_rec.last_update_date := SYSDATE;
263: l_ic_item_mst_rec.created_by := l_user_id;
264: l_ic_item_mst_rec.last_updated_by := l_user_id;

Line 261: l_ic_item_mst_rec.creation_date := SYSDATE;

257: l_ic_item_mst_rec.phantom_type := p_item_rec.phantom_type;
258: l_ic_item_mst_rec.whse_item_id := l_whse_item_id;
259: l_ic_item_mst_rec.experimental_ind := p_item_rec.experimental_ind;
260: l_ic_item_mst_rec.exported_date := GMA_GLOBAL_GRP.SY$MIN_DATE;
261: l_ic_item_mst_rec.creation_date := SYSDATE;
262: l_ic_item_mst_rec.last_update_date := SYSDATE;
263: l_ic_item_mst_rec.created_by := l_user_id;
264: l_ic_item_mst_rec.last_updated_by := l_user_id;
265: l_ic_item_mst_rec.last_update_login := TO_NUMBER(FND_PROFILE.Value(

Line 262: l_ic_item_mst_rec.last_update_date := SYSDATE;

258: l_ic_item_mst_rec.whse_item_id := l_whse_item_id;
259: l_ic_item_mst_rec.experimental_ind := p_item_rec.experimental_ind;
260: l_ic_item_mst_rec.exported_date := GMA_GLOBAL_GRP.SY$MIN_DATE;
261: l_ic_item_mst_rec.creation_date := SYSDATE;
262: l_ic_item_mst_rec.last_update_date := SYSDATE;
263: l_ic_item_mst_rec.created_by := l_user_id;
264: l_ic_item_mst_rec.last_updated_by := l_user_id;
265: l_ic_item_mst_rec.last_update_login := TO_NUMBER(FND_PROFILE.Value(
266: 'LOGIN_ID'));

Line 263: l_ic_item_mst_rec.created_by := l_user_id;

259: l_ic_item_mst_rec.experimental_ind := p_item_rec.experimental_ind;
260: l_ic_item_mst_rec.exported_date := GMA_GLOBAL_GRP.SY$MIN_DATE;
261: l_ic_item_mst_rec.creation_date := SYSDATE;
262: l_ic_item_mst_rec.last_update_date := SYSDATE;
263: l_ic_item_mst_rec.created_by := l_user_id;
264: l_ic_item_mst_rec.last_updated_by := l_user_id;
265: l_ic_item_mst_rec.last_update_login := TO_NUMBER(FND_PROFILE.Value(
266: 'LOGIN_ID'));
267: l_ic_item_mst_rec.trans_cnt := 1;

Line 264: l_ic_item_mst_rec.last_updated_by := l_user_id;

260: l_ic_item_mst_rec.exported_date := GMA_GLOBAL_GRP.SY$MIN_DATE;
261: l_ic_item_mst_rec.creation_date := SYSDATE;
262: l_ic_item_mst_rec.last_update_date := SYSDATE;
263: l_ic_item_mst_rec.created_by := l_user_id;
264: l_ic_item_mst_rec.last_updated_by := l_user_id;
265: l_ic_item_mst_rec.last_update_login := TO_NUMBER(FND_PROFILE.Value(
266: 'LOGIN_ID'));
267: l_ic_item_mst_rec.trans_cnt := 1;
268: l_ic_item_mst_rec.delete_mark := 0;

Line 265: l_ic_item_mst_rec.last_update_login := TO_NUMBER(FND_PROFILE.Value(

261: l_ic_item_mst_rec.creation_date := SYSDATE;
262: l_ic_item_mst_rec.last_update_date := SYSDATE;
263: l_ic_item_mst_rec.created_by := l_user_id;
264: l_ic_item_mst_rec.last_updated_by := l_user_id;
265: l_ic_item_mst_rec.last_update_login := TO_NUMBER(FND_PROFILE.Value(
266: 'LOGIN_ID'));
267: l_ic_item_mst_rec.trans_cnt := 1;
268: l_ic_item_mst_rec.delete_mark := 0;
269: l_ic_item_mst_rec.text_code := NULL;

Line 267: l_ic_item_mst_rec.trans_cnt := 1;

263: l_ic_item_mst_rec.created_by := l_user_id;
264: l_ic_item_mst_rec.last_updated_by := l_user_id;
265: l_ic_item_mst_rec.last_update_login := TO_NUMBER(FND_PROFILE.Value(
266: 'LOGIN_ID'));
267: l_ic_item_mst_rec.trans_cnt := 1;
268: l_ic_item_mst_rec.delete_mark := 0;
269: l_ic_item_mst_rec.text_code := NULL;
270: l_ic_item_mst_rec.seq_dpnd_class := UPPER(p_item_rec.seq_dpnd_class);
271: l_ic_item_mst_rec.commodity_code := p_item_rec.commodity_code;

Line 268: l_ic_item_mst_rec.delete_mark := 0;

264: l_ic_item_mst_rec.last_updated_by := l_user_id;
265: l_ic_item_mst_rec.last_update_login := TO_NUMBER(FND_PROFILE.Value(
266: 'LOGIN_ID'));
267: l_ic_item_mst_rec.trans_cnt := 1;
268: l_ic_item_mst_rec.delete_mark := 0;
269: l_ic_item_mst_rec.text_code := NULL;
270: l_ic_item_mst_rec.seq_dpnd_class := UPPER(p_item_rec.seq_dpnd_class);
271: l_ic_item_mst_rec.commodity_code := p_item_rec.commodity_code;
272: l_ic_item_mst_rec.attribute1 := UPPER(p_item_rec.attribute1);

Line 269: l_ic_item_mst_rec.text_code := NULL;

265: l_ic_item_mst_rec.last_update_login := TO_NUMBER(FND_PROFILE.Value(
266: 'LOGIN_ID'));
267: l_ic_item_mst_rec.trans_cnt := 1;
268: l_ic_item_mst_rec.delete_mark := 0;
269: l_ic_item_mst_rec.text_code := NULL;
270: l_ic_item_mst_rec.seq_dpnd_class := UPPER(p_item_rec.seq_dpnd_class);
271: l_ic_item_mst_rec.commodity_code := p_item_rec.commodity_code;
272: l_ic_item_mst_rec.attribute1 := UPPER(p_item_rec.attribute1);
273: l_ic_item_mst_rec.attribute2 := UPPER(p_item_rec.attribute2);

Line 270: l_ic_item_mst_rec.seq_dpnd_class := UPPER(p_item_rec.seq_dpnd_class);

266: 'LOGIN_ID'));
267: l_ic_item_mst_rec.trans_cnt := 1;
268: l_ic_item_mst_rec.delete_mark := 0;
269: l_ic_item_mst_rec.text_code := NULL;
270: l_ic_item_mst_rec.seq_dpnd_class := UPPER(p_item_rec.seq_dpnd_class);
271: l_ic_item_mst_rec.commodity_code := p_item_rec.commodity_code;
272: l_ic_item_mst_rec.attribute1 := UPPER(p_item_rec.attribute1);
273: l_ic_item_mst_rec.attribute2 := UPPER(p_item_rec.attribute2);
274: l_ic_item_mst_rec.attribute3 := UPPER(p_item_rec.attribute3);

Line 271: l_ic_item_mst_rec.commodity_code := p_item_rec.commodity_code;

267: l_ic_item_mst_rec.trans_cnt := 1;
268: l_ic_item_mst_rec.delete_mark := 0;
269: l_ic_item_mst_rec.text_code := NULL;
270: l_ic_item_mst_rec.seq_dpnd_class := UPPER(p_item_rec.seq_dpnd_class);
271: l_ic_item_mst_rec.commodity_code := p_item_rec.commodity_code;
272: l_ic_item_mst_rec.attribute1 := UPPER(p_item_rec.attribute1);
273: l_ic_item_mst_rec.attribute2 := UPPER(p_item_rec.attribute2);
274: l_ic_item_mst_rec.attribute3 := UPPER(p_item_rec.attribute3);
275: l_ic_item_mst_rec.attribute4 := UPPER(p_item_rec.attribute4);

Line 272: l_ic_item_mst_rec.attribute1 := UPPER(p_item_rec.attribute1);

268: l_ic_item_mst_rec.delete_mark := 0;
269: l_ic_item_mst_rec.text_code := NULL;
270: l_ic_item_mst_rec.seq_dpnd_class := UPPER(p_item_rec.seq_dpnd_class);
271: l_ic_item_mst_rec.commodity_code := p_item_rec.commodity_code;
272: l_ic_item_mst_rec.attribute1 := UPPER(p_item_rec.attribute1);
273: l_ic_item_mst_rec.attribute2 := UPPER(p_item_rec.attribute2);
274: l_ic_item_mst_rec.attribute3 := UPPER(p_item_rec.attribute3);
275: l_ic_item_mst_rec.attribute4 := UPPER(p_item_rec.attribute4);
276: l_ic_item_mst_rec.attribute5 := UPPER(p_item_rec.attribute5);

Line 273: l_ic_item_mst_rec.attribute2 := UPPER(p_item_rec.attribute2);

269: l_ic_item_mst_rec.text_code := NULL;
270: l_ic_item_mst_rec.seq_dpnd_class := UPPER(p_item_rec.seq_dpnd_class);
271: l_ic_item_mst_rec.commodity_code := p_item_rec.commodity_code;
272: l_ic_item_mst_rec.attribute1 := UPPER(p_item_rec.attribute1);
273: l_ic_item_mst_rec.attribute2 := UPPER(p_item_rec.attribute2);
274: l_ic_item_mst_rec.attribute3 := UPPER(p_item_rec.attribute3);
275: l_ic_item_mst_rec.attribute4 := UPPER(p_item_rec.attribute4);
276: l_ic_item_mst_rec.attribute5 := UPPER(p_item_rec.attribute5);
277: l_ic_item_mst_rec.attribute6 := UPPER(p_item_rec.attribute6);

Line 274: l_ic_item_mst_rec.attribute3 := UPPER(p_item_rec.attribute3);

270: l_ic_item_mst_rec.seq_dpnd_class := UPPER(p_item_rec.seq_dpnd_class);
271: l_ic_item_mst_rec.commodity_code := p_item_rec.commodity_code;
272: l_ic_item_mst_rec.attribute1 := UPPER(p_item_rec.attribute1);
273: l_ic_item_mst_rec.attribute2 := UPPER(p_item_rec.attribute2);
274: l_ic_item_mst_rec.attribute3 := UPPER(p_item_rec.attribute3);
275: l_ic_item_mst_rec.attribute4 := UPPER(p_item_rec.attribute4);
276: l_ic_item_mst_rec.attribute5 := UPPER(p_item_rec.attribute5);
277: l_ic_item_mst_rec.attribute6 := UPPER(p_item_rec.attribute6);
278: l_ic_item_mst_rec.attribute7 := UPPER(p_item_rec.attribute7);

Line 275: l_ic_item_mst_rec.attribute4 := UPPER(p_item_rec.attribute4);

271: l_ic_item_mst_rec.commodity_code := p_item_rec.commodity_code;
272: l_ic_item_mst_rec.attribute1 := UPPER(p_item_rec.attribute1);
273: l_ic_item_mst_rec.attribute2 := UPPER(p_item_rec.attribute2);
274: l_ic_item_mst_rec.attribute3 := UPPER(p_item_rec.attribute3);
275: l_ic_item_mst_rec.attribute4 := UPPER(p_item_rec.attribute4);
276: l_ic_item_mst_rec.attribute5 := UPPER(p_item_rec.attribute5);
277: l_ic_item_mst_rec.attribute6 := UPPER(p_item_rec.attribute6);
278: l_ic_item_mst_rec.attribute7 := UPPER(p_item_rec.attribute7);
279: l_ic_item_mst_rec.attribute8 := UPPER(p_item_rec.attribute8);

Line 276: l_ic_item_mst_rec.attribute5 := UPPER(p_item_rec.attribute5);

272: l_ic_item_mst_rec.attribute1 := UPPER(p_item_rec.attribute1);
273: l_ic_item_mst_rec.attribute2 := UPPER(p_item_rec.attribute2);
274: l_ic_item_mst_rec.attribute3 := UPPER(p_item_rec.attribute3);
275: l_ic_item_mst_rec.attribute4 := UPPER(p_item_rec.attribute4);
276: l_ic_item_mst_rec.attribute5 := UPPER(p_item_rec.attribute5);
277: l_ic_item_mst_rec.attribute6 := UPPER(p_item_rec.attribute6);
278: l_ic_item_mst_rec.attribute7 := UPPER(p_item_rec.attribute7);
279: l_ic_item_mst_rec.attribute8 := UPPER(p_item_rec.attribute8);
280: l_ic_item_mst_rec.attribute9 := UPPER(p_item_rec.attribute9);

Line 277: l_ic_item_mst_rec.attribute6 := UPPER(p_item_rec.attribute6);

273: l_ic_item_mst_rec.attribute2 := UPPER(p_item_rec.attribute2);
274: l_ic_item_mst_rec.attribute3 := UPPER(p_item_rec.attribute3);
275: l_ic_item_mst_rec.attribute4 := UPPER(p_item_rec.attribute4);
276: l_ic_item_mst_rec.attribute5 := UPPER(p_item_rec.attribute5);
277: l_ic_item_mst_rec.attribute6 := UPPER(p_item_rec.attribute6);
278: l_ic_item_mst_rec.attribute7 := UPPER(p_item_rec.attribute7);
279: l_ic_item_mst_rec.attribute8 := UPPER(p_item_rec.attribute8);
280: l_ic_item_mst_rec.attribute9 := UPPER(p_item_rec.attribute9);
281: l_ic_item_mst_rec.attribute10 := UPPER(p_item_rec.attribute10);

Line 278: l_ic_item_mst_rec.attribute7 := UPPER(p_item_rec.attribute7);

274: l_ic_item_mst_rec.attribute3 := UPPER(p_item_rec.attribute3);
275: l_ic_item_mst_rec.attribute4 := UPPER(p_item_rec.attribute4);
276: l_ic_item_mst_rec.attribute5 := UPPER(p_item_rec.attribute5);
277: l_ic_item_mst_rec.attribute6 := UPPER(p_item_rec.attribute6);
278: l_ic_item_mst_rec.attribute7 := UPPER(p_item_rec.attribute7);
279: l_ic_item_mst_rec.attribute8 := UPPER(p_item_rec.attribute8);
280: l_ic_item_mst_rec.attribute9 := UPPER(p_item_rec.attribute9);
281: l_ic_item_mst_rec.attribute10 := UPPER(p_item_rec.attribute10);
282: l_ic_item_mst_rec.attribute11 := UPPER(p_item_rec.attribute11);

Line 279: l_ic_item_mst_rec.attribute8 := UPPER(p_item_rec.attribute8);

275: l_ic_item_mst_rec.attribute4 := UPPER(p_item_rec.attribute4);
276: l_ic_item_mst_rec.attribute5 := UPPER(p_item_rec.attribute5);
277: l_ic_item_mst_rec.attribute6 := UPPER(p_item_rec.attribute6);
278: l_ic_item_mst_rec.attribute7 := UPPER(p_item_rec.attribute7);
279: l_ic_item_mst_rec.attribute8 := UPPER(p_item_rec.attribute8);
280: l_ic_item_mst_rec.attribute9 := UPPER(p_item_rec.attribute9);
281: l_ic_item_mst_rec.attribute10 := UPPER(p_item_rec.attribute10);
282: l_ic_item_mst_rec.attribute11 := UPPER(p_item_rec.attribute11);
283: l_ic_item_mst_rec.attribute12 := UPPER(p_item_rec.attribute12);

Line 280: l_ic_item_mst_rec.attribute9 := UPPER(p_item_rec.attribute9);

276: l_ic_item_mst_rec.attribute5 := UPPER(p_item_rec.attribute5);
277: l_ic_item_mst_rec.attribute6 := UPPER(p_item_rec.attribute6);
278: l_ic_item_mst_rec.attribute7 := UPPER(p_item_rec.attribute7);
279: l_ic_item_mst_rec.attribute8 := UPPER(p_item_rec.attribute8);
280: l_ic_item_mst_rec.attribute9 := UPPER(p_item_rec.attribute9);
281: l_ic_item_mst_rec.attribute10 := UPPER(p_item_rec.attribute10);
282: l_ic_item_mst_rec.attribute11 := UPPER(p_item_rec.attribute11);
283: l_ic_item_mst_rec.attribute12 := UPPER(p_item_rec.attribute12);
284: l_ic_item_mst_rec.attribute13 := UPPER(p_item_rec.attribute13);

Line 281: l_ic_item_mst_rec.attribute10 := UPPER(p_item_rec.attribute10);

277: l_ic_item_mst_rec.attribute6 := UPPER(p_item_rec.attribute6);
278: l_ic_item_mst_rec.attribute7 := UPPER(p_item_rec.attribute7);
279: l_ic_item_mst_rec.attribute8 := UPPER(p_item_rec.attribute8);
280: l_ic_item_mst_rec.attribute9 := UPPER(p_item_rec.attribute9);
281: l_ic_item_mst_rec.attribute10 := UPPER(p_item_rec.attribute10);
282: l_ic_item_mst_rec.attribute11 := UPPER(p_item_rec.attribute11);
283: l_ic_item_mst_rec.attribute12 := UPPER(p_item_rec.attribute12);
284: l_ic_item_mst_rec.attribute13 := UPPER(p_item_rec.attribute13);
285: l_ic_item_mst_rec.attribute14 := UPPER(p_item_rec.attribute14);

Line 282: l_ic_item_mst_rec.attribute11 := UPPER(p_item_rec.attribute11);

278: l_ic_item_mst_rec.attribute7 := UPPER(p_item_rec.attribute7);
279: l_ic_item_mst_rec.attribute8 := UPPER(p_item_rec.attribute8);
280: l_ic_item_mst_rec.attribute9 := UPPER(p_item_rec.attribute9);
281: l_ic_item_mst_rec.attribute10 := UPPER(p_item_rec.attribute10);
282: l_ic_item_mst_rec.attribute11 := UPPER(p_item_rec.attribute11);
283: l_ic_item_mst_rec.attribute12 := UPPER(p_item_rec.attribute12);
284: l_ic_item_mst_rec.attribute13 := UPPER(p_item_rec.attribute13);
285: l_ic_item_mst_rec.attribute14 := UPPER(p_item_rec.attribute14);
286: l_ic_item_mst_rec.attribute15 := UPPER(p_item_rec.attribute15);

Line 283: l_ic_item_mst_rec.attribute12 := UPPER(p_item_rec.attribute12);

279: l_ic_item_mst_rec.attribute8 := UPPER(p_item_rec.attribute8);
280: l_ic_item_mst_rec.attribute9 := UPPER(p_item_rec.attribute9);
281: l_ic_item_mst_rec.attribute10 := UPPER(p_item_rec.attribute10);
282: l_ic_item_mst_rec.attribute11 := UPPER(p_item_rec.attribute11);
283: l_ic_item_mst_rec.attribute12 := UPPER(p_item_rec.attribute12);
284: l_ic_item_mst_rec.attribute13 := UPPER(p_item_rec.attribute13);
285: l_ic_item_mst_rec.attribute14 := UPPER(p_item_rec.attribute14);
286: l_ic_item_mst_rec.attribute15 := UPPER(p_item_rec.attribute15);
287: l_ic_item_mst_rec.attribute16 := UPPER(p_item_rec.attribute16);

Line 284: l_ic_item_mst_rec.attribute13 := UPPER(p_item_rec.attribute13);

280: l_ic_item_mst_rec.attribute9 := UPPER(p_item_rec.attribute9);
281: l_ic_item_mst_rec.attribute10 := UPPER(p_item_rec.attribute10);
282: l_ic_item_mst_rec.attribute11 := UPPER(p_item_rec.attribute11);
283: l_ic_item_mst_rec.attribute12 := UPPER(p_item_rec.attribute12);
284: l_ic_item_mst_rec.attribute13 := UPPER(p_item_rec.attribute13);
285: l_ic_item_mst_rec.attribute14 := UPPER(p_item_rec.attribute14);
286: l_ic_item_mst_rec.attribute15 := UPPER(p_item_rec.attribute15);
287: l_ic_item_mst_rec.attribute16 := UPPER(p_item_rec.attribute16);
288: l_ic_item_mst_rec.attribute17 := UPPER(p_item_rec.attribute17);

Line 285: l_ic_item_mst_rec.attribute14 := UPPER(p_item_rec.attribute14);

281: l_ic_item_mst_rec.attribute10 := UPPER(p_item_rec.attribute10);
282: l_ic_item_mst_rec.attribute11 := UPPER(p_item_rec.attribute11);
283: l_ic_item_mst_rec.attribute12 := UPPER(p_item_rec.attribute12);
284: l_ic_item_mst_rec.attribute13 := UPPER(p_item_rec.attribute13);
285: l_ic_item_mst_rec.attribute14 := UPPER(p_item_rec.attribute14);
286: l_ic_item_mst_rec.attribute15 := UPPER(p_item_rec.attribute15);
287: l_ic_item_mst_rec.attribute16 := UPPER(p_item_rec.attribute16);
288: l_ic_item_mst_rec.attribute17 := UPPER(p_item_rec.attribute17);
289: l_ic_item_mst_rec.attribute18 := UPPER(p_item_rec.attribute18);

Line 286: l_ic_item_mst_rec.attribute15 := UPPER(p_item_rec.attribute15);

282: l_ic_item_mst_rec.attribute11 := UPPER(p_item_rec.attribute11);
283: l_ic_item_mst_rec.attribute12 := UPPER(p_item_rec.attribute12);
284: l_ic_item_mst_rec.attribute13 := UPPER(p_item_rec.attribute13);
285: l_ic_item_mst_rec.attribute14 := UPPER(p_item_rec.attribute14);
286: l_ic_item_mst_rec.attribute15 := UPPER(p_item_rec.attribute15);
287: l_ic_item_mst_rec.attribute16 := UPPER(p_item_rec.attribute16);
288: l_ic_item_mst_rec.attribute17 := UPPER(p_item_rec.attribute17);
289: l_ic_item_mst_rec.attribute18 := UPPER(p_item_rec.attribute18);
290: l_ic_item_mst_rec.attribute19 := UPPER(p_item_rec.attribute19);

Line 287: l_ic_item_mst_rec.attribute16 := UPPER(p_item_rec.attribute16);

283: l_ic_item_mst_rec.attribute12 := UPPER(p_item_rec.attribute12);
284: l_ic_item_mst_rec.attribute13 := UPPER(p_item_rec.attribute13);
285: l_ic_item_mst_rec.attribute14 := UPPER(p_item_rec.attribute14);
286: l_ic_item_mst_rec.attribute15 := UPPER(p_item_rec.attribute15);
287: l_ic_item_mst_rec.attribute16 := UPPER(p_item_rec.attribute16);
288: l_ic_item_mst_rec.attribute17 := UPPER(p_item_rec.attribute17);
289: l_ic_item_mst_rec.attribute18 := UPPER(p_item_rec.attribute18);
290: l_ic_item_mst_rec.attribute19 := UPPER(p_item_rec.attribute19);
291: l_ic_item_mst_rec.attribute20 := UPPER(p_item_rec.attribute20);

Line 288: l_ic_item_mst_rec.attribute17 := UPPER(p_item_rec.attribute17);

284: l_ic_item_mst_rec.attribute13 := UPPER(p_item_rec.attribute13);
285: l_ic_item_mst_rec.attribute14 := UPPER(p_item_rec.attribute14);
286: l_ic_item_mst_rec.attribute15 := UPPER(p_item_rec.attribute15);
287: l_ic_item_mst_rec.attribute16 := UPPER(p_item_rec.attribute16);
288: l_ic_item_mst_rec.attribute17 := UPPER(p_item_rec.attribute17);
289: l_ic_item_mst_rec.attribute18 := UPPER(p_item_rec.attribute18);
290: l_ic_item_mst_rec.attribute19 := UPPER(p_item_rec.attribute19);
291: l_ic_item_mst_rec.attribute20 := UPPER(p_item_rec.attribute20);
292: l_ic_item_mst_rec.attribute21 := UPPER(p_item_rec.attribute21);

Line 289: l_ic_item_mst_rec.attribute18 := UPPER(p_item_rec.attribute18);

285: l_ic_item_mst_rec.attribute14 := UPPER(p_item_rec.attribute14);
286: l_ic_item_mst_rec.attribute15 := UPPER(p_item_rec.attribute15);
287: l_ic_item_mst_rec.attribute16 := UPPER(p_item_rec.attribute16);
288: l_ic_item_mst_rec.attribute17 := UPPER(p_item_rec.attribute17);
289: l_ic_item_mst_rec.attribute18 := UPPER(p_item_rec.attribute18);
290: l_ic_item_mst_rec.attribute19 := UPPER(p_item_rec.attribute19);
291: l_ic_item_mst_rec.attribute20 := UPPER(p_item_rec.attribute20);
292: l_ic_item_mst_rec.attribute21 := UPPER(p_item_rec.attribute21);
293: l_ic_item_mst_rec.attribute22 := UPPER(p_item_rec.attribute22);

Line 290: l_ic_item_mst_rec.attribute19 := UPPER(p_item_rec.attribute19);

286: l_ic_item_mst_rec.attribute15 := UPPER(p_item_rec.attribute15);
287: l_ic_item_mst_rec.attribute16 := UPPER(p_item_rec.attribute16);
288: l_ic_item_mst_rec.attribute17 := UPPER(p_item_rec.attribute17);
289: l_ic_item_mst_rec.attribute18 := UPPER(p_item_rec.attribute18);
290: l_ic_item_mst_rec.attribute19 := UPPER(p_item_rec.attribute19);
291: l_ic_item_mst_rec.attribute20 := UPPER(p_item_rec.attribute20);
292: l_ic_item_mst_rec.attribute21 := UPPER(p_item_rec.attribute21);
293: l_ic_item_mst_rec.attribute22 := UPPER(p_item_rec.attribute22);
294: l_ic_item_mst_rec.attribute23 := UPPER(p_item_rec.attribute23);

Line 291: l_ic_item_mst_rec.attribute20 := UPPER(p_item_rec.attribute20);

287: l_ic_item_mst_rec.attribute16 := UPPER(p_item_rec.attribute16);
288: l_ic_item_mst_rec.attribute17 := UPPER(p_item_rec.attribute17);
289: l_ic_item_mst_rec.attribute18 := UPPER(p_item_rec.attribute18);
290: l_ic_item_mst_rec.attribute19 := UPPER(p_item_rec.attribute19);
291: l_ic_item_mst_rec.attribute20 := UPPER(p_item_rec.attribute20);
292: l_ic_item_mst_rec.attribute21 := UPPER(p_item_rec.attribute21);
293: l_ic_item_mst_rec.attribute22 := UPPER(p_item_rec.attribute22);
294: l_ic_item_mst_rec.attribute23 := UPPER(p_item_rec.attribute23);
295: l_ic_item_mst_rec.attribute24 := UPPER(p_item_rec.attribute24);

Line 292: l_ic_item_mst_rec.attribute21 := UPPER(p_item_rec.attribute21);

288: l_ic_item_mst_rec.attribute17 := UPPER(p_item_rec.attribute17);
289: l_ic_item_mst_rec.attribute18 := UPPER(p_item_rec.attribute18);
290: l_ic_item_mst_rec.attribute19 := UPPER(p_item_rec.attribute19);
291: l_ic_item_mst_rec.attribute20 := UPPER(p_item_rec.attribute20);
292: l_ic_item_mst_rec.attribute21 := UPPER(p_item_rec.attribute21);
293: l_ic_item_mst_rec.attribute22 := UPPER(p_item_rec.attribute22);
294: l_ic_item_mst_rec.attribute23 := UPPER(p_item_rec.attribute23);
295: l_ic_item_mst_rec.attribute24 := UPPER(p_item_rec.attribute24);
296: l_ic_item_mst_rec.attribute25 := UPPER(p_item_rec.attribute25);

Line 293: l_ic_item_mst_rec.attribute22 := UPPER(p_item_rec.attribute22);

289: l_ic_item_mst_rec.attribute18 := UPPER(p_item_rec.attribute18);
290: l_ic_item_mst_rec.attribute19 := UPPER(p_item_rec.attribute19);
291: l_ic_item_mst_rec.attribute20 := UPPER(p_item_rec.attribute20);
292: l_ic_item_mst_rec.attribute21 := UPPER(p_item_rec.attribute21);
293: l_ic_item_mst_rec.attribute22 := UPPER(p_item_rec.attribute22);
294: l_ic_item_mst_rec.attribute23 := UPPER(p_item_rec.attribute23);
295: l_ic_item_mst_rec.attribute24 := UPPER(p_item_rec.attribute24);
296: l_ic_item_mst_rec.attribute25 := UPPER(p_item_rec.attribute25);
297: l_ic_item_mst_rec.attribute26 := UPPER(p_item_rec.attribute26);

Line 294: l_ic_item_mst_rec.attribute23 := UPPER(p_item_rec.attribute23);

290: l_ic_item_mst_rec.attribute19 := UPPER(p_item_rec.attribute19);
291: l_ic_item_mst_rec.attribute20 := UPPER(p_item_rec.attribute20);
292: l_ic_item_mst_rec.attribute21 := UPPER(p_item_rec.attribute21);
293: l_ic_item_mst_rec.attribute22 := UPPER(p_item_rec.attribute22);
294: l_ic_item_mst_rec.attribute23 := UPPER(p_item_rec.attribute23);
295: l_ic_item_mst_rec.attribute24 := UPPER(p_item_rec.attribute24);
296: l_ic_item_mst_rec.attribute25 := UPPER(p_item_rec.attribute25);
297: l_ic_item_mst_rec.attribute26 := UPPER(p_item_rec.attribute26);
298: l_ic_item_mst_rec.attribute27 := UPPER(p_item_rec.attribute27);

Line 295: l_ic_item_mst_rec.attribute24 := UPPER(p_item_rec.attribute24);

291: l_ic_item_mst_rec.attribute20 := UPPER(p_item_rec.attribute20);
292: l_ic_item_mst_rec.attribute21 := UPPER(p_item_rec.attribute21);
293: l_ic_item_mst_rec.attribute22 := UPPER(p_item_rec.attribute22);
294: l_ic_item_mst_rec.attribute23 := UPPER(p_item_rec.attribute23);
295: l_ic_item_mst_rec.attribute24 := UPPER(p_item_rec.attribute24);
296: l_ic_item_mst_rec.attribute25 := UPPER(p_item_rec.attribute25);
297: l_ic_item_mst_rec.attribute26 := UPPER(p_item_rec.attribute26);
298: l_ic_item_mst_rec.attribute27 := UPPER(p_item_rec.attribute27);
299: l_ic_item_mst_rec.attribute28 := UPPER(p_item_rec.attribute28);

Line 296: l_ic_item_mst_rec.attribute25 := UPPER(p_item_rec.attribute25);

292: l_ic_item_mst_rec.attribute21 := UPPER(p_item_rec.attribute21);
293: l_ic_item_mst_rec.attribute22 := UPPER(p_item_rec.attribute22);
294: l_ic_item_mst_rec.attribute23 := UPPER(p_item_rec.attribute23);
295: l_ic_item_mst_rec.attribute24 := UPPER(p_item_rec.attribute24);
296: l_ic_item_mst_rec.attribute25 := UPPER(p_item_rec.attribute25);
297: l_ic_item_mst_rec.attribute26 := UPPER(p_item_rec.attribute26);
298: l_ic_item_mst_rec.attribute27 := UPPER(p_item_rec.attribute27);
299: l_ic_item_mst_rec.attribute28 := UPPER(p_item_rec.attribute28);
300: l_ic_item_mst_rec.attribute29 := UPPER(p_item_rec.attribute29);

Line 297: l_ic_item_mst_rec.attribute26 := UPPER(p_item_rec.attribute26);

293: l_ic_item_mst_rec.attribute22 := UPPER(p_item_rec.attribute22);
294: l_ic_item_mst_rec.attribute23 := UPPER(p_item_rec.attribute23);
295: l_ic_item_mst_rec.attribute24 := UPPER(p_item_rec.attribute24);
296: l_ic_item_mst_rec.attribute25 := UPPER(p_item_rec.attribute25);
297: l_ic_item_mst_rec.attribute26 := UPPER(p_item_rec.attribute26);
298: l_ic_item_mst_rec.attribute27 := UPPER(p_item_rec.attribute27);
299: l_ic_item_mst_rec.attribute28 := UPPER(p_item_rec.attribute28);
300: l_ic_item_mst_rec.attribute29 := UPPER(p_item_rec.attribute29);
301: l_ic_item_mst_rec.attribute30 := UPPER(p_item_rec.attribute30);

Line 298: l_ic_item_mst_rec.attribute27 := UPPER(p_item_rec.attribute27);

294: l_ic_item_mst_rec.attribute23 := UPPER(p_item_rec.attribute23);
295: l_ic_item_mst_rec.attribute24 := UPPER(p_item_rec.attribute24);
296: l_ic_item_mst_rec.attribute25 := UPPER(p_item_rec.attribute25);
297: l_ic_item_mst_rec.attribute26 := UPPER(p_item_rec.attribute26);
298: l_ic_item_mst_rec.attribute27 := UPPER(p_item_rec.attribute27);
299: l_ic_item_mst_rec.attribute28 := UPPER(p_item_rec.attribute28);
300: l_ic_item_mst_rec.attribute29 := UPPER(p_item_rec.attribute29);
301: l_ic_item_mst_rec.attribute30 := UPPER(p_item_rec.attribute30);
302: l_ic_item_mst_rec.attribute_category := UPPER(p_item_rec.attribute_category);

Line 299: l_ic_item_mst_rec.attribute28 := UPPER(p_item_rec.attribute28);

295: l_ic_item_mst_rec.attribute24 := UPPER(p_item_rec.attribute24);
296: l_ic_item_mst_rec.attribute25 := UPPER(p_item_rec.attribute25);
297: l_ic_item_mst_rec.attribute26 := UPPER(p_item_rec.attribute26);
298: l_ic_item_mst_rec.attribute27 := UPPER(p_item_rec.attribute27);
299: l_ic_item_mst_rec.attribute28 := UPPER(p_item_rec.attribute28);
300: l_ic_item_mst_rec.attribute29 := UPPER(p_item_rec.attribute29);
301: l_ic_item_mst_rec.attribute30 := UPPER(p_item_rec.attribute30);
302: l_ic_item_mst_rec.attribute_category := UPPER(p_item_rec.attribute_category);
303:

Line 300: l_ic_item_mst_rec.attribute29 := UPPER(p_item_rec.attribute29);

296: l_ic_item_mst_rec.attribute25 := UPPER(p_item_rec.attribute25);
297: l_ic_item_mst_rec.attribute26 := UPPER(p_item_rec.attribute26);
298: l_ic_item_mst_rec.attribute27 := UPPER(p_item_rec.attribute27);
299: l_ic_item_mst_rec.attribute28 := UPPER(p_item_rec.attribute28);
300: l_ic_item_mst_rec.attribute29 := UPPER(p_item_rec.attribute29);
301: l_ic_item_mst_rec.attribute30 := UPPER(p_item_rec.attribute30);
302: l_ic_item_mst_rec.attribute_category := UPPER(p_item_rec.attribute_category);
303:
304: -- dbms_output.put_line('item_id '||'!'||l_item_id||'!');

Line 301: l_ic_item_mst_rec.attribute30 := UPPER(p_item_rec.attribute30);

297: l_ic_item_mst_rec.attribute26 := UPPER(p_item_rec.attribute26);
298: l_ic_item_mst_rec.attribute27 := UPPER(p_item_rec.attribute27);
299: l_ic_item_mst_rec.attribute28 := UPPER(p_item_rec.attribute28);
300: l_ic_item_mst_rec.attribute29 := UPPER(p_item_rec.attribute29);
301: l_ic_item_mst_rec.attribute30 := UPPER(p_item_rec.attribute30);
302: l_ic_item_mst_rec.attribute_category := UPPER(p_item_rec.attribute_category);
303:
304: -- dbms_output.put_line('item_id '||'!'||l_item_id||'!');
305: -- dbms_output.put_line('item_no '||'!'||l_item_no||'!');

Line 302: l_ic_item_mst_rec.attribute_category := UPPER(p_item_rec.attribute_category);

298: l_ic_item_mst_rec.attribute27 := UPPER(p_item_rec.attribute27);
299: l_ic_item_mst_rec.attribute28 := UPPER(p_item_rec.attribute28);
300: l_ic_item_mst_rec.attribute29 := UPPER(p_item_rec.attribute29);
301: l_ic_item_mst_rec.attribute30 := UPPER(p_item_rec.attribute30);
302: l_ic_item_mst_rec.attribute_category := UPPER(p_item_rec.attribute_category);
303:
304: -- dbms_output.put_line('item_id '||'!'||l_item_id||'!');
305: -- dbms_output.put_line('item_no '||'!'||l_item_no||'!');
306: -- dbms_output.put_line('item_desc1 '||'!'||p_item_rec.item_desc1||'!');

Line 373: IF NOT GMI_ITEM_PVT.insert_ic_item_mst(l_ic_item_mst_rec)

369: -- dbms_output.put_line('delete_mark '||'!'||0||'!');
370: -- dbms_output.put_line('text_code '||'!'||0||'!');
371: -- dbms_output.put_line('seq_dpnd_class '||'!'||UPPER(p_item_rec.seq_dpnd_class)||'!');
372: -- dbms_output.put_line('commodity_code '||'!'||p_item_rec.commodity_code||'!');
373: IF NOT GMI_ITEM_PVT.insert_ic_item_mst(l_ic_item_mst_rec)
374: THEN
375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
376: END IF;
377:

Line 533: l_item_id ic_item_mst.item_id%TYPE;

529: )
530: IS
531: l_api_name CONSTANT VARCHAR2 (30) := 'Validate_Item';
532: l_api_version CONSTANT NUMBER := 2.0;
533: l_item_id ic_item_mst.item_id%TYPE;
534: l_item_no ic_item_mst.item_no%TYPE;
535:
536: l_item_desc1 ic_item_mst.item_desc1%TYPE;
537: l_item_um ic_item_mst.item_um%TYPE;

Line 534: l_item_no ic_item_mst.item_no%TYPE;

530: IS
531: l_api_name CONSTANT VARCHAR2 (30) := 'Validate_Item';
532: l_api_version CONSTANT NUMBER := 2.0;
533: l_item_id ic_item_mst.item_id%TYPE;
534: l_item_no ic_item_mst.item_no%TYPE;
535:
536: l_item_desc1 ic_item_mst.item_desc1%TYPE;
537: l_item_um ic_item_mst.item_um%TYPE;
538: l_item_um2 ic_item_mst.item_um2%TYPE;

Line 536: l_item_desc1 ic_item_mst.item_desc1%TYPE;

532: l_api_version CONSTANT NUMBER := 2.0;
533: l_item_id ic_item_mst.item_id%TYPE;
534: l_item_no ic_item_mst.item_no%TYPE;
535:
536: l_item_desc1 ic_item_mst.item_desc1%TYPE;
537: l_item_um ic_item_mst.item_um%TYPE;
538: l_item_um2 ic_item_mst.item_um2%TYPE;
539: l_qcitem_id ic_item_mst.qcitem_id%TYPE;
540: l_whse_item_id ic_item_mst.whse_item_id%TYPE;

Line 537: l_item_um ic_item_mst.item_um%TYPE;

533: l_item_id ic_item_mst.item_id%TYPE;
534: l_item_no ic_item_mst.item_no%TYPE;
535:
536: l_item_desc1 ic_item_mst.item_desc1%TYPE;
537: l_item_um ic_item_mst.item_um%TYPE;
538: l_item_um2 ic_item_mst.item_um2%TYPE;
539: l_qcitem_id ic_item_mst.qcitem_id%TYPE;
540: l_whse_item_id ic_item_mst.whse_item_id%TYPE;
541: l_user_name fnd_user.user_name%TYPE;

Line 538: l_item_um2 ic_item_mst.item_um2%TYPE;

534: l_item_no ic_item_mst.item_no%TYPE;
535:
536: l_item_desc1 ic_item_mst.item_desc1%TYPE;
537: l_item_um ic_item_mst.item_um%TYPE;
538: l_item_um2 ic_item_mst.item_um2%TYPE;
539: l_qcitem_id ic_item_mst.qcitem_id%TYPE;
540: l_whse_item_id ic_item_mst.whse_item_id%TYPE;
541: l_user_name fnd_user.user_name%TYPE;
542: l_msg_count NUMBER;

Line 539: l_qcitem_id ic_item_mst.qcitem_id%TYPE;

535:
536: l_item_desc1 ic_item_mst.item_desc1%TYPE;
537: l_item_um ic_item_mst.item_um%TYPE;
538: l_item_um2 ic_item_mst.item_um2%TYPE;
539: l_qcitem_id ic_item_mst.qcitem_id%TYPE;
540: l_whse_item_id ic_item_mst.whse_item_id%TYPE;
541: l_user_name fnd_user.user_name%TYPE;
542: l_msg_count NUMBER;
543: l_msg_data VARCHAR2(2000);

Line 540: l_whse_item_id ic_item_mst.whse_item_id%TYPE;

536: l_item_desc1 ic_item_mst.item_desc1%TYPE;
537: l_item_um ic_item_mst.item_um%TYPE;
538: l_item_um2 ic_item_mst.item_um2%TYPE;
539: l_qcitem_id ic_item_mst.qcitem_id%TYPE;
540: l_whse_item_id ic_item_mst.whse_item_id%TYPE;
541: l_user_name fnd_user.user_name%TYPE;
542: l_msg_count NUMBER;
543: l_msg_data VARCHAR2(2000);
544: l_return_status VARCHAR2(1);

Line 545: l_ic_item_mst_rec ic_item_mst%ROWTYPE;

541: l_user_name fnd_user.user_name%TYPE;
542: l_msg_count NUMBER;
543: l_msg_data VARCHAR2(2000);
544: l_return_status VARCHAR2(1);
545: l_ic_item_mst_rec ic_item_mst%ROWTYPE;
546: l_ic_item_cpg_rec ic_item_cpg%ROWTYPE;
547: --B965832(1) Add these 2 variables
548: l_lot_status ic_item_mst.lot_status%TYPE;
549: l_qc_grade ic_item_mst.qc_grade%TYPE;

Line 548: l_lot_status ic_item_mst.lot_status%TYPE;

544: l_return_status VARCHAR2(1);
545: l_ic_item_mst_rec ic_item_mst%ROWTYPE;
546: l_ic_item_cpg_rec ic_item_cpg%ROWTYPE;
547: --B965832(1) Add these 2 variables
548: l_lot_status ic_item_mst.lot_status%TYPE;
549: l_qc_grade ic_item_mst.qc_grade%TYPE;
550:
551: BEGIN
552:

Line 549: l_qc_grade ic_item_mst.qc_grade%TYPE;

545: l_ic_item_mst_rec ic_item_mst%ROWTYPE;
546: l_ic_item_cpg_rec ic_item_cpg%ROWTYPE;
547: --B965832(1) Add these 2 variables
548: l_lot_status ic_item_mst.lot_status%TYPE;
549: l_qc_grade ic_item_mst.qc_grade%TYPE;
550:
551: BEGIN
552:
553:

Line 1044: , x_ic_item_mst => l_ic_item_mst_rec

1040: RAISE FND_API.G_EXC_ERROR;
1041: ELSIF (p_item_rec.qcitem_no <> ' ' AND p_item_rec.qcitem_no IS NOT NULL)
1042: THEN
1043: GMI_GLOBAL_GRP.Get_Item ( p_item_no => p_item_rec.qcitem_no
1044: , x_ic_item_mst => l_ic_item_mst_rec
1045:
1046: , x_ic_item_cpg => l_ic_item_cpg_rec
1047: );
1048: IF (l_ic_item_mst_rec.item_id < 0)

Line 1048: IF (l_ic_item_mst_rec.item_id < 0)

1044: , x_ic_item_mst => l_ic_item_mst_rec
1045:
1046: , x_ic_item_cpg => l_ic_item_cpg_rec
1047: );
1048: IF (l_ic_item_mst_rec.item_id < 0)
1049: THEN
1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1051: ELSIF (l_ic_item_mst_rec.item_id = 0) OR
1052: (l_ic_item_mst_rec.delete_mark = 1)

Line 1051: ELSIF (l_ic_item_mst_rec.item_id = 0) OR

1047: );
1048: IF (l_ic_item_mst_rec.item_id < 0)
1049: THEN
1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1051: ELSIF (l_ic_item_mst_rec.item_id = 0) OR
1052: (l_ic_item_mst_rec.delete_mark = 1)
1053: THEN
1054: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QCITEM_NO');
1055: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

Line 1052: (l_ic_item_mst_rec.delete_mark = 1)

1048: IF (l_ic_item_mst_rec.item_id < 0)
1049: THEN
1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1051: ELSIF (l_ic_item_mst_rec.item_id = 0) OR
1052: (l_ic_item_mst_rec.delete_mark = 1)
1053: THEN
1054: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QCITEM_NO');
1055: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1056: FND_MSG_PUB.Add;

Line 1058: ELSIF (l_ic_item_mst_rec.noninv_ind = 1)

1054: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QCITEM_NO');
1055: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1056: FND_MSG_PUB.Add;
1057: RAISE FND_API.G_EXC_ERROR;
1058: ELSIF (l_ic_item_mst_rec.noninv_ind = 1)
1059:
1060: THEN
1061: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');
1062: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

Line 1065: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)

1061: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');
1062: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1063: FND_MSG_PUB.Add;
1064: RAISE FND_API.G_EXC_ERROR;
1065: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)
1066: THEN
1067: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');
1068: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1069: FND_MSG_PUB.Add;

Line 1120: , x_ic_item_mst => l_ic_item_mst_rec

1116:
1117: IF (p_item_rec.whse_item_no <> ' ' AND p_item_rec.whse_item_no IS NOT NULL)
1118: THEN
1119: GMI_GLOBAL_GRP.Get_Item ( p_item_no => p_item_rec.whse_item_no
1120: , x_ic_item_mst => l_ic_item_mst_rec
1121: , x_ic_item_cpg => l_ic_item_cpg_rec
1122: );
1123: IF (l_ic_item_mst_rec.item_id < 0)
1124: THEN

Line 1123: IF (l_ic_item_mst_rec.item_id < 0)

1119: GMI_GLOBAL_GRP.Get_Item ( p_item_no => p_item_rec.whse_item_no
1120: , x_ic_item_mst => l_ic_item_mst_rec
1121: , x_ic_item_cpg => l_ic_item_cpg_rec
1122: );
1123: IF (l_ic_item_mst_rec.item_id < 0)
1124: THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: ELSIF (l_ic_item_mst_rec.item_id = 0) OR
1127: (l_ic_item_mst_rec.delete_mark = 1)

Line 1126: ELSIF (l_ic_item_mst_rec.item_id = 0) OR

1122: );
1123: IF (l_ic_item_mst_rec.item_id < 0)
1124: THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: ELSIF (l_ic_item_mst_rec.item_id = 0) OR
1127: (l_ic_item_mst_rec.delete_mark = 1)
1128: THEN
1129:
1130: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_ITEM_NO');

Line 1127: (l_ic_item_mst_rec.delete_mark = 1)

1123: IF (l_ic_item_mst_rec.item_id < 0)
1124: THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: ELSIF (l_ic_item_mst_rec.item_id = 0) OR
1127: (l_ic_item_mst_rec.delete_mark = 1)
1128: THEN
1129:
1130: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_ITEM_NO');
1131: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

Line 1134: ELSIF (l_ic_item_mst_rec.noninv_ind = 1)

1130: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_ITEM_NO');
1131: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1132: FND_MSG_PUB.Add;
1133: RAISE FND_API.G_EXC_ERROR;
1134: ELSIF (l_ic_item_mst_rec.noninv_ind = 1)
1135: THEN
1136: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');
1137: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1138: FND_MSG_PUB.Add;

Line 1140: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)

1136: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');
1137: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1138: FND_MSG_PUB.Add;
1139: RAISE FND_API.G_EXC_ERROR;
1140: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)
1141: THEN
1142: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');
1143:
1144: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);