12: )
13:
14: IS
15:
16: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMWLOTEX';
17:
18: /* since two WF processes exist with the GMWLOTEX WF Item,
19: prefix ITEMKEY with 'EX' to differentiate the Expiry Process */
20: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := 'EX' || TO_CHAR(p_lot_id) ;
16: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMWLOTEX';
17:
18: /* since two WF processes exist with the GMWLOTEX WF Item,
19: prefix ITEMKEY with 'EX' to differentiate the Expiry Process */
20: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := 'EX' || TO_CHAR(p_lot_id) ;
21:
22: l_expiry_interval NUMBER(3) ;
23: l_expiry_interval_from_tab NUMBER(3);
24: l_default_expiry_interval NUMBER(3) :=7;