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_QUANTITY_PUB dependencies on IC_ADJS_JNL

Line 86: l_doc_id ic_adjs_jnl.doc_id%TYPE;

82: l_lot_id ic_lots_mst.lot_id%TYPE DEFAULT 0;
83: l_old_qc_grade qc_grad_mst.qc_grade%TYPE;
84: l_old_lot_status ic_lots_sts.lot_status%TYPE;
85: l_journal_id ic_jrnl_mst.journal_id%TYPE;
86: l_doc_id ic_adjs_jnl.doc_id%TYPE;
87: l_line_id ic_tran_cmp.line_id%TYPE;
88: l_trans_rec trans_rec_typ;
89: l_loop_ctr NUMBER(2);
90: l_num_rows NUMBER(2);

Line 95: l_ic_adjs_jnl_rec ic_adjs_jnl%ROWTYPE;

91: l_msg_count NUMBER :=0;
92: l_msg_data VARCHAR2(2000);
93: l_return_status VARCHAR2(1);
94: l_ic_jrnl_mst_rec ic_jrnl_mst%ROWTYPE;
95: l_ic_adjs_jnl_rec ic_adjs_jnl%ROWTYPE;
96: l_lot_rec GMI_LOTS_PUB.lot_rec_typ;
97: l_cmp_tran_rec GMI_CMP_TRAN_PVT.cmp_tran_typ;
98: l_user_name fnd_user.user_name%TYPE DEFAULT 'OPM';
99: l_user_id fnd_user.user_id%TYPE;

Line 220: -- Write transactions to ic_adjs_jnl

216: THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;
219:
220: -- Write transactions to ic_adjs_jnl
221: -- First get the surrogate key (doc_id) for the transaction.
222: SELECT gem5_doc_id_s.nextval INTO l_doc_id FROM dual;
223: IF (l_doc_id <=0)
224: THEN

Line 232: -- ic_adjs_jnl. If Move, Change lot status or Change

228: RAISE FND_API.G_EXC_ERROR;
229: END IF;
230:
231: -- If create or Adjust transaction then insert 1 row to
232: -- ic_adjs_jnl. If Move, Change lot status or Change
233: -- QC Grade then need to insert 2 rows into ic_adjs_jnl.
234:
235: IF (l_trans_rec.trans_type <= 2)
236: THEN

Line 233: -- QC Grade then need to insert 2 rows into ic_adjs_jnl.

229: END IF;
230:
231: -- If create or Adjust transaction then insert 1 row to
232: -- ic_adjs_jnl. If Move, Change lot status or Change
233: -- QC Grade then need to insert 2 rows into ic_adjs_jnl.
234:
235: IF (l_trans_rec.trans_type <= 2)
236: THEN
237: l_num_rows := 1;

Line 244: -- Set up PL/SQL record and insert row into ic_adjs_jnl

240: END IF;
241:
242: FOR l_loop_ctr IN 1..l_num_rows LOOP
243:
244: -- Set up PL/SQL record and insert row into ic_adjs_jnl
245: -- Get the surrogate key (line_id) for the line except for
246: -- 'New' QC grade and lot status changes where the line_id
247: -- is duplicated.
248:

Line 263: l_ic_adjs_jnl_rec.trans_type :='CREI';

259: END IF;
260:
261: IF (l_trans_rec.trans_type = 1)
262: THEN
263: l_ic_adjs_jnl_rec.trans_type :='CREI';
264: ELSIF (l_trans_rec.trans_type = 2)
265: THEN
266: l_ic_adjs_jnl_rec.trans_type :='ADJI';
267: ELSIF (l_trans_rec.trans_type = 3)

Line 266: l_ic_adjs_jnl_rec.trans_type :='ADJI';

262: THEN
263: l_ic_adjs_jnl_rec.trans_type :='CREI';
264: ELSIF (l_trans_rec.trans_type = 2)
265: THEN
266: l_ic_adjs_jnl_rec.trans_type :='ADJI';
267: ELSIF (l_trans_rec.trans_type = 3)
268: THEN
269: l_ic_adjs_jnl_rec.trans_type :='TRNI';
270: ELSIF (l_trans_rec.trans_type = 4)

Line 269: l_ic_adjs_jnl_rec.trans_type :='TRNI';

265: THEN
266: l_ic_adjs_jnl_rec.trans_type :='ADJI';
267: ELSIF (l_trans_rec.trans_type = 3)
268: THEN
269: l_ic_adjs_jnl_rec.trans_type :='TRNI';
270: ELSIF (l_trans_rec.trans_type = 4)
271: THEN
272: l_ic_adjs_jnl_rec.trans_type :='STSI';
273: ELSIF (l_trans_rec.trans_type = 5)

Line 272: l_ic_adjs_jnl_rec.trans_type :='STSI';

268: THEN
269: l_ic_adjs_jnl_rec.trans_type :='TRNI';
270: ELSIF (l_trans_rec.trans_type = 4)
271: THEN
272: l_ic_adjs_jnl_rec.trans_type :='STSI';
273: ELSIF (l_trans_rec.trans_type = 5)
274: THEN
275: l_ic_adjs_jnl_rec.trans_type :='GRDI';
276: END IF;

Line 275: l_ic_adjs_jnl_rec.trans_type :='GRDI';

271: THEN
272: l_ic_adjs_jnl_rec.trans_type :='STSI';
273: ELSIF (l_trans_rec.trans_type = 5)
274: THEN
275: l_ic_adjs_jnl_rec.trans_type :='GRDI';
276: END IF;
277:
278: l_ic_adjs_jnl_rec.trans_flag := 0;
279: l_ic_adjs_jnl_rec.doc_id := l_doc_id;

Line 278: l_ic_adjs_jnl_rec.trans_flag := 0;

