APPS.ICX_SEC dependencies on ICX_TRANSACTIONS

Line 842: -- select icx_transactions_s.nextval

838:
839: l_transaction_id number;
840:
841: begin
842: -- select icx_transactions_s.nextval
843: -- into l_transaction_id
844: -- from sys.dual;
845: -- icx_transactions_s.nextval moved directly into insert statment for performance bug# 2494109 --mputman
846:

Line 845: -- icx_transactions_s.nextval moved directly into insert statment for performance bug# 2494109 --mputman

841: begin
842: -- select icx_transactions_s.nextval
843: -- into l_transaction_id
844: -- from sys.dual;
845: -- icx_transactions_s.nextval moved directly into insert statment for performance bug# 2494109 --mputman
846:
847: insert into icx_transactions (
848: TRANSACTION_ID,
849: SESSION_ID,

Line 847: insert into icx_transactions (

843: -- into l_transaction_id
844: -- from sys.dual;
845: -- icx_transactions_s.nextval moved directly into insert statment for performance bug# 2494109 --mputman
846:
847: insert into icx_transactions (
848: TRANSACTION_ID,
849: SESSION_ID,
850: RESPONSIBILITY_APPLICATION_ID,
851: RESPONSIBILITY_ID,

Line 864: icx_transactions_s.nextval,

860: CREATION_DATE,
861: LAST_UPDATED_BY,
862: LAST_UPDATE_DATE)
863: values (
864: icx_transactions_s.nextval,
865: p_session_id,
866: p_resp_appl_id,
867: p_responsibility_id,
868: p_security_group_id,

Line 955: update ICX_TRANSACTIONS

951: procedure removeTransaction(p_transaction_id in number) is
952:
953: begin
954:
955: update ICX_TRANSACTIONS
956: set DISABLED_FLAG = 'Y'
957: where TRANSACTION_ID = p_transaction_id;
958:
959: exception

Line 1594: from ICX_TRANSACTIONS

1590: icx_sec.g_menu_id,
1591: icx_sec.g_function_id,
1592: icx_sec.g_function_type,
1593: icx_sec.g_page_id
1594: from ICX_TRANSACTIONS
1595: where TRANSACTION_ID = c_transaction_id
1596: and SESSION_ID = icx_sec.g_session_id
1597: and DISABLED_FLAG <> 'Y'; --reordered select for bug #2389169 mputman
1598:

Line 3758: update ICX_TRANSACTIONS

3754:
3755: if p_transaction_id is not null
3756: then
3757:
3758: update ICX_TRANSACTIONS
3759: set RESPONSIBILITY_APPLICATION_ID = p_application_id,
3760: RESPONSIBILITY_ID = p_responsibility_id,
3761: SECURITY_GROUP_ID = p_security_group_id,
3762: FUNCTION_ID = l_function_id,