DBA Data[Home] [Help]

APPS.FND_SESSION_MANAGEMENT dependencies on ICX_SESSION_ATTRIBUTES

Line 1631: delete ICX_SESSION_ATTRIBUTES

1627: -- bug 3296747 forgot the else ...
1628: l_name := upper(p_name);
1629: end if;
1630:
1631: delete ICX_SESSION_ATTRIBUTES
1632: where SESSION_ID = p_session_id
1633: and NAME = l_name;
1634:
1635: insert into ICX_SESSION_ATTRIBUTES

Line 1635: insert into ICX_SESSION_ATTRIBUTES

1631: delete ICX_SESSION_ATTRIBUTES
1632: where SESSION_ID = p_session_id
1633: and NAME = l_name;
1634:
1635: insert into ICX_SESSION_ATTRIBUTES
1636: (SESSION_ID,NAME,VALUE)
1637: values
1638: (p_session_id,l_name,p_value);
1639: commit;

Line 1665: from ICX_SESSION_ATTRIBUTES

1661: end if;
1662:
1663: select VALUE
1664: into l_value
1665: from ICX_SESSION_ATTRIBUTES
1666: where SESSION_ID = p_session_id
1667: and NAME = l_name;
1668:
1669: return l_value;

Line 1697: delete ICX_SESSION_ATTRIBUTES

1693: -- bug 3296747 forgot the else ...
1694: l_name := upper(p_name);
1695: end if;
1696:
1697: delete ICX_SESSION_ATTRIBUTES
1698: where SESSION_ID = p_session_id
1699: and NAME = l_name;
1700:
1701: -- Fix for bug#5326396 -- Added a commit and exception handling to the code.