274: THEN
275: l_ic_adjs_jnl_rec.trans_type :='GRDI';
276: END IF;
277:
278: l_ic_adjs_jnl_rec.trans_flag := 0;
279: l_ic_adjs_jnl_rec.doc_id := l_doc_id;
280: l_ic_adjs_jnl_rec.doc_line := l_loop_ctr;
281: l_ic_adjs_jnl_rec.journal_id := l_journal_id;
282: l_ic_adjs_jnl_rec.completed_ind := 1;

Line 279: l_ic_adjs_jnl_rec.doc_id := l_doc_id;

275: l_ic_adjs_jnl_rec.trans_type :='GRDI';
276: END IF;
277:
278: l_ic_adjs_jnl_rec.trans_flag := 0;
279: l_ic_adjs_jnl_rec.doc_id := l_doc_id;
280: l_ic_adjs_jnl_rec.doc_line := l_loop_ctr;
281: l_ic_adjs_jnl_rec.journal_id := l_journal_id;
282: l_ic_adjs_jnl_rec.completed_ind := 1;
283: l_ic_adjs_jnl_rec.reason_code := l_trans_rec.reason_code;

Line 280: l_ic_adjs_jnl_rec.doc_line := l_loop_ctr;

276: END IF;
277:
278: l_ic_adjs_jnl_rec.trans_flag := 0;
279: l_ic_adjs_jnl_rec.doc_id := l_doc_id;
280: l_ic_adjs_jnl_rec.doc_line := l_loop_ctr;
281: l_ic_adjs_jnl_rec.journal_id := l_journal_id;
282: l_ic_adjs_jnl_rec.completed_ind := 1;
283: l_ic_adjs_jnl_rec.reason_code := l_trans_rec.reason_code;
284: l_ic_adjs_jnl_rec.doc_date := l_trans_rec.trans_date;

Line 281: l_ic_adjs_jnl_rec.journal_id := l_journal_id;

277:
278: l_ic_adjs_jnl_rec.trans_flag := 0;
279: l_ic_adjs_jnl_rec.doc_id := l_doc_id;
280: l_ic_adjs_jnl_rec.doc_line := l_loop_ctr;
281: l_ic_adjs_jnl_rec.journal_id := l_journal_id;
282: l_ic_adjs_jnl_rec.completed_ind := 1;
283: l_ic_adjs_jnl_rec.reason_code := l_trans_rec.reason_code;
284: l_ic_adjs_jnl_rec.doc_date := l_trans_rec.trans_date;
285: l_ic_adjs_jnl_rec.item_id := l_item_id;

Line 282: l_ic_adjs_jnl_rec.completed_ind := 1;

278: l_ic_adjs_jnl_rec.trans_flag := 0;
279: l_ic_adjs_jnl_rec.doc_id := l_doc_id;
280: l_ic_adjs_jnl_rec.doc_line := l_loop_ctr;
281: l_ic_adjs_jnl_rec.journal_id := l_journal_id;
282: l_ic_adjs_jnl_rec.completed_ind := 1;
283: l_ic_adjs_jnl_rec.reason_code := l_trans_rec.reason_code;
284: l_ic_adjs_jnl_rec.doc_date := l_trans_rec.trans_date;
285: l_ic_adjs_jnl_rec.item_id := l_item_id;
286: l_ic_adjs_jnl_rec.item_um := l_trans_rec.item_um;

Line 283: l_ic_adjs_jnl_rec.reason_code := l_trans_rec.reason_code;

279: l_ic_adjs_jnl_rec.doc_id := l_doc_id;
280: l_ic_adjs_jnl_rec.doc_line := l_loop_ctr;
281: l_ic_adjs_jnl_rec.journal_id := l_journal_id;
282: l_ic_adjs_jnl_rec.completed_ind := 1;
283: l_ic_adjs_jnl_rec.reason_code := l_trans_rec.reason_code;
284: l_ic_adjs_jnl_rec.doc_date := l_trans_rec.trans_date;
285: l_ic_adjs_jnl_rec.item_id := l_item_id;
286: l_ic_adjs_jnl_rec.item_um := l_trans_rec.item_um;
287: l_ic_adjs_jnl_rec.item_um2 := l_trans_rec.item_um2;

Line 284: l_ic_adjs_jnl_rec.doc_date := l_trans_rec.trans_date;

280: l_ic_adjs_jnl_rec.doc_line := l_loop_ctr;
281: l_ic_adjs_jnl_rec.journal_id := l_journal_id;
282: l_ic_adjs_jnl_rec.completed_ind := 1;
283: l_ic_adjs_jnl_rec.reason_code := l_trans_rec.reason_code;
284: l_ic_adjs_jnl_rec.doc_date := l_trans_rec.trans_date;
285: l_ic_adjs_jnl_rec.item_id := l_item_id;
286: l_ic_adjs_jnl_rec.item_um := l_trans_rec.item_um;
287: l_ic_adjs_jnl_rec.item_um2 := l_trans_rec.item_um2;
288: l_ic_adjs_jnl_rec.lot_id := l_lot_id;

Line 285: l_ic_adjs_jnl_rec.item_id := l_item_id;

281: l_ic_adjs_jnl_rec.journal_id := l_journal_id;
282: l_ic_adjs_jnl_rec.completed_ind := 1;
283: l_ic_adjs_jnl_rec.reason_code := l_trans_rec.reason_code;
284: l_ic_adjs_jnl_rec.doc_date := l_trans_rec.trans_date;
285: l_ic_adjs_jnl_rec.item_id := l_item_id;
286: l_ic_adjs_jnl_rec.item_um := l_trans_rec.item_um;
287: l_ic_adjs_jnl_rec.item_um2 := l_trans_rec.item_um2;
288: l_ic_adjs_jnl_rec.lot_id := l_lot_id;
289:

Line 286: l_ic_adjs_jnl_rec.item_um := l_trans_rec.item_um;

