DBA Data[Home] [Help]

APPS.ENG_ECN_APPROVAL_LISTS_PKG dependencies on WF_LOCAL_ROLES

Line 261: lemail WF_LOCAL_ROLES.EMAIL_ADDRESS%type;

257: where role_orig_system= 'ENG_LIST' and
258: role_orig_system_id = X_Approval_List_Id;
259: myList wf_parameter_list_t;
260: l_username varchar2(320);
261: lemail WF_LOCAL_ROLES.EMAIL_ADDRESS%type;
262: lfax WF_LOCAL_ROLES.FAX%type;
263: BEGIN
264: UPDATE eng_ecn_approval_lists
265: SET

Line 262: lfax WF_LOCAL_ROLES.FAX%type;

258: role_orig_system_id = X_Approval_List_Id;
259: myList wf_parameter_list_t;
260: l_username varchar2(320);
261: lemail WF_LOCAL_ROLES.EMAIL_ADDRESS%type;
262: lfax WF_LOCAL_ROLES.FAX%type;
263: BEGIN
264: UPDATE eng_ecn_approval_lists
265: SET
266: approval_list_id = X_Approval_List_Id,

Line 299: from WF_LOCAL_ROLES

295: /* added for bug 3511260 */
296:
297: select EMAIL_ADDRESS,FAX
298: into lemail,lfax
299: from WF_LOCAL_ROLES
300: where NAME = l_username and
301: ORIG_SYSTEM = 'ENG_LIST' and
302: ORIG_SYSTEM_ID = X_Approval_List_Id;
303: