APPS.AME_UTIL dependencies on AK_WEB_USER_SEC_ATTR_VALUES

Line 1688: tempSecuredAttribute ak_web_user_sec_attr_values.number_value%type;

1684: responsibilityList icx_sec.g_responsibility_list;
1685: returnStatus varchar2(4000);
1686: securedAttributeCount integer;
1687: tempIndex integer;
1688: tempSecuredAttribute ak_web_user_sec_attr_values.number_value%type;
1689: userId fnd_user.user_id%type;
1690: begin
1691: if not icx_sec.validatesession then
1692: return(ame_util.noResponsibility);

Line 2889: ak_web_user_sec_attr_values.number_value,

2885: nvl(end_date - ame_util.oneSecond, sysdate)
2886: order by application_name;
2887: cursor securedAttributesCursor(userId in integer) is
2888: select
2889: ak_web_user_sec_attr_values.number_value,
2890: ame_calling_apps.application_name
2891: from ak_web_user_sec_attr_values,
2892: ame_calling_apps
2893: where ak_web_user_sec_attr_values.number_value = ame_calling_apps.application_id and

Line 2891: from ak_web_user_sec_attr_values,

2887: cursor securedAttributesCursor(userId in integer) is
2888: select
2889: ak_web_user_sec_attr_values.number_value,
2890: ame_calling_apps.application_name
2891: from ak_web_user_sec_attr_values,
2892: ame_calling_apps
2893: where ak_web_user_sec_attr_values.number_value = ame_calling_apps.application_id and
2894: web_user_id = userId and
2895: sysdate between ame_calling_apps.start_date and

Line 2893: where ak_web_user_sec_attr_values.number_value = ame_calling_apps.application_id and

2889: ak_web_user_sec_attr_values.number_value,
2890: ame_calling_apps.application_name
2891: from ak_web_user_sec_attr_values,
2892: ame_calling_apps
2893: where ak_web_user_sec_attr_values.number_value = ame_calling_apps.application_id and
2894: web_user_id = userId and
2895: sysdate between ame_calling_apps.start_date and
2896: nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)
2897: order by application_name;