DBA Data[Home] [Help]

APPS.GMI_WF_LOT_RETEST dependencies on WF_ITEMS

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

11: p_created_by IN ic_lots_mst.created_by%TYPE
12: )
13:
14: IS
15: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMWLOTEX';
16:
17: /* since two WF processes exist with the GMWLOTEX WF Item,
18: prefix ITEMKEY with 'RT' to differentiate the Retest Process */
19: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := 'RT' || TO_CHAR(p_lot_id) ;

Line 19: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := 'RT' || TO_CHAR(p_lot_id) ;

15: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMWLOTEX';
16:
17: /* since two WF processes exist with the GMWLOTEX WF Item,
18: prefix ITEMKEY with 'RT' to differentiate the Retest Process */
19: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := 'RT' || TO_CHAR(p_lot_id) ;
20:
21: /* number of days before lot retest date to send WF notification
22: value is fetched from table gmwlotrt_ctl
23: if not found in gmwlotrt_ctl, default is 7 days */