APPS.FND_LOG_REPOSITORY dependencies on FND_LOG_TRANSACTION_CONTEXT

Line 218: insert into FND_LOG_TRANSACTION_CONTEXT

214: P_PARENT_CONTEXT_ID IN NUMBER DEFAULT NULL) is
215: pragma AUTONOMOUS_TRANSACTION;
216: l_transaction_context_id number;
217: begin
218: insert into FND_LOG_TRANSACTION_CONTEXT
219: (TRANSACTION_CONTEXT_ID,
220: SESSION_ID,
221: TRANSACTION_TYPE,
222: TRANSACTION_ID,

Line 1705: from fnd_log_transaction_context

1701: -- see if a transaction context exists for this process
1702: begin
1703: select transaction_context_id
1704: into l_transaction_context_id
1705: from fnd_log_transaction_context
1706: where transaction_type = 'SERVICE'
1707: and transaction_id = concurrent_process_id;
1708:
1709: return l_transaction_context_id;

Line 1728: from fnd_log_transaction_context

1724: -- see if a transaction context exists for this request
1725: begin
1726: select transaction_context_id
1727: into l_transaction_context_id
1728: from fnd_log_transaction_context
1729: where transaction_type = 'REQUEST'
1730: and transaction_id = conc_request_id;
1731:
1732: return l_transaction_context_id;

Line 1761: from fnd_log_transaction_context

1757: -- see if a transaction context exists for this form
1758: begin
1759: select transaction_context_id
1760: into l_transaction_context_id
1761: from fnd_log_transaction_context
1762: where transaction_type = 'FORM'
1763: and transaction_id = l_transaction_id;
1764:
1765: return l_transaction_context_id;

Line 1788: from fnd_log_transaction_context

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
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)

Line 1821: from fnd_log_transaction_context

1817: -- Check for coarser ICX Session
1818: begin
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)

Line 1862: from fnd_log_transaction_context

1858:
1859: begin
1860: select transaction_context_id
1861: into l_transaction_context_id
1862: from fnd_log_transaction_context
1863: where transaction_type = 'UNKNOWN'
1864: and session_id = -1
1865: and transaction_id = -1
1866: and user_id = to_number(l_context(2).a_val)

Line 2265: from fnd_log_transaction_context

2261: --
2262: -- Check if child context already exists
2263: --
2264: select transaction_context_id into G_PRX_CHILD_TRANS_CONTEXT_ID
2265: from fnd_log_transaction_context
2266: where transaction_id = p_transaction_id
2267: and transaction_type = p_transaction_type
2268: and parent_context_id = p_parent_context_id;
2269: exception

Line 2290: -- row for child context in fnd_log_transaction_context

2286: end if;
2287:
2288: --
2289: -- Here, call init_transaction_internal to create a new
2290: -- row for child context in fnd_log_transaction_context
2291: --
2292: init_transaction_internal(
2293: p_transaction_type => p_transaction_type,
2294: p_transaction_id => p_transaction_id,