282: l_ic_adjs_jnl_rec.completed_ind := 1;
283: l_ic_adjs_jnl_rec.reason_code := l_trans_rec.reason_code;
284: l_ic_adjs_jnl_rec.doc_date := l_trans_rec.trans_date;
285: l_ic_adjs_jnl_rec.item_id := l_item_id;
286: l_ic_adjs_jnl_rec.item_um := l_trans_rec.item_um;
287: l_ic_adjs_jnl_rec.item_um2 := l_trans_rec.item_um2;
288: l_ic_adjs_jnl_rec.lot_id := l_lot_id;
289:
290:

Line 287: l_ic_adjs_jnl_rec.item_um2 := l_trans_rec.item_um2;

283: l_ic_adjs_jnl_rec.reason_code := l_trans_rec.reason_code;
284: l_ic_adjs_jnl_rec.doc_date := l_trans_rec.trans_date;
285: l_ic_adjs_jnl_rec.item_id := l_item_id;
286: l_ic_adjs_jnl_rec.item_um := l_trans_rec.item_um;
287: l_ic_adjs_jnl_rec.item_um2 := l_trans_rec.item_um2;
288: l_ic_adjs_jnl_rec.lot_id := l_lot_id;
289:
290:
291: -- For Move , QC Grade and lot Status change set values according

Line 288: l_ic_adjs_jnl_rec.lot_id := l_lot_id;

284: l_ic_adjs_jnl_rec.doc_date := l_trans_rec.trans_date;
285: l_ic_adjs_jnl_rec.item_id := l_item_id;
286: l_ic_adjs_jnl_rec.item_um := l_trans_rec.item_um;
287: l_ic_adjs_jnl_rec.item_um2 := l_trans_rec.item_um2;
288: l_ic_adjs_jnl_rec.lot_id := l_lot_id;
289:
290:
291: -- For Move , QC Grade and lot Status change set values according
292: -- to 'Old' and 'New' transaction.

Line 295: l_ic_adjs_jnl_rec.whse_code := l_trans_rec.from_whse_code;

291: -- For Move , QC Grade and lot Status change set values according
292: -- to 'Old' and 'New' transaction.
293: IF (l_loop_ctr = 1)
294: THEN
295: l_ic_adjs_jnl_rec.whse_code := l_trans_rec.from_whse_code;
296: l_ic_adjs_jnl_rec.location := l_trans_rec.from_location;
297: l_ic_adjs_jnl_rec.qc_grade := l_old_qc_grade;
298: l_ic_adjs_jnl_rec.lot_status := l_old_lot_status;
299: IF (l_trans_rec.trans_type < 3)

Line 296: l_ic_adjs_jnl_rec.location := l_trans_rec.from_location;

292: -- to 'Old' and 'New' transaction.
293: IF (l_loop_ctr = 1)
294: THEN
295: l_ic_adjs_jnl_rec.whse_code := l_trans_rec.from_whse_code;
296: l_ic_adjs_jnl_rec.location := l_trans_rec.from_location;
297: l_ic_adjs_jnl_rec.qc_grade := l_old_qc_grade;
298: l_ic_adjs_jnl_rec.lot_status := l_old_lot_status;
299: IF (l_trans_rec.trans_type < 3)
300: THEN

Line 297: l_ic_adjs_jnl_rec.qc_grade := l_old_qc_grade;

293: IF (l_loop_ctr = 1)
294: THEN
295: l_ic_adjs_jnl_rec.whse_code := l_trans_rec.from_whse_code;
296: l_ic_adjs_jnl_rec.location := l_trans_rec.from_location;
297: l_ic_adjs_jnl_rec.qc_grade := l_old_qc_grade;
298: l_ic_adjs_jnl_rec.lot_status := l_old_lot_status;
299: IF (l_trans_rec.trans_type < 3)
300: THEN
301: l_ic_adjs_jnl_rec.qty := l_trans_rec.trans_qty;

Line 298: l_ic_adjs_jnl_rec.lot_status := l_old_lot_status;

294: THEN
295: l_ic_adjs_jnl_rec.whse_code := l_trans_rec.from_whse_code;
296: l_ic_adjs_jnl_rec.location := l_trans_rec.from_location;
297: l_ic_adjs_jnl_rec.qc_grade := l_old_qc_grade;
298: l_ic_adjs_jnl_rec.lot_status := l_old_lot_status;
299: IF (l_trans_rec.trans_type < 3)
300: THEN
301: l_ic_adjs_jnl_rec.qty := l_trans_rec.trans_qty;
302: l_ic_adjs_jnl_rec.qty2 := l_trans_rec.trans_qty2;

Line 301: l_ic_adjs_jnl_rec.qty := l_trans_rec.trans_qty;

297: l_ic_adjs_jnl_rec.qc_grade := l_old_qc_grade;
298: l_ic_adjs_jnl_rec.lot_status := l_old_lot_status;
299: IF (l_trans_rec.trans_type < 3)
300: THEN
301: l_ic_adjs_jnl_rec.qty := l_trans_rec.trans_qty;
302: l_ic_adjs_jnl_rec.qty2 := l_trans_rec.trans_qty2;
303: l_ic_adjs_jnl_rec.line_type := 0;
304: -- 02/06/99 Add this here, to get the correct lot status for
305: -- Create and Adjust

Line 302: l_ic_adjs_jnl_rec.qty2 := l_trans_rec.trans_qty2;

298: l_ic_adjs_jnl_rec.lot_status := l_old_lot_status;
299: IF (l_trans_rec.trans_type < 3)
300: THEN
301: l_ic_adjs_jnl_rec.qty := l_trans_rec.trans_qty;
302: l_ic_adjs_jnl_rec.qty2 := l_trans_rec.trans_qty2;
303: l_ic_adjs_jnl_rec.line_type := 0;
304: -- 02/06/99 Add this here, to get the correct lot status for
305: -- Create and Adjust
306: l_ic_adjs_jnl_rec.lot_status := l_trans_rec.lot_status;

Line 303: l_ic_adjs_jnl_rec.line_type := 0;

