DBA Data[Home] [Help]

APPS.IES_TRANSACTION_UTIL_PKG dependencies on DUAL

Line 94: SELECT ies_transactions_s.nextval INTO transactionId FROM dual;

90: p_dscript_Id IN NUMBER) RETURN NUMBER IS
91: transactionId NUMBER;
92: sqlstmt VARCHAR2(2000);
93: BEGIN
94: SELECT ies_transactions_s.nextval INTO transactionId FROM dual;
95:
96: sqlstmt := 'insert into ies_transactions(transaction_id, created_by, creation_date, agent_id, dscript_id, start_time)
97: values(:1, :2, sysdate, :3, :4, sysdate)';
98: execute immediate sqlstmt using transactionId, p_user_id, p_user_id, p_dscript_id;