DBA Data[Home] [Help]

APPS.GMI_WF_LOT_EXPIRY dependencies on WF_ITEMS

Line 16: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMWLOTEX';

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) ;

Line 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;