1 PACKAGE gmi_wf_lot_expiry AUTHID CURRENT_USER AS
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 ,
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
18 parameters conform to WF standard (see WF FAQ) */
19 p_itemtype IN VARCHAR2,
20 p_itemkey IN VARCHAR2,
21 p_actid IN NUMBER,
22 p_funcmode IN VARCHAR2,
23 p_resultout OUT NOCOPY VARCHAR2
24 ) ;
25
26 END gmi_wf_lot_expiry ;