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 1826: elsif icx_sec.g_session_id is not null and icx_sec.g_session_id > 0 then

1822: end;
1823:
1824:
1825: -- ICX sessions, ICX transactions
1826: elsif icx_sec.g_session_id is not null and icx_sec.g_session_id > 0 then
1827:
1828: -- see if a transaction context exists for this session
1829: begin
1830: l_component_id := null;

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

1829: begin
1830: l_component_id := null;
1831:
1832: -- Check for finer ICX Transaction
1833: if icx_sec.g_transaction_id is not null and icx_sec.g_transaction_id > 0 then
1834: begin
1835: select transaction_context_id
1836: into l_transaction_context_id
1837: from fnd_log_transaction_context

Line 1839: and transaction_id = icx_sec.g_transaction_id

1835: select transaction_context_id
1836: into l_transaction_context_id
1837: from fnd_log_transaction_context
1838: where transaction_type = 'ICX'
1839: and transaction_id = icx_sec.g_transaction_id
1840: and session_id = icx_sec.g_session_id
1841: and user_id = to_number(l_context(2).a_val)
1842: and resp_appl_id = to_number(l_context(3).a_val)
1843: and responsibility_id = to_number(l_context(4).a_val)

Line 1840: and session_id = icx_sec.g_session_id

1836: into l_transaction_context_id
1837: from fnd_log_transaction_context
1838: where transaction_type = 'ICX'
1839: and transaction_id = icx_sec.g_transaction_id
1840: and session_id = icx_sec.g_session_id
1841: and user_id = to_number(l_context(2).a_val)
1842: and resp_appl_id = to_number(l_context(3).a_val)
1843: and responsibility_id = to_number(l_context(4).a_val)
1844: and security_group_id = to_number(l_context(5).a_val)

Line 1857: where transaction_id = icx_sec.g_transaction_id;

1853: begin
1854: select function_id
1855: into l_component_id
1856: from icx_transactions
1857: where transaction_id = icx_sec.g_transaction_id;
1858: exception
1859: when others then
1860: l_component_id := null;
1861: end;

Line 1872: and session_id = icx_sec.g_session_id

1868: select transaction_context_id
1869: into l_transaction_context_id
1870: from fnd_log_transaction_context
1871: where transaction_type = 'ICX'
1872: and session_id = icx_sec.g_session_id
1873: and transaction_id = -1
1874: and user_id = to_number(l_context(2).a_val)
1875: and resp_appl_id = to_number(l_context(3).a_val)
1876: and responsibility_id = to_number(l_context(4).a_val)

Line 1890: where session_id = icx_sec.g_session_id;

1886: begin
1887: select function_id
1888: into l_component_id
1889: from icx_sessions
1890: where session_id = icx_sec.g_session_id;
1891: exception
1892: when others then
1893: l_component_id := null;
1894: end;

Line 1900: l_transaction_id := icx_sec.g_transaction_id;

1896: end;
1897: end if;
1898:
1899: l_transaction_type := 'ICX';
1900: l_transaction_id := icx_sec.g_transaction_id;
1901: l_component_appl_id := null;
1902: l_component_type := 'FUNCTION';
1903: end;
1904:

Line 1965: SESSION_ID_X := icx_sec.g_session_id;

1961: DATA_SIZE NUMBER;
1962:
1963: begin
1964: if(SESSION_ID is NULL) then
1965: SESSION_ID_X := icx_sec.g_session_id;
1966: else
1967: SESSION_ID_X := SESSION_ID;
1968: end if;
1969: