APPS.GMI_WF_LOT_EXPIRY dependencies on DUAL

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 75: SELECT sysdate INTO l_wf_start_date FROM dual;

71: WHERE item_id = c_item_id);
72:
73: BEGIN
74: /* set the workflow start date to date now */
75: SELECT sysdate INTO l_wf_start_date FROM dual;
76:
77: /* get values to be stored into the workflow item */
78: SELECT USER_NAME, DESCRIPTION
79: INTO l_performer_name,l_performer_display_name

Line 84: SELECT item_no , item_desc1 , item_um ,item_um2 , dualum_ind

80: FROM FND_USER
81: WHERE USER_ID = p_created_by ;
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:

Line 85: INTO l_item_no ,l_item_desc1 , l_item_um , l_item_um2 , l_dualum_ind

81: WHERE USER_ID = p_created_by ;
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*/

Line 229: aname => 'DUALUM_IND',

225: avalue => l_item_um2);
226:
227: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,
228: itemkey => l_itemkey,
229: aname => 'DUALUM_IND',
230: avalue => l_dualum_ind);
231:
232: WF_ENGINE.SETITEMATTRDATE(itemtype => l_itemtype,
233: itemkey => l_itemkey,

Line 230: avalue => l_dualum_ind);

226:
227: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,
228: itemkey => l_itemkey,
229: aname => 'DUALUM_IND',
230: avalue => l_dualum_ind);
231:
232: WF_ENGINE.SETITEMATTRDATE(itemtype => l_itemtype,
233: itemkey => l_itemkey,
234: aname => 'WF_START_DATE',