APPS.UMX_LOGIN_HELP_PVT dependencies on WF_ITEMS

Line 120: l_item_key wf_items.item_key%type;

116: end CreateRole;
117:
118: Function getCurrNoActiveReqs( username IN varchar2 ) return pls_integer is
119: l_no pls_integer := 0;
120: l_item_key wf_items.item_key%type;
121: l_user_name fnd_user.user_name%type := username;
122: Begin
123: select count(*) into l_no from
124: (

Line 129: FROM WF_ITEMS WorkflowItemEO,

125: SELECT WorkflowItemEO.ITEM_TYPE,
126: WorkflowItemEO.ITEM_KEY,
127: wf_fwkmon.getitemstatus(WorkflowItemEO.ITEM_TYPE, WorkflowItemEO.ITEM_KEY, WorkflowItemEO.END_DATE,
128: WorkflowItemEO.ROOT_ACTIVITY, WorkflowItemEO.ROOT_ACTIVITY_VERSION) STATUS_CODE
129: FROM WF_ITEMS WorkflowItemEO,
130: WF_ITEM_TYPES_VL WorkflowItemTypeEO,
131: WF_ACTIVITIES_VL ActivityEO,
132: WF_ITEM_ATTRIBUTE_VALUES attrib
133: WHERE WorkflowItemEO.ITEM_TYPE = WorkflowItemTypeEO.NAME

Line 154: From WF_ITEMS item, WF_ITEM_ATTRIBUTE_VALUES attr

150: Function getMaxNoActiveReqs return pls_integer is
151: l_no pls_integer := 0;
152: l_max_no varchar2(4000) := null;
153: cursor MaxNoRequest is SELECT attr.text_value into l_max_no
154: From WF_ITEMS item, WF_ITEM_ATTRIBUTE_VALUES attr
155: Where
156: item.item_type = attr.item_type
157: And
158: item.item_key = attr.item_key

Line 488: l_itemkey wf_items.item_key%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();
492: l_too_many_prev_reqs boolean := false;

Line 597: l_itemkey wf_items.item_key%type;

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;
601: l_first pls_integer;

Line 1205: -- l_itemkey wf_items.item_key%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:
1209: l_item_status varchar2(8);