DBA Data[Home] [Help]

APPS.POS_ANON_PKG dependencies on ICX_TRANSACTIONS

Line 49: FROM icx_transactions

45: BEGIN
46:
47: SELECT max(transaction_id)
48: INTO x_transaction_id
49: FROM icx_transactions
50: WHERE session_id = icx_sec.g_session_id
51: AND responsibility_id = icx_sec.g_responsibility_id
52: AND security_group_id = icx_sec.g_security_group_id
53: AND function_id = icx_sec.g_function_id

Line 59: SELECT icx_transactions_s.nextval

55:
56: EXCEPTION
57: WHEN NO_DATA_FOUND THEN
58:
59: SELECT icx_transactions_s.nextval
60: INTO x_transaction_id
61: FROM dual;
62:
63: END;