APPS.GMI_WF_LOT_EXPIRY dependencies on IC_ITEM_MST

Line 33: l_item_no ic_item_mst.item_no%TYPE ;

29:
30: l_expire_notify_date DATE ;
31: l_wf_start_date DATE ;
32:
33: l_item_no ic_item_mst.item_no%TYPE ;
34: l_item_desc1 ic_item_mst.item_desc1%TYPE ;
35: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
36: l_item_um ic_item_mst.item_um%TYPE ;
37: l_item_um2 ic_item_mst.item_um2%TYPE ;

Line 34: l_item_desc1 ic_item_mst.item_desc1%TYPE ;

30: l_expire_notify_date DATE ;
31: l_wf_start_date DATE ;
32:
33: l_item_no ic_item_mst.item_no%TYPE ;
34: l_item_desc1 ic_item_mst.item_desc1%TYPE ;
35: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
36: l_item_um ic_item_mst.item_um%TYPE ;
37: l_item_um2 ic_item_mst.item_um2%TYPE ;
38: c_whse_item_id ic_item_mst.whse_item_id%TYPE;

Line 35: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;

31: l_wf_start_date DATE ;
32:
33: l_item_no ic_item_mst.item_no%TYPE ;
34: l_item_desc1 ic_item_mst.item_desc1%TYPE ;
35: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
36: l_item_um ic_item_mst.item_um%TYPE ;
37: l_item_um2 ic_item_mst.item_um2%TYPE ;
38: c_whse_item_id ic_item_mst.whse_item_id%TYPE;
39: c_item_id ic_item_mst.item_id%TYPE;

Line 36: l_item_um ic_item_mst.item_um%TYPE ;

32:
33: l_item_no ic_item_mst.item_no%TYPE ;
34: l_item_desc1 ic_item_mst.item_desc1%TYPE ;
35: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
36: l_item_um ic_item_mst.item_um%TYPE ;
37: l_item_um2 ic_item_mst.item_um2%TYPE ;
38: c_whse_item_id ic_item_mst.whse_item_id%TYPE;
39: c_item_id ic_item_mst.item_id%TYPE;
40:

Line 37: l_item_um2 ic_item_mst.item_um2%TYPE ;

33: l_item_no ic_item_mst.item_no%TYPE ;
34: l_item_desc1 ic_item_mst.item_desc1%TYPE ;
35: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
36: l_item_um ic_item_mst.item_um%TYPE ;
37: l_item_um2 ic_item_mst.item_um2%TYPE ;
38: c_whse_item_id ic_item_mst.whse_item_id%TYPE;
39: c_item_id ic_item_mst.item_id%TYPE;
40:
41: l_errname VARCHAR2(30);

Line 38: c_whse_item_id ic_item_mst.whse_item_id%TYPE;

34: l_item_desc1 ic_item_mst.item_desc1%TYPE ;
35: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
36: l_item_um ic_item_mst.item_um%TYPE ;
37: l_item_um2 ic_item_mst.item_um2%TYPE ;
38: c_whse_item_id ic_item_mst.whse_item_id%TYPE;
39: c_item_id ic_item_mst.item_id%TYPE;
40:
41: l_errname VARCHAR2(30);
42: l_errmsg VARCHAR2(2000);

Line 39: c_item_id ic_item_mst.item_id%TYPE;

35: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
36: l_item_um ic_item_mst.item_um%TYPE ;
37: l_item_um2 ic_item_mst.item_um2%TYPE ;
38: c_whse_item_id ic_item_mst.whse_item_id%TYPE;
39: c_item_id ic_item_mst.item_id%TYPE;
40:
41: l_errname VARCHAR2(30);
42: l_errmsg VARCHAR2(2000);
43:

Line 70: FROM ic_item_mst

66: WHERE item_id = c_item_id);
67:
68: CURSOR c_whse_item(c_item_id NUMBER) is
69: ( SELECT whse_item_id
70: FROM ic_item_mst
71: WHERE item_id = c_item_id);
72:
73: BEGIN
74: /* set the workflow start date to date now */

Line 86: FROM ic_item_mst

82:
83:
84: SELECT item_no , item_desc1 , item_um ,item_um2 , dualum_ind
85: INTO l_item_no ,l_item_desc1 , l_item_um , l_item_um2 , l_dualum_ind
86: FROM ic_item_mst
87: WHERE item_id = p_item_id ;
88:
89: /*BEGIN BUG#2134597 Praveen Reddy*/
90: /*Check if the workflow data exists and remove the same for the itemtype and itemkey