DBA Data[Home] [Help]

APPS.ICX_SEC dependencies on ICX_SESSION_ATTRIBUTES

Line 3188: delete ICX_SESSION_ATTRIBUTES

3184: -- bug 3296747 forgot the else ...
3185: l_name := upper(p_name);
3186: end if;
3187:
3188: delete ICX_SESSION_ATTRIBUTES
3189: where SESSION_ID = l_session_id
3190: and NAME = l_name;
3191:
3192: insert into ICX_SESSION_ATTRIBUTES

Line 3192: insert into ICX_SESSION_ATTRIBUTES

3188: delete ICX_SESSION_ATTRIBUTES
3189: where SESSION_ID = l_session_id
3190: and NAME = l_name;
3191:
3192: insert into ICX_SESSION_ATTRIBUTES
3193: (SESSION_ID,NAME,VALUE)
3194: values
3195: (l_session_id,l_name,p_value);
3196:

Line 3230: from ICX_SESSION_ATTRIBUTES

3226: end if;
3227:
3228: select VALUE
3229: into l_value
3230: from ICX_SESSION_ATTRIBUTES
3231: where SESSION_ID = l_session_id
3232: and NAME = l_name;
3233:
3234: return l_value;

Line 3268: delete ICX_SESSION_ATTRIBUTES

3264: -- bug 3296747 forgot the else ...
3265: l_name := upper(p_name);
3266: end if;
3267:
3268: delete ICX_SESSION_ATTRIBUTES
3269: where SESSION_ID = l_session_id
3270: and NAME = l_name;
3271:
3272: end;