66:
67: PROCEDURE Update_Transaction(p_transaction_Id in number) IS
68: sqlstmt VARCHAR2(2000);
69: BEGIN
70: sqlStmt := 'update ies_transactions set status = null where transaction_id = :id';
71: execute immediate sqlStmt using p_transaction_id;
72: END;
73:
74: PROCEDURE Update_Transaction(p_transaction_Id in number,
77: p_user_id IN NUMBER) IS
78: sqlstmt VARCHAR2(2000);
79: BEGIN
80: delete_Old_Data(p_transaction_Id);
81: sqlStmt := 'update ies_transactions set status = :1,
82: restart_data = :2,
83: last_update_date = sysdate,
84: end_time = sysdate,
85: last_updated_by = :3 where transaction_id = :id';
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;