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 572: from fnd_log_transaction_context

568: --8609702
569: begin
570: select transaction_type
571: into l_transaction_type
572: from fnd_log_transaction_context
573: where transaction_context_id = l_txn_id;
574:
575: if (l_transaction_type = 'UNKNOWN') then
576: return false;

Line 1729: from fnd_log_transaction_context

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

Line 1752: from fnd_log_transaction_context

1748: -- see if a transaction context exists for this request
1749: begin
1750: select transaction_context_id
1751: into l_transaction_context_id
1752: from fnd_log_transaction_context
1753: where transaction_type = 'REQUEST'
1754: and transaction_id = conc_request_id;
1755:
1756: return l_transaction_context_id;

Line 1785: from fnd_log_transaction_context

1781: -- see if a transaction context exists for this form
1782: begin
1783: select transaction_context_id
1784: into l_transaction_context_id
1785: from fnd_log_transaction_context
1786: where transaction_type = 'FORM'
1787: and transaction_id = l_transaction_id;
1788:
1789: return l_transaction_context_id;

Line 1808: from fnd_log_transaction_context

1804: -- see if a transaction context exists for this instance
1805: begin
1806: select transaction_context_id
1807: into l_transaction_context_id
1808: from fnd_log_transaction_context
1809: where transaction_type = 'SOA_INSTANCE'
1810: and transaction_id = soa_instance_id;
1811:
1812: return l_transaction_context_id;

Line 1837: from fnd_log_transaction_context

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

Line 1870: from fnd_log_transaction_context

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

Line 1911: from fnd_log_transaction_context

1907:
1908: begin
1909: select transaction_context_id
1910: into l_transaction_context_id
1911: from fnd_log_transaction_context
1912: where transaction_type = 'UNKNOWN'
1913: and session_id = -1
1914: and transaction_id = -1
1915: and user_id = to_number(l_context(2).a_val)

Line 2314: from fnd_log_transaction_context

2310: --
2311: -- Check if child context already exists
2312: --
2313: select transaction_context_id into G_PRX_CHILD_TRANS_CONTEXT_ID
2314: from fnd_log_transaction_context
2315: where transaction_id = p_transaction_id
2316: and transaction_type = p_transaction_type
2317: and parent_context_id = p_parent_context_id;
2318: exception

Line 2339: -- row for child context in fnd_log_transaction_context

2335: end if;
2336:
2337: --
2338: -- Here, call init_transaction_internal to create a new
2339: -- row for child context in fnd_log_transaction_context
2340: --
2341: init_transaction_internal(
2342: p_transaction_type => p_transaction_type,
2343: p_transaction_id => p_transaction_id,