APPS.GMI_AUTOLOT dependencies on GMI_SUBLOT_GENERATE

Line 17: INSERT INTO GMI_SUBLOT_GENERATE

13:
14:
15: BEGIN
16: l_userid :=FND_GLOBAL.USER_ID;
17: INSERT INTO GMI_SUBLOT_GENERATE
18: (item_id, lot_no, next_sublot_suffix,
19: creation_date, created_by,
20: last_update_date, last_updated_by)
21: VALUES (p_i_item_id, p_i_lot_no, p_i_sublot_suffix,

Line 40: UPDATE GMI_SUBLOT_GENERATE

36:
37:
38:
39: BEGIN
40: UPDATE GMI_SUBLOT_GENERATE
41: set next_sublot_suffix = p_next_sublot
42: where item_id = p_item_id AND
43: lot_no = p_i_lot_no;
44: COMMIT;

Line 179: db_next_sublot_suffix gmi_sublot_generate.next_sublot_suffix%TYPE;

175: w_pad_lot_suffix VARCHAR2(32);
176: db_sublot_prefix ic_item_mst_b.sublot_prefix%TYPE;
177: db_sublot_suffix ic_item_mst_b.sublot_suffix%TYPE;
178: w_pad_sublot_suffix VARCHAR2(32);
179: db_next_sublot_suffix gmi_sublot_generate.next_sublot_suffix%TYPE;
180:
181: profile_user_routine NUMBER := 0;
182: prof_lot_pad NUMBER;
183: prof_lot_max NUMBER;

Line 227: FROM gmi_sublot_generate

223: WHERE item_id = p_item_id;
224:
225: CURSOR GET_SUBLOT_INFO IS
226: SELECT next_sublot_suffix
227: FROM gmi_sublot_generate
228: WHERE item_id = p_item_id AND
229: lot_no = p_in_lot_no;
230:
231: