[Home] [Help]
11: # SYNOPSIS
12: # proc insert_row
13: # DESCRIPTION
14: # This particular procedure is used to insert the values into
15: # the ic_xfer_mst table.
16: #################################################################*/
17:
18: PROCEDURE insert_row (p_commit IN VARCHAR2,
19: p_called_by_form IN VARCHAR2,
152: IF FND_API.To_Boolean(l_key_exists) THEN
153: RAISE Transfer_Exists_Error;
154: END IF;
155:
156: INSERT INTO ic_xfer_mst
157: (transfer_id,
158: transfer_no,
159: transfer_batch,
160: orgn_code,
365: # SYNOPSIS
366: # proc update_row
367: # DESCRIPTION
368: # This particular procedure is used to update the values into
369: # the ic_xfer_mst table.
370: #################################################################*/
371:
372: PROCEDURE update_row (p_commit IN VARCHAR2,
373: p_called_by_form IN VARCHAR2,
487: IF l_return_status <> 'S' THEN
488: RAISE Foreign_Key_Error;
489: END IF;
490:
491: UPDATE ic_xfer_mst
492: SET transfer_status = p_transfer_status,
493: transfer_batch = p_transfer_batch,
494: item_id = p_item_id,
495: lot_id = p_lot_id,
609: # SYNOPSIS
610: # proc lock_row
611: # DESCRIPTION
612: # This particular procedure is used to lock the corresponding
613: # row in the ic_xfer_mst table.
614: #################################################################*/
615:
616: PROCEDURE Lock_Row (p_called_by_form IN VARCHAR2,
617: p_rowid IN VARCHAR2,
638: /* Define the cursors */
639:
640: CURSOR c_lock_transfer IS
641: SELECT last_update_date
642: FROM ic_xfer_mst
643: WHERE rowid = p_rowid
644: FOR UPDATE OF last_update_date NOWAIT;
645:
646: LockTransferRcd c_lock_transfer%ROWTYPE;
823: /* Declare any variables and the cursor */
824:
825: CURSOR Cur_get_transfer_rowid IS
826: SELECT rowid
827: FROM ic_xfer_mst
828: WHERE transfer_no = p_transfer_no
829: AND orgn_code = p_orgn_code;
830:
831: TransferRecord Cur_get_transfer_rowid%ROWTYPE;