DBA Data[Home] [Help]

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);

Line 1076: l_current_forward_to_username wf_users.NAME%TYPE;

1072: WHERE item_type = p_itemtype AND item_key = p_itemkey;
1073:
1074: -- local variables
1075: notification_rec ame_util2.notificationrecord;
1076: l_current_forward_to_username wf_users.NAME%TYPE;
1077: l_is_parallel VARCHAR2 (10) DEFAULT NULL;
1078: original_forward_to_user wf_users.NAME%TYPE;
1079: l_role_name wf_users.NAME%TYPE;
1080: ntfidstartpos NUMBER DEFAULT NULL;

Line 1078: original_forward_to_user wf_users.NAME%TYPE;

1074: -- local variables
1075: notification_rec ame_util2.notificationrecord;
1076: l_current_forward_to_username wf_users.NAME%TYPE;
1077: l_is_parallel VARCHAR2 (10) DEFAULT NULL;
1078: original_forward_to_user wf_users.NAME%TYPE;
1079: l_role_name wf_users.NAME%TYPE;
1080: ntfidstartpos NUMBER DEFAULT NULL;
1081: startpos NUMBER DEFAULT NULL;
1082: endpos NUMBER DEFAULT NULL;

Line 1079: l_role_name wf_users.NAME%TYPE;

1075: notification_rec ame_util2.notificationrecord;
1076: l_current_forward_to_username wf_users.NAME%TYPE;
1077: l_is_parallel VARCHAR2 (10) DEFAULT NULL;
1078: original_forward_to_user wf_users.NAME%TYPE;
1079: l_role_name wf_users.NAME%TYPE;
1080: ntfidstartpos NUMBER DEFAULT NULL;
1081: startpos NUMBER DEFAULT NULL;
1082: endpos NUMBER DEFAULT NULL;
1083: prll_ntf VARCHAR2 (600) DEFAULT NULL;