APPS.GMI_WF_LOT_RETEST dependencies on IC_LOTS_MST

Line 6: p_lot_id IN ic_lots_mst.lot_id%TYPE ,

2: /* $Header: gmiltrts.pls 115.2 2002/10/25 16:07:40 jdiiorio ship $ */
3:
4: PROCEDURE init_wf (
5: /* procedure to initialize and run Workflow */
6: p_lot_id IN ic_lots_mst.lot_id%TYPE ,
7: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
8: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
9: p_retest_date IN ic_lots_mst.retest_date%TYPE ,
10: p_item_id IN ic_lots_mst.item_id%TYPE ,

Line 7: p_lot_no IN ic_lots_mst.lot_no%TYPE ,

3:
4: PROCEDURE init_wf (
5: /* procedure to initialize and run Workflow */
6: p_lot_id IN ic_lots_mst.lot_id%TYPE ,
7: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
8: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
9: p_retest_date IN ic_lots_mst.retest_date%TYPE ,
10: p_item_id IN ic_lots_mst.item_id%TYPE ,
11: p_created_by IN ic_lots_mst.created_by%TYPE

Line 8: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,

4: PROCEDURE init_wf (
5: /* procedure to initialize and run Workflow */
6: p_lot_id IN ic_lots_mst.lot_id%TYPE ,
7: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
8: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
9: p_retest_date IN ic_lots_mst.retest_date%TYPE ,
10: p_item_id IN ic_lots_mst.item_id%TYPE ,
11: p_created_by IN ic_lots_mst.created_by%TYPE
12: ) ;

Line 9: p_retest_date IN ic_lots_mst.retest_date%TYPE ,

5: /* procedure to initialize and run Workflow */
6: p_lot_id IN ic_lots_mst.lot_id%TYPE ,
7: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
8: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
9: p_retest_date IN ic_lots_mst.retest_date%TYPE ,
10: p_item_id IN ic_lots_mst.item_id%TYPE ,
11: p_created_by IN ic_lots_mst.created_by%TYPE
12: ) ;
13:

Line 10: p_item_id IN ic_lots_mst.item_id%TYPE ,

6: p_lot_id IN ic_lots_mst.lot_id%TYPE ,
7: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
8: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
9: p_retest_date IN ic_lots_mst.retest_date%TYPE ,
10: p_item_id IN ic_lots_mst.item_id%TYPE ,
11: p_created_by IN ic_lots_mst.created_by%TYPE
12: ) ;
13:
14: PROCEDURE verify_retest (

Line 11: p_created_by IN ic_lots_mst.created_by%TYPE

7: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
8: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
9: p_retest_date IN ic_lots_mst.retest_date%TYPE ,
10: p_item_id IN ic_lots_mst.item_id%TYPE ,
11: p_created_by IN ic_lots_mst.created_by%TYPE
12: ) ;
13:
14: PROCEDURE verify_retest (
15: /* procedure to confirm lot expiration called via Workflow