299: IF (l_trans_rec.trans_type < 3)
300: THEN
301: l_ic_adjs_jnl_rec.qty := l_trans_rec.trans_qty;
302: l_ic_adjs_jnl_rec.qty2 := l_trans_rec.trans_qty2;
303: l_ic_adjs_jnl_rec.line_type := 0;
304: -- 02/06/99 Add this here, to get the correct lot status for
305: -- Create and Adjust
306: l_ic_adjs_jnl_rec.lot_status := l_trans_rec.lot_status;
307: ELSE

Line 306: l_ic_adjs_jnl_rec.lot_status := l_trans_rec.lot_status;

302: l_ic_adjs_jnl_rec.qty2 := l_trans_rec.trans_qty2;
303: l_ic_adjs_jnl_rec.line_type := 0;
304: -- 02/06/99 Add this here, to get the correct lot status for
305: -- Create and Adjust
306: l_ic_adjs_jnl_rec.lot_status := l_trans_rec.lot_status;
307: ELSE
308: l_ic_adjs_jnl_rec.qty := 0 - l_trans_rec.trans_qty;
309: l_ic_adjs_jnl_rec.qty2 := 0 - l_trans_rec.trans_qty2;
310: l_ic_adjs_jnl_rec.line_type := -1;

Line 308: l_ic_adjs_jnl_rec.qty := 0 - l_trans_rec.trans_qty;

304: -- 02/06/99 Add this here, to get the correct lot status for
305: -- Create and Adjust
306: l_ic_adjs_jnl_rec.lot_status := l_trans_rec.lot_status;
307: ELSE
308: l_ic_adjs_jnl_rec.qty := 0 - l_trans_rec.trans_qty;
309: l_ic_adjs_jnl_rec.qty2 := 0 - l_trans_rec.trans_qty2;
310: l_ic_adjs_jnl_rec.line_type := -1;
311: END IF;
312: ELSE

Line 309: l_ic_adjs_jnl_rec.qty2 := 0 - l_trans_rec.trans_qty2;

305: -- Create and Adjust
306: l_ic_adjs_jnl_rec.lot_status := l_trans_rec.lot_status;
307: ELSE
308: l_ic_adjs_jnl_rec.qty := 0 - l_trans_rec.trans_qty;
309: l_ic_adjs_jnl_rec.qty2 := 0 - l_trans_rec.trans_qty2;
310: l_ic_adjs_jnl_rec.line_type := -1;
311: END IF;
312: ELSE
313: l_ic_adjs_jnl_rec.whse_code := l_trans_rec.to_whse_code;

Line 310: l_ic_adjs_jnl_rec.line_type := -1;

306: l_ic_adjs_jnl_rec.lot_status := l_trans_rec.lot_status;
307: ELSE
308: l_ic_adjs_jnl_rec.qty := 0 - l_trans_rec.trans_qty;
309: l_ic_adjs_jnl_rec.qty2 := 0 - l_trans_rec.trans_qty2;
310: l_ic_adjs_jnl_rec.line_type := -1;
311: END IF;
312: ELSE
313: l_ic_adjs_jnl_rec.whse_code := l_trans_rec.to_whse_code;
314: l_ic_adjs_jnl_rec.location := l_trans_rec.to_location;

Line 313: l_ic_adjs_jnl_rec.whse_code := l_trans_rec.to_whse_code;

309: l_ic_adjs_jnl_rec.qty2 := 0 - l_trans_rec.trans_qty2;
310: l_ic_adjs_jnl_rec.line_type := -1;
311: END IF;
312: ELSE
313: l_ic_adjs_jnl_rec.whse_code := l_trans_rec.to_whse_code;
314: l_ic_adjs_jnl_rec.location := l_trans_rec.to_location;
315: l_ic_adjs_jnl_rec.qty := l_trans_rec.trans_qty;
316: l_ic_adjs_jnl_rec.qty2 := l_trans_rec.trans_qty2;
317: l_ic_adjs_jnl_rec.qc_grade := l_trans_rec.qc_grade;

Line 314: l_ic_adjs_jnl_rec.location := l_trans_rec.to_location;

310: l_ic_adjs_jnl_rec.line_type := -1;
311: END IF;
312: ELSE
313: l_ic_adjs_jnl_rec.whse_code := l_trans_rec.to_whse_code;
314: l_ic_adjs_jnl_rec.location := l_trans_rec.to_location;
315: l_ic_adjs_jnl_rec.qty := l_trans_rec.trans_qty;
316: l_ic_adjs_jnl_rec.qty2 := l_trans_rec.trans_qty2;
317: l_ic_adjs_jnl_rec.qc_grade := l_trans_rec.qc_grade;
318: l_ic_adjs_jnl_rec.lot_status := l_trans_rec.lot_status;

Line 315: l_ic_adjs_jnl_rec.qty := l_trans_rec.trans_qty;

311: END IF;
312: ELSE
313: l_ic_adjs_jnl_rec.whse_code := l_trans_rec.to_whse_code;
314: l_ic_adjs_jnl_rec.location := l_trans_rec.to_location;
315: l_ic_adjs_jnl_rec.qty := l_trans_rec.trans_qty;
316: l_ic_adjs_jnl_rec.qty2 := l_trans_rec.trans_qty2;
317: l_ic_adjs_jnl_rec.qc_grade := l_trans_rec.qc_grade;
318: l_ic_adjs_jnl_rec.lot_status := l_trans_rec.lot_status;
319: l_ic_adjs_jnl_rec.line_type := 1;

Line 316: l_ic_adjs_jnl_rec.qty2 := l_trans_rec.trans_qty2;

312: ELSE
313: l_ic_adjs_jnl_rec.whse_code := l_trans_rec.to_whse_code;
314: l_ic_adjs_jnl_rec.location := l_trans_rec.to_location;
315: l_ic_adjs_jnl_rec.qty := l_trans_rec.trans_qty;
316: l_ic_adjs_jnl_rec.qty2 := l_trans_rec.trans_qty2;
317: l_ic_adjs_jnl_rec.qc_grade := l_trans_rec.qc_grade;
318: l_ic_adjs_jnl_rec.lot_status := l_trans_rec.lot_status;
319: l_ic_adjs_jnl_rec.line_type := 1;
320: END IF;

Line 317: l_ic_adjs_jnl_rec.qc_grade := l_trans_rec.qc_grade;

313: l_ic_adjs_jnl_rec.whse_code := l_trans_rec.to_whse_code;
314: l_ic_adjs_jnl_rec.location := l_trans_rec.to_location;
315: l_ic_adjs_jnl_rec.qty := l_trans_rec.trans_qty;
316: l_ic_adjs_jnl_rec.qty2 := l_trans_rec.trans_qty2;
317: l_ic_adjs_jnl_rec.qc_grade := l_trans_rec.qc_grade;
318: l_ic_adjs_jnl_rec.lot_status := l_trans_rec.lot_status;
319: l_ic_adjs_jnl_rec.line_type := 1;
320: END IF;
321:

Line 318: l_ic_adjs_jnl_rec.lot_status := l_trans_rec.lot_status;

314: l_ic_adjs_jnl_rec.location := l_trans_rec.to_location;
315: l_ic_adjs_jnl_rec.qty := l_trans_rec.trans_qty;
316: l_ic_adjs_jnl_rec.qty2 := l_trans_rec.trans_qty2;
317: l_ic_adjs_jnl_rec.qc_grade := l_trans_rec.qc_grade;
318: l_ic_adjs_jnl_rec.lot_status := l_trans_rec.lot_status;
319: l_ic_adjs_jnl_rec.line_type := 1;
320: END IF;
321:
322: l_ic_adjs_jnl_rec.line_id := l_line_id;

Line 319: l_ic_adjs_jnl_rec.line_type := 1;

315: l_ic_adjs_jnl_rec.qty := l_trans_rec.trans_qty;
316: l_ic_adjs_jnl_rec.qty2 := l_trans_rec.trans_qty2;
317: l_ic_adjs_jnl_rec.qc_grade := l_trans_rec.qc_grade;
318: l_ic_adjs_jnl_rec.lot_status := l_trans_rec.lot_status;
319: l_ic_adjs_jnl_rec.line_type := 1;
320: END IF;
321:
322: l_ic_adjs_jnl_rec.line_id := l_line_id;
323: l_ic_adjs_jnl_rec.co_code := l_trans_rec.co_code;

Line 322: l_ic_adjs_jnl_rec.line_id := l_line_id;

318: l_ic_adjs_jnl_rec.lot_status := l_trans_rec.lot_status;
319: l_ic_adjs_jnl_rec.line_type := 1;
320: END IF;
321:
322: l_ic_adjs_jnl_rec.line_id := l_line_id;
323: l_ic_adjs_jnl_rec.co_code := l_trans_rec.co_code;
324: l_ic_adjs_jnl_rec.orgn_code := l_trans_rec.orgn_code;
325: l_ic_adjs_jnl_rec.no_inv := 0;
326: l_ic_adjs_jnl_rec.no_trans := 0;

Line 323: l_ic_adjs_jnl_rec.co_code := l_trans_rec.co_code;

319: l_ic_adjs_jnl_rec.line_type := 1;
320: END IF;
321:
322: l_ic_adjs_jnl_rec.line_id := l_line_id;
323: l_ic_adjs_jnl_rec.co_code := l_trans_rec.co_code;
324: l_ic_adjs_jnl_rec.orgn_code := l_trans_rec.orgn_code;
325: l_ic_adjs_jnl_rec.no_inv := 0;
326: l_ic_adjs_jnl_rec.no_trans := 0;
327: l_ic_adjs_jnl_rec.creation_date := SYSDATE;

Line 324: l_ic_adjs_jnl_rec.orgn_code := l_trans_rec.orgn_code;

320: END IF;
321:
322: l_ic_adjs_jnl_rec.line_id := l_line_id;
323: l_ic_adjs_jnl_rec.co_code := l_trans_rec.co_code;
324: l_ic_adjs_jnl_rec.orgn_code := l_trans_rec.orgn_code;
325: l_ic_adjs_jnl_rec.no_inv := 0;
326: l_ic_adjs_jnl_rec.no_trans := 0;
327: l_ic_adjs_jnl_rec.creation_date := SYSDATE;
328: l_ic_adjs_jnl_rec.created_by := l_user_id;

Line 325: l_ic_adjs_jnl_rec.no_inv := 0;

321:
322: l_ic_adjs_jnl_rec.line_id := l_line_id;
323: l_ic_adjs_jnl_rec.co_code := l_trans_rec.co_code;
324: l_ic_adjs_jnl_rec.orgn_code := l_trans_rec.orgn_code;
325: l_ic_adjs_jnl_rec.no_inv := 0;
326: l_ic_adjs_jnl_rec.no_trans := 0;
327: l_ic_adjs_jnl_rec.creation_date := SYSDATE;
328: l_ic_adjs_jnl_rec.created_by := l_user_id;
329: l_ic_adjs_jnl_rec.last_update_date := SYSDATE;

Line 326: l_ic_adjs_jnl_rec.no_trans := 0;

322: l_ic_adjs_jnl_rec.line_id := l_line_id;
323: l_ic_adjs_jnl_rec.co_code := l_trans_rec.co_code;
324: l_ic_adjs_jnl_rec.orgn_code := l_trans_rec.orgn_code;
325: l_ic_adjs_jnl_rec.no_inv := 0;
326: l_ic_adjs_jnl_rec.no_trans := 0;
327: l_ic_adjs_jnl_rec.creation_date := SYSDATE;
328: l_ic_adjs_jnl_rec.created_by := l_user_id;
329: l_ic_adjs_jnl_rec.last_update_date := SYSDATE;
330: l_ic_adjs_jnl_rec.trans_cnt := 0;

Line 327: l_ic_adjs_jnl_rec.creation_date := SYSDATE;

