APPS.GMI_WF_LOT_RETEST dependencies on DUAL

Line 37: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;

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

Line 78: FROM dual;

74: WHERE item_id = c_item_id);
75: BEGIN
76: SELECT sysdate
77: INTO l_wf_start_date
78: FROM dual;
79:
80: SELECT USER_NAME , DESCRIPTION
81: INTO l_performer_name ,l_performer_display_name
82: FROM FND_USER

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

81: INTO l_performer_name ,l_performer_display_name
82: FROM FND_USER
83: WHERE USER_ID = p_created_by ;
84:
85: SELECT item_no , item_desc1 ,item_um ,item_um2 , dualum_ind
86: INTO l_item_no ,l_item_desc1 ,l_item_um ,l_item_um2 ,l_dualum_ind
87: FROM ic_item_mst
88: WHERE item_id = p_item_id ;
89:

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

82: FROM FND_USER
83: WHERE USER_ID = p_created_by ;
84:
85: SELECT item_no , item_desc1 ,item_um ,item_um2 , dualum_ind
86: INTO l_item_no ,l_item_desc1 ,l_item_um ,l_item_um2 ,l_dualum_ind
87: FROM ic_item_mst
88: WHERE item_id = p_item_id ;
89:
90: /*BEGIN BUG#2134597 Praveen Reddy*/

Line 234: aname => 'DUALUM_IND',

230: avalue => l_item_um2);
231:
232: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,
233: itemkey => l_itemkey,
234: aname => 'DUALUM_IND',
235: avalue => l_dualum_ind);
236:
237: WF_ENGINE.SETITEMATTRDATE(itemtype => l_itemtype,
238: itemkey => l_itemkey,

Line 235: avalue => l_dualum_ind);

231:
232: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,
233: itemkey => l_itemkey,
234: aname => 'DUALUM_IND',
235: avalue => l_dualum_ind);
236:
237: WF_ENGINE.SETITEMATTRDATE(itemtype => l_itemtype,
238: itemkey => l_itemkey,
239: aname => 'WF_START_DATE',