111: l_audit_project_id number;
112: l_sign_off_status varchar2(30);
113:
114: begin
115: x_return_status := fnd_api.g_ret_sts_success;
116:
117: select entity_name,pk1_value,pk2_value,pk3_value
118: into l_ename, l_pk1, l_pk2, l_pk3
119: from eng_change_subjects
187: commit;
188:
189: EXCEPTION
190: WHEN OTHERS THEN
191: x_return_status := fnd_api.g_ret_sts_unexp_error;
192: -- Standard call to get message count and if count=1, get the message
193: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
194: p_count => x_msg_count,
195: p_data => x_msg_data);
189: EXCEPTION
190: WHEN OTHERS THEN
191: x_return_status := fnd_api.g_ret_sts_unexp_error;
192: -- Standard call to get message count and if count=1, get the message
193: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
194: p_count => x_msg_count,
195: p_data => x_msg_data);
196: end UPDATE_APPROVAL_STATUS;
197: