APPS.UMX_LOGIN_HELP_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 486: l_result wf_item_activity_statuses.activity_result_code%type;

482: l_email_address varchar2(2000);
483: l_role_name wf_local_roles.name%type;
484: l_password varchar2(40);
485: l_notification_preference wf_local_roles.notification_preference%type;
486: l_result wf_item_activity_statuses.activity_result_code%type;
487: l_status wf_item_activity_statuses.activity_status%type;
488: l_itemkey wf_items.item_key%type;
489: l_pwdChangeable boolean := null;
490: l_nonExistentUser boolean := false;

Line 487: l_status wf_item_activity_statuses.activity_status%type;

483: l_role_name wf_local_roles.name%type;
484: l_password varchar2(40);
485: l_notification_preference wf_local_roles.notification_preference%type;
486: l_result wf_item_activity_statuses.activity_result_code%type;
487: l_status wf_item_activity_statuses.activity_status%type;
488: l_itemkey wf_items.item_key%type;
489: l_pwdChangeable boolean := null;
490: l_nonExistentUser boolean := false;
491: l_max_req pls_integer := getMaxNoActiveReqs();

Line 595: l_result wf_item_activity_statuses.activity_result_code%type;

591:
592: l_email_address varchar2(2000) := p_email;
593: l_role_name wf_local_roles.name%type;
594: l_notification_preference wf_local_roles.notification_preference%type;
595: l_result wf_item_activity_statuses.activity_result_code%type;
596: l_status wf_item_activity_statuses.activity_status%type;
597: l_itemkey wf_items.item_key%type;
598: l_user_name fnd_user.user_name%type;
599: l_user_list UsersWEmail;

Line 596: l_status wf_item_activity_statuses.activity_status%type;

592: l_email_address varchar2(2000) := p_email;
593: l_role_name wf_local_roles.name%type;
594: l_notification_preference wf_local_roles.notification_preference%type;
595: l_result wf_item_activity_statuses.activity_result_code%type;
596: l_status wf_item_activity_statuses.activity_status%type;
597: l_itemkey wf_items.item_key%type;
598: l_user_name fnd_user.user_name%type;
599: l_user_list UsersWEmail;
600: i pls_integer;

Line 1203: l_result wf_item_activity_statuses.activity_result_code%type;

1199: -- l_email_address varchar2(2000);
1200: -- l_role_name wf_local_roles.name%type;
1201: l_password varchar2(40) := p_password;
1202: -- l_notification_preference wf_local_roles.notification_preference%type;
1203: l_result wf_item_activity_statuses.activity_result_code%type;
1204: -- l_status wf_item_activity_statuses.activity_status%type;
1205: -- l_itemkey wf_items.item_key%type;
1206: l_pwdChangeable boolean := null;
1207: l_updatePwdFailedException exception;

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

1200: -- l_role_name wf_local_roles.name%type;
1201: l_password varchar2(40) := p_password;
1202: -- l_notification_preference wf_local_roles.notification_preference%type;
1203: l_result wf_item_activity_statuses.activity_result_code%type;
1204: -- l_status wf_item_activity_statuses.activity_status%type;
1205: -- l_itemkey wf_items.item_key%type;
1206: l_pwdChangeable boolean := null;
1207: l_updatePwdFailedException exception;
1208: