APPS.GMI_WF_LOT_EXPIRY dependencies on IC_LOTS_MST

Line 6: called via trigger on ic_lots_mst */

2: /* $Header: gmiltexs.pls 115.3 2002/10/25 16:04:28 jdiiorio ship $ */
3:
4: PROCEDURE init_wf (
5: /* procedure to initialize and run Workflow
6: called via trigger on ic_lots_mst */
7:
8: p_lot_id IN ic_lots_mst.lot_id%TYPE ,
9: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
10: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,

Line 8: p_lot_id IN ic_lots_mst.lot_id%TYPE ,

4: PROCEDURE init_wf (
5: /* procedure to initialize and run Workflow
6: called via trigger on ic_lots_mst */
7:
8: p_lot_id IN ic_lots_mst.lot_id%TYPE ,
9: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
10: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
11: p_expire_date IN ic_lots_mst.expire_date%TYPE ,
12: p_item_id IN ic_lots_mst.item_id%TYPE ,

Line 9: p_lot_no IN ic_lots_mst.lot_no%TYPE ,

5: /* procedure to initialize and run Workflow
6: called via trigger on ic_lots_mst */
7:
8: p_lot_id IN ic_lots_mst.lot_id%TYPE ,
9: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
10: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
11: p_expire_date IN ic_lots_mst.expire_date%TYPE ,
12: p_item_id IN ic_lots_mst.item_id%TYPE ,
13: p_created_by IN ic_lots_mst.created_by%TYPE

Line 10: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,

6: called via trigger on ic_lots_mst */
7:
8: p_lot_id IN ic_lots_mst.lot_id%TYPE ,
9: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
10: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
11: p_expire_date IN ic_lots_mst.expire_date%TYPE ,
12: p_item_id IN ic_lots_mst.item_id%TYPE ,
13: p_created_by IN ic_lots_mst.created_by%TYPE
14: ) ;

Line 11: p_expire_date IN ic_lots_mst.expire_date%TYPE ,

7:
8: p_lot_id IN ic_lots_mst.lot_id%TYPE ,
9: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
10: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
11: p_expire_date IN ic_lots_mst.expire_date%TYPE ,
12: p_item_id IN ic_lots_mst.item_id%TYPE ,
13: p_created_by IN ic_lots_mst.created_by%TYPE
14: ) ;
15:

Line 12: p_item_id IN ic_lots_mst.item_id%TYPE ,

8: p_lot_id IN ic_lots_mst.lot_id%TYPE ,
9: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
10: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
11: p_expire_date IN ic_lots_mst.expire_date%TYPE ,
12: p_item_id IN ic_lots_mst.item_id%TYPE ,
13: p_created_by IN ic_lots_mst.created_by%TYPE
14: ) ;
15:
16: PROCEDURE verify_expiry (

Line 13: p_created_by IN ic_lots_mst.created_by%TYPE

9: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
10: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
11: p_expire_date IN ic_lots_mst.expire_date%TYPE ,
12: p_item_id IN ic_lots_mst.item_id%TYPE ,
13: p_created_by IN ic_lots_mst.created_by%TYPE
14: ) ;
15:
16: PROCEDURE verify_expiry (
17: /* procedure to confirm lot expiration called via Workflow