[Home] [Help]
59: * Added nocopy.
60: * Joe DiIorio Bug 3090255 11.5.10L 08/15/2003
61: * Added field intorder_posted_ind.
62: * Jeff Baird Bug #3409615 02/05/2004
63: * Added who columns to update of ic_lots_mst.
64: * Jeff Baird Bug #3434156 02/10/2004
65: * Corrected column name in above fix.
66: * V.Anitha BUG#3526733 14-APR-2004
67: * Added colum reverse_id column in create_completed_transactions
299: *********************************************************** */
300:
301:
302: /* Jalaj Srivastava Bug 1427922 */
303: /* Added logic for grade txns and to update ic_lots_mst for change in gradeREM */
304:
305: --Jalaj Srivastava Bug 2483644
306: --Now journal txns would also be posted using these APIs
307: IF (substr(l_tran_rec.doc_type,1,3) = 'GRD') THEN
305: --Jalaj Srivastava Bug 2483644
306: --Now journal txns would also be posted using these APIs
307: IF (substr(l_tran_rec.doc_type,1,3) = 'GRD') THEN
308:
309: /* Update ic_lots_mst with the new grade */
310:
311: update ic_lots_mst set
312: qc_grade = l_tran_rec.qc_grade,
313: last_update_date = SYSDATE,
307: IF (substr(l_tran_rec.doc_type,1,3) = 'GRD') THEN
308:
309: /* Update ic_lots_mst with the new grade */
310:
311: update ic_lots_mst set
312: qc_grade = l_tran_rec.qc_grade,
313: last_update_date = SYSDATE,
314: last_updated_by = p_tran_rec.user_id
315: where item_id = l_tran_rec.item_id
862: SELECT
863: DECODE(i.lot_id, 0, NULL, m.qc_grade)
864: FROM
865: ic_loct_inv i,
866: ic_lots_mst m
867: WHERE
868: m.lot_id = i.lot_id
869: AND i.lot_id = v_lot_id;
870: