APPS.GMI_LOCT_INV_DB_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

 |     Changed trni logic to update status when diff stat = 2.  A          |
 |     standard move with this doc type may cause a status update.         |
 |     Jalaj Srivastava Bug 2483644                                        |
 |     Removed code for bug 2117575 as it is already taken care            |
 |     of in GMIVQTY.validate_inventory_posting.                           |
 |     18-MAR-2003 James Bernard BUG#2847679                               |
 |     Code is added to update ic_loct_inv.last_update_date with           |
 |     SYSDATE and ic_loct_inv.last_updated_by the user who is currently   |
 |     doing the adjust immediate.                                         |
 +=========================================================================+
  API Name  : GMI_LOCT_INV_DB_PVT
  Type      : Public
  Function  : This package contains private procedures used to create
              IC_SUMM_INV transactions
  Pre-reqs  : N/A
  Parameters: Per function

  Current Vers  : 1.0

  Previous Vers : 1.0

  Initial Vers  : 1.0
  Notes
*/
/*  Global variables */
G_PKG_NAME  CONSTANT  VARCHAR2(30):='GMI_LOCT_INV_DB_PVT';

Line: 45

FUNCTION UPDATE_IC_LOCT_INV
(
   p_loct_inv       IN IC_LOCT_INV%ROWTYPE,
   p_status_updated IN NUMBER,
   p_qty_updated    IN NUMBER
)
RETURN BOOLEAN
IS

err_num NUMBER;

Line: 56

bad_insert EXCEPTION;

Line: 61

IF ( p_qty_updated =1) THEN
   /* *************************************************
      Jalaj Srivastava Bug 2483644
      Below fix is not required here since, this
      scenario is already taken care of in
      GMIVQTY.validate_inventory_posting
      ************************************************* */
   /*================================================
      27-DEC-2001  J. DiIorio Bug#2117575  11.5.1I                        |
     ==============================================*/
     /*================================================
      21-MAR-2003  James Bernard Bug#2847679
      Modified the update statement to update last_update_date with SYSDATE
      and last_updated_by with the user_id if the current user doing adjust immediate.
     ==============================================*/

     UPDATE ic_loct_inv
     SET
          loct_onhand      = loct_onhand  + p_loct_inv.loct_onhand,
	  loct_onhand2     = loct_onhand2 + p_loct_inv.loct_onhand2,
	  last_update_date = SYSDATE,
	  last_updated_by  = p_loct_inv.last_updated_by
     WHERE
	  item_id        = p_loct_inv.item_id   and
	  lot_id         = p_loct_inv.lot_id    and
	  whse_code      = p_loct_inv.whse_code and
   	  location       = p_loct_inv.location;

Line: 89

ELSIF (p_status_updated = 1) THEN

     /*================================================
      21-MAR-2003  James Bernard Bug#2847679
      Modified the update statement to update last_update_date with SYSDATE
      and last_updated_by with the user_id if the current user doing adjust immediate.
     ==============================================*/

   UPDATE ic_loct_inv
   SET
          lot_status       = p_loct_inv.lot_status,
          last_update_date = SYSDATE,
          last_updated_by  = p_loct_inv.last_updated_by
   WHERE
	  item_id        = p_loct_inv.item_id   and
	  lot_id         = p_loct_inv.lot_id    and
	  whse_code      = p_loct_inv.whse_code and
   	  location       = p_loct_inv.location;

Line: 114

  /*  There was nothing to update so we must insert a row */

  IF INSERT_IC_LOCT_INV(p_loct_inv)
  THEN
    NULL;

Line: 120

    RAISE bad_insert;

Line: 133

                             , 'update_ic_LOCT_inv'
                            );

Line: 137

END UPDATE_IC_LOCT_INV;

Line: 139

FUNCTION INSERT_IC_LOCT_INV
(
 p_LOCT_inv IN IC_LOCT_INV%ROWTYPE
)
RETURN BOOLEAN
IS
err_num NUMBER;

Line: 150

INSERT INTO IC_LOCT_INV
(
 item_id,
 whse_code,
 lot_id,
 location,
 loct_onhand,
 loct_onhand2,
 lot_status,
 qchold_res_code,
 delete_mark,
 text_code,
 created_by,
 creation_date,
 last_update_date,
 last_updated_by
)
VALUES
(
 p_loct_inv.item_id,
 p_loct_inv.whse_code,
 p_loct_inv.lot_id,
 p_loct_inv.location,
 p_loct_inv.loct_onhand,
 p_loct_inv.loct_onhand2,
 p_loct_inv.lot_status,
 p_loct_inv.qchold_res_code,
 p_loct_inv.delete_mark,
 p_loct_inv.text_code,
 p_loct_inv.created_by,
 p_loct_inv.creation_date,
 p_LOCT_inv.last_update_date,
 p_LOCT_inv.last_updated_by
);

Line: 192

                             , 'insert_ic_LOCT_inv'
                            );

Line: 196

END INSERT_IC_LOCT_INV;