125: CURSOR c_opinion_rec (c_opinion_log_id NUMBER) IS
126: SELECT opinion_id, object_name, audit_result_code,
127: pk1_value, pk2_value, pk3_value, pk4_value, pk5_value,
128: pk6_value, pk7_value, pk8_value
129: FROM amw_opinions_log_v
130: WHERE opinion_log_id = c_opinion_log_id;
131:
132: CURSOR c_prev_opinion_rec (c_opinion_id NUMBER, c_opinion_log_id NUMBER) IS
133: SELECT audit_result_code
130: WHERE opinion_log_id = c_opinion_log_id;
131:
132: CURSOR c_prev_opinion_rec (c_opinion_id NUMBER, c_opinion_log_id NUMBER) IS
133: SELECT audit_result_code
134: FROM amw_opinions_log_v
135: WHERE opinion_log_id = (SELECT max(opinion_log_id)
136: FROM amw_opinions_log_v
137: WHERE opinion_id = c_opinion_id
138: AND opinion_log_id < c_opinion_log_id);
132: CURSOR c_prev_opinion_rec (c_opinion_id NUMBER, c_opinion_log_id NUMBER) IS
133: SELECT audit_result_code
134: FROM amw_opinions_log_v
135: WHERE opinion_log_id = (SELECT max(opinion_log_id)
136: FROM amw_opinions_log_v
137: WHERE opinion_id = c_opinion_id
138: AND opinion_log_id < c_opinion_log_id);
139:
140: l_opin_log_id NUMBER;