323: l_ic_adjs_jnl_rec.co_code := l_trans_rec.co_code;
324: l_ic_adjs_jnl_rec.orgn_code := l_trans_rec.orgn_code;
325: l_ic_adjs_jnl_rec.no_inv := 0;
326: l_ic_adjs_jnl_rec.no_trans := 0;
327: l_ic_adjs_jnl_rec.creation_date := SYSDATE;
328: l_ic_adjs_jnl_rec.created_by := l_user_id;
329: l_ic_adjs_jnl_rec.last_update_date := SYSDATE;
330: l_ic_adjs_jnl_rec.trans_cnt := 0;
331: l_ic_adjs_jnl_rec.last_updated_by := l_user_id;

Line 328: l_ic_adjs_jnl_rec.created_by := l_user_id;

324: l_ic_adjs_jnl_rec.orgn_code := l_trans_rec.orgn_code;
325: l_ic_adjs_jnl_rec.no_inv := 0;
326: l_ic_adjs_jnl_rec.no_trans := 0;
327: l_ic_adjs_jnl_rec.creation_date := SYSDATE;
328: l_ic_adjs_jnl_rec.created_by := l_user_id;
329: l_ic_adjs_jnl_rec.last_update_date := SYSDATE;
330: l_ic_adjs_jnl_rec.trans_cnt := 0;
331: l_ic_adjs_jnl_rec.last_updated_by := l_user_id;
332: l_ic_adjs_jnl_rec.program_application_id :=NULL;

Line 329: l_ic_adjs_jnl_rec.last_update_date := SYSDATE;

325: l_ic_adjs_jnl_rec.no_inv := 0;
326: l_ic_adjs_jnl_rec.no_trans := 0;
327: l_ic_adjs_jnl_rec.creation_date := SYSDATE;
328: l_ic_adjs_jnl_rec.created_by := l_user_id;
329: l_ic_adjs_jnl_rec.last_update_date := SYSDATE;
330: l_ic_adjs_jnl_rec.trans_cnt := 0;
331: l_ic_adjs_jnl_rec.last_updated_by := l_user_id;
332: l_ic_adjs_jnl_rec.program_application_id :=NULL;
333: l_ic_adjs_jnl_rec.program_id := NULL;

Line 330: l_ic_adjs_jnl_rec.trans_cnt := 0;

326: l_ic_adjs_jnl_rec.no_trans := 0;
327: l_ic_adjs_jnl_rec.creation_date := SYSDATE;
328: l_ic_adjs_jnl_rec.created_by := l_user_id;
329: l_ic_adjs_jnl_rec.last_update_date := SYSDATE;
330: l_ic_adjs_jnl_rec.trans_cnt := 0;
331: l_ic_adjs_jnl_rec.last_updated_by := l_user_id;
332: l_ic_adjs_jnl_rec.program_application_id :=NULL;
333: l_ic_adjs_jnl_rec.program_id := NULL;
334: l_ic_adjs_jnl_rec.program_update_date := SYSDATE;

Line 331: l_ic_adjs_jnl_rec.last_updated_by := l_user_id;

327: l_ic_adjs_jnl_rec.creation_date := SYSDATE;
328: l_ic_adjs_jnl_rec.created_by := l_user_id;
329: l_ic_adjs_jnl_rec.last_update_date := SYSDATE;
330: l_ic_adjs_jnl_rec.trans_cnt := 0;
331: l_ic_adjs_jnl_rec.last_updated_by := l_user_id;
332: l_ic_adjs_jnl_rec.program_application_id :=NULL;
333: l_ic_adjs_jnl_rec.program_id := NULL;
334: l_ic_adjs_jnl_rec.program_update_date := SYSDATE;
335: l_ic_adjs_jnl_rec.request_id := NULL;

Line 332: l_ic_adjs_jnl_rec.program_application_id :=NULL;

328: l_ic_adjs_jnl_rec.created_by := l_user_id;
329: l_ic_adjs_jnl_rec.last_update_date := SYSDATE;
330: l_ic_adjs_jnl_rec.trans_cnt := 0;
331: l_ic_adjs_jnl_rec.last_updated_by := l_user_id;
332: l_ic_adjs_jnl_rec.program_application_id :=NULL;
333: l_ic_adjs_jnl_rec.program_id := NULL;
334: l_ic_adjs_jnl_rec.program_update_date := SYSDATE;
335: l_ic_adjs_jnl_rec.request_id := NULL;
336: l_ic_adjs_jnl_rec.last_update_login :=l_user_id;

Line 333: l_ic_adjs_jnl_rec.program_id := NULL;

329: l_ic_adjs_jnl_rec.last_update_date := SYSDATE;
330: l_ic_adjs_jnl_rec.trans_cnt := 0;
331: l_ic_adjs_jnl_rec.last_updated_by := l_user_id;
332: l_ic_adjs_jnl_rec.program_application_id :=NULL;
333: l_ic_adjs_jnl_rec.program_id := NULL;
334: l_ic_adjs_jnl_rec.program_update_date := SYSDATE;
335: l_ic_adjs_jnl_rec.request_id := NULL;
336: l_ic_adjs_jnl_rec.last_update_login :=l_user_id;
337:

Line 334: l_ic_adjs_jnl_rec.program_update_date := SYSDATE;

330: l_ic_adjs_jnl_rec.trans_cnt := 0;
331: l_ic_adjs_jnl_rec.last_updated_by := l_user_id;
332: l_ic_adjs_jnl_rec.program_application_id :=NULL;
333: l_ic_adjs_jnl_rec.program_id := NULL;
334: l_ic_adjs_jnl_rec.program_update_date := SYSDATE;
335: l_ic_adjs_jnl_rec.request_id := NULL;
336: l_ic_adjs_jnl_rec.last_update_login :=l_user_id;
337:
338:

Line 335: l_ic_adjs_jnl_rec.request_id := NULL;

