DBA Data[Home] [Help]

APPS.ICX_SEC dependencies on ICX_TRANSACTIONS_S

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