165: /* This first Queries To see If Any Reservations Exist */
166: /* ( GMI Transcations) Then deletes or Updates. */
167: /* Else it will just delete this line. */
168: gmi_reservation_util.println('Operation delete');
169: GMI_Move_Order_LINE_Util.delete_Row( l_mo_line_rec.LINE_id);
170: ELSE
171: gmi_reservation_util.println('Going to fetch opm_item');
172: Open get_opm_item;
173: Fetch get_opm_item Into l_opm_item_id,
213: /* or quantity_detailed is different from New Then Call */
214: /* query to get reservations and do update logic. */
215: /* Else it will just update this row. */
216: gmi_reservation_util.println('Going to update row');
217: GMI_Move_Order_LINE_Util.update_Row( l_mo_line_rec);
218: ELSIF l_mo_line_rec.operation = INV_GLOBALS.G_OPR_CREATE THEN
219: /* Set create defaults */
220: gmi_reservation_util.println('Going to get get new id');
221: l_mo_line_rec.creation_date := SYSDATE;
229: FROM DUAL;
230:
231: WSH_Util_Core.PrintLn('Insert For Row > '|| I);
232: gmi_reservation_util.println('Going to intsert line in move order ');
233: GMI_Move_Order_LINE_Util.Insert_Row( l_mo_line_rec);
234:
235: /* Begin Bug 2973135 Uday Phadtare */
236: --Check if default transaction exists
237: OPEN get_default_trans(l_mo_line_rec.txn_source_line_id, l_opm_item_id);