DBA Data[Home] [Help]

APPS.FND_SESSION_MANAGEMENT dependencies on ICX_SESSION_ATTRIBUTES

Line 1679: delete ICX_SESSION_ATTRIBUTES

1675: -- bug 3296747 forgot the else ...
1676: l_name := upper(p_name);
1677: end if;
1678:
1679: delete ICX_SESSION_ATTRIBUTES
1680: where SESSION_ID = p_session_id
1681: and NAME = l_name;
1682:
1683: insert into ICX_SESSION_ATTRIBUTES

Line 1683: insert into ICX_SESSION_ATTRIBUTES

1679: delete ICX_SESSION_ATTRIBUTES
1680: where SESSION_ID = p_session_id
1681: and NAME = l_name;
1682:
1683: insert into ICX_SESSION_ATTRIBUTES
1684: (SESSION_ID,NAME,VALUE)
1685: values
1686: (p_session_id,l_name,p_value);
1687: commit;

Line 1713: from ICX_SESSION_ATTRIBUTES

1709: end if;
1710:
1711: select VALUE
1712: into l_value
1713: from ICX_SESSION_ATTRIBUTES
1714: where SESSION_ID = p_session_id
1715: and NAME = l_name;
1716:
1717: return l_value;

Line 1745: delete ICX_SESSION_ATTRIBUTES

1741: -- bug 3296747 forgot the else ...
1742: l_name := upper(p_name);
1743: end if;
1744:
1745: delete ICX_SESSION_ATTRIBUTES
1746: where SESSION_ID = p_session_id
1747: and NAME = l_name;
1748:
1749: -- Fix for bug#5326396 -- Added a commit and exception handling to the code.