DBA Data[Home] [Help]

APPS.ALR_MLR_PACKAGE dependencies on ALR_ACTUAL_RESPONSES

Line 552: from alr_actual_responses

548: count_var number;
549: begin
550: select count(*)
551: into count_var
552: from alr_actual_responses
553: where open_closed = 'O';
554:
555: return (count_var);
556:

Line 575: from alr_actual_responses

571: into alr_msg_dtls_tbl(1).app_id,
572: alr_msg_dtls_tbl(1).alert_id,
573: alr_msg_dtls_tbl(1).response_set_id,
574: alr_msg_dtls_tbl(1).open_closed
575: from alr_actual_responses
576: where message_handle=msg_handle and
577: node_handle= node_handle;
578:
579: exception

Line 995: update alr_actual_responses

991: open_closed in varchar2,
992: action_set_pass_fail in varchar2)
993: is
994: begin
995: update alr_actual_responses
996: set response_id=alr_init_valid_resp_tbl(1).resp_id,
997: open_closed= open_closed, action_set_pass_fail=action_set_pass_fail
998: where message_handle = msg_handle and node_handle=node_handle;
999: