[Home] [Help]
766: is
767: CURSOR c_resp_var_csr (p_msg_handle number,
768: p_node_handle number) IS
769: select variable_name, value, data_type, detail_max_len
770: from alr_response_variable_values
771: where message_handle = p_msg_handle and
772: node_handle = p_node_handle;
773: i number;
774: begin
882: begin
883: i := 1;
884: if (alr_init_resp_tbl.COUNT > 0) then
885: for i IN 1..alr_init_resp_tbl.LAST LOOP
886: insert into alr_response_variable_values(application_id, alert_id,
887: response_set_id, message_handle, node_handle, variable_name,
888: value, data_type, detail_max_len)
889: select alr_msg_dtls_tbl(1).app_id,
890: alr_msg_dtls_tbl(1).alert_id,
895: alr_init_resp_tbl(i).default_value,
896: alr_init_resp_tbl(i).data_type,
897: alr_init_resp_tbl(i).max_len
898: from dual where not exists
899: (select null from alr_response_variable_values
900: where message_handle=msg_handle and
901: node_handle=node_handle and
902: variable_name=alr_init_resp_tbl(i).name);
903: END LOOP;
927: -- Loop through the alr_init_resp_tbl to find the
928: -- variable name that matches what the user entered in the body.
929: FOR t_counter IN 1..alr_init_resp_tbl.LAST loop
930: if (alr_init_resp_tbl(t_counter).name = variable_name) then
931: insert into alr_response_variable_values(application_id, alert_id,
932: response_set_id, message_handle, node_handle, variable_name,
933: value, data_type, detail_max_len)
934: select alr_msg_dtls_tbl(1).app_id,
935: alr_msg_dtls_tbl(1).alert_id,
940: value,
941: alr_init_resp_tbl(t_counter).data_type,
942: alr_init_resp_tbl(t_counter).max_len
943: from dual where not exists
944: (select null from alr_response_variable_values
945: where message_handle=msg_handle and
946: node_handle=node_handle and
947: variable_name=variable_name);
948: end if;