117: l_whse_code ic_whse_mst.whse_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'WHSE_CODE');
118: l_whse_name ic_whse_mst.whse_name%TYPE;
119: l_lot_no ic_lots_mst.lot_no%TYPE ;
120: l_sublot_no ic_lots_mst.sublot_no%TYPE ;
121: l_doc_type sy_docs_mst.doc_type%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'DOC_TYPE');
122: l_doc_desc sy_docs_mst.doc_desc%TYPE;
123: l_role_name wf_roles.name%TYPE;
124: l_role_display_name wf_roles.display_name%TYPE;
125: l_email_Address varchar2(2000);
118: l_whse_name ic_whse_mst.whse_name%TYPE;
119: l_lot_no ic_lots_mst.lot_no%TYPE ;
120: l_sublot_no ic_lots_mst.sublot_no%TYPE ;
121: l_doc_type sy_docs_mst.doc_type%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'DOC_TYPE');
122: l_doc_desc sy_docs_mst.doc_desc%TYPE;
123: l_role_name wf_roles.name%TYPE;
124: l_role_display_name wf_roles.display_name%TYPE;
125: l_email_Address varchar2(2000);
126: l_notification_Preference varchar2(2000);
178:
179: /* Selecting Document details from Document Master */
180: SELECT doc_desc
181: INTO l_doc_desc
182: FROM sy_docs_mst
183: WHERE doc_type = l_doc_type;
184:
185: /* Begin Bug#2250274 Praveen Reddy*/
186: /* Added code to fetch the doc_no depending upon doc type and doc_id*/