diff options
author | Christian Grothoff <christian@grothoff.org> | 2023-02-14 14:26:00 +0100 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2023-02-14 14:26:00 +0100 |
commit | afe3f70d336e151598e02ebedb6498e13122530e (patch) | |
tree | 16b28b9fec850465e963dd1eb2acee796d86d9f2 /src/exchangedb/exchange_do_insert_aml_decision.sql | |
parent | 437e6ec86a1cd3a391de437999ad21ac5e256e68 (diff) | |
download | exchange-afe3f70d336e151598e02ebedb6498e13122530e.tar.xz |
begin API change to allow AML officers to trigger KYC process
Diffstat (limited to 'src/exchangedb/exchange_do_insert_aml_decision.sql')
-rw-r--r-- | src/exchangedb/exchange_do_insert_aml_decision.sql | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/src/exchangedb/exchange_do_insert_aml_decision.sql b/src/exchangedb/exchange_do_insert_aml_decision.sql index 0009ecb40..8e22c57f8 100644 --- a/src/exchangedb/exchange_do_insert_aml_decision.sql +++ b/src/exchangedb/exchange_do_insert_aml_decision.sql @@ -24,6 +24,7 @@ CREATE OR REPLACE FUNCTION exchange_do_insert_aml_decision( IN in_decider_pub BYTEA, IN in_decider_sig BYTEA, IN in_notify_s VARCHAR, + IN in_kyc_requirements VARCHAR, OUT out_invalid_officer BOOLEAN, OUT out_last_date INT8) LANGUAGE plpgsql @@ -84,6 +85,7 @@ INSERT INTO exchange.aml_history ,new_status ,decision_time ,justification + ,kyc_requirements ,decider_pub ,decider_sig ) VALUES @@ -93,6 +95,7 @@ INSERT INTO exchange.aml_history ,in_new_status ,in_decision_time ,in_justification + ,in_kyc_requirements ,in_decider_pub ,in_decider_sig); @@ -105,7 +108,7 @@ THEN ,trigger_type) VALUES (in_h_payto,1); - + EXECUTE FORMAT ( 'NOTIFY %s' ,in_notify_s); @@ -116,5 +119,5 @@ END IF; END $$; -COMMENT ON FUNCTION exchange_do_insert_aml_decision(BYTEA, INT8, INT4, INT4, INT8, VARCHAR, BYTEA, BYTEA, VARCHAR) +COMMENT ON FUNCTION exchange_do_insert_aml_decision(BYTEA, INT8, INT4, INT4, INT8, VARCHAR, BYTEA, BYTEA, VARCHAR, VARCHAR) IS 'Checks whether the AML officer is eligible to make AML decisions and if so inserts the decision into the table'; |