APPS.FND_SESSION_MANAGEMENT dependencies on ICX_TRANSACTIONS

Line 89: select 'Y' into x_transaction_id from icx_transactions

85: l_transaction_id := fnd_crypto.SmallRandomNumber;
86:
87: loop
88:
89: select 'Y' into x_transaction_id from icx_transactions
90: where transaction_id = l_transaction_id;
91:
92: if x_transaction_id = 'Y'
93: then

Line 120: select 'Y' into x_transaction_id from icx_transactions

116: l_transaction_id := fnd_crypto.SmallRandomNumber;
117:
118: loop
119:
120: select 'Y' into x_transaction_id from icx_transactions
121: where transaction_id = l_transaction_id
122: and SESSION_ID = p_session_id
123: and DISABLED_FLAG <> 'Y';
124:

Line 151: select 'Y' into x_XTID from icx_transactions

147: l_XTID := fnd_crypto.encode(fnd_crypto.RandomBytes(18),fnd_crypto.ENCODE_URL);
148:
149: loop
150:
151: select 'Y' into x_XTID from icx_transactions
152: where XTID = l_XTID;
153:
154: if x_XTID = 'Y'
155: then

Line 920: insert into icx_transactions (

916:
917: l_transaction_id := NewTransactionId(p_session_id);
918: l_XTID := NewXTID;
919:
920: insert into icx_transactions (
921: TRANSACTION_ID,
922: SESSION_ID,
923: RESPONSIBILITY_APPLICATION_ID,
924: RESPONSIBILITY_ID,

Line 967: update ICX_TRANSACTIONS

963: procedure removeTransaction(p_transaction_id in number) is
964:
965: begin
966:
967: update ICX_TRANSACTIONS
968: set DISABLED_FLAG = 'Y'
969: where TRANSACTION_ID = p_transaction_id;
970:
971: end removeTransaction;

Line 1159: from ICX_TRANSACTIONS

1155: fnd_session_management.g_menu_id,
1156: fnd_session_management.g_function_id,
1157: fnd_session_management.g_function_type,
1158: fnd_session_management.g_page_id
1159: from ICX_TRANSACTIONS
1160: where TRANSACTION_ID = p_transaction_id
1161: and SESSION_ID = p_session_id
1162: and DISABLED_FLAG <> 'Y';
1163:

Line 1901: update ICX_TRANSACTIONS

1897:
1898: if p_transaction_id is not null
1899: then
1900:
1901: update ICX_TRANSACTIONS
1902: set RESPONSIBILITY_APPLICATION_ID = p_application_id,
1903: RESPONSIBILITY_ID = p_responsibility_id,
1904: SECURITY_GROUP_ID = p_security_group_id,
1905: FUNCTION_ID = l_function_id,