APPS.FND_SESSION_MANAGEMENT dependencies on ICX_TRANSACTIONS

Line 77: select 'Y' into x_transaction_id from icx_transactions

73: l_transaction_id := fnd_crypto.SmallRandomNumber;
74:
75: loop
76:
77: select 'Y' into x_transaction_id from icx_transactions
78: where transaction_id = l_transaction_id;
79:
80: if x_transaction_id = 'Y'
81: then

Line 108: select 'Y' into x_transaction_id from icx_transactions

104: l_transaction_id := fnd_crypto.SmallRandomNumber;
105:
106: loop
107:
108: select 'Y' into x_transaction_id from icx_transactions
109: where transaction_id = l_transaction_id
110: and SESSION_ID = p_session_id
111: and DISABLED_FLAG <> 'Y';
112:

Line 139: select 'Y' into x_XTID from icx_transactions

135: l_XTID := fnd_crypto.encode(fnd_crypto.RandomBytes(18),fnd_crypto.ENCODE_URL);
136:
137: loop
138:
139: select 'Y' into x_XTID from icx_transactions
140: where XTID = l_XTID;
141:
142: if x_XTID = 'Y'
143: then

Line 872: insert into icx_transactions (

868:
869: l_transaction_id := NewTransactionId(p_session_id);
870: l_XTID := NewXTID;
871:
872: insert into icx_transactions (
873: TRANSACTION_ID,
874: SESSION_ID,
875: RESPONSIBILITY_APPLICATION_ID,
876: RESPONSIBILITY_ID,

Line 919: update ICX_TRANSACTIONS

915: procedure removeTransaction(p_transaction_id in number) is
916:
917: begin
918:
919: update ICX_TRANSACTIONS
920: set DISABLED_FLAG = 'Y'
921: where TRANSACTION_ID = p_transaction_id;
922:
923: end removeTransaction;

Line 1111: from ICX_TRANSACTIONS

1107: fnd_session_management.g_menu_id,
1108: fnd_session_management.g_function_id,
1109: fnd_session_management.g_function_type,
1110: fnd_session_management.g_page_id
1111: from ICX_TRANSACTIONS
1112: where TRANSACTION_ID = p_transaction_id
1113: and SESSION_ID = p_session_id
1114: and DISABLED_FLAG <> 'Y';
1115:

Line 1853: update ICX_TRANSACTIONS

1849:
1850: if p_transaction_id is not null
1851: then
1852:
1853: update ICX_TRANSACTIONS
1854: set RESPONSIBILITY_APPLICATION_ID = p_application_id,
1855: RESPONSIBILITY_ID = p_responsibility_id,
1856: SECURITY_GROUP_ID = p_security_group_id,
1857: FUNCTION_ID = l_function_id,