DBA Data[Home] [Help]

APPS.GMI_WF_ITEM_ACTIVATION dependencies on IC_ITEM_MST

Line 6: /* called via trigger on ic_item_mst */

2: /* $Header: gmiitmwb.pls 120.1 2005/10/03 11:52:28 jsrivast noship $ */
3:
4: procedure init_wf
5: (
6: /* called via trigger on ic_item_mst */
7: p_item_id in number,
8: p_item_no in varchar2,
9: p_item_um in varchar2,
10: p_item_desc1 in varchar2,

Line 210: from IC_ITEM_MST

206: and supervisor_user_name=wu.name;
207: END IF;
208:
209: Select ITEM_DESC1 into l_item_desc
210: from IC_ITEM_MST
211: where ITEM_NO=l_ITEM_NO;
212:
213: wf_engine.setitemattrtext(itemtype => p_itemtype,
214: itemkey => p_itemkey, aname => 'ITEM_DESC1',

Line 335: ic_item_mst

331: begin
332: if (p_funcmode = 'RUN')
333: then
334: update
335: ic_item_mst
336: set
337: inactive_ind = 0, trans_cnt = -99
338: where
339: item_id = l_item_id;