DBA Data[Home] [Help]

APPS.FND_LOG_REPOSITORY dependencies on ICX_SEC

Line 312: CONTEXT_OUT(1).a_val := icx_sec.g_session_id;

308: if (SESSION_ID IS NULL) then
309: if SELF_INITED_X then
310: CONTEXT_OUT(1).a_val := SESSION_ID_X;
311: else
312: CONTEXT_OUT(1).a_val := icx_sec.g_session_id;
313: end if;
314: else
315: CONTEXT_OUT(1).a_val := SESSION_ID;
316: end if;

Line 395: icx_sec.g_session_id,

391: fnd_global.form_appl_id,
392: fnd_global.conc_process_id,
393: fnd_global.conc_queue_id,
394: fnd_global.queue_appl_id,
395: icx_sec.g_session_id,
396: fnd_global.user_id,
397: fnd_global.resp_appl_id,
398: fnd_global.resp_id,
399: fnd_global.security_group_id

Line 438: CONTEXT_OUT(1).a_val := icx_sec.g_session_id;

434: elsif ((SESSION_ID_X is NOT NULL) and
435: (SESSION_ID_X <> -1 )) then
436: CONTEXT_OUT(1).a_val := SESSION_ID_X;
437: else
438: CONTEXT_OUT(1).a_val := icx_sec.g_session_id;
439: end if;
440:
441:
442: /* 2. USER_ID */

Line 1777: elsif icx_sec.g_session_id is not null and icx_sec.g_session_id > 0 then

1773: l_component_type := 'FORM';
1774: end;
1775:
1776: -- ICX sessions, ICX transactions
1777: elsif icx_sec.g_session_id is not null and icx_sec.g_session_id > 0 then
1778:
1779: -- see if a transaction context exists for this session
1780: begin
1781: l_component_id := null;

Line 1784: if icx_sec.g_transaction_id is not null and icx_sec.g_transaction_id > 0 then

1780: begin
1781: l_component_id := null;
1782:
1783: -- Check for finer ICX Transaction
1784: if icx_sec.g_transaction_id is not null and icx_sec.g_transaction_id > 0 then
1785: begin
1786: select transaction_context_id
1787: into l_transaction_context_id
1788: from fnd_log_transaction_context

Line 1790: and transaction_id = icx_sec.g_transaction_id

1786: select transaction_context_id
1787: into l_transaction_context_id
1788: from fnd_log_transaction_context
1789: where transaction_type = 'ICX'
1790: and transaction_id = icx_sec.g_transaction_id
1791: and session_id = icx_sec.g_session_id
1792: and user_id = to_number(l_context(2).a_val)
1793: and resp_appl_id = to_number(l_context(3).a_val)
1794: and responsibility_id = to_number(l_context(4).a_val)

Line 1791: and session_id = icx_sec.g_session_id

1787: into l_transaction_context_id
1788: from fnd_log_transaction_context
1789: where transaction_type = 'ICX'
1790: and transaction_id = icx_sec.g_transaction_id
1791: and session_id = icx_sec.g_session_id
1792: and user_id = to_number(l_context(2).a_val)
1793: and resp_appl_id = to_number(l_context(3).a_val)
1794: and responsibility_id = to_number(l_context(4).a_val)
1795: and security_group_id = to_number(l_context(5).a_val)

Line 1808: where transaction_id = icx_sec.g_transaction_id;

1804: begin
1805: select function_id
1806: into l_component_id
1807: from icx_transactions
1808: where transaction_id = icx_sec.g_transaction_id;
1809: exception
1810: when others then
1811: l_component_id := null;
1812: end;

Line 1823: and session_id = icx_sec.g_session_id

1819: select transaction_context_id
1820: into l_transaction_context_id
1821: from fnd_log_transaction_context
1822: where transaction_type = 'ICX'
1823: and session_id = icx_sec.g_session_id
1824: and transaction_id = -1
1825: and user_id = to_number(l_context(2).a_val)
1826: and resp_appl_id = to_number(l_context(3).a_val)
1827: and responsibility_id = to_number(l_context(4).a_val)

Line 1841: where session_id = icx_sec.g_session_id;

1837: begin
1838: select function_id
1839: into l_component_id
1840: from icx_sessions
1841: where session_id = icx_sec.g_session_id;
1842: exception
1843: when others then
1844: l_component_id := null;
1845: end;

Line 1851: l_transaction_id := icx_sec.g_transaction_id;

1847: end;
1848: end if;
1849:
1850: l_transaction_type := 'ICX';
1851: l_transaction_id := icx_sec.g_transaction_id;
1852: l_component_appl_id := null;
1853: l_component_type := 'FUNCTION';
1854: end;
1855:

Line 1916: SESSION_ID_X := icx_sec.g_session_id;

1912: DATA_SIZE NUMBER;
1913:
1914: begin
1915: if(SESSION_ID is NULL) then
1916: SESSION_ID_X := icx_sec.g_session_id;
1917: else
1918: SESSION_ID_X := SESSION_ID;
1919: end if;
1920: