APPS.GMI_LOCT_INV_PVT dependencies on IC_LOTS_CPG

Line 23: | Update ic_lots_cpg with hold_date if it is the first yielding |

19: | Included changes to process journal transactions also. |
20: | For destination move line the status needs to be updated. |
21: | 28-OCT-2002 Joe DiIorio Bug #2643440 - 11.5.1J - added nocopy. |
22: | Jalaj Srivastava Bug 3158806 |
23: | Update ic_lots_cpg with hold_date if it is the first yielding |
24: | transaction. |
25: | 27-FEB-2004 Jatinder Gogna - 3470841 |
26: | Compute the lot dates for the first yielding transaction|
27: | 7-JUN-2004 Teresa Wong B3415691 - Enhancement for Serono |

Line 143: Update ic_lots_cpg with hold_date if it is the first yielding transaction.

139: RETURN;
140: END IF;
141: ELSE
142: /* Jalaj Srivastava Bug 3158806
143: Update ic_lots_cpg with hold_date if it is the first yielding transaction.
144: and hold date is null. update_ic_loct_inv internally calls insert_ic_loct_inv
145: if there is no existing inventory*/
146: Update ic_lots_cpg
147: Set ic_hold_date = (select p_tran_rec.trans_date + ic_hold_days

Line 146: Update ic_lots_cpg

142: /* Jalaj Srivastava Bug 3158806
143: Update ic_lots_cpg with hold_date if it is the first yielding transaction.
144: and hold date is null. update_ic_loct_inv internally calls insert_ic_loct_inv
145: if there is no existing inventory*/
146: Update ic_lots_cpg
147: Set ic_hold_date = (select p_tran_rec.trans_date + ic_hold_days
148: from ic_item_cpg
149: where item_id = l_loct_inv.item_id
150: )