APPS.ASO_WORKFLOW_PVT dependencies on WF_USERS

Line 99: l_adhoc_user WF_USERS.NAME%TYPE;

95: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
96: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97: ) IS
98:
99: l_adhoc_user WF_USERS.NAME%TYPE;
100: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
101: l_event_type VARCHAR2(20);
102: l_email_addr WF_USERS.Email_Address%TYPE;
103: l_this NUMBER;

Line 102: l_email_addr WF_USERS.Email_Address%TYPE;

98:
99: l_adhoc_user WF_USERS.NAME%TYPE;
100: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
101: l_event_type VARCHAR2(20);
102: l_email_addr WF_USERS.Email_Address%TYPE;
103: l_this NUMBER;
104: l_temp_str VARCHAR2(2000);
105: l_next NUMBER;
106: l_errmsg_count NUMBER;

Line 108: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

104: l_temp_str VARCHAR2(2000);
105: l_next NUMBER;
106: l_errmsg_count NUMBER;
107: l_errmsg_data VARCHAR2(32000);
108: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
109: l_UserType Varchar2(30) := 'ALL';
110: l_notifname Varchar2(100);
111: --dummy pls_integer;
112: l_display_name Varchar2(100) := 'Quoting Order Administrator';

Line 116: from wf_users

112: l_display_name Varchar2(100) := 'Quoting Order Administrator';
113: l_name Varchar2(100) := 'ASOORDERADMIN';
114: CURSOR wf_name_cur IS
115: select name
116: from wf_users
117: where orig_system = 'WF_LOCAL_USERS'
118: and name = 'ASOORDERADMIN'
119: and status = 'ACTIVE';
120: l_wf_name_cur_name varchar2(2000);