331: l_ic_adjs_jnl_rec.last_updated_by := l_user_id;
332: l_ic_adjs_jnl_rec.program_application_id :=NULL;
333: l_ic_adjs_jnl_rec.program_id := NULL;
334: l_ic_adjs_jnl_rec.program_update_date := SYSDATE;
335: l_ic_adjs_jnl_rec.request_id := NULL;
336: l_ic_adjs_jnl_rec.last_update_login :=l_user_id;
337:
338:
339: IF NOT GMI_QUANTITY_PVT.insert_ic_adjs_jnl(l_ic_adjs_jnl_rec)

Line 336: l_ic_adjs_jnl_rec.last_update_login :=l_user_id;

332: l_ic_adjs_jnl_rec.program_application_id :=NULL;
333: l_ic_adjs_jnl_rec.program_id := NULL;
334: l_ic_adjs_jnl_rec.program_update_date := SYSDATE;
335: l_ic_adjs_jnl_rec.request_id := NULL;
336: l_ic_adjs_jnl_rec.last_update_login :=l_user_id;
337:
338:
339: IF NOT GMI_QUANTITY_PVT.insert_ic_adjs_jnl(l_ic_adjs_jnl_rec)
340: THEN

Line 339: IF NOT GMI_QUANTITY_PVT.insert_ic_adjs_jnl(l_ic_adjs_jnl_rec)

335: l_ic_adjs_jnl_rec.request_id := NULL;
336: l_ic_adjs_jnl_rec.last_update_login :=l_user_id;
337:
338:
339: IF NOT GMI_QUANTITY_PVT.insert_ic_adjs_jnl(l_ic_adjs_jnl_rec)
340: THEN
341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
342: END IF;
343:

Line 353: l_cmp_tran_rec.whse_code := l_ic_adjs_jnl_rec.whse_code;

349: l_cmp_tran_rec.line_id := l_line_id;
350: l_cmp_tran_rec.trans_id := 0;
351: l_cmp_tran_rec.co_code := l_trans_rec.co_code;
352: l_cmp_tran_rec.orgn_code := l_trans_rec.orgn_code;
353: l_cmp_tran_rec.whse_code := l_ic_adjs_jnl_rec.whse_code;
354: l_cmp_tran_rec.lot_id := l_lot_id;
355: l_cmp_tran_rec.location := l_ic_adjs_jnl_rec.location;
356: l_cmp_tran_rec.doc_id := l_doc_id;
357: l_cmp_tran_rec.doc_type := l_ic_adjs_jnl_rec.trans_type;

Line 355: l_cmp_tran_rec.location := l_ic_adjs_jnl_rec.location;

351: l_cmp_tran_rec.co_code := l_trans_rec.co_code;
352: l_cmp_tran_rec.orgn_code := l_trans_rec.orgn_code;
353: l_cmp_tran_rec.whse_code := l_ic_adjs_jnl_rec.whse_code;
354: l_cmp_tran_rec.lot_id := l_lot_id;
355: l_cmp_tran_rec.location := l_ic_adjs_jnl_rec.location;
356: l_cmp_tran_rec.doc_id := l_doc_id;
357: l_cmp_tran_rec.doc_type := l_ic_adjs_jnl_rec.trans_type;
358: l_cmp_tran_rec.doc_line := l_ic_adjs_jnl_rec.doc_line;
359: l_cmp_tran_rec.line_type := l_ic_adjs_jnl_rec.line_type;

Line 357: l_cmp_tran_rec.doc_type := l_ic_adjs_jnl_rec.trans_type;

353: l_cmp_tran_rec.whse_code := l_ic_adjs_jnl_rec.whse_code;
354: l_cmp_tran_rec.lot_id := l_lot_id;
355: l_cmp_tran_rec.location := l_ic_adjs_jnl_rec.location;
356: l_cmp_tran_rec.doc_id := l_doc_id;
357: l_cmp_tran_rec.doc_type := l_ic_adjs_jnl_rec.trans_type;
358: l_cmp_tran_rec.doc_line := l_ic_adjs_jnl_rec.doc_line;
359: l_cmp_tran_rec.line_type := l_ic_adjs_jnl_rec.line_type;
360: l_cmp_tran_rec.reason_code := l_ic_adjs_jnl_rec.reason_code;
361: l_cmp_tran_rec.creation_date := SYSDATE;

Line 358: l_cmp_tran_rec.doc_line := l_ic_adjs_jnl_rec.doc_line;

354: l_cmp_tran_rec.lot_id := l_lot_id;
355: l_cmp_tran_rec.location := l_ic_adjs_jnl_rec.location;
356: l_cmp_tran_rec.doc_id := l_doc_id;
357: l_cmp_tran_rec.doc_type := l_ic_adjs_jnl_rec.trans_type;
358: l_cmp_tran_rec.doc_line := l_ic_adjs_jnl_rec.doc_line;
359: l_cmp_tran_rec.line_type := l_ic_adjs_jnl_rec.line_type;
360: l_cmp_tran_rec.reason_code := l_ic_adjs_jnl_rec.reason_code;
361: l_cmp_tran_rec.creation_date := SYSDATE;
362: l_cmp_tran_rec.trans_date := l_ic_adjs_jnl_rec.doc_date;

Line 359: l_cmp_tran_rec.line_type := l_ic_adjs_jnl_rec.line_type;

355: l_cmp_tran_rec.location := l_ic_adjs_jnl_rec.location;
356: l_cmp_tran_rec.doc_id := l_doc_id;
357: l_cmp_tran_rec.doc_type := l_ic_adjs_jnl_rec.trans_type;
358: l_cmp_tran_rec.doc_line := l_ic_adjs_jnl_rec.doc_line;
359: l_cmp_tran_rec.line_type := l_ic_adjs_jnl_rec.line_type;
360: l_cmp_tran_rec.reason_code := l_ic_adjs_jnl_rec.reason_code;
361: l_cmp_tran_rec.creation_date := SYSDATE;
362: l_cmp_tran_rec.trans_date := l_ic_adjs_jnl_rec.doc_date;
363: l_cmp_tran_rec.trans_qty := l_ic_adjs_jnl_rec.qty;

Line 360: l_cmp_tran_rec.reason_code := l_ic_adjs_jnl_rec.reason_code;

356: l_cmp_tran_rec.doc_id := l_doc_id;
357: l_cmp_tran_rec.doc_type := l_ic_adjs_jnl_rec.trans_type;
358: l_cmp_tran_rec.doc_line := l_ic_adjs_jnl_rec.doc_line;
359: l_cmp_tran_rec.line_type := l_ic_adjs_jnl_rec.line_type;
360: l_cmp_tran_rec.reason_code := l_ic_adjs_jnl_rec.reason_code;
361: l_cmp_tran_rec.creation_date := SYSDATE;
362: l_cmp_tran_rec.trans_date := l_ic_adjs_jnl_rec.doc_date;
363: l_cmp_tran_rec.trans_qty := l_ic_adjs_jnl_rec.qty;
364: l_cmp_tran_rec.trans_qty2 := l_ic_adjs_jnl_rec.qty2;

Line 362: l_cmp_tran_rec.trans_date := l_ic_adjs_jnl_rec.doc_date;

358: l_cmp_tran_rec.doc_line := l_ic_adjs_jnl_rec.doc_line;
359: l_cmp_tran_rec.line_type := l_ic_adjs_jnl_rec.line_type;
360: l_cmp_tran_rec.reason_code := l_ic_adjs_jnl_rec.reason_code;
361: l_cmp_tran_rec.creation_date := SYSDATE;
362: l_cmp_tran_rec.trans_date := l_ic_adjs_jnl_rec.doc_date;
363: l_cmp_tran_rec.trans_qty := l_ic_adjs_jnl_rec.qty;
364: l_cmp_tran_rec.trans_qty2 := l_ic_adjs_jnl_rec.qty2;
365: l_cmp_tran_rec.qc_grade := l_ic_adjs_jnl_rec.qc_grade;
366: l_cmp_tran_rec.lot_status := l_ic_adjs_jnl_rec.lot_status;

Line 363: l_cmp_tran_rec.trans_qty := l_ic_adjs_jnl_rec.qty;

359: l_cmp_tran_rec.line_type := l_ic_adjs_jnl_rec.line_type;
360: l_cmp_tran_rec.reason_code := l_ic_adjs_jnl_rec.reason_code;
361: l_cmp_tran_rec.creation_date := SYSDATE;
362: l_cmp_tran_rec.trans_date := l_ic_adjs_jnl_rec.doc_date;
363: l_cmp_tran_rec.trans_qty := l_ic_adjs_jnl_rec.qty;
364: l_cmp_tran_rec.trans_qty2 := l_ic_adjs_jnl_rec.qty2;
365: l_cmp_tran_rec.qc_grade := l_ic_adjs_jnl_rec.qc_grade;
366: l_cmp_tran_rec.lot_status := l_ic_adjs_jnl_rec.lot_status;
367: l_cmp_tran_rec.trans_stat := NULL;

Line 364: l_cmp_tran_rec.trans_qty2 := l_ic_adjs_jnl_rec.qty2;

360: l_cmp_tran_rec.reason_code := l_ic_adjs_jnl_rec.reason_code;
361: l_cmp_tran_rec.creation_date := SYSDATE;
362: l_cmp_tran_rec.trans_date := l_ic_adjs_jnl_rec.doc_date;
363: l_cmp_tran_rec.trans_qty := l_ic_adjs_jnl_rec.qty;
364: l_cmp_tran_rec.trans_qty2 := l_ic_adjs_jnl_rec.qty2;
365: l_cmp_tran_rec.qc_grade := l_ic_adjs_jnl_rec.qc_grade;
366: l_cmp_tran_rec.lot_status := l_ic_adjs_jnl_rec.lot_status;
367: l_cmp_tran_rec.trans_stat := NULL;
368: l_cmp_tran_rec.trans_um := l_trans_rec.item_um;

Line 365: l_cmp_tran_rec.qc_grade := l_ic_adjs_jnl_rec.qc_grade;

361: l_cmp_tran_rec.creation_date := SYSDATE;
362: l_cmp_tran_rec.trans_date := l_ic_adjs_jnl_rec.doc_date;
363: l_cmp_tran_rec.trans_qty := l_ic_adjs_jnl_rec.qty;
364: l_cmp_tran_rec.trans_qty2 := l_ic_adjs_jnl_rec.qty2;
365: l_cmp_tran_rec.qc_grade := l_ic_adjs_jnl_rec.qc_grade;
366: l_cmp_tran_rec.lot_status := l_ic_adjs_jnl_rec.lot_status;
367: l_cmp_tran_rec.trans_stat := NULL;
368: l_cmp_tran_rec.trans_um := l_trans_rec.item_um;
369: l_cmp_tran_rec.trans_um2 := l_trans_rec.item_um2;

Line 366: l_cmp_tran_rec.lot_status := l_ic_adjs_jnl_rec.lot_status;

362: l_cmp_tran_rec.trans_date := l_ic_adjs_jnl_rec.doc_date;
363: l_cmp_tran_rec.trans_qty := l_ic_adjs_jnl_rec.qty;
364: l_cmp_tran_rec.trans_qty2 := l_ic_adjs_jnl_rec.qty2;
365: l_cmp_tran_rec.qc_grade := l_ic_adjs_jnl_rec.qc_grade;
366: l_cmp_tran_rec.lot_status := l_ic_adjs_jnl_rec.lot_status;
367: l_cmp_tran_rec.trans_stat := NULL;
368: l_cmp_tran_rec.trans_um := l_trans_rec.item_um;
369: l_cmp_tran_rec.trans_um2 := l_trans_rec.item_um2;
370: l_cmp_tran_rec.user_id := l_user_id;