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

Line 614: l_itemkey wf_items.item_key%type;

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

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