APPS.HR_APPRAISAL_WORKFLOW_SS dependencies on WF_USERS

Line 195: l_username wf_users.name%type;

191: l_appraisee_person_id per_appraisals.appraisee_person_id%type;
192: l_system_params per_appraisals.system_params%type;
193: l_system_type per_appraisals.system_type%type;
194: l_assignment_id per_appraisals.assignment_id%type;
195: l_username wf_users.name%type;
196: l_appraisee_user_name wf_users.name%type;
197: l_supervisor_user_name wf_users.name%type;
198: l_main_appraiser_user_name wf_users.name%type;
199: l_display_name wf_users.display_name%type;

Line 196: l_appraisee_user_name wf_users.name%type;

192: l_system_params per_appraisals.system_params%type;
193: l_system_type per_appraisals.system_type%type;
194: l_assignment_id per_appraisals.assignment_id%type;
195: l_username wf_users.name%type;
196: l_appraisee_user_name wf_users.name%type;
197: l_supervisor_user_name wf_users.name%type;
198: l_main_appraiser_user_name wf_users.name%type;
199: l_display_name wf_users.display_name%type;
200:

Line 197: l_supervisor_user_name wf_users.name%type;

193: l_system_type per_appraisals.system_type%type;
194: l_assignment_id per_appraisals.assignment_id%type;
195: l_username wf_users.name%type;
196: l_appraisee_user_name wf_users.name%type;
197: l_supervisor_user_name wf_users.name%type;
198: l_main_appraiser_user_name wf_users.name%type;
199: l_display_name wf_users.display_name%type;
200:
201: begin

Line 198: l_main_appraiser_user_name wf_users.name%type;

194: l_assignment_id per_appraisals.assignment_id%type;
195: l_username wf_users.name%type;
196: l_appraisee_user_name wf_users.name%type;
197: l_supervisor_user_name wf_users.name%type;
198: l_main_appraiser_user_name wf_users.name%type;
199: l_display_name wf_users.display_name%type;
200:
201: begin
202: hr_utility.set_location('Entered:'|| gv_package || '.create_hr_transaction', 1);

Line 199: l_display_name wf_users.display_name%type;

195: l_username wf_users.name%type;
196: l_appraisee_user_name wf_users.name%type;
197: l_supervisor_user_name wf_users.name%type;
198: l_main_appraiser_user_name wf_users.name%type;
199: l_display_name wf_users.display_name%type;
200:
201: begin
202: hr_utility.set_location('Entered:'|| gv_package || '.create_hr_transaction', 1);
203: -- get the appraisal_id from the item attribute , APPRAISAL_ID

Line 391: prole wf_users.name%type; -- Fix 3210283.

387: resultout in out nocopy varchar2)
388: is
389: msg varchar2(30);
390: msgtype varchar2(8);
391: prole wf_users.name%type; -- Fix 3210283.
392: expand_role varchar2(1);
393:
394: colon pls_integer;
395: avalue varchar2(240);