APPS.UMX_LOGIN_HELP_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 491: l_result wf_item_activity_statuses.activity_result_code%type;

487: l_email_address varchar2(2000);
488: l_role_name wf_local_roles.name%type;
489: l_password varchar2(40);
490: l_notification_preference wf_local_roles.notification_preference%type;
491: l_result wf_item_activity_statuses.activity_result_code%type;
492: l_status wf_item_activity_statuses.activity_status%type;
493: l_itemkey wf_items.item_key%type;
494: l_pwdChangeable boolean := null;
495: l_nonExistentUser boolean := false;

Line 492: l_status wf_item_activity_statuses.activity_status%type;

488: l_role_name wf_local_roles.name%type;
489: l_password varchar2(40);
490: l_notification_preference wf_local_roles.notification_preference%type;
491: l_result wf_item_activity_statuses.activity_result_code%type;
492: l_status wf_item_activity_statuses.activity_status%type;
493: l_itemkey wf_items.item_key%type;
494: l_pwdChangeable boolean := null;
495: l_nonExistentUser boolean := false;
496: l_max_req pls_integer := getMaxNoActiveReqs();

Line 612: l_result wf_item_activity_statuses.activity_result_code%type;

608:
609: l_email_address varchar2(2000) := p_email;
610: l_role_name wf_local_roles.name%type;
611: l_notification_preference wf_local_roles.notification_preference%type;
612: l_result wf_item_activity_statuses.activity_result_code%type;
613: l_status wf_item_activity_statuses.activity_status%type;
614: l_itemkey wf_items.item_key%type;
615: l_user_name fnd_user.user_name%type;
616: l_user_list UsersWEmail;

Line 613: l_status wf_item_activity_statuses.activity_status%type;

609: l_email_address varchar2(2000) := p_email;
610: l_role_name wf_local_roles.name%type;
611: l_notification_preference wf_local_roles.notification_preference%type;
612: l_result wf_item_activity_statuses.activity_result_code%type;
613: l_status wf_item_activity_statuses.activity_status%type;
614: l_itemkey wf_items.item_key%type;
615: l_user_name fnd_user.user_name%type;
616: l_user_list UsersWEmail;
617: i pls_integer;

Line 1223: l_result wf_item_activity_statuses.activity_result_code%type;

1219: -- l_email_address varchar2(2000);
1220: -- l_role_name wf_local_roles.name%type;
1221: l_password varchar2(40) := p_password;
1222: -- l_notification_preference wf_local_roles.notification_preference%type;
1223: l_result wf_item_activity_statuses.activity_result_code%type;
1224: -- l_status wf_item_activity_statuses.activity_status%type;
1225: -- l_itemkey wf_items.item_key%type;
1226: l_pwdChangeable boolean := null;
1227: l_updatePwdFailedException exception;

Line 1224: -- l_status wf_item_activity_statuses.activity_status%type;

1220: -- l_role_name wf_local_roles.name%type;
1221: l_password varchar2(40) := p_password;
1222: -- l_notification_preference wf_local_roles.notification_preference%type;
1223: l_result wf_item_activity_statuses.activity_result_code%type;
1224: -- l_status wf_item_activity_statuses.activity_status%type;
1225: -- l_itemkey wf_items.item_key%type;
1226: l_pwdChangeable boolean := null;
1227: l_updatePwdFailedException exception;
1228: