APPS.GMI_AUTOLOT SQL Statements

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

Line: 6

FUNCTION insert_sublot_gen(p_i_item_id               IN   NUMBER,
                          p_i_lot_no                 IN   VARCHAR2,
                          p_i_sublot_suffix          IN   NUMBER)
   RETURN NUMBER IS
PRAGMA AUTONOMOUS_TRANSACTION;

Line: 17

   INSERT INTO GMI_SUBLOT_GENERATE
           (item_id, lot_no, next_sublot_suffix,
           creation_date, created_by,
           last_update_date, last_updated_by)
         VALUES (p_i_item_id, p_i_lot_no, p_i_sublot_suffix,
                  SYSDATE, l_userid, SYSDATE, l_userid);

Line: 26

END insert_sublot_gen;

Line: 31

FUNCTION update_sublot_gen(p_next_sublot           IN   NUMBER,
                           p_item_id               IN   NUMBER,
                           p_i_lot_no              IN   VARCHAR2)
   RETURN NUMBER IS
PRAGMA AUTONOMOUS_TRANSACTION;

Line: 40

   UPDATE GMI_SUBLOT_GENERATE
      set next_sublot_suffix = p_next_sublot
          where item_id = p_item_id AND
          lot_no = p_i_lot_no;

Line: 48

END update_sublot_gen;

Line: 54

FUNCTION update_item_suffix(p_item_id              IN   NUMBER,
                            p_suffix               IN   NUMBER)
   RETURN NUMBER IS
PRAGMA AUTONOMOUS_TRANSACTION;

Line: 60

   UPDATE IC_ITEM_MST_B
      set lot_suffix = p_suffix
      where item_id = p_item_id;

Line: 67

END update_item_suffix;

Line: 75

    SELECT lot_id
    FROM ic_lots_mst
    WHERE item_id = p_f_item_id AND
          lot_no = p_f_lot_no AND
          sublot_no = p_f_sublot_no;

Line: 82

    SELECT lot_id
    FROM ic_lots_mst
    WHERE item_id = p_f_item_id AND
          lot_no = p_f_lot_no;

Line: 216

  e_sublot_insert           EXCEPTION;

Line: 219

    SELECT lot_ctl, sublot_ctl,
       autolot_active_indicator, lot_prefix,
       lot_suffix, sublot_prefix, sublot_suffix
    FROM ic_item_mst_b
    WHERE item_id = p_item_id;

Line: 226

    SELECT next_sublot_suffix
    FROM gmi_sublot_generate
    WHERE item_id = p_item_id AND
          lot_no = p_in_lot_no;

Line: 381

         l_retcode := insert_sublot_gen(p_item_id,
                          p_in_lot_no,
                          db_sublot_suffix);

Line: 386

           RAISE e_sublot_insert;

Line: 418

         l_updcode := update_sublot_gen(w_next_sublot, p_item_id, p_in_lot_no);

Line: 446

	l_itmcode := update_item_suffix(p_item_id, w_next_lot);

Line: 490

  WHEN e_sublot_insert THEN
    FND_MESSAGE.SET_NAME ('GMI','GMI_AUTOLOT_INSERT_SUBLOT_ERR');

Line: 531

    SELECT autolot_active_indicator
    FROM ic_item_mst_b
    WHERE item_id = p_item_id;